ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where deaths = 953 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Florida 15
- New York 15
- Tennessee 9
- Minnesota 6
- New Jersey 6
- Pennsylvania 6
- Texas 5
- Illinois 4
- Georgia 3
- Utah 3
- California 2
- Kansas 2
- Kentucky 2
- Louisiana 2
- Delaware 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- New Mexico 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498203 | 2498203 | 2022-05-12 | Orange | New York | 36071 | 111228 | 953 |
2494945 | 2494945 | 2022-05-11 | Orange | New York | 36071 | 111001 | 953 |
2491687 | 2491687 | 2022-05-10 | Orange | New York | 36071 | 110754 | 953 |
2488429 | 2488429 | 2022-05-09 | Orange | New York | 36071 | 110607 | 953 |
2485172 | 2485172 | 2022-05-08 | Orange | New York | 36071 | 110498 | 953 |
2481914 | 2481914 | 2022-05-07 | Orange | New York | 36071 | 110336 | 953 |
2478656 | 2478656 | 2022-05-06 | Orange | New York | 36071 | 110120 | 953 |
2475398 | 2475398 | 2022-05-05 | Orange | New York | 36071 | 109911 | 953 |
2472141 | 2472141 | 2022-05-04 | Orange | New York | 36071 | 109690 | 953 |
2468885 | 2468885 | 2022-05-03 | Orange | New York | 36071 | 109534 | 953 |
2465629 | 2465629 | 2022-05-02 | Orange | New York | 36071 | 109423 | 953 |
2462374 | 2462374 | 2022-05-01 | Orange | New York | 36071 | 109333 | 953 |
2459118 | 2459118 | 2022-04-30 | Orange | New York | 36071 | 109188 | 953 |
2455862 | 2455862 | 2022-04-29 | Orange | New York | 36071 | 109048 | 953 |
2452606 | 2452606 | 2022-04-28 | Orange | New York | 36071 | 108902 | 953 |
2351617 | 2351617 | 2022-03-28 | Gloucester | New Jersey | 34015 | 69537 | 953 |
2225629 | 2225629 | 2022-02-17 | Brazoria | Texas | 48039 | 92059 | 953 |
2215040 | 2215040 | 2022-02-14 | Somerset | New Jersey | 34035 | 65685 | 953 |
2205282 | 2205282 | 2022-02-11 | Somerset | New Jersey | 34035 | 65574 | 953 |
1969999 | 1969999 | 2021-12-01 | Kane | Illinois | 17089 | 73777 | 953 |
1966749 | 1966749 | 2021-11-30 | Kane | Illinois | 17089 | 73556 | 953 |
1963497 | 1963497 | 2021-11-29 | Kane | Illinois | 17089 | 73338 | 953 |
1932674 | 1932674 | 2021-11-19 | Westmoreland | Pennsylvania | 42129 | 49221 | 953 |
1922897 | 1922897 | 2021-11-16 | Lehigh | Pennsylvania | 42077 | 50486 | 953 |
1919648 | 1919648 | 2021-11-15 | Lehigh | Pennsylvania | 42077 | 50329 | 953 |
1916398 | 1916398 | 2021-11-14 | Lehigh | Pennsylvania | 42077 | 50254 | 953 |
1913148 | 1913148 | 2021-11-13 | Lehigh | Pennsylvania | 42077 | 50148 | 953 |
1841688 | 1841688 | 2021-10-22 | York | Pennsylvania | 42133 | 61118 | 953 |
1833989 | 1833989 | 2021-10-20 | Caddo | Louisiana | 22017 | 39194 | 953 |
1813747 | 1813747 | 2021-10-14 | St. Lucie | Florida | 12111 | 47161 | 953 |
1810498 | 1810498 | 2021-10-13 | St. Lucie | Florida | 12111 | 47161 | 953 |
1807249 | 1807249 | 2021-10-12 | St. Lucie | Florida | 12111 | 47161 | 953 |
1807851 | 1807851 | 2021-10-12 | Sedgwick | Kansas | 20173 | 78693 | 953 |
1803998 | 1803998 | 2021-10-11 | St. Lucie | Florida | 12111 | 47161 | 953 |
1804600 | 1804600 | 2021-10-11 | Sedgwick | Kansas | 20173 | 78693 | 953 |
1806304 | 1806304 | 2021-10-11 | Denton | Texas | 48121 | 103750 | 953 |
1800749 | 1800749 | 2021-10-10 | St. Lucie | Florida | 12111 | 47161 | 953 |
1803054 | 1803054 | 2021-10-10 | Denton | Texas | 48121 | 103345 | 953 |
1797500 | 1797500 | 2021-10-09 | St. Lucie | Florida | 12111 | 47161 | 953 |
1794251 | 1794251 | 2021-10-08 | St. Lucie | Florida | 12111 | 47161 | 953 |
1790815 | 1790815 | 2021-10-07 | Contra Costa | California | 6013 | 98276 | 953 |
1791003 | 1791003 | 2021-10-07 | St. Lucie | Florida | 12111 | 46783 | 953 |
1787754 | 1787754 | 2021-10-06 | St. Lucie | Florida | 12111 | 46783 | 953 |
1784505 | 1784505 | 2021-10-05 | St. Lucie | Florida | 12111 | 46783 | 953 |
1781256 | 1781256 | 2021-10-04 | St. Lucie | Florida | 12111 | 46783 | 953 |
1778006 | 1778006 | 2021-10-03 | St. Lucie | Florida | 12111 | 46783 | 953 |
1762767 | 1762767 | 2021-09-28 | Ramsey | Minnesota | 27123 | 59964 | 953 |
1759518 | 1759518 | 2021-09-27 | Ramsey | Minnesota | 27123 | 59611 | 953 |
1756270 | 1756270 | 2021-09-26 | Ramsey | Minnesota | 27123 | 59431 | 953 |
1753022 | 1753022 | 2021-09-25 | Ramsey | Minnesota | 27123 | 59431 | 953 |
1749774 | 1749774 | 2021-09-24 | Ramsey | Minnesota | 27123 | 59431 | 953 |
1742205 | 1742205 | 2021-09-22 | New Castle | Delaware | 10003 | 74576 | 953 |
1603348 | 1603348 | 2021-08-10 | Jefferson | Louisiana | 22051 | 58156 | 953 |
1598601 | 1598601 | 2021-08-08 | Salt Lake | Utah | 49035 | 161432 | 953 |
1595352 | 1595352 | 2021-08-07 | Salt Lake | Utah | 49035 | 161432 | 953 |
1592103 | 1592103 | 2021-08-06 | Salt Lake | Utah | 49035 | 161432 | 953 |
1517053 | 1517053 | 2021-07-14 | Davidson | Tennessee | 47037 | 99657 | 953 |
1513806 | 1513806 | 2021-07-13 | Davidson | Tennessee | 47037 | 99657 | 953 |
1510560 | 1510560 | 2021-07-12 | Davidson | Tennessee | 47037 | 99657 | 953 |
1507313 | 1507313 | 2021-07-11 | Davidson | Tennessee | 47037 | 99657 | 953 |
1504067 | 1504067 | 2021-07-10 | Davidson | Tennessee | 47037 | 99657 | 953 |
1500821 | 1500821 | 2021-07-09 | Davidson | Tennessee | 47037 | 99657 | 953 |
1497575 | 1497575 | 2021-07-08 | Davidson | Tennessee | 47037 | 99433 | 953 |
1406692 | 1406692 | 2021-06-10 | Davidson | Tennessee | 47037 | 99471 | 953 |
1402702 | 1402702 | 2021-06-09 | Mercer | New Jersey | 34021 | 34049 | 953 |
1402714 | 1402714 | 2021-06-09 | Bernalillo | New Mexico | 35001 | 58678 | 953 |
1403446 | 1403446 | 2021-06-09 | Davidson | Tennessee | 47037 | 99463 | 953 |
1399457 | 1399457 | 2021-06-08 | Mercer | New Jersey | 34021 | 34047 | 953 |
1248677 | 1248677 | 2021-04-23 | Lee | Florida | 12071 | 67687 | 953 |
1200038 | 1200038 | 2021-04-08 | DeKalb | Georgia | 13089 | 62581 | 953 |
1202044 | 1202044 | 2021-04-08 | Greenville | South Carolina | 45045 | 71012 | 953 |
1194314 | 1194314 | 2021-04-06 | Baltimore city | Maryland | 24510 | 45989 | 953 |
1122093 | 1122093 | 2021-03-15 | Cobb | Georgia | 13067 | 71980 | 953 |
1106495 | 1106495 | 2021-03-10 | Jefferson | Kentucky | 21111 | 75480 | 953 |
1103249 | 1103249 | 2021-03-09 | Jefferson | Kentucky | 21111 | 75367 | 953 |
1082951 | 1082951 | 2021-03-03 | Stanislaus | California | 6099 | 56433 | 953 |
1047711 | 1047711 | 2021-02-20 | Will | Illinois | 17197 | 64131 | 953 |
979301 | 979301 | 2021-01-30 | Fulton | Georgia | 13121 | 77182 | 953 |
969491 | 969491 | 2021-01-27 | Polk | Florida | 12105 | 48974 | 953 |
951440 | 951440 | 2021-01-21 | Camden | New Jersey | 34007 | 37755 | 953 |
824305 | 824305 | 2020-12-13 | Bristol | Massachusetts | 25005 | 26154 | 953 |
620017 | 620017 | 2020-10-11 | Hennepin | Minnesota | 27053 | 30218 | 953 |
592135 | 592135 | 2020-10-02 | Cameron | Texas | 48061 | 22917 | 953 |
588895 | 588895 | 2020-10-01 | Cameron | Texas | 48061 | 22917 | 953 |
422626 | 422626 | 2020-08-11 | Macomb | Michigan | 26099 | 10918 | 953 |
281143 | 281143 | 2020-06-28 | Miami-Dade | Florida | 12086 | 33713 | 953 |
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);