ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,419 rows where county = "Prairie" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
400445 | 400445 | 2020-08-04 | Prairie | Montana | 30079 | 1 | 0 |
403663 | 403663 | 2020-08-05 | Prairie | Montana | 30079 | 1 | 0 |
406881 | 406881 | 2020-08-06 | Prairie | Montana | 30079 | 1 | 0 |
410101 | 410101 | 2020-08-07 | Prairie | Montana | 30079 | 1 | 0 |
413321 | 413321 | 2020-08-08 | Prairie | Montana | 30079 | 1 | 0 |
416541 | 416541 | 2020-08-09 | Prairie | Montana | 30079 | 1 | 0 |
419762 | 419762 | 2020-08-10 | Prairie | Montana | 30079 | 1 | 0 |
422985 | 422985 | 2020-08-11 | Prairie | Montana | 30079 | 1 | 0 |
426207 | 426207 | 2020-08-12 | Prairie | Montana | 30079 | 1 | 0 |
429431 | 429431 | 2020-08-13 | Prairie | Montana | 30079 | 1 | 0 |
432658 | 432658 | 2020-08-14 | Prairie | Montana | 30079 | 1 | 0 |
435884 | 435884 | 2020-08-15 | Prairie | Montana | 30079 | 1 | 0 |
439109 | 439109 | 2020-08-16 | Prairie | Montana | 30079 | 1 | 0 |
442336 | 442336 | 2020-08-17 | Prairie | Montana | 30079 | 1 | 0 |
445562 | 445562 | 2020-08-18 | Prairie | Montana | 30079 | 1 | 0 |
448788 | 448788 | 2020-08-19 | Prairie | Montana | 30079 | 1 | 0 |
452016 | 452016 | 2020-08-20 | Prairie | Montana | 30079 | 1 | 0 |
455244 | 455244 | 2020-08-21 | Prairie | Montana | 30079 | 1 | 0 |
458472 | 458472 | 2020-08-22 | Prairie | Montana | 30079 | 1 | 0 |
461699 | 461699 | 2020-08-23 | Prairie | Montana | 30079 | 1 | 0 |
464930 | 464930 | 2020-08-24 | Prairie | Montana | 30079 | 1 | 0 |
468159 | 468159 | 2020-08-25 | Prairie | Montana | 30079 | 1 | 0 |
471389 | 471389 | 2020-08-26 | Prairie | Montana | 30079 | 1 | 0 |
474621 | 474621 | 2020-08-27 | Prairie | Montana | 30079 | 1 | 0 |
477854 | 477854 | 2020-08-28 | Prairie | Montana | 30079 | 1 | 0 |
481086 | 481086 | 2020-08-29 | Prairie | Montana | 30079 | 1 | 0 |
484321 | 484321 | 2020-08-30 | Prairie | Montana | 30079 | 1 | 0 |
487555 | 487555 | 2020-08-31 | Prairie | Montana | 30079 | 1 | 0 |
490788 | 490788 | 2020-09-01 | Prairie | Montana | 30079 | 1 | 0 |
494022 | 494022 | 2020-09-02 | Prairie | Montana | 30079 | 1 | 0 |
497255 | 497255 | 2020-09-03 | Prairie | Montana | 30079 | 1 | 0 |
500489 | 500489 | 2020-09-04 | Prairie | Montana | 30079 | 1 | 0 |
503723 | 503723 | 2020-09-05 | Prairie | Montana | 30079 | 1 | 0 |
506956 | 506956 | 2020-09-06 | Prairie | Montana | 30079 | 1 | 0 |
510189 | 510189 | 2020-09-07 | Prairie | Montana | 30079 | 1 | 0 |
513421 | 513421 | 2020-09-08 | Prairie | Montana | 30079 | 1 | 0 |
516655 | 516655 | 2020-09-09 | Prairie | Montana | 30079 | 1 | 0 |
519890 | 519890 | 2020-09-10 | Prairie | Montana | 30079 | 1 | 0 |
523127 | 523127 | 2020-09-11 | Prairie | Montana | 30079 | 1 | 0 |
526363 | 526363 | 2020-09-12 | Prairie | Montana | 30079 | 1 | 0 |
529599 | 529599 | 2020-09-13 | Prairie | Montana | 30079 | 1 | 0 |
532835 | 532835 | 2020-09-14 | Prairie | Montana | 30079 | 1 | 0 |
536070 | 536070 | 2020-09-15 | Prairie | Montana | 30079 | 1 | 0 |
539307 | 539307 | 2020-09-16 | Prairie | Montana | 30079 | 1 | 0 |
542543 | 542543 | 2020-09-17 | Prairie | Montana | 30079 | 1 | 0 |
545780 | 545780 | 2020-09-18 | Prairie | Montana | 30079 | 1 | 0 |
549018 | 549018 | 2020-09-19 | Prairie | Montana | 30079 | 1 | 0 |
552257 | 552257 | 2020-09-20 | Prairie | Montana | 30079 | 1 | 0 |
555495 | 555495 | 2020-09-21 | Prairie | Montana | 30079 | 1 | 0 |
558732 | 558732 | 2020-09-22 | Prairie | Montana | 30079 | 1 | 0 |
561969 | 561969 | 2020-09-23 | Prairie | Montana | 30079 | 1 | 0 |
565210 | 565210 | 2020-09-24 | Prairie | Montana | 30079 | 1 | 0 |
568450 | 568450 | 2020-09-25 | Prairie | Montana | 30079 | 1 | 0 |
571692 | 571692 | 2020-09-26 | Prairie | Montana | 30079 | 2 | 0 |
574935 | 574935 | 2020-09-27 | Prairie | Montana | 30079 | 2 | 0 |
578176 | 578176 | 2020-09-28 | Prairie | Montana | 30079 | 4 | 0 |
581417 | 581417 | 2020-09-29 | Prairie | Montana | 30079 | 4 | 0 |
584658 | 584658 | 2020-09-30 | Prairie | Montana | 30079 | 4 | 0 |
587898 | 587898 | 2020-10-01 | Prairie | Montana | 30079 | 4 | 0 |
591139 | 591139 | 2020-10-02 | Prairie | Montana | 30079 | 5 | 0 |
594380 | 594380 | 2020-10-03 | Prairie | Montana | 30079 | 14 | 0 |
597621 | 597621 | 2020-10-04 | Prairie | Montana | 30079 | 14 | 0 |
600865 | 600865 | 2020-10-05 | Prairie | Montana | 30079 | 16 | 0 |
604107 | 604107 | 2020-10-06 | Prairie | Montana | 30079 | 20 | 0 |
607350 | 607350 | 2020-10-07 | Prairie | Montana | 30079 | 20 | 0 |
610592 | 610592 | 2020-10-08 | Prairie | Montana | 30079 | 23 | 0 |
613834 | 613834 | 2020-10-09 | Prairie | Montana | 30079 | 25 | 0 |
617075 | 617075 | 2020-10-10 | Prairie | Montana | 30079 | 26 | 0 |
620317 | 620317 | 2020-10-11 | Prairie | Montana | 30079 | 26 | 0 |
623560 | 623560 | 2020-10-12 | Prairie | Montana | 30079 | 28 | 0 |
626802 | 626802 | 2020-10-13 | Prairie | Montana | 30079 | 28 | 0 |
630046 | 630046 | 2020-10-14 | Prairie | Montana | 30079 | 28 | 0 |
633291 | 633291 | 2020-10-15 | Prairie | Montana | 30079 | 28 | 0 |
636537 | 636537 | 2020-10-16 | Prairie | Montana | 30079 | 28 | 0 |
639783 | 639783 | 2020-10-17 | Prairie | Montana | 30079 | 29 | 0 |
643031 | 643031 | 2020-10-18 | Prairie | Montana | 30079 | 29 | 0 |
646277 | 646277 | 2020-10-19 | Prairie | Montana | 30079 | 29 | 0 |
649521 | 649521 | 2020-10-20 | Prairie | Montana | 30079 | 29 | 0 |
652766 | 652766 | 2020-10-21 | Prairie | Montana | 30079 | 30 | 0 |
656011 | 656011 | 2020-10-22 | Prairie | Montana | 30079 | 31 | 0 |
659256 | 659256 | 2020-10-23 | Prairie | Montana | 30079 | 32 | 0 |
662500 | 662500 | 2020-10-24 | Prairie | Montana | 30079 | 32 | 0 |
665745 | 665745 | 2020-10-25 | Prairie | Montana | 30079 | 32 | 0 |
668989 | 668989 | 2020-10-26 | Prairie | Montana | 30079 | 32 | 0 |
672231 | 672231 | 2020-10-27 | Prairie | Montana | 30079 | 32 | 0 |
675474 | 675474 | 2020-10-28 | Prairie | Montana | 30079 | 33 | 0 |
678716 | 678716 | 2020-10-29 | Prairie | Montana | 30079 | 33 | 0 |
681960 | 681960 | 2020-10-30 | Prairie | Montana | 30079 | 33 | 0 |
685203 | 685203 | 2020-10-31 | Prairie | Montana | 30079 | 33 | 0 |
688447 | 688447 | 2020-11-01 | Prairie | Montana | 30079 | 33 | 0 |
691692 | 691692 | 2020-11-02 | Prairie | Montana | 30079 | 33 | 0 |
694934 | 694934 | 2020-11-03 | Prairie | Montana | 30079 | 33 | 0 |
698177 | 698177 | 2020-11-04 | Prairie | Montana | 30079 | 35 | 0 |
701421 | 701421 | 2020-11-05 | Prairie | Montana | 30079 | 36 | 0 |
704663 | 704663 | 2020-11-06 | Prairie | Montana | 30079 | 36 | 0 |
707906 | 707906 | 2020-11-07 | Prairie | Montana | 30079 | 36 | 0 |
711150 | 711150 | 2020-11-08 | Prairie | Montana | 30079 | 36 | 0 |
714394 | 714394 | 2020-11-09 | Prairie | Montana | 30079 | 36 | 0 |
717638 | 717638 | 2020-11-10 | Prairie | Montana | 30079 | 36 | 0 |
720881 | 720881 | 2020-11-11 | Prairie | Montana | 30079 | 36 | 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);