ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
658 rows where fips = 30019 and state = "Montana" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
368265 | 368265 | 2020-07-25 | Daniels | Montana | 30019 | 1 | 0 |
371476 | 371476 | 2020-07-26 | Daniels | Montana | 30019 | 1 | 0 |
374688 | 374688 | 2020-07-27 | Daniels | Montana | 30019 | 1 | 0 |
377903 | 377903 | 2020-07-28 | Daniels | Montana | 30019 | 1 | 0 |
381120 | 381120 | 2020-07-29 | Daniels | Montana | 30019 | 2 | 0 |
384336 | 384336 | 2020-07-30 | Daniels | Montana | 30019 | 2 | 0 |
387554 | 387554 | 2020-07-31 | Daniels | Montana | 30019 | 2 | 0 |
390771 | 390771 | 2020-08-01 | Daniels | Montana | 30019 | 2 | 0 |
393988 | 393988 | 2020-08-02 | Daniels | Montana | 30019 | 2 | 0 |
397204 | 397204 | 2020-08-03 | Daniels | Montana | 30019 | 2 | 0 |
400418 | 400418 | 2020-08-04 | Daniels | Montana | 30019 | 3 | 0 |
403635 | 403635 | 2020-08-05 | Daniels | Montana | 30019 | 3 | 0 |
406853 | 406853 | 2020-08-06 | Daniels | Montana | 30019 | 3 | 0 |
410073 | 410073 | 2020-08-07 | Daniels | Montana | 30019 | 3 | 0 |
413293 | 413293 | 2020-08-08 | Daniels | Montana | 30019 | 3 | 0 |
416513 | 416513 | 2020-08-09 | Daniels | Montana | 30019 | 3 | 0 |
419734 | 419734 | 2020-08-10 | Daniels | Montana | 30019 | 3 | 0 |
422956 | 422956 | 2020-08-11 | Daniels | Montana | 30019 | 3 | 0 |
426178 | 426178 | 2020-08-12 | Daniels | Montana | 30019 | 3 | 0 |
429402 | 429402 | 2020-08-13 | Daniels | Montana | 30019 | 3 | 0 |
432629 | 432629 | 2020-08-14 | Daniels | Montana | 30019 | 3 | 0 |
435855 | 435855 | 2020-08-15 | Daniels | Montana | 30019 | 3 | 0 |
439080 | 439080 | 2020-08-16 | Daniels | Montana | 30019 | 3 | 0 |
442307 | 442307 | 2020-08-17 | Daniels | Montana | 30019 | 3 | 0 |
445533 | 445533 | 2020-08-18 | Daniels | Montana | 30019 | 3 | 0 |
448759 | 448759 | 2020-08-19 | Daniels | Montana | 30019 | 3 | 0 |
451987 | 451987 | 2020-08-20 | Daniels | Montana | 30019 | 3 | 0 |
455215 | 455215 | 2020-08-21 | Daniels | Montana | 30019 | 3 | 0 |
458443 | 458443 | 2020-08-22 | Daniels | Montana | 30019 | 3 | 0 |
461670 | 461670 | 2020-08-23 | Daniels | Montana | 30019 | 3 | 0 |
464901 | 464901 | 2020-08-24 | Daniels | Montana | 30019 | 3 | 0 |
468130 | 468130 | 2020-08-25 | Daniels | Montana | 30019 | 3 | 0 |
471360 | 471360 | 2020-08-26 | Daniels | Montana | 30019 | 3 | 0 |
474592 | 474592 | 2020-08-27 | Daniels | Montana | 30019 | 3 | 0 |
477825 | 477825 | 2020-08-28 | Daniels | Montana | 30019 | 3 | 0 |
481057 | 481057 | 2020-08-29 | Daniels | Montana | 30019 | 3 | 0 |
484292 | 484292 | 2020-08-30 | Daniels | Montana | 30019 | 3 | 0 |
487526 | 487526 | 2020-08-31 | Daniels | Montana | 30019 | 3 | 0 |
490759 | 490759 | 2020-09-01 | Daniels | Montana | 30019 | 3 | 0 |
493993 | 493993 | 2020-09-02 | Daniels | Montana | 30019 | 3 | 0 |
497226 | 497226 | 2020-09-03 | Daniels | Montana | 30019 | 3 | 0 |
500460 | 500460 | 2020-09-04 | Daniels | Montana | 30019 | 3 | 0 |
503694 | 503694 | 2020-09-05 | Daniels | Montana | 30019 | 3 | 0 |
506927 | 506927 | 2020-09-06 | Daniels | Montana | 30019 | 3 | 0 |
510160 | 510160 | 2020-09-07 | Daniels | Montana | 30019 | 3 | 0 |
513392 | 513392 | 2020-09-08 | Daniels | Montana | 30019 | 3 | 0 |
516626 | 516626 | 2020-09-09 | Daniels | Montana | 30019 | 3 | 0 |
519861 | 519861 | 2020-09-10 | Daniels | Montana | 30019 | 3 | 0 |
523098 | 523098 | 2020-09-11 | Daniels | Montana | 30019 | 3 | 0 |
526334 | 526334 | 2020-09-12 | Daniels | Montana | 30019 | 3 | 0 |
529570 | 529570 | 2020-09-13 | Daniels | Montana | 30019 | 3 | 0 |
532806 | 532806 | 2020-09-14 | Daniels | Montana | 30019 | 3 | 0 |
536041 | 536041 | 2020-09-15 | Daniels | Montana | 30019 | 3 | 0 |
539278 | 539278 | 2020-09-16 | Daniels | Montana | 30019 | 3 | 0 |
542514 | 542514 | 2020-09-17 | Daniels | Montana | 30019 | 3 | 0 |
545751 | 545751 | 2020-09-18 | Daniels | Montana | 30019 | 3 | 0 |
548989 | 548989 | 2020-09-19 | Daniels | Montana | 30019 | 3 | 0 |
552228 | 552228 | 2020-09-20 | Daniels | Montana | 30019 | 3 | 0 |
555466 | 555466 | 2020-09-21 | Daniels | Montana | 30019 | 4 | 0 |
558703 | 558703 | 2020-09-22 | Daniels | Montana | 30019 | 4 | 0 |
561940 | 561940 | 2020-09-23 | Daniels | Montana | 30019 | 5 | 0 |
565181 | 565181 | 2020-09-24 | Daniels | Montana | 30019 | 5 | 0 |
568421 | 568421 | 2020-09-25 | Daniels | Montana | 30019 | 5 | 0 |
571663 | 571663 | 2020-09-26 | Daniels | Montana | 30019 | 5 | 0 |
574906 | 574906 | 2020-09-27 | Daniels | Montana | 30019 | 5 | 0 |
578147 | 578147 | 2020-09-28 | Daniels | Montana | 30019 | 5 | 0 |
581388 | 581388 | 2020-09-29 | Daniels | Montana | 30019 | 5 | 0 |
584629 | 584629 | 2020-09-30 | Daniels | Montana | 30019 | 5 | 0 |
587869 | 587869 | 2020-10-01 | Daniels | Montana | 30019 | 6 | 0 |
591110 | 591110 | 2020-10-02 | Daniels | Montana | 30019 | 6 | 0 |
594351 | 594351 | 2020-10-03 | Daniels | Montana | 30019 | 6 | 0 |
597592 | 597592 | 2020-10-04 | Daniels | Montana | 30019 | 6 | 0 |
600835 | 600835 | 2020-10-05 | Daniels | Montana | 30019 | 6 | 0 |
604077 | 604077 | 2020-10-06 | Daniels | Montana | 30019 | 6 | 0 |
607320 | 607320 | 2020-10-07 | Daniels | Montana | 30019 | 12 | 0 |
610562 | 610562 | 2020-10-08 | Daniels | Montana | 30019 | 12 | 0 |
613804 | 613804 | 2020-10-09 | Daniels | Montana | 30019 | 11 | 0 |
617045 | 617045 | 2020-10-10 | Daniels | Montana | 30019 | 11 | 0 |
620287 | 620287 | 2020-10-11 | Daniels | Montana | 30019 | 11 | 0 |
623530 | 623530 | 2020-10-12 | Daniels | Montana | 30019 | 11 | 0 |
626772 | 626772 | 2020-10-13 | Daniels | Montana | 30019 | 11 | 0 |
630016 | 630016 | 2020-10-14 | Daniels | Montana | 30019 | 11 | 0 |
633261 | 633261 | 2020-10-15 | Daniels | Montana | 30019 | 13 | 0 |
636507 | 636507 | 2020-10-16 | Daniels | Montana | 30019 | 15 | 0 |
639753 | 639753 | 2020-10-17 | Daniels | Montana | 30019 | 15 | 0 |
643001 | 643001 | 2020-10-18 | Daniels | Montana | 30019 | 15 | 0 |
646247 | 646247 | 2020-10-19 | Daniels | Montana | 30019 | 16 | 0 |
649491 | 649491 | 2020-10-20 | Daniels | Montana | 30019 | 22 | 0 |
652736 | 652736 | 2020-10-21 | Daniels | Montana | 30019 | 23 | 1 |
655981 | 655981 | 2020-10-22 | Daniels | Montana | 30019 | 27 | 1 |
659226 | 659226 | 2020-10-23 | Daniels | Montana | 30019 | 26 | 1 |
662470 | 662470 | 2020-10-24 | Daniels | Montana | 30019 | 27 | 1 |
665715 | 665715 | 2020-10-25 | Daniels | Montana | 30019 | 27 | 1 |
668959 | 668959 | 2020-10-26 | Daniels | Montana | 30019 | 32 | 1 |
672201 | 672201 | 2020-10-27 | Daniels | Montana | 30019 | 32 | 1 |
675444 | 675444 | 2020-10-28 | Daniels | Montana | 30019 | 36 | 1 |
678686 | 678686 | 2020-10-29 | Daniels | Montana | 30019 | 41 | 1 |
681930 | 681930 | 2020-10-30 | Daniels | Montana | 30019 | 42 | 3 |
685173 | 685173 | 2020-10-31 | Daniels | Montana | 30019 | 48 | 3 |
688417 | 688417 | 2020-11-01 | Daniels | Montana | 30019 | 49 | 3 |
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);