ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where county = "Blaine", deaths = 6 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
654920 | 654920 | 2020-10-22 | Blaine | Idaho | 16013 | 845 | 6 |
651675 | 651675 | 2020-10-21 | Blaine | Idaho | 16013 | 842 | 6 |
648431 | 648431 | 2020-10-20 | Blaine | Idaho | 16013 | 832 | 6 |
645186 | 645186 | 2020-10-19 | Blaine | Idaho | 16013 | 813 | 6 |
641938 | 641938 | 2020-10-18 | Blaine | Idaho | 16013 | 803 | 6 |
638691 | 638691 | 2020-10-17 | Blaine | Idaho | 16013 | 803 | 6 |
635446 | 635446 | 2020-10-16 | Blaine | Idaho | 16013 | 803 | 6 |
632200 | 632200 | 2020-10-15 | Blaine | Idaho | 16013 | 790 | 6 |
628956 | 628956 | 2020-10-14 | Blaine | Idaho | 16013 | 780 | 6 |
625713 | 625713 | 2020-10-13 | Blaine | Idaho | 16013 | 778 | 6 |
622470 | 622470 | 2020-10-12 | Blaine | Idaho | 16013 | 731 | 6 |
619227 | 619227 | 2020-10-11 | Blaine | Idaho | 16013 | 731 | 6 |
615985 | 615985 | 2020-10-10 | Blaine | Idaho | 16013 | 731 | 6 |
612744 | 612744 | 2020-10-09 | Blaine | Idaho | 16013 | 731 | 6 |
609502 | 609502 | 2020-10-08 | Blaine | Idaho | 16013 | 723 | 6 |
606259 | 606259 | 2020-10-07 | Blaine | Idaho | 16013 | 716 | 6 |
603017 | 603017 | 2020-10-06 | Blaine | Idaho | 16013 | 708 | 6 |
599774 | 599774 | 2020-10-05 | Blaine | Idaho | 16013 | 703 | 6 |
596531 | 596531 | 2020-10-04 | Blaine | Idaho | 16013 | 693 | 6 |
593289 | 593289 | 2020-10-03 | Blaine | Idaho | 16013 | 693 | 6 |
590049 | 590049 | 2020-10-02 | Blaine | Idaho | 16013 | 693 | 6 |
586808 | 586808 | 2020-10-01 | Blaine | Idaho | 16013 | 685 | 6 |
583568 | 583568 | 2020-09-30 | Blaine | Idaho | 16013 | 685 | 6 |
580329 | 580329 | 2020-09-29 | Blaine | Idaho | 16013 | 682 | 6 |
577088 | 577088 | 2020-09-28 | Blaine | Idaho | 16013 | 680 | 6 |
573845 | 573845 | 2020-09-27 | Blaine | Idaho | 16013 | 651 | 6 |
570603 | 570603 | 2020-09-26 | Blaine | Idaho | 16013 | 651 | 6 |
567361 | 567361 | 2020-09-25 | Blaine | Idaho | 16013 | 651 | 6 |
564121 | 564121 | 2020-09-24 | Blaine | Idaho | 16013 | 644 | 6 |
560881 | 560881 | 2020-09-23 | Blaine | Idaho | 16013 | 642 | 6 |
557645 | 557645 | 2020-09-22 | Blaine | Idaho | 16013 | 641 | 6 |
554408 | 554408 | 2020-09-21 | Blaine | Idaho | 16013 | 639 | 6 |
551169 | 551169 | 2020-09-20 | Blaine | Idaho | 16013 | 631 | 6 |
547930 | 547930 | 2020-09-19 | Blaine | Idaho | 16013 | 630 | 6 |
544692 | 544692 | 2020-09-18 | Blaine | Idaho | 16013 | 624 | 6 |
541456 | 541456 | 2020-09-17 | Blaine | Idaho | 16013 | 621 | 6 |
538219 | 538219 | 2020-09-16 | Blaine | Idaho | 16013 | 617 | 6 |
534983 | 534983 | 2020-09-15 | Blaine | Idaho | 16013 | 617 | 6 |
531748 | 531748 | 2020-09-14 | Blaine | Idaho | 16013 | 615 | 6 |
528511 | 528511 | 2020-09-13 | Blaine | Idaho | 16013 | 610 | 6 |
525275 | 525275 | 2020-09-12 | Blaine | Idaho | 16013 | 610 | 6 |
522039 | 522039 | 2020-09-11 | Blaine | Idaho | 16013 | 609 | 6 |
518802 | 518802 | 2020-09-10 | Blaine | Idaho | 16013 | 609 | 6 |
515567 | 515567 | 2020-09-09 | Blaine | Idaho | 16013 | 608 | 6 |
512334 | 512334 | 2020-09-08 | Blaine | Idaho | 16013 | 607 | 6 |
509101 | 509101 | 2020-09-07 | Blaine | Idaho | 16013 | 607 | 6 |
505869 | 505869 | 2020-09-06 | Blaine | Idaho | 16013 | 606 | 6 |
502635 | 502635 | 2020-09-05 | Blaine | Idaho | 16013 | 606 | 6 |
499401 | 499401 | 2020-09-04 | Blaine | Idaho | 16013 | 606 | 6 |
496168 | 496168 | 2020-09-03 | Blaine | Idaho | 16013 | 607 | 6 |
492934 | 492934 | 2020-09-02 | Blaine | Idaho | 16013 | 605 | 6 |
489701 | 489701 | 2020-09-01 | Blaine | Idaho | 16013 | 606 | 6 |
486468 | 486468 | 2020-08-31 | Blaine | Idaho | 16013 | 606 | 6 |
483233 | 483233 | 2020-08-30 | Blaine | Idaho | 16013 | 605 | 6 |
479999 | 479999 | 2020-08-29 | Blaine | Idaho | 16013 | 604 | 6 |
476766 | 476766 | 2020-08-28 | Blaine | Idaho | 16013 | 601 | 6 |
473533 | 473533 | 2020-08-27 | Blaine | Idaho | 16013 | 601 | 6 |
470301 | 470301 | 2020-08-26 | Blaine | Idaho | 16013 | 599 | 6 |
467072 | 467072 | 2020-08-25 | Blaine | Idaho | 16013 | 596 | 6 |
463843 | 463843 | 2020-08-24 | Blaine | Idaho | 16013 | 595 | 6 |
460614 | 460614 | 2020-08-23 | Blaine | Idaho | 16013 | 595 | 6 |
457387 | 457387 | 2020-08-22 | Blaine | Idaho | 16013 | 594 | 6 |
454159 | 454159 | 2020-08-21 | Blaine | Idaho | 16013 | 593 | 6 |
450931 | 450931 | 2020-08-20 | Blaine | Idaho | 16013 | 593 | 6 |
447703 | 447703 | 2020-08-19 | Blaine | Idaho | 16013 | 592 | 6 |
444476 | 444476 | 2020-08-18 | Blaine | Idaho | 16013 | 591 | 6 |
441250 | 441250 | 2020-08-17 | Blaine | Idaho | 16013 | 586 | 6 |
438024 | 438024 | 2020-08-16 | Blaine | Idaho | 16013 | 585 | 6 |
434798 | 434798 | 2020-08-15 | Blaine | Idaho | 16013 | 585 | 6 |
431573 | 431573 | 2020-08-14 | Blaine | Idaho | 16013 | 584 | 6 |
428345 | 428345 | 2020-08-13 | Blaine | Idaho | 16013 | 582 | 6 |
425121 | 425121 | 2020-08-12 | Blaine | Idaho | 16013 | 579 | 6 |
421901 | 421901 | 2020-08-11 | Blaine | Idaho | 16013 | 578 | 6 |
418679 | 418679 | 2020-08-10 | Blaine | Idaho | 16013 | 577 | 6 |
415458 | 415458 | 2020-08-09 | Blaine | Idaho | 16013 | 576 | 6 |
412238 | 412238 | 2020-08-08 | Blaine | Idaho | 16013 | 575 | 6 |
409019 | 409019 | 2020-08-07 | Blaine | Idaho | 16013 | 575 | 6 |
405799 | 405799 | 2020-08-06 | Blaine | Idaho | 16013 | 575 | 6 |
402581 | 402581 | 2020-08-05 | Blaine | Idaho | 16013 | 575 | 6 |
399365 | 399365 | 2020-08-04 | Blaine | Idaho | 16013 | 571 | 6 |
396149 | 396149 | 2020-08-03 | Blaine | Idaho | 16013 | 571 | 6 |
392933 | 392933 | 2020-08-02 | Blaine | Idaho | 16013 | 569 | 6 |
389716 | 389716 | 2020-08-01 | Blaine | Idaho | 16013 | 569 | 6 |
386499 | 386499 | 2020-07-31 | Blaine | Idaho | 16013 | 568 | 6 |
383281 | 383281 | 2020-07-30 | Blaine | Idaho | 16013 | 567 | 6 |
380064 | 380064 | 2020-07-29 | Blaine | Idaho | 16013 | 567 | 6 |
376847 | 376847 | 2020-07-28 | Blaine | Idaho | 16013 | 566 | 6 |
373633 | 373633 | 2020-07-27 | Blaine | Idaho | 16013 | 563 | 6 |
370421 | 370421 | 2020-07-26 | Blaine | Idaho | 16013 | 560 | 6 |
367211 | 367211 | 2020-07-25 | Blaine | Idaho | 16013 | 560 | 6 |
364004 | 364004 | 2020-07-24 | Blaine | Idaho | 16013 | 560 | 6 |
360797 | 360797 | 2020-07-23 | Blaine | Idaho | 16013 | 560 | 6 |
357592 | 357592 | 2020-07-22 | Blaine | Idaho | 16013 | 562 | 6 |
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);