ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
654 rows where county = "Powell" and state = "Montana" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
381146 | 381146 | 2020-07-29 | Powell | Montana | 30077 | 1 | 0 |
384362 | 384362 | 2020-07-30 | Powell | Montana | 30077 | 2 | 0 |
387580 | 387580 | 2020-07-31 | Powell | Montana | 30077 | 2 | 0 |
390797 | 390797 | 2020-08-01 | Powell | Montana | 30077 | 2 | 0 |
394014 | 394014 | 2020-08-02 | Powell | Montana | 30077 | 2 | 0 |
397230 | 397230 | 2020-08-03 | Powell | Montana | 30077 | 2 | 0 |
400444 | 400444 | 2020-08-04 | Powell | Montana | 30077 | 2 | 0 |
403662 | 403662 | 2020-08-05 | Powell | Montana | 30077 | 2 | 0 |
406880 | 406880 | 2020-08-06 | Powell | Montana | 30077 | 2 | 0 |
410100 | 410100 | 2020-08-07 | Powell | Montana | 30077 | 2 | 0 |
413320 | 413320 | 2020-08-08 | Powell | Montana | 30077 | 2 | 0 |
416540 | 416540 | 2020-08-09 | Powell | Montana | 30077 | 2 | 0 |
419761 | 419761 | 2020-08-10 | Powell | Montana | 30077 | 2 | 0 |
422984 | 422984 | 2020-08-11 | Powell | Montana | 30077 | 2 | 0 |
426206 | 426206 | 2020-08-12 | Powell | Montana | 30077 | 2 | 0 |
429430 | 429430 | 2020-08-13 | Powell | Montana | 30077 | 2 | 0 |
432657 | 432657 | 2020-08-14 | Powell | Montana | 30077 | 2 | 0 |
435883 | 435883 | 2020-08-15 | Powell | Montana | 30077 | 2 | 0 |
439108 | 439108 | 2020-08-16 | Powell | Montana | 30077 | 2 | 0 |
442335 | 442335 | 2020-08-17 | Powell | Montana | 30077 | 2 | 0 |
445561 | 445561 | 2020-08-18 | Powell | Montana | 30077 | 2 | 0 |
448787 | 448787 | 2020-08-19 | Powell | Montana | 30077 | 2 | 0 |
452015 | 452015 | 2020-08-20 | Powell | Montana | 30077 | 2 | 0 |
455243 | 455243 | 2020-08-21 | Powell | Montana | 30077 | 2 | 0 |
458471 | 458471 | 2020-08-22 | Powell | Montana | 30077 | 2 | 0 |
461698 | 461698 | 2020-08-23 | Powell | Montana | 30077 | 3 | 0 |
464929 | 464929 | 2020-08-24 | Powell | Montana | 30077 | 8 | 0 |
468158 | 468158 | 2020-08-25 | Powell | Montana | 30077 | 10 | 0 |
471388 | 471388 | 2020-08-26 | Powell | Montana | 30077 | 10 | 0 |
474620 | 474620 | 2020-08-27 | Powell | Montana | 30077 | 10 | 0 |
477853 | 477853 | 2020-08-28 | Powell | Montana | 30077 | 10 | 0 |
481085 | 481085 | 2020-08-29 | Powell | Montana | 30077 | 10 | 0 |
484320 | 484320 | 2020-08-30 | Powell | Montana | 30077 | 10 | 0 |
487554 | 487554 | 2020-08-31 | Powell | Montana | 30077 | 10 | 0 |
490787 | 490787 | 2020-09-01 | Powell | Montana | 30077 | 10 | 0 |
494021 | 494021 | 2020-09-02 | Powell | Montana | 30077 | 10 | 0 |
497254 | 497254 | 2020-09-03 | Powell | Montana | 30077 | 10 | 0 |
500488 | 500488 | 2020-09-04 | Powell | Montana | 30077 | 10 | 0 |
503722 | 503722 | 2020-09-05 | Powell | Montana | 30077 | 10 | 0 |
506955 | 506955 | 2020-09-06 | Powell | Montana | 30077 | 10 | 0 |
510188 | 510188 | 2020-09-07 | Powell | Montana | 30077 | 10 | 0 |
513420 | 513420 | 2020-09-08 | Powell | Montana | 30077 | 10 | 0 |
516654 | 516654 | 2020-09-09 | Powell | Montana | 30077 | 10 | 0 |
519889 | 519889 | 2020-09-10 | Powell | Montana | 30077 | 10 | 0 |
523126 | 523126 | 2020-09-11 | Powell | Montana | 30077 | 10 | 0 |
526362 | 526362 | 2020-09-12 | Powell | Montana | 30077 | 10 | 0 |
529598 | 529598 | 2020-09-13 | Powell | Montana | 30077 | 10 | 0 |
532834 | 532834 | 2020-09-14 | Powell | Montana | 30077 | 10 | 0 |
536069 | 536069 | 2020-09-15 | Powell | Montana | 30077 | 10 | 0 |
539306 | 539306 | 2020-09-16 | Powell | Montana | 30077 | 10 | 0 |
542542 | 542542 | 2020-09-17 | Powell | Montana | 30077 | 10 | 0 |
545779 | 545779 | 2020-09-18 | Powell | Montana | 30077 | 10 | 0 |
549017 | 549017 | 2020-09-19 | Powell | Montana | 30077 | 10 | 0 |
552256 | 552256 | 2020-09-20 | Powell | Montana | 30077 | 10 | 0 |
555494 | 555494 | 2020-09-21 | Powell | Montana | 30077 | 10 | 0 |
558731 | 558731 | 2020-09-22 | Powell | Montana | 30077 | 10 | 0 |
561968 | 561968 | 2020-09-23 | Powell | Montana | 30077 | 10 | 0 |
565209 | 565209 | 2020-09-24 | Powell | Montana | 30077 | 12 | 0 |
568449 | 568449 | 2020-09-25 | Powell | Montana | 30077 | 12 | 0 |
571691 | 571691 | 2020-09-26 | Powell | Montana | 30077 | 12 | 0 |
574934 | 574934 | 2020-09-27 | Powell | Montana | 30077 | 12 | 0 |
578175 | 578175 | 2020-09-28 | Powell | Montana | 30077 | 12 | 0 |
581416 | 581416 | 2020-09-29 | Powell | Montana | 30077 | 12 | 0 |
584657 | 584657 | 2020-09-30 | Powell | Montana | 30077 | 12 | 0 |
587897 | 587897 | 2020-10-01 | Powell | Montana | 30077 | 12 | 0 |
591138 | 591138 | 2020-10-02 | Powell | Montana | 30077 | 12 | 0 |
594379 | 594379 | 2020-10-03 | Powell | Montana | 30077 | 12 | 0 |
597620 | 597620 | 2020-10-04 | Powell | Montana | 30077 | 15 | 0 |
600864 | 600864 | 2020-10-05 | Powell | Montana | 30077 | 15 | 0 |
604106 | 604106 | 2020-10-06 | Powell | Montana | 30077 | 15 | 0 |
607349 | 607349 | 2020-10-07 | Powell | Montana | 30077 | 15 | 0 |
610591 | 610591 | 2020-10-08 | Powell | Montana | 30077 | 15 | 0 |
613833 | 613833 | 2020-10-09 | Powell | Montana | 30077 | 17 | 0 |
617074 | 617074 | 2020-10-10 | Powell | Montana | 30077 | 19 | 0 |
620316 | 620316 | 2020-10-11 | Powell | Montana | 30077 | 21 | 0 |
623559 | 623559 | 2020-10-12 | Powell | Montana | 30077 | 23 | 0 |
626801 | 626801 | 2020-10-13 | Powell | Montana | 30077 | 27 | 0 |
630045 | 630045 | 2020-10-14 | Powell | Montana | 30077 | 27 | 0 |
633290 | 633290 | 2020-10-15 | Powell | Montana | 30077 | 28 | 0 |
636536 | 636536 | 2020-10-16 | Powell | Montana | 30077 | 33 | 0 |
639782 | 639782 | 2020-10-17 | Powell | Montana | 30077 | 37 | 0 |
643030 | 643030 | 2020-10-18 | Powell | Montana | 30077 | 37 | 0 |
646276 | 646276 | 2020-10-19 | Powell | Montana | 30077 | 43 | 0 |
649520 | 649520 | 2020-10-20 | Powell | Montana | 30077 | 80 | 0 |
652765 | 652765 | 2020-10-21 | Powell | Montana | 30077 | 80 | 0 |
656010 | 656010 | 2020-10-22 | Powell | Montana | 30077 | 89 | 0 |
659255 | 659255 | 2020-10-23 | Powell | Montana | 30077 | 89 | 0 |
662499 | 662499 | 2020-10-24 | Powell | Montana | 30077 | 89 | 0 |
665744 | 665744 | 2020-10-25 | Powell | Montana | 30077 | 98 | 0 |
668988 | 668988 | 2020-10-26 | Powell | Montana | 30077 | 110 | 0 |
672230 | 672230 | 2020-10-27 | Powell | Montana | 30077 | 110 | 0 |
675473 | 675473 | 2020-10-28 | Powell | Montana | 30077 | 112 | 0 |
678715 | 678715 | 2020-10-29 | Powell | Montana | 30077 | 137 | 0 |
681959 | 681959 | 2020-10-30 | Powell | Montana | 30077 | 168 | 0 |
685202 | 685202 | 2020-10-31 | Powell | Montana | 30077 | 182 | 0 |
688446 | 688446 | 2020-11-01 | Powell | Montana | 30077 | 183 | 0 |
691691 | 691691 | 2020-11-02 | Powell | Montana | 30077 | 193 | 0 |
694933 | 694933 | 2020-11-03 | Powell | Montana | 30077 | 198 | 0 |
698176 | 698176 | 2020-11-04 | Powell | Montana | 30077 | 210 | 0 |
701420 | 701420 | 2020-11-05 | Powell | Montana | 30077 | 220 | 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);