ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 12797 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Tennessee 7
- Indiana 4
- New Mexico 4
- Connecticut 3
- Louisiana 2
- Arizona 1
- Arkansas 1
- Illinois 1
- Iowa 1
- Missouri 1
- Nevada 1
- New York 1
- Oregon 1
- Pennsylvania 1
- Rhode Island 1
- Texas 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501399 | 2501399 | 2022-05-13 | Curry | New Mexico | 35009 | 12797 | 198 |
2492754 | 2492754 | 2022-05-10 | Campbell | Virginia | 51031 | 12797 | 215 |
2446765 | 2446765 | 2022-04-26 | Dyer | Tennessee | 47045 | 12797 | 201 |
2443510 | 2443510 | 2022-04-25 | Dyer | Tennessee | 47045 | 12797 | 201 |
2440254 | 2440254 | 2022-04-24 | Dyer | Tennessee | 47045 | 12797 | 201 |
2436998 | 2436998 | 2022-04-23 | Dyer | Tennessee | 47045 | 12797 | 201 |
2433742 | 2433742 | 2022-04-22 | Dyer | Tennessee | 47045 | 12797 | 201 |
2430486 | 2430486 | 2022-04-21 | Dyer | Tennessee | 47045 | 12797 | 201 |
2427230 | 2427230 | 2022-04-20 | Dyer | Tennessee | 47045 | 12797 | 201 |
2217218 | 2217218 | 2022-02-15 | Henry | Indiana | 18065 | 12797 | 219 |
2187965 | 2187965 | 2022-02-06 | Noble | Indiana | 18113 | 12797 | 149 |
2184712 | 2184712 | 2022-02-05 | Noble | Indiana | 18113 | 12797 | 149 |
2181460 | 2181460 | 2022-02-04 | Noble | Indiana | 18113 | 12797 | 149 |
2180184 | 2180184 | 2022-02-03 | Hood | Texas | 48221 | 12797 | 239 |
2173190 | 2173190 | 2022-02-01 | Klamath | Oregon | 41035 | 12797 | 182 |
2099474 | 2099474 | 2022-01-10 | Gila | Arizona | 4007 | 12797 | 316 |
2024764 | 2024764 | 2021-12-18 | Lonoke | Arkansas | 5085 | 12797 | 178 |
1668687 | 1668687 | 2021-08-30 | Clay | Missouri | 29047 | 12797 | 185 |
1620275 | 1620275 | 2021-08-15 | McKinley | New Mexico | 35031 | 12797 | 483 |
1617027 | 1617027 | 2021-08-14 | McKinley | New Mexico | 35031 | 12797 | 483 |
1613779 | 1613779 | 2021-08-13 | McKinley | New Mexico | 35031 | 12797 | 483 |
1489696 | 1489696 | 2021-07-06 | Rapides | Louisiana | 22079 | 12797 | 328 |
1391477 | 1391477 | 2021-06-06 | Middlesex | Connecticut | 9007 | 12797 | 371 |
1388232 | 1388232 | 2021-06-05 | Middlesex | Connecticut | 9007 | 12797 | 371 |
1384987 | 1384987 | 2021-06-04 | Middlesex | Connecticut | 9007 | 12797 | 371 |
1333907 | 1333907 | 2021-05-19 | Tangipahoa | Louisiana | 22105 | 12797 | 297 |
1270216 | 1270216 | 2021-04-29 | Unknown | Rhode Island | 12797 | 13 | |
1143416 | 1143416 | 2021-03-21 | Beaver | Pennsylvania | 42007 | 12797 | 355 |
1132056 | 1132056 | 2021-03-18 | Kankakee | Illinois | 17091 | 12797 | 199 |
1021895 | 1021895 | 2021-02-12 | Johnson | Iowa | 19103 | 12797 | 68 |
1024218 | 1024218 | 2021-02-12 | Fond du Lac | Wisconsin | 55039 | 12797 | 96 |
893088 | 893088 | 2021-01-03 | Dutchess | New York | 36027 | 12797 | 243 |
672355 | 672355 | 2020-10-27 | Washoe | Nevada | 32031 | 12797 | 195 |
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);