ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Unknown" and state = "Massachusetts" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921678 | 921678 | 2021-01-12 | Unknown | Massachusetts | 21304 | 8 | |
918433 | 918433 | 2021-01-11 | Unknown | Massachusetts | 20703 | 8 | |
915188 | 915188 | 2021-01-10 | Unknown | Massachusetts | 20700 | 8 | |
911943 | 911943 | 2021-01-09 | Unknown | Massachusetts | 20405 | 8 | |
908698 | 908698 | 2021-01-08 | Unknown | Massachusetts | 20091 | 7 | |
905452 | 905452 | 2021-01-07 | Unknown | Massachusetts | 19584 | 7 | |
902207 | 902207 | 2021-01-06 | Unknown | Massachusetts | 19186 | 7 | |
898962 | 898962 | 2021-01-05 | Unknown | Massachusetts | 18738 | 7 | |
895717 | 895717 | 2021-01-04 | Unknown | Massachusetts | 18285 | 5 | |
892470 | 892470 | 2021-01-03 | Unknown | Massachusetts | 17737 | 7 | |
889224 | 889224 | 2021-01-02 | Unknown | Massachusetts | 17330 | 7 | |
885978 | 885978 | 2021-01-01 | Unknown | Massachusetts | 16810 | 7 | |
882733 | 882733 | 2020-12-31 | Unknown | Massachusetts | 16810 | 7 | |
879488 | 879488 | 2020-12-30 | Unknown | Massachusetts | 16403 | 7 | |
876243 | 876243 | 2020-12-29 | Unknown | Massachusetts | 15668 | 6 | |
872998 | 872998 | 2020-12-28 | Unknown | Massachusetts | 15166 | 6 | |
869753 | 869753 | 2020-12-27 | Unknown | Massachusetts | 15019 | 6 | |
866508 | 866508 | 2020-12-26 | Unknown | Massachusetts | 14851 | 6 | |
863263 | 863263 | 2020-12-25 | Unknown | Massachusetts | 14560 | 6 | |
860018 | 860018 | 2020-12-24 | Unknown | Massachusetts | 14560 | 6 | |
856773 | 856773 | 2020-12-23 | Unknown | Massachusetts | 14267 | 6 | |
853528 | 853528 | 2020-12-22 | Unknown | Massachusetts | 13937 | 6 | |
850283 | 850283 | 2020-12-21 | Unknown | Massachusetts | 13482 | 6 | |
847038 | 847038 | 2020-12-20 | Unknown | Massachusetts | 13335 | 6 | |
843792 | 843792 | 2020-12-19 | Unknown | Massachusetts | 13212 | 6 | |
840547 | 840547 | 2020-12-18 | Unknown | Massachusetts | 12859 | 6 | |
837302 | 837302 | 2020-12-17 | Unknown | Massachusetts | 12790 | 6 | |
834056 | 834056 | 2020-12-16 | Unknown | Massachusetts | 12619 | 6 | |
830809 | 830809 | 2020-12-15 | Unknown | Massachusetts | 12112 | 6 | |
827563 | 827563 | 2020-12-14 | Unknown | Massachusetts | 11895 | 6 | |
824316 | 824316 | 2020-12-13 | Unknown | Massachusetts | 11805 | 6 | |
821070 | 821070 | 2020-12-12 | Unknown | Massachusetts | 11616 | 6 | |
817824 | 817824 | 2020-12-11 | Unknown | Massachusetts | 11278 | 6 | |
814578 | 814578 | 2020-12-10 | Unknown | Massachusetts | 11102 | 6 | |
811333 | 811333 | 2020-12-09 | Unknown | Massachusetts | 10832 | 6 | |
808088 | 808088 | 2020-12-08 | Unknown | Massachusetts | 10533 | 6 | |
804843 | 804843 | 2020-12-07 | Unknown | Massachusetts | 10038 | 6 | |
801598 | 801598 | 2020-12-06 | Unknown | Massachusetts | 9984 | 6 | |
798353 | 798353 | 2020-12-05 | Unknown | Massachusetts | 9892 | 6 | |
795108 | 795108 | 2020-12-04 | Unknown | Massachusetts | 9631 | 6 | |
791863 | 791863 | 2020-12-03 | Unknown | Massachusetts | 9330 | 6 | |
788618 | 788618 | 2020-12-02 | Unknown | Massachusetts | 9094 | 6 | |
785373 | 785373 | 2020-12-01 | Unknown | Massachusetts | 8701 | 6 | |
782129 | 782129 | 2020-11-30 | Unknown | Massachusetts | 8414 | 6 | |
778883 | 778883 | 2020-11-29 | Unknown | Massachusetts | 8449 | 6 | |
775638 | 775638 | 2020-11-28 | Unknown | Massachusetts | 8440 | 6 | |
772393 | 772393 | 2020-11-27 | Unknown | Massachusetts | 8110 | 6 | |
769148 | 769148 | 2020-11-26 | Unknown | Massachusetts | 7899 | 6 | |
765902 | 765902 | 2020-11-25 | Unknown | Massachusetts | 7899 | 6 | |
762657 | 762657 | 2020-11-24 | Unknown | Massachusetts | 7705 | 7 | |
759412 | 759412 | 2020-11-23 | Unknown | Massachusetts | 7340 | 7 | |
756165 | 756165 | 2020-11-22 | Unknown | Massachusetts | 7366 | 7 | |
752919 | 752919 | 2020-11-21 | Unknown | Massachusetts | 7362 | 7 | |
749673 | 749673 | 2020-11-20 | Unknown | Massachusetts | 7164 | 7 | |
746427 | 746427 | 2020-11-19 | Unknown | Massachusetts | 7030 | 7 | |
743180 | 743180 | 2020-11-18 | Unknown | Massachusetts | 6870 | 7 | |
739933 | 739933 | 2020-11-17 | Unknown | Massachusetts | 6693 | 7 | |
736689 | 736689 | 2020-11-16 | Unknown | Massachusetts | 6397 | 7 | |
733443 | 733443 | 2020-11-15 | Unknown | Massachusetts | 6189 | 7 | |
730198 | 730198 | 2020-11-14 | Unknown | Massachusetts | 6140 | 6 | |
726955 | 726955 | 2020-11-13 | Unknown | Massachusetts | 5902 | 6 | |
723712 | 723712 | 2020-11-12 | Unknown | Massachusetts | 5656 | 6 | |
720469 | 720469 | 2020-11-11 | Unknown | Massachusetts | 5492 | 6 | |
717226 | 717226 | 2020-11-10 | Unknown | Massachusetts | 5327 | 23 | |
713982 | 713982 | 2020-11-09 | Unknown | Massachusetts | 5202 | 23 | |
710738 | 710738 | 2020-11-08 | Unknown | Massachusetts | 5037 | 23 | |
707494 | 707494 | 2020-11-07 | Unknown | Massachusetts | 5022 | 23 | |
704251 | 704251 | 2020-11-06 | Unknown | Massachusetts | 4899 | 23 | |
701009 | 701009 | 2020-11-05 | Unknown | Massachusetts | 4804 | 7 | |
697765 | 697765 | 2020-11-04 | Unknown | Massachusetts | 4735 | 6 | |
694522 | 694522 | 2020-11-03 | Unknown | Massachusetts | 4607 | 6 | |
691280 | 691280 | 2020-11-02 | Unknown | Massachusetts | 4493 | 6 | |
688035 | 688035 | 2020-11-01 | Unknown | Massachusetts | 4382 | 6 | |
684791 | 684791 | 2020-10-31 | Unknown | Massachusetts | 4380 | 6 | |
681548 | 681548 | 2020-10-30 | Unknown | Massachusetts | 4238 | 6 | |
678304 | 678304 | 2020-10-29 | Unknown | Massachusetts | 4126 | 6 | |
675062 | 675062 | 2020-10-28 | Unknown | Massachusetts | 4030 | 6 | |
671819 | 671819 | 2020-10-27 | Unknown | Massachusetts | 3995 | 6 | |
668577 | 668577 | 2020-10-26 | Unknown | Massachusetts | 3751 | 6 | |
665333 | 665333 | 2020-10-25 | Unknown | Massachusetts | 3746 | 6 | |
662088 | 662088 | 2020-10-24 | Unknown | Massachusetts | 3786 | 6 | |
658844 | 658844 | 2020-10-23 | Unknown | Massachusetts | 3693 | 6 | |
655599 | 655599 | 2020-10-22 | Unknown | Massachusetts | 3600 | 6 | |
652354 | 652354 | 2020-10-21 | Unknown | Massachusetts | 3537 | 6 | |
649109 | 649109 | 2020-10-20 | Unknown | Massachusetts | 3471 | 6 | |
645865 | 645865 | 2020-10-19 | Unknown | Massachusetts | 3303 | 6 | |
642618 | 642618 | 2020-10-18 | Unknown | Massachusetts | 3302 | 6 | |
639371 | 639371 | 2020-10-17 | Unknown | Massachusetts | 3316 | 6 | |
636125 | 636125 | 2020-10-16 | Unknown | Massachusetts | 3297 | 6 | |
632879 | 632879 | 2020-10-15 | Unknown | Massachusetts | 3217 | 6 | |
629634 | 629634 | 2020-10-14 | Unknown | Massachusetts | 3201 | 6 | |
626390 | 626390 | 2020-10-13 | Unknown | Massachusetts | 3145 | 6 | |
623148 | 623148 | 2020-10-12 | Unknown | Massachusetts | 3015 | 6 | |
619905 | 619905 | 2020-10-11 | Unknown | Massachusetts | 3033 | 6 | |
616663 | 616663 | 2020-10-10 | Unknown | Massachusetts | 3028 | 6 | |
613422 | 613422 | 2020-10-09 | Unknown | Massachusetts | 2981 | 6 | |
610180 | 610180 | 2020-10-08 | Unknown | Massachusetts | 2950 | 6 | |
606938 | 606938 | 2020-10-07 | Unknown | Massachusetts | 2919 | 6 | |
603695 | 603695 | 2020-10-06 | Unknown | Massachusetts | 2909 | 6 | |
600453 | 600453 | 2020-10-05 | Unknown | Massachusetts | 2864 | 5 |
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);