ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
137 rows where cases = 3383 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 13
- Minnesota 9
- Puerto Rico 8
- Tennessee 8
- Illinois 7
- Iowa 7
- Kentucky 7
- Texas 7
- Colorado 6
- Virginia 6
- Arkansas 5
- Michigan 5
- Georgia 4
- Missouri 4
- New York 4
- North Carolina 4
- Ohio 4
- Mississippi 3
- Washington 3
- Louisiana 2
- Nebraska 2
- Oregon 2
- Pennsylvania 2
- South Carolina 2
- Utah 2
- Wisconsin 2
- Arizona 1
- California 1
- Florida 1
- Indiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427609 | 2427609 | 2022-04-20 | Alleghany | Virginia | 51005 | 3383 | 98 |
2418431 | 2418431 | 2022-04-18 | Gunnison | Colorado | 8051 | 3383 | 14 |
2372743 | 2372743 | 2022-04-04 | Marion | Arkansas | 5089 | 3383 | 87 |
2374495 | 2374495 | 2022-04-04 | Yates | New York | 36123 | 3383 | 39 |
2369490 | 2369490 | 2022-04-03 | Marion | Arkansas | 5089 | 3383 | 87 |
2366237 | 2366237 | 2022-04-02 | Marion | Arkansas | 5089 | 3383 | 87 |
2362433 | 2362433 | 2022-03-31 | Tyler | Texas | 48457 | 3383 | 86 |
2223253 | 2223253 | 2022-02-17 | Grand | Colorado | 8049 | 3383 | 23 |
2215627 | 2215627 | 2022-02-14 | San German | Puerto Rico | 72125 | 3383 | |
2186587 | 2186587 | 2022-02-05 | Bandera | Texas | 48019 | 3383 | 70 |
2157943 | 2157943 | 2022-01-28 | Crenshaw | Alabama | 1041 | 3383 | 81 |
2154690 | 2154690 | 2022-01-27 | Crenshaw | Alabama | 1041 | 3383 | 81 |
2156019 | 2156019 | 2022-01-27 | Faribault | Minnesota | 27043 | 3383 | 45 |
2156650 | 2156650 | 2022-01-27 | Polk | North Carolina | 37149 | 3383 | 49 |
2157784 | 2157784 | 2022-01-27 | Grant | West Virginia | 54023 | 3383 | 51 |
2151437 | 2151437 | 2022-01-26 | Crenshaw | Alabama | 1041 | 3383 | 81 |
2148185 | 2148185 | 2022-01-25 | Crenshaw | Alabama | 1041 | 3383 | 81 |
2144933 | 2144933 | 2022-01-24 | Crenshaw | Alabama | 1041 | 3383 | 81 |
2146659 | 2146659 | 2022-01-24 | Saline | Nebraska | 31151 | 3383 | 8 |
2126477 | 2126477 | 2022-01-18 | Morgan | Kentucky | 21175 | 3383 | 17 |
2108764 | 2108764 | 2022-01-12 | Duchesne | Utah | 49013 | 3383 | 21 |
2105513 | 2105513 | 2022-01-11 | Duchesne | Utah | 49013 | 3383 | 21 |
2080692 | 2080692 | 2022-01-04 | Dickinson | Iowa | 19059 | 3383 | 60 |
2081710 | 2081710 | 2022-01-04 | Taos | New Mexico | 35055 | 3383 | 73 |
2082897 | 2082897 | 2022-01-04 | Radford city | Virginia | 51750 | 3383 | 39 |
2077440 | 2077440 | 2022-01-03 | Dickinson | Iowa | 19059 | 3383 | 60 |
2079382 | 2079382 | 2022-01-03 | Lavaca | Texas | 48285 | 3383 | 100 |
2074189 | 2074189 | 2022-01-02 | Dickinson | Iowa | 19059 | 3383 | 60 |
2070938 | 2070938 | 2022-01-01 | Dickinson | Iowa | 19059 | 3383 | 60 |
2067687 | 2067687 | 2021-12-31 | Dickinson | Iowa | 19059 | 3383 | 60 |
2064436 | 2064436 | 2021-12-30 | Dickinson | Iowa | 19059 | 3383 | 60 |
2061186 | 2061186 | 2021-12-29 | Dickinson | Iowa | 19059 | 3383 | 60 |
2056476 | 2056476 | 2021-12-27 | Unicoi | Tennessee | 47171 | 3383 | 79 |
2044140 | 2044140 | 2021-12-24 | Fayette | Alabama | 1057 | 3383 | 86 |
2008168 | 2008168 | 2021-12-12 | Adams | Washington | 53001 | 3383 | 34 |
2004917 | 2004917 | 2021-12-11 | Adams | Washington | 53001 | 3383 | 34 |
2001666 | 2001666 | 2021-12-10 | Adams | Washington | 53001 | 3383 | 34 |
1992152 | 1992152 | 2021-12-08 | Monroe | Alabama | 1099 | 3383 | 66 |
1979151 | 1979151 | 2021-12-04 | Monroe | Alabama | 1099 | 3383 | 66 |
1975901 | 1975901 | 2021-12-03 | Monroe | Alabama | 1099 | 3383 | 66 |
1960708 | 1960708 | 2021-11-28 | Simpson | Kentucky | 21213 | 3383 | 62 |
1957457 | 1957457 | 2021-11-27 | Simpson | Kentucky | 21213 | 3383 | 62 |
1954206 | 1954206 | 2021-11-26 | Simpson | Kentucky | 21213 | 3383 | 62 |
1950955 | 1950955 | 2021-11-25 | Simpson | Kentucky | 21213 | 3383 | 62 |
1947704 | 1947704 | 2021-11-24 | Simpson | Kentucky | 21213 | 3383 | 62 |
1945961 | 1945961 | 2021-11-23 | Union | Tennessee | 47173 | 3383 | 50 |
1941441 | 1941441 | 2021-11-22 | Dodge | Minnesota | 27039 | 3383 | 11 |
1905752 | 1905752 | 2021-11-11 | Wabasha | Minnesota | 27157 | 3383 | 8 |
1900204 | 1900204 | 2021-11-09 | Dorado | Puerto Rico | 72051 | 3383 | |
1896954 | 1896954 | 2021-11-08 | Dorado | Puerto Rico | 72051 | 3383 | |
1893704 | 1893704 | 2021-11-07 | Dorado | Puerto Rico | 72051 | 3383 | |
1890454 | 1890454 | 2021-11-06 | Dorado | Puerto Rico | 72051 | 3383 | |
1887204 | 1887204 | 2021-11-05 | Dorado | Puerto Rico | 72051 | 3383 | |
1883954 | 1883954 | 2021-11-04 | Dorado | Puerto Rico | 72051 | 3383 | |
1875386 | 1875386 | 2021-11-02 | Montezuma | Colorado | 8083 | 3383 | 37 |
1872502 | 1872502 | 2021-11-01 | Lawrence | Illinois | 17101 | 3383 | 43 |
1869899 | 1869899 | 2021-10-31 | Menominee | Michigan | 26109 | 3383 | 51 |
1866650 | 1866650 | 2021-10-30 | Menominee | Michigan | 26109 | 3383 | 51 |
1863401 | 1863401 | 2021-10-29 | Menominee | Michigan | 26109 | 3383 | 51 |
1855729 | 1855729 | 2021-10-27 | Columbia | Arkansas | 5027 | 3383 | 73 |
1855904 | 1855904 | 2021-10-27 | Routt | Colorado | 8107 | 3383 | 23 |
1852401 | 1852401 | 2021-10-26 | Marengo | Alabama | 1091 | 3383 | 90 |
1849151 | 1849151 | 2021-10-25 | Marengo | Alabama | 1091 | 3383 | 90 |
1852287 | 1852287 | 2021-10-25 | Jackson | Wisconsin | 55053 | 3383 | 31 |
1845901 | 1845901 | 2021-10-24 | Marengo | Alabama | 1091 | 3383 | 90 |
1832648 | 1832648 | 2021-10-19 | Salem city | Virginia | 51775 | 3383 | 58 |
1820025 | 1820025 | 2021-10-16 | Ouachita | Arkansas | 5103 | 3383 | 83 |
1783407 | 1783407 | 2021-10-04 | Bledsoe | Tennessee | 47007 | 3383 | 14 |
1762546 | 1762546 | 2021-09-28 | St. James | Louisiana | 22093 | 3383 | 68 |
1759615 | 1759615 | 2021-09-27 | Tishomingo | Mississippi | 28141 | 3383 | 89 |
1739696 | 1739696 | 2021-09-21 | Johnson | Kentucky | 21115 | 3383 | 40 |
1724806 | 1724806 | 2021-09-16 | Abbeville | South Carolina | 45001 | 3383 | 43 |
1717969 | 1717969 | 2021-09-14 | Coshocton | Ohio | 39031 | 3383 | 64 |
1696832 | 1696832 | 2021-09-08 | Cook | Georgia | 13075 | 3383 | 49 |
1679567 | 1679567 | 2021-09-02 | Cass | Texas | 48067 | 3383 | 102 |
1671076 | 1671076 | 2021-08-31 | McDonough | Illinois | 17109 | 3383 | 65 |
1653633 | 1653633 | 2021-08-25 | Frio | Texas | 48163 | 3383 | 57 |
1629344 | 1629344 | 2021-08-18 | Plaquemines | Louisiana | 22075 | 3383 | 30 |
1616760 | 1616760 | 2021-08-14 | Miller | Missouri | 29131 | 3383 | 64 |
1599591 | 1599591 | 2021-08-09 | Iroquois | Illinois | 17075 | 3383 | 70 |
1585285 | 1585285 | 2021-08-04 | Lauderdale | Tennessee | 47097 | 3383 | 50 |
1585891 | 1585891 | 2021-08-04 | Juneau | Wisconsin | 55057 | 3383 | 31 |
1582516 | 1582516 | 2021-08-03 | Wise | Virginia | 51195 | 3383 | 105 |
1577593 | 1577593 | 2021-08-02 | Pine | Minnesota | 27115 | 3383 | 23 |
1562263 | 1562263 | 2021-07-28 | Greene | Pennsylvania | 42059 | 3383 | 42 |
1532351 | 1532351 | 2021-07-19 | Warren | Missouri | 29219 | 3383 | 39 |
1474268 | 1474268 | 2021-07-01 | Montgomery | North Carolina | 37123 | 3383 | 97 |
1395961 | 1395961 | 2021-06-07 | Laclede | Missouri | 29105 | 3383 | 70 |
1373173 | 1373173 | 2021-05-31 | Sunflower | Mississippi | 28133 | 3383 | 91 |
1347589 | 1347589 | 2021-05-23 | Greene | New York | 36039 | 3383 | 78 |
1344547 | 1344547 | 2021-05-22 | Champaign | Ohio | 39021 | 3383 | 58 |
1273386 | 1273386 | 2021-04-30 | Arecibo | Puerto Rico | 72013 | 3383 | |
1245361 | 1245361 | 2021-04-22 | Montrose | Colorado | 8085 | 3383 | 57 |
1221348 | 1221348 | 2021-04-14 | Polk | Oregon | 41053 | 3383 | 51 |
1204128 | 1204128 | 2021-04-09 | Huron | Michigan | 26063 | 3383 | 63 |
1165738 | 1165738 | 2021-03-28 | Cortland | New York | 36023 | 3383 | 60 |
1135263 | 1135263 | 2021-03-19 | Bureau | Illinois | 17011 | 3383 | 91 |
1132016 | 1132016 | 2021-03-18 | Bureau | Illinois | 17011 | 3383 | 91 |
1125114 | 1125114 | 2021-03-16 | Humboldt | California | 6023 | 3383 | 34 |
1126469 | 1126469 | 2021-03-16 | Lawrence | Missouri | 29109 | 3383 | 77 |
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);