ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 10 and county = "Powell" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
561968 | 561968 | 2020-09-23 | Powell | Montana | 30077 | 10 | 0 |
558731 | 558731 | 2020-09-22 | Powell | Montana | 30077 | 10 | 0 |
555494 | 555494 | 2020-09-21 | Powell | Montana | 30077 | 10 | 0 |
552256 | 552256 | 2020-09-20 | Powell | Montana | 30077 | 10 | 0 |
549017 | 549017 | 2020-09-19 | Powell | Montana | 30077 | 10 | 0 |
545779 | 545779 | 2020-09-18 | Powell | Montana | 30077 | 10 | 0 |
542542 | 542542 | 2020-09-17 | Powell | Montana | 30077 | 10 | 0 |
539306 | 539306 | 2020-09-16 | Powell | Montana | 30077 | 10 | 0 |
536069 | 536069 | 2020-09-15 | Powell | Montana | 30077 | 10 | 0 |
532834 | 532834 | 2020-09-14 | Powell | Montana | 30077 | 10 | 0 |
529598 | 529598 | 2020-09-13 | Powell | Montana | 30077 | 10 | 0 |
526362 | 526362 | 2020-09-12 | Powell | Montana | 30077 | 10 | 0 |
523126 | 523126 | 2020-09-11 | Powell | Montana | 30077 | 10 | 0 |
519889 | 519889 | 2020-09-10 | Powell | Montana | 30077 | 10 | 0 |
516654 | 516654 | 2020-09-09 | Powell | Montana | 30077 | 10 | 0 |
513420 | 513420 | 2020-09-08 | Powell | Montana | 30077 | 10 | 0 |
510188 | 510188 | 2020-09-07 | Powell | Montana | 30077 | 10 | 0 |
506955 | 506955 | 2020-09-06 | Powell | Montana | 30077 | 10 | 0 |
503722 | 503722 | 2020-09-05 | Powell | Montana | 30077 | 10 | 0 |
500488 | 500488 | 2020-09-04 | Powell | Montana | 30077 | 10 | 0 |
497254 | 497254 | 2020-09-03 | Powell | Montana | 30077 | 10 | 0 |
494021 | 494021 | 2020-09-02 | Powell | Montana | 30077 | 10 | 0 |
490787 | 490787 | 2020-09-01 | Powell | Montana | 30077 | 10 | 0 |
487554 | 487554 | 2020-08-31 | Powell | Montana | 30077 | 10 | 0 |
484320 | 484320 | 2020-08-30 | Powell | Montana | 30077 | 10 | 0 |
481085 | 481085 | 2020-08-29 | Powell | Montana | 30077 | 10 | 0 |
477853 | 477853 | 2020-08-28 | Powell | Montana | 30077 | 10 | 0 |
474620 | 474620 | 2020-08-27 | Powell | Montana | 30077 | 10 | 0 |
471388 | 471388 | 2020-08-26 | Powell | Montana | 30077 | 10 | 0 |
468158 | 468158 | 2020-08-25 | Powell | Montana | 30077 | 10 | 0 |
329345 | 329345 | 2020-07-13 | Powell | Kentucky | 21197 | 10 | 0 |
326159 | 326159 | 2020-07-12 | Powell | Kentucky | 21197 | 10 | 0 |
322976 | 322976 | 2020-07-11 | Powell | Kentucky | 21197 | 10 | 0 |
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);