ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 6856 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Georgia 9
- Iowa 7
- Tennessee 5
- Indiana 4
- Mississippi 4
- Pennsylvania 4
- South Dakota 4
- Virginia 4
- Minnesota 3
- Texas 3
- Kentucky 2
- North Carolina 2
- Ohio 2
- Alabama 1
- Arkansas 1
- Maryland 1
- Nebraska 1
- New Mexico 1
- New York 1
- Oklahoma 1
- Oregon 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500290 | 2500290 | 2022-05-13 | Clay | Indiana | 18021 | 6856 | 88 |
2501336 | 2501336 | 2022-05-13 | Unknown | Nebraska | 6856 | 465 | |
2486331 | 2486331 | 2022-05-08 | Russell | Virginia | 51167 | 6856 | 113 |
2483073 | 2483073 | 2022-05-07 | Russell | Virginia | 51167 | 6856 | 113 |
2479815 | 2479815 | 2022-05-06 | Russell | Virginia | 51167 | 6856 | 113 |
2473698 | 2473698 | 2022-05-05 | Yell | Arkansas | 5149 | 6856 | 106 |
2453673 | 2453673 | 2022-04-28 | Caroline | Virginia | 51033 | 6856 | 84 |
2288738 | 2288738 | 2022-03-09 | Fayette | Indiana | 18041 | 6856 | 145 |
2222495 | 2222495 | 2022-02-16 | Kleberg | Texas | 48273 | 6856 | 137 |
2213974 | 2213974 | 2022-02-14 | Jennings | Indiana | 18079 | 6856 | 99 |
2188579 | 2188579 | 2022-02-06 | Mille Lacs | Minnesota | 27095 | 6856 | 103 |
2185326 | 2185326 | 2022-02-05 | Mille Lacs | Minnesota | 27095 | 6856 | 103 |
2182074 | 2182074 | 2022-02-04 | Mille Lacs | Minnesota | 27095 | 6856 | 103 |
2124605 | 2124605 | 2022-01-17 | Brookings | South Dakota | 46011 | 6856 | 41 |
2121353 | 2121353 | 2022-01-16 | Brookings | South Dakota | 46011 | 6856 | 41 |
2118101 | 2118101 | 2022-01-15 | Brookings | South Dakota | 46011 | 6856 | 41 |
2114850 | 2114850 | 2022-01-14 | Brookings | South Dakota | 46011 | 6856 | 41 |
2020186 | 2020186 | 2021-12-16 | Clinton | Ohio | 39027 | 6856 | 110 |
2012468 | 2012468 | 2021-12-14 | Marshall | Iowa | 19127 | 6856 | 94 |
2009217 | 2009217 | 2021-12-13 | Marshall | Iowa | 19127 | 6856 | 94 |
2005966 | 2005966 | 2021-12-12 | Marshall | Iowa | 19127 | 6856 | 94 |
2002715 | 2002715 | 2021-12-11 | Marshall | Iowa | 19127 | 6856 | 94 |
1999465 | 1999465 | 2021-12-10 | Marshall | Iowa | 19127 | 6856 | 94 |
2000934 | 2000934 | 2021-12-10 | Wayne | Pennsylvania | 42127 | 6856 | 129 |
1996214 | 1996214 | 2021-12-09 | Marshall | Iowa | 19127 | 6856 | 94 |
1992963 | 1992963 | 2021-12-08 | Marshall | Iowa | 19127 | 6856 | 94 |
1938923 | 1938923 | 2021-11-21 | Crawford | Ohio | 39033 | 6856 | 147 |
1923255 | 1923255 | 2021-11-16 | Cherokee | Texas | 48073 | 6856 | 227 |
1892809 | 1892809 | 2021-11-07 | Monroe | Mississippi | 28095 | 6856 | 179 |
1889559 | 1889559 | 2021-11-06 | Monroe | Mississippi | 28095 | 6856 | 179 |
1886309 | 1886309 | 2021-11-05 | Monroe | Mississippi | 28095 | 6856 | 179 |
1874119 | 1874119 | 2021-11-01 | Bedford | Pennsylvania | 42009 | 6856 | 171 |
1870870 | 1870870 | 2021-10-31 | Bedford | Pennsylvania | 42009 | 6856 | 171 |
1814473 | 1814473 | 2021-10-14 | Shelby | Kentucky | 21211 | 6856 | 104 |
1806218 | 1806218 | 2021-10-11 | Rhea | Tennessee | 47143 | 6856 | 90 |
1802907 | 1802907 | 2021-10-10 | Cheatham | Tennessee | 47021 | 6856 | 66 |
1799658 | 1799658 | 2021-10-09 | Cheatham | Tennessee | 47021 | 6856 | 66 |
1796409 | 1796409 | 2021-10-08 | Cheatham | Tennessee | 47021 | 6856 | 66 |
1723395 | 1723395 | 2021-09-16 | Barren | Kentucky | 21009 | 6856 | 116 |
1722372 | 1722372 | 2021-09-15 | Fremont | Wyoming | 56013 | 6856 | 102 |
1691778 | 1691778 | 2021-09-06 | Jefferson | New York | 36045 | 6856 | 70 |
1655397 | 1655397 | 2021-08-26 | St. Mary's | Maryland | 24037 | 6856 | 137 |
1641709 | 1641709 | 2021-08-22 | Tift | Georgia | 13277 | 6856 | 137 |
1638459 | 1638459 | 2021-08-21 | Tift | Georgia | 13277 | 6856 | 137 |
1635209 | 1635209 | 2021-08-20 | Tift | Georgia | 13277 | 6856 | 137 |
1456484 | 1456484 | 2021-06-26 | Bulloch | Georgia | 13031 | 6856 | 121 |
1372099 | 1372099 | 2021-05-31 | Bulloch | Georgia | 13031 | 6856 | 120 |
1368854 | 1368854 | 2021-05-30 | Bulloch | Georgia | 13031 | 6856 | 120 |
1365608 | 1365608 | 2021-05-29 | Bulloch | Georgia | 13031 | 6856 | 120 |
1355468 | 1355468 | 2021-05-26 | Blount | Alabama | 1009 | 6856 | 139 |
1334555 | 1334555 | 2021-05-19 | Eddy | New Mexico | 35015 | 6856 | 129 |
1328788 | 1328788 | 2021-05-17 | Dickson | Tennessee | 47043 | 6856 | 113 |
1198999 | 1198999 | 2021-04-07 | Bowie | Texas | 48037 | 6856 | 207 |
1126900 | 1126900 | 2021-03-16 | Rutherford | North Carolina | 37161 | 6856 | 201 |
1090658 | 1090658 | 2021-03-05 | Lauderdale | Mississippi | 28075 | 6856 | 227 |
1044297 | 1044297 | 2021-02-19 | Troup | Georgia | 13285 | 6856 | 189 |
1033935 | 1033935 | 2021-02-15 | Wood | West Virginia | 54107 | 6856 | 125 |
948656 | 948656 | 2021-01-20 | Umatilla | Oregon | 41059 | 6856 | 71 |
891965 | 891965 | 2021-01-03 | Howard | Indiana | 18067 | 6856 | 126 |
857847 | 857847 | 2020-12-23 | Schuylkill | Pennsylvania | 42107 | 6856 | 229 |
747167 | 747167 | 2020-11-19 | Robeson | North Carolina | 37155 | 6856 | 103 |
615841 | 615841 | 2020-10-10 | Cherokee | Georgia | 13057 | 6856 | 96 |
362428 | 362428 | 2020-07-23 | Tulsa | Oklahoma | 40143 | 6856 | 89 |
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);