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 fips = 78010 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 78010 · 768 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502507 2502507 2022-05-13 St. Croix Virgin Islands 78010 8562 49
2499249 2499249 2022-05-12 St. Croix Virgin Islands 78010 8473 49
2495991 2495991 2022-05-11 St. Croix Virgin Islands 78010 8390 49
2492733 2492733 2022-05-10 St. Croix Virgin Islands 78010 8269 49
2489475 2489475 2022-05-09 St. Croix Virgin Islands 78010 8269 49
2486217 2486217 2022-05-08 St. Croix Virgin Islands 78010 8232 49
2482959 2482959 2022-05-07 St. Croix Virgin Islands 78010 8232 49
2479701 2479701 2022-05-06 St. Croix Virgin Islands 78010 8232 49
2476443 2476443 2022-05-05 St. Croix Virgin Islands 78010 8220 49
2473186 2473186 2022-05-04 St. Croix Virgin Islands 78010 8114 47
2469930 2469930 2022-05-03 St. Croix Virgin Islands 78010 8096 47
2466674 2466674 2022-05-02 St. Croix Virgin Islands 78010 8096 47
2463419 2463419 2022-05-01 St. Croix Virgin Islands 78010 8055 47
2460163 2460163 2022-04-30 St. Croix Virgin Islands 78010 8055 47
2456907 2456907 2022-04-29 St. Croix Virgin Islands 78010 8055 47
2453651 2453651 2022-04-28 St. Croix Virgin Islands 78010 8055 47
2450395 2450395 2022-04-27 St. Croix Virgin Islands 78010 8024 47
2447138 2447138 2022-04-26 St. Croix Virgin Islands 78010 7968 47
2443883 2443883 2022-04-25 St. Croix Virgin Islands 78010 7968 47
2440627 2440627 2022-04-24 St. Croix Virgin Islands 78010 7923 47
2437371 2437371 2022-04-23 St. Croix Virgin Islands 78010 7923 47
2434115 2434115 2022-04-22 St. Croix Virgin Islands 78010 7923 47
2430859 2430859 2022-04-21 St. Croix Virgin Islands 78010 7898 47
2427603 2427603 2022-04-20 St. Croix Virgin Islands 78010 7845 47
2424347 2424347 2022-04-19 St. Croix Virgin Islands 78010 7845 47
2421091 2421091 2022-04-18 St. Croix Virgin Islands 78010 7823 47
2417835 2417835 2022-04-17 St. Croix Virgin Islands 78010 7816 47
2414579 2414579 2022-04-16 St. Croix Virgin Islands 78010 7816 47
2411323 2411323 2022-04-15 St. Croix Virgin Islands 78010 7816 47
2408067 2408067 2022-04-14 St. Croix Virgin Islands 78010 7816 47
2404811 2404811 2022-04-13 St. Croix Virgin Islands 78010 7798 47
2401556 2401556 2022-04-12 St. Croix Virgin Islands 78010 7785 47
2398301 2398301 2022-04-11 St. Croix Virgin Islands 78010 7759 47
2395046 2395046 2022-04-10 St. Croix Virgin Islands 78010 7759 47
2391790 2391790 2022-04-09 St. Croix Virgin Islands 78010 7759 47
2388534 2388534 2022-04-08 St. Croix Virgin Islands 78010 7759 47
2385279 2385279 2022-04-07 St. Croix Virgin Islands 78010 7751 47
2382024 2382024 2022-04-06 St. Croix Virgin Islands 78010 7745 47
2378769 2378769 2022-04-05 St. Croix Virgin Islands 78010 7737 47
2375515 2375515 2022-04-04 St. Croix Virgin Islands 78010 7730 47
2372263 2372263 2022-04-03 St. Croix Virgin Islands 78010 7730 47
2369010 2369010 2022-04-02 St. Croix Virgin Islands 78010 7730 47
2365757 2365757 2022-04-01 St. Croix Virgin Islands 78010 7730 47
2362504 2362504 2022-03-31 St. Croix Virgin Islands 78010 7724 47
2359250 2359250 2022-03-30 St. Croix Virgin Islands 78010 7723 47
2355996 2355996 2022-03-29 St. Croix Virgin Islands 78010 7723 47
2352743 2352743 2022-03-28 St. Croix Virgin Islands 78010 7706 46
2349491 2349491 2022-03-27 St. Croix Virgin Islands 78010 7706 46
2346238 2346238 2022-03-26 St. Croix Virgin Islands 78010 7706 46
2342985 2342985 2022-03-25 St. Croix Virgin Islands 78010 7706 46
2339732 2339732 2022-03-24 St. Croix Virgin Islands 78010 7704 46
2336478 2336478 2022-03-23 St. Croix Virgin Islands 78010 7694 46
2333224 2333224 2022-03-22 St. Croix Virgin Islands 78010 7690 46
2329971 2329971 2022-03-21 St. Croix Virgin Islands 78010 7686 46
2326719 2326719 2022-03-20 St. Croix Virgin Islands 78010 7683 46
2323466 2323466 2022-03-19 St. Croix Virgin Islands 78010 7683 46
2320212 2320212 2022-03-18 St. Croix Virgin Islands 78010 7683 46
2316958 2316958 2022-03-17 St. Croix Virgin Islands 78010 7682 46
2313705 2313705 2022-03-16 St. Croix Virgin Islands 78010 7680 45
2310452 2310452 2022-03-15 St. Croix Virgin Islands 78010 7678 45
2307199 2307199 2022-03-14 St. Croix Virgin Islands 78010 7671 45
2303948 2303948 2022-03-13 St. Croix Virgin Islands 78010 7671 45
2300696 2300696 2022-03-12 St. Croix Virgin Islands 78010 7671 45
2297444 2297444 2022-03-11 St. Croix Virgin Islands 78010 7671 45
2294192 2294192 2022-03-10 St. Croix Virgin Islands 78010 7607 45
2290940 2290940 2022-03-09 St. Croix Virgin Islands 78010 7603 45
2287688 2287688 2022-03-08 St. Croix Virgin Islands 78010 7601 45
2284436 2284436 2022-03-07 St. Croix Virgin Islands 78010 7595 45
2281184 2281184 2022-03-06 St. Croix Virgin Islands 78010 7595 45
2277931 2277931 2022-03-05 St. Croix Virgin Islands 78010 7595 45
2274678 2274678 2022-03-04 St. Croix Virgin Islands 78010 7595 45
2271425 2271425 2022-03-03 St. Croix Virgin Islands 78010 7588 45
2268173 2268173 2022-03-02 St. Croix Virgin Islands 78010 7587 45
2264920 2264920 2022-03-01 St. Croix Virgin Islands 78010 7580 45
2261670 2261670 2022-02-28 St. Croix Virgin Islands 78010 7576 45
2258419 2258419 2022-02-27 St. Croix Virgin Islands 78010 7551 45
2255168 2255168 2022-02-26 St. Croix Virgin Islands 78010 7551 45
2251917 2251917 2022-02-25 St. Croix Virgin Islands 78010 7551 45
2248666 2248666 2022-02-24 St. Croix Virgin Islands 78010 7535 45
2245415 2245415 2022-02-23 St. Croix Virgin Islands 78010 7472 45
2242164 2242164 2022-02-22 St. Croix Virgin Islands 78010 7472 45
2238913 2238913 2022-02-21 St. Croix Virgin Islands 78010 7472 45
2235662 2235662 2022-02-20 St. Croix Virgin Islands 78010 7472 45
2232411 2232411 2022-02-19 St. Croix Virgin Islands 78010 7472 45
2229160 2229160 2022-02-18 St. Croix Virgin Islands 78010 7472 45
2225909 2225909 2022-02-17 St. Croix Virgin Islands 78010 7472 45
2222658 2222658 2022-02-16 St. Croix Virgin Islands 78010 7453 44
2219407 2219407 2022-02-15 St. Croix Virgin Islands 78010 7453 44
2216156 2216156 2022-02-14 St. Croix Virgin Islands 78010 7413 43
2212905 2212905 2022-02-13 St. Croix Virgin Islands 78010 7406 43
2209652 2209652 2022-02-12 St. Croix Virgin Islands 78010 7406 43
2206399 2206399 2022-02-11 St. Croix Virgin Islands 78010 7406 43
2203146 2203146 2022-02-10 St. Croix Virgin Islands 78010 7344 43
2199892 2199892 2022-02-09 St. Croix Virgin Islands 78010 7344 43
2196638 2196638 2022-02-08 St. Croix Virgin Islands 78010 7344 43
2193384 2193384 2022-02-07 St. Croix Virgin Islands 78010 7302 43
2190131 2190131 2022-02-06 St. Croix Virgin Islands 78010 7302 43
2186878 2186878 2022-02-05 St. Croix Virgin Islands 78010 7302 43
2183625 2183625 2022-02-04 St. Croix Virgin Islands 78010 7302 43
2180373 2180373 2022-02-03 St. Croix Virgin Islands 78010 7287 43

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