ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where cases = 3306 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 16
- Georgia 11
- Illinois 9
- Indiana 8
- Alabama 7
- Wisconsin 7
- Kansas 6
- Arkansas 5
- Michigan 5
- North Carolina 5
- Tennessee 5
- Idaho 4
- Ohio 4
- Oregon 4
- Puerto Rico 4
- Texas 4
- Colorado 3
- Minnesota 3
- Nebraska 3
- New York 3
- Vermont 3
- Florida 2
- Kentucky 2
- Maryland 2
- Missouri 2
- New Hampshire 2
- New Jersey 2
- Pennsylvania 2
- Washington 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444114 | 2444114 | 2022-04-25 | Ashland | Wisconsin | 55003 | 3306 | 36 |
2418068 | 2418068 | 2022-04-17 | Bayfield | Wisconsin | 55007 | 3306 | 40 |
2414812 | 2414812 | 2022-04-16 | Bayfield | Wisconsin | 55007 | 3306 | 40 |
2411556 | 2411556 | 2022-04-15 | Bayfield | Wisconsin | 55007 | 3306 | 40 |
2372343 | 2372343 | 2022-04-03 | Martinsville city | Virginia | 51690 | 3306 | 115 |
2369090 | 2369090 | 2022-04-02 | Martinsville city | Virginia | 51690 | 3306 | 115 |
2365837 | 2365837 | 2022-04-01 | Martinsville city | Virginia | 51690 | 3306 | 115 |
2362584 | 2362584 | 2022-03-31 | Martinsville city | Virginia | 51690 | 3306 | 115 |
2345125 | 2345125 | 2022-03-26 | Unknown | New Jersey | 3306 | 0 | |
2333260 | 2333260 | 2022-03-22 | Dickenson | Virginia | 51051 | 3306 | 47 |
2330007 | 2330007 | 2022-03-21 | Dickenson | Virginia | 51051 | 3306 | 47 |
2326837 | 2326837 | 2022-03-20 | Southampton | Virginia | 51175 | 3306 | 89 |
2323584 | 2323584 | 2022-03-19 | Southampton | Virginia | 51175 | 3306 | 89 |
2320330 | 2320330 | 2022-03-18 | Southampton | Virginia | 51175 | 3306 | 89 |
2290252 | 2290252 | 2022-03-09 | Curry | Oregon | 41015 | 3306 | 44 |
2287724 | 2287724 | 2022-03-08 | Dickenson | Virginia | 51051 | 3306 | 45 |
2256446 | 2256446 | 2022-02-27 | Marion | Kansas | 20115 | 3306 | 39 |
2253195 | 2253195 | 2022-02-26 | Marion | Kansas | 20115 | 3306 | 39 |
2249944 | 2249944 | 2022-02-25 | Marion | Kansas | 20115 | 3306 | 39 |
2215043 | 2215043 | 2022-02-14 | Unknown | New Jersey | 3306 | 0 | |
2216392 | 2216392 | 2022-02-14 | Buffalo | Wisconsin | 55011 | 3306 | 11 |
2176535 | 2176535 | 2022-02-02 | Anasco | Puerto Rico | 72011 | 3306 | |
2169809 | 2169809 | 2022-01-31 | Monroe | Ohio | 39111 | 3306 | 69 |
2166774 | 2166774 | 2022-01-30 | Aibonito | Puerto Rico | 72009 | 3306 | |
2149183 | 2149183 | 2022-01-25 | Caldwell | Kentucky | 21033 | 3306 | 55 |
2125331 | 2125331 | 2022-01-17 | Marquette | Wisconsin | 55077 | 3306 | 43 |
2112007 | 2112007 | 2022-01-13 | Young | Texas | 48503 | 3306 | 74 |
2096824 | 2096824 | 2022-01-09 | White | Illinois | 17193 | 3306 | 45 |
2093572 | 2093572 | 2022-01-08 | White | Illinois | 17193 | 3306 | 45 |
2090320 | 2090320 | 2022-01-07 | White | Illinois | 17193 | 3306 | 45 |
2079526 | 2079526 | 2022-01-03 | Caledonia | Vermont | 50005 | 3306 | 21 |
2076393 | 2076393 | 2022-01-02 | Radford city | Virginia | 51750 | 3306 | 39 |
2073142 | 2073142 | 2022-01-01 | Radford city | Virginia | 51750 | 3306 | 39 |
2069891 | 2069891 | 2021-12-31 | Radford city | Virginia | 51750 | 3306 | 39 |
2063643 | 2063643 | 2021-12-30 | Henry | Alabama | 1067 | 3306 | 66 |
2055752 | 2055752 | 2021-12-27 | Schoharie | New York | 36095 | 3306 | 29 |
2031277 | 2031277 | 2021-12-20 | Phillips | Arkansas | 5107 | 3306 | 79 |
2028026 | 2028026 | 2021-12-19 | Phillips | Arkansas | 5107 | 3306 | 79 |
1968025 | 1968025 | 2021-11-30 | Caswell | North Carolina | 37033 | 3306 | 38 |
1961899 | 1961899 | 2021-11-28 | Juniata | Pennsylvania | 42067 | 3306 | 125 |
1936518 | 1936518 | 2021-11-20 | Windsor | Vermont | 50027 | 3306 | 33 |
1929486 | 1929486 | 2021-11-18 | Rio Grande | Puerto Rico | 72119 | 3306 | |
1926236 | 1926236 | 2021-11-17 | Rio Grande | Puerto Rico | 72119 | 3306 | |
1879563 | 1879563 | 2021-11-03 | Garrett | Maryland | 24023 | 3306 | 81 |
1856655 | 1856655 | 2021-10-27 | Harrison | Kentucky | 21097 | 3306 | 39 |
1836602 | 1836602 | 2021-10-21 | Morgan | Georgia | 13211 | 3306 | 40 |
1837330 | 1837330 | 2021-10-21 | Somerset | Maryland | 24039 | 3306 | 52 |
1834644 | 1834644 | 2021-10-20 | Coos | New Hampshire | 33007 | 3306 | 53 |
1826410 | 1826410 | 2021-10-18 | Monroe | Alabama | 1099 | 3306 | 62 |
1819535 | 1819535 | 2021-10-15 | Washington | Vermont | 50023 | 3306 | 20 |
1792194 | 1792194 | 2021-10-07 | Nodaway | Missouri | 29147 | 3306 | 34 |
1788945 | 1788945 | 2021-10-06 | Nodaway | Missouri | 29147 | 3306 | 34 |
1779308 | 1779308 | 2021-10-03 | Cass | Nebraska | 31025 | 3306 | 19 |
1774499 | 1774499 | 2021-10-02 | Columbia | Arkansas | 5027 | 3306 | 66 |
1776058 | 1776058 | 2021-10-02 | Cass | Nebraska | 31025 | 3306 | 19 |
1772808 | 1772808 | 2021-10-01 | Cass | Nebraska | 31025 | 3306 | 19 |
1773758 | 1773758 | 2021-10-01 | Austin | Texas | 48015 | 3306 | 50 |
1758605 | 1758605 | 2021-09-27 | Lamar | Georgia | 13171 | 3306 | 79 |
1739429 | 1739429 | 2021-09-21 | Washington | Indiana | 18175 | 3306 | 47 |
1741347 | 1741347 | 2021-09-21 | Gillespie | Texas | 48171 | 3306 | 68 |
1702600 | 1702600 | 2021-09-09 | Caroline | Virginia | 51033 | 3306 | 43 |
1650933 | 1650933 | 2021-08-25 | Bibb | Alabama | 1007 | 3306 | 69 |
1647684 | 1647684 | 2021-08-24 | Bibb | Alabama | 1007 | 3306 | 69 |
1644435 | 1644435 | 2021-08-23 | Bibb | Alabama | 1007 | 3306 | 69 |
1632728 | 1632728 | 2021-08-19 | Mecosta | Michigan | 26107 | 3306 | 38 |
1629481 | 1629481 | 2021-08-18 | Mecosta | Michigan | 26107 | 3306 | 38 |
1617096 | 1617096 | 2021-08-14 | Washington | New York | 36115 | 3306 | 56 |
1573369 | 1573369 | 2021-08-01 | Butts | Georgia | 13035 | 3306 | 90 |
1570121 | 1570121 | 2021-07-31 | Butts | Georgia | 13035 | 3306 | 90 |
1566873 | 1566873 | 2021-07-30 | Butts | Georgia | 13035 | 3306 | 90 |
1562546 | 1562546 | 2021-07-28 | Lauderdale | Tennessee | 47097 | 3306 | 50 |
1563211 | 1563211 | 2021-07-28 | Sheridan | Wyoming | 56033 | 3306 | 31 |
1559963 | 1559963 | 2021-07-27 | Sheridan | Wyoming | 56033 | 3306 | 31 |
1547131 | 1547131 | 2021-07-24 | Lincoln | Arkansas | 5079 | 3306 | 49 |
1520811 | 1520811 | 2021-07-15 | Wise | Virginia | 51195 | 3306 | 105 |
1506996 | 1506996 | 2021-07-11 | Benton | Oregon | 41003 | 3306 | 22 |
1503750 | 1503750 | 2021-07-10 | Benton | Oregon | 41003 | 3306 | 22 |
1500504 | 1500504 | 2021-07-09 | Benton | Oregon | 41003 | 3306 | 22 |
1440978 | 1440978 | 2021-06-21 | Beauregard | Louisiana | 22011 | 3306 | 79 |
1382807 | 1382807 | 2021-06-03 | Nicollet | Minnesota | 27103 | 3306 | 44 |
1372258 | 1372258 | 2021-05-31 | Bonner | Idaho | 16017 | 3306 | 43 |
1369013 | 1369013 | 2021-05-30 | Bonner | Idaho | 16017 | 3306 | 43 |
1365767 | 1365767 | 2021-05-29 | Bonner | Idaho | 16017 | 3306 | 43 |
1362521 | 1362521 | 2021-05-28 | Bonner | Idaho | 16017 | 3306 | 43 |
1272932 | 1272932 | 2021-04-30 | Otsego | New York | 36077 | 3306 | 47 |
1255740 | 1255740 | 2021-04-25 | Geary | Kansas | 20061 | 3306 | 40 |
1252493 | 1252493 | 2021-04-24 | Geary | Kansas | 20061 | 3306 | 40 |
1249246 | 1249246 | 2021-04-23 | Geary | Kansas | 20061 | 3306 | 40 |
1187113 | 1187113 | 2021-04-04 | Pickens | Georgia | 13227 | 3306 | 74 |
1183866 | 1183866 | 2021-04-03 | Pickens | Georgia | 13227 | 3306 | 74 |
1174887 | 1174887 | 2021-03-31 | Delta | Michigan | 26041 | 3306 | 86 |
1171148 | 1171148 | 2021-03-30 | Ripley | Indiana | 18137 | 3306 | 66 |
1167406 | 1167406 | 2021-03-29 | La Plata | Colorado | 8067 | 3306 | 37 |
1167868 | 1167868 | 2021-03-29 | Jasper | Indiana | 18073 | 3306 | 48 |
1167900 | 1167900 | 2021-03-29 | Ripley | Indiana | 18137 | 3306 | 66 |
1164652 | 1164652 | 2021-03-28 | Ripley | Indiana | 18137 | 3306 | 66 |
1161404 | 1161404 | 2021-03-27 | Ripley | Indiana | 18137 | 3306 | 66 |
1158156 | 1158156 | 2021-03-26 | Ripley | Indiana | 18137 | 3306 | 66 |
1159165 | 1159165 | 2021-03-26 | Belknap | New Hampshire | 33001 | 3306 | 94 |
1147931 | 1147931 | 2021-03-23 | Montrose | Colorado | 8085 | 3306 | 57 |
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);