ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 10202 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Florida 9
- North Carolina 5
- Iowa 4
- Minnesota 3
- Mississippi 2
- Puerto Rico 2
- South Carolina 2
- West Virginia 2
- Georgia 1
- Hawaii 1
- Maryland 1
- New Jersey 1
- Ohio 1
- Pennsylvania 1
- Vermont 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476433 | 2476433 | 2022-05-05 | Franklin | Vermont | 50011 | 10202 | 67 |
2256894 | 2256894 | 2022-02-27 | Steele | Minnesota | 27147 | 10202 | 57 |
2253643 | 2253643 | 2022-02-26 | Steele | Minnesota | 27147 | 10202 | 57 |
2250392 | 2250392 | 2022-02-25 | Steele | Minnesota | 27147 | 10202 | 57 |
2218570 | 2218570 | 2022-02-15 | Fulton | Ohio | 39051 | 10202 | 168 |
2143655 | 2143655 | 2022-01-23 | Vance | North Carolina | 37181 | 10202 | 109 |
2140400 | 2140400 | 2022-01-22 | Vance | North Carolina | 37181 | 10202 | 109 |
2137144 | 2137144 | 2022-01-21 | Vance | North Carolina | 37181 | 10202 | 109 |
2024500 | 2024500 | 2021-12-17 | Putnam | West Virginia | 54079 | 10202 | 144 |
2018462 | 2018462 | 2021-12-16 | Jackson | Florida | 12063 | 10202 | 241 |
2015212 | 2015212 | 2021-12-15 | Jackson | Florida | 12063 | 10202 | 241 |
2011961 | 2011961 | 2021-12-14 | Jackson | Florida | 12063 | 10202 | 241 |
2008710 | 2008710 | 2021-12-13 | Jackson | Florida | 12063 | 10202 | 240 |
2005459 | 2005459 | 2021-12-12 | Jackson | Florida | 12063 | 10202 | 240 |
2002208 | 2002208 | 2021-12-11 | Jackson | Florida | 12063 | 10202 | 240 |
2004983 | 2004983 | 2021-12-11 | Mercer | West Virginia | 54055 | 10202 | 191 |
1998958 | 1998958 | 2021-12-10 | Jackson | Florida | 12063 | 10202 | 240 |
1934151 | 1934151 | 2021-11-20 | Maui | Hawaii | 15009 | 10202 | 99 |
1919772 | 1919772 | 2021-11-15 | Cherokee | South Carolina | 45021 | 10202 | 255 |
1737834 | 1737834 | 2021-09-20 | Laurens | South Carolina | 45059 | 10202 | 183 |
1714633 | 1714633 | 2021-09-13 | Stanly | North Carolina | 37167 | 10202 | 153 |
1399115 | 1399115 | 2021-06-08 | Madison | Mississippi | 28089 | 10202 | 224 |
1395869 | 1395869 | 2021-06-07 | Madison | Mississippi | 28089 | 10202 | 224 |
1155010 | 1155010 | 2021-03-25 | Pottawattamie | Iowa | 19155 | 10202 | 152 |
1107778 | 1107778 | 2021-03-10 | Bayamon | Puerto Rico | 72021 | 10202 | |
1104532 | 1104532 | 2021-03-09 | Bayamon | Puerto Rico | 72021 | 10202 | |
1096518 | 1096518 | 2021-03-07 | Dallas | Iowa | 19049 | 10202 | 93 |
1093272 | 1093272 | 2021-03-06 | Dallas | Iowa | 19049 | 10202 | 93 |
1090026 | 1090026 | 2021-03-05 | Dallas | Iowa | 19049 | 10202 | 93 |
1065241 | 1065241 | 2021-02-25 | Wayne | North Carolina | 37191 | 10202 | 221 |
1039563 | 1039563 | 2021-02-17 | Fayette | Pennsylvania | 42051 | 10202 | 256 |
923368 | 923368 | 2021-01-12 | Arlington | Virginia | 51013 | 10202 | 186 |
847013 | 847013 | 2020-12-20 | Howard | Maryland | 24027 | 10202 | 170 |
752060 | 752060 | 2020-11-21 | St. Lucie | Florida | 12111 | 10202 | 359 |
729373 | 729373 | 2020-11-14 | Chatham | Georgia | 13051 | 10202 | 201 |
601006 | 601006 | 2020-10-05 | Camden | New Jersey | 34007 | 10202 | 612 |
408790 | 408790 | 2020-08-07 | Collier | Florida | 12021 | 10202 | 131 |
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);