ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 12484 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Texas 8
- Indiana 4
- Massachusetts 3
- New York 3
- Florida 2
- Georgia 2
- Washington 2
- Wisconsin 2
- Alabama 1
- Illinois 1
- Maine 1
- North Carolina 1
- Pennsylvania 1
- Puerto Rico 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446614 | 2446614 | 2022-04-26 | Toa Alta | Puerto Rico | 72135 | 12484 | |
2420931 | 2420931 | 2022-04-18 | Lamar | Texas | 48277 | 12484 | 255 |
2417675 | 2417675 | 2022-04-17 | Lamar | Texas | 48277 | 12484 | 256 |
2414419 | 2414419 | 2022-04-16 | Lamar | Texas | 48277 | 12484 | 256 |
2411163 | 2411163 | 2022-04-15 | Lamar | Texas | 48277 | 12484 | 256 |
2407907 | 2407907 | 2022-04-14 | Lamar | Texas | 48277 | 12484 | 256 |
2404651 | 2404651 | 2022-04-13 | Lamar | Texas | 48277 | 12484 | 256 |
2401396 | 2401396 | 2022-04-12 | Lamar | Texas | 48277 | 12484 | 256 |
2398141 | 2398141 | 2022-04-11 | Lamar | Texas | 48277 | 12484 | 256 |
2335416 | 2335416 | 2022-03-23 | Fulton | New York | 36035 | 12484 | 166 |
2291914 | 2291914 | 2022-03-10 | Knox | Illinois | 17095 | 12484 | 240 |
2260726 | 2260726 | 2022-02-28 | Richmond | North Carolina | 37153 | 12484 | 184 |
2053925 | 2053925 | 2021-12-27 | Walker | Alabama | 1127 | 12484 | 388 |
2041375 | 2041375 | 2021-12-23 | Rockdale | Georgia | 13247 | 12484 | 262 |
1967997 | 1967997 | 2021-11-30 | Steuben | New York | 36101 | 12484 | 190 |
1960836 | 1960836 | 2021-11-28 | Hampshire | Massachusetts | 25015 | 12484 | 324 |
1957585 | 1957585 | 2021-11-27 | Hampshire | Massachusetts | 25015 | 12484 | 324 |
1954334 | 1954334 | 2021-11-26 | Hampshire | Massachusetts | 25015 | 12484 | 324 |
1790439 | 1790439 | 2021-10-06 | Cowlitz | Washington | 53015 | 12484 | 205 |
1505516 | 1505516 | 2021-07-11 | LaPorte | Indiana | 18091 | 12484 | 225 |
1502270 | 1502270 | 2021-07-10 | LaPorte | Indiana | 18091 | 12484 | 225 |
1499024 | 1499024 | 2021-07-09 | LaPorte | Indiana | 18091 | 12484 | 225 |
1495777 | 1495777 | 2021-07-08 | LaPorte | Indiana | 18091 | 12484 | 225 |
1248650 | 1248650 | 2021-04-23 | Charlotte | Florida | 12015 | 12484 | 409 |
1180465 | 1180465 | 2021-04-02 | Hernando | Florida | 12053 | 12484 | 443 |
1143466 | 1143466 | 2021-03-21 | Schuylkill | Pennsylvania | 42107 | 12484 | 378 |
1070921 | 1070921 | 2021-02-27 | Cumberland | Maine | 23005 | 12484 | 180 |
1011751 | 1011751 | 2021-02-09 | Douglas | Georgia | 13097 | 12484 | 159 |
985269 | 985269 | 2021-01-31 | Fond du Lac | Wisconsin | 55039 | 12484 | 93 |
982022 | 982022 | 2021-01-30 | Fond du Lac | Wisconsin | 55039 | 12484 | 93 |
612032 | 612032 | 2020-10-08 | Yakima | Washington | 53077 | 12484 | 276 |
579545 | 579545 | 2020-09-28 | Prince William | Virginia | 51153 | 12484 | 203 |
134961 | 134961 | 2020-05-11 | Rockland | New York | 36087 | 12484 | 421 |
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);