ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
157 rows where cases = 4050 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 13
- Illinois 10
- Indiana 10
- Oklahoma 10
- Kentucky 9
- Texas 9
- Idaho 8
- North Carolina 8
- Michigan 7
- Nebraska 7
- Georgia 5
- Wisconsin 5
- Arkansas 4
- Louisiana 4
- Ohio 4
- Pennsylvania 4
- Alaska 3
- Colorado 3
- Missouri 3
- Tennessee 3
- Virginia 3
- West Virginia 3
- Alabama 2
- Arizona 2
- California 2
- Kansas 2
- Montana 2
- New Mexico 2
- New York 2
- Puerto Rico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2314701 | 2314701 | 2022-03-17 | Moultrie | Illinois | 17139 | 4050 | 52 |
2271129 | 2271129 | 2022-03-03 | Aransas | Texas | 48007 | 4050 | 78 |
2263491 | 2263491 | 2022-03-01 | Yalobusha | Mississippi | 28161 | 4050 | 56 |
2260240 | 2260240 | 2022-02-28 | Yalobusha | Mississippi | 28161 | 4050 | 55 |
2244137 | 2244137 | 2022-02-23 | Park | Montana | 30067 | 4050 | 33 |
2225395 | 2225395 | 2022-02-17 | Yauco | Puerto Rico | 72153 | 4050 | |
2193574 | 2193574 | 2022-02-07 | Hardy | West Virginia | 54031 | 4050 | 44 |
2173628 | 2173628 | 2022-02-01 | Deaf Smith | Texas | 48117 | 4050 | 105 |
2165133 | 2165133 | 2022-01-30 | White | Illinois | 17193 | 4050 | 45 |
2161878 | 2161878 | 2022-01-29 | White | Illinois | 17193 | 4050 | 45 |
2158623 | 2158623 | 2022-01-28 | White | Illinois | 17193 | 4050 | 45 |
2129252 | 2129252 | 2022-01-19 | Cass | Illinois | 17017 | 4050 | 41 |
2130213 | 2130213 | 2022-01-19 | New Madrid | Missouri | 29143 | 4050 | 72 |
2131463 | 2131463 | 2022-01-19 | Reeves | Texas | 48389 | 4050 | 64 |
2122760 | 2122760 | 2022-01-17 | Edgar | Illinois | 17045 | 4050 | 75 |
2124960 | 2124960 | 2022-01-17 | Robertson | Texas | 48395 | 4050 | 68 |
2119508 | 2119508 | 2022-01-16 | Edgar | Illinois | 17045 | 4050 | 75 |
2116256 | 2116256 | 2022-01-15 | Edgar | Illinois | 17045 | 4050 | 75 |
2113005 | 2113005 | 2022-01-14 | Edgar | Illinois | 17045 | 4050 | 75 |
2103118 | 2103118 | 2022-01-11 | Mitchell | Georgia | 13205 | 4050 | 102 |
2101321 | 2101321 | 2022-01-10 | Greene | North Carolina | 37079 | 4050 | 56 |
2102591 | 2102591 | 2022-01-10 | Taylor | Wisconsin | 55119 | 4050 | 62 |
2089783 | 2089783 | 2022-01-07 | Ouachita | Arkansas | 5103 | 4050 | 91 |
2077739 | 2077739 | 2022-01-03 | Assumption | Louisiana | 22007 | 4050 | 57 |
2038186 | 2038186 | 2021-12-22 | Cassia | Idaho | 16031 | 4050 | 44 |
2034936 | 2034936 | 2021-12-21 | Cassia | Idaho | 16031 | 4050 | 44 |
2036514 | 2036514 | 2021-12-21 | Wyandot | Ohio | 39175 | 4050 | 80 |
1966077 | 1966077 | 2021-11-29 | Waushara | Wisconsin | 55137 | 4050 | 57 |
1924911 | 1924911 | 2021-11-17 | Letcher | Kentucky | 21133 | 4050 | 71 |
1897349 | 1897349 | 2021-11-08 | Karnes | Texas | 48255 | 4050 | 56 |
1894463 | 1894463 | 2021-11-07 | Jackson | West Virginia | 54035 | 4050 | 87 |
1884349 | 1884349 | 2021-11-04 | Karnes | Texas | 48255 | 4050 | 56 |
1881100 | 1881100 | 2021-11-03 | Karnes | Texas | 48255 | 4050 | 56 |
1881422 | 1881422 | 2021-11-03 | Island | Washington | 53029 | 4050 | 46 |
1873681 | 1873681 | 2021-11-01 | Luna | New Mexico | 35029 | 4050 | 95 |
1836609 | 1836609 | 2021-10-21 | Peach | Georgia | 13225 | 4050 | 96 |
1818205 | 1818205 | 2021-10-15 | Saline | Missouri | 29195 | 4050 | 46 |
1812179 | 1812179 | 2021-10-13 | Adams | Ohio | 39001 | 4050 | 83 |
1788827 | 1788827 | 2021-10-06 | Leake | Mississippi | 28079 | 4050 | 87 |
1789190 | 1789190 | 2021-10-06 | Cibola | New Mexico | 35006 | 4050 | 135 |
1778357 | 1778357 | 2021-10-03 | Greene | Indiana | 18055 | 4050 | 98 |
1775107 | 1775107 | 2021-10-02 | Greene | Indiana | 18055 | 4050 | 98 |
1771857 | 1771857 | 2021-10-01 | Greene | Indiana | 18055 | 4050 | 98 |
1755468 | 1755468 | 2021-09-26 | Latah | Idaho | 16057 | 4050 | 24 |
1752220 | 1752220 | 2021-09-25 | Latah | Idaho | 16057 | 4050 | 24 |
1748971 | 1748971 | 2021-09-24 | Latah | Idaho | 16057 | 4050 | 24 |
1719643 | 1719643 | 2021-09-15 | Pierce | Georgia | 13229 | 4050 | 79 |
1697902 | 1697902 | 2021-09-08 | Yazoo | Mississippi | 28163 | 4050 | 86 |
1689875 | 1689875 | 2021-09-05 | Trempealeau | Wisconsin | 55121 | 4050 | 49 |
1686625 | 1686625 | 2021-09-04 | Trempealeau | Wisconsin | 55121 | 4050 | 49 |
1683375 | 1683375 | 2021-09-03 | Trempealeau | Wisconsin | 55121 | 4050 | 49 |
1678383 | 1678383 | 2021-09-02 | Prentiss | Mississippi | 28117 | 4050 | 71 |
1671511 | 1671511 | 2021-08-31 | Perry | Kentucky | 21193 | 4050 | 70 |
1664662 | 1664662 | 2021-08-29 | Jefferson | Indiana | 18077 | 4050 | 91 |
1661414 | 1661414 | 2021-08-28 | Jefferson | Indiana | 18077 | 4050 | 91 |
1658166 | 1658166 | 2021-08-27 | Jefferson | Indiana | 18077 | 4050 | 91 |
1651940 | 1651940 | 2021-08-25 | Boyle | Kentucky | 21021 | 4050 | 80 |
1630587 | 1630587 | 2021-08-18 | Trujillo Alto | Puerto Rico | 72139 | 4050 | |
1617303 | 1617303 | 2021-08-14 | Logan | Ohio | 39091 | 4050 | 79 |
1596296 | 1596296 | 2021-08-08 | Nez Perce | Idaho | 16069 | 4050 | 60 |
1593047 | 1593047 | 2021-08-07 | Nez Perce | Idaho | 16069 | 4050 | 60 |
1589798 | 1589798 | 2021-08-06 | Nez Perce | Idaho | 16069 | 4050 | 60 |
1583448 | 1583448 | 2021-08-04 | Jasper | Indiana | 18073 | 4050 | 59 |
1581616 | 1581616 | 2021-08-03 | Caddo | Oklahoma | 40015 | 4050 | 96 |
1578367 | 1578367 | 2021-08-02 | Caddo | Oklahoma | 40015 | 4050 | 96 |
1575119 | 1575119 | 2021-08-01 | Caddo | Oklahoma | 40015 | 4050 | 96 |
1571871 | 1571871 | 2021-07-31 | Caddo | Oklahoma | 40015 | 4050 | 96 |
1568623 | 1568623 | 2021-07-30 | Caddo | Oklahoma | 40015 | 4050 | 96 |
1565375 | 1565375 | 2021-07-29 | Caddo | Oklahoma | 40015 | 4050 | 96 |
1562127 | 1562127 | 2021-07-28 | Caddo | Oklahoma | 40015 | 4050 | 96 |
1551664 | 1551664 | 2021-07-25 | Hancock | Mississippi | 28045 | 4050 | 88 |
1548417 | 1548417 | 2021-07-24 | Hancock | Mississippi | 28045 | 4050 | 88 |
1545170 | 1545170 | 2021-07-23 | Hancock | Mississippi | 28045 | 4050 | 88 |
1511288 | 1511288 | 2021-07-13 | Escambia | Alabama | 1053 | 4050 | 81 |
1513328 | 1513328 | 2021-07-13 | Brown | Ohio | 39015 | 4050 | 61 |
1508041 | 1508041 | 2021-07-12 | Escambia | Alabama | 1053 | 4050 | 81 |
1492521 | 1492521 | 2021-07-07 | Huntington | Indiana | 18069 | 4050 | 83 |
1466442 | 1466442 | 2021-06-29 | Fulton | Illinois | 17057 | 4050 | 67 |
1466931 | 1466931 | 2021-06-29 | Whitley | Kentucky | 21235 | 4050 | 61 |
1463686 | 1463686 | 2021-06-28 | Whitley | Kentucky | 21235 | 4050 | 61 |
1449870 | 1449870 | 2021-06-24 | Logan | Colorado | 8075 | 4050 | 69 |
1410215 | 1410215 | 2021-06-11 | Rusk | Texas | 48401 | 4050 | 108 |
1406970 | 1406970 | 2021-06-10 | Rusk | Texas | 48401 | 4050 | 108 |
1398155 | 1398155 | 2021-06-08 | Oconee | Georgia | 13219 | 4050 | 73 |
1394688 | 1394688 | 2021-06-07 | La Plata | Colorado | 8067 | 4050 | 41 |
1391443 | 1391443 | 2021-06-06 | La Plata | Colorado | 8067 | 4050 | 41 |
1371873 | 1371873 | 2021-05-31 | Union | Arkansas | 5139 | 4050 | 115 |
1368628 | 1368628 | 2021-05-30 | Union | Arkansas | 5139 | 4050 | 115 |
1369911 | 1369911 | 2021-05-30 | Neshoba | Mississippi | 28099 | 4050 | 178 |
1366665 | 1366665 | 2021-05-29 | Neshoba | Mississippi | 28099 | 4050 | 178 |
1363419 | 1363419 | 2021-05-28 | Neshoba | Mississippi | 28099 | 4050 | 178 |
1364278 | 1364278 | 2021-05-28 | Venango | Pennsylvania | 42121 | 4050 | 96 |
1330760 | 1330760 | 2021-05-18 | Huron | Michigan | 26063 | 4050 | 75 |
1301423 | 1301423 | 2021-05-09 | Natchitoches | Louisiana | 22069 | 4050 | 86 |
1302202 | 1302202 | 2021-05-09 | Davie | North Carolina | 37059 | 4050 | 37 |
1298176 | 1298176 | 2021-05-08 | Natchitoches | Louisiana | 22069 | 4050 | 86 |
1298954 | 1298954 | 2021-05-08 | Davie | North Carolina | 37059 | 4050 | 37 |
1294930 | 1294930 | 2021-05-07 | Natchitoches | Louisiana | 22069 | 4050 | 86 |
1295708 | 1295708 | 2021-05-07 | Davie | North Carolina | 37059 | 4050 | 37 |
1289742 | 1289742 | 2021-05-05 | Williamsburg | South Carolina | 45089 | 4050 | 98 |
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);