ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 12757 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Florida 8
- Michigan 3
- West Virginia 2
- Alabama 1
- Arizona 1
- Arkansas 1
- California 1
- Georgia 1
- Kentucky 1
- Louisiana 1
- Massachusetts 1
- Mississippi 1
- Missouri 1
- Texas 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2197122 | 2197122 | 2022-02-09 | Mississippi | Arkansas | 5093 | 12757 | 175 |
2188526 | 2188526 | 2022-02-06 | Tuscola | Michigan | 26157 | 12757 | 260 |
2185273 | 2185273 | 2022-02-05 | Tuscola | Michigan | 26157 | 12757 | 260 |
2182021 | 2182021 | 2022-02-04 | Tuscola | Michigan | 26157 | 12757 | 260 |
2154543 | 2154543 | 2022-01-26 | Marion | West Virginia | 54049 | 12757 | 146 |
2096223 | 2096223 | 2022-01-09 | Gila | Arizona | 4007 | 12757 | 316 |
2073425 | 2073425 | 2022-01-02 | Walker | Alabama | 1127 | 12757 | 388 |
1973838 | 1973838 | 2021-12-02 | Hampshire | Massachusetts | 25015 | 12757 | 327 |
1887490 | 1887490 | 2021-11-05 | Bowie | Texas | 48037 | 12757 | 331 |
1801887 | 1801887 | 2021-10-10 | Christian | Missouri | 29043 | 12757 | 157 |
1473464 | 1473464 | 2021-07-01 | Rapides | Louisiana | 22079 | 12757 | 327 |
1404499 | 1404499 | 2021-06-10 | Indian River | Florida | 12061 | 12757 | 306 |
1401254 | 1401254 | 2021-06-09 | Indian River | Florida | 12061 | 12757 | 306 |
1398009 | 1398009 | 2021-06-08 | Indian River | Florida | 12061 | 12757 | 306 |
1400754 | 1400754 | 2021-06-08 | Berkeley | West Virginia | 54003 | 12757 | 126 |
1394762 | 1394762 | 2021-06-07 | Indian River | Florida | 12061 | 12757 | 306 |
1391517 | 1391517 | 2021-06-06 | Indian River | Florida | 12061 | 12757 | 306 |
1388272 | 1388272 | 2021-06-05 | Indian River | Florida | 12061 | 12757 | 306 |
1385027 | 1385027 | 2021-06-04 | Indian River | Florida | 12061 | 12757 | 306 |
1296940 | 1296940 | 2021-05-07 | Dodge | Wisconsin | 55027 | 12757 | 185 |
1084191 | 1084191 | 2021-03-03 | Rankin | Mississippi | 28121 | 12757 | 265 |
1054514 | 1054514 | 2021-02-22 | Boone | Kentucky | 21015 | 12757 | 72 |
1027745 | 1027745 | 2021-02-14 | Marin | California | 6041 | 12757 | 184 |
985128 | 985128 | 2021-01-31 | Richmond city | Virginia | 51760 | 12757 | 132 |
969612 | 969612 | 2021-01-27 | Muscogee | Georgia | 13215 | 12757 | 250 |
761795 | 761795 | 2020-11-24 | Sarasota | Florida | 12115 | 12757 | 382 |
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);