ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 12812 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Louisiana 4
- Illinois 3
- Washington 3
- California 2
- Indiana 2
- Missouri 2
- Arkansas 1
- Colorado 1
- Connecticut 1
- Georgia 1
- Massachusetts 1
- New York 1
- North Carolina 1
- Pennsylvania 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483924 | 2483924 | 2022-05-08 | Henry | Illinois | 17073 | 12812 | 150 |
2480666 | 2480666 | 2022-05-07 | Henry | Illinois | 17073 | 12812 | 150 |
2477408 | 2477408 | 2022-05-06 | Henry | Illinois | 17073 | 12812 | 150 |
2421694 | 2421694 | 2022-04-19 | La Plata | Colorado | 8067 | 12812 | 81 |
2265969 | 2265969 | 2022-03-02 | Dubois | Indiana | 18037 | 12812 | 163 |
2237168 | 2237168 | 2022-02-21 | Washington | Louisiana | 22117 | 12812 | 238 |
2028015 | 2028015 | 2021-12-19 | Lonoke | Arkansas | 5085 | 12812 | 178 |
1915979 | 1915979 | 2021-11-14 | Putnam | New York | 36079 | 12812 | 98 |
1877869 | 1877869 | 2021-11-02 | Liberty | Texas | 48291 | 12812 | 349 |
1821382 | 1821382 | 2021-10-16 | Christian | Missouri | 29043 | 12812 | 157 |
1716129 | 1716129 | 2021-09-14 | Sutter | California | 6101 | 12812 | 145 |
1666991 | 1666991 | 2021-08-29 | Grant | Washington | 53025 | 12812 | 145 |
1663743 | 1663743 | 2021-08-28 | Grant | Washington | 53025 | 12812 | 145 |
1660495 | 1660495 | 2021-08-27 | Grant | Washington | 53025 | 12812 | 145 |
1444220 | 1444220 | 2021-06-22 | Ascension | Louisiana | 22005 | 12812 | 167 |
1401214 | 1401214 | 2021-06-09 | Middlesex | Connecticut | 9007 | 12812 | 371 |
1342958 | 1342958 | 2021-05-22 | Lowndes | Georgia | 13185 | 12812 | 212 |
997408 | 997408 | 2021-02-04 | Washington | Pennsylvania | 42125 | 12812 | 235 |
853417 | 853417 | 2020-12-22 | Calcasieu | Louisiana | 22019 | 12812 | 277 |
850548 | 850548 | 2020-12-21 | Boone | Missouri | 29019 | 12812 | 46 |
834754 | 834754 | 2020-12-16 | Gaston | North Carolina | 37071 | 12812 | 203 |
827106 | 827106 | 2020-12-14 | Vanderburgh | Indiana | 18163 | 12812 | 159 |
688024 | 688024 | 2020-11-01 | Bristol | Massachusetts | 25005 | 12812 | 763 |
580009 | 580009 | 2020-09-29 | Ventura | California | 6111 | 12812 | 150 |
358170 | 358170 | 2020-07-22 | Jefferson | Louisiana | 22051 | 12812 | 507 |
230533 | 230533 | 2020-06-11 | Fairfax | Virginia | 51059 | 12812 | 418 |
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);