ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 10587 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Oklahoma 7
- Virginia 4
- Georgia 3
- Mississippi 3
- Florida 2
- Missouri 2
- New York 2
- Ohio 2
- Texas 2
- Alabama 1
- California 1
- Connecticut 1
- New Jersey 1
- New Mexico 1
- Pennsylvania 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2312999 | 2312999 | 2022-03-16 | Sequoyah | Oklahoma | 40135 | 10587 | 102 |
2309746 | 2309746 | 2022-03-15 | Sequoyah | Oklahoma | 40135 | 10587 | 102 |
2306493 | 2306493 | 2022-03-14 | Sequoyah | Oklahoma | 40135 | 10587 | 102 |
2303242 | 2303242 | 2022-03-13 | Sequoyah | Oklahoma | 40135 | 10587 | 102 |
2299990 | 2299990 | 2022-03-12 | Sequoyah | Oklahoma | 40135 | 10587 | 102 |
2296738 | 2296738 | 2022-03-11 | Sequoyah | Oklahoma | 40135 | 10587 | 102 |
2293486 | 2293486 | 2022-03-10 | Sequoyah | Oklahoma | 40135 | 10587 | 102 |
2290113 | 2290113 | 2022-03-09 | Highland | Ohio | 39071 | 10587 | 175 |
2248712 | 2248712 | 2022-02-24 | Franklin | Virginia | 51067 | 10587 | 176 |
2228887 | 2228887 | 2022-02-18 | Burnet | Texas | 48053 | 10587 | 154 |
2186702 | 2186702 | 2022-02-05 | Jim Wells | Texas | 48249 | 10587 | 189 |
2102367 | 2102367 | 2022-01-10 | James City | Virginia | 51095 | 10587 | 100 |
2019943 | 2019943 | 2021-12-16 | Otero | New Mexico | 35035 | 10587 | 133 |
1949533 | 1949533 | 2021-11-24 | Augusta | Virginia | 51015 | 10587 | 136 |
1915546 | 1915546 | 2021-11-14 | Lamar | Mississippi | 28073 | 10587 | 140 |
1915974 | 1915974 | 2021-11-14 | Ontario | New York | 36069 | 10587 | 113 |
1912296 | 1912296 | 2021-11-13 | Lamar | Mississippi | 28073 | 10587 | 140 |
1909046 | 1909046 | 2021-11-12 | Lamar | Mississippi | 28073 | 10587 | 140 |
1744869 | 1744869 | 2021-09-22 | Hanover | Virginia | 51085 | 10587 | 182 |
1596172 | 1596172 | 2021-08-08 | Jackson | Georgia | 13157 | 10587 | 153 |
1592923 | 1592923 | 2021-08-07 | Jackson | Georgia | 13157 | 10587 | 153 |
1589674 | 1589674 | 2021-08-06 | Jackson | Georgia | 13157 | 10587 | 153 |
1556781 | 1556781 | 2021-07-27 | St. Clair | Alabama | 1115 | 10587 | 250 |
1288814 | 1288814 | 2021-05-05 | Franklin | Missouri | 29071 | 10587 | 183 |
1223873 | 1223873 | 2021-04-15 | Franklin | Missouri | 29071 | 10587 | 179 |
1219424 | 1219424 | 2021-04-14 | Citrus | Florida | 12017 | 10587 | 432 |
968143 | 968143 | 2021-01-26 | Cambria | Pennsylvania | 42021 | 10587 | 358 |
696365 | 696365 | 2020-11-03 | Snohomish | Washington | 53061 | 10587 | 246 |
612395 | 612395 | 2020-10-09 | Monterey | California | 6053 | 10587 | 78 |
403806 | 403806 | 2020-08-05 | Ocean | New Jersey | 34029 | 10587 | 1016 |
311223 | 311223 | 2020-07-07 | Franklin | Ohio | 39049 | 10587 | 431 |
160567 | 160567 | 2020-05-20 | New Haven | Connecticut | 9009 | 10587 | 855 |
81583 | 81583 | 2020-04-23 | Miami-Dade | Florida | 12086 | 10587 | 270 |
27466 | 27466 | 2020-04-02 | Nassau | New York | 36059 | 10587 | 95 |
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);