ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Sagadahoc" and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194306 | 1194306 | 2021-04-06 | Sagadahoc | Maine | 23023 | 1027 | 6 |
1191056 | 1191056 | 2021-04-05 | Sagadahoc | Maine | 23023 | 1020 | 6 |
1187809 | 1187809 | 2021-04-04 | Sagadahoc | Maine | 23023 | 1009 | 6 |
1184562 | 1184562 | 2021-04-03 | Sagadahoc | Maine | 23023 | 998 | 6 |
1181315 | 1181315 | 2021-04-02 | Sagadahoc | Maine | 23023 | 993 | 6 |
1178068 | 1178068 | 2021-04-01 | Sagadahoc | Maine | 23023 | 985 | 6 |
1174821 | 1174821 | 2021-03-31 | Sagadahoc | Maine | 23023 | 979 | 6 |
1171574 | 1171574 | 2021-03-30 | Sagadahoc | Maine | 23023 | 977 | 6 |
1168326 | 1168326 | 2021-03-29 | Sagadahoc | Maine | 23023 | 969 | 6 |
1165078 | 1165078 | 2021-03-28 | Sagadahoc | Maine | 23023 | 966 | 6 |
1161830 | 1161830 | 2021-03-27 | Sagadahoc | Maine | 23023 | 962 | 6 |
1158582 | 1158582 | 2021-03-26 | Sagadahoc | Maine | 23023 | 958 | 6 |
1155335 | 1155335 | 2021-03-25 | Sagadahoc | Maine | 23023 | 954 | 6 |
1152088 | 1152088 | 2021-03-24 | Sagadahoc | Maine | 23023 | 950 | 6 |
1148841 | 1148841 | 2021-03-23 | Sagadahoc | Maine | 23023 | 946 | 6 |
1145594 | 1145594 | 2021-03-22 | Sagadahoc | Maine | 23023 | 942 | 6 |
1142347 | 1142347 | 2021-03-21 | Sagadahoc | Maine | 23023 | 938 | 6 |
1139101 | 1139101 | 2021-03-20 | Sagadahoc | Maine | 23023 | 937 | 6 |
1135855 | 1135855 | 2021-03-19 | Sagadahoc | Maine | 23023 | 935 | 6 |
1132608 | 1132608 | 2021-03-18 | Sagadahoc | Maine | 23023 | 934 | 6 |
1129360 | 1129360 | 2021-03-17 | Sagadahoc | Maine | 23023 | 925 | 6 |
1126114 | 1126114 | 2021-03-16 | Sagadahoc | Maine | 23023 | 918 | 6 |
1122868 | 1122868 | 2021-03-15 | Sagadahoc | Maine | 23023 | 916 | 6 |
1119621 | 1119621 | 2021-03-14 | Sagadahoc | Maine | 23023 | 911 | 6 |
1116374 | 1116374 | 2021-03-13 | Sagadahoc | Maine | 23023 | 911 | 6 |
1113128 | 1113128 | 2021-03-12 | Sagadahoc | Maine | 23023 | 907 | 6 |
1109882 | 1109882 | 2021-03-11 | Sagadahoc | Maine | 23023 | 903 | 6 |
1106636 | 1106636 | 2021-03-10 | Sagadahoc | Maine | 23023 | 903 | 6 |
1103390 | 1103390 | 2021-03-09 | Sagadahoc | Maine | 23023 | 898 | 6 |
1100144 | 1100144 | 2021-03-08 | Sagadahoc | Maine | 23023 | 896 | 5 |
1096896 | 1096896 | 2021-03-07 | Sagadahoc | Maine | 23023 | 894 | 5 |
1093650 | 1093650 | 2021-03-06 | Sagadahoc | Maine | 23023 | 893 | 5 |
1090404 | 1090404 | 2021-03-05 | Sagadahoc | Maine | 23023 | 891 | 5 |
1087159 | 1087159 | 2021-03-04 | Sagadahoc | Maine | 23023 | 890 | 5 |
1083913 | 1083913 | 2021-03-03 | Sagadahoc | Maine | 23023 | 890 | 5 |
1080667 | 1080667 | 2021-03-02 | Sagadahoc | Maine | 23023 | 887 | 5 |
1077422 | 1077422 | 2021-03-01 | Sagadahoc | Maine | 23023 | 887 | 5 |
1074176 | 1074176 | 2021-02-28 | Sagadahoc | Maine | 23023 | 886 | 5 |
1070930 | 1070930 | 2021-02-27 | Sagadahoc | Maine | 23023 | 884 | 5 |
1067685 | 1067685 | 2021-02-26 | Sagadahoc | Maine | 23023 | 883 | 5 |
1064440 | 1064440 | 2021-02-25 | Sagadahoc | Maine | 23023 | 880 | 5 |
1061195 | 1061195 | 2021-02-24 | Sagadahoc | Maine | 23023 | 873 | 3 |
1057949 | 1057949 | 2021-02-23 | Sagadahoc | Maine | 23023 | 870 | 1 |
1054703 | 1054703 | 2021-02-22 | Sagadahoc | Maine | 23023 | 867 | 1 |
1051456 | 1051456 | 2021-02-21 | Sagadahoc | Maine | 23023 | 865 | 1 |
1048209 | 1048209 | 2021-02-20 | Sagadahoc | Maine | 23023 | 865 | 1 |
1044964 | 1044964 | 2021-02-19 | Sagadahoc | Maine | 23023 | 862 | 1 |
1041719 | 1041719 | 2021-02-18 | Sagadahoc | Maine | 23023 | 857 | 1 |
1038474 | 1038474 | 2021-02-17 | Sagadahoc | Maine | 23023 | 852 | 1 |
1035229 | 1035229 | 2021-02-16 | Sagadahoc | Maine | 23023 | 851 | 1 |
1031983 | 1031983 | 2021-02-15 | Sagadahoc | Maine | 23023 | 848 | 1 |
1028736 | 1028736 | 2021-02-14 | Sagadahoc | Maine | 23023 | 848 | 1 |
1025491 | 1025491 | 2021-02-13 | Sagadahoc | Maine | 23023 | 847 | 1 |
1022246 | 1022246 | 2021-02-12 | Sagadahoc | Maine | 23023 | 846 | 1 |
1019001 | 1019001 | 2021-02-11 | Sagadahoc | Maine | 23023 | 845 | 1 |
1015756 | 1015756 | 2021-02-10 | Sagadahoc | Maine | 23023 | 841 | 1 |
1012511 | 1012511 | 2021-02-09 | Sagadahoc | Maine | 23023 | 838 | 1 |
1009265 | 1009265 | 2021-02-08 | Sagadahoc | Maine | 23023 | 833 | 1 |
1006019 | 1006019 | 2021-02-07 | Sagadahoc | Maine | 23023 | 833 | 1 |
1002773 | 1002773 | 2021-02-06 | Sagadahoc | Maine | 23023 | 832 | 1 |
999527 | 999527 | 2021-02-05 | Sagadahoc | Maine | 23023 | 831 | 1 |
996281 | 996281 | 2021-02-04 | Sagadahoc | Maine | 23023 | 819 | 1 |
993035 | 993035 | 2021-02-03 | Sagadahoc | Maine | 23023 | 812 | 1 |
989789 | 989789 | 2021-02-02 | Sagadahoc | Maine | 23023 | 809 | 1 |
986542 | 986542 | 2021-02-01 | Sagadahoc | Maine | 23023 | 787 | 1 |
983295 | 983295 | 2021-01-31 | Sagadahoc | Maine | 23023 | 776 | 1 |
980049 | 980049 | 2021-01-30 | Sagadahoc | Maine | 23023 | 772 | 1 |
976803 | 976803 | 2021-01-29 | Sagadahoc | Maine | 23023 | 768 | 1 |
973558 | 973558 | 2021-01-28 | Sagadahoc | Maine | 23023 | 753 | 1 |
970313 | 970313 | 2021-01-27 | Sagadahoc | Maine | 23023 | 743 | 1 |
967069 | 967069 | 2021-01-26 | Sagadahoc | Maine | 23023 | 729 | 1 |
963824 | 963824 | 2021-01-25 | Sagadahoc | Maine | 23023 | 703 | 1 |
960579 | 960579 | 2021-01-24 | Sagadahoc | Maine | 23023 | 695 | 1 |
957333 | 957333 | 2021-01-23 | Sagadahoc | Maine | 23023 | 695 | 1 |
954088 | 954088 | 2021-01-22 | Sagadahoc | Maine | 23023 | 687 | 1 |
950843 | 950843 | 2021-01-21 | Sagadahoc | Maine | 23023 | 671 | 1 |
947597 | 947597 | 2021-01-20 | Sagadahoc | Maine | 23023 | 653 | 1 |
944350 | 944350 | 2021-01-19 | Sagadahoc | Maine | 23023 | 626 | 1 |
941105 | 941105 | 2021-01-18 | Sagadahoc | Maine | 23023 | 620 | 1 |
937860 | 937860 | 2021-01-17 | Sagadahoc | Maine | 23023 | 614 | 1 |
934615 | 934615 | 2021-01-16 | Sagadahoc | Maine | 23023 | 613 | 1 |
931370 | 931370 | 2021-01-15 | Sagadahoc | Maine | 23023 | 589 | 1 |
928125 | 928125 | 2021-01-14 | Sagadahoc | Maine | 23023 | 575 | 1 |
924879 | 924879 | 2021-01-13 | Sagadahoc | Maine | 23023 | 568 | 1 |
921634 | 921634 | 2021-01-12 | Sagadahoc | Maine | 23023 | 539 | 1 |
918389 | 918389 | 2021-01-11 | Sagadahoc | Maine | 23023 | 510 | 1 |
915144 | 915144 | 2021-01-10 | Sagadahoc | Maine | 23023 | 506 | 1 |
911899 | 911899 | 2021-01-09 | Sagadahoc | Maine | 23023 | 502 | 1 |
908654 | 908654 | 2021-01-08 | Sagadahoc | Maine | 23023 | 489 | 1 |
905408 | 905408 | 2021-01-07 | Sagadahoc | Maine | 23023 | 461 | 1 |
902163 | 902163 | 2021-01-06 | Sagadahoc | Maine | 23023 | 433 | 1 |
898918 | 898918 | 2021-01-05 | Sagadahoc | Maine | 23023 | 430 | 1 |
895673 | 895673 | 2021-01-04 | Sagadahoc | Maine | 23023 | 415 | 1 |
892426 | 892426 | 2021-01-03 | Sagadahoc | Maine | 23023 | 404 | 1 |
889180 | 889180 | 2021-01-02 | Sagadahoc | Maine | 23023 | 389 | 1 |
885934 | 885934 | 2021-01-01 | Sagadahoc | Maine | 23023 | 387 | 1 |
882689 | 882689 | 2020-12-31 | Sagadahoc | Maine | 23023 | 387 | 1 |
879444 | 879444 | 2020-12-30 | Sagadahoc | Maine | 23023 | 367 | 1 |
876199 | 876199 | 2020-12-29 | Sagadahoc | Maine | 23023 | 363 | 1 |
872954 | 872954 | 2020-12-28 | Sagadahoc | Maine | 23023 | 354 | 1 |
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);