ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 1 and fips = 30085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
565213 | 565213 | 2020-09-24 | Roosevelt | Montana | 30085 | 269 | 1 |
561972 | 561972 | 2020-09-23 | Roosevelt | Montana | 30085 | 213 | 1 |
558735 | 558735 | 2020-09-22 | Roosevelt | Montana | 30085 | 199 | 1 |
555498 | 555498 | 2020-09-21 | Roosevelt | Montana | 30085 | 168 | 1 |
552260 | 552260 | 2020-09-20 | Roosevelt | Montana | 30085 | 151 | 1 |
549021 | 549021 | 2020-09-19 | Roosevelt | Montana | 30085 | 147 | 1 |
545783 | 545783 | 2020-09-18 | Roosevelt | Montana | 30085 | 126 | 1 |
542546 | 542546 | 2020-09-17 | Roosevelt | Montana | 30085 | 101 | 1 |
539310 | 539310 | 2020-09-16 | Roosevelt | Montana | 30085 | 87 | 1 |
536073 | 536073 | 2020-09-15 | Roosevelt | Montana | 30085 | 87 | 1 |
532838 | 532838 | 2020-09-14 | Roosevelt | Montana | 30085 | 86 | 1 |
529602 | 529602 | 2020-09-13 | Roosevelt | Montana | 30085 | 86 | 1 |
526366 | 526366 | 2020-09-12 | Roosevelt | Montana | 30085 | 74 | 1 |
523130 | 523130 | 2020-09-11 | Roosevelt | Montana | 30085 | 66 | 1 |
519893 | 519893 | 2020-09-10 | Roosevelt | Montana | 30085 | 63 | 1 |
516658 | 516658 | 2020-09-09 | Roosevelt | Montana | 30085 | 63 | 1 |
513424 | 513424 | 2020-09-08 | Roosevelt | Montana | 30085 | 62 | 1 |
510192 | 510192 | 2020-09-07 | Roosevelt | Montana | 30085 | 62 | 1 |
506959 | 506959 | 2020-09-06 | Roosevelt | Montana | 30085 | 62 | 1 |
503726 | 503726 | 2020-09-05 | Roosevelt | Montana | 30085 | 61 | 1 |
500492 | 500492 | 2020-09-04 | Roosevelt | Montana | 30085 | 51 | 1 |
497258 | 497258 | 2020-09-03 | Roosevelt | Montana | 30085 | 48 | 1 |
494025 | 494025 | 2020-09-02 | Roosevelt | Montana | 30085 | 44 | 1 |
490791 | 490791 | 2020-09-01 | Roosevelt | Montana | 30085 | 43 | 1 |
487558 | 487558 | 2020-08-31 | Roosevelt | Montana | 30085 | 42 | 1 |
484324 | 484324 | 2020-08-30 | Roosevelt | Montana | 30085 | 34 | 1 |
481089 | 481089 | 2020-08-29 | Roosevelt | Montana | 30085 | 34 | 1 |
477857 | 477857 | 2020-08-28 | Roosevelt | Montana | 30085 | 34 | 1 |
474624 | 474624 | 2020-08-27 | Roosevelt | Montana | 30085 | 34 | 1 |
471392 | 471392 | 2020-08-26 | Roosevelt | Montana | 30085 | 34 | 1 |
468162 | 468162 | 2020-08-25 | Roosevelt | Montana | 30085 | 35 | 1 |
464933 | 464933 | 2020-08-24 | Roosevelt | Montana | 30085 | 34 | 1 |
461702 | 461702 | 2020-08-23 | Roosevelt | Montana | 30085 | 34 | 1 |
458475 | 458475 | 2020-08-22 | Roosevelt | Montana | 30085 | 34 | 1 |
455247 | 455247 | 2020-08-21 | Roosevelt | Montana | 30085 | 31 | 1 |
452019 | 452019 | 2020-08-20 | Roosevelt | Montana | 30085 | 31 | 1 |
448791 | 448791 | 2020-08-19 | Roosevelt | Montana | 30085 | 30 | 1 |
445565 | 445565 | 2020-08-18 | Roosevelt | Montana | 30085 | 30 | 1 |
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);