ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 12653 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Illinois 8
- North Carolina 6
- Idaho 5
- Florida 2
- Kentucky 2
- Arkansas 1
- California 1
- District of Columbia 1
- Iowa 1
- Mississippi 1
- Ohio 1
- Pennsylvania 1
- South Dakota 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483935 | 2483935 | 2022-05-08 | Knox | Illinois | 17095 | 12653 | 246 |
2480677 | 2480677 | 2022-05-07 | Knox | Illinois | 17095 | 12653 | 246 |
2477419 | 2477419 | 2022-05-06 | Knox | Illinois | 17095 | 12653 | 246 |
2402471 | 2402471 | 2022-04-13 | Madison | Idaho | 16065 | 12653 | 50 |
2399216 | 2399216 | 2022-04-12 | Madison | Idaho | 16065 | 12653 | 50 |
2395961 | 2395961 | 2022-04-11 | Madison | Idaho | 16065 | 12653 | 50 |
2314620 | 2314620 | 2022-03-17 | Madison | Idaho | 16065 | 12653 | 50 |
2311367 | 2311367 | 2022-03-16 | Madison | Idaho | 16065 | 12653 | 50 |
2278914 | 2278914 | 2022-03-06 | Macoupin | Illinois | 17117 | 12653 | 166 |
2275661 | 2275661 | 2022-03-05 | Macoupin | Illinois | 17117 | 12653 | 166 |
2272408 | 2272408 | 2022-03-04 | Macoupin | Illinois | 17117 | 12653 | 166 |
2104079 | 2104079 | 2022-01-11 | Lamar | Mississippi | 28073 | 12653 | 140 |
2080967 | 2080967 | 2022-01-04 | Pulaski | Kentucky | 21199 | 12653 | 228 |
2077715 | 2077715 | 2022-01-03 | Pulaski | Kentucky | 21199 | 12653 | 228 |
2029852 | 2029852 | 2021-12-19 | Stanly | North Carolina | 37167 | 12653 | 206 |
2026601 | 2026601 | 2021-12-18 | Stanly | North Carolina | 37167 | 12653 | 206 |
2023350 | 2023350 | 2021-12-17 | Stanly | North Carolina | 37167 | 12653 | 206 |
2002008 | 2002008 | 2021-12-11 | Lonoke | Arkansas | 5085 | 12653 | 177 |
1835502 | 1835502 | 2021-10-20 | Bowie | Texas | 48037 | 12653 | 317 |
1782951 | 1782951 | 2021-10-04 | Columbiana | Ohio | 39029 | 12653 | 244 |
1779629 | 1779629 | 2021-10-03 | Wilson | North Carolina | 37195 | 12653 | 214 |
1776379 | 1776379 | 2021-10-02 | Wilson | North Carolina | 37195 | 12653 | 214 |
1773129 | 1773129 | 2021-10-01 | Wilson | North Carolina | 37195 | 12653 | 214 |
1433548 | 1433548 | 2021-06-19 | Butte | California | 6007 | 12653 | 194 |
1339877 | 1339877 | 2021-05-21 | LaSalle | Illinois | 17099 | 12653 | 300 |
1320100 | 1320100 | 2021-05-15 | Indian River | Florida | 12061 | 12653 | 304 |
1296063 | 1296063 | 2021-05-07 | Fayette | Pennsylvania | 42051 | 12653 | 309 |
1036542 | 1036542 | 2021-02-16 | Pennington | South Dakota | 46103 | 12653 | 183 |
1036962 | 1036962 | 2021-02-16 | Arlington | Virginia | 51013 | 12653 | 210 |
1002422 | 1002422 | 2021-02-06 | Johnson | Iowa | 19103 | 12653 | 65 |
839687 | 839687 | 2020-12-18 | St. Lucie | Florida | 12111 | 12653 | 380 |
752335 | 752335 | 2020-11-21 | Madison | Illinois | 17119 | 12653 | 219 |
411998 | 411998 | 2020-08-08 | District of Columbia | District of Columbia | 11001 | 12653 | 590 |
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);