ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 11477 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Virginia 4
- Pennsylvania 3
- Tennessee 3
- Ohio 2
- Washington 2
- Alabama 1
- Illinois 1
- Indiana 1
- Mississippi 1
- New Jersey 1
- Puerto Rico 1
- South Carolina 1
- Texas 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496024 | 2496024 | 2022-05-11 | Culpeper | Virginia | 51047 | 11477 | 149 |
2383039 | 2383039 | 2022-04-07 | Stephenson | Illinois | 17177 | 11477 | 176 |
2339103 | 2339103 | 2022-03-24 | Huntingdon | Pennsylvania | 42061 | 11477 | 242 |
2316991 | 2316991 | 2022-03-17 | Culpeper | Virginia | 51047 | 11477 | 143 |
2186751 | 2186751 | 2022-02-05 | Nacogdoches | Texas | 48347 | 11477 | 247 |
2105792 | 2105792 | 2022-01-11 | Columbia | Wisconsin | 55021 | 11477 | 105 |
2095263 | 2095263 | 2022-01-08 | Ponce | Puerto Rico | 72113 | 11477 | |
2036631 | 2036631 | 2021-12-21 | Armstrong | Pennsylvania | 42005 | 11477 | 265 |
2016318 | 2016318 | 2021-12-15 | Lowndes | Mississippi | 28087 | 11477 | 196 |
1875162 | 1875162 | 2021-11-02 | Walker | Alabama | 1127 | 11477 | 371 |
1868491 | 1868491 | 2021-10-30 | Raleigh | West Virginia | 54081 | 11477 | 173 |
1769690 | 1769690 | 2021-09-30 | Warren | New Jersey | 34041 | 11477 | 251 |
1770308 | 1770308 | 2021-09-30 | Darlington | South Carolina | 45031 | 11477 | 218 |
1666521 | 1666521 | 2021-08-29 | Robertson | Tennessee | 47147 | 11477 | 146 |
1663273 | 1663273 | 2021-08-28 | Robertson | Tennessee | 47147 | 11477 | 146 |
1660025 | 1660025 | 2021-08-27 | Robertson | Tennessee | 47147 | 11477 | 146 |
1657217 | 1657217 | 2021-08-26 | Spotsylvania | Virginia | 51177 | 11477 | 128 |
1623807 | 1623807 | 2021-08-16 | Miami | Ohio | 39109 | 11477 | 232 |
1439648 | 1439648 | 2021-06-20 | Stafford | Virginia | 51179 | 11477 | 82 |
1150712 | 1150712 | 2021-03-23 | Franklin | Washington | 53021 | 11477 | 103 |
1010383 | 1010383 | 2021-02-08 | Schuylkill | Pennsylvania | 42107 | 11477 | 345 |
1005534 | 1005534 | 2021-02-07 | Clark | Indiana | 18019 | 11477 | 174 |
881306 | 881306 | 2020-12-30 | Benton | Washington | 53005 | 11477 | 164 |
873829 | 873829 | 2020-12-28 | Clermont | Ohio | 39025 | 11477 | 76 |
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);