ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
220 rows where cases = 2861 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 23
- Iowa 18
- Nebraska 18
- Alabama 15
- Texas 11
- Arkansas 10
- Mississippi 10
- Indiana 9
- Louisiana 8
- Minnesota 8
- Oklahoma 7
- Missouri 6
- Ohio 6
- Illinois 5
- Pennsylvania 5
- Tennessee 5
- Colorado 4
- Georgia 4
- North Carolina 4
- Oregon 4
- West Virginia 4
- California 3
- Idaho 3
- Maine 3
- Montana 3
- Utah 3
- Virginia 3
- Florida 2
- Maryland 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484736 | 2484736 | 2022-05-08 | Jefferson Davis | Mississippi | 28065 | 2861 | 53 |
2481478 | 2481478 | 2022-05-07 | Jefferson Davis | Mississippi | 28065 | 2861 | 53 |
2478220 | 2478220 | 2022-05-06 | Jefferson Davis | Mississippi | 28065 | 2861 | 53 |
2474962 | 2474962 | 2022-05-05 | Jefferson Davis | Mississippi | 28065 | 2861 | 53 |
2471705 | 2471705 | 2022-05-04 | Jefferson Davis | Mississippi | 28065 | 2861 | 53 |
2467016 | 2467016 | 2022-05-03 | Conecuh | Alabama | 1035 | 2861 | 70 |
2468449 | 2468449 | 2022-05-03 | Jefferson Davis | Mississippi | 28065 | 2861 | 53 |
2463761 | 2463761 | 2022-05-02 | Conecuh | Alabama | 1035 | 2861 | 70 |
2465194 | 2465194 | 2022-05-02 | Jefferson Davis | Mississippi | 28065 | 2861 | 53 |
2460505 | 2460505 | 2022-05-01 | Conecuh | Alabama | 1035 | 2861 | 70 |
2460780 | 2460780 | 2022-05-01 | Park | Colorado | 8093 | 2861 | 20 |
2457249 | 2457249 | 2022-04-30 | Conecuh | Alabama | 1035 | 2861 | 70 |
2457524 | 2457524 | 2022-04-30 | Park | Colorado | 8093 | 2861 | 20 |
2453993 | 2453993 | 2022-04-29 | Conecuh | Alabama | 1035 | 2861 | 70 |
2454268 | 2454268 | 2022-04-29 | Park | Colorado | 8093 | 2861 | 20 |
2450737 | 2450737 | 2022-04-28 | Conecuh | Alabama | 1035 | 2861 | 70 |
2418177 | 2418177 | 2022-04-18 | Conecuh | Alabama | 1035 | 2861 | 71 |
2414921 | 2414921 | 2022-04-17 | Conecuh | Alabama | 1035 | 2861 | 71 |
2417567 | 2417567 | 2022-04-17 | Camp | Texas | 48063 | 2861 | 74 |
2411665 | 2411665 | 2022-04-16 | Conecuh | Alabama | 1035 | 2861 | 71 |
2414311 | 2414311 | 2022-04-16 | Camp | Texas | 48063 | 2861 | 74 |
2408409 | 2408409 | 2022-04-15 | Conecuh | Alabama | 1035 | 2861 | 71 |
2411055 | 2411055 | 2022-04-15 | Camp | Texas | 48063 | 2861 | 74 |
2405153 | 2405153 | 2022-04-14 | Conecuh | Alabama | 1035 | 2861 | 71 |
2407799 | 2407799 | 2022-04-14 | Camp | Texas | 48063 | 2861 | 74 |
2400386 | 2400386 | 2022-04-12 | Unknown | Nebraska | 2861 | 540 | |
2393203 | 2393203 | 2022-04-10 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2389947 | 2389947 | 2022-04-09 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2386691 | 2386691 | 2022-04-08 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2383436 | 2383436 | 2022-04-07 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2380181 | 2380181 | 2022-04-06 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2376639 | 2376639 | 2022-04-05 | Allamakee | Iowa | 19005 | 2861 | 59 |
2376926 | 2376926 | 2022-04-05 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2373387 | 2373387 | 2022-04-04 | Allamakee | Iowa | 19005 | 2861 | 59 |
2373674 | 2373674 | 2022-04-04 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2370134 | 2370134 | 2022-04-03 | Allamakee | Iowa | 19005 | 2861 | 59 |
2366881 | 2366881 | 2022-04-02 | Allamakee | Iowa | 19005 | 2861 | 59 |
2363628 | 2363628 | 2022-04-01 | Allamakee | Iowa | 19005 | 2861 | 59 |
2360374 | 2360374 | 2022-03-31 | Allamakee | Iowa | 19005 | 2861 | 59 |
2357120 | 2357120 | 2022-03-30 | Allamakee | Iowa | 19005 | 2861 | 59 |
2337120 | 2337120 | 2022-03-24 | Unknown | Connecticut | 2861 | 10 | |
2268563 | 2268563 | 2022-03-03 | Wilcox | Alabama | 1131 | 2861 | 42 |
2264889 | 2264889 | 2022-03-01 | Morgan | Utah | 49029 | 2861 | 13 |
2194525 | 2194525 | 2022-02-08 | Cherokee | Iowa | 19035 | 2861 | 54 |
2191271 | 2191271 | 2022-02-07 | Cherokee | Iowa | 19035 | 2861 | 54 |
2188018 | 2188018 | 2022-02-06 | Cherokee | Iowa | 19035 | 2861 | 54 |
2184765 | 2184765 | 2022-02-05 | Cherokee | Iowa | 19035 | 2861 | 54 |
2181513 | 2181513 | 2022-02-04 | Cherokee | Iowa | 19035 | 2861 | 54 |
2178262 | 2178262 | 2022-02-03 | Cherokee | Iowa | 19035 | 2861 | 54 |
2175009 | 2175009 | 2022-02-02 | Cherokee | Iowa | 19035 | 2861 | 54 |
2176451 | 2176451 | 2022-02-02 | Morrow | Oregon | 41049 | 2861 | 26 |
2169928 | 2169928 | 2022-01-31 | Curry | Oregon | 41015 | 2861 | 41 |
2165566 | 2165566 | 2022-01-30 | Caldwell | Louisiana | 22021 | 2861 | 43 |
2162311 | 2162311 | 2022-01-29 | Caldwell | Louisiana | 22021 | 2861 | 43 |
2159056 | 2159056 | 2022-01-28 | Caldwell | Louisiana | 22021 | 2861 | 43 |
2152484 | 2152484 | 2022-01-26 | Leslie | Kentucky | 21131 | 2861 | 39 |
2147232 | 2147232 | 2022-01-24 | Potter | Pennsylvania | 42105 | 2861 | 83 |
2125659 | 2125659 | 2022-01-18 | Gunnison | Colorado | 8051 | 2861 | 13 |
2123211 | 2123211 | 2022-01-17 | Magoffin | Kentucky | 21153 | 2861 | 36 |
2119959 | 2119959 | 2022-01-16 | Magoffin | Kentucky | 21153 | 2861 | 36 |
2116707 | 2116707 | 2022-01-15 | Magoffin | Kentucky | 21153 | 2861 | 36 |
2113456 | 2113456 | 2022-01-14 | Magoffin | Kentucky | 21153 | 2861 | 36 |
2109826 | 2109826 | 2022-01-13 | Washington | Illinois | 17189 | 2861 | 37 |
2100578 | 2100578 | 2022-01-10 | Washington | Maine | 23029 | 2861 | 41 |
2097327 | 2097327 | 2022-01-09 | Washington | Maine | 23029 | 2861 | 41 |
2094075 | 2094075 | 2022-01-08 | Washington | Maine | 23029 | 2861 | 41 |
2084478 | 2084478 | 2022-01-05 | Kanabec | Minnesota | 27065 | 2861 | 47 |
2050755 | 2050755 | 2021-12-26 | Izard | Arkansas | 5065 | 2861 | 57 |
2047505 | 2047505 | 2021-12-25 | Izard | Arkansas | 5065 | 2861 | 57 |
2035477 | 2035477 | 2021-12-21 | Union | Kentucky | 21225 | 2861 | 44 |
1964763 | 1964763 | 2021-11-29 | Avery | North Carolina | 37011 | 2861 | 39 |
1922431 | 1922431 | 2021-11-16 | Roosevelt | New Mexico | 35041 | 2861 | 70 |
1922556 | 1922556 | 2021-11-16 | Madison | North Carolina | 37115 | 2861 | 62 |
1906877 | 1906877 | 2021-11-11 | Benton | Tennessee | 47005 | 2861 | 54 |
1903628 | 1903628 | 2021-11-10 | Benton | Tennessee | 47005 | 2861 | 54 |
1866576 | 1866576 | 2021-10-30 | Talbot | Maryland | 24041 | 2861 | 54 |
1838984 | 1838984 | 2021-10-21 | Young | Texas | 48503 | 2861 | 66 |
1826493 | 1826493 | 2021-10-18 | Drew | Arkansas | 5043 | 2861 | 54 |
1816751 | 1816751 | 2021-10-15 | Grant | Arkansas | 5053 | 2861 | 47 |
1790484 | 1790484 | 2021-10-06 | Hampshire | West Virginia | 54027 | 2861 | 46 |
1782302 | 1782302 | 2021-10-04 | Clarke | Mississippi | 28023 | 2861 | 91 |
1759338 | 1759338 | 2021-09-27 | Caroline | Maryland | 24011 | 2861 | 39 |
1740244 | 1740244 | 2021-09-21 | Texas | Missouri | 29215 | 2861 | 39 |
1723817 | 1723817 | 2021-09-16 | Clay | Mississippi | 28025 | 2861 | 72 |
1710482 | 1710482 | 2021-09-12 | Meade | Kentucky | 21163 | 2861 | 30 |
1707235 | 1707235 | 2021-09-11 | Meade | Kentucky | 21163 | 2861 | 30 |
1703987 | 1703987 | 2021-09-10 | Meade | Kentucky | 21163 | 2861 | 30 |
1700272 | 1700272 | 2021-09-09 | Crawford | Illinois | 17033 | 2861 | 44 |
1693321 | 1693321 | 2021-09-07 | Phillips | Arkansas | 5107 | 2861 | 60 |
1695770 | 1695770 | 2021-09-07 | Trousdale | Tennessee | 47169 | 2861 | 22 |
1676028 | 1676028 | 2021-09-01 | Humacao | Puerto Rico | 72069 | 2861 | |
1636759 | 1636759 | 2021-08-20 | Coshocton | Ohio | 39031 | 2861 | 63 |
1627032 | 1627032 | 2021-08-17 | Hardin | Ohio | 39065 | 2861 | 66 |
1603667 | 1603667 | 2021-08-10 | Newton | Mississippi | 28101 | 2861 | 65 |
1596165 | 1596165 | 2021-08-08 | Haralson | Georgia | 13143 | 2861 | 91 |
1592916 | 1592916 | 2021-08-07 | Haralson | Georgia | 13143 | 2861 | 91 |
1589667 | 1589667 | 2021-08-06 | Haralson | Georgia | 13143 | 2861 | 91 |
1591564 | 1591564 | 2021-08-06 | Dorado | Puerto Rico | 72051 | 2861 | |
1580232 | 1580232 | 2021-08-03 | Scott | Indiana | 18143 | 2861 | 60 |
1564910 | 1564910 | 2021-07-29 | Dawson | Nebraska | 31047 | 2861 | 31 |
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);