ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,408 rows where deaths = 217 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 109
- Tennessee 103
- North Carolina 87
- Georgia 78
- Alabama 77
- South Carolina 70
- Texas 69
- Missouri 59
- Illinois 57
- Maryland 54
- Pennsylvania 54
- Wisconsin 48
- Louisiana 47
- Oklahoma 42
- Mississippi 36
- Indiana 35
- Iowa 31
- Michigan 29
- Kentucky 28
- Virginia 27
- California 25
- Idaho 24
- Nevada 23
- Arizona 22
- Florida 19
- New York 19
- Arkansas 18
- Minnesota 14
- New Jersey 12
- Washington 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500234 | 2500234 | 2022-05-13 | Marion | Illinois | 17121 | 11933 | 217 |
2500800 | 2500800 | 2022-05-13 | St. Mary's | Maryland | 24037 | 19329 | 217 |
2502125 | 2502125 | 2022-05-13 | Cocke | Tennessee | 47029 | 11634 | 217 |
2496976 | 2496976 | 2022-05-12 | Marion | Illinois | 17121 | 11929 | 217 |
2497542 | 2497542 | 2022-05-12 | St. Mary's | Maryland | 24037 | 19312 | 217 |
2498867 | 2498867 | 2022-05-12 | Cocke | Tennessee | 47029 | 11634 | 217 |
2493718 | 2493718 | 2022-05-11 | Marion | Illinois | 17121 | 11925 | 217 |
2494284 | 2494284 | 2022-05-11 | St. Mary's | Maryland | 24037 | 19267 | 217 |
2495609 | 2495609 | 2022-05-11 | Cocke | Tennessee | 47029 | 11634 | 217 |
2490460 | 2490460 | 2022-05-10 | Marion | Illinois | 17121 | 11919 | 217 |
2491569 | 2491569 | 2022-05-10 | Carson City | Nevada | 32510 | 14999 | 217 |
2492351 | 2492351 | 2022-05-10 | Cocke | Tennessee | 47029 | 11617 | 217 |
2487203 | 2487203 | 2022-05-09 | Marion | Illinois | 17121 | 11916 | 217 |
2488311 | 2488311 | 2022-05-09 | Carson City | Nevada | 32510 | 14999 | 217 |
2489093 | 2489093 | 2022-05-09 | Cocke | Tennessee | 47029 | 11617 | 217 |
2483945 | 2483945 | 2022-05-08 | Marion | Illinois | 17121 | 11914 | 217 |
2485054 | 2485054 | 2022-05-08 | Carson City | Nevada | 32510 | 14999 | 217 |
2485836 | 2485836 | 2022-05-08 | Cocke | Tennessee | 47029 | 11617 | 217 |
2480687 | 2480687 | 2022-05-07 | Marion | Illinois | 17121 | 11914 | 217 |
2481796 | 2481796 | 2022-05-07 | Carson City | Nevada | 32510 | 14999 | 217 |
2482578 | 2482578 | 2022-05-07 | Cocke | Tennessee | 47029 | 11617 | 217 |
2477429 | 2477429 | 2022-05-06 | Marion | Illinois | 17121 | 11914 | 217 |
2478538 | 2478538 | 2022-05-06 | Carson City | Nevada | 32510 | 14999 | 217 |
2479320 | 2479320 | 2022-05-06 | Cocke | Tennessee | 47029 | 11617 | 217 |
2474171 | 2474171 | 2022-05-05 | Marion | Illinois | 17121 | 11911 | 217 |
2475280 | 2475280 | 2022-05-05 | Carson City | Nevada | 32510 | 14999 | 217 |
2476062 | 2476062 | 2022-05-05 | Cocke | Tennessee | 47029 | 11617 | 217 |
2470914 | 2470914 | 2022-05-04 | Marion | Illinois | 17121 | 11911 | 217 |
2471807 | 2471807 | 2022-05-04 | Joplin | Missouri | 13735 | 217 | |
2472023 | 2472023 | 2022-05-04 | Carson City | Nevada | 32510 | 14999 | 217 |
2472805 | 2472805 | 2022-05-04 | Cocke | Tennessee | 47029 | 11617 | 217 |
2467526 | 2467526 | 2022-05-03 | Tift | Georgia | 13277 | 11565 | 217 |
2467658 | 2467658 | 2022-05-03 | Marion | Illinois | 17121 | 11909 | 217 |
2468551 | 2468551 | 2022-05-03 | Joplin | Missouri | 13735 | 217 | |
2468767 | 2468767 | 2022-05-03 | Carson City | Nevada | 32510 | 14972 | 217 |
2469549 | 2469549 | 2022-05-03 | Cocke | Tennessee | 47029 | 11603 | 217 |
2464271 | 2464271 | 2022-05-02 | Tift | Georgia | 13277 | 11565 | 217 |
2464403 | 2464403 | 2022-05-02 | Marion | Illinois | 17121 | 11907 | 217 |
2465295 | 2465295 | 2022-05-02 | Joplin | Missouri | 13735 | 217 | |
2465511 | 2465511 | 2022-05-02 | Carson City | Nevada | 32510 | 14972 | 217 |
2466293 | 2466293 | 2022-05-02 | Cocke | Tennessee | 47029 | 11603 | 217 |
2461015 | 2461015 | 2022-05-01 | Tift | Georgia | 13277 | 11565 | 217 |
2461147 | 2461147 | 2022-05-01 | Marion | Illinois | 17121 | 11901 | 217 |
2462040 | 2462040 | 2022-05-01 | Joplin | Missouri | 13735 | 217 | |
2462256 | 2462256 | 2022-05-01 | Carson City | Nevada | 32510 | 14972 | 217 |
2463038 | 2463038 | 2022-05-01 | Cocke | Tennessee | 47029 | 11603 | 217 |
2457759 | 2457759 | 2022-04-30 | Tift | Georgia | 13277 | 11565 | 217 |
2457891 | 2457891 | 2022-04-30 | Marion | Illinois | 17121 | 11901 | 217 |
2458784 | 2458784 | 2022-04-30 | Joplin | Missouri | 13735 | 217 | |
2459000 | 2459000 | 2022-04-30 | Carson City | Nevada | 32510 | 14972 | 217 |
2459782 | 2459782 | 2022-04-30 | Cocke | Tennessee | 47029 | 11603 | 217 |
2454503 | 2454503 | 2022-04-29 | Tift | Georgia | 13277 | 11565 | 217 |
2454635 | 2454635 | 2022-04-29 | Marion | Illinois | 17121 | 11901 | 217 |
2455528 | 2455528 | 2022-04-29 | Joplin | Missouri | 13735 | 217 | |
2455744 | 2455744 | 2022-04-29 | Carson City | Nevada | 32510 | 14972 | 217 |
2456526 | 2456526 | 2022-04-29 | Cocke | Tennessee | 47029 | 11603 | 217 |
2451247 | 2451247 | 2022-04-28 | Tift | Georgia | 13277 | 11565 | 217 |
2451379 | 2451379 | 2022-04-28 | Marion | Illinois | 17121 | 11899 | 217 |
2452272 | 2452272 | 2022-04-28 | Joplin | Missouri | 13735 | 217 | |
2452488 | 2452488 | 2022-04-28 | Carson City | Nevada | 32510 | 14972 | 217 |
2453270 | 2453270 | 2022-04-28 | Cocke | Tennessee | 47029 | 11603 | 217 |
2447991 | 2447991 | 2022-04-27 | Tift | Georgia | 13277 | 11565 | 217 |
2448123 | 2448123 | 2022-04-27 | Marion | Illinois | 17121 | 11891 | 217 |
2449016 | 2449016 | 2022-04-27 | Joplin | Missouri | 13735 | 217 | |
2449232 | 2449232 | 2022-04-27 | Carson City | Nevada | 32510 | 14972 | 217 |
2449657 | 2449657 | 2022-04-27 | Kay | Oklahoma | 40071 | 12283 | 217 |
2450014 | 2450014 | 2022-04-27 | Cocke | Tennessee | 47029 | 11603 | 217 |
2444867 | 2444867 | 2022-04-26 | Marion | Illinois | 17121 | 11887 | 217 |
2445759 | 2445759 | 2022-04-26 | Joplin | Missouri | 13735 | 217 | |
2445975 | 2445975 | 2022-04-26 | Carson City | Nevada | 32510 | 14942 | 217 |
2446400 | 2446400 | 2022-04-26 | Kay | Oklahoma | 40071 | 12283 | 217 |
2441611 | 2441611 | 2022-04-25 | Marion | Illinois | 17121 | 11885 | 217 |
2442504 | 2442504 | 2022-04-25 | Joplin | Missouri | 13735 | 217 | |
2442720 | 2442720 | 2022-04-25 | Carson City | Nevada | 32510 | 14942 | 217 |
2443145 | 2443145 | 2022-04-25 | Kay | Oklahoma | 40071 | 12283 | 217 |
2438355 | 2438355 | 2022-04-24 | Marion | Illinois | 17121 | 11879 | 217 |
2439248 | 2439248 | 2022-04-24 | Joplin | Missouri | 13735 | 217 | |
2439464 | 2439464 | 2022-04-24 | Carson City | Nevada | 32510 | 14942 | 217 |
2439889 | 2439889 | 2022-04-24 | Kay | Oklahoma | 40071 | 12283 | 217 |
2435099 | 2435099 | 2022-04-23 | Marion | Illinois | 17121 | 11879 | 217 |
2435992 | 2435992 | 2022-04-23 | Joplin | Missouri | 13735 | 217 | |
2436208 | 2436208 | 2022-04-23 | Carson City | Nevada | 32510 | 14942 | 217 |
2436633 | 2436633 | 2022-04-23 | Kay | Oklahoma | 40071 | 12283 | 217 |
2431843 | 2431843 | 2022-04-22 | Marion | Illinois | 17121 | 11879 | 217 |
2432736 | 2432736 | 2022-04-22 | Joplin | Missouri | 13735 | 217 | |
2432952 | 2432952 | 2022-04-22 | Carson City | Nevada | 32510 | 14942 | 217 |
2433377 | 2433377 | 2022-04-22 | Kay | Oklahoma | 40071 | 12283 | 217 |
2428587 | 2428587 | 2022-04-21 | Marion | Illinois | 17121 | 11877 | 217 |
2429480 | 2429480 | 2022-04-21 | Joplin | Missouri | 13735 | 217 | |
2429696 | 2429696 | 2022-04-21 | Carson City | Nevada | 32510 | 14942 | 217 |
2430121 | 2430121 | 2022-04-21 | Kay | Oklahoma | 40071 | 12283 | 217 |
2426224 | 2426224 | 2022-04-20 | Joplin | Missouri | 13735 | 217 | |
2426440 | 2426440 | 2022-04-20 | Carson City | Nevada | 32510 | 14942 | 217 |
2426743 | 2426743 | 2022-04-20 | Ashland | Ohio | 39005 | 11967 | 217 |
2426865 | 2426865 | 2022-04-20 | Kay | Oklahoma | 40071 | 12277 | 217 |
2422968 | 2422968 | 2022-04-19 | Joplin | Missouri | 13735 | 217 | |
2423487 | 2423487 | 2022-04-19 | Ashland | Ohio | 39005 | 11967 | 217 |
2423609 | 2423609 | 2022-04-19 | Kay | Oklahoma | 40071 | 12277 | 217 |
2419711 | 2419711 | 2022-04-18 | Joplin | Missouri | 13735 | 217 | |
2420230 | 2420230 | 2022-04-18 | Ashland | Ohio | 39005 | 11967 | 217 |
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);