ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where deaths = 903 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Pennsylvania 14
- Arizona 13
- Colorado 8
- New Jersey 7
- Ohio 6
- Florida 4
- South Carolina 4
- Texas 4
- Georgia 3
- Michigan 3
- New Hampshire 3
- Tennessee 3
- Illinois 2
- Louisiana 2
- Massachusetts 2
- Minnesota 2
- Nebraska 2
- Alabama 1
- Connecticut 1
- Delaware 1
- Idaho 1
- Maryland 1
- Missouri 1
- New York 1
- North Carolina 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393906 | 2393906 | 2022-04-10 | Hillsborough | New Hampshire | 33011 | 97391 | 903 |
2390650 | 2390650 | 2022-04-09 | Hillsborough | New Hampshire | 33011 | 97391 | 903 |
2387394 | 2387394 | 2022-04-08 | Hillsborough | New Hampshire | 33011 | 97391 | 903 |
2359311 | 2359311 | 2022-03-30 | Henrico | Virginia | 51087 | 64128 | 903 |
2270640 | 2270640 | 2022-03-03 | Trumbull | Ohio | 39155 | 41247 | 903 |
2267388 | 2267388 | 2022-03-02 | Trumbull | Ohio | 39155 | 41232 | 903 |
2264135 | 2264135 | 2022-03-01 | Trumbull | Ohio | 39155 | 41219 | 903 |
2225821 | 2225821 | 2022-02-17 | Smith | Texas | 48423 | 44937 | 903 |
2132453 | 2132453 | 2022-01-20 | Ada | Idaho | 16001 | 97338 | 903 |
2091934 | 2091934 | 2022-01-07 | Northampton | Pennsylvania | 42095 | 64193 | 903 |
2087915 | 2087915 | 2022-01-06 | Jackson | Missouri | 29095 | 71820 | 903 |
2058809 | 2058809 | 2021-12-28 | Douglas | Nebraska | 31055 | 101355 | 903 |
2055560 | 2055560 | 2021-12-27 | Douglas | Nebraska | 31055 | 100863 | 903 |
2052422 | 2052422 | 2021-12-26 | Somerset | New Jersey | 34035 | 42720 | 903 |
1965132 | 1965132 | 2021-11-29 | Chester | Pennsylvania | 42029 | 55228 | 903 |
1961880 | 1961880 | 2021-11-28 | Chester | Pennsylvania | 42029 | 55089 | 903 |
1962043 | 1962043 | 2021-11-28 | Horry | South Carolina | 45051 | 63450 | 903 |
1958629 | 1958629 | 2021-11-27 | Chester | Pennsylvania | 42029 | 54981 | 903 |
1958792 | 1958792 | 2021-11-27 | Horry | South Carolina | 45051 | 63450 | 903 |
1955378 | 1955378 | 2021-11-26 | Chester | Pennsylvania | 42029 | 54840 | 903 |
1955541 | 1955541 | 2021-11-26 | Horry | South Carolina | 45051 | 63450 | 903 |
1952127 | 1952127 | 2021-11-25 | Chester | Pennsylvania | 42029 | 54713 | 903 |
1881842 | 1881842 | 2021-11-04 | Adams | Colorado | 8001 | 78897 | 903 |
1874179 | 1874179 | 2021-11-01 | Westmoreland | Pennsylvania | 42129 | 45286 | 903 |
1870930 | 1870930 | 2021-10-31 | Westmoreland | Pennsylvania | 42129 | 45286 | 903 |
1849217 | 1849217 | 2021-10-25 | Yuma | Arizona | 4027 | 41379 | 903 |
1845967 | 1845967 | 2021-10-24 | Yuma | Arizona | 4027 | 41379 | 903 |
1846132 | 1846132 | 2021-10-24 | Jefferson | Colorado | 8059 | 62065 | 903 |
1842717 | 1842717 | 2021-10-23 | Yuma | Arizona | 4027 | 41347 | 903 |
1842882 | 1842882 | 2021-10-23 | Jefferson | Colorado | 8059 | 62065 | 903 |
1839467 | 1839467 | 2021-10-22 | Yuma | Arizona | 4027 | 41309 | 903 |
1839632 | 1839632 | 2021-10-22 | Jefferson | Colorado | 8059 | 62065 | 903 |
1836218 | 1836218 | 2021-10-21 | Yuma | Arizona | 4027 | 41281 | 903 |
1836383 | 1836383 | 2021-10-21 | Jefferson | Colorado | 8059 | 61832 | 903 |
1832969 | 1832969 | 2021-10-20 | Yuma | Arizona | 4027 | 41254 | 903 |
1833134 | 1833134 | 2021-10-20 | Jefferson | Colorado | 8059 | 61579 | 903 |
1829720 | 1829720 | 2021-10-19 | Yuma | Arizona | 4027 | 41251 | 903 |
1832185 | 1832185 | 2021-10-19 | Knox | Tennessee | 47093 | 77772 | 903 |
1825416 | 1825416 | 2021-10-17 | Luzerne | Pennsylvania | 42079 | 39672 | 903 |
1822167 | 1822167 | 2021-10-16 | Luzerne | Pennsylvania | 42079 | 39515 | 903 |
1818918 | 1818918 | 2021-10-15 | Luzerne | Pennsylvania | 42079 | 39367 | 903 |
1790869 | 1790869 | 2021-10-07 | Arapahoe | Colorado | 8005 | 76621 | 903 |
1793324 | 1793324 | 2021-10-07 | Fort Bend | Texas | 48157 | 96984 | 903 |
1790075 | 1790075 | 2021-10-06 | Fort Bend | Texas | 48157 | 96752 | 903 |
1767718 | 1767718 | 2021-09-29 | Spokane | Washington | 53063 | 66046 | 903 |
1745781 | 1745781 | 2021-09-23 | Kane | Illinois | 17089 | 65993 | 903 |
1738741 | 1738741 | 2021-09-21 | Mohave | Arizona | 4015 | 30429 | 903 |
1681952 | 1681952 | 2021-09-03 | Burlington | New Jersey | 34005 | 48852 | 903 |
1678704 | 1678704 | 2021-09-02 | Burlington | New Jersey | 34005 | 48737 | 903 |
1673081 | 1673081 | 2021-08-31 | Collin | Texas | 48085 | 109432 | 903 |
1605500 | 1605500 | 2021-08-11 | Mobile | Alabama | 1097 | 54736 | 903 |
1600090 | 1600090 | 2021-08-09 | East Baton Rouge | Louisiana | 22033 | 51423 | 903 |
1566784 | 1566784 | 2021-07-30 | New Castle | Delaware | 10003 | 65889 | 903 |
1563482 | 1563482 | 2021-07-29 | El Paso | Colorado | 8041 | 76067 | 903 |
1470445 | 1470445 | 2021-06-30 | Ramsey | Minnesota | 27123 | 52573 | 903 |
1449694 | 1449694 | 2021-06-24 | Pinal | Arizona | 4021 | 53773 | 903 |
1446449 | 1446449 | 2021-06-23 | Pinal | Arizona | 4021 | 53717 | 903 |
1424768 | 1424768 | 2021-06-16 | Jefferson | Louisiana | 22051 | 47289 | 903 |
1394517 | 1394517 | 2021-06-07 | Pinal | Arizona | 4021 | 53175 | 903 |
1391272 | 1391272 | 2021-06-06 | Pinal | Arizona | 4021 | 53175 | 903 |
1384782 | 1384782 | 2021-06-04 | Pinal | Arizona | 4021 | 53090 | 903 |
1372020 | 1372020 | 2021-05-31 | Brevard | Florida | 12009 | 42856 | 903 |
1368775 | 1368775 | 2021-05-30 | Brevard | Florida | 12009 | 42856 | 903 |
1365529 | 1365529 | 2021-05-29 | Brevard | Florida | 12009 | 42856 | 903 |
1362283 | 1362283 | 2021-05-28 | Brevard | Florida | 12009 | 42856 | 903 |
1311274 | 1311274 | 2021-05-12 | Genesee | Michigan | 26049 | 40910 | 903 |
1141582 | 1141582 | 2021-03-21 | DeKalb | Georgia | 13089 | 60319 | 903 |
1138336 | 1138336 | 2021-03-20 | DeKalb | Georgia | 13089 | 60200 | 903 |
1133374 | 1133374 | 2021-03-18 | Mecklenburg | North Carolina | 37119 | 99894 | 903 |
1111121 | 1111121 | 2021-03-11 | Greenville | South Carolina | 45045 | 65669 | 903 |
1088077 | 1088077 | 2021-03-04 | Montgomery | Ohio | 39113 | 47424 | 903 |
1084832 | 1084832 | 2021-03-03 | Montgomery | Ohio | 39113 | 47359 | 903 |
1081586 | 1081586 | 2021-03-02 | Montgomery | Ohio | 39113 | 47301 | 903 |
1081737 | 1081737 | 2021-03-02 | Berks | Pennsylvania | 42011 | 35791 | 903 |
1066910 | 1066910 | 2021-02-26 | Cobb | Georgia | 13067 | 69345 | 903 |
974658 | 974658 | 2021-01-28 | Lancaster | Pennsylvania | 42071 | 36945 | 903 |
953541 | 953541 | 2021-01-22 | Lake | Illinois | 17097 | 54272 | 903 |
887341 | 887341 | 2021-01-01 | Shelby | Tennessee | 47157 | 67800 | 903 |
884096 | 884096 | 2020-12-31 | Shelby | Tennessee | 47157 | 67198 | 903 |
811951 | 811951 | 2020-12-09 | Erie | New York | 36029 | 30719 | 903 |
782691 | 782691 | 2020-11-30 | Monmouth | New Jersey | 34025 | 20749 | 903 |
726932 | 726932 | 2020-11-13 | Montgomery | Maryland | 24031 | 28426 | 903 |
728021 | 728021 | 2020-11-13 | Montgomery | Pennsylvania | 42091 | 16773 | 903 |
526065 | 526065 | 2020-09-12 | Hennepin | Minnesota | 27053 | 24611 | 903 |
269476 | 269476 | 2020-06-24 | Macomb | Michigan | 26099 | 7430 | 903 |
266343 | 266343 | 2020-06-23 | Macomb | Michigan | 26099 | 7414 | 903 |
263167 | 263167 | 2020-06-22 | Worcester | Massachusetts | 25027 | 12143 | 903 |
247561 | 247561 | 2020-06-17 | Norfolk | Massachusetts | 25021 | 8908 | 903 |
186282 | 186282 | 2020-05-28 | Passaic | New Jersey | 34031 | 15959 | 903 |
172706 | 172706 | 2020-05-24 | New Haven | Connecticut | 9009 | 10905 | 903 |
158914 | 158914 | 2020-05-19 | Middlesex | New Jersey | 34023 | 14834 | 903 |
119951 | 119951 | 2020-05-06 | Hudson | New Jersey | 34017 | 16197 | 903 |
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);