ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 14787 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2195981 | 2195981 | 2022-02-08 | Armstrong | Pennsylvania | 42005 | 14787 | 312 |
2145429 | 2145429 | 2022-01-24 | Spalding | Georgia | 13255 | 14787 | 353 |
1764455 | 1764455 | 2021-09-28 | Kitsap | Washington | 53035 | 14787 | 184 |
1445412 | 1445412 | 2021-06-22 | Schuylkill | Pennsylvania | 42107 | 14787 | 412 |
1429173 | 1429173 | 2021-06-17 | Monroe | Pennsylvania | 42089 | 14787 | 321 |
1374309 | 1374309 | 2021-05-31 | Washington | Tennessee | 47179 | 14787 | 249 |
1371064 | 1371064 | 2021-05-30 | Washington | Tennessee | 47179 | 14787 | 249 |
1367818 | 1367818 | 2021-05-29 | Washington | Tennessee | 47179 | 14787 | 249 |
1364572 | 1364572 | 2021-05-28 | Washington | Tennessee | 47179 | 14787 | 249 |
1339694 | 1339694 | 2021-05-21 | Houston | Georgia | 13153 | 14787 | 262 |
1265121 | 1265121 | 2021-04-28 | Bonneville | Idaho | 16019 | 14787 | 169 |
1221206 | 1221206 | 2021-04-14 | Medina | Ohio | 39103 | 14787 | 259 |
1210243 | 1210243 | 2021-04-11 | Woodbury | Iowa | 19193 | 14787 | 219 |
1102856 | 1102856 | 2021-03-09 | McLean | Illinois | 17113 | 14787 | 196 |
1024589 | 1024589 | 2021-02-13 | Pueblo | Colorado | 8101 | 14787 | 361 |
869296 | 869296 | 2020-12-27 | Vanderburgh | Indiana | 18163 | 14787 | 191 |
503278 | 503278 | 2020-09-05 | Baltimore city | Maryland | 24510 | 14787 | 469 |
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);