ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,239 rows where deaths = 216 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 128
- Texas 86
- Alabama 75
- North Carolina 68
- Ohio 68
- Georgia 62
- Pennsylvania 62
- Michigan 61
- Maryland 53
- Wisconsin 44
- Virginia 43
- Tennessee 38
- South Carolina 37
- Missouri 33
- Kentucky 31
- Washington 29
- Indiana 27
- New Mexico 24
- Oklahoma 21
- California 20
- Iowa 20
- Mississippi 20
- Arkansas 18
- Florida 18
- New Jersey 17
- Arizona 16
- Nevada 15
- Louisiana 14
- New York 14
- Idaho 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499575 | 2499575 | 2022-05-13 | Autauga | Alabama | 1001 | 15863 | 216 |
2500879 | 2500879 | 2022-05-13 | Montcalm | Michigan | 26117 | 17350 | 216 |
2501768 | 2501768 | 2022-05-13 | Kay | Oklahoma | 40071 | 12327 | 216 |
2496317 | 2496317 | 2022-05-12 | Autauga | Alabama | 1001 | 15860 | 216 |
2497621 | 2497621 | 2022-05-12 | Montcalm | Michigan | 26117 | 17350 | 216 |
2498510 | 2498510 | 2022-05-12 | Kay | Oklahoma | 40071 | 12327 | 216 |
2493059 | 2493059 | 2022-05-11 | Autauga | Alabama | 1001 | 15853 | 216 |
2494363 | 2494363 | 2022-05-11 | Montcalm | Michigan | 26117 | 17350 | 216 |
2495252 | 2495252 | 2022-05-11 | Kay | Oklahoma | 40071 | 12318 | 216 |
2489801 | 2489801 | 2022-05-10 | Autauga | Alabama | 1001 | 15852 | 216 |
2491026 | 2491026 | 2022-05-10 | St. Mary's | Maryland | 24037 | 19234 | 216 |
2491105 | 2491105 | 2022-05-10 | Montcalm | Michigan | 26117 | 17268 | 216 |
2491994 | 2491994 | 2022-05-10 | Kay | Oklahoma | 40071 | 12318 | 216 |
2486544 | 2486544 | 2022-05-09 | Autauga | Alabama | 1001 | 15846 | 216 |
2487769 | 2487769 | 2022-05-09 | St. Mary's | Maryland | 24037 | 19190 | 216 |
2487848 | 2487848 | 2022-05-09 | Montcalm | Michigan | 26117 | 17268 | 216 |
2488736 | 2488736 | 2022-05-09 | Kay | Oklahoma | 40071 | 12318 | 216 |
2483286 | 2483286 | 2022-05-08 | Autauga | Alabama | 1001 | 15840 | 216 |
2484511 | 2484511 | 2022-05-08 | St. Mary's | Maryland | 24037 | 19180 | 216 |
2484590 | 2484590 | 2022-05-08 | Montcalm | Michigan | 26117 | 17268 | 216 |
2485479 | 2485479 | 2022-05-08 | Kay | Oklahoma | 40071 | 12318 | 216 |
2480028 | 2480028 | 2022-05-07 | Autauga | Alabama | 1001 | 15840 | 216 |
2481253 | 2481253 | 2022-05-07 | St. Mary's | Maryland | 24037 | 19180 | 216 |
2481332 | 2481332 | 2022-05-07 | Montcalm | Michigan | 26117 | 17268 | 216 |
2482221 | 2482221 | 2022-05-07 | Kay | Oklahoma | 40071 | 12318 | 216 |
2476770 | 2476770 | 2022-05-06 | Autauga | Alabama | 1001 | 15840 | 216 |
2477995 | 2477995 | 2022-05-06 | St. Mary's | Maryland | 24037 | 19180 | 216 |
2478074 | 2478074 | 2022-05-06 | Montcalm | Michigan | 26117 | 17268 | 216 |
2478963 | 2478963 | 2022-05-06 | Kay | Oklahoma | 40071 | 12318 | 216 |
2473512 | 2473512 | 2022-05-05 | Autauga | Alabama | 1001 | 15840 | 216 |
2474737 | 2474737 | 2022-05-05 | St. Mary's | Maryland | 24037 | 19156 | 216 |
2474816 | 2474816 | 2022-05-05 | Montcalm | Michigan | 26117 | 17268 | 216 |
2475705 | 2475705 | 2022-05-05 | Kay | Oklahoma | 40071 | 12318 | 216 |
2470255 | 2470255 | 2022-05-04 | Autauga | Alabama | 1001 | 15839 | 216 |
2471480 | 2471480 | 2022-05-04 | St. Mary's | Maryland | 24037 | 19131 | 216 |
2471559 | 2471559 | 2022-05-04 | Montcalm | Michigan | 26117 | 17268 | 216 |
2466999 | 2466999 | 2022-05-03 | Autauga | Alabama | 1001 | 15835 | 216 |
2468303 | 2468303 | 2022-05-03 | Montcalm | Michigan | 26117 | 17219 | 216 |
2463744 | 2463744 | 2022-05-02 | Autauga | Alabama | 1001 | 15833 | 216 |
2465048 | 2465048 | 2022-05-02 | Montcalm | Michigan | 26117 | 17219 | 216 |
2460488 | 2460488 | 2022-05-01 | Autauga | Alabama | 1001 | 15827 | 216 |
2461792 | 2461792 | 2022-05-01 | Montcalm | Michigan | 26117 | 17219 | 216 |
2457232 | 2457232 | 2022-04-30 | Autauga | Alabama | 1001 | 15827 | 216 |
2458536 | 2458536 | 2022-04-30 | Montcalm | Michigan | 26117 | 17219 | 216 |
2453976 | 2453976 | 2022-04-29 | Autauga | Alabama | 1001 | 15827 | 216 |
2455280 | 2455280 | 2022-04-29 | Montcalm | Michigan | 26117 | 17219 | 216 |
2450720 | 2450720 | 2022-04-28 | Autauga | Alabama | 1001 | 15826 | 216 |
2452024 | 2452024 | 2022-04-28 | Montcalm | Michigan | 26117 | 17219 | 216 |
2447464 | 2447464 | 2022-04-27 | Autauga | Alabama | 1001 | 15821 | 216 |
2448768 | 2448768 | 2022-04-27 | Montcalm | Michigan | 26117 | 17219 | 216 |
2444735 | 2444735 | 2022-04-26 | Tift | Georgia | 13277 | 11558 | 216 |
2445512 | 2445512 | 2022-04-26 | Montcalm | Michigan | 26117 | 17188 | 216 |
2446757 | 2446757 | 2022-04-26 | Cocke | Tennessee | 47029 | 11586 | 216 |
2441479 | 2441479 | 2022-04-25 | Tift | Georgia | 13277 | 11558 | 216 |
2442256 | 2442256 | 2022-04-25 | Montcalm | Michigan | 26117 | 17188 | 216 |
2443502 | 2443502 | 2022-04-25 | Cocke | Tennessee | 47029 | 11586 | 216 |
2438223 | 2438223 | 2022-04-24 | Tift | Georgia | 13277 | 11557 | 216 |
2439000 | 2439000 | 2022-04-24 | Montcalm | Michigan | 26117 | 17188 | 216 |
2440246 | 2440246 | 2022-04-24 | Cocke | Tennessee | 47029 | 11586 | 216 |
2434967 | 2434967 | 2022-04-23 | Tift | Georgia | 13277 | 11557 | 216 |
2435744 | 2435744 | 2022-04-23 | Montcalm | Michigan | 26117 | 17188 | 216 |
2436990 | 2436990 | 2022-04-23 | Cocke | Tennessee | 47029 | 11586 | 216 |
2431711 | 2431711 | 2022-04-22 | Tift | Georgia | 13277 | 11557 | 216 |
2432488 | 2432488 | 2022-04-22 | Montcalm | Michigan | 26117 | 17188 | 216 |
2433734 | 2433734 | 2022-04-22 | Cocke | Tennessee | 47029 | 11586 | 216 |
2428455 | 2428455 | 2022-04-21 | Tift | Georgia | 13277 | 11557 | 216 |
2429232 | 2429232 | 2022-04-21 | Montcalm | Michigan | 26117 | 17188 | 216 |
2430478 | 2430478 | 2022-04-21 | Cocke | Tennessee | 47029 | 11586 | 216 |
2425199 | 2425199 | 2022-04-20 | Tift | Georgia | 13277 | 11557 | 216 |
2425331 | 2425331 | 2022-04-20 | Marion | Illinois | 17121 | 11877 | 216 |
2425976 | 2425976 | 2022-04-20 | Montcalm | Michigan | 26117 | 17188 | 216 |
2426937 | 2426937 | 2022-04-20 | Umatilla | Oregon | 41059 | 22392 | 216 |
2427222 | 2427222 | 2022-04-20 | Cocke | Tennessee | 47029 | 11586 | 216 |
2422075 | 2422075 | 2022-04-19 | Marion | Illinois | 17121 | 11871 | 216 |
2422720 | 2422720 | 2022-04-19 | Montcalm | Michigan | 26117 | 17158 | 216 |
2423184 | 2423184 | 2022-04-19 | Carson City | Nevada | 32510 | 14922 | 216 |
2424358 | 2424358 | 2022-04-19 | Augusta | Virginia | 51015 | 19073 | 216 |
2418819 | 2418819 | 2022-04-18 | Marion | Illinois | 17121 | 11869 | 216 |
2419464 | 2419464 | 2022-04-18 | Montcalm | Michigan | 26117 | 17158 | 216 |
2419927 | 2419927 | 2022-04-18 | Carson City | Nevada | 32510 | 14922 | 216 |
2415563 | 2415563 | 2022-04-17 | Marion | Illinois | 17121 | 11867 | 216 |
2416208 | 2416208 | 2022-04-17 | Montcalm | Michigan | 26117 | 17158 | 216 |
2416672 | 2416672 | 2022-04-17 | Carson City | Nevada | 32510 | 14922 | 216 |
2412307 | 2412307 | 2022-04-16 | Marion | Illinois | 17121 | 11867 | 216 |
2412952 | 2412952 | 2022-04-16 | Montcalm | Michigan | 26117 | 17158 | 216 |
2413416 | 2413416 | 2022-04-16 | Carson City | Nevada | 32510 | 14922 | 216 |
2409051 | 2409051 | 2022-04-15 | Marion | Illinois | 17121 | 11867 | 216 |
2409696 | 2409696 | 2022-04-15 | Montcalm | Michigan | 26117 | 17158 | 216 |
2410160 | 2410160 | 2022-04-15 | Carson City | Nevada | 32510 | 14922 | 216 |
2405795 | 2405795 | 2022-04-14 | Marion | Illinois | 17121 | 11864 | 216 |
2406440 | 2406440 | 2022-04-14 | Montcalm | Michigan | 26117 | 17158 | 216 |
2406904 | 2406904 | 2022-04-14 | Carson City | Nevada | 32510 | 14922 | 216 |
2402540 | 2402540 | 2022-04-13 | Marion | Illinois | 17121 | 11863 | 216 |
2403184 | 2403184 | 2022-04-13 | Montcalm | Michigan | 26117 | 17158 | 216 |
2403648 | 2403648 | 2022-04-13 | Carson City | Nevada | 32510 | 14922 | 216 |
2399285 | 2399285 | 2022-04-12 | Marion | Illinois | 17121 | 11862 | 216 |
2400393 | 2400393 | 2022-04-12 | Carson City | Nevada | 32510 | 14886 | 216 |
2396030 | 2396030 | 2022-04-11 | Marion | Illinois | 17121 | 11859 | 216 |
2397138 | 2397138 | 2022-04-11 | Carson City | Nevada | 32510 | 14886 | 216 |
2392774 | 2392774 | 2022-04-10 | Marion | Illinois | 17121 | 11858 | 216 |
Advanced export
JSON shape: default, array, newline-delimited
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);