ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where county = "Ravalli" and deaths = 2 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 |
---|---|---|---|---|---|---|---|
630047 | 630047 | 2020-10-14 | Ravalli | Montana | 30081 | 262 | 2 |
626803 | 626803 | 2020-10-13 | Ravalli | Montana | 30081 | 235 | 2 |
623561 | 623561 | 2020-10-12 | Ravalli | Montana | 30081 | 235 | 2 |
620318 | 620318 | 2020-10-11 | Ravalli | Montana | 30081 | 228 | 2 |
617076 | 617076 | 2020-10-10 | Ravalli | Montana | 30081 | 228 | 2 |
613835 | 613835 | 2020-10-09 | Ravalli | Montana | 30081 | 210 | 2 |
610593 | 610593 | 2020-10-08 | Ravalli | Montana | 30081 | 195 | 2 |
607351 | 607351 | 2020-10-07 | Ravalli | Montana | 30081 | 180 | 2 |
604108 | 604108 | 2020-10-06 | Ravalli | Montana | 30081 | 180 | 2 |
600866 | 600866 | 2020-10-05 | Ravalli | Montana | 30081 | 175 | 2 |
597622 | 597622 | 2020-10-04 | Ravalli | Montana | 30081 | 174 | 2 |
594381 | 594381 | 2020-10-03 | Ravalli | Montana | 30081 | 164 | 2 |
591140 | 591140 | 2020-10-02 | Ravalli | Montana | 30081 | 161 | 2 |
587899 | 587899 | 2020-10-01 | Ravalli | Montana | 30081 | 158 | 2 |
584659 | 584659 | 2020-09-30 | Ravalli | Montana | 30081 | 154 | 2 |
581418 | 581418 | 2020-09-29 | Ravalli | Montana | 30081 | 149 | 2 |
578177 | 578177 | 2020-09-28 | Ravalli | Montana | 30081 | 141 | 2 |
574936 | 574936 | 2020-09-27 | Ravalli | Montana | 30081 | 140 | 2 |
571693 | 571693 | 2020-09-26 | Ravalli | Montana | 30081 | 140 | 2 |
568451 | 568451 | 2020-09-25 | Ravalli | Montana | 30081 | 135 | 2 |
565211 | 565211 | 2020-09-24 | Ravalli | Montana | 30081 | 132 | 2 |
561970 | 561970 | 2020-09-23 | Ravalli | Montana | 30081 | 129 | 2 |
558733 | 558733 | 2020-09-22 | Ravalli | Montana | 30081 | 129 | 2 |
555496 | 555496 | 2020-09-21 | Ravalli | Montana | 30081 | 126 | 2 |
552258 | 552258 | 2020-09-20 | Ravalli | Montana | 30081 | 126 | 2 |
549019 | 549019 | 2020-09-19 | Ravalli | Montana | 30081 | 126 | 2 |
545781 | 545781 | 2020-09-18 | Ravalli | Montana | 30081 | 122 | 2 |
542544 | 542544 | 2020-09-17 | Ravalli | Montana | 30081 | 120 | 2 |
539308 | 539308 | 2020-09-16 | Ravalli | Montana | 30081 | 119 | 2 |
536071 | 536071 | 2020-09-15 | Ravalli | Montana | 30081 | 117 | 2 |
532836 | 532836 | 2020-09-14 | Ravalli | Montana | 30081 | 116 | 2 |
529600 | 529600 | 2020-09-13 | Ravalli | Montana | 30081 | 115 | 2 |
526364 | 526364 | 2020-09-12 | Ravalli | Montana | 30081 | 115 | 2 |
523128 | 523128 | 2020-09-11 | Ravalli | Montana | 30081 | 115 | 2 |
519891 | 519891 | 2020-09-10 | Ravalli | Montana | 30081 | 113 | 2 |
516656 | 516656 | 2020-09-09 | Ravalli | Montana | 30081 | 113 | 2 |
513422 | 513422 | 2020-09-08 | Ravalli | Montana | 30081 | 113 | 2 |
510190 | 510190 | 2020-09-07 | Ravalli | Montana | 30081 | 113 | 2 |
506957 | 506957 | 2020-09-06 | Ravalli | Montana | 30081 | 113 | 2 |
503724 | 503724 | 2020-09-05 | Ravalli | Montana | 30081 | 113 | 2 |
500490 | 500490 | 2020-09-04 | Ravalli | Montana | 30081 | 113 | 2 |
497256 | 497256 | 2020-09-03 | Ravalli | Montana | 30081 | 112 | 2 |
494023 | 494023 | 2020-09-02 | Ravalli | Montana | 30081 | 110 | 2 |
490789 | 490789 | 2020-09-01 | Ravalli | Montana | 30081 | 110 | 2 |
487556 | 487556 | 2020-08-31 | Ravalli | Montana | 30081 | 107 | 2 |
484322 | 484322 | 2020-08-30 | Ravalli | Montana | 30081 | 107 | 2 |
481087 | 481087 | 2020-08-29 | Ravalli | Montana | 30081 | 107 | 2 |
477855 | 477855 | 2020-08-28 | Ravalli | Montana | 30081 | 104 | 2 |
474622 | 474622 | 2020-08-27 | Ravalli | Montana | 30081 | 99 | 2 |
471390 | 471390 | 2020-08-26 | Ravalli | Montana | 30081 | 99 | 2 |
468160 | 468160 | 2020-08-25 | Ravalli | Montana | 30081 | 98 | 2 |
464931 | 464931 | 2020-08-24 | Ravalli | Montana | 30081 | 94 | 2 |
461700 | 461700 | 2020-08-23 | Ravalli | Montana | 30081 | 92 | 2 |
458473 | 458473 | 2020-08-22 | Ravalli | Montana | 30081 | 92 | 2 |
455245 | 455245 | 2020-08-21 | Ravalli | Montana | 30081 | 90 | 2 |
452017 | 452017 | 2020-08-20 | Ravalli | Montana | 30081 | 90 | 2 |
448789 | 448789 | 2020-08-19 | Ravalli | Montana | 30081 | 89 | 2 |
445563 | 445563 | 2020-08-18 | Ravalli | Montana | 30081 | 88 | 2 |
442337 | 442337 | 2020-08-17 | Ravalli | Montana | 30081 | 85 | 2 |
439110 | 439110 | 2020-08-16 | Ravalli | Montana | 30081 | 85 | 2 |
435885 | 435885 | 2020-08-15 | Ravalli | Montana | 30081 | 85 | 2 |
432659 | 432659 | 2020-08-14 | Ravalli | Montana | 30081 | 85 | 2 |
429432 | 429432 | 2020-08-13 | Ravalli | Montana | 30081 | 84 | 2 |
426208 | 426208 | 2020-08-12 | Ravalli | Montana | 30081 | 83 | 2 |
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);