ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 9880 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Wyoming 7
- South Carolina 6
- Tennessee 4
- Alabama 3
- Guam 3
- West Virginia 3
- Kansas 2
- Ohio 2
- Puerto Rico 2
- Texas 2
- California 1
- Michigan 1
- Missouri 1
- New Mexico 1
- North Dakota 1
- Pennsylvania 1
- Vermont 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447493 | 2447493 | 2022-04-27 | Franklin | Alabama | 1059 | 9880 | 138 |
2421393 | 2421393 | 2022-04-18 | Albany | Wyoming | 56001 | 9880 | 48 |
2418137 | 2418137 | 2022-04-17 | Albany | Wyoming | 56001 | 9880 | 48 |
2414881 | 2414881 | 2022-04-16 | Albany | Wyoming | 56001 | 9880 | 48 |
2411625 | 2411625 | 2022-04-15 | Albany | Wyoming | 56001 | 9880 | 48 |
2408369 | 2408369 | 2022-04-14 | Albany | Wyoming | 56001 | 9880 | 48 |
2405113 | 2405113 | 2022-04-13 | Albany | Wyoming | 56001 | 9880 | 48 |
2401034 | 2401034 | 2022-04-12 | Trujillo Alto | Puerto Rico | 72139 | 9880 | |
2401858 | 2401858 | 2022-04-12 | Albany | Wyoming | 56001 | 9880 | 48 |
2206781 | 2206781 | 2022-02-12 | Russell | Alabama | 1113 | 9880 | 75 |
2179556 | 2179556 | 2022-02-03 | Logan | Ohio | 39091 | 9880 | 148 |
2101457 | 2101457 | 2022-01-10 | Darke | Ohio | 39037 | 9880 | 192 |
1998517 | 1998517 | 2021-12-09 | Calumet | Wisconsin | 55015 | 9880 | 75 |
1968542 | 1968542 | 2021-11-30 | Georgetown | South Carolina | 45043 | 9880 | 184 |
1851680 | 1851680 | 2021-10-25 | Jefferson | Tennessee | 47089 | 9880 | 144 |
1848430 | 1848430 | 2021-10-24 | Jefferson | Tennessee | 47089 | 9880 | 144 |
1845180 | 1845180 | 2021-10-23 | Jefferson | Tennessee | 47089 | 9880 | 144 |
1841930 | 1841930 | 2021-10-22 | Jefferson | Tennessee | 47089 | 9880 | 144 |
1751297 | 1751297 | 2021-09-24 | Chittenden | Vermont | 50007 | 9880 | 117 |
1747860 | 1747860 | 2021-09-23 | Hardin | Texas | 48199 | 9880 | 167 |
1744610 | 1744610 | 2021-09-22 | Hardin | Texas | 48199 | 9880 | 165 |
1700628 | 1700628 | 2021-09-09 | Reno | Kansas | 20155 | 9880 | 148 |
1697379 | 1697379 | 2021-09-08 | Reno | Kansas | 20155 | 9880 | 148 |
1644312 | 1644312 | 2021-08-22 | Monongalia | West Virginia | 54061 | 9880 | 93 |
1641062 | 1641062 | 2021-08-21 | Monongalia | West Virginia | 54061 | 9880 | 93 |
1637812 | 1637812 | 2021-08-20 | Monongalia | West Virginia | 54061 | 9880 | 93 |
1618996 | 1618996 | 2021-08-15 | Unknown | Guam | 9880 | 144 | |
1615748 | 1615748 | 2021-08-14 | Unknown | Guam | 9880 | 144 | |
1612499 | 1612499 | 2021-08-13 | Unknown | Guam | 9880 | 144 | |
1581723 | 1581723 | 2021-08-03 | Adams | Pennsylvania | 42001 | 9880 | 190 |
1439058 | 1439058 | 2021-06-20 | Orangeburg | South Carolina | 45075 | 9880 | 255 |
1435811 | 1435811 | 2021-06-19 | Orangeburg | South Carolina | 45075 | 9880 | 255 |
1432564 | 1432564 | 2021-06-18 | Orangeburg | South Carolina | 45075 | 9880 | 255 |
1416335 | 1416335 | 2021-06-13 | Orangeburg | South Carolina | 45075 | 9880 | 254 |
1370899 | 1370899 | 2021-05-30 | Orangeburg | South Carolina | 45075 | 9880 | 253 |
1367256 | 1367256 | 2021-05-29 | Ward | North Dakota | 38101 | 9880 | 196 |
1308025 | 1308025 | 2021-05-11 | Eaton | Michigan | 26045 | 9880 | 195 |
1150916 | 1150916 | 2021-03-24 | Elmore | Alabama | 1051 | 9880 | 200 |
1009575 | 1009575 | 2021-02-08 | Buchanan | Missouri | 29021 | 9880 | 157 |
696734 | 696734 | 2020-11-04 | Merced | California | 6047 | 9880 | 161 |
663239 | 663239 | 2020-10-24 | San Juan | Puerto Rico | 72127 | 9880 | |
659415 | 659415 | 2020-10-23 | Bernalillo | New Mexico | 35001 | 9880 | 190 |
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);