ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 4435 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Illinois 7
- Ohio 7
- Oklahoma 7
- Michigan 6
- Louisiana 5
- Arkansas 4
- Kansas 4
- Minnesota 4
- North Carolina 4
- Puerto Rico 4
- South Carolina 4
- California 3
- Indiana 3
- Missouri 3
- New Jersey 3
- New York 3
- Pennsylvania 3
- Florida 2
- Georgia 2
- Kentucky 2
- Maryland 2
- Tennessee 2
- Texas 2
- Wyoming 2
- Alabama 1
- Mississippi 1
- New Mexico 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2438324 | 2438324 | 2022-04-24 | Ford | Illinois | 17053 | 4435 | 73 |
2435068 | 2435068 | 2022-04-23 | Ford | Illinois | 17053 | 4435 | 73 |
2431812 | 2431812 | 2022-04-22 | Ford | Illinois | 17053 | 4435 | 73 |
2429116 | 2429116 | 2022-04-21 | Winn | Louisiana | 22127 | 4435 | 63 |
2425860 | 2425860 | 2022-04-20 | Winn | Louisiana | 22127 | 4435 | 63 |
2291910 | 2291910 | 2022-03-10 | Johnson | Illinois | 17087 | 4435 | 46 |
2288658 | 2288658 | 2022-03-09 | Johnson | Illinois | 17087 | 4435 | 46 |
2266601 | 2266601 | 2022-03-02 | Houston | Minnesota | 27055 | 4435 | 18 |
2228619 | 2228619 | 2022-02-18 | Morovis | Puerto Rico | 72101 | 4435 | |
2193910 | 2193910 | 2022-02-08 | Inyo | California | 6027 | 4435 | 51 |
2195882 | 2195882 | 2022-02-08 | Craig | Oklahoma | 40035 | 4435 | 42 |
2192628 | 2192628 | 2022-02-07 | Craig | Oklahoma | 40035 | 4435 | 42 |
2188463 | 2188463 | 2022-02-06 | Cheboygan | Michigan | 26031 | 4435 | 91 |
2189374 | 2189374 | 2022-02-06 | Craig | Oklahoma | 40035 | 4435 | 42 |
2185210 | 2185210 | 2022-02-05 | Cheboygan | Michigan | 26031 | 4435 | 91 |
2186121 | 2186121 | 2022-02-05 | Craig | Oklahoma | 40035 | 4435 | 42 |
2181958 | 2181958 | 2022-02-04 | Cheboygan | Michigan | 26031 | 4435 | 91 |
2182869 | 2182869 | 2022-02-04 | Craig | Oklahoma | 40035 | 4435 | 42 |
2183046 | 2183046 | 2022-02-04 | Camuy | Puerto Rico | 72027 | 4435 | |
2179617 | 2179617 | 2022-02-03 | Craig | Oklahoma | 40035 | 4435 | 42 |
2176366 | 2176366 | 2022-02-02 | Craig | Oklahoma | 40035 | 4435 | 42 |
2164563 | 2164563 | 2022-01-30 | Cross | Arkansas | 5037 | 4435 | 73 |
2161308 | 2161308 | 2022-01-29 | Cross | Arkansas | 5037 | 4435 | 73 |
2158052 | 2158052 | 2022-01-28 | Cross | Arkansas | 5037 | 4435 | 73 |
2148939 | 2148939 | 2022-01-25 | Rush | Indiana | 18139 | 4435 | 41 |
2140294 | 2140294 | 2022-01-22 | Schoharie | New York | 36095 | 4435 | 32 |
2131476 | 2131476 | 2022-01-19 | Scurry | Texas | 48415 | 4435 | 95 |
2110179 | 2110179 | 2022-01-13 | Harrison | Kentucky | 21097 | 4435 | 57 |
2107417 | 2107417 | 2022-01-12 | Henry | Missouri | 29083 | 4435 | 66 |
2087585 | 2087585 | 2022-01-06 | Garrett | Maryland | 24023 | 4435 | 98 |
1975970 | 1975970 | 2021-12-03 | Carroll | Arkansas | 5015 | 4435 | 77 |
1967410 | 1967410 | 2021-11-30 | Oceana | Michigan | 26127 | 4435 | 75 |
1964158 | 1964158 | 2021-11-29 | Oceana | Michigan | 26127 | 4435 | 75 |
1925345 | 1925345 | 2021-11-17 | Barry | Missouri | 29009 | 4435 | 64 |
1922096 | 1922096 | 2021-11-16 | Barry | Missouri | 29009 | 4435 | 64 |
1878883 | 1878883 | 2021-11-03 | Unknown | Georgia | 4435 | 7 | |
1877534 | 1877534 | 2021-11-02 | Edgefield | South Carolina | 45037 | 4435 | 57 |
1873235 | 1873235 | 2021-11-01 | Pine | Minnesota | 27115 | 4435 | 33 |
1874285 | 1874285 | 2021-11-01 | Edgefield | South Carolina | 45037 | 4435 | 57 |
1859051 | 1859051 | 2021-10-28 | Glenn | California | 6021 | 4435 | 45 |
1854762 | 1854762 | 2021-10-26 | Vega Baja | Puerto Rico | 72145 | 4435 | |
1790413 | 1790413 | 2021-10-06 | Smyth | Virginia | 51173 | 4435 | 105 |
1783157 | 1783157 | 2021-10-04 | Clinton | Pennsylvania | 42035 | 4435 | 71 |
1765767 | 1765767 | 2021-09-29 | East Feliciana | Louisiana | 22037 | 4435 | 140 |
1757004 | 1757004 | 2021-09-26 | Ottawa | Ohio | 39123 | 4435 | 84 |
1740709 | 1740709 | 2021-09-21 | Champaign | Ohio | 39021 | 4435 | 64 |
1737726 | 1737726 | 2021-09-20 | Arecibo | Puerto Rico | 72013 | 4435 | |
1717120 | 1717120 | 2021-09-14 | Worcester | Maryland | 24047 | 4435 | 111 |
1679486 | 1679486 | 2021-09-02 | Lauderdale | Tennessee | 47097 | 4435 | 50 |
1580409 | 1580409 | 2021-08-03 | Lyon | Kansas | 20111 | 4435 | 87 |
1577160 | 1577160 | 2021-08-02 | Lyon | Kansas | 20111 | 4435 | 88 |
1578991 | 1578991 | 2021-08-02 | Matagorda | Texas | 48321 | 4435 | 115 |
1543071 | 1543071 | 2021-07-22 | Marshall | Tennessee | 47117 | 4435 | 63 |
1518421 | 1518421 | 2021-07-15 | Monroe | Illinois | 17133 | 4435 | 94 |
1500137 | 1500137 | 2021-07-09 | Fulton | New York | 36035 | 4435 | 93 |
1463209 | 1463209 | 2021-06-28 | Jefferson | Illinois | 17081 | 4435 | 123 |
1425526 | 1425526 | 2021-06-16 | Alexander | North Carolina | 37003 | 4435 | 85 |
1409500 | 1409500 | 2021-06-11 | Madison | Ohio | 39097 | 4435 | 65 |
1395139 | 1395139 | 2021-06-07 | Gibson | Indiana | 18051 | 4435 | 95 |
1375273 | 1375273 | 2021-06-01 | DeSoto | Florida | 12027 | 4435 | 97 |
1330843 | 1330843 | 2021-05-18 | Itasca | Minnesota | 27061 | 4435 | 56 |
1329464 | 1329464 | 2021-05-17 | Albany | Wyoming | 56001 | 4435 | 12 |
1308221 | 1308221 | 2021-05-11 | Marshall | Mississippi | 28093 | 4435 | 103 |
1253669 | 1253669 | 2021-04-24 | Knox | Ohio | 39083 | 4435 | 109 |
1197733 | 1197733 | 2021-04-07 | Mower | Minnesota | 27099 | 4435 | 32 |
1187052 | 1187052 | 2021-04-04 | Effingham | Georgia | 13103 | 4435 | 65 |
1147990 | 1147990 | 2021-03-23 | Hendry | Florida | 12051 | 4435 | 77 |
1138955 | 1138955 | 2021-03-20 | Henderson | Kentucky | 21101 | 4435 | 70 |
1084579 | 1084579 | 2021-03-03 | Genesee | New York | 36037 | 4435 | 118 |
1016863 | 1016863 | 2021-02-10 | Mifflin | Pennsylvania | 42087 | 4435 | 165 |
990705 | 990705 | 2021-02-02 | Mercer | Ohio | 39107 | 4435 | 93 |
986665 | 986665 | 2021-02-01 | St. Joseph | Michigan | 26149 | 4435 | 75 |
987412 | 987412 | 2021-02-01 | Belmont | Ohio | 39013 | 4435 | 48 |
982081 | 982081 | 2021-01-30 | Fremont | Wyoming | 56013 | 4435 | 77 |
955155 | 955155 | 2021-01-22 | Armstrong | Pennsylvania | 42005 | 4435 | 98 |
936611 | 936611 | 2021-01-16 | Oconto | Wisconsin | 55083 | 4435 | 48 |
873848 | 873848 | 2020-12-28 | Hancock | Ohio | 39063 | 4435 | 77 |
841756 | 841756 | 2020-12-18 | Oconee | South Carolina | 45073 | 4435 | 54 |
830514 | 830514 | 2020-12-15 | Leavenworth | Kansas | 20103 | 4435 | 35 |
827268 | 827268 | 2020-12-14 | Leavenworth | Kansas | 20103 | 4435 | 35 |
807085 | 807085 | 2020-12-08 | Sutter | California | 6101 | 4435 | 26 |
802303 | 802303 | 2020-12-06 | Harnett | North Carolina | 37085 | 4435 | 79 |
745212 | 745212 | 2020-11-19 | DeKalb | Alabama | 1049 | 4435 | 34 |
745906 | 745906 | 2020-11-19 | Delaware | Indiana | 18035 | 4435 | 105 |
730754 | 730754 | 2020-11-14 | Cumberland | New Jersey | 34011 | 4435 | 170 |
704993 | 704993 | 2020-11-06 | Rowan | North Carolina | 37159 | 4435 | 122 |
675741 | 675741 | 2020-10-28 | Catawba | North Carolina | 37035 | 4435 | 62 |
630223 | 630223 | 2020-10-14 | McKinley | New Mexico | 35031 | 4435 | 260 |
623068 | 623068 | 2020-10-12 | Rapides | Louisiana | 22079 | 4435 | 151 |
564731 | 564731 | 2020-09-24 | Tangipahoa | Louisiana | 22105 | 4435 | 118 |
565353 | 565353 | 2020-09-24 | Gloucester | New Jersey | 34015 | 4435 | 227 |
501291 | 501291 | 2020-09-04 | York | South Carolina | 45091 | 4435 | 51 |
77255 | 77255 | 2020-04-21 | Morris | New Jersey | 34027 | 4435 | 291 |
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);