ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 11745 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- North Carolina 4
- Georgia 3
- Minnesota 2
- South Carolina 2
- Mississippi 1
- Missouri 1
- Montana 1
- New York 1
- Pennsylvania 1
- Puerto Rico 1
- South Dakota 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2368486 | 2368486 | 2022-04-02 | Toa Alta | Puerto Rico | 72135 | 11745 | |
2282887 | 2282887 | 2022-03-07 | Mower | Minnesota | 27099 | 11745 | 69 |
2231386 | 2231386 | 2022-02-19 | Washington | New York | 36115 | 11745 | 111 |
2059614 | 2059614 | 2021-12-28 | Lincoln | South Dakota | 46083 | 11745 | 79 |
2005560 | 2005560 | 2021-12-12 | Gordon | Georgia | 13129 | 11745 | 206 |
2002309 | 2002309 | 2021-12-11 | Gordon | Georgia | 13129 | 11745 | 206 |
1999059 | 1999059 | 2021-12-10 | Gordon | Georgia | 13129 | 11745 | 206 |
1900986 | 1900986 | 2021-11-09 | Raleigh | West Virginia | 54081 | 11745 | 183 |
1880794 | 1880794 | 2021-11-03 | Laurens | South Carolina | 45059 | 11745 | 226 |
1852296 | 1852296 | 2021-10-25 | Manitowoc | Wisconsin | 55071 | 11745 | 106 |
1809312 | 1809312 | 2021-10-12 | Kershaw | South Carolina | 45055 | 11745 | 196 |
1785723 | 1785723 | 2021-10-05 | St. Francois | Missouri | 29187 | 11745 | 158 |
1697742 | 1697742 | 2021-09-08 | Carver | Minnesota | 27019 | 11745 | 51 |
1589194 | 1589194 | 2021-08-05 | Laramie | Wyoming | 56021 | 11745 | 134 |
1506734 | 1506734 | 2021-07-11 | Nash | North Carolina | 37127 | 11745 | 199 |
1503488 | 1503488 | 2021-07-10 | Nash | North Carolina | 37127 | 11745 | 199 |
1500242 | 1500242 | 2021-07-09 | Nash | North Carolina | 37127 | 11745 | 199 |
1272677 | 1272677 | 2021-04-30 | Flathead | Montana | 30029 | 11745 | 93 |
1036346 | 1036346 | 2021-02-16 | Schuylkill | Pennsylvania | 42107 | 11745 | 356 |
1003019 | 1003019 | 2021-02-06 | Jackson | Mississippi | 28059 | 11745 | 206 |
945137 | 945137 | 2021-01-19 | Rowan | North Carolina | 37159 | 11745 | 217 |
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);