ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 11890 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Arizona 8
- Indiana 5
- South Carolina 5
- Alabama 3
- Georgia 2
- Pennsylvania 2
- Virginia 2
- Kentucky 1
- Mississippi 1
- New Mexico 1
- New York 1
- Ohio 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2284861 | 2284861 | 2022-03-08 | Graham | Arizona | 4009 | 11890 | 171 |
2281609 | 2281609 | 2022-03-07 | Graham | Arizona | 4009 | 11890 | 171 |
2283411 | 2283411 | 2022-03-07 | Washington | New York | 36115 | 11890 | 113 |
2278356 | 2278356 | 2022-03-06 | Graham | Arizona | 4009 | 11890 | 171 |
2275103 | 2275103 | 2022-03-05 | Graham | Arizona | 4009 | 11890 | 171 |
2271850 | 2271850 | 2022-03-04 | Graham | Arizona | 4009 | 11890 | 171 |
2268598 | 2268598 | 2022-03-03 | Graham | Arizona | 4009 | 11890 | 171 |
2265345 | 2265345 | 2022-03-02 | Graham | Arizona | 4009 | 11890 | 171 |
2103652 | 2103652 | 2022-01-11 | Christian | Kentucky | 21047 | 11890 | 176 |
2069129 | 2069129 | 2021-12-31 | Armstrong | Pennsylvania | 42005 | 11890 | 275 |
2069139 | 2069139 | 2021-12-31 | Carbon | Pennsylvania | 42025 | 11890 | 232 |
2012120 | 2012120 | 2021-12-14 | Rockdale | Georgia | 13247 | 11890 | 251 |
1960331 | 1960331 | 2021-11-28 | Grant | Indiana | 18053 | 11890 | 241 |
1957080 | 1957080 | 2021-11-27 | Grant | Indiana | 18053 | 11890 | 241 |
1953829 | 1953829 | 2021-11-26 | Grant | Indiana | 18053 | 11890 | 241 |
1950578 | 1950578 | 2021-11-25 | Grant | Indiana | 18053 | 11890 | 241 |
1947327 | 1947327 | 2021-11-24 | Grant | Indiana | 18053 | 11890 | 241 |
1930094 | 1930094 | 2021-11-18 | Lynchburg city | Virginia | 51680 | 11890 | 193 |
1923906 | 1923906 | 2021-11-17 | Walker | Alabama | 1127 | 11890 | 377 |
1923040 | 1923040 | 2021-11-16 | Laurens | South Carolina | 45059 | 11890 | 231 |
1917234 | 1917234 | 2021-11-14 | Raleigh | West Virginia | 54081 | 11890 | 186 |
1848289 | 1848289 | 2021-10-24 | Darlington | South Carolina | 45031 | 11890 | 227 |
1845039 | 1845039 | 2021-10-23 | Darlington | South Carolina | 45031 | 11890 | 227 |
1841789 | 1841789 | 2021-10-22 | Darlington | South Carolina | 45031 | 11890 | 227 |
1728912 | 1728912 | 2021-09-18 | DeKalb | Alabama | 1049 | 11890 | 229 |
1672254 | 1672254 | 2021-08-31 | Santa Fe | New Mexico | 35049 | 11890 | 156 |
1605547 | 1605547 | 2021-08-11 | Apache | Arizona | 4001 | 11890 | 441 |
1481723 | 1481723 | 2021-07-03 | Alexandria city | Virginia | 51510 | 11890 | 140 |
1232532 | 1232532 | 2021-04-18 | Floyd | Georgia | 13115 | 11890 | 216 |
1189906 | 1189906 | 2021-04-05 | Marshall | Alabama | 1095 | 11890 | 218 |
996559 | 996559 | 2021-02-04 | Rankin | Mississippi | 28121 | 11890 | 242 |
913154 | 913154 | 2021-01-09 | Pickens | South Carolina | 45077 | 11890 | 173 |
750569 | 750569 | 2020-11-20 | Summit | Ohio | 39153 | 11890 | 307 |
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);