ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 7854 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423382 | 2423382 | 2022-04-19 | Macon | North Carolina | 37113 | 7854 | 117 |
2420125 | 2420125 | 2022-04-18 | Macon | North Carolina | 37113 | 7854 | 117 |
2416870 | 2416870 | 2022-04-17 | Macon | North Carolina | 37113 | 7854 | 117 |
2413614 | 2413614 | 2022-04-16 | Macon | North Carolina | 37113 | 7854 | 117 |
2410358 | 2410358 | 2022-04-15 | Macon | North Carolina | 37113 | 7854 | 117 |
2407102 | 2407102 | 2022-04-14 | Macon | North Carolina | 37113 | 7854 | 117 |
2403846 | 2403846 | 2022-04-13 | Macon | North Carolina | 37113 | 7854 | 117 |
2400489 | 2400489 | 2022-04-12 | Delaware | New York | 36025 | 7854 | 69 |
2370018 | 2370018 | 2022-04-03 | Saline | Illinois | 17165 | 7854 | 109 |
2366765 | 2366765 | 2022-04-02 | Saline | Illinois | 17165 | 7854 | 109 |
2363512 | 2363512 | 2022-04-01 | Saline | Illinois | 17165 | 7854 | 109 |
2360350 | 2360350 | 2022-03-31 | Scott | Indiana | 18143 | 7854 | 106 |
2357096 | 2357096 | 2022-03-30 | Scott | Indiana | 18143 | 7854 | 106 |
2314805 | 2314805 | 2022-03-17 | Scott | Indiana | 18143 | 7854 | 106 |
2311552 | 2311552 | 2022-03-16 | Scott | Indiana | 18143 | 7854 | 106 |
2305048 | 2305048 | 2022-03-14 | Scott | Indiana | 18143 | 7854 | 105 |
2285885 | 2285885 | 2022-03-08 | Allen | Louisiana | 22003 | 7854 | 130 |
2219575 | 2219575 | 2022-02-15 | Stevens | Washington | 53065 | 7854 | 128 |
2216325 | 2216325 | 2022-02-14 | Stevens | Washington | 53065 | 7854 | 128 |
2212642 | 2212642 | 2022-02-13 | Cherokee | Texas | 48073 | 7854 | 241 |
2186590 | 2186590 | 2022-02-05 | Bee | Texas | 48025 | 7854 | 142 |
2169972 | 2169972 | 2022-01-31 | Clarion | Pennsylvania | 42031 | 7854 | 188 |
2157389 | 2157389 | 2022-01-27 | Grimes | Texas | 48185 | 7854 | 112 |
2150268 | 2150268 | 2022-01-25 | Jackson | Ohio | 39079 | 7854 | 123 |
2148113 | 2148113 | 2022-01-24 | Oneida | Wisconsin | 55085 | 7854 | 120 |
2132638 | 2132638 | 2022-01-20 | Jefferson | Indiana | 18077 | 7854 | 132 |
2117763 | 2117763 | 2022-01-15 | Preble | Ohio | 39135 | 7854 | 160 |
2059982 | 2059982 | 2021-12-28 | Wilson | Texas | 48493 | 7854 | 143 |
2053148 | 2053148 | 2021-12-26 | Campbell | Tennessee | 47013 | 7854 | 121 |
2049898 | 2049898 | 2021-12-25 | Campbell | Tennessee | 47013 | 7854 | 121 |
2046648 | 2046648 | 2021-12-24 | Campbell | Tennessee | 47013 | 7854 | 121 |
2043398 | 2043398 | 2021-12-23 | Campbell | Tennessee | 47013 | 7854 | 121 |
2031033 | 2031033 | 2021-12-19 | Douglas | Wisconsin | 55031 | 7854 | 70 |
2027782 | 2027782 | 2021-12-18 | Douglas | Wisconsin | 55031 | 7854 | 70 |
2024531 | 2024531 | 2021-12-17 | Douglas | Wisconsin | 55031 | 7854 | 70 |
1992528 | 1992528 | 2021-12-08 | Colquitt | Georgia | 13071 | 7854 | 203 |
1990290 | 1990290 | 2021-12-07 | Hancock | Mississippi | 28045 | 7854 | 132 |
1986960 | 1986960 | 2021-12-06 | Itasca | Minnesota | 27061 | 7854 | 99 |
1967967 | 1967967 | 2021-11-30 | Fulton | New York | 36035 | 7854 | 115 |
1912416 | 1912416 | 2021-11-13 | Newton | Missouri | 29145 | 7854 | 129 |
1893482 | 1893482 | 2021-11-07 | Seneca | Ohio | 39147 | 7854 | 150 |
1834797 | 1834797 | 2021-10-20 | Edgecombe | North Carolina | 37065 | 7854 | 124 |
1828915 | 1828915 | 2021-10-18 | Franklin | Tennessee | 47051 | 7854 | 100 |
1718656 | 1718656 | 2021-09-14 | Lamar | Texas | 48277 | 7854 | 176 |
1700181 | 1700181 | 2021-09-09 | Tift | Georgia | 13277 | 7854 | 142 |
1653165 | 1653165 | 2021-08-25 | Douglas | Oregon | 41019 | 7854 | 121 |
1605452 | 1605452 | 2021-08-11 | Autauga | Alabama | 1001 | 7854 | 114 |
1597928 | 1597928 | 2021-08-08 | Unknown | Oklahoma | 7854 | 0 | |
1594679 | 1594679 | 2021-08-07 | Unknown | Oklahoma | 7854 | 0 | |
1591430 | 1591430 | 2021-08-06 | Unknown | Oklahoma | 7854 | 0 | |
1408183 | 1408183 | 2021-06-11 | Warrick | Indiana | 18173 | 7854 | 159 |
1347433 | 1347433 | 2021-05-23 | Hall | Nebraska | 31079 | 7854 | 118 |
1344185 | 1344185 | 2021-05-22 | Hall | Nebraska | 31079 | 7854 | 118 |
1340937 | 1340937 | 2021-05-21 | Hall | Nebraska | 31079 | 7854 | 118 |
1334721 | 1334721 | 2021-05-19 | Stanly | North Carolina | 37167 | 7854 | 134 |
1326629 | 1326629 | 2021-05-17 | Walton | Florida | 12131 | 7854 | 87 |
1311308 | 1311308 | 2021-05-12 | Montcalm | Michigan | 26117 | 7854 | 112 |
1237612 | 1237612 | 2021-04-19 | Clearfield | Pennsylvania | 42033 | 7854 | 133 |
1196540 | 1196540 | 2021-04-07 | White | Arkansas | 5145 | 7854 | 118 |
1170544 | 1170544 | 2021-03-30 | Pope | Arkansas | 5115 | 7854 | 106 |
1165733 | 1165733 | 2021-03-28 | Chautauqua | New York | 36013 | 7854 | 130 |
1126125 | 1126125 | 2021-03-16 | Carroll | Maryland | 24013 | 7854 | 216 |
1009713 | 1009713 | 2021-02-08 | Missoula | Montana | 30063 | 7854 | 82 |
994695 | 994695 | 2021-02-03 | Walker | Texas | 48471 | 7854 | 104 |
959441 | 959441 | 2021-01-24 | St. Clair | Alabama | 1115 | 7854 | 130 |
960914 | 960914 | 2021-01-24 | Franklin | Missouri | 29071 | 7854 | 128 |
786238 | 786238 | 2020-12-01 | Lorain | Ohio | 39093 | 7854 | 106 |
693516 | 693516 | 2020-11-03 | Solano | California | 6095 | 7854 | 76 |
667656 | 667656 | 2020-10-26 | Sussex | Delaware | 10005 | 7854 | 226 |
639730 | 639730 | 2020-10-17 | St. Louis city | Missouri | 29510 | 7854 | 218 |
577655 | 577655 | 2020-09-28 | Calcasieu | Louisiana | 22019 | 7854 | 212 |
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);