ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where deaths = 952 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Florida 18
- New Jersey 12
- Tennessee 9
- Alabama 7
- Missouri 7
- New York 6
- Pennsylvania 6
- Kansas 5
- South Carolina 5
- Delaware 4
- Georgia 4
- Indiana 4
- North Carolina 4
- Ohio 4
- Texas 4
- Arkansas 3
- Colorado 3
- Michigan 3
- California 2
- Illinois 2
- Louisiana 2
- Arizona 1
- Connecticut 1
- District of Columbia 1
- Massachusetts 1
- Nebraska 1
- Nevada 1
- New Mexico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449350 | 2449350 | 2022-04-27 | Orange | New York | 36071 | 108749 | 952 |
2446093 | 2446093 | 2022-04-26 | Orange | New York | 36071 | 108618 | 952 |
2442838 | 2442838 | 2022-04-25 | Orange | New York | 36071 | 108525 | 952 |
2439582 | 2439582 | 2022-04-24 | Orange | New York | 36071 | 108436 | 952 |
2395415 | 2395415 | 2022-04-11 | Madison | Alabama | 1089 | 89251 | 952 |
2392159 | 2392159 | 2022-04-10 | Madison | Alabama | 1089 | 89192 | 952 |
2388903 | 2388903 | 2022-04-09 | Madison | Alabama | 1089 | 89192 | 952 |
2385648 | 2385648 | 2022-04-08 | Madison | Alabama | 1089 | 89192 | 952 |
2382393 | 2382393 | 2022-04-07 | Madison | Alabama | 1089 | 89157 | 952 |
2379138 | 2379138 | 2022-04-06 | Madison | Alabama | 1089 | 89146 | 952 |
2375884 | 2375884 | 2022-04-05 | Madison | Alabama | 1089 | 89128 | 952 |
2376261 | 2376261 | 2022-04-05 | Clayton | Georgia | 13063 | 63922 | 952 |
2373009 | 2373009 | 2022-04-04 | Clayton | Georgia | 13063 | 63914 | 952 |
2348365 | 2348365 | 2022-03-27 | Gloucester | New Jersey | 34015 | 69528 | 952 |
2345112 | 2345112 | 2022-03-26 | Gloucester | New Jersey | 34015 | 69518 | 952 |
2341859 | 2341859 | 2022-03-25 | Gloucester | New Jersey | 34015 | 69505 | 952 |
2335840 | 2335840 | 2022-03-23 | Dauphin | Pennsylvania | 42043 | 58948 | 952 |
2332586 | 2332586 | 2022-03-22 | Dauphin | Pennsylvania | 42043 | 58940 | 952 |
2329333 | 2329333 | 2022-03-21 | Dauphin | Pennsylvania | 42043 | 58937 | 952 |
2326081 | 2326081 | 2022-03-20 | Dauphin | Pennsylvania | 42043 | 58934 | 952 |
2320124 | 2320124 | 2022-03-18 | Smith | Texas | 48423 | 45307 | 952 |
2316870 | 2316870 | 2022-03-17 | Smith | Texas | 48423 | 45304 | 952 |
2222378 | 2222378 | 2022-02-16 | Brazoria | Texas | 48039 | 91985 | 952 |
2202029 | 2202029 | 2022-02-10 | Somerset | New Jersey | 34035 | 65474 | 952 |
2171313 | 2171313 | 2022-02-01 | Osceola | Florida | 12097 | 107029 | 952 |
2168060 | 2168060 | 2022-01-31 | Osceola | Florida | 12097 | 107029 | 952 |
2164805 | 2164805 | 2022-01-30 | Osceola | Florida | 12097 | 107029 | 952 |
2161550 | 2161550 | 2022-01-29 | Osceola | Florida | 12097 | 107029 | 952 |
2158294 | 2158294 | 2022-01-28 | Osceola | Florida | 12097 | 107029 | 952 |
2155041 | 2155041 | 2022-01-27 | Osceola | Florida | 12097 | 103689 | 952 |
2151788 | 2151788 | 2022-01-26 | Osceola | Florida | 12097 | 103689 | 952 |
2148536 | 2148536 | 2022-01-25 | Osceola | Florida | 12097 | 103689 | 952 |
2145284 | 2145284 | 2022-01-24 | Osceola | Florida | 12097 | 103689 | 952 |
2146792 | 2146792 | 2022-01-24 | Onondaga | New York | 36067 | 98669 | 952 |
2142029 | 2142029 | 2022-01-23 | Osceola | Florida | 12097 | 103689 | 952 |
2138774 | 2138774 | 2022-01-22 | Osceola | Florida | 12097 | 103689 | 952 |
2135518 | 2135518 | 2022-01-21 | Osceola | Florida | 12097 | 103689 | 952 |
2132266 | 2132266 | 2022-01-20 | Osceola | Florida | 12097 | 98133 | 952 |
2134457 | 2134457 | 2022-01-20 | Hamilton | Tennessee | 47065 | 82227 | 952 |
2129013 | 2129013 | 2022-01-19 | Osceola | Florida | 12097 | 98133 | 952 |
2104325 | 2104325 | 2022-01-11 | Douglas | Nebraska | 31055 | 115420 | 952 |
2031283 | 2031283 | 2021-12-20 | Pulaski | Arkansas | 5119 | 61491 | 952 |
2028032 | 2028032 | 2021-12-19 | Pulaski | Arkansas | 5119 | 61443 | 952 |
2028568 | 2028568 | 2021-12-19 | Allen | Indiana | 18003 | 71387 | 952 |
2024781 | 2024781 | 2021-12-18 | Pulaski | Arkansas | 5119 | 61398 | 952 |
2025317 | 2025317 | 2021-12-18 | Allen | Indiana | 18003 | 71387 | 952 |
2022066 | 2022066 | 2021-12-17 | Allen | Indiana | 18003 | 71387 | 952 |
1987152 | 1987152 | 2021-12-06 | Kansas City | Missouri | 69178 | 952 | |
1983902 | 1983902 | 2021-12-05 | Kansas City | Missouri | 68811 | 952 | |
1980652 | 1980652 | 2021-12-04 | Kansas City | Missouri | 68721 | 952 | |
1977402 | 1977402 | 2021-12-03 | Kansas City | Missouri | 68146 | 952 | |
1974152 | 1974152 | 2021-12-02 | Kansas City | Missouri | 68146 | 952 | |
1970903 | 1970903 | 2021-12-01 | Kansas City | Missouri | 67899 | 952 | |
1938394 | 1938394 | 2021-11-21 | Kansas City | Missouri | 66517 | 952 | |
1925623 | 1925623 | 2021-11-17 | Washoe | Nevada | 32031 | 67472 | 952 |
1915036 | 1915036 | 2021-11-14 | Johnson | Kansas | 20091 | 79838 | 952 |
1911786 | 1911786 | 2021-11-13 | Johnson | Kansas | 20091 | 79838 | 952 |
1908537 | 1908537 | 2021-11-12 | Johnson | Kansas | 20091 | 79838 | 952 |
1905288 | 1905288 | 2021-11-11 | Johnson | Kansas | 20091 | 79476 | 952 |
1902038 | 1902038 | 2021-11-10 | Johnson | Kansas | 20091 | 79476 | 952 |
1891593 | 1891593 | 2021-11-07 | Arapahoe | Colorado | 8005 | 84029 | 952 |
1888343 | 1888343 | 2021-11-06 | Arapahoe | Colorado | 8005 | 84030 | 952 |
1881858 | 1881858 | 2021-11-04 | Denver | Colorado | 8031 | 93866 | 952 |
1883392 | 1883392 | 2021-11-04 | Burlington | New Jersey | 34005 | 55267 | 952 |
1880143 | 1880143 | 2021-11-03 | Burlington | New Jersey | 34005 | 55140 | 952 |
1876894 | 1876894 | 2021-11-02 | Burlington | New Jersey | 34005 | 55080 | 952 |
1793974 | 1793974 | 2021-10-08 | Mohave | Arizona | 4015 | 31930 | 952 |
1738956 | 1738956 | 2021-09-21 | New Castle | Delaware | 10003 | 74466 | 952 |
1739794 | 1739794 | 2021-09-21 | Orleans | Louisiana | 22071 | 45386 | 952 |
1735707 | 1735707 | 2021-09-20 | New Castle | Delaware | 10003 | 74331 | 952 |
1732457 | 1732457 | 2021-09-19 | New Castle | Delaware | 10003 | 74119 | 952 |
1729207 | 1729207 | 2021-09-18 | New Castle | Delaware | 10003 | 73907 | 952 |
1725994 | 1725994 | 2021-09-17 | Lake | Florida | 12069 | 50713 | 952 |
1722745 | 1722745 | 2021-09-16 | Lake | Florida | 12069 | 49249 | 952 |
1719496 | 1719496 | 2021-09-15 | Lake | Florida | 12069 | 49249 | 952 |
1716248 | 1716248 | 2021-09-14 | Lake | Florida | 12069 | 49249 | 952 |
1692046 | 1692046 | 2021-09-06 | Stark | Ohio | 39151 | 37769 | 952 |
1688797 | 1688797 | 2021-09-05 | Stark | Ohio | 39151 | 37566 | 952 |
1685547 | 1685547 | 2021-09-04 | Stark | Ohio | 39151 | 37375 | 952 |
1682296 | 1682296 | 2021-09-03 | Stark | Ohio | 39151 | 37210 | 952 |
1626076 | 1626076 | 2021-08-17 | East Baton Rouge | Louisiana | 22033 | 54618 | 952 |
1494328 | 1494328 | 2021-07-07 | Davidson | Tennessee | 47037 | 99433 | 952 |
1491081 | 1491081 | 2021-07-06 | Davidson | Tennessee | 47037 | 99433 | 952 |
1399469 | 1399469 | 2021-06-08 | Bernalillo | New Mexico | 35001 | 58652 | 952 |
1396211 | 1396211 | 2021-06-07 | Mercer | New Jersey | 34021 | 34034 | 952 |
1396956 | 1396956 | 2021-06-07 | Davidson | Tennessee | 47037 | 99431 | 952 |
1392431 | 1392431 | 2021-06-06 | Genesee | Michigan | 26049 | 41643 | 952 |
1392965 | 1392965 | 2021-06-06 | Mercer | New Jersey | 34021 | 34028 | 952 |
1393709 | 1393709 | 2021-06-06 | Davidson | Tennessee | 47037 | 99417 | 952 |
1389186 | 1389186 | 2021-06-05 | Genesee | Michigan | 26049 | 41643 | 952 |
1389720 | 1389720 | 2021-06-05 | Mercer | New Jersey | 34021 | 34027 | 952 |
1390464 | 1390464 | 2021-06-05 | Davidson | Tennessee | 47037 | 99417 | 952 |
1386475 | 1386475 | 2021-06-04 | Mercer | New Jersey | 34021 | 34022 | 952 |
1387219 | 1387219 | 2021-06-04 | Davidson | Tennessee | 47037 | 99417 | 952 |
1383230 | 1383230 | 2021-06-03 | Mercer | New Jersey | 34021 | 34003 | 952 |
1383974 | 1383974 | 2021-06-03 | Davidson | Tennessee | 47037 | 99392 | 952 |
1380728 | 1380728 | 2021-06-02 | Davidson | Tennessee | 47037 | 99350 | 952 |
1324957 | 1324957 | 2021-05-16 | Mecklenburg | North Carolina | 37119 | 112120 | 952 |
1321711 | 1321711 | 2021-05-15 | Mecklenburg | North Carolina | 37119 | 112120 | 952 |
1318465 | 1318465 | 2021-05-14 | Mecklenburg | North Carolina | 37119 | 112120 | 952 |
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);