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

762 rows where county = "Unknown" and state = "Delaware" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Delaware · 762 ✖

fips 1

  • - 762

county 1

  • Unknown · 762 ✖
Link rowid date ▲ county state fips cases deaths
2499896 2499896 2022-05-13 Unknown Delaware   899 0
2496638 2496638 2022-05-12 Unknown Delaware   895 0
2493380 2493380 2022-05-11 Unknown Delaware   885 0
2490122 2490122 2022-05-10 Unknown Delaware   885 0
2486865 2486865 2022-05-09 Unknown Delaware   881 0
2483607 2483607 2022-05-08 Unknown Delaware   877 0
2480349 2480349 2022-05-07 Unknown Delaware   877 0
2477091 2477091 2022-05-06 Unknown Delaware   877 0
2473833 2473833 2022-05-05 Unknown Delaware   876 0
2470576 2470576 2022-05-04 Unknown Delaware   874 0
2467320 2467320 2022-05-03 Unknown Delaware   874 0
2464065 2464065 2022-05-02 Unknown Delaware   871 0
2460809 2460809 2022-05-01 Unknown Delaware   867 0
2457553 2457553 2022-04-30 Unknown Delaware   867 0
2454297 2454297 2022-04-29 Unknown Delaware   867 0
2451041 2451041 2022-04-28 Unknown Delaware   866 0
2447785 2447785 2022-04-27 Unknown Delaware   861 0
2444529 2444529 2022-04-26 Unknown Delaware   861 0
2441273 2441273 2022-04-25 Unknown Delaware   861 0
2438017 2438017 2022-04-24 Unknown Delaware   858 0
2434761 2434761 2022-04-23 Unknown Delaware   858 0
2431505 2431505 2022-04-22 Unknown Delaware   858 0
2428249 2428249 2022-04-21 Unknown Delaware   863 0
2424993 2424993 2022-04-20 Unknown Delaware   863 0
2421737 2421737 2022-04-19 Unknown Delaware   862 0
2418481 2418481 2022-04-18 Unknown Delaware   860 0
2415225 2415225 2022-04-17 Unknown Delaware   859 0
2411969 2411969 2022-04-16 Unknown Delaware   859 0
2408713 2408713 2022-04-15 Unknown Delaware   859 0
2405457 2405457 2022-04-14 Unknown Delaware   857 0
2402202 2402202 2022-04-13 Unknown Delaware   851 0
2398947 2398947 2022-04-12 Unknown Delaware   855 0
2395692 2395692 2022-04-11 Unknown Delaware   851 0
2392436 2392436 2022-04-10 Unknown Delaware   851 0
2389180 2389180 2022-04-09 Unknown Delaware   851 0
2385925 2385925 2022-04-08 Unknown Delaware   850 0
2382670 2382670 2022-04-07 Unknown Delaware   924 0
2379415 2379415 2022-04-06 Unknown Delaware   921 0
2376161 2376161 2022-04-05 Unknown Delaware   921 0
2372909 2372909 2022-04-04 Unknown Delaware   921 0
2369656 2369656 2022-04-03 Unknown Delaware   921 0
2366403 2366403 2022-04-02 Unknown Delaware   920 0
2363150 2363150 2022-04-01 Unknown Delaware   920 0
2359896 2359896 2022-03-31 Unknown Delaware   920 0
2356642 2356642 2022-03-30 Unknown Delaware   926 0
2353389 2353389 2022-03-29 Unknown Delaware   920 0
2350137 2350137 2022-03-28 Unknown Delaware   920 0
2346884 2346884 2022-03-27 Unknown Delaware   920 0
2343631 2343631 2022-03-26 Unknown Delaware   920 0
2340378 2340378 2022-03-25 Unknown Delaware   920 0
2337125 2337125 2022-03-24 Unknown Delaware   920 0
2333871 2333871 2022-03-23 Unknown Delaware   920 0
2330617 2330617 2022-03-22 Unknown Delaware   921 0
2327365 2327365 2022-03-21 Unknown Delaware   920 0
2324112 2324112 2022-03-20 Unknown Delaware   920 0
2320858 2320858 2022-03-19 Unknown Delaware   919 0
2317604 2317604 2022-03-18 Unknown Delaware   919 0
2314351 2314351 2022-03-17 Unknown Delaware   919 0
2311098 2311098 2022-03-16 Unknown Delaware   919 0
2307845 2307845 2022-03-15 Unknown Delaware   919 0
2304594 2304594 2022-03-14 Unknown Delaware   919 0
2301342 2301342 2022-03-13 Unknown Delaware   919 0
2298090 2298090 2022-03-12 Unknown Delaware   919 0
2294838 2294838 2022-03-11 Unknown Delaware   919 0
2291586 2291586 2022-03-10 Unknown Delaware   920 0
2288334 2288334 2022-03-09 Unknown Delaware   919 0
2285083 2285083 2022-03-08 Unknown Delaware   919 0
2281831 2281831 2022-03-07 Unknown Delaware   919 0
2278578 2278578 2022-03-06 Unknown Delaware   919 0
2275325 2275325 2022-03-05 Unknown Delaware   919 0
2272072 2272072 2022-03-04 Unknown Delaware   920 0
2268820 2268820 2022-03-03 Unknown Delaware   920 0
2265567 2265567 2022-03-02 Unknown Delaware   920 0
2262316 2262316 2022-03-01 Unknown Delaware   920 0
2259065 2259065 2022-02-28 Unknown Delaware   920 0
2255814 2255814 2022-02-27 Unknown Delaware   920 0
2252563 2252563 2022-02-26 Unknown Delaware   920 0
2249312 2249312 2022-02-25 Unknown Delaware   920 0
2246061 2246061 2022-02-24 Unknown Delaware   920 0
2242810 2242810 2022-02-23 Unknown Delaware   914 0
2239559 2239559 2022-02-22 Unknown Delaware   914 0
2236308 2236308 2022-02-21 Unknown Delaware   914 0
2233057 2233057 2022-02-20 Unknown Delaware   913 0
2229806 2229806 2022-02-19 Unknown Delaware   913 0
2226555 2226555 2022-02-18 Unknown Delaware   913 0
2223304 2223304 2022-02-17 Unknown Delaware   913 0
2220053 2220053 2022-02-16 Unknown Delaware   911 0
2216802 2216802 2022-02-15 Unknown Delaware   910 0
2213551 2213551 2022-02-14 Unknown Delaware   909 0
2210299 2210299 2022-02-13 Unknown Delaware   909 0
2207046 2207046 2022-02-12 Unknown Delaware   909 0
2203793 2203793 2022-02-11 Unknown Delaware   909 0
2200540 2200540 2022-02-10 Unknown Delaware   908 0
2197286 2197286 2022-02-09 Unknown Delaware   906 0
2194032 2194032 2022-02-08 Unknown Delaware   903 0
2190778 2190778 2022-02-07 Unknown Delaware   903 0
2187525 2187525 2022-02-06 Unknown Delaware   903 0
2184272 2184272 2022-02-05 Unknown Delaware   902 0
2181020 2181020 2022-02-04 Unknown Delaware   904 0
2177769 2177769 2022-02-03 Unknown Delaware   904 0

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