ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 6669 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Tennessee 5
- Virginia 5
- Louisiana 4
- South Dakota 4
- West Virginia 3
- Wisconsin 3
- Indiana 2
- Michigan 2
- Minnesota 2
- New York 2
- North Carolina 2
- Ohio 2
- Alabama 1
- Illinois 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- Pennsylvania 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313894 | 2313894 | 2022-03-16 | Hancock | West Virginia | 54029 | 6669 | 140 |
2203204 | 2203204 | 2022-02-10 | Halifax | Virginia | 51083 | 6669 | 138 |
2197760 | 2197760 | 2022-02-09 | White | Indiana | 18181 | 6669 | 88 |
2194506 | 2194506 | 2022-02-08 | White | Indiana | 18181 | 6669 | 88 |
2191612 | 2191612 | 2022-02-07 | Morehouse | Louisiana | 22067 | 6669 | 127 |
2170881 | 2170881 | 2022-01-31 | Lincoln | Wisconsin | 55069 | 6669 | 128 |
2126845 | 2126845 | 2022-01-18 | Leflore | Mississippi | 28083 | 6669 | 145 |
2098602 | 2098602 | 2022-01-09 | Codington | South Dakota | 46029 | 6669 | 91 |
2095350 | 2095350 | 2022-01-08 | Codington | South Dakota | 46029 | 6669 | 91 |
2092098 | 2092098 | 2022-01-07 | Codington | South Dakota | 46029 | 6669 | 91 |
2030161 | 2030161 | 2021-12-19 | Jefferson | Pennsylvania | 42065 | 6669 | 177 |
1964431 | 1964431 | 2021-11-29 | Phelps | Missouri | 29161 | 6669 | 193 |
1945280 | 1945280 | 2021-11-23 | Davie | North Carolina | 37059 | 6669 | 81 |
1905528 | 1905528 | 2021-11-11 | Webster | Louisiana | 22119 | 6669 | 148 |
1902278 | 1902278 | 2021-11-10 | Webster | Louisiana | 22119 | 6669 | 148 |
1904083 | 1904083 | 2021-11-10 | Henry | Virginia | 51089 | 6669 | 165 |
1861322 | 1861322 | 2021-10-28 | Brown | South Dakota | 46013 | 6669 | 100 |
1748380 | 1748380 | 2021-09-23 | Sweetwater | Wyoming | 56037 | 6669 | 63 |
1678189 | 1678189 | 2021-09-02 | Isabella | Michigan | 26073 | 6669 | 102 |
1674941 | 1674941 | 2021-09-01 | Isabella | Michigan | 26073 | 6669 | 102 |
1665728 | 1665728 | 2021-08-29 | Salem | New Jersey | 34033 | 6669 | 193 |
1471610 | 1471610 | 2021-06-30 | Gibson | Tennessee | 47053 | 6669 | 150 |
1468747 | 1468747 | 2021-06-29 | Bedford | Virginia | 51019 | 6669 | 109 |
1448894 | 1448894 | 2021-06-23 | Gibson | Tennessee | 47053 | 6669 | 149 |
1445649 | 1445649 | 2021-06-22 | Gibson | Tennessee | 47053 | 6669 | 149 |
1426174 | 1426174 | 2021-06-16 | Gibson | Tennessee | 47053 | 6669 | 149 |
1376059 | 1376059 | 2021-06-01 | Acadia | Louisiana | 22001 | 6669 | 195 |
1324337 | 1324337 | 2021-05-16 | Crow Wing | Minnesota | 27035 | 6669 | 90 |
1298913 | 1298913 | 2021-05-08 | Steuben | New York | 36101 | 6669 | 143 |
1290420 | 1290420 | 2021-05-05 | Raleigh | West Virginia | 54081 | 6669 | 83 |
1185246 | 1185246 | 2021-04-03 | Oswego | New York | 36075 | 6669 | 89 |
1032867 | 1032867 | 2021-02-15 | Erie | Ohio | 39043 | 6669 | 171 |
1024045 | 1024045 | 2021-02-12 | Lynchburg city | Virginia | 51680 | 6669 | 86 |
1004725 | 1004725 | 2021-02-06 | Wood | West Virginia | 54107 | 6669 | 120 |
989932 | 989932 | 2021-02-02 | Clay | Minnesota | 27027 | 6669 | 84 |
990505 | 990505 | 2021-02-02 | Brunswick | North Carolina | 37019 | 6669 | 102 |
943067 | 943067 | 2021-01-18 | Chippewa | Wisconsin | 55017 | 6669 | 74 |
808918 | 808918 | 2020-12-08 | Clark | Ohio | 39023 | 6669 | 147 |
809377 | 809377 | 2020-12-08 | Blount | Tennessee | 47009 | 6669 | 66 |
784788 | 784788 | 2020-12-01 | Macon | Illinois | 17115 | 6669 | 135 |
780672 | 780672 | 2020-11-29 | Richmond city | Virginia | 51760 | 6669 | 82 |
738630 | 738630 | 2020-11-16 | La Crosse | Wisconsin | 55063 | 6669 | 30 |
680348 | 680348 | 2020-10-30 | Lee | Alabama | 1081 | 6669 | 65 |
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);