ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 23025 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418327 | 1418327 | 2021-06-14 | Somerset | Maine | 23025 | 2264 | 33 |
1415081 | 1415081 | 2021-06-13 | Somerset | Maine | 23025 | 2260 | 33 |
1411836 | 1411836 | 2021-06-12 | Somerset | Maine | 23025 | 2257 | 33 |
1408591 | 1408591 | 2021-06-11 | Somerset | Maine | 23025 | 2253 | 33 |
1405345 | 1405345 | 2021-06-10 | Somerset | Maine | 23025 | 2252 | 33 |
1402100 | 1402100 | 2021-06-09 | Somerset | Maine | 23025 | 2249 | 33 |
1398855 | 1398855 | 2021-06-08 | Somerset | Maine | 23025 | 2247 | 33 |
1395608 | 1395608 | 2021-06-07 | Somerset | Maine | 23025 | 2241 | 33 |
1392363 | 1392363 | 2021-06-06 | Somerset | Maine | 23025 | 2239 | 33 |
1389118 | 1389118 | 2021-06-05 | Somerset | Maine | 23025 | 2229 | 33 |
1385873 | 1385873 | 2021-06-04 | Somerset | Maine | 23025 | 2216 | 33 |
1382627 | 1382627 | 2021-06-03 | Somerset | Maine | 23025 | 2204 | 33 |
1379382 | 1379382 | 2021-06-02 | Somerset | Maine | 23025 | 2190 | 32 |
1376136 | 1376136 | 2021-06-01 | Somerset | Maine | 23025 | 2189 | 31 |
1372891 | 1372891 | 2021-05-31 | Somerset | Maine | 23025 | 2185 | 31 |
1369646 | 1369646 | 2021-05-30 | Somerset | Maine | 23025 | 2181 | 31 |
1366400 | 1366400 | 2021-05-29 | Somerset | Maine | 23025 | 2178 | 31 |
1363154 | 1363154 | 2021-05-28 | Somerset | Maine | 23025 | 2175 | 31 |
1359907 | 1359907 | 2021-05-27 | Somerset | Maine | 23025 | 2173 | 31 |
1356661 | 1356661 | 2021-05-26 | Somerset | Maine | 23025 | 2169 | 31 |
1353415 | 1353415 | 2021-05-25 | Somerset | Maine | 23025 | 2166 | 31 |
1350169 | 1350169 | 2021-05-24 | Somerset | Maine | 23025 | 2165 | 30 |
1346922 | 1346922 | 2021-05-23 | Somerset | Maine | 23025 | 2158 | 30 |
1343674 | 1343674 | 2021-05-22 | Somerset | Maine | 23025 | 2148 | 30 |
1340426 | 1340426 | 2021-05-21 | Somerset | Maine | 23025 | 2140 | 30 |
1337179 | 1337179 | 2021-05-20 | Somerset | Maine | 23025 | 2134 | 30 |
1333932 | 1333932 | 2021-05-19 | Somerset | Maine | 23025 | 2117 | 30 |
1330685 | 1330685 | 2021-05-18 | Somerset | Maine | 23025 | 2107 | 30 |
1327438 | 1327438 | 2021-05-17 | Somerset | Maine | 23025 | 2102 | 30 |
1324192 | 1324192 | 2021-05-16 | Somerset | Maine | 23025 | 2092 | 30 |
1320946 | 1320946 | 2021-05-15 | Somerset | Maine | 23025 | 2080 | 30 |
1317699 | 1317699 | 2021-05-14 | Somerset | Maine | 23025 | 2073 | 30 |
1314452 | 1314452 | 2021-05-13 | Somerset | Maine | 23025 | 2065 | 30 |
1311205 | 1311205 | 2021-05-12 | Somerset | Maine | 23025 | 2047 | 30 |
1307959 | 1307959 | 2021-05-11 | Somerset | Maine | 23025 | 2029 | 30 |
1304713 | 1304713 | 2021-05-10 | Somerset | Maine | 23025 | 2018 | 29 |
1301466 | 1301466 | 2021-05-09 | Somerset | Maine | 23025 | 2013 | 29 |
1298219 | 1298219 | 2021-05-08 | Somerset | Maine | 23025 | 2003 | 29 |
1294973 | 1294973 | 2021-05-07 | Somerset | Maine | 23025 | 1990 | 29 |
1291727 | 1291727 | 2021-05-06 | Somerset | Maine | 23025 | 1974 | 29 |
1288481 | 1288481 | 2021-05-05 | Somerset | Maine | 23025 | 1962 | 29 |
1285235 | 1285235 | 2021-05-04 | Somerset | Maine | 23025 | 1951 | 29 |
1281988 | 1281988 | 2021-05-03 | Somerset | Maine | 23025 | 1930 | 29 |
1278741 | 1278741 | 2021-05-02 | Somerset | Maine | 23025 | 1911 | 29 |
1275494 | 1275494 | 2021-05-01 | Somerset | Maine | 23025 | 1897 | 29 |
1272247 | 1272247 | 2021-04-30 | Somerset | Maine | 23025 | 1868 | 29 |
1269000 | 1269000 | 2021-04-29 | Somerset | Maine | 23025 | 1860 | 29 |
1265753 | 1265753 | 2021-04-28 | Somerset | Maine | 23025 | 1851 | 29 |
1262506 | 1262506 | 2021-04-27 | Somerset | Maine | 23025 | 1843 | 29 |
1259259 | 1259259 | 2021-04-26 | Somerset | Maine | 23025 | 1821 | 29 |
1256012 | 1256012 | 2021-04-25 | Somerset | Maine | 23025 | 1812 | 29 |
1252765 | 1252765 | 2021-04-24 | Somerset | Maine | 23025 | 1804 | 29 |
1249518 | 1249518 | 2021-04-23 | Somerset | Maine | 23025 | 1792 | 29 |
1246271 | 1246271 | 2021-04-22 | Somerset | Maine | 23025 | 1772 | 29 |
1243024 | 1243024 | 2021-04-21 | Somerset | Maine | 23025 | 1734 | 29 |
1239777 | 1239777 | 2021-04-20 | Somerset | Maine | 23025 | 1726 | 29 |
1236530 | 1236530 | 2021-04-19 | Somerset | Maine | 23025 | 1691 | 29 |
1233283 | 1233283 | 2021-04-18 | Somerset | Maine | 23025 | 1687 | 29 |
1230035 | 1230035 | 2021-04-17 | Somerset | Maine | 23025 | 1657 | 29 |
1226787 | 1226787 | 2021-04-16 | Somerset | Maine | 23025 | 1640 | 29 |
1223540 | 1223540 | 2021-04-15 | Somerset | Maine | 23025 | 1610 | 28 |
1220292 | 1220292 | 2021-04-14 | Somerset | Maine | 23025 | 1573 | 28 |
1217044 | 1217044 | 2021-04-13 | Somerset | Maine | 23025 | 1558 | 28 |
1213797 | 1213797 | 2021-04-12 | Somerset | Maine | 23025 | 1536 | 28 |
1210549 | 1210549 | 2021-04-11 | Somerset | Maine | 23025 | 1526 | 28 |
1207300 | 1207300 | 2021-04-10 | Somerset | Maine | 23025 | 1521 | 28 |
1204052 | 1204052 | 2021-04-09 | Somerset | Maine | 23025 | 1505 | 28 |
1200804 | 1200804 | 2021-04-08 | Somerset | Maine | 23025 | 1490 | 28 |
1197555 | 1197555 | 2021-04-07 | Somerset | Maine | 23025 | 1466 | 28 |
1194307 | 1194307 | 2021-04-06 | Somerset | Maine | 23025 | 1456 | 28 |
1191057 | 1191057 | 2021-04-05 | Somerset | Maine | 23025 | 1443 | 28 |
1187810 | 1187810 | 2021-04-04 | Somerset | Maine | 23025 | 1434 | 28 |
1184563 | 1184563 | 2021-04-03 | Somerset | Maine | 23025 | 1426 | 28 |
1181316 | 1181316 | 2021-04-02 | Somerset | Maine | 23025 | 1414 | 27 |
1178069 | 1178069 | 2021-04-01 | Somerset | Maine | 23025 | 1399 | 27 |
1174822 | 1174822 | 2021-03-31 | Somerset | Maine | 23025 | 1375 | 27 |
1171575 | 1171575 | 2021-03-30 | Somerset | Maine | 23025 | 1369 | 27 |
1168327 | 1168327 | 2021-03-29 | Somerset | Maine | 23025 | 1365 | 27 |
1165079 | 1165079 | 2021-03-28 | Somerset | Maine | 23025 | 1356 | 27 |
1161831 | 1161831 | 2021-03-27 | Somerset | Maine | 23025 | 1353 | 27 |
1158583 | 1158583 | 2021-03-26 | Somerset | Maine | 23025 | 1341 | 27 |
1155336 | 1155336 | 2021-03-25 | Somerset | Maine | 23025 | 1336 | 27 |
1152089 | 1152089 | 2021-03-24 | Somerset | Maine | 23025 | 1328 | 27 |
1148842 | 1148842 | 2021-03-23 | Somerset | Maine | 23025 | 1326 | 27 |
1145595 | 1145595 | 2021-03-22 | Somerset | Maine | 23025 | 1322 | 27 |
1142348 | 1142348 | 2021-03-21 | Somerset | Maine | 23025 | 1317 | 27 |
1139102 | 1139102 | 2021-03-20 | Somerset | Maine | 23025 | 1315 | 27 |
1135856 | 1135856 | 2021-03-19 | Somerset | Maine | 23025 | 1307 | 27 |
1132609 | 1132609 | 2021-03-18 | Somerset | Maine | 23025 | 1305 | 27 |
1129361 | 1129361 | 2021-03-17 | Somerset | Maine | 23025 | 1302 | 27 |
1126115 | 1126115 | 2021-03-16 | Somerset | Maine | 23025 | 1301 | 27 |
1122869 | 1122869 | 2021-03-15 | Somerset | Maine | 23025 | 1297 | 27 |
1119622 | 1119622 | 2021-03-14 | Somerset | Maine | 23025 | 1294 | 27 |
1116375 | 1116375 | 2021-03-13 | Somerset | Maine | 23025 | 1290 | 27 |
1113129 | 1113129 | 2021-03-12 | Somerset | Maine | 23025 | 1283 | 27 |
1109883 | 1109883 | 2021-03-11 | Somerset | Maine | 23025 | 1283 | 27 |
1106637 | 1106637 | 2021-03-10 | Somerset | Maine | 23025 | 1274 | 27 |
1103391 | 1103391 | 2021-03-09 | Somerset | Maine | 23025 | 1269 | 27 |
1100145 | 1100145 | 2021-03-08 | Somerset | Maine | 23025 | 1266 | 27 |
1096897 | 1096897 | 2021-03-07 | Somerset | Maine | 23025 | 1265 | 27 |
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);