ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
667 rows where county = "Blaine" and fips = 30005 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
339437 | 339437 | 2020-07-16 | Blaine | Montana | 30005 | 1 | 0 |
342633 | 342633 | 2020-07-17 | Blaine | Montana | 30005 | 4 | 0 |
345833 | 345833 | 2020-07-18 | Blaine | Montana | 30005 | 4 | 0 |
349034 | 349034 | 2020-07-19 | Blaine | Montana | 30005 | 4 | 0 |
352234 | 352234 | 2020-07-20 | Blaine | Montana | 30005 | 4 | 0 |
355436 | 355436 | 2020-07-21 | Blaine | Montana | 30005 | 6 | 0 |
358639 | 358639 | 2020-07-22 | Blaine | Montana | 30005 | 6 | 0 |
361844 | 361844 | 2020-07-23 | Blaine | Montana | 30005 | 7 | 0 |
365051 | 365051 | 2020-07-24 | Blaine | Montana | 30005 | 7 | 0 |
368259 | 368259 | 2020-07-25 | Blaine | Montana | 30005 | 7 | 0 |
371470 | 371470 | 2020-07-26 | Blaine | Montana | 30005 | 7 | 0 |
374682 | 374682 | 2020-07-27 | Blaine | Montana | 30005 | 7 | 0 |
377897 | 377897 | 2020-07-28 | Blaine | Montana | 30005 | 7 | 0 |
381114 | 381114 | 2020-07-29 | Blaine | Montana | 30005 | 7 | 0 |
384330 | 384330 | 2020-07-30 | Blaine | Montana | 30005 | 7 | 0 |
387548 | 387548 | 2020-07-31 | Blaine | Montana | 30005 | 7 | 0 |
390765 | 390765 | 2020-08-01 | Blaine | Montana | 30005 | 8 | 0 |
393982 | 393982 | 2020-08-02 | Blaine | Montana | 30005 | 9 | 0 |
397198 | 397198 | 2020-08-03 | Blaine | Montana | 30005 | 9 | 0 |
400412 | 400412 | 2020-08-04 | Blaine | Montana | 30005 | 9 | 0 |
403629 | 403629 | 2020-08-05 | Blaine | Montana | 30005 | 10 | 0 |
406847 | 406847 | 2020-08-06 | Blaine | Montana | 30005 | 10 | 0 |
410067 | 410067 | 2020-08-07 | Blaine | Montana | 30005 | 10 | 0 |
413287 | 413287 | 2020-08-08 | Blaine | Montana | 30005 | 10 | 0 |
416507 | 416507 | 2020-08-09 | Blaine | Montana | 30005 | 10 | 0 |
419728 | 419728 | 2020-08-10 | Blaine | Montana | 30005 | 10 | 0 |
422950 | 422950 | 2020-08-11 | Blaine | Montana | 30005 | 11 | 0 |
426172 | 426172 | 2020-08-12 | Blaine | Montana | 30005 | 13 | 0 |
429396 | 429396 | 2020-08-13 | Blaine | Montana | 30005 | 13 | 0 |
432623 | 432623 | 2020-08-14 | Blaine | Montana | 30005 | 14 | 0 |
442301 | 442301 | 2020-08-17 | Blaine | Montana | 30005 | 14 | 0 |
445527 | 445527 | 2020-08-18 | Blaine | Montana | 30005 | 14 | 0 |
448753 | 448753 | 2020-08-19 | Blaine | Montana | 30005 | 14 | 0 |
435849 | 435849 | 2020-08-15 | Blaine | Montana | 30005 | 15 | 0 |
439074 | 439074 | 2020-08-16 | Blaine | Montana | 30005 | 15 | 0 |
451981 | 451981 | 2020-08-20 | Blaine | Montana | 30005 | 15 | 0 |
455209 | 455209 | 2020-08-21 | Blaine | Montana | 30005 | 15 | 0 |
458437 | 458437 | 2020-08-22 | Blaine | Montana | 30005 | 15 | 0 |
461664 | 461664 | 2020-08-23 | Blaine | Montana | 30005 | 15 | 0 |
464895 | 464895 | 2020-08-24 | Blaine | Montana | 30005 | 15 | 0 |
468124 | 468124 | 2020-08-25 | Blaine | Montana | 30005 | 15 | 0 |
471354 | 471354 | 2020-08-26 | Blaine | Montana | 30005 | 15 | 0 |
474586 | 474586 | 2020-08-27 | Blaine | Montana | 30005 | 15 | 0 |
477819 | 477819 | 2020-08-28 | Blaine | Montana | 30005 | 15 | 0 |
481051 | 481051 | 2020-08-29 | Blaine | Montana | 30005 | 15 | 0 |
484286 | 484286 | 2020-08-30 | Blaine | Montana | 30005 | 15 | 0 |
487520 | 487520 | 2020-08-31 | Blaine | Montana | 30005 | 15 | 0 |
490753 | 490753 | 2020-09-01 | Blaine | Montana | 30005 | 15 | 0 |
493987 | 493987 | 2020-09-02 | Blaine | Montana | 30005 | 15 | 0 |
497220 | 497220 | 2020-09-03 | Blaine | Montana | 30005 | 15 | 0 |
500454 | 500454 | 2020-09-04 | Blaine | Montana | 30005 | 15 | 0 |
503688 | 503688 | 2020-09-05 | Blaine | Montana | 30005 | 15 | 0 |
506921 | 506921 | 2020-09-06 | Blaine | Montana | 30005 | 15 | 0 |
510154 | 510154 | 2020-09-07 | Blaine | Montana | 30005 | 15 | 0 |
513386 | 513386 | 2020-09-08 | Blaine | Montana | 30005 | 15 | 0 |
516620 | 516620 | 2020-09-09 | Blaine | Montana | 30005 | 15 | 0 |
519855 | 519855 | 2020-09-10 | Blaine | Montana | 30005 | 15 | 0 |
523092 | 523092 | 2020-09-11 | Blaine | Montana | 30005 | 15 | 0 |
526328 | 526328 | 2020-09-12 | Blaine | Montana | 30005 | 15 | 0 |
529564 | 529564 | 2020-09-13 | Blaine | Montana | 30005 | 15 | 0 |
532800 | 532800 | 2020-09-14 | Blaine | Montana | 30005 | 15 | 0 |
536035 | 536035 | 2020-09-15 | Blaine | Montana | 30005 | 15 | 0 |
539272 | 539272 | 2020-09-16 | Blaine | Montana | 30005 | 15 | 0 |
542508 | 542508 | 2020-09-17 | Blaine | Montana | 30005 | 15 | 0 |
545745 | 545745 | 2020-09-18 | Blaine | Montana | 30005 | 16 | 0 |
548983 | 548983 | 2020-09-19 | Blaine | Montana | 30005 | 16 | 0 |
552222 | 552222 | 2020-09-20 | Blaine | Montana | 30005 | 16 | 0 |
555460 | 555460 | 2020-09-21 | Blaine | Montana | 30005 | 16 | 0 |
558697 | 558697 | 2020-09-22 | Blaine | Montana | 30005 | 16 | 0 |
561934 | 561934 | 2020-09-23 | Blaine | Montana | 30005 | 21 | 0 |
565174 | 565174 | 2020-09-24 | Blaine | Montana | 30005 | 21 | 0 |
568414 | 568414 | 2020-09-25 | Blaine | Montana | 30005 | 21 | 0 |
571656 | 571656 | 2020-09-26 | Blaine | Montana | 30005 | 21 | 0 |
574899 | 574899 | 2020-09-27 | Blaine | Montana | 30005 | 21 | 0 |
578140 | 578140 | 2020-09-28 | Blaine | Montana | 30005 | 25 | 0 |
581381 | 581381 | 2020-09-29 | Blaine | Montana | 30005 | 31 | 0 |
584622 | 584622 | 2020-09-30 | Blaine | Montana | 30005 | 34 | 0 |
587862 | 587862 | 2020-10-01 | Blaine | Montana | 30005 | 38 | 0 |
591103 | 591103 | 2020-10-02 | Blaine | Montana | 30005 | 39 | 0 |
597585 | 597585 | 2020-10-04 | Blaine | Montana | 30005 | 74 | 0 |
600828 | 600828 | 2020-10-05 | Blaine | Montana | 30005 | 74 | 0 |
594344 | 594344 | 2020-10-03 | Blaine | Montana | 30005 | 75 | 0 |
604070 | 604070 | 2020-10-06 | Blaine | Montana | 30005 | 83 | 0 |
607313 | 607313 | 2020-10-07 | Blaine | Montana | 30005 | 100 | 0 |
610555 | 610555 | 2020-10-08 | Blaine | Montana | 30005 | 108 | 0 |
613797 | 613797 | 2020-10-09 | Blaine | Montana | 30005 | 112 | 0 |
617038 | 617038 | 2020-10-10 | Blaine | Montana | 30005 | 112 | 0 |
620280 | 620280 | 2020-10-11 | Blaine | Montana | 30005 | 140 | 0 |
623523 | 623523 | 2020-10-12 | Blaine | Montana | 30005 | 145 | 0 |
626765 | 626765 | 2020-10-13 | Blaine | Montana | 30005 | 146 | 2 |
630009 | 630009 | 2020-10-14 | Blaine | Montana | 30005 | 155 | 2 |
633254 | 633254 | 2020-10-15 | Blaine | Montana | 30005 | 165 | 2 |
636500 | 636500 | 2020-10-16 | Blaine | Montana | 30005 | 182 | 2 |
639746 | 639746 | 2020-10-17 | Blaine | Montana | 30005 | 193 | 2 |
642994 | 642994 | 2020-10-18 | Blaine | Montana | 30005 | 206 | 2 |
646240 | 646240 | 2020-10-19 | Blaine | Montana | 30005 | 228 | 2 |
649484 | 649484 | 2020-10-20 | Blaine | Montana | 30005 | 241 | 2 |
652729 | 652729 | 2020-10-21 | Blaine | Montana | 30005 | 246 | 2 |
655974 | 655974 | 2020-10-22 | Blaine | Montana | 30005 | 256 | 2 |
659219 | 659219 | 2020-10-23 | Blaine | Montana | 30005 | 266 | 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);