ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
202 rows where cases = 2340 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 20
- West Virginia 20
- Kentucky 17
- Nebraska 11
- Arkansas 8
- Oklahoma 8
- Alabama 7
- Georgia 7
- Indiana 7
- Michigan 7
- Mississippi 7
- North Carolina 7
- Alaska 4
- Illinois 4
- Kansas 4
- Maryland 4
- Minnesota 4
- Missouri 4
- Ohio 4
- Virginia 4
- Wisconsin 4
- California 3
- Idaho 3
- Puerto Rico 3
- South Carolina 3
- Colorado 2
- Florida 2
- Iowa 2
- Louisiana 2
- Montana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492697 | 2492697 | 2022-05-10 | Grand | Utah | 49019 | 2340 | 6 |
2474908 | 2474908 | 2022-05-05 | Rock | Minnesota | 27133 | 2340 | 34 |
2440809 | 2440809 | 2022-04-24 | Clay | West Virginia | 54015 | 2340 | 41 |
2437553 | 2437553 | 2022-04-23 | Clay | West Virginia | 54015 | 2340 | 41 |
2434297 | 2434297 | 2022-04-22 | Clay | West Virginia | 54015 | 2340 | 41 |
2429608 | 2429608 | 2022-04-21 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2431041 | 2431041 | 2022-04-21 | Clay | West Virginia | 54015 | 2340 | 41 |
2426352 | 2426352 | 2022-04-20 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2427785 | 2427785 | 2022-04-20 | Clay | West Virginia | 54015 | 2340 | 41 |
2423096 | 2423096 | 2022-04-19 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2424529 | 2424529 | 2022-04-19 | Clay | West Virginia | 54015 | 2340 | 41 |
2419839 | 2419839 | 2022-04-18 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2421273 | 2421273 | 2022-04-18 | Clay | West Virginia | 54015 | 2340 | 40 |
2416584 | 2416584 | 2022-04-17 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2418017 | 2418017 | 2022-04-17 | Clay | West Virginia | 54015 | 2340 | 40 |
2413328 | 2413328 | 2022-04-16 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2414761 | 2414761 | 2022-04-16 | Clay | West Virginia | 54015 | 2340 | 40 |
2410072 | 2410072 | 2022-04-15 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2411505 | 2411505 | 2022-04-15 | Clay | West Virginia | 54015 | 2340 | 40 |
2406816 | 2406816 | 2022-04-14 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2408249 | 2408249 | 2022-04-14 | Clay | West Virginia | 54015 | 2340 | 40 |
2403560 | 2403560 | 2022-04-13 | Box Butte | Nebraska | 31013 | 2340 | 17 |
2404993 | 2404993 | 2022-04-13 | Clay | West Virginia | 54015 | 2340 | 40 |
2401738 | 2401738 | 2022-04-12 | Clay | West Virginia | 54015 | 2340 | 40 |
2398483 | 2398483 | 2022-04-11 | Clay | West Virginia | 54015 | 2340 | 40 |
2395228 | 2395228 | 2022-04-10 | Clay | West Virginia | 54015 | 2340 | 40 |
2391972 | 2391972 | 2022-04-09 | Clay | West Virginia | 54015 | 2340 | 40 |
2388716 | 2388716 | 2022-04-08 | Clay | West Virginia | 54015 | 2340 | 40 |
2385461 | 2385461 | 2022-04-07 | Clay | West Virginia | 54015 | 2340 | 40 |
2382206 | 2382206 | 2022-04-06 | Clay | West Virginia | 54015 | 2340 | 40 |
2339571 | 2339571 | 2022-03-24 | La Salle | Texas | 48283 | 2340 | 48 |
2336317 | 2336317 | 2022-03-23 | La Salle | Texas | 48283 | 2340 | 48 |
2194317 | 2194317 | 2022-02-08 | Brown | Illinois | 17009 | 2340 | 19 |
2168828 | 2168828 | 2022-01-31 | East Carroll | Louisiana | 22035 | 2340 | 35 |
2145986 | 2145986 | 2022-01-24 | Lyon | Kentucky | 21143 | 2340 | 31 |
2122154 | 2122154 | 2022-01-17 | Coosa | Alabama | 1037 | 2340 | 48 |
2111539 | 2111539 | 2022-01-13 | Villalba | Puerto Rico | 72149 | 2340 | |
2104098 | 2104098 | 2022-01-11 | Perry | Mississippi | 28111 | 2340 | 57 |
2064842 | 2064842 | 2021-12-30 | Dukes | Massachusetts | 25007 | 2340 | 0 |
2030773 | 2030773 | 2021-12-19 | Addison | Vermont | 50001 | 2340 | 10 |
2016182 | 2016182 | 2021-12-15 | Unknown | Michigan | 2340 | 24 | |
2005186 | 2005186 | 2021-12-12 | Kusilvak Census Area | Alaska | 2158 | 2340 | 9 |
2001935 | 2001935 | 2021-12-11 | Kusilvak Census Area | Alaska | 2158 | 2340 | 9 |
1998685 | 1998685 | 2021-12-10 | Kusilvak Census Area | Alaska | 2158 | 2340 | 9 |
1973639 | 1973639 | 2021-12-02 | Fleming | Kentucky | 21069 | 2340 | 40 |
1974920 | 1974920 | 2021-12-02 | Potter | Pennsylvania | 42105 | 2340 | 65 |
1926654 | 1926654 | 2021-11-17 | Pecos | Texas | 48371 | 2340 | 52 |
1923404 | 1923404 | 2021-11-16 | Pecos | Texas | 48371 | 2340 | 52 |
1920155 | 1920155 | 2021-11-15 | Pecos | Texas | 48371 | 2340 | 52 |
1916905 | 1916905 | 2021-11-14 | Pecos | Texas | 48371 | 2340 | 52 |
1906401 | 1906401 | 2021-11-11 | Walsh | North Dakota | 38099 | 2340 | 29 |
1895945 | 1895945 | 2021-11-08 | Faribault | Minnesota | 27043 | 2340 | 31 |
1872103 | 1872103 | 2021-11-01 | Chaffee | Colorado | 8015 | 2340 | 31 |
1867384 | 1867384 | 2021-10-30 | McKenzie | North Dakota | 38053 | 2340 | 21 |
1863663 | 1863663 | 2021-10-29 | Madison | Missouri | 29123 | 2340 | 25 |
1847353 | 1847353 | 2021-10-24 | Yalobusha | Mississippi | 28161 | 2340 | 47 |
1844103 | 1844103 | 2021-10-23 | Yalobusha | Mississippi | 28161 | 2340 | 47 |
1840853 | 1840853 | 2021-10-22 | Yalobusha | Mississippi | 28161 | 2340 | 47 |
1837952 | 1837952 | 2021-10-21 | Taos | New Mexico | 35055 | 2340 | 63 |
1825490 | 1825490 | 2021-10-17 | Manati | Puerto Rico | 72091 | 2340 | |
1807477 | 1807477 | 2021-10-12 | Carroll | Illinois | 17015 | 2340 | 39 |
1807931 | 1807931 | 2021-10-12 | Larue | Kentucky | 21123 | 2340 | 44 |
1768994 | 1768994 | 2021-09-30 | Webster | Kentucky | 21233 | 2340 | 33 |
1763291 | 1763291 | 2021-09-28 | Bertie | North Carolina | 37015 | 2340 | 48 |
1745401 | 1745401 | 2021-09-23 | Elbert | Colorado | 8039 | 2340 | 18 |
1746191 | 1746191 | 2021-09-23 | Jackson | Kentucky | 21109 | 2340 | 46 |
1746249 | 1746249 | 2021-09-23 | Union | Kentucky | 21225 | 2340 | 25 |
1744840 | 1744840 | 2021-09-22 | Colonial Heights city | Virginia | 51570 | 2340 | 64 |
1736783 | 1736783 | 2021-09-20 | Roseau | Minnesota | 27135 | 2340 | 23 |
1710111 | 1710111 | 2021-09-12 | Carroll | Indiana | 18015 | 2340 | 27 |
1706864 | 1706864 | 2021-09-11 | Carroll | Indiana | 18015 | 2340 | 27 |
1703616 | 1703616 | 2021-09-10 | Carroll | Indiana | 18015 | 2340 | 27 |
1695344 | 1695344 | 2021-09-07 | Kingfisher | Oklahoma | 40073 | 2340 | 43 |
1696335 | 1696335 | 2021-09-07 | Iowa | Wisconsin | 55049 | 2340 | 14 |
1692096 | 1692096 | 2021-09-06 | Kingfisher | Oklahoma | 40073 | 2340 | 43 |
1693087 | 1693087 | 2021-09-06 | Iowa | Wisconsin | 55049 | 2340 | 14 |
1688847 | 1688847 | 2021-09-05 | Kingfisher | Oklahoma | 40073 | 2340 | 43 |
1683473 | 1683473 | 2021-09-04 | Washington | Alabama | 1129 | 2340 | 43 |
1685597 | 1685597 | 2021-09-04 | Kingfisher | Oklahoma | 40073 | 2340 | 43 |
1682346 | 1682346 | 2021-09-03 | Kingfisher | Oklahoma | 40073 | 2340 | 43 |
1677919 | 1677919 | 2021-09-02 | Bourbon | Kentucky | 21017 | 2340 | 21 |
1679096 | 1679096 | 2021-09-02 | Kingfisher | Oklahoma | 40073 | 2340 | 43 |
1675275 | 1675275 | 2021-09-01 | Wright | Missouri | 29229 | 2340 | 43 |
1675848 | 1675848 | 2021-09-01 | Kingfisher | Oklahoma | 40073 | 2340 | 43 |
1668736 | 1668736 | 2021-08-30 | Morgan | Missouri | 29141 | 2340 | 52 |
1653761 | 1653761 | 2021-08-25 | Shelby | Texas | 48419 | 2340 | 75 |
1634225 | 1634225 | 2021-08-19 | Montague | Texas | 48337 | 2340 | 74 |
1619552 | 1619552 | 2021-08-15 | Simpson | Kentucky | 21213 | 2340 | 44 |
1620031 | 1620031 | 2021-08-15 | Ray | Missouri | 29177 | 2340 | 37 |
1616304 | 1616304 | 2021-08-14 | Simpson | Kentucky | 21213 | 2340 | 44 |
1613055 | 1613055 | 2021-08-13 | Simpson | Kentucky | 21213 | 2340 | 44 |
1613064 | 1613064 | 2021-08-13 | Wayne | Kentucky | 21231 | 2340 | 51 |
1609100 | 1609100 | 2021-08-12 | Berrien | Georgia | 13019 | 2340 | 50 |
1609480 | 1609480 | 2021-08-12 | Sullivan | Indiana | 18153 | 2340 | 44 |
1609967 | 1609967 | 2021-08-12 | Gladwin | Michigan | 26051 | 2340 | 61 |
1606719 | 1606719 | 2021-08-11 | Gladwin | Michigan | 26051 | 2340 | 61 |
1586105 | 1586105 | 2021-08-05 | Lawrence | Arkansas | 5075 | 2340 | 43 |
1585476 | 1585476 | 2021-08-04 | Lee | Texas | 48287 | 2340 | 40 |
1585746 | 1585746 | 2021-08-04 | Russell | Virginia | 51167 | 2340 | 40 |
1581367 | 1581367 | 2021-08-03 | Ashe | North Carolina | 37009 | 2340 | 45 |
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);