ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 10700 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Indiana 5
- Alabama 3
- Texas 3
- Virginia 3
- Maryland 2
- Tennessee 2
- California 1
- Georgia 1
- Idaho 1
- Missouri 1
- New Hampshire 1
- New Mexico 1
- New York 1
- North Carolina 1
- Ohio 1
- Utah 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461246 | 2461246 | 2022-05-01 | Montgomery | Indiana | 18107 | 10700 | 164 |
2457990 | 2457990 | 2022-04-30 | Montgomery | Indiana | 18107 | 10700 | 164 |
2454734 | 2454734 | 2022-04-29 | Montgomery | Indiana | 18107 | 10700 | 164 |
2281519 | 2281519 | 2022-03-07 | Chilton | Alabama | 1021 | 10700 | 193 |
2211186 | 2211186 | 2022-02-13 | Calvert | Maryland | 24009 | 10700 | 135 |
2203051 | 2203051 | 2022-02-10 | San Patricio | Texas | 48409 | 10700 | 319 |
2125829 | 2125829 | 2022-01-18 | Effingham | Georgia | 13103 | 10700 | 177 |
2098861 | 2098861 | 2022-01-09 | Hood | Texas | 48221 | 10700 | 220 |
2040740 | 2040740 | 2021-12-22 | Mercer | West Virginia | 54055 | 10700 | 196 |
1953102 | 1953102 | 2021-11-26 | Blount | Alabama | 1009 | 10700 | 192 |
1949851 | 1949851 | 2021-11-25 | Blount | Alabama | 1009 | 10700 | 192 |
1945896 | 1945896 | 2021-11-23 | Dickson | Tennessee | 47043 | 10700 | 169 |
1832284 | 1832284 | 2021-10-19 | Coryell | Texas | 48099 | 10700 | 154 |
1826158 | 1826158 | 2021-10-17 | Suffolk city | Virginia | 51800 | 10700 | 224 |
1822909 | 1822909 | 2021-10-16 | Suffolk city | Virginia | 51800 | 10700 | 224 |
1819660 | 1819660 | 2021-10-15 | Suffolk city | Virginia | 51800 | 10700 | 224 |
1652717 | 1652717 | 2021-08-25 | Strafford | New Hampshire | 33017 | 10700 | 101 |
1555358 | 1555358 | 2021-07-26 | Putnam | New York | 36079 | 10700 | 93 |
1340759 | 1340759 | 2021-05-21 | Franklin | Missouri | 29071 | 10700 | 184 |
1314464 | 1314464 | 2021-05-13 | Charles | Maryland | 24017 | 10700 | 194 |
1148399 | 1148399 | 2021-03-23 | Monroe | Indiana | 18105 | 10700 | 168 |
1055567 | 1055567 | 2021-02-22 | Allen | Ohio | 39003 | 10700 | 231 |
1011544 | 1011544 | 2021-02-09 | Shasta | California | 6089 | 10700 | 161 |
953677 | 953677 | 2021-01-22 | Vigo | Indiana | 18167 | 10700 | 184 |
925512 | 925512 | 2021-01-13 | McKinley | New Mexico | 35031 | 10700 | 370 |
868145 | 868145 | 2020-12-26 | Cache | Utah | 49005 | 10700 | 19 |
796475 | 796475 | 2020-12-04 | Sumner | Tennessee | 47165 | 10700 | 144 |
750367 | 750367 | 2020-11-20 | Durham | North Carolina | 37063 | 10700 | 111 |
463837 | 463837 | 2020-08-24 | Ada | Idaho | 16001 | 10700 | 111 |
405088 | 405088 | 2020-08-05 | Yakima | Washington | 53077 | 10700 | 223 |
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);