ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where deaths = 791 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Mississippi 18
- Texas 14
- Utah 9
- Colorado 8
- Florida 8
- Minnesota 8
- New York 7
- California 6
- Oklahoma 6
- Pennsylvania 6
- Alabama 5
- Maryland 5
- New Jersey 5
- Washington 5
- Arizona 4
- Louisiana 4
- Massachusetts 4
- South Carolina 4
- Arkansas 3
- Georgia 2
- Kansas 2
- Missouri 2
- North Carolina 2
- Delaware 1
- Illinois 1
- Indiana 1
- Ohio 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501017 | 2501017 | 2022-05-13 | Hinds | Mississippi | 28049 | 52682 | 791 |
2502487 | 2502487 | 2022-05-13 | Utah | Utah | 49049 | 203286 | 791 |
2497759 | 2497759 | 2022-05-12 | Hinds | Mississippi | 28049 | 52682 | 791 |
2499229 | 2499229 | 2022-05-12 | Utah | Utah | 49049 | 203286 | 791 |
2494501 | 2494501 | 2022-05-11 | Hinds | Mississippi | 28049 | 52682 | 791 |
2495971 | 2495971 | 2022-05-11 | Utah | Utah | 49049 | 202690 | 791 |
2491243 | 2491243 | 2022-05-10 | Hinds | Mississippi | 28049 | 52682 | 791 |
2492713 | 2492713 | 2022-05-10 | Utah | Utah | 49049 | 202690 | 791 |
2487986 | 2487986 | 2022-05-09 | Hinds | Mississippi | 28049 | 52682 | 791 |
2489455 | 2489455 | 2022-05-09 | Utah | Utah | 49049 | 202690 | 791 |
2484728 | 2484728 | 2022-05-08 | Hinds | Mississippi | 28049 | 52485 | 791 |
2486197 | 2486197 | 2022-05-08 | Utah | Utah | 49049 | 202690 | 791 |
2481470 | 2481470 | 2022-05-07 | Hinds | Mississippi | 28049 | 52485 | 791 |
2482939 | 2482939 | 2022-05-07 | Utah | Utah | 49049 | 202690 | 791 |
2478212 | 2478212 | 2022-05-06 | Hinds | Mississippi | 28049 | 52485 | 791 |
2479681 | 2479681 | 2022-05-06 | Utah | Utah | 49049 | 202690 | 791 |
2474954 | 2474954 | 2022-05-05 | Hinds | Mississippi | 28049 | 52485 | 791 |
2476423 | 2476423 | 2022-05-05 | Utah | Utah | 49049 | 202690 | 791 |
2471697 | 2471697 | 2022-05-04 | Hinds | Mississippi | 28049 | 52485 | 791 |
2468441 | 2468441 | 2022-05-03 | Hinds | Mississippi | 28049 | 52485 | 791 |
2465186 | 2465186 | 2022-05-02 | Hinds | Mississippi | 28049 | 52485 | 791 |
2461930 | 2461930 | 2022-05-01 | Hinds | Mississippi | 28049 | 52391 | 791 |
2458674 | 2458674 | 2022-04-30 | Hinds | Mississippi | 28049 | 52391 | 791 |
2455418 | 2455418 | 2022-04-29 | Hinds | Mississippi | 28049 | 52391 | 791 |
2452162 | 2452162 | 2022-04-28 | Hinds | Mississippi | 28049 | 52391 | 791 |
2448906 | 2448906 | 2022-04-27 | Hinds | Mississippi | 28049 | 52391 | 791 |
2449347 | 2449347 | 2022-04-27 | Oneida | New York | 36065 | 56293 | 791 |
2445650 | 2445650 | 2022-04-26 | Hinds | Mississippi | 28049 | 52391 | 791 |
2378910 | 2378910 | 2022-04-05 | Clark | Washington | 53011 | 88099 | 791 |
2375656 | 2375656 | 2022-04-04 | Clark | Washington | 53011 | 88099 | 791 |
2372404 | 2372404 | 2022-04-03 | Clark | Washington | 53011 | 88066 | 791 |
2369151 | 2369151 | 2022-04-02 | Clark | Washington | 53011 | 88066 | 791 |
2365898 | 2365898 | 2022-04-01 | Clark | Washington | 53011 | 88066 | 791 |
2361517 | 2361517 | 2022-03-31 | Forsyth | North Carolina | 37067 | 92055 | 791 |
2358263 | 2358263 | 2022-03-30 | Forsyth | North Carolina | 37067 | 92039 | 791 |
2354397 | 2354397 | 2022-03-29 | Anoka | Minnesota | 27003 | 98180 | 791 |
2351145 | 2351145 | 2022-03-28 | Anoka | Minnesota | 27003 | 98131 | 791 |
2347892 | 2347892 | 2022-03-27 | Anoka | Minnesota | 27003 | 98110 | 791 |
2344639 | 2344639 | 2022-03-26 | Anoka | Minnesota | 27003 | 98110 | 791 |
2341386 | 2341386 | 2022-03-25 | Anoka | Minnesota | 27003 | 98110 | 791 |
2278371 | 2278371 | 2022-03-06 | Benton | Arkansas | 5007 | 66015 | 791 |
2275118 | 2275118 | 2022-03-05 | Benton | Arkansas | 5007 | 65983 | 791 |
2258968 | 2258968 | 2022-02-28 | San Francisco | California | 6075 | 131964 | 791 |
2183339 | 2183339 | 2022-02-04 | Bell | Texas | 48027 | 61687 | 791 |
2177959 | 2177959 | 2022-02-03 | Richmond | Georgia | 13245 | 48103 | 791 |
2152195 | 2152195 | 2022-01-26 | St. Joseph | Indiana | 18141 | 66914 | 791 |
2154290 | 2154290 | 2022-01-26 | Williamson | Texas | 48491 | 119058 | 791 |
2138507 | 2138507 | 2022-01-22 | Navajo | Arizona | 4017 | 32907 | 791 |
2137935 | 2137935 | 2022-01-21 | McLennan | Texas | 48309 | 50139 | 791 |
2134681 | 2134681 | 2022-01-20 | McLennan | Texas | 48309 | 49577 | 791 |
2131429 | 2131429 | 2022-01-19 | McLennan | Texas | 48309 | 49233 | 791 |
2108165 | 2108165 | 2022-01-12 | Dauphin | Pennsylvania | 42043 | 50236 | 791 |
2053912 | 2053912 | 2021-12-27 | Montgomery | Alabama | 1101 | 35898 | 791 |
2050662 | 2050662 | 2021-12-26 | Montgomery | Alabama | 1101 | 35791 | 791 |
2047412 | 2047412 | 2021-12-25 | Montgomery | Alabama | 1101 | 35701 | 791 |
2044162 | 2044162 | 2021-12-24 | Montgomery | Alabama | 1101 | 35526 | 791 |
2037812 | 2037812 | 2021-12-22 | Imperial | California | 6025 | 40603 | 791 |
2034562 | 2034562 | 2021-12-21 | Imperial | California | 6025 | 40555 | 791 |
2031312 | 2031312 | 2021-12-20 | Imperial | California | 6025 | 40524 | 791 |
1991310 | 1991310 | 2021-12-07 | Richland | South Carolina | 45079 | 70663 | 791 |
1971774 | 1971774 | 2021-12-01 | Anderson | South Carolina | 45007 | 37671 | 791 |
1966212 | 1966212 | 2021-11-30 | Yavapai | Arizona | 4025 | 32544 | 791 |
1968524 | 1968524 | 2021-11-30 | Anderson | South Carolina | 45007 | 37627 | 791 |
1964056 | 1964056 | 2021-11-29 | Anne Arundel | Maryland | 24003 | 55371 | 791 |
1965273 | 1965273 | 2021-11-29 | Anderson | South Carolina | 45007 | 37601 | 791 |
1960805 | 1960805 | 2021-11-28 | Anne Arundel | Maryland | 24003 | 55290 | 791 |
1957554 | 1957554 | 2021-11-27 | Anne Arundel | Maryland | 24003 | 55243 | 791 |
1948389 | 1948389 | 2021-11-24 | Atlantic | New Jersey | 34001 | 40894 | 791 |
1945138 | 1945138 | 2021-11-23 | Atlantic | New Jersey | 34001 | 40828 | 791 |
1941887 | 1941887 | 2021-11-22 | Atlantic | New Jersey | 34001 | 40754 | 791 |
1932225 | 1932225 | 2021-11-19 | Orange | New York | 36071 | 60576 | 791 |
1928974 | 1928974 | 2021-11-18 | Orange | New York | 36071 | 60416 | 791 |
1902975 | 1902975 | 2021-11-10 | Onondaga | New York | 36067 | 55282 | 791 |
1899725 | 1899725 | 2021-11-09 | Onondaga | New York | 36067 | 55074 | 791 |
1887683 | 1887683 | 2021-11-05 | Smith | Texas | 48423 | 36719 | 791 |
1775925 | 1775925 | 2021-10-02 | Kansas City | Missouri | 61384 | 791 | |
1772675 | 1772675 | 2021-10-01 | Kansas City | Missouri | 61253 | 791 | |
1654346 | 1654346 | 2021-08-26 | Pulaski | Arkansas | 5119 | 53220 | 791 |
1576313 | 1576313 | 2021-08-02 | Mohave | Arizona | 4015 | 25583 | 791 |
1573065 | 1573065 | 2021-08-01 | Mohave | Arizona | 4015 | 25527 | 791 |
1473286 | 1473286 | 2021-07-01 | Sedgwick | Kansas | 20173 | 58027 | 791 |
1470040 | 1470040 | 2021-06-30 | Sedgwick | Kansas | 20173 | 58027 | 791 |
1401177 | 1401177 | 2021-06-09 | Jefferson | Colorado | 8059 | 48303 | 791 |
1377712 | 1377712 | 2021-06-01 | Lubbock | Texas | 48303 | 49347 | 791 |
1374466 | 1374466 | 2021-05-31 | Lubbock | Texas | 48303 | 49319 | 791 |
1371221 | 1371221 | 2021-05-30 | Lubbock | Texas | 48303 | 49319 | 791 |
1367975 | 1367975 | 2021-05-29 | Lubbock | Texas | 48303 | 49319 | 791 |
1364729 | 1364729 | 2021-05-28 | Lubbock | Texas | 48303 | 49319 | 791 |
1361483 | 1361483 | 2021-05-27 | Lubbock | Texas | 48303 | 49318 | 791 |
1309038 | 1309038 | 2021-05-11 | Chester | Pennsylvania | 42029 | 39960 | 791 |
1281055 | 1281055 | 2021-05-03 | El Paso | Colorado | 8041 | 64565 | 791 |
1277808 | 1277808 | 2021-05-02 | El Paso | Colorado | 8041 | 64366 | 791 |
1274561 | 1274561 | 2021-05-01 | El Paso | Colorado | 8041 | 64179 | 791 |
1271314 | 1271314 | 2021-04-30 | El Paso | Colorado | 8041 | 63886 | 791 |
1264748 | 1264748 | 2021-04-28 | Contra Costa | California | 6013 | 67816 | 791 |
1255951 | 1255951 | 2021-04-25 | East Baton Rouge | Louisiana | 22033 | 38740 | 791 |
1252704 | 1252704 | 2021-04-24 | East Baton Rouge | Louisiana | 22033 | 38740 | 791 |
1249457 | 1249457 | 2021-04-23 | East Baton Rouge | Louisiana | 22033 | 38740 | 791 |
1246210 | 1246210 | 2021-04-22 | East Baton Rouge | Louisiana | 22033 | 38648 | 791 |
1219354 | 1219354 | 2021-04-14 | Denver | Colorado | 8031 | 67387 | 791 |
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);