ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 5041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 16
- Tennessee 16
- Kentucky 9
- California 6
- Alabama 5
- Indiana 5
- Nevada 5
- North Carolina 5
- Ohio 5
- Illinois 4
- Missouri 4
- New Mexico 4
- Arkansas 3
- Mississippi 3
- Pennsylvania 3
- Texas 3
- Virginia 3
- Florida 2
- Iowa 2
- Kansas 2
- Minnesota 2
- Nebraska 2
- New York 2
- Puerto Rico 2
- Utah 2
- Wisconsin 2
- Colorado 1
- Hawaii 1
- Louisiana 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470931 | 2470931 | 2022-05-04 | Pike | Illinois | 17149 | 5041 | 70 |
2447318 | 2447318 | 2022-04-26 | Brooke | West Virginia | 54009 | 5041 | 104 |
2350303 | 2350303 | 2022-03-28 | McDuffie | Georgia | 13189 | 5041 | 93 |
2342426 | 2342426 | 2022-03-25 | Hatillo | Puerto Rico | 72065 | 5041 | |
2328652 | 2328652 | 2022-03-21 | Vernon | Missouri | 29217 | 5041 | 105 |
2301027 | 2301027 | 2022-03-13 | Butler | Alabama | 1013 | 5041 | 124 |
2302984 | 2302984 | 2022-03-13 | Madison | North Carolina | 37115 | 5041 | 79 |
2297775 | 2297775 | 2022-03-12 | Butler | Alabama | 1013 | 5041 | 124 |
2299732 | 2299732 | 2022-03-12 | Madison | North Carolina | 37115 | 5041 | 79 |
2294523 | 2294523 | 2022-03-11 | Butler | Alabama | 1013 | 5041 | 124 |
2296480 | 2296480 | 2022-03-11 | Madison | North Carolina | 37115 | 5041 | 79 |
2291271 | 2291271 | 2022-03-10 | Butler | Alabama | 1013 | 5041 | 124 |
2293598 | 2293598 | 2022-03-10 | Wyoming | Pennsylvania | 42131 | 5041 | 103 |
2288019 | 2288019 | 2022-03-09 | Butler | Alabama | 1013 | 5041 | 124 |
2256015 | 2256015 | 2022-02-27 | Tattnall | Georgia | 13267 | 5041 | 129 |
2252764 | 2252764 | 2022-02-26 | Tattnall | Georgia | 13267 | 5041 | 129 |
2249513 | 2249513 | 2022-02-25 | Tattnall | Georgia | 13267 | 5041 | 129 |
2221833 | 2221833 | 2022-02-16 | Holmes | Ohio | 39075 | 5041 | 172 |
2197967 | 2197967 | 2022-02-09 | Adair | Kentucky | 21001 | 5041 | 95 |
2196267 | 2196267 | 2022-02-08 | Fentress | Tennessee | 47049 | 5041 | 109 |
2193013 | 2193013 | 2022-02-07 | Fentress | Tennessee | 47049 | 5041 | 109 |
2189759 | 2189759 | 2022-02-06 | Fentress | Tennessee | 47049 | 5041 | 109 |
2186506 | 2186506 | 2022-02-05 | Fentress | Tennessee | 47049 | 5041 | 109 |
2183254 | 2183254 | 2022-02-04 | Fentress | Tennessee | 47049 | 5041 | 109 |
2180002 | 2180002 | 2022-02-03 | Fentress | Tennessee | 47049 | 5041 | 109 |
2176751 | 2176751 | 2022-02-02 | Fentress | Tennessee | 47049 | 5041 | 109 |
2168381 | 2168381 | 2022-01-31 | Union | Illinois | 17181 | 5041 | 64 |
2150733 | 2150733 | 2022-01-25 | Haywood | Tennessee | 47075 | 5041 | 82 |
2147481 | 2147481 | 2022-01-24 | Haywood | Tennessee | 47075 | 5041 | 82 |
2144227 | 2144227 | 2022-01-23 | Haywood | Tennessee | 47075 | 5041 | 82 |
2140972 | 2140972 | 2022-01-22 | Haywood | Tennessee | 47075 | 5041 | 82 |
2137716 | 2137716 | 2022-01-21 | Haywood | Tennessee | 47075 | 5041 | 82 |
2134462 | 2134462 | 2022-01-20 | Haywood | Tennessee | 47075 | 5041 | 82 |
2128818 | 2128818 | 2022-01-19 | Sevier | Arkansas | 5133 | 5041 | 63 |
2130016 | 2130016 | 2022-01-19 | Meeker | Minnesota | 27093 | 5041 | 70 |
2131210 | 2131210 | 2022-01-19 | Haywood | Tennessee | 47075 | 5041 | 82 |
2126391 | 2126391 | 2022-01-18 | Allen | Kentucky | 21003 | 5041 | 85 |
2108123 | 2108123 | 2022-01-12 | Jefferson | Oregon | 41031 | 5041 | 70 |
2108826 | 2108826 | 2022-01-12 | Carroll | Virginia | 51035 | 5041 | 113 |
2094972 | 2094972 | 2022-01-08 | Hocking | Ohio | 39073 | 5041 | 100 |
2058478 | 2058478 | 2021-12-28 | Le Sueur | Minnesota | 27079 | 5041 | 41 |
2050845 | 2050845 | 2021-12-26 | Siskiyou | California | 6093 | 5041 | 77 |
2052430 | 2052430 | 2021-12-26 | Cibola | New Mexico | 35006 | 5041 | 157 |
2047595 | 2047595 | 2021-12-25 | Siskiyou | California | 6093 | 5041 | 77 |
2049180 | 2049180 | 2021-12-25 | Cibola | New Mexico | 35006 | 5041 | 157 |
2044345 | 2044345 | 2021-12-24 | Siskiyou | California | 6093 | 5041 | 77 |
2045930 | 2045930 | 2021-12-24 | Cibola | New Mexico | 35006 | 5041 | 157 |
2041096 | 2041096 | 2021-12-23 | Siskiyou | California | 6093 | 5041 | 77 |
2042680 | 2042680 | 2021-12-23 | Cibola | New Mexico | 35006 | 5041 | 157 |
2037846 | 2037846 | 2021-12-22 | Siskiyou | California | 6093 | 5041 | 77 |
2015342 | 2015342 | 2021-12-15 | Lumpkin | Georgia | 13187 | 5041 | 110 |
2013300 | 2013300 | 2021-12-14 | Dakota | Nebraska | 31043 | 5041 | 82 |
2005900 | 2005900 | 2021-12-12 | Wells | Indiana | 18179 | 5041 | 109 |
2002649 | 2002649 | 2021-12-11 | Wells | Indiana | 18179 | 5041 | 109 |
2004145 | 2004145 | 2021-12-11 | Elk | Pennsylvania | 42047 | 5041 | 68 |
1999399 | 1999399 | 2021-12-10 | Wells | Indiana | 18179 | 5041 | 109 |
1973530 | 1973530 | 2021-12-02 | Geary | Kansas | 20061 | 5041 | 61 |
1970280 | 1970280 | 2021-12-01 | Geary | Kansas | 20061 | 5041 | 61 |
1960085 | 1960085 | 2021-11-28 | Madison | Georgia | 13195 | 5041 | 80 |
1961368 | 1961368 | 2021-11-28 | Douglas | Nevada | 32005 | 5041 | 68 |
1956834 | 1956834 | 2021-11-27 | Madison | Georgia | 13195 | 5041 | 80 |
1958117 | 1958117 | 2021-11-27 | Douglas | Nevada | 32005 | 5041 | 68 |
1953583 | 1953583 | 2021-11-26 | Madison | Georgia | 13195 | 5041 | 80 |
1954866 | 1954866 | 2021-11-26 | Douglas | Nevada | 32005 | 5041 | 68 |
1950332 | 1950332 | 2021-11-25 | Madison | Georgia | 13195 | 5041 | 80 |
1951615 | 1951615 | 2021-11-25 | Douglas | Nevada | 32005 | 5041 | 68 |
1947081 | 1947081 | 2021-11-24 | Madison | Georgia | 13195 | 5041 | 80 |
1948364 | 1948364 | 2021-11-24 | Douglas | Nevada | 32005 | 5041 | 68 |
1925042 | 1925042 | 2021-11-17 | Somerset | Maine | 23025 | 5041 | 56 |
1881399 | 1881399 | 2021-11-03 | Warren | Virginia | 51187 | 5041 | 86 |
1876176 | 1876176 | 2021-11-02 | Marshall | Kentucky | 21157 | 5041 | 78 |
1873459 | 1873459 | 2021-11-01 | Warren | Missouri | 29219 | 5041 | 47 |
1857040 | 1857040 | 2021-10-27 | George | Mississippi | 28039 | 5041 | 79 |
1829115 | 1829115 | 2021-10-18 | Kendall | Texas | 48259 | 5041 | 95 |
1801387 | 1801387 | 2021-10-10 | Calloway | Kentucky | 21035 | 5041 | 60 |
1798138 | 1798138 | 2021-10-09 | Calloway | Kentucky | 21035 | 5041 | 60 |
1794889 | 1794889 | 2021-10-08 | Calloway | Kentucky | 21035 | 5041 | 60 |
1781924 | 1781924 | 2021-10-04 | Harlan | Kentucky | 21095 | 5041 | 119 |
1779484 | 1779484 | 2021-10-03 | Cortland | New York | 36023 | 5041 | 73 |
1769660 | 1769660 | 2021-09-30 | Cheshire | New Hampshire | 33005 | 5041 | 45 |
1763955 | 1763955 | 2021-09-28 | Lauderdale | Tennessee | 47097 | 5041 | 59 |
1717444 | 1717444 | 2021-09-14 | Laclede | Missouri | 29105 | 5041 | 121 |
1717806 | 1717806 | 2021-09-14 | Bladen | North Carolina | 37017 | 5041 | 88 |
1711476 | 1711476 | 2021-09-12 | Crawford | Ohio | 39033 | 5041 | 112 |
1587378 | 1587378 | 2021-08-05 | Bolivar | Mississippi | 28011 | 5041 | 134 |
1585109 | 1585109 | 2021-08-04 | Toa Baja | Puerto Rico | 72137 | 5041 | |
1585910 | 1585910 | 2021-08-04 | Pierce | Wisconsin | 55093 | 5041 | 44 |
1537795 | 1537795 | 2021-07-21 | Maui | Hawaii | 15009 | 5041 | 57 |
1508266 | 1508266 | 2021-07-12 | Broomfield | Colorado | 8014 | 5041 | 76 |
1501326 | 1501326 | 2021-07-09 | Washington | Virginia | 51191 | 5041 | 111 |
1484107 | 1484107 | 2021-07-04 | Auglaize | Ohio | 39011 | 5041 | 87 |
1480861 | 1480861 | 2021-07-03 | Auglaize | Ohio | 39011 | 5041 | 87 |
1459818 | 1459818 | 2021-06-27 | Murray | Georgia | 13213 | 5041 | 92 |
1456573 | 1456573 | 2021-06-26 | Murray | Georgia | 13213 | 5041 | 92 |
1453328 | 1453328 | 2021-06-25 | Murray | Georgia | 13213 | 5041 | 92 |
1443592 | 1443592 | 2021-06-22 | Murray | Georgia | 13213 | 5041 | 93 |
1420869 | 1420869 | 2021-06-15 | Murray | Georgia | 13213 | 5041 | 91 |
1405657 | 1405657 | 2021-06-10 | Callaway | Missouri | 29027 | 5041 | 51 |
1381924 | 1381924 | 2021-06-03 | Murray | Georgia | 13213 | 5041 | 90 |
1349209 | 1349209 | 2021-05-24 | Tehama | California | 6103 | 5041 | 63 |
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);