ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 7742 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Tennessee 15
- South Carolina 10
- Wisconsin 6
- Georgia 4
- Missouri 4
- New Mexico 4
- Virginia 4
- Michigan 3
- Texas 3
- Florida 2
- New York 2
- North Carolina 2
- Arkansas 1
- Kentucky 1
- Maryland 1
- Minnesota 1
- Mississippi 1
- Montana 1
- New Jersey 1
- Oklahoma 1
- Oregon 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492268 | 2492268 | 2022-05-10 | Union | South Carolina | 45087 | 7742 | 150 |
2489010 | 2489010 | 2022-05-09 | Union | South Carolina | 45087 | 7742 | 150 |
2485753 | 2485753 | 2022-05-08 | Union | South Carolina | 45087 | 7742 | 150 |
2482495 | 2482495 | 2022-05-07 | Union | South Carolina | 45087 | 7742 | 150 |
2479237 | 2479237 | 2022-05-06 | Union | South Carolina | 45087 | 7742 | 150 |
2475979 | 2475979 | 2022-05-05 | Union | South Carolina | 45087 | 7742 | 150 |
2472722 | 2472722 | 2022-05-04 | Union | South Carolina | 45087 | 7742 | 150 |
2469466 | 2469466 | 2022-05-03 | Union | South Carolina | 45087 | 7742 | 150 |
2424000 | 2424000 | 2022-04-19 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2420744 | 2420744 | 2022-04-18 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2417488 | 2417488 | 2022-04-17 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2414232 | 2414232 | 2022-04-16 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2410976 | 2410976 | 2022-04-15 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2407720 | 2407720 | 2022-04-14 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2404464 | 2404464 | 2022-04-13 | Lauderdale | Tennessee | 47097 | 7742 | 104 |
2315304 | 2315304 | 2022-03-17 | Houghton | Michigan | 26061 | 7742 | 89 |
2311319 | 2311319 | 2022-03-16 | Wayne | Georgia | 13305 | 7742 | 203 |
2312051 | 2312051 | 2022-03-16 | Houghton | Michigan | 26061 | 7742 | 89 |
2302576 | 2302576 | 2022-03-13 | Lawrence | Missouri | 29109 | 7742 | 157 |
2299324 | 2299324 | 2022-03-12 | Lawrence | Missouri | 29109 | 7742 | 157 |
2296072 | 2296072 | 2022-03-11 | Lawrence | Missouri | 29109 | 7742 | 157 |
2224362 | 2224362 | 2022-02-17 | Nicollet | Minnesota | 27103 | 7742 | 66 |
2151188 | 2151188 | 2022-01-25 | Petersburg city | Virginia | 51730 | 7742 | 112 |
2127975 | 2127975 | 2022-01-18 | Marshall | Tennessee | 47117 | 7742 | 104 |
2124723 | 2124723 | 2022-01-17 | Marshall | Tennessee | 47117 | 7742 | 104 |
2121471 | 2121471 | 2022-01-16 | Marshall | Tennessee | 47117 | 7742 | 104 |
2118219 | 2118219 | 2022-01-15 | Marshall | Tennessee | 47117 | 7742 | 104 |
2114968 | 2114968 | 2022-01-14 | Marshall | Tennessee | 47117 | 7742 | 104 |
2111716 | 2111716 | 2022-01-13 | Marshall | Tennessee | 47117 | 7742 | 104 |
2108464 | 2108464 | 2022-01-12 | Marshall | Tennessee | 47117 | 7742 | 104 |
1993697 | 1993697 | 2021-12-08 | Scott | Missouri | 29201 | 7742 | 132 |
1897649 | 1897649 | 2021-11-08 | Washington | Virginia | 51191 | 7742 | 148 |
1824946 | 1824946 | 2021-10-17 | Otero | New Mexico | 35035 | 7742 | 97 |
1821697 | 1821697 | 2021-10-16 | Otero | New Mexico | 35035 | 7742 | 97 |
1818448 | 1818448 | 2021-10-15 | Otero | New Mexico | 35035 | 7742 | 97 |
1781299 | 1781299 | 2021-10-04 | Coffee | Georgia | 13069 | 7742 | 206 |
1749596 | 1749596 | 2021-09-24 | Cecil | Maryland | 24015 | 7742 | 164 |
1679846 | 1679846 | 2021-09-02 | Bedford | Virginia | 51019 | 7742 | 114 |
1650420 | 1650420 | 2021-08-24 | Hunt | Texas | 48231 | 7742 | 191 |
1628141 | 1628141 | 2021-08-17 | Portage | Wisconsin | 55097 | 7742 | 77 |
1623537 | 1623537 | 2021-08-16 | Valencia | New Mexico | 35061 | 7742 | 124 |
1553389 | 1553389 | 2021-07-25 | Chippewa | Wisconsin | 55017 | 7742 | 97 |
1550142 | 1550142 | 2021-07-24 | Chippewa | Wisconsin | 55017 | 7742 | 97 |
1546895 | 1546895 | 2021-07-23 | Chippewa | Wisconsin | 55017 | 7742 | 97 |
1543711 | 1543711 | 2021-07-22 | Wood | Wisconsin | 55141 | 7742 | 110 |
1518847 | 1518847 | 2021-07-15 | Oldham | Kentucky | 21185 | 7742 | 84 |
1508545 | 1508545 | 2021-07-12 | Troup | Georgia | 13285 | 7742 | 239 |
1478190 | 1478190 | 2021-07-02 | Bowie | Texas | 48037 | 7742 | 225 |
1474944 | 1474944 | 2021-07-01 | Bowie | Texas | 48037 | 7742 | 225 |
1353648 | 1353648 | 2021-05-25 | Forrest | Mississippi | 28035 | 7742 | 153 |
1149495 | 1149495 | 2021-03-23 | Chautauqua | New York | 36013 | 7742 | 130 |
1102646 | 1102646 | 2021-03-09 | Gordon | Georgia | 13129 | 7742 | 104 |
1094674 | 1094674 | 2021-03-06 | Wagoner | Oklahoma | 40145 | 7742 | 83 |
1062426 | 1062426 | 2021-02-24 | Darlington | South Carolina | 45031 | 7742 | 163 |
1019731 | 1019731 | 2021-02-11 | Craven | North Carolina | 37049 | 7742 | 111 |
1010308 | 1010308 | 2021-02-08 | Jackson | Oregon | 41029 | 7742 | 105 |
959527 | 959527 | 2021-01-24 | Jefferson | Arkansas | 5069 | 7742 | 144 |
848400 | 848400 | 2020-12-20 | Sevier | Tennessee | 47155 | 7742 | 58 |
806818 | 806818 | 2020-12-07 | Walworth | Wisconsin | 55127 | 7742 | 59 |
792251 | 792251 | 2020-12-03 | Gallatin | Montana | 30031 | 7742 | 24 |
627086 | 627086 | 2020-10-13 | Forsyth | North Carolina | 37067 | 7742 | 105 |
598413 | 598413 | 2020-10-04 | Lexington | South Carolina | 45063 | 7742 | 171 |
544511 | 544511 | 2020-09-18 | St. Lucie | Florida | 12111 | 7742 | 259 |
515332 | 515332 | 2020-09-09 | Brevard | Florida | 12009 | 7742 | 237 |
326888 | 326888 | 2020-07-12 | Erie | New York | 36029 | 7742 | 602 |
321672 | 321672 | 2020-07-10 | Prince William | Virginia | 51153 | 7742 | 156 |
302714 | 302714 | 2020-07-04 | Yakima | Washington | 53077 | 7742 | 160 |
297810 | 297810 | 2020-07-03 | Macomb | Michigan | 26099 | 7742 | 924 |
143865 | 143865 | 2020-05-14 | Ocean | New Jersey | 34029 | 7742 | 595 |
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);