ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 4082 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 8
- Minnesota 7
- Illinois 6
- Tennessee 6
- Alabama 5
- Georgia 5
- Mississippi 5
- Virginia 5
- Louisiana 4
- Kansas 3
- Kentucky 3
- Pennsylvania 3
- Puerto Rico 3
- Wisconsin 3
- California 2
- Florida 2
- Maryland 2
- New York 2
- Ohio 2
- Oregon 2
- Texas 2
- Arkansas 1
- Colorado 1
- Indiana 1
- Maine 1
- New Hampshire 1
- New Jersey 1
- North Carolina 1
- Oklahoma 1
- Vermont 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497013 | 2497013 | 2022-05-12 | Warren | Illinois | 17187 | 4082 | 87 |
2487188 | 2487188 | 2022-05-09 | Jo Daviess | Illinois | 17085 | 4082 | 39 |
2464415 | 2464415 | 2022-05-02 | Moultrie | Illinois | 17139 | 4082 | 52 |
2424685 | 2424685 | 2022-04-20 | Clay | Alabama | 1027 | 4082 | 82 |
2421429 | 2421429 | 2022-04-19 | Clay | Alabama | 1027 | 4082 | 81 |
2374939 | 2374939 | 2022-04-04 | Catano | Puerto Rico | 72033 | 4082 | |
2288026 | 2288026 | 2022-03-09 | Clay | Alabama | 1027 | 4082 | 78 |
2278424 | 2278424 | 2022-03-06 | Polk | Arkansas | 5113 | 4082 | 136 |
2264289 | 2264289 | 2022-03-01 | Fulton | Pennsylvania | 42057 | 4082 | 64 |
2203388 | 2203388 | 2022-02-10 | Crawford | Wisconsin | 55023 | 4082 | 28 |
2193591 | 2193591 | 2022-02-07 | Morgan | West Virginia | 54065 | 4082 | 60 |
2155863 | 2155863 | 2022-01-27 | Knox | Maine | 23013 | 4082 | 22 |
2129042 | 2129042 | 2022-01-19 | Berrien | Georgia | 13019 | 4082 | 72 |
2109805 | 2109805 | 2022-01-13 | Pike | Illinois | 17149 | 4082 | 64 |
2105338 | 2105338 | 2022-01-11 | Gillespie | Texas | 48171 | 4082 | 84 |
2092544 | 2092544 | 2022-01-07 | Windham | Vermont | 50025 | 4082 | 31 |
2058597 | 2058597 | 2021-12-28 | Tishomingo | Mississippi | 28141 | 4082 | 97 |
2052137 | 2052137 | 2021-12-26 | Crawford | Missouri | 29055 | 4082 | 78 |
2048887 | 2048887 | 2021-12-25 | Crawford | Missouri | 29055 | 4082 | 78 |
2045637 | 2045637 | 2021-12-24 | Crawford | Missouri | 29055 | 4082 | 78 |
2042387 | 2042387 | 2021-12-23 | Crawford | Missouri | 29055 | 4082 | 78 |
1997348 | 1997348 | 2021-12-09 | Transylvania | North Carolina | 37175 | 4082 | 52 |
1973708 | 1973708 | 2021-12-02 | Russell | Kentucky | 21207 | 4082 | 63 |
1900467 | 1900467 | 2021-11-09 | Wayne | Tennessee | 47181 | 4082 | 39 |
1847312 | 1847312 | 2021-10-24 | Leake | Mississippi | 28079 | 4082 | 88 |
1847448 | 1847448 | 2021-10-24 | Saline | Missouri | 29195 | 4082 | 46 |
1844062 | 1844062 | 2021-10-23 | Leake | Mississippi | 28079 | 4082 | 88 |
1840812 | 1840812 | 2021-10-22 | Leake | Mississippi | 28079 | 4082 | 88 |
1837563 | 1837563 | 2021-10-21 | Leake | Mississippi | 28079 | 4082 | 88 |
1814703 | 1814703 | 2021-10-14 | Cass | Minnesota | 27021 | 4082 | 42 |
1680212 | 1680212 | 2021-09-03 | Pike | Alabama | 1109 | 4082 | 84 |
1678518 | 1678518 | 2021-09-02 | Warren | Missouri | 29219 | 4082 | 39 |
1659737 | 1659737 | 2021-08-27 | Perry | Pennsylvania | 42099 | 4082 | 102 |
1648862 | 1648862 | 2021-08-24 | West Baton Rouge | Louisiana | 22121 | 4082 | 67 |
1648907 | 1648907 | 2021-08-24 | Worcester | Maryland | 24047 | 4082 | 108 |
1619371 | 1619371 | 2021-08-15 | Geary | Kansas | 20061 | 4082 | 47 |
1616123 | 1616123 | 2021-08-14 | Geary | Kansas | 20061 | 4082 | 47 |
1612874 | 1612874 | 2021-08-13 | Geary | Kansas | 20061 | 4082 | 47 |
1536307 | 1536307 | 2021-07-20 | Pike | Pennsylvania | 42103 | 4082 | 54 |
1490789 | 1490789 | 2021-07-06 | Polk | Oregon | 41053 | 4082 | 56 |
1483897 | 1483897 | 2021-07-04 | Columbia | New York | 36021 | 4082 | 104 |
1480651 | 1480651 | 2021-07-03 | Columbia | New York | 36021 | 4082 | 104 |
1476879 | 1476879 | 2021-07-02 | Beltrami | Minnesota | 27007 | 4082 | 63 |
1470387 | 1470387 | 2021-06-30 | Beltrami | Minnesota | 27007 | 4082 | 62 |
1383816 | 1383816 | 2021-06-03 | Ponce | Puerto Rico | 72113 | 4082 | |
1381151 | 1381151 | 2021-06-02 | Franklin | Virginia | 51067 | 4082 | 79 |
1377325 | 1377325 | 2021-06-01 | Ponce | Puerto Rico | 72113 | 4082 | |
1374660 | 1374660 | 2021-05-31 | Franklin | Virginia | 51067 | 4082 | 78 |
1371415 | 1371415 | 2021-05-30 | Franklin | Virginia | 51067 | 4082 | 78 |
1353997 | 1353997 | 2021-05-25 | Belknap | New Hampshire | 33001 | 4082 | 100 |
1336460 | 1336460 | 2021-05-20 | Liberty | Georgia | 13179 | 4082 | 64 |
1337359 | 1337359 | 2021-05-20 | Nobles | Minnesota | 27105 | 4082 | 48 |
1333103 | 1333103 | 2021-05-19 | Okeechobee | Florida | 12093 | 4082 | 89 |
1333889 | 1333889 | 2021-05-19 | Natchitoches | Louisiana | 22069 | 4082 | 91 |
1334112 | 1334112 | 2021-05-19 | Nobles | Minnesota | 27105 | 4082 | 48 |
1330642 | 1330642 | 2021-05-18 | Natchitoches | Louisiana | 22069 | 4082 | 91 |
1330865 | 1330865 | 2021-05-18 | Nobles | Minnesota | 27105 | 4082 | 48 |
1319363 | 1319363 | 2021-05-14 | Washington | Texas | 48477 | 4082 | 93 |
1288638 | 1288638 | 2021-05-05 | Isanti | Minnesota | 27059 | 4082 | 62 |
1285547 | 1285547 | 2021-05-04 | Camden | Missouri | 29029 | 4082 | 87 |
1256894 | 1256894 | 2021-04-25 | Defiance | Ohio | 39039 | 4082 | 96 |
1246654 | 1246654 | 2021-04-22 | Platte | Missouri | 29165 | 4082 | 47 |
1243033 | 1243033 | 2021-04-21 | Calvert | Maryland | 24009 | 4082 | 76 |
1224875 | 1224875 | 2021-04-15 | Campbell | Tennessee | 47013 | 4082 | 62 |
1213641 | 1213641 | 2021-04-12 | Graves | Kentucky | 21083 | 4082 | 90 |
1178979 | 1178979 | 2021-04-01 | Madison | Ohio | 39097 | 4082 | 57 |
1147895 | 1147895 | 2021-03-23 | Broomfield | Colorado | 8014 | 4082 | 74 |
1137645 | 1137645 | 2021-03-19 | James City | Virginia | 51095 | 4082 | 69 |
1131363 | 1131363 | 2021-03-17 | Polk | Wisconsin | 55095 | 4082 | 48 |
1120618 | 1120618 | 2021-03-14 | Mayes | Oklahoma | 40097 | 4082 | 39 |
1112664 | 1112664 | 2021-03-12 | Harrison | Indiana | 18061 | 4082 | 68 |
1080575 | 1080575 | 2021-03-02 | Scott | Kentucky | 21209 | 4082 | 26 |
1043098 | 1043098 | 2021-02-18 | Lincoln | Tennessee | 47103 | 4082 | 61 |
1043118 | 1043118 | 2021-02-18 | Rhea | Tennessee | 47143 | 4082 | 70 |
1011839 | 1011839 | 2021-02-09 | Thomas | Georgia | 13275 | 4082 | 100 |
1007747 | 1007747 | 2021-02-07 | Albemarle | Virginia | 51003 | 4082 | 38 |
971707 | 971707 | 2021-01-27 | Obion | Tennessee | 47131 | 4082 | 86 |
966110 | 966110 | 2021-01-26 | Tehama | California | 6103 | 4082 | 46 |
953528 | 953528 | 2021-01-22 | Henry | Illinois | 17073 | 4082 | 77 |
886971 | 886971 | 2021-01-01 | Deschutes | Oregon | 41017 | 4082 | 22 |
839712 | 839712 | 2020-12-18 | Bulloch | Georgia | 13031 | 4082 | 56 |
813690 | 813690 | 2020-12-10 | Jackson | Florida | 12063 | 4082 | 102 |
806909 | 806909 | 2020-12-08 | Talladega | Alabama | 1121 | 4082 | 62 |
797644 | 797644 | 2020-12-05 | Troup | Georgia | 13285 | 4082 | 126 |
751669 | 751669 | 2020-11-20 | Natrona | Wyoming | 56025 | 4082 | 36 |
731561 | 731561 | 2020-11-14 | Sevier | Tennessee | 47155 | 4082 | 27 |
661527 | 661527 | 2020-10-24 | Rock Island | Illinois | 17161 | 4082 | 99 |
655486 | 655486 | 2020-10-22 | Bossier | Louisiana | 22015 | 4082 | 117 |
592662 | 592662 | 2020-10-02 | Kenosha | Wisconsin | 55059 | 4082 | 68 |
373285 | 373285 | 2020-07-27 | Monterey | California | 6053 | 4082 | 23 |
34541 | 34541 | 2020-04-05 | Essex | New Jersey | 34013 | 4082 | 172 |
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);