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

768 rows where county = "St. John", fips = 78020 and state = "Virgin Islands" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Virgin Islands · 768 ✖

fips 1

  • 78020 · 768 ✖

county 1

  • St. John · 768 ✖
Link rowid date ▲ county state fips cases deaths
2502508 2502508 2022-05-13 St. John Virgin Islands 78020 832 5
2499250 2499250 2022-05-12 St. John Virgin Islands 78020 830 5
2495992 2495992 2022-05-11 St. John Virgin Islands 78020 813 5
2492734 2492734 2022-05-10 St. John Virgin Islands 78020 812 5
2489476 2489476 2022-05-09 St. John Virgin Islands 78020 812 5
2486218 2486218 2022-05-08 St. John Virgin Islands 78020 811 5
2482960 2482960 2022-05-07 St. John Virgin Islands 78020 811 5
2479702 2479702 2022-05-06 St. John Virgin Islands 78020 811 5
2476444 2476444 2022-05-05 St. John Virgin Islands 78020 804 5
2473187 2473187 2022-05-04 St. John Virgin Islands 78020 797 5
2469931 2469931 2022-05-03 St. John Virgin Islands 78020 797 5
2466675 2466675 2022-05-02 St. John Virgin Islands 78020 797 5
2463420 2463420 2022-05-01 St. John Virgin Islands 78020 794 5
2460164 2460164 2022-04-30 St. John Virgin Islands 78020 794 5
2456908 2456908 2022-04-29 St. John Virgin Islands 78020 794 5
2453652 2453652 2022-04-28 St. John Virgin Islands 78020 794 5
2450396 2450396 2022-04-27 St. John Virgin Islands 78020 792 5
2447139 2447139 2022-04-26 St. John Virgin Islands 78020 791 5
2443884 2443884 2022-04-25 St. John Virgin Islands 78020 791 5
2440628 2440628 2022-04-24 St. John Virgin Islands 78020 791 5
2437372 2437372 2022-04-23 St. John Virgin Islands 78020 791 5
2434116 2434116 2022-04-22 St. John Virgin Islands 78020 791 5
2430860 2430860 2022-04-21 St. John Virgin Islands 78020 791 5
2427604 2427604 2022-04-20 St. John Virgin Islands 78020 790 5
2424348 2424348 2022-04-19 St. John Virgin Islands 78020 790 5
2421092 2421092 2022-04-18 St. John Virgin Islands 78020 789 5
2417836 2417836 2022-04-17 St. John Virgin Islands 78020 789 5
2414580 2414580 2022-04-16 St. John Virgin Islands 78020 789 5
2411324 2411324 2022-04-15 St. John Virgin Islands 78020 789 5
2408068 2408068 2022-04-14 St. John Virgin Islands 78020 789 5
2404812 2404812 2022-04-13 St. John Virgin Islands 78020 786 5
2401557 2401557 2022-04-12 St. John Virgin Islands 78020 786 5
2398302 2398302 2022-04-11 St. John Virgin Islands 78020 786 5
2395047 2395047 2022-04-10 St. John Virgin Islands 78020 786 5
2391791 2391791 2022-04-09 St. John Virgin Islands 78020 786 5
2388535 2388535 2022-04-08 St. John Virgin Islands 78020 786 5
2385280 2385280 2022-04-07 St. John Virgin Islands 78020 783 5
2382025 2382025 2022-04-06 St. John Virgin Islands 78020 782 5
2378770 2378770 2022-04-05 St. John Virgin Islands 78020 782 5
2375516 2375516 2022-04-04 St. John Virgin Islands 78020 781 5
2372264 2372264 2022-04-03 St. John Virgin Islands 78020 781 5
2369011 2369011 2022-04-02 St. John Virgin Islands 78020 781 5
2365758 2365758 2022-04-01 St. John Virgin Islands 78020 781 5
2362505 2362505 2022-03-31 St. John Virgin Islands 78020 774 5
2359251 2359251 2022-03-30 St. John Virgin Islands 78020 774 5
2355997 2355997 2022-03-29 St. John Virgin Islands 78020 774 5
2352744 2352744 2022-03-28 St. John Virgin Islands 78020 774 5
2349492 2349492 2022-03-27 St. John Virgin Islands 78020 774 5
2346239 2346239 2022-03-26 St. John Virgin Islands 78020 774 5
2342986 2342986 2022-03-25 St. John Virgin Islands 78020 774 5
2339733 2339733 2022-03-24 St. John Virgin Islands 78020 774 5
2336479 2336479 2022-03-23 St. John Virgin Islands 78020 774 5
2333225 2333225 2022-03-22 St. John Virgin Islands 78020 774 5
2329972 2329972 2022-03-21 St. John Virgin Islands 78020 774 5
2326720 2326720 2022-03-20 St. John Virgin Islands 78020 774 5
2323467 2323467 2022-03-19 St. John Virgin Islands 78020 774 5
2320213 2320213 2022-03-18 St. John Virgin Islands 78020 774 5
2316959 2316959 2022-03-17 St. John Virgin Islands 78020 773 5
2313706 2313706 2022-03-16 St. John Virgin Islands 78020 773 5
2310453 2310453 2022-03-15 St. John Virgin Islands 78020 773 5
2307200 2307200 2022-03-14 St. John Virgin Islands 78020 771 5
2303949 2303949 2022-03-13 St. John Virgin Islands 78020 771 5
2300697 2300697 2022-03-12 St. John Virgin Islands 78020 771 5
2297445 2297445 2022-03-11 St. John Virgin Islands 78020 771 5
2294193 2294193 2022-03-10 St. John Virgin Islands 78020 754 5
2290941 2290941 2022-03-09 St. John Virgin Islands 78020 753 5
2287689 2287689 2022-03-08 St. John Virgin Islands 78020 753 5
2284437 2284437 2022-03-07 St. John Virgin Islands 78020 753 5
2281185 2281185 2022-03-06 St. John Virgin Islands 78020 753 5
2277932 2277932 2022-03-05 St. John Virgin Islands 78020 753 5
2274679 2274679 2022-03-04 St. John Virgin Islands 78020 753 5
2271426 2271426 2022-03-03 St. John Virgin Islands 78020 753 5
2268174 2268174 2022-03-02 St. John Virgin Islands 78020 753 5
2264921 2264921 2022-03-01 St. John Virgin Islands 78020 753 5
2261671 2261671 2022-02-28 St. John Virgin Islands 78020 753 5
2258420 2258420 2022-02-27 St. John Virgin Islands 78020 753 5
2255169 2255169 2022-02-26 St. John Virgin Islands 78020 753 5
2251918 2251918 2022-02-25 St. John Virgin Islands 78020 753 5
2248667 2248667 2022-02-24 St. John Virgin Islands 78020 753 5
2245416 2245416 2022-02-23 St. John Virgin Islands 78020 749 5
2242165 2242165 2022-02-22 St. John Virgin Islands 78020 749 5
2238914 2238914 2022-02-21 St. John Virgin Islands 78020 749 5
2235663 2235663 2022-02-20 St. John Virgin Islands 78020 749 5
2232412 2232412 2022-02-19 St. John Virgin Islands 78020 749 5
2229161 2229161 2022-02-18 St. John Virgin Islands 78020 749 5
2225910 2225910 2022-02-17 St. John Virgin Islands 78020 749 5
2222659 2222659 2022-02-16 St. John Virgin Islands 78020 749 5
2219408 2219408 2022-02-15 St. John Virgin Islands 78020 749 5
2216157 2216157 2022-02-14 St. John Virgin Islands 78020 749 5
2212906 2212906 2022-02-13 St. John Virgin Islands 78020 749 5
2209653 2209653 2022-02-12 St. John Virgin Islands 78020 749 5
2206400 2206400 2022-02-11 St. John Virgin Islands 78020 749 5
2203147 2203147 2022-02-10 St. John Virgin Islands 78020 749 5
2199893 2199893 2022-02-09 St. John Virgin Islands 78020 749 5
2196639 2196639 2022-02-08 St. John Virgin Islands 78020 749 5
2193385 2193385 2022-02-07 St. John Virgin Islands 78020 743 5
2190132 2190132 2022-02-06 St. John Virgin Islands 78020 743 5
2186879 2186879 2022-02-05 St. John Virgin Islands 78020 743 5
2183626 2183626 2022-02-04 St. John Virgin Islands 78020 743 5
2180374 2180374 2022-02-03 St. John Virgin Islands 78020 742 5

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);