ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 12198 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Louisiana 12
- Georgia 3
- Alabama 2
- Arizona 2
- California 2
- Maryland 2
- Idaho 1
- Massachusetts 1
- Montana 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2354220 | 2354220 | 2022-03-29 | Lincoln | Louisiana | 22061 | 12198 | 144 |
2350968 | 2350968 | 2022-03-28 | Lincoln | Louisiana | 22061 | 12198 | 143 |
2347715 | 2347715 | 2022-03-27 | Lincoln | Louisiana | 22061 | 12198 | 143 |
2344462 | 2344462 | 2022-03-26 | Lincoln | Louisiana | 22061 | 12198 | 143 |
2341209 | 2341209 | 2022-03-25 | Lincoln | Louisiana | 22061 | 12198 | 143 |
2337956 | 2337956 | 2022-03-24 | Lincoln | Louisiana | 22061 | 12198 | 143 |
2334702 | 2334702 | 2022-03-23 | Lincoln | Louisiana | 22061 | 12198 | 143 |
2331448 | 2331448 | 2022-03-22 | Lincoln | Louisiana | 22061 | 12198 | 143 |
2328196 | 2328196 | 2022-03-21 | Lincoln | Louisiana | 22061 | 12198 | 142 |
2291744 | 2291744 | 2022-03-10 | Liberty | Georgia | 13179 | 12198 | 143 |
2077818 | 2077818 | 2022-01-03 | Allegany | Maryland | 24001 | 12198 | 294 |
2066959 | 2066959 | 2021-12-31 | Gila | Arizona | 4007 | 12198 | 308 |
2032343 | 2032343 | 2021-12-20 | Berkshire | Massachusetts | 25003 | 12198 | 336 |
1828801 | 1828801 | 2021-10-18 | Greenwood | South Carolina | 45047 | 12198 | 212 |
1680196 | 1680196 | 2021-09-03 | Lauderdale | Alabama | 1077 | 12198 | 259 |
1456175 | 1456175 | 2021-06-26 | Cochise | Arizona | 4003 | 12198 | 293 |
1383057 | 1383057 | 2021-06-03 | Flathead | Montana | 30029 | 12198 | 97 |
1336171 | 1336171 | 2021-05-20 | Butte | California | 6007 | 12198 | 188 |
1238549 | 1238549 | 2021-04-19 | Walworth | Wisconsin | 55127 | 12198 | 155 |
1170858 | 1170858 | 2021-03-30 | Lowndes | Georgia | 13185 | 12198 | 196 |
1142323 | 1142323 | 2021-03-21 | Tangipahoa | Louisiana | 22105 | 12198 | 281 |
1139077 | 1139077 | 2021-03-20 | Tangipahoa | Louisiana | 22105 | 12198 | 281 |
1135831 | 1135831 | 2021-03-19 | Tangipahoa | Louisiana | 22105 | 12198 | 281 |
1076790 | 1076790 | 2021-03-01 | Bonneville | Idaho | 16019 | 12198 | 147 |
966372 | 966372 | 2021-01-26 | Paulding | Georgia | 13223 | 12198 | 140 |
898934 | 898934 | 2021-01-05 | Frederick | Maryland | 24021 | 12198 | 200 |
777878 | 777878 | 2020-11-29 | Sonoma | California | 6097 | 12198 | 157 |
764713 | 764713 | 2020-11-25 | Montgomery | Alabama | 1101 | 12198 | 235 |
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);