ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 10564 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- North Carolina 3
- Indiana 2
- Michigan 2
- New York 2
- Ohio 2
- Tennessee 2
- Alabama 1
- Arkansas 1
- Florida 1
- Georgia 1
- Louisiana 1
- Maryland 1
- New Jersey 1
- Oregon 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468170 | 2468170 | 2022-05-03 | St. John the Baptist | Louisiana | 22095 | 10564 | 184 |
2249001 | 2249001 | 2022-02-25 | Chilton | Alabama | 1021 | 10564 | 187 |
2153555 | 2153555 | 2022-01-26 | Shelby | Ohio | 39149 | 10564 | 160 |
2124284 | 2124284 | 2022-01-17 | Washington | Ohio | 39167 | 10564 | 168 |
1944669 | 1944669 | 2021-11-23 | Van Buren | Michigan | 26159 | 10564 | 177 |
1941418 | 1941418 | 2021-11-22 | Van Buren | Michigan | 26159 | 10564 | 177 |
1928962 | 1928962 | 2021-11-18 | Jefferson | New York | 36045 | 10564 | 101 |
1877637 | 1877637 | 2021-11-02 | Carter | Tennessee | 47019 | 10564 | 217 |
1853087 | 1853087 | 2021-10-26 | Grant | Indiana | 18053 | 10564 | 228 |
1756868 | 1756868 | 2021-09-26 | Sampson | North Carolina | 37163 | 10564 | 125 |
1753620 | 1753620 | 2021-09-25 | Sampson | North Carolina | 37163 | 10564 | 125 |
1750372 | 1750372 | 2021-09-24 | Sampson | North Carolina | 37163 | 10564 | 125 |
1742593 | 1742593 | 2021-09-22 | Bartholomew | Indiana | 18005 | 10564 | 173 |
1723599 | 1723599 | 2021-09-16 | Carroll | Maryland | 24013 | 10564 | 270 |
1552574 | 1552574 | 2021-07-25 | Carolina | Puerto Rico | 72031 | 10564 | |
1469194 | 1469194 | 2021-06-30 | Garland | Arkansas | 5051 | 10564 | 264 |
1354100 | 1354100 | 2021-05-25 | Putnam | New York | 36079 | 10564 | 91 |
1216176 | 1216176 | 2021-04-13 | Citrus | Florida | 12017 | 10564 | 432 |
1195690 | 1195690 | 2021-04-06 | Madison | Tennessee | 47113 | 10564 | 239 |
1143396 | 1143396 | 2021-03-21 | Lane | Oregon | 41039 | 10564 | 139 |
1073390 | 1073390 | 2021-02-28 | Carroll | Georgia | 13045 | 10564 | 213 |
717788 | 717788 | 2020-11-10 | Morris | New Jersey | 34027 | 10564 | 843 |
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);