ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where cases = 2995 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 16
- Arkansas 10
- Iowa 9
- Tennessee 9
- Georgia 8
- Indiana 8
- Minnesota 8
- Missouri 7
- Virginia 7
- Ohio 6
- Colorado 5
- Kentucky 5
- Mississippi 5
- Pennsylvania 5
- Puerto Rico 5
- Alabama 4
- North Carolina 4
- Florida 3
- Illinois 3
- Kansas 3
- South Dakota 3
- West Virginia 3
- Idaho 2
- Louisiana 2
- New York 2
- Arizona 1
- California 1
- Maryland 1
- Michigan 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499006 | 2499006 | 2022-05-12 | Dawson | Texas | 48115 | 2995 | 94 |
2495748 | 2495748 | 2022-05-11 | Dawson | Texas | 48115 | 2995 | 94 |
2486660 | 2486660 | 2022-05-09 | Bradley | Arkansas | 5011 | 2995 | 49 |
2483402 | 2483402 | 2022-05-08 | Bradley | Arkansas | 5011 | 2995 | 49 |
2480144 | 2480144 | 2022-05-07 | Bradley | Arkansas | 5011 | 2995 | 49 |
2476886 | 2476886 | 2022-05-06 | Bradley | Arkansas | 5011 | 2995 | 49 |
2473628 | 2473628 | 2022-05-05 | Bradley | Arkansas | 5011 | 2995 | 49 |
2433577 | 2433577 | 2022-04-22 | Orocovis | Puerto Rico | 72107 | 2995 | |
2353354 | 2353354 | 2022-03-29 | Moffat | Colorado | 8081 | 2995 | 51 |
2179766 | 2179766 | 2022-02-03 | Potter | Pennsylvania | 42105 | 2995 | 86 |
2175209 | 2175209 | 2022-02-02 | Breathitt | Kentucky | 21025 | 2995 | 49 |
2145412 | 2145412 | 2022-01-24 | Oglethorpe | Georgia | 13221 | 2995 | 46 |
2127152 | 2127152 | 2022-01-18 | York | Nebraska | 31185 | 2995 | 19 |
2121630 | 2121630 | 2022-01-16 | Jackson | Texas | 48239 | 2995 | 53 |
2109399 | 2109399 | 2022-01-13 | Grand | Colorado | 8049 | 2995 | 20 |
2086950 | 2086950 | 2022-01-06 | Gem | Idaho | 16045 | 2995 | 72 |
2083698 | 2083698 | 2022-01-05 | Gem | Idaho | 16045 | 2995 | 72 |
2079987 | 2079987 | 2022-01-04 | Clay | Arkansas | 5021 | 2995 | 77 |
2060969 | 2060969 | 2021-12-29 | Carroll | Illinois | 17015 | 2995 | 42 |
2054332 | 2054332 | 2021-12-27 | Jeff Davis | Georgia | 13161 | 2995 | 63 |
2027239 | 2027239 | 2021-12-18 | Andrews | Texas | 48003 | 2995 | 65 |
1995600 | 1995600 | 2021-12-09 | Alamosa | Colorado | 8003 | 2995 | 51 |
1994873 | 1994873 | 2021-12-08 | Lee | Texas | 48287 | 2995 | 54 |
1989528 | 1989528 | 2021-12-07 | Pike | Illinois | 17149 | 2995 | 61 |
1986643 | 1986643 | 2021-12-06 | Garrard | Kentucky | 21079 | 2995 | 54 |
1987446 | 1987446 | 2021-12-06 | Taos | New Mexico | 35055 | 2995 | 71 |
1984884 | 1984884 | 2021-12-05 | Benton | Tennessee | 47005 | 2995 | 60 |
1981634 | 1981634 | 2021-12-04 | Benton | Tennessee | 47005 | 2995 | 60 |
1978384 | 1978384 | 2021-12-03 | Benton | Tennessee | 47005 | 2995 | 60 |
1972230 | 1972230 | 2021-12-01 | Young | Texas | 48503 | 2995 | 72 |
1944151 | 1944151 | 2021-11-23 | Buchanan | Iowa | 19019 | 2995 | 39 |
1940901 | 1940901 | 2021-11-22 | Buchanan | Iowa | 19019 | 2995 | 39 |
1937651 | 1937651 | 2021-11-21 | Buchanan | Iowa | 19019 | 2995 | 39 |
1934401 | 1934401 | 2021-11-20 | Buchanan | Iowa | 19019 | 2995 | 39 |
1931150 | 1931150 | 2021-11-19 | Buchanan | Iowa | 19019 | 2995 | 39 |
1927899 | 1927899 | 2021-11-18 | Buchanan | Iowa | 19019 | 2995 | 39 |
1924649 | 1924649 | 2021-11-17 | Buchanan | Iowa | 19019 | 2995 | 39 |
1899618 | 1899618 | 2021-11-09 | Humboldt | Nevada | 32013 | 2995 | 37 |
1900145 | 1900145 | 2021-11-09 | Juniata | Pennsylvania | 42067 | 2995 | 117 |
1894763 | 1894763 | 2021-11-08 | Polk | Arkansas | 5113 | 2995 | 112 |
1891513 | 1891513 | 2021-11-07 | Polk | Arkansas | 5113 | 2995 | 112 |
1887218 | 1887218 | 2021-11-05 | Juncos | Puerto Rico | 72077 | 2995 | |
1883968 | 1883968 | 2021-11-04 | Juncos | Puerto Rico | 72077 | 2995 | |
1878477 | 1878477 | 2021-11-03 | Cross | Arkansas | 5037 | 2995 | 65 |
1879936 | 1879936 | 2021-11-03 | Ray | Missouri | 29177 | 2995 | 50 |
1861459 | 1861459 | 2021-10-28 | Sequatchie | Tennessee | 47153 | 2995 | 33 |
1848976 | 1848976 | 2021-10-24 | Lewis | West Virginia | 54041 | 2995 | 50 |
1834930 | 1834930 | 2021-10-20 | Carroll | Ohio | 39019 | 2995 | 59 |
1832713 | 1832713 | 2021-10-19 | Brooke | West Virginia | 54009 | 2995 | 69 |
1795079 | 1795079 | 2021-10-08 | Caroline | Maryland | 24011 | 2995 | 41 |
1785227 | 1785227 | 2021-10-05 | Rockcastle | Kentucky | 21203 | 2995 | 28 |
1786491 | 1786491 | 2021-10-05 | Humacao | Puerto Rico | 72069 | 2995 | |
1781639 | 1781639 | 2021-10-04 | Owen | Indiana | 18119 | 2995 | 68 |
1739639 | 1739639 | 2021-09-21 | Adair | Kentucky | 21001 | 2995 | 64 |
1735441 | 1735441 | 2021-09-20 | Pickens | Alabama | 1107 | 2995 | 69 |
1736390 | 1736390 | 2021-09-20 | Adair | Kentucky | 21001 | 2995 | 64 |
1724299 | 1724299 | 2021-09-16 | Ashe | North Carolina | 37009 | 2995 | 45 |
1719288 | 1719288 | 2021-09-15 | Lawrence | Arkansas | 5075 | 2995 | 48 |
1719634 | 1719634 | 2021-09-15 | Morgan | Georgia | 13211 | 2995 | 34 |
1718542 | 1718542 | 2021-09-14 | Burleson | Texas | 48051 | 2995 | 55 |
1713187 | 1713187 | 2021-09-13 | Washington | Georgia | 13303 | 2995 | 99 |
1678395 | 1678395 | 2021-09-02 | Tishomingo | Mississippi | 28141 | 2995 | 80 |
1679848 | 1679848 | 2021-09-02 | Botetourt | Virginia | 51023 | 2995 | 39 |
1666311 | 1666311 | 2021-08-29 | Rio Grande | Puerto Rico | 72119 | 2995 | |
1654095 | 1654095 | 2021-08-25 | Door | Wisconsin | 55029 | 2995 | 37 |
1643646 | 1643646 | 2021-08-22 | Beadle | South Dakota | 46005 | 2995 | 42 |
1640396 | 1640396 | 2021-08-21 | Beadle | South Dakota | 46005 | 2995 | 42 |
1637146 | 1637146 | 2021-08-20 | Beadle | South Dakota | 46005 | 2995 | 42 |
1588657 | 1588657 | 2021-08-05 | Fayette | Texas | 48149 | 2995 | 70 |
1585479 | 1585479 | 2021-08-04 | Limestone | Texas | 48293 | 2995 | 82 |
1554199 | 1554199 | 2021-07-26 | Fayette | Indiana | 18041 | 2995 | 66 |
1550952 | 1550952 | 2021-07-25 | Fayette | Indiana | 18041 | 2995 | 66 |
1551593 | 1551593 | 2021-07-25 | Le Sueur | Minnesota | 27079 | 2995 | 27 |
1547705 | 1547705 | 2021-07-24 | Fayette | Indiana | 18041 | 2995 | 66 |
1548346 | 1548346 | 2021-07-24 | Le Sueur | Minnesota | 27079 | 2995 | 27 |
1544458 | 1544458 | 2021-07-23 | Fayette | Indiana | 18041 | 2995 | 66 |
1545099 | 1545099 | 2021-07-23 | Le Sueur | Minnesota | 27079 | 2995 | 27 |
1541210 | 1541210 | 2021-07-22 | Fayette | Indiana | 18041 | 2995 | 66 |
1543292 | 1543292 | 2021-07-22 | Palo Pinto | Texas | 48363 | 2995 | 78 |
1501206 | 1501206 | 2021-07-09 | Amherst | Virginia | 51009 | 2995 | 40 |
1466995 | 1466995 | 2021-06-29 | West Baton Rouge | Louisiana | 22121 | 2995 | 62 |
1438106 | 1438106 | 2021-06-20 | Barry | Missouri | 29009 | 2995 | 47 |
1423106 | 1423106 | 2021-06-15 | Hockley | Texas | 48219 | 2995 | 103 |
1419860 | 1419860 | 2021-06-14 | Hockley | Texas | 48219 | 2995 | 103 |
1416615 | 1416615 | 2021-06-13 | Hockley | Texas | 48219 | 2995 | 103 |
1413369 | 1413369 | 2021-06-12 | Hockley | Texas | 48219 | 2995 | 103 |
1360123 | 1360123 | 2021-05-27 | Adams | Mississippi | 28001 | 2995 | 82 |
1343324 | 1343324 | 2021-05-22 | Jones | Iowa | 19105 | 2995 | 57 |
1329107 | 1329107 | 2021-05-17 | Willacy | Texas | 48489 | 2995 | 88 |
1325861 | 1325861 | 2021-05-16 | Willacy | Texas | 48489 | 2995 | 88 |
1304957 | 1304957 | 2021-05-10 | Itawamba | Mississippi | 28057 | 2995 | 77 |
1225934 | 1225934 | 2021-04-16 | Hardee | Florida | 12049 | 2995 | 42 |
1219525 | 1219525 | 2021-04-14 | Dawson | Georgia | 13085 | 2995 | 41 |
1212339 | 1212339 | 2021-04-11 | Isle of Wight | Virginia | 51093 | 2995 | 63 |
1191743 | 1191743 | 2021-04-05 | Otsego | New York | 36077 | 2995 | 46 |
1189214 | 1189214 | 2021-04-04 | Scott | Tennessee | 47151 | 2995 | 45 |
1185967 | 1185967 | 2021-04-03 | Scott | Tennessee | 47151 | 2995 | 45 |
1186420 | 1186420 | 2021-04-03 | Wise | Virginia | 51195 | 2995 | 92 |
1182720 | 1182720 | 2021-04-02 | Scott | Tennessee | 47151 | 2995 | 45 |
1179473 | 1179473 | 2021-04-01 | Scott | Tennessee | 47151 | 2995 | 45 |
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);