ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 4978 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Georgia 9
- Michigan 9
- Oklahoma 9
- North Carolina 5
- Oregon 5
- Texas 5
- Mississippi 4
- Ohio 4
- Idaho 3
- Kentucky 3
- Virginia 3
- California 2
- Massachusetts 2
- Minnesota 2
- Missouri 2
- New York 2
- Pennsylvania 2
- Wisconsin 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Illinois 1
- Indiana 1
- Iowa 1
- Maryland 1
- New Mexico 1
- North Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2263010 | 2263010 | 2022-03-01 | Breckinridge | Kentucky | 21027 | 4978 | 71 |
2261396 | 2261396 | 2022-02-28 | Burleson | Texas | 48051 | 4978 | 65 |
2238250 | 2238250 | 2022-02-21 | Wasco | Oregon | 41065 | 4978 | 53 |
2234999 | 2234999 | 2022-02-20 | Wasco | Oregon | 41065 | 4978 | 53 |
2231748 | 2231748 | 2022-02-19 | Wasco | Oregon | 41065 | 4978 | 53 |
2228497 | 2228497 | 2022-02-18 | Wasco | Oregon | 41065 | 4978 | 53 |
2216593 | 2216593 | 2022-02-15 | Ashley | Arkansas | 5003 | 4978 | 57 |
2176908 | 2176908 | 2022-02-02 | Gillespie | Texas | 48171 | 4978 | 96 |
2100858 | 2100858 | 2022-01-10 | Sunflower | Mississippi | 28133 | 4978 | 110 |
2096711 | 2096711 | 2022-01-09 | Latah | Idaho | 16057 | 4978 | 41 |
2093459 | 2093459 | 2022-01-08 | Latah | Idaho | 16057 | 4978 | 41 |
2038847 | 2038847 | 2021-12-22 | Franklin | Massachusetts | 25011 | 4978 | 128 |
2038980 | 2038980 | 2021-12-22 | Le Sueur | Minnesota | 27079 | 4978 | 41 |
2029123 | 2029123 | 2021-12-19 | Clare | Michigan | 26035 | 4978 | 126 |
2025872 | 2025872 | 2021-12-18 | Clare | Michigan | 26035 | 4978 | 126 |
2022621 | 2022621 | 2021-12-17 | Clare | Michigan | 26035 | 4978 | 126 |
2013052 | 2013052 | 2021-12-14 | Itawamba | Mississippi | 28057 | 4978 | 107 |
1982835 | 1982835 | 2021-12-05 | Lumpkin | Georgia | 13187 | 4978 | 110 |
1979585 | 1979585 | 2021-12-04 | Lumpkin | Georgia | 13187 | 4978 | 110 |
1976335 | 1976335 | 2021-12-03 | Lumpkin | Georgia | 13187 | 4978 | 110 |
1869086 | 1869086 | 2021-10-31 | Madison | Georgia | 13195 | 4978 | 75 |
1865837 | 1865837 | 2021-10-30 | Madison | Georgia | 13195 | 4978 | 75 |
1862588 | 1862588 | 2021-10-29 | Madison | Georgia | 13195 | 4978 | 75 |
1864226 | 1864226 | 2021-10-29 | Ottawa | Ohio | 39123 | 4978 | 89 |
1854526 | 1854526 | 2021-10-26 | Custer | Oklahoma | 40039 | 4978 | 128 |
1851277 | 1851277 | 2021-10-25 | Custer | Oklahoma | 40039 | 4978 | 128 |
1847085 | 1847085 | 2021-10-24 | Worcester | Maryland | 24047 | 4978 | 118 |
1848027 | 1848027 | 2021-10-24 | Custer | Oklahoma | 40039 | 4978 | 128 |
1844777 | 1844777 | 2021-10-23 | Custer | Oklahoma | 40039 | 4978 | 128 |
1841527 | 1841527 | 2021-10-22 | Custer | Oklahoma | 40039 | 4978 | 128 |
1838278 | 1838278 | 2021-10-21 | Custer | Oklahoma | 40039 | 4978 | 128 |
1835029 | 1835029 | 2021-10-20 | Custer | Oklahoma | 40039 | 4978 | 128 |
1792746 | 1792746 | 2021-10-07 | Perry | Ohio | 39127 | 4978 | 56 |
1746225 | 1746225 | 2021-09-23 | Muhlenberg | Kentucky | 21177 | 4978 | 82 |
1727512 | 1727512 | 2021-09-17 | Montgomery | New York | 36057 | 4978 | 133 |
1715281 | 1715281 | 2021-09-13 | Bee | Texas | 48025 | 4978 | 94 |
1710671 | 1710671 | 2021-09-12 | Hillsdale | Michigan | 26059 | 4978 | 101 |
1712035 | 1712035 | 2021-09-12 | Bee | Texas | 48025 | 4978 | 94 |
1707424 | 1707424 | 2021-09-11 | Hillsdale | Michigan | 26059 | 4978 | 101 |
1704177 | 1704177 | 2021-09-10 | Hillsdale | Michigan | 26059 | 4978 | 101 |
1704775 | 1704775 | 2021-09-10 | Livingston | New York | 36051 | 4978 | 63 |
1688210 | 1688210 | 2021-09-05 | Laclede | Missouri | 29105 | 4978 | 119 |
1660288 | 1660288 | 2021-08-27 | Wharton | Texas | 48481 | 4978 | 128 |
1628811 | 1628811 | 2021-08-18 | Effingham | Illinois | 17049 | 4978 | 86 |
1626314 | 1626314 | 2021-08-17 | Mower | Minnesota | 27099 | 4978 | 34 |
1626400 | 1626400 | 2021-08-17 | Monroe | Mississippi | 28095 | 4978 | 139 |
1610647 | 1610647 | 2021-08-12 | Haywood | North Carolina | 37087 | 4978 | 100 |
1605692 | 1605692 | 2021-08-11 | Tuolumne | California | 6109 | 4978 | 74 |
1608442 | 1608442 | 2021-08-11 | James City | Virginia | 51095 | 4978 | 73 |
1417668 | 1417668 | 2021-06-14 | Ware | Georgia | 13299 | 4978 | 179 |
1414422 | 1414422 | 2021-06-13 | Ware | Georgia | 13299 | 4978 | 179 |
1402958 | 1402958 | 2021-06-09 | Williams | North Dakota | 38105 | 4978 | 40 |
1384596 | 1384596 | 2021-06-03 | Douglas | Wisconsin | 55031 | 4978 | 61 |
1368251 | 1368251 | 2021-05-29 | Washington | Virginia | 51191 | 4978 | 110 |
1357457 | 1357457 | 2021-05-26 | Vance | North Carolina | 37181 | 4978 | 87 |
1357528 | 1357528 | 2021-05-26 | Auglaize | Ohio | 39011 | 4978 | 87 |
1321257 | 1321257 | 2021-05-15 | Callaway | Missouri | 29027 | 4978 | 49 |
1311017 | 1311017 | 2021-05-12 | Boyd | Kentucky | 21019 | 4978 | 74 |
1243746 | 1243746 | 2021-04-21 | Carteret | North Carolina | 37031 | 4978 | 47 |
1200924 | 1200924 | 2021-04-08 | Shiawassee | Michigan | 26155 | 4978 | 86 |
1133373 | 1133373 | 2021-03-18 | McDowell | North Carolina | 37111 | 4978 | 62 |
1123488 | 1123488 | 2021-03-15 | Curry | New Mexico | 35009 | 4978 | 70 |
1119652 | 1119652 | 2021-03-14 | Berkshire | Massachusetts | 25003 | 4978 | 265 |
1114195 | 1114195 | 2021-03-12 | Armstrong | Pennsylvania | 42005 | 4978 | 116 |
1106328 | 1106328 | 2021-03-10 | Webster | Iowa | 19187 | 4978 | 88 |
1104402 | 1104402 | 2021-03-09 | Pontotoc | Oklahoma | 40123 | 4978 | 49 |
1051520 | 1051520 | 2021-02-21 | Clinton | Michigan | 26037 | 4978 | 69 |
1048273 | 1048273 | 2021-02-20 | Clinton | Michigan | 26037 | 4978 | 69 |
1042715 | 1042715 | 2021-02-18 | McClain | Oklahoma | 40087 | 4978 | 44 |
1039415 | 1039415 | 2021-02-17 | Union | Ohio | 39159 | 4978 | 49 |
1034299 | 1034299 | 2021-02-16 | Garfield | Colorado | 8045 | 4978 | 38 |
920398 | 920398 | 2021-01-11 | Sauk | Wisconsin | 55111 | 4978 | 37 |
869301 | 869301 | 2020-12-27 | Warrick | Indiana | 18173 | 4978 | 88 |
833404 | 833404 | 2020-12-16 | Madison | Idaho | 16065 | 4978 | 10 |
831809 | 831809 | 2020-12-15 | Jackson | Oregon | 41029 | 4978 | 52 |
776679 | 776679 | 2020-11-28 | Cumberland | Pennsylvania | 42041 | 4978 | 132 |
708252 | 708252 | 2020-11-07 | Wayne | North Carolina | 37191 | 4978 | 99 |
691483 | 691483 | 2020-11-02 | Jackson | Mississippi | 28059 | 4978 | 91 |
651595 | 651595 | 2020-10-21 | Lowndes | Georgia | 13185 | 4978 | 85 |
628177 | 628177 | 2020-10-13 | Richmond city | Virginia | 51760 | 4978 | 62 |
531190 | 531190 | 2020-09-14 | Baldwin | Alabama | 1003 | 4978 | 47 |
341250 | 341250 | 2020-07-17 | San Francisco | California | 6075 | 4978 | 52 |
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);