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

787 rows where county = "Kent", fips = 10001 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 · 787 ✖

fips 1

  • 10001 · 787 ✖

county 1

  • Kent · 787 ✖
Link rowid date ▲ county state fips cases deaths
2499893 2499893 2022-05-13 Kent Delaware 10001 51836 650
2496635 2496635 2022-05-12 Kent Delaware 10001 51721 650
2493377 2493377 2022-05-11 Kent Delaware 10001 51498 650
2490119 2490119 2022-05-10 Kent Delaware 10001 51498 650
2486862 2486862 2022-05-09 Kent Delaware 10001 51471 650
2483604 2483604 2022-05-08 Kent Delaware 10001 51306 650
2480346 2480346 2022-05-07 Kent Delaware 10001 51306 650
2477088 2477088 2022-05-06 Kent Delaware 10001 51306 650
2473830 2473830 2022-05-05 Kent Delaware 10001 51201 649
2470573 2470573 2022-05-04 Kent Delaware 10001 51102 649
2467317 2467317 2022-05-03 Kent Delaware 10001 51055 649
2464062 2464062 2022-05-02 Kent Delaware 10001 51041 649
2460806 2460806 2022-05-01 Kent Delaware 10001 50914 645
2457550 2457550 2022-04-30 Kent Delaware 10001 50914 645
2454294 2454294 2022-04-29 Kent Delaware 10001 50914 645
2451038 2451038 2022-04-28 Kent Delaware 10001 50861 645
2447782 2447782 2022-04-27 Kent Delaware 10001 50816 645
2444526 2444526 2022-04-26 Kent Delaware 10001 50776 645
2441270 2441270 2022-04-25 Kent Delaware 10001 50752 645
2438014 2438014 2022-04-24 Kent Delaware 10001 50702 645
2434758 2434758 2022-04-23 Kent Delaware 10001 50702 645
2431502 2431502 2022-04-22 Kent Delaware 10001 50631 643
2428246 2428246 2022-04-21 Kent Delaware 10001 50588 643
2424990 2424990 2022-04-20 Kent Delaware 10001 50551 643
2421734 2421734 2022-04-19 Kent Delaware 10001 50508 643
2418478 2418478 2022-04-18 Kent Delaware 10001 50479 643
2415222 2415222 2022-04-17 Kent Delaware 10001 50413 643
2411966 2411966 2022-04-16 Kent Delaware 10001 50413 643
2408710 2408710 2022-04-15 Kent Delaware 10001 50413 643
2405454 2405454 2022-04-14 Kent Delaware 10001 50356 640
2402199 2402199 2022-04-13 Kent Delaware 10001 50300 640
2398944 2398944 2022-04-12 Kent Delaware 10001 50256 640
2395689 2395689 2022-04-11 Kent Delaware 10001 50244 640
2392433 2392433 2022-04-10 Kent Delaware 10001 50229 640
2389177 2389177 2022-04-09 Kent Delaware 10001 50200 640
2385922 2385922 2022-04-08 Kent Delaware 10001 50175 638
2382667 2382667 2022-04-07 Kent Delaware 10001 50315 638
2379412 2379412 2022-04-06 Kent Delaware 10001 50280 638
2376158 2376158 2022-04-05 Kent Delaware 10001 50258 638
2372906 2372906 2022-04-04 Kent Delaware 10001 50253 638
2369653 2369653 2022-04-03 Kent Delaware 10001 50246 638
2366400 2366400 2022-04-02 Kent Delaware 10001 50225 638
2363147 2363147 2022-04-01 Kent Delaware 10001 50210 634
2359893 2359893 2022-03-31 Kent Delaware 10001 50196 634
2356639 2356639 2022-03-30 Kent Delaware 10001 50166 634
2353386 2353386 2022-03-29 Kent Delaware 10001 50153 634
2350134 2350134 2022-03-28 Kent Delaware 10001 50140 634
2346881 2346881 2022-03-27 Kent Delaware 10001 50134 634
2343628 2343628 2022-03-26 Kent Delaware 10001 50114 634
2340375 2340375 2022-03-25 Kent Delaware 10001 50096 632
2337122 2337122 2022-03-24 Kent Delaware 10001 50068 631
2333868 2333868 2022-03-23 Kent Delaware 10001 50031 631
2330614 2330614 2022-03-22 Kent Delaware 10001 50019 631
2327362 2327362 2022-03-21 Kent Delaware 10001 50018 631
2324109 2324109 2022-03-20 Kent Delaware 10001 50010 631
2320855 2320855 2022-03-19 Kent Delaware 10001 49998 631
2317601 2317601 2022-03-18 Kent Delaware 10001 49983 625
2314348 2314348 2022-03-17 Kent Delaware 10001 49969 625
2311095 2311095 2022-03-16 Kent Delaware 10001 49949 625
2307842 2307842 2022-03-15 Kent Delaware 10001 49934 625
2304591 2304591 2022-03-14 Kent Delaware 10001 49925 622
2301339 2301339 2022-03-13 Kent Delaware 10001 49917 622
2298087 2298087 2022-03-12 Kent Delaware 10001 49908 622
2294835 2294835 2022-03-11 Kent Delaware 10001 49887 611
2291583 2291583 2022-03-10 Kent Delaware 10001 49856 611
2288331 2288331 2022-03-09 Kent Delaware 10001 49777 610
2285080 2285080 2022-03-08 Kent Delaware 10001 49760 610
2281828 2281828 2022-03-07 Kent Delaware 10001 49755 609
2278575 2278575 2022-03-06 Kent Delaware 10001 49740 609
2275322 2275322 2022-03-05 Kent Delaware 10001 49725 609
2272069 2272069 2022-03-04 Kent Delaware 10001 49720 603
2268817 2268817 2022-03-03 Kent Delaware 10001 49679 603
2265564 2265564 2022-03-02 Kent Delaware 10001 49652 603
2262313 2262313 2022-03-01 Kent Delaware 10001 49627 603
2259062 2259062 2022-02-28 Kent Delaware 10001 49617 602
2255811 2255811 2022-02-27 Kent Delaware 10001 49606 602
2252560 2252560 2022-02-26 Kent Delaware 10001 49592 602
2249309 2249309 2022-02-25 Kent Delaware 10001 49573 601
2246058 2246058 2022-02-24 Kent Delaware 10001 49546 599
2242807 2242807 2022-02-23 Kent Delaware 10001 49362 599
2239556 2239556 2022-02-22 Kent Delaware 10001 49339 599
2236305 2236305 2022-02-21 Kent Delaware 10001 49327 596
2233054 2233054 2022-02-20 Kent Delaware 10001 49298 596
2229803 2229803 2022-02-19 Kent Delaware 10001 49268 596
2226552 2226552 2022-02-18 Kent Delaware 10001 49226 590
2223301 2223301 2022-02-17 Kent Delaware 10001 49165 589
2220050 2220050 2022-02-16 Kent Delaware 10001 49092 589
2216799 2216799 2022-02-15 Kent Delaware 10001 49030 587
2213548 2213548 2022-02-14 Kent Delaware 10001 48999 587
2210296 2210296 2022-02-13 Kent Delaware 10001 48959 587
2207043 2207043 2022-02-12 Kent Delaware 10001 48897 587
2203790 2203790 2022-02-11 Kent Delaware 10001 48839 576
2200537 2200537 2022-02-10 Kent Delaware 10001 48751 576
2197283 2197283 2022-02-09 Kent Delaware 10001 48617 574
2194029 2194029 2022-02-08 Kent Delaware 10001 48552 572
2190775 2190775 2022-02-07 Kent Delaware 10001 48509 567
2187522 2187522 2022-02-06 Kent Delaware 10001 48458 567
2184269 2184269 2022-02-05 Kent Delaware 10001 48336 567
2181017 2181017 2022-02-04 Kent Delaware 10001 48229 565
2177766 2177766 2022-02-03 Kent Delaware 10001 48098 560

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