ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,223 rows where deaths = 223 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 112
- Texas 108
- Missouri 77
- North Carolina 77
- Louisiana 75
- Ohio 68
- Tennessee 63
- Indiana 60
- Michigan 53
- South Carolina 52
- Pennsylvania 44
- Virginia 34
- Illinois 33
- Washington 28
- Alabama 27
- Wisconsin 27
- Kentucky 26
- New Mexico 26
- Arkansas 17
- Oregon 17
- New Jersey 16
- Minnesota 15
- California 14
- Maryland 14
- Oklahoma 14
- Maine 12
- New York 12
- Arizona 11
- Florida 9
- Mississippi 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500593 | 2500593 | 2022-05-13 | Bullitt | Kentucky | 21029 | 21805 | 223 |
2497335 | 2497335 | 2022-05-12 | Bullitt | Kentucky | 21029 | 21805 | 223 |
2494077 | 2494077 | 2022-05-11 | Bullitt | Kentucky | 21029 | 21805 | 223 |
2490819 | 2490819 | 2022-05-10 | Bullitt | Kentucky | 21029 | 21805 | 223 |
2487562 | 2487562 | 2022-05-09 | Bullitt | Kentucky | 21029 | 21805 | 223 |
2484467 | 2484467 | 2022-05-08 | Vermilion | Louisiana | 22113 | 15312 | 223 |
2481209 | 2481209 | 2022-05-07 | Vermilion | Louisiana | 22113 | 15312 | 223 |
2477951 | 2477951 | 2022-05-06 | Vermilion | Louisiana | 22113 | 15312 | 223 |
2474693 | 2474693 | 2022-05-05 | Vermilion | Louisiana | 22113 | 15310 | 223 |
2471436 | 2471436 | 2022-05-04 | Vermilion | Louisiana | 22113 | 15305 | 223 |
2471864 | 2471864 | 2022-05-04 | Taney | Missouri | 29213 | 13307 | 223 |
2468180 | 2468180 | 2022-05-03 | Vermilion | Louisiana | 22113 | 15305 | 223 |
2468608 | 2468608 | 2022-05-03 | Taney | Missouri | 29213 | 13307 | 223 |
2464925 | 2464925 | 2022-05-02 | Vermilion | Louisiana | 22113 | 15303 | 223 |
2465352 | 2465352 | 2022-05-02 | Taney | Missouri | 29213 | 13307 | 223 |
2461669 | 2461669 | 2022-05-01 | Vermilion | Louisiana | 22113 | 15303 | 223 |
2462097 | 2462097 | 2022-05-01 | Taney | Missouri | 29213 | 13307 | 223 |
2458413 | 2458413 | 2022-04-30 | Vermilion | Louisiana | 22113 | 15303 | 223 |
2458841 | 2458841 | 2022-04-30 | Taney | Missouri | 29213 | 13307 | 223 |
2455157 | 2455157 | 2022-04-29 | Vermilion | Louisiana | 22113 | 15303 | 223 |
2455585 | 2455585 | 2022-04-29 | Taney | Missouri | 29213 | 13307 | 223 |
2451901 | 2451901 | 2022-04-28 | Vermilion | Louisiana | 22113 | 15302 | 223 |
2452329 | 2452329 | 2022-04-28 | Taney | Missouri | 29213 | 13307 | 223 |
2448645 | 2448645 | 2022-04-27 | Vermilion | Louisiana | 22113 | 15300 | 223 |
2449073 | 2449073 | 2022-04-27 | Taney | Missouri | 29213 | 13307 | 223 |
2445389 | 2445389 | 2022-04-26 | Vermilion | Louisiana | 22113 | 15298 | 223 |
2445509 | 2445509 | 2022-04-26 | Midland | Michigan | 26111 | 19090 | 223 |
2445816 | 2445816 | 2022-04-26 | Taney | Missouri | 29213 | 13307 | 223 |
2442133 | 2442133 | 2022-04-25 | Vermilion | Louisiana | 22113 | 15297 | 223 |
2442253 | 2442253 | 2022-04-25 | Midland | Michigan | 26111 | 19090 | 223 |
2442561 | 2442561 | 2022-04-25 | Taney | Missouri | 29213 | 13307 | 223 |
2438877 | 2438877 | 2022-04-24 | Vermilion | Louisiana | 22113 | 15297 | 223 |
2438997 | 2438997 | 2022-04-24 | Midland | Michigan | 26111 | 19090 | 223 |
2439305 | 2439305 | 2022-04-24 | Taney | Missouri | 29213 | 13307 | 223 |
2435621 | 2435621 | 2022-04-23 | Vermilion | Louisiana | 22113 | 15297 | 223 |
2435741 | 2435741 | 2022-04-23 | Midland | Michigan | 26111 | 19090 | 223 |
2436049 | 2436049 | 2022-04-23 | Taney | Missouri | 29213 | 13307 | 223 |
2432365 | 2432365 | 2022-04-22 | Vermilion | Louisiana | 22113 | 15297 | 223 |
2432485 | 2432485 | 2022-04-22 | Midland | Michigan | 26111 | 19090 | 223 |
2432793 | 2432793 | 2022-04-22 | Taney | Missouri | 29213 | 13307 | 223 |
2429109 | 2429109 | 2022-04-21 | Vermilion | Louisiana | 22113 | 15296 | 223 |
2429229 | 2429229 | 2022-04-21 | Midland | Michigan | 26111 | 19090 | 223 |
2429537 | 2429537 | 2022-04-21 | Taney | Missouri | 29213 | 13307 | 223 |
2425853 | 2425853 | 2022-04-20 | Vermilion | Louisiana | 22113 | 15296 | 223 |
2425973 | 2425973 | 2022-04-20 | Midland | Michigan | 26111 | 19090 | 223 |
2426281 | 2426281 | 2022-04-20 | Taney | Missouri | 29213 | 13307 | 223 |
2422597 | 2422597 | 2022-04-19 | Vermilion | Louisiana | 22113 | 15296 | 223 |
2422717 | 2422717 | 2022-04-19 | Midland | Michigan | 26111 | 19051 | 223 |
2423025 | 2423025 | 2022-04-19 | Taney | Missouri | 29213 | 13307 | 223 |
2419341 | 2419341 | 2022-04-18 | Vermilion | Louisiana | 22113 | 15295 | 223 |
2419461 | 2419461 | 2022-04-18 | Midland | Michigan | 26111 | 19051 | 223 |
2419768 | 2419768 | 2022-04-18 | Taney | Missouri | 29213 | 13307 | 223 |
2416085 | 2416085 | 2022-04-17 | Vermilion | Louisiana | 22113 | 15292 | 223 |
2416205 | 2416205 | 2022-04-17 | Midland | Michigan | 26111 | 19051 | 223 |
2416513 | 2416513 | 2022-04-17 | Taney | Missouri | 29213 | 13307 | 223 |
2412829 | 2412829 | 2022-04-16 | Vermilion | Louisiana | 22113 | 15292 | 223 |
2412949 | 2412949 | 2022-04-16 | Midland | Michigan | 26111 | 19051 | 223 |
2413257 | 2413257 | 2022-04-16 | Taney | Missouri | 29213 | 13307 | 223 |
2409573 | 2409573 | 2022-04-15 | Vermilion | Louisiana | 22113 | 15292 | 223 |
2409693 | 2409693 | 2022-04-15 | Midland | Michigan | 26111 | 19051 | 223 |
2410001 | 2410001 | 2022-04-15 | Taney | Missouri | 29213 | 13307 | 223 |
2406317 | 2406317 | 2022-04-14 | Vermilion | Louisiana | 22113 | 15292 | 223 |
2406437 | 2406437 | 2022-04-14 | Midland | Michigan | 26111 | 19051 | 223 |
2406745 | 2406745 | 2022-04-14 | Taney | Missouri | 29213 | 13307 | 223 |
2403061 | 2403061 | 2022-04-13 | Vermilion | Louisiana | 22113 | 15248 | 223 |
2403181 | 2403181 | 2022-04-13 | Midland | Michigan | 26111 | 19051 | 223 |
2403489 | 2403489 | 2022-04-13 | Taney | Missouri | 29213 | 13307 | 223 |
2399807 | 2399807 | 2022-04-12 | Vermilion | Louisiana | 22113 | 15248 | 223 |
2399927 | 2399927 | 2022-04-12 | Midland | Michigan | 26111 | 19021 | 223 |
2400234 | 2400234 | 2022-04-12 | Taney | Missouri | 29213 | 13307 | 223 |
2396551 | 2396551 | 2022-04-11 | Vermilion | Louisiana | 22113 | 15246 | 223 |
2396671 | 2396671 | 2022-04-11 | Midland | Michigan | 26111 | 19021 | 223 |
2396979 | 2396979 | 2022-04-11 | Taney | Missouri | 29213 | 13307 | 223 |
2393296 | 2393296 | 2022-04-10 | Vermilion | Louisiana | 22113 | 15244 | 223 |
2393416 | 2393416 | 2022-04-10 | Midland | Michigan | 26111 | 19021 | 223 |
2393724 | 2393724 | 2022-04-10 | Taney | Missouri | 29213 | 13307 | 223 |
2390040 | 2390040 | 2022-04-09 | Vermilion | Louisiana | 22113 | 15244 | 223 |
2390160 | 2390160 | 2022-04-09 | Midland | Michigan | 26111 | 19021 | 223 |
2390468 | 2390468 | 2022-04-09 | Taney | Missouri | 29213 | 13307 | 223 |
2386784 | 2386784 | 2022-04-08 | Vermilion | Louisiana | 22113 | 15244 | 223 |
2386904 | 2386904 | 2022-04-08 | Midland | Michigan | 26111 | 19021 | 223 |
2387212 | 2387212 | 2022-04-08 | Taney | Missouri | 29213 | 13307 | 223 |
2383529 | 2383529 | 2022-04-07 | Vermilion | Louisiana | 22113 | 15244 | 223 |
2383649 | 2383649 | 2022-04-07 | Midland | Michigan | 26111 | 19021 | 223 |
2383957 | 2383957 | 2022-04-07 | Taney | Missouri | 29213 | 13307 | 223 |
2380274 | 2380274 | 2022-04-06 | Vermilion | Louisiana | 22113 | 15243 | 223 |
2380394 | 2380394 | 2022-04-06 | Midland | Michigan | 26111 | 19021 | 223 |
2380702 | 2380702 | 2022-04-06 | Taney | Missouri | 29213 | 13307 | 223 |
2377019 | 2377019 | 2022-04-05 | Vermilion | Louisiana | 22113 | 15243 | 223 |
2377139 | 2377139 | 2022-04-05 | Midland | Michigan | 26111 | 19016 | 223 |
2377447 | 2377447 | 2022-04-05 | Taney | Missouri | 29213 | 13307 | 223 |
2373767 | 2373767 | 2022-04-04 | Vermilion | Louisiana | 22113 | 15242 | 223 |
2373887 | 2373887 | 2022-04-04 | Midland | Michigan | 26111 | 19016 | 223 |
2374194 | 2374194 | 2022-04-04 | Taney | Missouri | 29213 | 13307 | 223 |
2370514 | 2370514 | 2022-04-03 | Vermilion | Louisiana | 22113 | 15240 | 223 |
2370634 | 2370634 | 2022-04-03 | Midland | Michigan | 26111 | 19016 | 223 |
2370942 | 2370942 | 2022-04-03 | Taney | Missouri | 29213 | 13307 | 223 |
2367261 | 2367261 | 2022-04-02 | Vermilion | Louisiana | 22113 | 15240 | 223 |
2367381 | 2367381 | 2022-04-02 | Midland | Michigan | 26111 | 19016 | 223 |
2367689 | 2367689 | 2022-04-02 | Taney | Missouri | 29213 | 13307 | 223 |
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);