ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where cases = 3418 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Wisconsin 11
- Florida 9
- Texas 9
- Indiana 7
- Arkansas 5
- Illinois 5
- Louisiana 5
- New York 5
- Alabama 4
- Michigan 4
- Mississippi 4
- Ohio 4
- Puerto Rico 4
- Virginia 4
- Colorado 3
- Maryland 3
- Minnesota 3
- Missouri 3
- Oklahoma 3
- Tennessee 3
- Washington 3
- Kentucky 2
- North Carolina 2
- South Carolina 2
- Wyoming 2
- California 1
- Connecticut 1
- Idaho 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424631 | 2424631 | 2022-04-19 | Rusk | Wisconsin | 55107 | 3418 | 54 |
2421375 | 2421375 | 2022-04-18 | Rusk | Wisconsin | 55107 | 3418 | 54 |
2418119 | 2418119 | 2022-04-17 | Rusk | Wisconsin | 55107 | 3418 | 54 |
2414863 | 2414863 | 2022-04-16 | Rusk | Wisconsin | 55107 | 3418 | 54 |
2411607 | 2411607 | 2022-04-15 | Rusk | Wisconsin | 55107 | 3418 | 54 |
2402285 | 2402285 | 2022-04-13 | Brooks | Georgia | 13027 | 3418 | 84 |
2271580 | 2271580 | 2022-03-03 | Klickitat | Washington | 53039 | 3418 | 42 |
2267644 | 2267644 | 2022-03-02 | San German | Puerto Rico | 72125 | 3418 | |
2268328 | 2268328 | 2022-03-02 | Klickitat | Washington | 53039 | 3418 | 42 |
2264391 | 2264391 | 2022-03-01 | San German | Puerto Rico | 72125 | 3418 | |
2261141 | 2261141 | 2022-02-28 | San German | Puerto Rico | 72125 | 3418 | |
2225853 | 2225853 | 2022-02-17 | Wilbarger | Texas | 48487 | 3418 | 85 |
2177176 | 2177176 | 2022-02-02 | Grayson | Virginia | 51077 | 3418 | 68 |
2146417 | 2146417 | 2022-01-24 | Bates | Missouri | 29013 | 3418 | 70 |
2132556 | 2132556 | 2022-01-20 | Mason | Illinois | 17125 | 3418 | 58 |
2089760 | 2089760 | 2022-01-07 | Hempstead | Arkansas | 5057 | 3418 | 49 |
2073371 | 2073371 | 2022-01-02 | Cherokee | Alabama | 1019 | 3418 | 65 |
2044161 | 2044161 | 2021-12-24 | Monroe | Alabama | 1099 | 3418 | 66 |
2032975 | 2032975 | 2021-12-20 | Essex | New York | 36031 | 3418 | 45 |
2013243 | 2013243 | 2021-12-14 | Hill | Montana | 30041 | 3418 | 71 |
1993549 | 1993549 | 2021-12-08 | Jasper | Mississippi | 28061 | 3418 | 67 |
1991113 | 1991113 | 2021-12-07 | Union | Oregon | 41061 | 3418 | 57 |
1987547 | 1987547 | 2021-12-06 | Greene | North Carolina | 37079 | 3418 | 56 |
1962816 | 1962816 | 2021-11-28 | Taylor | Wisconsin | 55119 | 3418 | 48 |
1959565 | 1959565 | 2021-11-27 | Taylor | Wisconsin | 55119 | 3418 | 48 |
1956314 | 1956314 | 2021-11-26 | Taylor | Wisconsin | 55119 | 3418 | 48 |
1953063 | 1953063 | 2021-11-25 | Taylor | Wisconsin | 55119 | 3418 | 48 |
1940266 | 1940266 | 2021-11-22 | Randolph | Arkansas | 5121 | 3418 | 64 |
1930018 | 1930018 | 2021-11-18 | St. Croix | Virgin Islands | 78010 | 3418 | 35 |
1917996 | 1917996 | 2021-11-15 | Lawrence | Illinois | 17101 | 3418 | 44 |
1914588 | 1914588 | 2021-11-14 | Morgan | Georgia | 13211 | 3418 | 44 |
1911338 | 1911338 | 2021-11-13 | Morgan | Georgia | 13211 | 3418 | 44 |
1908089 | 1908089 | 2021-11-12 | Morgan | Georgia | 13211 | 3418 | 44 |
1904837 | 1904837 | 2021-11-11 | Mitchell | Georgia | 13205 | 3418 | 100 |
1901587 | 1901587 | 2021-11-10 | Mitchell | Georgia | 13205 | 3418 | 100 |
1895090 | 1895090 | 2021-11-08 | Morgan | Georgia | 13211 | 3418 | 43 |
1891840 | 1891840 | 2021-11-07 | Morgan | Georgia | 13211 | 3418 | 43 |
1894365 | 1894365 | 2021-11-07 | Page | Virginia | 51139 | 3418 | 79 |
1888590 | 1888590 | 2021-11-06 | Morgan | Georgia | 13211 | 3418 | 43 |
1891115 | 1891115 | 2021-11-06 | Page | Virginia | 51139 | 3418 | 79 |
1885008 | 1885008 | 2021-11-05 | Ouachita | Arkansas | 5103 | 3418 | 85 |
1885340 | 1885340 | 2021-11-05 | Morgan | Georgia | 13211 | 3418 | 43 |
1887865 | 1887865 | 2021-11-05 | Page | Virginia | 51139 | 3418 | 79 |
1868900 | 1868900 | 2021-10-31 | Routt | Colorado | 8107 | 3418 | 23 |
1865651 | 1865651 | 2021-10-30 | Routt | Colorado | 8107 | 3418 | 23 |
1862402 | 1862402 | 2021-10-29 | Routt | Colorado | 8107 | 3418 | 23 |
1863105 | 1863105 | 2021-10-29 | Adair | Kentucky | 21001 | 3418 | 80 |
1859856 | 1859856 | 2021-10-28 | Adair | Kentucky | 21001 | 3418 | 80 |
1829156 | 1829156 | 2021-10-18 | Moore | Texas | 48341 | 3418 | 84 |
1825907 | 1825907 | 2021-10-17 | Moore | Texas | 48341 | 3418 | 84 |
1822658 | 1822658 | 2021-10-16 | Moore | Texas | 48341 | 3418 | 84 |
1814053 | 1814053 | 2021-10-14 | Shelby | Illinois | 17173 | 3418 | 50 |
1793540 | 1793540 | 2021-10-07 | Rutland | Vermont | 50021 | 3418 | 27 |
1786664 | 1786664 | 2021-10-05 | Chester | Tennessee | 47023 | 3418 | 68 |
1779722 | 1779722 | 2021-10-03 | Henry | Ohio | 39069 | 3418 | 69 |
1766031 | 1766031 | 2021-09-29 | Todd | Minnesota | 27153 | 3418 | 35 |
1755034 | 1755034 | 2021-09-26 | Logan | Arkansas | 5083 | 3418 | 34 |
1745496 | 1745496 | 2021-09-23 | Madison | Florida | 12079 | 3418 | 52 |
1742247 | 1742247 | 2021-09-22 | Madison | Florida | 12079 | 3418 | 52 |
1738998 | 1738998 | 2021-09-21 | Madison | Florida | 12079 | 3418 | 52 |
1735749 | 1735749 | 2021-09-20 | Madison | Florida | 12079 | 3418 | 52 |
1732499 | 1732499 | 2021-09-19 | Madison | Florida | 12079 | 3418 | 52 |
1729249 | 1729249 | 2021-09-18 | Madison | Florida | 12079 | 3418 | 52 |
1725999 | 1725999 | 2021-09-17 | Madison | Florida | 12079 | 3418 | 52 |
1721234 | 1721234 | 2021-09-15 | Hardin | Ohio | 39065 | 3418 | 68 |
1694370 | 1694370 | 2021-09-07 | Dorchester | Maryland | 24019 | 3418 | 68 |
1678206 | 1678206 | 2021-09-02 | Mecosta | Michigan | 26107 | 3418 | 38 |
1674958 | 1674958 | 2021-09-01 | Mecosta | Michigan | 26107 | 3418 | 38 |
1596859 | 1596859 | 2021-08-08 | Morehouse | Louisiana | 22067 | 3418 | 80 |
1593610 | 1593610 | 2021-08-07 | Morehouse | Louisiana | 22067 | 3418 | 80 |
1590361 | 1590361 | 2021-08-06 | Morehouse | Louisiana | 22067 | 3418 | 80 |
1558273 | 1558273 | 2021-07-27 | Lafayette | Missouri | 29107 | 3418 | 57 |
1549849 | 1549849 | 2021-07-24 | Willacy | Texas | 48489 | 3418 | 93 |
1518319 | 1518319 | 2021-07-15 | Bonner | Idaho | 16017 | 3418 | 46 |
1516280 | 1516280 | 2021-07-14 | Lyon | Nevada | 32019 | 3418 | 65 |
1340000 | 1340000 | 2021-05-21 | Ripley | Indiana | 18137 | 3418 | 70 |
1334286 | 1334286 | 2021-05-19 | Lawrence | Missouri | 29109 | 3418 | 83 |
1310535 | 1310535 | 2021-05-12 | Toombs | Georgia | 13279 | 3418 | 112 |
1289711 | 1289711 | 2021-05-05 | Clarendon | South Carolina | 45027 | 3418 | 112 |
1278045 | 1278045 | 2021-05-02 | Pickens | Georgia | 13227 | 3418 | 79 |
1279880 | 1279880 | 2021-05-02 | Arecibo | Puerto Rico | 72013 | 3418 | |
1242012 | 1242012 | 2021-04-21 | Yell | Arkansas | 5149 | 3418 | 65 |
1242029 | 1242029 | 2021-04-21 | Lake | California | 6033 | 3418 | 43 |
1243725 | 1243725 | 2021-04-21 | Warren | New York | 36113 | 3418 | 56 |
1239115 | 1239115 | 2021-04-20 | Upson | Georgia | 13293 | 3418 | 125 |
1225912 | 1225912 | 2021-04-16 | Baker | Florida | 12003 | 3418 | 60 |
1207470 | 1207470 | 2021-04-10 | Lyon | Minnesota | 27083 | 3418 | 48 |
1193812 | 1193812 | 2021-04-06 | Adams | Indiana | 18001 | 3418 | 53 |
1190562 | 1190562 | 2021-04-05 | Adams | Indiana | 18001 | 3418 | 53 |
1187315 | 1187315 | 2021-04-04 | Adams | Indiana | 18001 | 3418 | 53 |
1187838 | 1187838 | 2021-04-04 | Worcester | Maryland | 24047 | 3418 | 95 |
1178727 | 1178727 | 2021-04-01 | Cortland | New York | 36023 | 3418 | 60 |
1175745 | 1175745 | 2021-03-31 | Ottawa | Ohio | 39123 | 3418 | 77 |
1172472 | 1172472 | 2021-03-30 | Highland | Ohio | 39071 | 3418 | 58 |
1167916 | 1167916 | 2021-03-29 | Wabash | Indiana | 18169 | 3418 | 77 |
1141554 | 1141554 | 2021-03-21 | Bryan | Georgia | 13029 | 3418 | 36 |
1138308 | 1138308 | 2021-03-20 | Bryan | Georgia | 13029 | 3418 | 36 |
1111927 | 1111927 | 2021-03-11 | Teton | Wyoming | 56039 | 3418 | 9 |
1095087 | 1095087 | 2021-03-06 | Bee | Texas | 48025 | 3418 | 65 |
1091068 | 1091068 | 2021-03-05 | Fulton | New York | 36035 | 3418 | 84 |
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);