ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 12216 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- New Mexico 4
- Indiana 2
- New York 2
- North Carolina 2
- Ohio 2
- Arizona 1
- Arkansas 1
- Illinois 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- Puerto Rico 1
- South Carolina 1
- Virginia 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419314 | 2419314 | 2022-04-18 | Lincoln | Louisiana | 22061 | 12216 | 144 |
2270839 | 2270839 | 2022-03-03 | Arecibo | Puerto Rico | 72013 | 12216 | |
2244353 | 2244353 | 2022-02-23 | Fulton | New York | 36035 | 12216 | 165 |
2208808 | 2208808 | 2022-02-12 | Darke | Ohio | 39037 | 12216 | 215 |
1946486 | 1946486 | 2021-11-23 | Raleigh | West Virginia | 54081 | 12216 | 191 |
1880460 | 1880460 | 2021-11-03 | Marion | Ohio | 39101 | 12216 | 184 |
1657156 | 1657156 | 2021-08-26 | Hampton city | Virginia | 51650 | 12216 | 186 |
1644527 | 1644527 | 2021-08-23 | Apache | Arizona | 4001 | 12216 | 445 |
1580854 | 1580854 | 2021-08-03 | Sherburne | Minnesota | 27141 | 12216 | 96 |
1519701 | 1519701 | 2021-07-15 | Harnett | North Carolina | 37085 | 12216 | 182 |
1438443 | 1438443 | 2021-06-20 | Sandoval | New Mexico | 35043 | 12216 | 241 |
1435196 | 1435196 | 2021-06-19 | Sandoval | New Mexico | 35043 | 12216 | 241 |
1431949 | 1431949 | 2021-06-18 | Sandoval | New Mexico | 35043 | 12216 | 241 |
1259892 | 1259892 | 2021-04-26 | McKinley | New Mexico | 35031 | 12216 | 462 |
1229623 | 1229623 | 2021-04-17 | Vigo | Indiana | 18167 | 12216 | 249 |
1200356 | 1200356 | 2021-04-08 | Madison | Indiana | 18095 | 12216 | 354 |
1180250 | 1180250 | 2021-04-02 | Faulkner | Arkansas | 5045 | 12216 | 157 |
1044981 | 1044981 | 2021-02-19 | Harford | Maryland | 24025 | 12216 | 231 |
1034677 | 1034677 | 2021-02-16 | Kankakee | Illinois | 17091 | 12216 | 194 |
928832 | 928832 | 2021-01-14 | Alamance | North Carolina | 37001 | 12216 | 169 |
913136 | 913136 | 2021-01-09 | Florence | South Carolina | 45041 | 12216 | 290 |
630252 | 630252 | 2020-10-14 | Erie | New York | 36029 | 12216 | 639 |
569890 | 569890 | 2020-09-25 | Yakima | Washington | 53077 | 12216 | 271 |
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);