ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

2,492 rows where state = "Virgin Islands" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 4

county 4

state 1

  • Virgin Islands · 2,492 ✖
Link rowid date ▲ county state fips cases deaths
2502507 2502507 2022-05-13 St. Croix Virgin Islands 78010 8562 49
2502508 2502508 2022-05-13 St. John Virgin Islands 78020 832 5
2502509 2502509 2022-05-13 St. Thomas Virgin Islands 78030 8643 59
2499249 2499249 2022-05-12 St. Croix Virgin Islands 78010 8473 49
2499250 2499250 2022-05-12 St. John Virgin Islands 78020 830 5
2499251 2499251 2022-05-12 St. Thomas Virgin Islands 78030 8532 59
2495991 2495991 2022-05-11 St. Croix Virgin Islands 78010 8390 49
2495992 2495992 2022-05-11 St. John Virgin Islands 78020 813 5
2495993 2495993 2022-05-11 St. Thomas Virgin Islands 78030 8469 59
2492733 2492733 2022-05-10 St. Croix Virgin Islands 78010 8269 49
2492734 2492734 2022-05-10 St. John Virgin Islands 78020 812 5
2492735 2492735 2022-05-10 St. Thomas Virgin Islands 78030 8272 59
2489475 2489475 2022-05-09 St. Croix Virgin Islands 78010 8269 49
2489476 2489476 2022-05-09 St. John Virgin Islands 78020 812 5
2489477 2489477 2022-05-09 St. Thomas Virgin Islands 78030 8272 59
2486217 2486217 2022-05-08 St. Croix Virgin Islands 78010 8232 49
2486218 2486218 2022-05-08 St. John Virgin Islands 78020 811 5
2486219 2486219 2022-05-08 St. Thomas Virgin Islands 78030 8123 59
2486220 2486220 2022-05-08 Unknown Virgin Islands   1 0
2482959 2482959 2022-05-07 St. Croix Virgin Islands 78010 8232 49
2482960 2482960 2022-05-07 St. John Virgin Islands 78020 811 5
2482961 2482961 2022-05-07 St. Thomas Virgin Islands 78030 8123 59
2482962 2482962 2022-05-07 Unknown Virgin Islands   1 0
2479701 2479701 2022-05-06 St. Croix Virgin Islands 78010 8232 49
2479702 2479702 2022-05-06 St. John Virgin Islands 78020 811 5
2479703 2479703 2022-05-06 St. Thomas Virgin Islands 78030 8123 59
2479704 2479704 2022-05-06 Unknown Virgin Islands   1 0
2476443 2476443 2022-05-05 St. Croix Virgin Islands 78010 8220 49
2476444 2476444 2022-05-05 St. John Virgin Islands 78020 804 5
2476445 2476445 2022-05-05 St. Thomas Virgin Islands 78030 7987 59
2476446 2476446 2022-05-05 Unknown Virgin Islands   1 0
2473186 2473186 2022-05-04 St. Croix Virgin Islands 78010 8114 47
2473187 2473187 2022-05-04 St. John Virgin Islands 78020 797 5
2473188 2473188 2022-05-04 St. Thomas Virgin Islands 78030 7570 59
2469930 2469930 2022-05-03 St. Croix Virgin Islands 78010 8096 47
2469931 2469931 2022-05-03 St. John Virgin Islands 78020 797 5
2469932 2469932 2022-05-03 St. Thomas Virgin Islands 78030 7498 59
2466674 2466674 2022-05-02 St. Croix Virgin Islands 78010 8096 47
2466675 2466675 2022-05-02 St. John Virgin Islands 78020 797 5
2466676 2466676 2022-05-02 St. Thomas Virgin Islands 78030 7498 59
2463419 2463419 2022-05-01 St. Croix Virgin Islands 78010 8055 47
2463420 2463420 2022-05-01 St. John Virgin Islands 78020 794 5
2463421 2463421 2022-05-01 St. Thomas Virgin Islands 78030 7457 59
2460163 2460163 2022-04-30 St. Croix Virgin Islands 78010 8055 47
2460164 2460164 2022-04-30 St. John Virgin Islands 78020 794 5
2460165 2460165 2022-04-30 St. Thomas Virgin Islands 78030 7457 59
2456907 2456907 2022-04-29 St. Croix Virgin Islands 78010 8055 47
2456908 2456908 2022-04-29 St. John Virgin Islands 78020 794 5
2456909 2456909 2022-04-29 St. Thomas Virgin Islands 78030 7457 59
2453651 2453651 2022-04-28 St. Croix Virgin Islands 78010 8055 47
2453652 2453652 2022-04-28 St. John Virgin Islands 78020 794 5
2453653 2453653 2022-04-28 St. Thomas Virgin Islands 78030 7457 59
2450395 2450395 2022-04-27 St. Croix Virgin Islands 78010 8024 47
2450396 2450396 2022-04-27 St. John Virgin Islands 78020 792 5
2450397 2450397 2022-04-27 St. Thomas Virgin Islands 78030 7444 59
2447138 2447138 2022-04-26 St. Croix Virgin Islands 78010 7968 47
2447139 2447139 2022-04-26 St. John Virgin Islands 78020 791 5
2447140 2447140 2022-04-26 St. Thomas Virgin Islands 78030 7395 59
2443883 2443883 2022-04-25 St. Croix Virgin Islands 78010 7968 47
2443884 2443884 2022-04-25 St. John Virgin Islands 78020 791 5
2443885 2443885 2022-04-25 St. Thomas Virgin Islands 78030 7395 59
2440627 2440627 2022-04-24 St. Croix Virgin Islands 78010 7923 47
2440628 2440628 2022-04-24 St. John Virgin Islands 78020 791 5
2440629 2440629 2022-04-24 St. Thomas Virgin Islands 78030 7377 59
2437371 2437371 2022-04-23 St. Croix Virgin Islands 78010 7923 47
2437372 2437372 2022-04-23 St. John Virgin Islands 78020 791 5
2437373 2437373 2022-04-23 St. Thomas Virgin Islands 78030 7377 59
2434115 2434115 2022-04-22 St. Croix Virgin Islands 78010 7923 47
2434116 2434116 2022-04-22 St. John Virgin Islands 78020 791 5
2434117 2434117 2022-04-22 St. Thomas Virgin Islands 78030 7377 59
2430859 2430859 2022-04-21 St. Croix Virgin Islands 78010 7898 47
2430860 2430860 2022-04-21 St. John Virgin Islands 78020 791 5
2430861 2430861 2022-04-21 St. Thomas Virgin Islands 78030 7341 59
2427603 2427603 2022-04-20 St. Croix Virgin Islands 78010 7845 47
2427604 2427604 2022-04-20 St. John Virgin Islands 78020 790 5
2427605 2427605 2022-04-20 St. Thomas Virgin Islands 78030 7293 59
2424347 2424347 2022-04-19 St. Croix Virgin Islands 78010 7845 47
2424348 2424348 2022-04-19 St. John Virgin Islands 78020 790 5
2424349 2424349 2022-04-19 St. Thomas Virgin Islands 78030 7293 59
2421091 2421091 2022-04-18 St. Croix Virgin Islands 78010 7823 47
2421092 2421092 2022-04-18 St. John Virgin Islands 78020 789 5
2421093 2421093 2022-04-18 St. Thomas Virgin Islands 78030 7270 59
2417835 2417835 2022-04-17 St. Croix Virgin Islands 78010 7816 47
2417836 2417836 2022-04-17 St. John Virgin Islands 78020 789 5
2417837 2417837 2022-04-17 St. Thomas Virgin Islands 78030 7267 59
2414579 2414579 2022-04-16 St. Croix Virgin Islands 78010 7816 47
2414580 2414580 2022-04-16 St. John Virgin Islands 78020 789 5
2414581 2414581 2022-04-16 St. Thomas Virgin Islands 78030 7267 59
2411323 2411323 2022-04-15 St. Croix Virgin Islands 78010 7816 47
2411324 2411324 2022-04-15 St. John Virgin Islands 78020 789 5
2411325 2411325 2022-04-15 St. Thomas Virgin Islands 78030 7267 59
2408067 2408067 2022-04-14 St. Croix Virgin Islands 78010 7816 47
2408068 2408068 2022-04-14 St. John Virgin Islands 78020 789 5
2408069 2408069 2022-04-14 St. Thomas Virgin Islands 78030 7267 59
2404811 2404811 2022-04-13 St. Croix Virgin Islands 78010 7798 47
2404812 2404812 2022-04-13 St. John Virgin Islands 78020 786 5
2404813 2404813 2022-04-13 St. Thomas Virgin Islands 78030 7252 59
2401556 2401556 2022-04-12 St. Croix Virgin Islands 78010 7785 47
2401557 2401557 2022-04-12 St. John Virgin Islands 78020 786 5
2401558 2401558 2022-04-12 St. Thomas Virgin Islands 78030 7230 59

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);