ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 15663 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Georgia 5
- Michigan 4
- Indiana 1
- Missouri 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- Texas 1
- Utah 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488805 | 2488805 | 2022-05-09 | Polk | Oregon | 41053 | 15663 | 134 |
1958657 | 1958657 | 2021-11-27 | Mercer | Pennsylvania | 42085 | 15663 | 370 |
1691164 | 1691164 | 2021-09-06 | Calhoun | Michigan | 26025 | 15663 | 327 |
1687914 | 1687914 | 2021-09-05 | Calhoun | Michigan | 26025 | 15663 | 327 |
1684664 | 1684664 | 2021-09-04 | Calhoun | Michigan | 26025 | 15663 | 327 |
1681413 | 1681413 | 2021-09-03 | Calhoun | Michigan | 26025 | 15663 | 327 |
1563087 | 1563087 | 2021-07-28 | Kanawha | West Virginia | 54039 | 15663 | 361 |
1485727 | 1485727 | 2021-07-05 | Douglas | Georgia | 13097 | 15663 | 232 |
1482481 | 1482481 | 2021-07-04 | Douglas | Georgia | 13097 | 15663 | 232 |
1479234 | 1479234 | 2021-07-03 | Douglas | Georgia | 13097 | 15663 | 232 |
1475988 | 1475988 | 2021-07-02 | Douglas | Georgia | 13097 | 15663 | 232 |
1225093 | 1225093 | 2021-04-15 | Kaufman | Texas | 48257 | 15663 | 252 |
1094873 | 1094873 | 2021-03-06 | Beaufort | South Carolina | 45013 | 15663 | 189 |
1066913 | 1066913 | 2021-02-26 | Columbia | Georgia | 13073 | 15663 | 185 |
1028305 | 1028305 | 2021-02-14 | Porter | Indiana | 18127 | 15663 | 273 |
850588 | 850588 | 2020-12-21 | Jefferson | Missouri | 29099 | 15663 | 121 |
340677 | 340677 | 2020-07-16 | Salt Lake | Utah | 49035 | 15663 | 135 |
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);