ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,261 rows where deaths = 227 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 111
- Indiana 86
- Ohio 86
- Georgia 80
- Alabama 66
- North Carolina 66
- Arizona 54
- Tennessee 52
- South Carolina 51
- Mississippi 50
- Louisiana 44
- California 43
- Pennsylvania 43
- Wisconsin 41
- Arkansas 40
- Virginia 34
- Colorado 33
- Michigan 27
- Minnesota 27
- New York 27
- Illinois 26
- Oklahoma 23
- Florida 19
- New Mexico 18
- Maine 13
- Maryland 11
- Missouri 11
- New Jersey 10
- Kentucky 9
- West Virginia 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502020 | 2502020 | 2022-05-13 | Georgetown | South Carolina | 45043 | 15958 | 227 |
2502308 | 2502308 | 2022-05-13 | Harrison | Texas | 48203 | 13370 | 227 |
2498762 | 2498762 | 2022-05-12 | Georgetown | South Carolina | 45043 | 15958 | 227 |
2499050 | 2499050 | 2022-05-12 | Harrison | Texas | 48203 | 13366 | 227 |
2495504 | 2495504 | 2022-05-11 | Georgetown | South Carolina | 45043 | 15958 | 227 |
2495792 | 2495792 | 2022-05-11 | Harrison | Texas | 48203 | 13362 | 227 |
2492246 | 2492246 | 2022-05-10 | Georgetown | South Carolina | 45043 | 15917 | 227 |
2492534 | 2492534 | 2022-05-10 | Harrison | Texas | 48203 | 13355 | 227 |
2488988 | 2488988 | 2022-05-09 | Georgetown | South Carolina | 45043 | 15917 | 227 |
2489276 | 2489276 | 2022-05-09 | Harrison | Texas | 48203 | 13349 | 227 |
2485731 | 2485731 | 2022-05-08 | Georgetown | South Carolina | 45043 | 15917 | 227 |
2486019 | 2486019 | 2022-05-08 | Harrison | Texas | 48203 | 13349 | 227 |
2482473 | 2482473 | 2022-05-07 | Georgetown | South Carolina | 45043 | 15917 | 227 |
2482761 | 2482761 | 2022-05-07 | Harrison | Texas | 48203 | 13347 | 227 |
2479215 | 2479215 | 2022-05-06 | Georgetown | South Carolina | 45043 | 15917 | 227 |
2479503 | 2479503 | 2022-05-06 | Harrison | Texas | 48203 | 13347 | 227 |
2475957 | 2475957 | 2022-05-05 | Georgetown | South Carolina | 45043 | 15917 | 227 |
2476245 | 2476245 | 2022-05-05 | Harrison | Texas | 48203 | 13345 | 227 |
2472700 | 2472700 | 2022-05-04 | Georgetown | South Carolina | 45043 | 15917 | 227 |
2472988 | 2472988 | 2022-05-04 | Harrison | Texas | 48203 | 13340 | 227 |
2469444 | 2469444 | 2022-05-03 | Georgetown | South Carolina | 45043 | 15917 | 227 |
2469732 | 2469732 | 2022-05-03 | Harrison | Texas | 48203 | 13339 | 227 |
2470042 | 2470042 | 2022-05-03 | Rockingham | Virginia | 51165 | 14569 | 227 |
2466476 | 2466476 | 2022-05-02 | Harrison | Texas | 48203 | 13339 | 227 |
2466786 | 2466786 | 2022-05-02 | Rockingham | Virginia | 51165 | 14566 | 227 |
2463221 | 2463221 | 2022-05-01 | Harrison | Texas | 48203 | 13339 | 227 |
2463531 | 2463531 | 2022-05-01 | Rockingham | Virginia | 51165 | 14554 | 227 |
2459965 | 2459965 | 2022-04-30 | Harrison | Texas | 48203 | 13339 | 227 |
2460275 | 2460275 | 2022-04-30 | Rockingham | Virginia | 51165 | 14554 | 227 |
2456709 | 2456709 | 2022-04-29 | Harrison | Texas | 48203 | 13339 | 227 |
2457019 | 2457019 | 2022-04-29 | Rockingham | Virginia | 51165 | 14554 | 227 |
2453453 | 2453453 | 2022-04-28 | Harrison | Texas | 48203 | 13338 | 227 |
2453763 | 2453763 | 2022-04-28 | Rockingham | Virginia | 51165 | 14544 | 227 |
2450197 | 2450197 | 2022-04-27 | Harrison | Texas | 48203 | 13337 | 227 |
2450507 | 2450507 | 2022-04-27 | Rockingham | Virginia | 51165 | 14537 | 227 |
2446940 | 2446940 | 2022-04-26 | Harrison | Texas | 48203 | 13337 | 227 |
2447250 | 2447250 | 2022-04-26 | Rockingham | Virginia | 51165 | 14535 | 227 |
2443995 | 2443995 | 2022-04-25 | Rockingham | Virginia | 51165 | 14529 | 227 |
2405555 | 2405555 | 2022-04-14 | Clarke | Georgia | 13059 | 29675 | 227 |
2403672 | 2403672 | 2022-04-13 | Merrimack | New Hampshire | 33013 | 32270 | 227 |
2403990 | 2403990 | 2022-04-13 | Knox | Ohio | 39083 | 13157 | 227 |
2404013 | 2404013 | 2022-04-13 | Pickaway | Ohio | 39129 | 17507 | 227 |
2398734 | 2398734 | 2022-04-12 | Santa Cruz | Arizona | 4023 | 16649 | 227 |
2400417 | 2400417 | 2022-04-12 | Merrimack | New Hampshire | 33013 | 32239 | 227 |
2400735 | 2400735 | 2022-04-12 | Knox | Ohio | 39083 | 13157 | 227 |
2400758 | 2400758 | 2022-04-12 | Pickaway | Ohio | 39129 | 17507 | 227 |
2395479 | 2395479 | 2022-04-11 | Santa Cruz | Arizona | 4023 | 16649 | 227 |
2397162 | 2397162 | 2022-04-11 | Merrimack | New Hampshire | 33013 | 32194 | 227 |
2397480 | 2397480 | 2022-04-11 | Knox | Ohio | 39083 | 13157 | 227 |
2397503 | 2397503 | 2022-04-11 | Pickaway | Ohio | 39129 | 17507 | 227 |
2392223 | 2392223 | 2022-04-10 | Santa Cruz | Arizona | 4023 | 16649 | 227 |
2393907 | 2393907 | 2022-04-10 | Merrimack | New Hampshire | 33013 | 32150 | 227 |
2394225 | 2394225 | 2022-04-10 | Knox | Ohio | 39083 | 13157 | 227 |
2394248 | 2394248 | 2022-04-10 | Pickaway | Ohio | 39129 | 17507 | 227 |
2388967 | 2388967 | 2022-04-09 | Santa Cruz | Arizona | 4023 | 16649 | 227 |
2390651 | 2390651 | 2022-04-09 | Merrimack | New Hampshire | 33013 | 32150 | 227 |
2390969 | 2390969 | 2022-04-09 | Knox | Ohio | 39083 | 13157 | 227 |
2390992 | 2390992 | 2022-04-09 | Pickaway | Ohio | 39129 | 17507 | 227 |
2385712 | 2385712 | 2022-04-08 | Santa Cruz | Arizona | 4023 | 16649 | 227 |
2387395 | 2387395 | 2022-04-08 | Merrimack | New Hampshire | 33013 | 32150 | 227 |
2387713 | 2387713 | 2022-04-08 | Knox | Ohio | 39083 | 13157 | 227 |
2387736 | 2387736 | 2022-04-08 | Pickaway | Ohio | 39129 | 17507 | 227 |
2382457 | 2382457 | 2022-04-07 | Santa Cruz | Arizona | 4023 | 16649 | 227 |
2384458 | 2384458 | 2022-04-07 | Knox | Ohio | 39083 | 13157 | 227 |
2384481 | 2384481 | 2022-04-07 | Pickaway | Ohio | 39129 | 17507 | 227 |
2379202 | 2379202 | 2022-04-06 | Santa Cruz | Arizona | 4023 | 16649 | 227 |
2381203 | 2381203 | 2022-04-06 | Knox | Ohio | 39083 | 13143 | 227 |
2375948 | 2375948 | 2022-04-05 | Santa Cruz | Arizona | 4023 | 16611 | 227 |
2377948 | 2377948 | 2022-04-05 | Knox | Ohio | 39083 | 13143 | 227 |
2372696 | 2372696 | 2022-04-04 | Santa Cruz | Arizona | 4023 | 16611 | 227 |
2373780 | 2373780 | 2022-04-04 | Kennebec | Maine | 23011 | 22882 | 227 |
2374694 | 2374694 | 2022-04-04 | Knox | Ohio | 39083 | 13143 | 227 |
2369443 | 2369443 | 2022-04-03 | Santa Cruz | Arizona | 4023 | 16611 | 227 |
2370527 | 2370527 | 2022-04-03 | Kennebec | Maine | 23011 | 22882 | 227 |
2371442 | 2371442 | 2022-04-03 | Knox | Ohio | 39083 | 13143 | 227 |
2366190 | 2366190 | 2022-04-02 | Santa Cruz | Arizona | 4023 | 16611 | 227 |
2367274 | 2367274 | 2022-04-02 | Kennebec | Maine | 23011 | 22882 | 227 |
2368189 | 2368189 | 2022-04-02 | Knox | Ohio | 39083 | 13143 | 227 |
2362937 | 2362937 | 2022-04-01 | Santa Cruz | Arizona | 4023 | 16611 | 227 |
2364021 | 2364021 | 2022-04-01 | Kennebec | Maine | 23011 | 22853 | 227 |
2364936 | 2364936 | 2022-04-01 | Knox | Ohio | 39083 | 13143 | 227 |
2359597 | 2359597 | 2022-03-31 | Dale | Alabama | 1045 | 12860 | 227 |
2359683 | 2359683 | 2022-03-31 | Santa Cruz | Arizona | 4023 | 16611 | 227 |
2360767 | 2360767 | 2022-03-31 | Kennebec | Maine | 23011 | 22808 | 227 |
2361683 | 2361683 | 2022-03-31 | Knox | Ohio | 39083 | 13143 | 227 |
2356343 | 2356343 | 2022-03-30 | Dale | Alabama | 1045 | 12858 | 227 |
2356429 | 2356429 | 2022-03-30 | Santa Cruz | Arizona | 4023 | 16611 | 227 |
2357513 | 2357513 | 2022-03-30 | Kennebec | Maine | 23011 | 22774 | 227 |
2358429 | 2358429 | 2022-03-30 | Knox | Ohio | 39083 | 13127 | 227 |
2353090 | 2353090 | 2022-03-29 | Dale | Alabama | 1045 | 12853 | 227 |
2353176 | 2353176 | 2022-03-29 | Santa Cruz | Arizona | 4023 | 16597 | 227 |
2354260 | 2354260 | 2022-03-29 | Kennebec | Maine | 23011 | 22730 | 227 |
2355175 | 2355175 | 2022-03-29 | Knox | Ohio | 39083 | 13127 | 227 |
2349835 | 2349835 | 2022-03-28 | Covington | Alabama | 1039 | 9300 | 227 |
2349838 | 2349838 | 2022-03-28 | Dale | Alabama | 1045 | 12852 | 227 |
2349924 | 2349924 | 2022-03-28 | Santa Cruz | Arizona | 4023 | 16597 | 227 |
2351008 | 2351008 | 2022-03-28 | Kennebec | Maine | 23011 | 22683 | 227 |
2351922 | 2351922 | 2022-03-28 | Knox | Ohio | 39083 | 13127 | 227 |
2346585 | 2346585 | 2022-03-27 | Dale | Alabama | 1045 | 12502 | 227 |
2346671 | 2346671 | 2022-03-27 | Santa Cruz | Arizona | 4023 | 16597 | 227 |
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);