ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
164 rows where cases = 3235 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- Kansas 12
- Virginia 12
- Ohio 9
- Georgia 8
- Iowa 8
- Missouri 8
- Indiana 7
- Nevada 6
- California 5
- Kentucky 5
- Louisiana 5
- Minnesota 5
- Wisconsin 5
- Florida 4
- Illinois 4
- Michigan 4
- North Carolina 4
- North Dakota 4
- Tennessee 4
- Alabama 3
- Arkansas 3
- Massachusetts 3
- Pennsylvania 3
- Idaho 2
- Maine 2
- Mississippi 2
- Montana 2
- Oregon 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471601 | 2471601 | 2022-05-04 | Cottonwood | Minnesota | 27033 | 3235 | 41 |
2449566 | 2449566 | 2022-04-27 | Harrison | Ohio | 39067 | 3235 | 74 |
2446309 | 2446309 | 2022-04-26 | Harrison | Ohio | 39067 | 3235 | 74 |
2443054 | 2443054 | 2022-04-25 | Harrison | Ohio | 39067 | 3235 | 74 |
2439798 | 2439798 | 2022-04-24 | Harrison | Ohio | 39067 | 3235 | 74 |
2436542 | 2436542 | 2022-04-23 | Harrison | Ohio | 39067 | 3235 | 74 |
2433286 | 2433286 | 2022-04-22 | Harrison | Ohio | 39067 | 3235 | 74 |
2430030 | 2430030 | 2022-04-21 | Harrison | Ohio | 39067 | 3235 | 74 |
2430876 | 2430876 | 2022-04-21 | Brunswick | Virginia | 51025 | 3235 | 47 |
2427620 | 2427620 | 2022-04-20 | Brunswick | Virginia | 51025 | 3235 | 47 |
2383312 | 2383312 | 2022-04-07 | Nemaha | Kansas | 20131 | 3235 | 60 |
2380057 | 2380057 | 2022-04-06 | Nemaha | Kansas | 20131 | 3235 | 60 |
2376802 | 2376802 | 2022-04-05 | Nemaha | Kansas | 20131 | 3235 | 60 |
2373550 | 2373550 | 2022-04-04 | Nemaha | Kansas | 20131 | 3235 | 60 |
2370297 | 2370297 | 2022-04-03 | Nemaha | Kansas | 20131 | 3235 | 60 |
2367044 | 2367044 | 2022-04-02 | Nemaha | Kansas | 20131 | 3235 | 60 |
2363791 | 2363791 | 2022-04-01 | Nemaha | Kansas | 20131 | 3235 | 60 |
2329791 | 2329791 | 2022-03-21 | Jackson | Texas | 48239 | 3235 | 59 |
2326539 | 2326539 | 2022-03-20 | Jackson | Texas | 48239 | 3235 | 59 |
2294425 | 2294425 | 2022-03-10 | Bayfield | Wisconsin | 55007 | 3235 | 38 |
2257525 | 2257525 | 2022-02-27 | McKenzie | North Dakota | 38053 | 3235 | 25 |
2254274 | 2254274 | 2022-02-26 | McKenzie | North Dakota | 38053 | 3235 | 25 |
2226389 | 2226389 | 2022-02-18 | Marion | Arkansas | 5089 | 3235 | 80 |
2214258 | 2214258 | 2022-02-14 | Clinton | Kentucky | 21053 | 3235 | 41 |
2172326 | 2172326 | 2022-02-01 | Pennington | Minnesota | 27113 | 3235 | 36 |
2132662 | 2132662 | 2022-01-20 | Pike | Indiana | 18125 | 3235 | 46 |
2128032 | 2128032 | 2022-01-18 | Bosque | Texas | 48035 | 3235 | 59 |
2113579 | 2113579 | 2022-01-14 | Sagadahoc | Maine | 23023 | 3235 | 23 |
2087157 | 2087157 | 2022-01-06 | Vermillion | Indiana | 18165 | 3235 | 61 |
2039385 | 2039385 | 2021-12-22 | Humboldt | Nevada | 32013 | 3235 | 40 |
2034395 | 2034395 | 2021-12-21 | Hale | Alabama | 1065 | 3235 | 89 |
2019072 | 2019072 | 2021-12-16 | Neosho | Kansas | 20133 | 3235 | 54 |
2015822 | 2015822 | 2021-12-15 | Neosho | Kansas | 20133 | 3235 | 54 |
1995918 | 1995918 | 2021-12-09 | Blaine | Idaho | 16013 | 3235 | 27 |
1996369 | 1996369 | 2021-12-09 | Breckinridge | Kentucky | 21027 | 3235 | 45 |
1972474 | 1972474 | 2021-12-01 | Lincoln | West Virginia | 54043 | 3235 | 52 |
1959792 | 1959792 | 2021-11-28 | Colusa | California | 6011 | 3235 | 19 |
1962352 | 1962352 | 2021-11-28 | Jones | Texas | 48253 | 3235 | 76 |
1956541 | 1956541 | 2021-11-27 | Colusa | California | 6011 | 3235 | 19 |
1959101 | 1959101 | 2021-11-27 | Jones | Texas | 48253 | 3235 | 76 |
1953290 | 1953290 | 2021-11-26 | Colusa | California | 6011 | 3235 | 19 |
1955850 | 1955850 | 2021-11-26 | Jones | Texas | 48253 | 3235 | 76 |
1950039 | 1950039 | 2021-11-25 | Colusa | California | 6011 | 3235 | 19 |
1952599 | 1952599 | 2021-11-25 | Jones | Texas | 48253 | 3235 | 76 |
1946788 | 1946788 | 2021-11-24 | Colusa | California | 6011 | 3235 | 19 |
1948895 | 1948895 | 2021-11-24 | Juniata | Pennsylvania | 42067 | 3235 | 123 |
1949348 | 1949348 | 2021-11-24 | Jones | Texas | 48253 | 3235 | 76 |
1943936 | 1943936 | 2021-11-23 | Minidoka | Idaho | 16067 | 3235 | 49 |
1930197 | 1930197 | 2021-11-18 | Brooke | West Virginia | 54009 | 3235 | 75 |
1923771 | 1923771 | 2021-11-16 | Green Lake | Wisconsin | 55047 | 3235 | 36 |
1905655 | 1905655 | 2021-11-11 | Osceola | Michigan | 26133 | 3235 | 44 |
1902406 | 1902406 | 2021-11-10 | Osceola | Michigan | 26133 | 3235 | 44 |
1892924 | 1892924 | 2021-11-07 | Perry | Missouri | 29157 | 3235 | 33 |
1878855 | 1878855 | 2021-11-03 | Putnam | Georgia | 13237 | 3235 | 81 |
1881230 | 1881230 | 2021-11-03 | Carbon | Utah | 49007 | 3235 | 30 |
1806923 | 1806923 | 2021-10-12 | Randolph | Alabama | 1111 | 3235 | 60 |
1778859 | 1778859 | 2021-10-03 | Franklin | Massachusetts | 25011 | 3235 | 120 |
1775609 | 1775609 | 2021-10-02 | Franklin | Massachusetts | 25011 | 3235 | 120 |
1771174 | 1771174 | 2021-10-01 | Monroe | Alabama | 1099 | 3235 | 57 |
1772359 | 1772359 | 2021-10-01 | Franklin | Massachusetts | 25011 | 3235 | 120 |
1762951 | 1762951 | 2021-09-28 | Nodaway | Missouri | 29147 | 3235 | 33 |
1759702 | 1759702 | 2021-09-27 | Nodaway | Missouri | 29147 | 3235 | 33 |
1756454 | 1756454 | 2021-09-26 | Nodaway | Missouri | 29147 | 3235 | 33 |
1753206 | 1753206 | 2021-09-25 | Nodaway | Missouri | 29147 | 3235 | 33 |
1749958 | 1749958 | 2021-09-24 | Nodaway | Missouri | 29147 | 3235 | 33 |
1746334 | 1746334 | 2021-09-23 | Somerset | Maine | 23025 | 3235 | 40 |
1746708 | 1746708 | 2021-09-23 | Nodaway | Missouri | 29147 | 3235 | 33 |
1743459 | 1743459 | 2021-09-22 | Nodaway | Missouri | 29147 | 3235 | 33 |
1716741 | 1716741 | 2021-09-14 | Jones | Iowa | 19105 | 3235 | 58 |
1713495 | 1713495 | 2021-09-13 | Jones | Iowa | 19105 | 3235 | 58 |
1710248 | 1710248 | 2021-09-12 | Jones | Iowa | 19105 | 3235 | 58 |
1707001 | 1707001 | 2021-09-11 | Jones | Iowa | 19105 | 3235 | 58 |
1703753 | 1703753 | 2021-09-10 | Jones | Iowa | 19105 | 3235 | 58 |
1700054 | 1700054 | 2021-09-09 | Berrien | Georgia | 13019 | 3235 | 53 |
1700503 | 1700503 | 2021-09-09 | Jones | Iowa | 19105 | 3235 | 58 |
1701748 | 1701748 | 2021-09-09 | Hardin | Ohio | 39065 | 3235 | 66 |
1697254 | 1697254 | 2021-09-08 | Jones | Iowa | 19105 | 3235 | 58 |
1699393 | 1699393 | 2021-09-08 | Hopewell city | Virginia | 51670 | 3235 | 83 |
1674089 | 1674089 | 2021-09-01 | Cook | Georgia | 13075 | 3235 | 48 |
1644115 | 1644115 | 2021-08-22 | Amherst | Virginia | 51009 | 3235 | 41 |
1640865 | 1640865 | 2021-08-21 | Amherst | Virginia | 51009 | 3235 | 41 |
1637615 | 1637615 | 2021-08-20 | Amherst | Virginia | 51009 | 3235 | 41 |
1621132 | 1621132 | 2021-08-15 | Dimmit | Texas | 48127 | 3235 | 38 |
1617884 | 1617884 | 2021-08-14 | Dimmit | Texas | 48127 | 3235 | 39 |
1578489 | 1578489 | 2021-08-02 | Clarion | Pennsylvania | 42031 | 3235 | 96 |
1562429 | 1562429 | 2021-07-28 | Union | South Carolina | 45087 | 3235 | 82 |
1554482 | 1554482 | 2021-07-26 | Bell | Kentucky | 21013 | 3235 | 58 |
1511669 | 1511669 | 2021-07-13 | Butts | Georgia | 13035 | 3235 | 90 |
1511887 | 1511887 | 2021-07-13 | Fayette | Illinois | 17051 | 3235 | 59 |
1443247 | 1443247 | 2021-06-22 | Lincoln | Arkansas | 5079 | 3235 | 48 |
1437744 | 1437744 | 2021-06-20 | East Feliciana | Louisiana | 22037 | 3235 | 114 |
1434497 | 1434497 | 2021-06-19 | East Feliciana | Louisiana | 22037 | 3235 | 114 |
1431251 | 1431251 | 2021-06-18 | East Feliciana | Louisiana | 22037 | 3235 | 114 |
1424769 | 1424769 | 2021-06-16 | Jefferson Davis | Louisiana | 22053 | 3235 | 97 |
1422027 | 1422027 | 2021-06-15 | Ravalli | Montana | 30081 | 3235 | 46 |
1407537 | 1407537 | 2021-06-11 | Jackson | Arkansas | 5067 | 3235 | 38 |
1402990 | 1402990 | 2021-06-09 | Guernsey | Ohio | 39059 | 3235 | 53 |
1394955 | 1394955 | 2021-06-07 | White | Georgia | 13311 | 3235 | 82 |
1385220 | 1385220 | 2021-06-04 | White | Georgia | 13311 | 3235 | 81 |
1373465 | 1373465 | 2021-05-31 | Lyon | Nevada | 32019 | 3235 | 65 |
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);