ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 11829 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Louisiana 3
- North Carolina 2
- Tennessee 2
- Alabama 1
- Arizona 1
- California 1
- Kentucky 1
- Maine 1
- New Mexico 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358320 | 2358320 | 2022-03-30 | Vance | North Carolina | 37181 | 11829 | 112 |
2102503 | 2102503 | 2022-01-10 | Mercer | West Virginia | 54055 | 11829 | 210 |
1970545 | 1970545 | 2021-12-01 | Kennebec | Maine | 23011 | 11829 | 122 |
1878099 | 1878099 | 2021-11-02 | Lynchburg city | Virginia | 51680 | 11829 | 186 |
1860827 | 1860827 | 2021-10-28 | Orange | North Carolina | 37135 | 11829 | 110 |
1739657 | 1739657 | 2021-09-21 | Campbell | Kentucky | 21037 | 11829 | 92 |
1725662 | 1725662 | 2021-09-17 | DeKalb | Alabama | 1049 | 11829 | 226 |
1686872 | 1686872 | 2021-09-05 | Napa | California | 6055 | 11829 | 90 |
1513502 | 1513502 | 2021-07-13 | Jackson | Oregon | 41029 | 11829 | 148 |
1364016 | 1364016 | 2021-05-28 | Allen | Ohio | 39003 | 11829 | 237 |
1266394 | 1266394 | 2021-04-28 | Sandoval | New Mexico | 35043 | 11829 | 227 |
1235429 | 1235429 | 2021-04-19 | Cochise | Arizona | 4003 | 11829 | 282 |
1233208 | 1233208 | 2021-04-18 | Ascension | Louisiana | 22005 | 11829 | 162 |
1229960 | 1229960 | 2021-04-17 | Ascension | Louisiana | 22005 | 11829 | 162 |
1226712 | 1226712 | 2021-04-16 | Ascension | Louisiana | 22005 | 11829 | 162 |
1052863 | 1052863 | 2021-02-21 | Sevier | Tennessee | 47155 | 11829 | 159 |
945575 | 945575 | 2021-01-19 | Beaufort | South Carolina | 45013 | 11829 | 126 |
887023 | 887023 | 2021-01-01 | Erie | Pennsylvania | 42049 | 11829 | 227 |
305398 | 305398 | 2020-07-05 | Shelby | Tennessee | 47157 | 11829 | 200 |
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);