ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 15070 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Maryland 24
- Massachusetts 3
- New Mexico 3
- Alabama 2
- Louisiana 2
- Washington 2
- Indiana 1
- Missouri 1
- Pennsylvania 1
- Texas 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394405 | 2394405 | 2022-04-10 | Columbia | Pennsylvania | 42037 | 15070 | 243 |
2055074 | 2055074 | 2021-12-27 | Charles | Maryland | 24017 | 15070 | 268 |
2051824 | 2051824 | 2021-12-26 | Charles | Maryland | 24017 | 15070 | 268 |
2048574 | 2048574 | 2021-12-25 | Charles | Maryland | 24017 | 15070 | 268 |
2045324 | 2045324 | 2021-12-24 | Charles | Maryland | 24017 | 15070 | 268 |
2042074 | 2042074 | 2021-12-23 | Charles | Maryland | 24017 | 15070 | 268 |
2038825 | 2038825 | 2021-12-22 | Charles | Maryland | 24017 | 15070 | 268 |
2035575 | 2035575 | 2021-12-21 | Charles | Maryland | 24017 | 15070 | 268 |
2032325 | 2032325 | 2021-12-20 | Charles | Maryland | 24017 | 15070 | 268 |
2034243 | 2034243 | 2021-12-20 | Monongalia | West Virginia | 54061 | 15070 | 154 |
2029074 | 2029074 | 2021-12-19 | Charles | Maryland | 24017 | 15070 | 268 |
2025823 | 2025823 | 2021-12-18 | Charles | Maryland | 24017 | 15070 | 268 |
2022572 | 2022572 | 2021-12-17 | Charles | Maryland | 24017 | 15070 | 268 |
2019321 | 2019321 | 2021-12-16 | Charles | Maryland | 24017 | 15070 | 268 |
2016071 | 2016071 | 2021-12-15 | Charles | Maryland | 24017 | 15070 | 268 |
2012820 | 2012820 | 2021-12-14 | Charles | Maryland | 24017 | 15070 | 268 |
2009569 | 2009569 | 2021-12-13 | Charles | Maryland | 24017 | 15070 | 268 |
2006318 | 2006318 | 2021-12-12 | Charles | Maryland | 24017 | 15070 | 268 |
2003067 | 2003067 | 2021-12-11 | Charles | Maryland | 24017 | 15070 | 268 |
1999817 | 1999817 | 2021-12-10 | Charles | Maryland | 24017 | 15070 | 268 |
1996566 | 1996566 | 2021-12-09 | Charles | Maryland | 24017 | 15070 | 268 |
1993315 | 1993315 | 2021-12-08 | Charles | Maryland | 24017 | 15070 | 268 |
1990064 | 1990064 | 2021-12-07 | Charles | Maryland | 24017 | 15070 | 268 |
1986814 | 1986814 | 2021-12-06 | Charles | Maryland | 24017 | 15070 | 268 |
1983564 | 1983564 | 2021-12-05 | Charles | Maryland | 24017 | 15070 | 268 |
1980314 | 1980314 | 2021-12-04 | Charles | Maryland | 24017 | 15070 | 268 |
1735446 | 1735446 | 2021-09-20 | St. Clair | Alabama | 1115 | 15070 | 276 |
1642410 | 1642410 | 2021-08-22 | Barnstable | Massachusetts | 25001 | 15070 | 485 |
1639160 | 1639160 | 2021-08-21 | Barnstable | Massachusetts | 25001 | 15070 | 485 |
1635910 | 1635910 | 2021-08-20 | Barnstable | Massachusetts | 25001 | 15070 | 485 |
1324830 | 1324830 | 2021-05-16 | San Juan | New Mexico | 35045 | 15070 | 473 |
1321584 | 1321584 | 2021-05-15 | San Juan | New Mexico | 35045 | 15070 | 473 |
1318338 | 1318338 | 2021-05-14 | San Juan | New Mexico | 35045 | 15070 | 473 |
1092493 | 1092493 | 2021-03-06 | Lee | Alabama | 1081 | 15070 | 161 |
1089148 | 1089148 | 2021-03-04 | Marathon | Wisconsin | 55073 | 15070 | 214 |
903608 | 903608 | 2021-01-06 | Brazos | Texas | 48041 | 15070 | 141 |
875786 | 875786 | 2020-12-29 | Vanderburgh | Indiana | 18163 | 15070 | 194 |
827922 | 827922 | 2020-12-14 | St. Louis city | Missouri | 29510 | 15070 | 271 |
820958 | 820958 | 2020-12-12 | Caddo | Louisiana | 22017 | 15070 | 471 |
817712 | 817712 | 2020-12-11 | Caddo | Louisiana | 22017 | 15070 | 471 |
780739 | 780739 | 2020-11-29 | Yakima | Washington | 53077 | 15070 | 308 |
777493 | 777493 | 2020-11-28 | Yakima | Washington | 53077 | 15070 | 308 |
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);