ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 23031 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194310 | 1194310 | 2021-04-06 | York | Maine | 23031 | 11045 | 127 |
1191061 | 1191061 | 2021-04-05 | York | Maine | 23031 | 10978 | 127 |
1187813 | 1187813 | 2021-04-04 | York | Maine | 23031 | 10937 | 127 |
1184566 | 1184566 | 2021-04-03 | York | Maine | 23031 | 10889 | 127 |
1181320 | 1181320 | 2021-04-02 | York | Maine | 23031 | 10803 | 127 |
1178073 | 1178073 | 2021-04-01 | York | Maine | 23031 | 10734 | 127 |
1174826 | 1174826 | 2021-03-31 | York | Maine | 23031 | 10676 | 126 |
1171579 | 1171579 | 2021-03-30 | York | Maine | 23031 | 10608 | 125 |
1168331 | 1168331 | 2021-03-29 | York | Maine | 23031 | 10560 | 125 |
1165083 | 1165083 | 2021-03-28 | York | Maine | 23031 | 10529 | 125 |
1161835 | 1161835 | 2021-03-27 | York | Maine | 23031 | 10475 | 125 |
1158587 | 1158587 | 2021-03-26 | York | Maine | 23031 | 10449 | 125 |
1155340 | 1155340 | 2021-03-25 | York | Maine | 23031 | 10371 | 125 |
1152093 | 1152093 | 2021-03-24 | York | Maine | 23031 | 10331 | 125 |
1148846 | 1148846 | 2021-03-23 | York | Maine | 23031 | 10292 | 125 |
1145599 | 1145599 | 2021-03-22 | York | Maine | 23031 | 10259 | 125 |
1142352 | 1142352 | 2021-03-21 | York | Maine | 23031 | 10223 | 125 |
1139105 | 1139105 | 2021-03-20 | York | Maine | 23031 | 10181 | 125 |
1135859 | 1135859 | 2021-03-19 | York | Maine | 23031 | 10140 | 125 |
1132613 | 1132613 | 2021-03-18 | York | Maine | 23031 | 10100 | 125 |
1129365 | 1129365 | 2021-03-17 | York | Maine | 23031 | 10065 | 125 |
1126118 | 1126118 | 2021-03-16 | York | Maine | 23031 | 10021 | 125 |
1122872 | 1122872 | 2021-03-15 | York | Maine | 23031 | 9983 | 125 |
1119625 | 1119625 | 2021-03-14 | York | Maine | 23031 | 9956 | 124 |
1116378 | 1116378 | 2021-03-13 | York | Maine | 23031 | 9926 | 124 |
1113132 | 1113132 | 2021-03-12 | York | Maine | 23031 | 9891 | 124 |
1109886 | 1109886 | 2021-03-11 | York | Maine | 23031 | 9850 | 124 |
1106640 | 1106640 | 2021-03-10 | York | Maine | 23031 | 9814 | 124 |
1103394 | 1103394 | 2021-03-09 | York | Maine | 23031 | 9771 | 124 |
1100148 | 1100148 | 2021-03-08 | York | Maine | 23031 | 9753 | 120 |
1096901 | 1096901 | 2021-03-07 | York | Maine | 23031 | 9733 | 120 |
1093654 | 1093654 | 2021-03-06 | York | Maine | 23031 | 9705 | 119 |
1090408 | 1090408 | 2021-03-05 | York | Maine | 23031 | 9674 | 119 |
1087163 | 1087163 | 2021-03-04 | York | Maine | 23031 | 9626 | 119 |
1083918 | 1083918 | 2021-03-03 | York | Maine | 23031 | 9593 | 119 |
1080672 | 1080672 | 2021-03-02 | York | Maine | 23031 | 9567 | 117 |
1077426 | 1077426 | 2021-03-01 | York | Maine | 23031 | 9534 | 117 |
1074180 | 1074180 | 2021-02-28 | York | Maine | 23031 | 9521 | 117 |
1070934 | 1070934 | 2021-02-27 | York | Maine | 23031 | 9501 | 117 |
1067689 | 1067689 | 2021-02-26 | York | Maine | 23031 | 9464 | 117 |
1064444 | 1064444 | 2021-02-25 | York | Maine | 23031 | 9419 | 116 |
1061200 | 1061200 | 2021-02-24 | York | Maine | 23031 | 9369 | 113 |
1057954 | 1057954 | 2021-02-23 | York | Maine | 23031 | 9324 | 110 |
1054708 | 1054708 | 2021-02-22 | York | Maine | 23031 | 9287 | 110 |
1051461 | 1051461 | 2021-02-21 | York | Maine | 23031 | 9266 | 110 |
1048214 | 1048214 | 2021-02-20 | York | Maine | 23031 | 9240 | 110 |
1044968 | 1044968 | 2021-02-19 | York | Maine | 23031 | 9203 | 110 |
1041723 | 1041723 | 2021-02-18 | York | Maine | 23031 | 9180 | 110 |
1038478 | 1038478 | 2021-02-17 | York | Maine | 23031 | 9134 | 110 |
1035233 | 1035233 | 2021-02-16 | York | Maine | 23031 | 9107 | 110 |
1031988 | 1031988 | 2021-02-15 | York | Maine | 23031 | 9082 | 109 |
1028741 | 1028741 | 2021-02-14 | York | Maine | 23031 | 9055 | 109 |
1025495 | 1025495 | 2021-02-13 | York | Maine | 23031 | 9032 | 109 |
1022250 | 1022250 | 2021-02-12 | York | Maine | 23031 | 9007 | 109 |
1019005 | 1019005 | 2021-02-11 | York | Maine | 23031 | 8963 | 109 |
1015760 | 1015760 | 2021-02-10 | York | Maine | 23031 | 8928 | 109 |
1012515 | 1012515 | 2021-02-09 | York | Maine | 23031 | 8855 | 109 |
1009270 | 1009270 | 2021-02-08 | York | Maine | 23031 | 8814 | 109 |
1006023 | 1006023 | 2021-02-07 | York | Maine | 23031 | 8781 | 109 |
1002777 | 1002777 | 2021-02-06 | York | Maine | 23031 | 8740 | 108 |
999532 | 999532 | 2021-02-05 | York | Maine | 23031 | 8680 | 107 |
996286 | 996286 | 2021-02-04 | York | Maine | 23031 | 8620 | 107 |
993040 | 993040 | 2021-02-03 | York | Maine | 23031 | 8584 | 106 |
989794 | 989794 | 2021-02-02 | York | Maine | 23031 | 8533 | 103 |
986547 | 986547 | 2021-02-01 | York | Maine | 23031 | 8452 | 100 |
983300 | 983300 | 2021-01-31 | York | Maine | 23031 | 8429 | 100 |
980054 | 980054 | 2021-01-30 | York | Maine | 23031 | 8389 | 100 |
976808 | 976808 | 2021-01-29 | York | Maine | 23031 | 8310 | 97 |
973563 | 973563 | 2021-01-28 | York | Maine | 23031 | 8259 | 97 |
970318 | 970318 | 2021-01-27 | York | Maine | 23031 | 8179 | 97 |
967073 | 967073 | 2021-01-26 | York | Maine | 23031 | 8118 | 97 |
963829 | 963829 | 2021-01-25 | York | Maine | 23031 | 7990 | 97 |
960584 | 960584 | 2021-01-24 | York | Maine | 23031 | 7892 | 96 |
957338 | 957338 | 2021-01-23 | York | Maine | 23031 | 7892 | 96 |
954093 | 954093 | 2021-01-22 | York | Maine | 23031 | 7827 | 96 |
950848 | 950848 | 2021-01-21 | York | Maine | 23031 | 7723 | 96 |
947602 | 947602 | 2021-01-20 | York | Maine | 23031 | 7516 | 95 |
944355 | 944355 | 2021-01-19 | York | Maine | 23031 | 7393 | 94 |
941110 | 941110 | 2021-01-18 | York | Maine | 23031 | 7354 | 93 |
937865 | 937865 | 2021-01-17 | York | Maine | 23031 | 7296 | 93 |
934620 | 934620 | 2021-01-16 | York | Maine | 23031 | 7222 | 92 |
931375 | 931375 | 2021-01-15 | York | Maine | 23031 | 7125 | 87 |
928130 | 928130 | 2021-01-14 | York | Maine | 23031 | 6973 | 87 |
924884 | 924884 | 2021-01-13 | York | Maine | 23031 | 6788 | 85 |
921639 | 921639 | 2021-01-12 | York | Maine | 23031 | 6590 | 83 |
918394 | 918394 | 2021-01-11 | York | Maine | 23031 | 6474 | 82 |
915149 | 915149 | 2021-01-10 | York | Maine | 23031 | 6389 | 80 |
911904 | 911904 | 2021-01-09 | York | Maine | 23031 | 6308 | 80 |
908659 | 908659 | 2021-01-08 | York | Maine | 23031 | 6170 | 78 |
905413 | 905413 | 2021-01-07 | York | Maine | 23031 | 5888 | 72 |
902168 | 902168 | 2021-01-06 | York | Maine | 23031 | 5837 | 68 |
898923 | 898923 | 2021-01-05 | York | Maine | 23031 | 5730 | 68 |
895678 | 895678 | 2021-01-04 | York | Maine | 23031 | 5567 | 65 |
892431 | 892431 | 2021-01-03 | York | Maine | 23031 | 5443 | 64 |
889185 | 889185 | 2021-01-02 | York | Maine | 23031 | 5345 | 64 |
885939 | 885939 | 2021-01-01 | York | Maine | 23031 | 5030 | 63 |
882694 | 882694 | 2020-12-31 | York | Maine | 23031 | 5030 | 63 |
879449 | 879449 | 2020-12-30 | York | Maine | 23031 | 4815 | 61 |
876204 | 876204 | 2020-12-29 | York | Maine | 23031 | 4703 | 60 |
872959 | 872959 | 2020-12-28 | York | Maine | 23031 | 4574 | 59 |
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);