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 |
---|---|---|---|---|---|---|---|
1194349 | 1194349 | 2021-04-06 | Unknown | Massachusetts | 39707 | 12 | |
1191100 | 1191100 | 2021-04-05 | Unknown | Massachusetts | 39465 | 12 | |
1187852 | 1187852 | 2021-04-04 | Unknown | Massachusetts | 39383 | 12 | |
1184605 | 1184605 | 2021-04-03 | Unknown | Massachusetts | 39383 | 12 | |
1181359 | 1181359 | 2021-04-02 | Unknown | Massachusetts | 39220 | 12 | |
1178112 | 1178112 | 2021-04-01 | Unknown | Massachusetts | 38934 | 12 | |
1174865 | 1174865 | 2021-03-31 | Unknown | Massachusetts | 38639 | 12 | |
1171618 | 1171618 | 2021-03-30 | Unknown | Massachusetts | 38389 | 12 | |
1168370 | 1168370 | 2021-03-29 | Unknown | Massachusetts | 38030 | 12 | |
1165122 | 1165122 | 2021-03-28 | Unknown | Massachusetts | 37995 | 12 | |
1161874 | 1161874 | 2021-03-27 | Unknown | Massachusetts | 37827 | 12 | |
1158626 | 1158626 | 2021-03-26 | Unknown | Massachusetts | 37623 | 12 | |
1155379 | 1155379 | 2021-03-25 | Unknown | Massachusetts | 37179 | 12 | |
1152132 | 1152132 | 2021-03-24 | Unknown | Massachusetts | 37064 | 12 | |
1148885 | 1148885 | 2021-03-23 | Unknown | Massachusetts | 36787 | 12 | |
1145638 | 1145638 | 2021-03-22 | Unknown | Massachusetts | 36441 | 10 | |
1142391 | 1142391 | 2021-03-21 | Unknown | Massachusetts | 36336 | 10 | |
1139144 | 1139144 | 2021-03-20 | Unknown | Massachusetts | 36206 | 10 | |
1135898 | 1135898 | 2021-03-19 | Unknown | Massachusetts | 35710 | 10 | |
1132652 | 1132652 | 2021-03-18 | Unknown | Massachusetts | 35464 | 10 | |
1129404 | 1129404 | 2021-03-17 | Unknown | Massachusetts | 35394 | 10 | |
1126157 | 1126157 | 2021-03-16 | Unknown | Massachusetts | 35372 | 9 | |
1122911 | 1122911 | 2021-03-15 | Unknown | Massachusetts | 35192 | 9 | |
1119664 | 1119664 | 2021-03-14 | Unknown | Massachusetts | 35076 | 9 | |
1116417 | 1116417 | 2021-03-13 | Unknown | Massachusetts | 34888 | 9 | |
1113171 | 1113171 | 2021-03-12 | Unknown | Massachusetts | 34687 | 9 | |
1109925 | 1109925 | 2021-03-11 | Unknown | Massachusetts | 34547 | 9 | |
1106679 | 1106679 | 2021-03-10 | Unknown | Massachusetts | 34329 | 9 | |
1103433 | 1103433 | 2021-03-09 | Unknown | Massachusetts | 34086 | 9 | |
1100187 | 1100187 | 2021-03-08 | Unknown | Massachusetts | 33825 | 9 | |
1096940 | 1096940 | 2021-03-07 | Unknown | Massachusetts | 33735 | 9 | |
1093693 | 1093693 | 2021-03-06 | Unknown | Massachusetts | 33585 | 9 | |
1090447 | 1090447 | 2021-03-05 | Unknown | Massachusetts | 33365 | 9 | |
1087202 | 1087202 | 2021-03-04 | Unknown | Massachusetts | 33137 | 9 | |
1083957 | 1083957 | 2021-03-03 | Unknown | Massachusetts | 33007 | 8 | |
1080711 | 1080711 | 2021-03-02 | Unknown | Massachusetts | 32661 | 8 | |
1077465 | 1077465 | 2021-03-01 | Unknown | Massachusetts | 32486 | 8 | |
1074219 | 1074219 | 2021-02-28 | Unknown | Massachusetts | 32332 | 8 | |
1070973 | 1070973 | 2021-02-27 | Unknown | Massachusetts | 32294 | 8 | |
1067728 | 1067728 | 2021-02-26 | Unknown | Massachusetts | 32109 | 8 | |
1064483 | 1064483 | 2021-02-25 | Unknown | Massachusetts | 31855 | 8 | |
1061239 | 1061239 | 2021-02-24 | Unknown | Massachusetts | 31673 | 8 | |
1057993 | 1057993 | 2021-02-23 | Unknown | Massachusetts | 31361 | 8 | |
1054747 | 1054747 | 2021-02-22 | Unknown | Massachusetts | 31247 | 8 | |
1051500 | 1051500 | 2021-02-21 | Unknown | Massachusetts | 31135 | 8 | |
1048253 | 1048253 | 2021-02-20 | Unknown | Massachusetts | 30920 | 8 | |
1045007 | 1045007 | 2021-02-19 | Unknown | Massachusetts | 30772 | 8 | |
1041762 | 1041762 | 2021-02-18 | Unknown | Massachusetts | 30631 | 8 | |
1038517 | 1038517 | 2021-02-17 | Unknown | Massachusetts | 30393 | 8 | |
1035272 | 1035272 | 2021-02-16 | Unknown | Massachusetts | 30351 | 8 | |
1032027 | 1032027 | 2021-02-15 | Unknown | Massachusetts | 30089 | 8 | |
1028780 | 1028780 | 2021-02-14 | Unknown | Massachusetts | 29993 | 8 | |
1025534 | 1025534 | 2021-02-13 | Unknown | Massachusetts | 29932 | 8 | |
1022289 | 1022289 | 2021-02-12 | Unknown | Massachusetts | 29810 | 8 | |
1019044 | 1019044 | 2021-02-11 | Unknown | Massachusetts | 29598 | 8 | |
1015799 | 1015799 | 2021-02-10 | Unknown | Massachusetts | 29380 | 8 | |
1012554 | 1012554 | 2021-02-09 | Unknown | Massachusetts | 29225 | 8 | |
1009309 | 1009309 | 2021-02-08 | Unknown | Massachusetts | 28959 | 8 | |
1006062 | 1006062 | 2021-02-07 | Unknown | Massachusetts | 28870 | 8 | |
1002816 | 1002816 | 2021-02-06 | Unknown | Massachusetts | 28751 | 8 | |
999571 | 999571 | 2021-02-05 | Unknown | Massachusetts | 28532 | 8 | |
996325 | 996325 | 2021-02-04 | Unknown | Massachusetts | 28202 | 8 | |
993079 | 993079 | 2021-02-03 | Unknown | Massachusetts | 28001 | 8 | |
989833 | 989833 | 2021-02-02 | Unknown | Massachusetts | 27733 | 8 | |
986586 | 986586 | 2021-02-01 | Unknown | Massachusetts | 27487 | 8 | |
983339 | 983339 | 2021-01-31 | Unknown | Massachusetts | 27356 | 8 | |
980093 | 980093 | 2021-01-30 | Unknown | Massachusetts | 27214 | 8 | |
976847 | 976847 | 2021-01-29 | Unknown | Massachusetts | 27059 | 8 | |
973602 | 973602 | 2021-01-28 | Unknown | Massachusetts | 26715 | 8 | |
970357 | 970357 | 2021-01-27 | Unknown | Massachusetts | 26297 | 9 | |
967112 | 967112 | 2021-01-26 | Unknown | Massachusetts | 26007 | 9 | |
963868 | 963868 | 2021-01-25 | Unknown | Massachusetts | 25718 | 8 | |
960623 | 960623 | 2021-01-24 | Unknown | Massachusetts | 25561 | 8 | |
957377 | 957377 | 2021-01-23 | Unknown | Massachusetts | 25329 | 8 | |
954132 | 954132 | 2021-01-22 | Unknown | Massachusetts | 25043 | 8 | |
950887 | 950887 | 2021-01-21 | Unknown | Massachusetts | 24652 | 8 | |
947641 | 947641 | 2021-01-20 | Unknown | Massachusetts | 24360 | 8 | |
944394 | 944394 | 2021-01-19 | Unknown | Massachusetts | 23759 | 8 | |
941149 | 941149 | 2021-01-18 | Unknown | Massachusetts | 23252 | 8 | |
937904 | 937904 | 2021-01-17 | Unknown | Massachusetts | 23157 | 8 | |
934659 | 934659 | 2021-01-16 | Unknown | Massachusetts | 23020 | 8 | |
931414 | 931414 | 2021-01-15 | Unknown | Massachusetts | 22876 | 8 | |
928169 | 928169 | 2021-01-14 | Unknown | Massachusetts | 22400 | 8 | |
924923 | 924923 | 2021-01-13 | Unknown | Massachusetts | 22030 | 8 | |
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 |
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);