ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where cases = 6767 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2406542 | 2406542 | 2022-04-14 | Todd | Minnesota | 27153 | 6767 | 57 |
2378402 | 2378402 | 2022-04-05 | Grainger | Tennessee | 47057 | 6767 | 107 |
2375148 | 2375148 | 2022-04-04 | Grainger | Tennessee | 47057 | 6767 | 107 |
2371896 | 2371896 | 2022-04-03 | Grainger | Tennessee | 47057 | 6767 | 107 |
2368643 | 2368643 | 2022-04-02 | Grainger | Tennessee | 47057 | 6767 | 107 |
2365390 | 2365390 | 2022-04-01 | Grainger | Tennessee | 47057 | 6767 | 107 |
2362137 | 2362137 | 2022-03-31 | Grainger | Tennessee | 47057 | 6767 | 107 |
2358883 | 2358883 | 2022-03-30 | Grainger | Tennessee | 47057 | 6767 | 107 |
2221509 | 2221509 | 2022-02-16 | Nye | Nevada | 32023 | 6767 | 223 |
2198345 | 2198345 | 2022-02-09 | Nobles | Minnesota | 27105 | 6767 | 57 |
2177366 | 2177366 | 2022-02-02 | Door | Wisconsin | 55029 | 6767 | 54 |
2125411 | 2125411 | 2022-01-18 | Dallas | Alabama | 1047 | 6767 | 216 |
2103129 | 2103129 | 2022-01-11 | Pickens | Georgia | 13227 | 6767 | 131 |
2101102 | 2101102 | 2022-01-10 | Lincoln | Nebraska | 31111 | 6767 | 87 |
2075594 | 2075594 | 2022-01-02 | Benton | Oregon | 41003 | 6767 | 43 |
2072343 | 2072343 | 2022-01-01 | Benton | Oregon | 41003 | 6767 | 43 |
2069092 | 2069092 | 2021-12-31 | Benton | Oregon | 41003 | 6767 | 43 |
2065841 | 2065841 | 2021-12-30 | Benton | Oregon | 41003 | 6767 | 43 |
2033542 | 2033542 | 2021-12-20 | Chester | South Carolina | 45023 | 6767 | 123 |
2028633 | 2028633 | 2021-12-19 | Putnam | Indiana | 18133 | 6767 | 91 |
2025382 | 2025382 | 2021-12-18 | Putnam | Indiana | 18133 | 6767 | 91 |
2022131 | 2022131 | 2021-12-17 | Putnam | Indiana | 18133 | 6767 | 91 |
2018265 | 2018265 | 2021-12-16 | Miller | Arkansas | 5091 | 6767 | 151 |
1993568 | 1993568 | 2021-12-08 | Neshoba | Mississippi | 28099 | 6767 | 210 |
1989712 | 1989712 | 2021-12-07 | Marshall | Iowa | 19127 | 6767 | 94 |
1986462 | 1986462 | 2021-12-06 | Marshall | Iowa | 19127 | 6767 | 94 |
1983212 | 1983212 | 2021-12-05 | Marshall | Iowa | 19127 | 6767 | 94 |
1979962 | 1979962 | 2021-12-04 | Marshall | Iowa | 19127 | 6767 | 94 |
1976712 | 1976712 | 2021-12-03 | Marshall | Iowa | 19127 | 6767 | 94 |
1973463 | 1973463 | 2021-12-02 | Marshall | Iowa | 19127 | 6767 | 94 |
1970213 | 1970213 | 2021-12-01 | Marshall | Iowa | 19127 | 6767 | 94 |
1940373 | 1940373 | 2021-11-22 | La Plata | Colorado | 8067 | 6767 | 58 |
1916675 | 1916675 | 2021-11-14 | Lincoln | Tennessee | 47103 | 6767 | 88 |
1913425 | 1913425 | 2021-11-13 | Lincoln | Tennessee | 47103 | 6767 | 88 |
1910175 | 1910175 | 2021-11-12 | Lincoln | Tennessee | 47103 | 6767 | 88 |
1876589 | 1876589 | 2021-11-02 | Warren | Mississippi | 28149 | 6767 | 176 |
1791729 | 1791729 | 2021-10-07 | Shelby | Kentucky | 21211 | 6767 | 98 |
1788032 | 1788032 | 2021-10-06 | Marion | Illinois | 17121 | 6767 | 146 |
1786724 | 1786724 | 2021-10-05 | Rhea | Tennessee | 47143 | 6767 | 89 |
1781615 | 1781615 | 2021-10-04 | Jackson | Indiana | 18071 | 6767 | 88 |
1762926 | 1762926 | 2021-09-28 | Johnson | Missouri | 29101 | 6767 | 69 |
1746390 | 1746390 | 2021-09-23 | Branch | Michigan | 26023 | 6767 | 131 |
1743141 | 1743141 | 2021-09-22 | Branch | Michigan | 26023 | 6767 | 131 |
1674423 | 1674423 | 2021-09-01 | Noble | Indiana | 18113 | 6767 | 101 |
1583899 | 1583899 | 2021-08-04 | Kennebec | Maine | 23011 | 6767 | 82 |
1581350 | 1581350 | 2021-08-03 | St. Lawrence | New York | 36089 | 6767 | 97 |
1511080 | 1511080 | 2021-07-12 | Cowlitz | Washington | 53015 | 6767 | 95 |
1487825 | 1487825 | 2021-07-05 | Carter | Tennessee | 47019 | 6767 | 159 |
1484578 | 1484578 | 2021-07-04 | Carter | Tennessee | 47019 | 6767 | 159 |
1481332 | 1481332 | 2021-07-03 | Carter | Tennessee | 47019 | 6767 | 159 |
1478085 | 1478085 | 2021-07-02 | Carter | Tennessee | 47019 | 6767 | 159 |
1444218 | 1444218 | 2021-06-22 | Acadia | Louisiana | 22001 | 6767 | 196 |
1364391 | 1364391 | 2021-05-28 | Georgetown | South Carolina | 45043 | 6767 | 140 |
1168415 | 1168415 | 2021-03-29 | Lapeer | Michigan | 26087 | 6767 | 140 |
1150285 | 1150285 | 2021-03-23 | Bowie | Texas | 48037 | 6767 | 199 |
1061798 | 1061798 | 2021-02-24 | Hunterdon | New Jersey | 34019 | 6767 | 157 |
1055587 | 1055587 | 2021-02-22 | Erie | Ohio | 39043 | 6767 | 180 |
1031515 | 1031515 | 2021-02-15 | Grant | Indiana | 18053 | 6767 | 161 |
960171 | 960171 | 2021-01-24 | Warrick | Indiana | 18173 | 6767 | 101 |
897188 | 897188 | 2021-01-04 | Grayson | Texas | 48181 | 6767 | 180 |
893942 | 893942 | 2021-01-03 | Grayson | Texas | 48181 | 6767 | 180 |
890696 | 890696 | 2021-01-02 | Grayson | Texas | 48181 | 6767 | 179 |
828611 | 828611 | 2020-12-14 | Franklin | Pennsylvania | 42055 | 6767 | 162 |
652544 | 652544 | 2020-10-21 | DeSoto | Mississippi | 28033 | 6767 | 78 |
586360 | 586360 | 2020-10-01 | Benton | Arkansas | 5007 | 6767 | 93 |
556285 | 556285 | 2020-09-21 | Lexington | South Carolina | 45063 | 6767 | 156 |
529293 | 529293 | 2020-09-13 | Dakota | Minnesota | 27037 | 6767 | 120 |
461819 | 461819 | 2020-08-23 | Washoe | Nevada | 32031 | 6767 | 133 |
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);