ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where deaths = 948 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Illinois 12
- Alabama 11
- New York 10
- Ohio 10
- Tennessee 9
- Iowa 7
- Missouri 7
- Pennsylvania 7
- Florida 6
- Georgia 5
- New Jersey 5
- South Carolina 4
- Colorado 3
- Maryland 3
- Texas 3
- Washington 3
- Arizona 2
- California 1
- Hawaii 1
- Indiana 1
- Massachusetts 1
- Michigan 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499625 | 2499625 | 2022-05-13 | Montgomery | Alabama | 1101 | 55316 | 948 |
2496367 | 2496367 | 2022-05-12 | Montgomery | Alabama | 1101 | 55297 | 948 |
2493109 | 2493109 | 2022-05-11 | Montgomery | Alabama | 1101 | 55266 | 948 |
2489851 | 2489851 | 2022-05-10 | Montgomery | Alabama | 1101 | 55239 | 948 |
2486594 | 2486594 | 2022-05-09 | Montgomery | Alabama | 1101 | 55203 | 948 |
2483336 | 2483336 | 2022-05-08 | Montgomery | Alabama | 1101 | 55168 | 948 |
2480078 | 2480078 | 2022-05-07 | Montgomery | Alabama | 1101 | 55168 | 948 |
2476820 | 2476820 | 2022-05-06 | Montgomery | Alabama | 1101 | 55168 | 948 |
2473562 | 2473562 | 2022-05-05 | Montgomery | Alabama | 1101 | 55157 | 948 |
2470305 | 2470305 | 2022-05-04 | Montgomery | Alabama | 1101 | 55146 | 948 |
2467049 | 2467049 | 2022-05-03 | Montgomery | Alabama | 1101 | 55127 | 948 |
2420045 | 2420045 | 2022-04-18 | Orange | New York | 36071 | 107799 | 948 |
2416790 | 2416790 | 2022-04-17 | Orange | New York | 36071 | 107724 | 948 |
2413534 | 2413534 | 2022-04-16 | Orange | New York | 36071 | 107644 | 948 |
2410278 | 2410278 | 2022-04-15 | Orange | New York | 36071 | 107565 | 948 |
2407022 | 2407022 | 2022-04-14 | Orange | New York | 36071 | 107477 | 948 |
2403766 | 2403766 | 2022-04-13 | Orange | New York | 36071 | 107374 | 948 |
2400511 | 2400511 | 2022-04-12 | Orange | New York | 36071 | 107277 | 948 |
2397256 | 2397256 | 2022-04-11 | Orange | New York | 36071 | 107208 | 948 |
2369756 | 2369756 | 2022-04-03 | Clayton | Georgia | 13063 | 63885 | 948 |
2366503 | 2366503 | 2022-04-02 | Clayton | Georgia | 13063 | 63885 | 948 |
2363250 | 2363250 | 2022-04-01 | Clayton | Georgia | 13063 | 63885 | 948 |
2316320 | 2316320 | 2022-03-17 | Dauphin | Pennsylvania | 42043 | 58920 | 948 |
2313067 | 2313067 | 2022-03-16 | Dauphin | Pennsylvania | 42043 | 58913 | 948 |
2223536 | 2223536 | 2022-02-17 | Honolulu | Hawaii | 15003 | 161942 | 948 |
2171815 | 2171815 | 2022-02-01 | Polk | Iowa | 19153 | 113009 | 948 |
2174035 | 2174035 | 2022-02-01 | Snohomish | Washington | 53061 | 139881 | 948 |
2168562 | 2168562 | 2022-01-31 | Polk | Iowa | 19153 | 113009 | 948 |
2170783 | 2170783 | 2022-01-31 | Snohomish | Washington | 53061 | 139881 | 948 |
2165307 | 2165307 | 2022-01-30 | Polk | Iowa | 19153 | 113009 | 948 |
2162052 | 2162052 | 2022-01-29 | Polk | Iowa | 19153 | 113009 | 948 |
2158797 | 2158797 | 2022-01-28 | Polk | Iowa | 19153 | 113009 | 948 |
2155543 | 2155543 | 2022-01-27 | Polk | Iowa | 19153 | 113009 | 948 |
2155875 | 2155875 | 2022-01-27 | Anne Arundel | Maryland | 24003 | 83689 | 948 |
2152290 | 2152290 | 2022-01-26 | Polk | Iowa | 19153 | 113009 | 948 |
2143538 | 2143538 | 2022-01-23 | Onondaga | New York | 36067 | 98269 | 948 |
2124580 | 2124580 | 2022-01-17 | Horry | South Carolina | 45051 | 76420 | 948 |
2121328 | 2121328 | 2022-01-16 | Horry | South Carolina | 45051 | 76420 | 948 |
2118076 | 2118076 | 2022-01-15 | Horry | South Carolina | 45051 | 76420 | 948 |
2114825 | 2114825 | 2022-01-14 | Horry | South Carolina | 45051 | 76420 | 948 |
2060469 | 2060469 | 2021-12-29 | Yavapai | Arizona | 4025 | 36081 | 948 |
2056141 | 2056141 | 2021-12-27 | Chester | Pennsylvania | 42029 | 63789 | 948 |
2052892 | 2052892 | 2021-12-26 | Chester | Pennsylvania | 42029 | 63518 | 948 |
2049642 | 2049642 | 2021-12-25 | Chester | Pennsylvania | 42029 | 63050 | 948 |
2046392 | 2046392 | 2021-12-24 | Chester | Pennsylvania | 42029 | 62638 | 948 |
2014969 | 2014969 | 2021-12-15 | Yuma | Arizona | 4027 | 43487 | 948 |
1973296 | 1973296 | 2021-12-02 | Unknown | Illinois | 0 | 948 | |
1964401 | 1964401 | 2021-11-29 | Kansas City | Missouri | 67493 | 948 | |
1961150 | 1961150 | 2021-11-28 | Kansas City | Missouri | 66830 | 948 | |
1957899 | 1957899 | 2021-11-27 | Kansas City | Missouri | 66830 | 948 | |
1954648 | 1954648 | 2021-11-26 | Kansas City | Missouri | 66830 | 948 | |
1951397 | 1951397 | 2021-11-25 | Kansas City | Missouri | 66830 | 948 | |
1948146 | 1948146 | 2021-11-24 | Kansas City | Missouri | 66830 | 948 | |
1944895 | 1944895 | 2021-11-23 | Kansas City | Missouri | 66683 | 948 | |
1937491 | 1937491 | 2021-11-21 | Kane | Illinois | 17089 | 71661 | 948 |
1934241 | 1934241 | 2021-11-20 | Kane | Illinois | 17089 | 71661 | 948 |
1930990 | 1930990 | 2021-11-19 | Kane | Illinois | 17089 | 71661 | 948 |
1927739 | 1927739 | 2021-11-18 | Kane | Illinois | 17089 | 71425 | 948 |
1924489 | 1924489 | 2021-11-17 | Kane | Illinois | 17089 | 71207 | 948 |
1921240 | 1921240 | 2021-11-16 | Kane | Illinois | 17089 | 70975 | 948 |
1917990 | 1917990 | 2021-11-15 | Kane | Illinois | 17089 | 70856 | 948 |
1914740 | 1914740 | 2021-11-14 | Kane | Illinois | 17089 | 70510 | 948 |
1911490 | 1911490 | 2021-11-13 | Kane | Illinois | 17089 | 70510 | 948 |
1908241 | 1908241 | 2021-11-12 | Kane | Illinois | 17089 | 70510 | 948 |
1904621 | 1904621 | 2021-11-11 | Jefferson | Colorado | 8059 | 67533 | 948 |
1883706 | 1883706 | 2021-11-04 | Lucas | Ohio | 39095 | 57801 | 948 |
1878595 | 1878595 | 2021-11-03 | Arapahoe | Colorado | 8005 | 82858 | 948 |
1880457 | 1880457 | 2021-11-03 | Lucas | Ohio | 39095 | 57646 | 948 |
1875346 | 1875346 | 2021-11-02 | Arapahoe | Colorado | 8005 | 82858 | 948 |
1877208 | 1877208 | 2021-11-02 | Lucas | Ohio | 39095 | 57484 | 948 |
1870396 | 1870396 | 2021-10-31 | Burlington | New Jersey | 34005 | 54959 | 948 |
1867147 | 1867147 | 2021-10-30 | Burlington | New Jersey | 34005 | 54903 | 948 |
1863898 | 1863898 | 2021-10-29 | Burlington | New Jersey | 34005 | 54811 | 948 |
1860649 | 1860649 | 2021-10-28 | Burlington | New Jersey | 34005 | 54710 | 948 |
1857400 | 1857400 | 2021-10-27 | Burlington | New Jersey | 34005 | 54570 | 948 |
1796646 | 1796646 | 2021-10-08 | Lubbock | Texas | 48303 | 64463 | 948 |
1718559 | 1718559 | 2021-09-14 | Collin | Texas | 48085 | 118184 | 948 |
1669303 | 1669303 | 2021-08-30 | Stark | Ohio | 39151 | 36509 | 948 |
1666056 | 1666056 | 2021-08-29 | Stark | Ohio | 39151 | 36390 | 948 |
1662808 | 1662808 | 2021-08-28 | Stark | Ohio | 39151 | 36249 | 948 |
1659560 | 1659560 | 2021-08-27 | Stark | Ohio | 39151 | 36043 | 948 |
1656311 | 1656311 | 2021-08-26 | Stark | Ohio | 39151 | 35911 | 948 |
1653064 | 1653064 | 2021-08-25 | Stark | Ohio | 39151 | 35764 | 948 |
1649817 | 1649817 | 2021-08-24 | Stark | Ohio | 39151 | 35648 | 948 |
1452132 | 1452132 | 2021-06-24 | Davidson | Tennessee | 47037 | 99527 | 948 |
1445641 | 1445641 | 2021-06-22 | Davidson | Tennessee | 47037 | 99527 | 948 |
1442396 | 1442396 | 2021-06-21 | Davidson | Tennessee | 47037 | 99527 | 948 |
1439151 | 1439151 | 2021-06-20 | Davidson | Tennessee | 47037 | 99527 | 948 |
1435904 | 1435904 | 2021-06-19 | Davidson | Tennessee | 47037 | 99527 | 948 |
1432657 | 1432657 | 2021-06-18 | Davidson | Tennessee | 47037 | 99527 | 948 |
1382696 | 1382696 | 2021-06-03 | Genesee | Michigan | 26049 | 41619 | 948 |
1361254 | 1361254 | 2021-05-27 | Davidson | Tennessee | 47037 | 99242 | 948 |
1358008 | 1358008 | 2021-05-26 | Davidson | Tennessee | 47037 | 99209 | 948 |
1354762 | 1354762 | 2021-05-25 | Davidson | Tennessee | 47037 | 99176 | 948 |
1258424 | 1258424 | 2021-04-26 | Marion | Florida | 12083 | 30479 | 948 |
1255177 | 1255177 | 2021-04-25 | Marion | Florida | 12083 | 30438 | 948 |
1251930 | 1251930 | 2021-04-24 | Marion | Florida | 12083 | 30397 | 948 |
1248683 | 1248683 | 2021-04-23 | Marion | Florida | 12083 | 30322 | 948 |
1245436 | 1245436 | 2021-04-22 | Marion | Florida | 12083 | 30234 | 948 |
1242189 | 1242189 | 2021-04-21 | Marion | Florida | 12083 | 30173 | 948 |
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);