ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where fips = 23021 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418325 | 1418325 | 2021-06-14 | Piscataquis | Maine | 23021 | 575 | 6 |
1415079 | 1415079 | 2021-06-13 | Piscataquis | Maine | 23021 | 574 | 6 |
1411834 | 1411834 | 2021-06-12 | Piscataquis | Maine | 23021 | 573 | 6 |
1408589 | 1408589 | 2021-06-11 | Piscataquis | Maine | 23021 | 572 | 6 |
1405343 | 1405343 | 2021-06-10 | Piscataquis | Maine | 23021 | 572 | 6 |
1402098 | 1402098 | 2021-06-09 | Piscataquis | Maine | 23021 | 572 | 6 |
1398853 | 1398853 | 2021-06-08 | Piscataquis | Maine | 23021 | 572 | 6 |
1395606 | 1395606 | 2021-06-07 | Piscataquis | Maine | 23021 | 572 | 6 |
1392361 | 1392361 | 2021-06-06 | Piscataquis | Maine | 23021 | 572 | 6 |
1389116 | 1389116 | 2021-06-05 | Piscataquis | Maine | 23021 | 572 | 6 |
1385871 | 1385871 | 2021-06-04 | Piscataquis | Maine | 23021 | 572 | 6 |
1382625 | 1382625 | 2021-06-03 | Piscataquis | Maine | 23021 | 572 | 6 |
1379380 | 1379380 | 2021-06-02 | Piscataquis | Maine | 23021 | 571 | 6 |
1376134 | 1376134 | 2021-06-01 | Piscataquis | Maine | 23021 | 570 | 6 |
1372889 | 1372889 | 2021-05-31 | Piscataquis | Maine | 23021 | 569 | 6 |
1369644 | 1369644 | 2021-05-30 | Piscataquis | Maine | 23021 | 568 | 6 |
1366398 | 1366398 | 2021-05-29 | Piscataquis | Maine | 23021 | 565 | 6 |
1363152 | 1363152 | 2021-05-28 | Piscataquis | Maine | 23021 | 562 | 6 |
1359905 | 1359905 | 2021-05-27 | Piscataquis | Maine | 23021 | 555 | 6 |
1356659 | 1356659 | 2021-05-26 | Piscataquis | Maine | 23021 | 555 | 6 |
1353413 | 1353413 | 2021-05-25 | Piscataquis | Maine | 23021 | 548 | 6 |
1350167 | 1350167 | 2021-05-24 | Piscataquis | Maine | 23021 | 547 | 6 |
1346920 | 1346920 | 2021-05-23 | Piscataquis | Maine | 23021 | 541 | 6 |
1343672 | 1343672 | 2021-05-22 | Piscataquis | Maine | 23021 | 540 | 6 |
1340424 | 1340424 | 2021-05-21 | Piscataquis | Maine | 23021 | 536 | 6 |
1337177 | 1337177 | 2021-05-20 | Piscataquis | Maine | 23021 | 535 | 6 |
1333930 | 1333930 | 2021-05-19 | Piscataquis | Maine | 23021 | 531 | 6 |
1330683 | 1330683 | 2021-05-18 | Piscataquis | Maine | 23021 | 530 | 6 |
1327436 | 1327436 | 2021-05-17 | Piscataquis | Maine | 23021 | 521 | 6 |
1324190 | 1324190 | 2021-05-16 | Piscataquis | Maine | 23021 | 510 | 6 |
1320944 | 1320944 | 2021-05-15 | Piscataquis | Maine | 23021 | 508 | 6 |
1317697 | 1317697 | 2021-05-14 | Piscataquis | Maine | 23021 | 506 | 6 |
1314450 | 1314450 | 2021-05-13 | Piscataquis | Maine | 23021 | 502 | 6 |
1311203 | 1311203 | 2021-05-12 | Piscataquis | Maine | 23021 | 497 | 6 |
1307957 | 1307957 | 2021-05-11 | Piscataquis | Maine | 23021 | 489 | 6 |
1304711 | 1304711 | 2021-05-10 | Piscataquis | Maine | 23021 | 482 | 6 |
1301464 | 1301464 | 2021-05-09 | Piscataquis | Maine | 23021 | 481 | 6 |
1298217 | 1298217 | 2021-05-08 | Piscataquis | Maine | 23021 | 479 | 6 |
1294971 | 1294971 | 2021-05-07 | Piscataquis | Maine | 23021 | 479 | 6 |
1291725 | 1291725 | 2021-05-06 | Piscataquis | Maine | 23021 | 469 | 6 |
1288479 | 1288479 | 2021-05-05 | Piscataquis | Maine | 23021 | 463 | 6 |
1285233 | 1285233 | 2021-05-04 | Piscataquis | Maine | 23021 | 461 | 6 |
1281986 | 1281986 | 2021-05-03 | Piscataquis | Maine | 23021 | 457 | 6 |
1278739 | 1278739 | 2021-05-02 | Piscataquis | Maine | 23021 | 450 | 6 |
1275492 | 1275492 | 2021-05-01 | Piscataquis | Maine | 23021 | 448 | 6 |
1272245 | 1272245 | 2021-04-30 | Piscataquis | Maine | 23021 | 445 | 6 |
1268998 | 1268998 | 2021-04-29 | Piscataquis | Maine | 23021 | 442 | 6 |
1265751 | 1265751 | 2021-04-28 | Piscataquis | Maine | 23021 | 441 | 6 |
1262504 | 1262504 | 2021-04-27 | Piscataquis | Maine | 23021 | 439 | 5 |
1259257 | 1259257 | 2021-04-26 | Piscataquis | Maine | 23021 | 434 | 4 |
1256010 | 1256010 | 2021-04-25 | Piscataquis | Maine | 23021 | 434 | 4 |
1252763 | 1252763 | 2021-04-24 | Piscataquis | Maine | 23021 | 434 | 4 |
1249516 | 1249516 | 2021-04-23 | Piscataquis | Maine | 23021 | 433 | 4 |
1246269 | 1246269 | 2021-04-22 | Piscataquis | Maine | 23021 | 427 | 4 |
1243022 | 1243022 | 2021-04-21 | Piscataquis | Maine | 23021 | 427 | 4 |
1239775 | 1239775 | 2021-04-20 | Piscataquis | Maine | 23021 | 424 | 4 |
1236528 | 1236528 | 2021-04-19 | Piscataquis | Maine | 23021 | 423 | 4 |
1233281 | 1233281 | 2021-04-18 | Piscataquis | Maine | 23021 | 420 | 4 |
1230033 | 1230033 | 2021-04-17 | Piscataquis | Maine | 23021 | 416 | 4 |
1226785 | 1226785 | 2021-04-16 | Piscataquis | Maine | 23021 | 412 | 4 |
1223538 | 1223538 | 2021-04-15 | Piscataquis | Maine | 23021 | 407 | 4 |
1220290 | 1220290 | 2021-04-14 | Piscataquis | Maine | 23021 | 405 | 4 |
1217042 | 1217042 | 2021-04-13 | Piscataquis | Maine | 23021 | 401 | 4 |
1213795 | 1213795 | 2021-04-12 | Piscataquis | Maine | 23021 | 398 | 4 |
1210547 | 1210547 | 2021-04-11 | Piscataquis | Maine | 23021 | 398 | 4 |
1207298 | 1207298 | 2021-04-10 | Piscataquis | Maine | 23021 | 398 | 4 |
1204050 | 1204050 | 2021-04-09 | Piscataquis | Maine | 23021 | 397 | 4 |
1200802 | 1200802 | 2021-04-08 | Piscataquis | Maine | 23021 | 395 | 4 |
1197553 | 1197553 | 2021-04-07 | Piscataquis | Maine | 23021 | 394 | 4 |
1194305 | 1194305 | 2021-04-06 | Piscataquis | Maine | 23021 | 393 | 4 |
1191055 | 1191055 | 2021-04-05 | Piscataquis | Maine | 23021 | 390 | 4 |
1187808 | 1187808 | 2021-04-04 | Piscataquis | Maine | 23021 | 389 | 4 |
1184561 | 1184561 | 2021-04-03 | Piscataquis | Maine | 23021 | 388 | 4 |
1181314 | 1181314 | 2021-04-02 | Piscataquis | Maine | 23021 | 388 | 4 |
1178067 | 1178067 | 2021-04-01 | Piscataquis | Maine | 23021 | 388 | 4 |
1174820 | 1174820 | 2021-03-31 | Piscataquis | Maine | 23021 | 384 | 4 |
1171573 | 1171573 | 2021-03-30 | Piscataquis | Maine | 23021 | 382 | 4 |
1168325 | 1168325 | 2021-03-29 | Piscataquis | Maine | 23021 | 380 | 4 |
1165077 | 1165077 | 2021-03-28 | Piscataquis | Maine | 23021 | 379 | 4 |
1161829 | 1161829 | 2021-03-27 | Piscataquis | Maine | 23021 | 377 | 4 |
1158581 | 1158581 | 2021-03-26 | Piscataquis | Maine | 23021 | 375 | 3 |
1155334 | 1155334 | 2021-03-25 | Piscataquis | Maine | 23021 | 374 | 3 |
1152087 | 1152087 | 2021-03-24 | Piscataquis | Maine | 23021 | 373 | 3 |
1148840 | 1148840 | 2021-03-23 | Piscataquis | Maine | 23021 | 373 | 3 |
1145593 | 1145593 | 2021-03-22 | Piscataquis | Maine | 23021 | 373 | 3 |
1142346 | 1142346 | 2021-03-21 | Piscataquis | Maine | 23021 | 373 | 3 |
1139100 | 1139100 | 2021-03-20 | Piscataquis | Maine | 23021 | 373 | 3 |
1135854 | 1135854 | 2021-03-19 | Piscataquis | Maine | 23021 | 369 | 3 |
1132607 | 1132607 | 2021-03-18 | Piscataquis | Maine | 23021 | 366 | 3 |
1129359 | 1129359 | 2021-03-17 | Piscataquis | Maine | 23021 | 365 | 2 |
1126113 | 1126113 | 2021-03-16 | Piscataquis | Maine | 23021 | 363 | 2 |
1122867 | 1122867 | 2021-03-15 | Piscataquis | Maine | 23021 | 359 | 2 |
1119620 | 1119620 | 2021-03-14 | Piscataquis | Maine | 23021 | 356 | 2 |
1116373 | 1116373 | 2021-03-13 | Piscataquis | Maine | 23021 | 353 | 2 |
1113127 | 1113127 | 2021-03-12 | Piscataquis | Maine | 23021 | 344 | 1 |
1109881 | 1109881 | 2021-03-11 | Piscataquis | Maine | 23021 | 342 | 1 |
1106635 | 1106635 | 2021-03-10 | Piscataquis | Maine | 23021 | 339 | 1 |
1103389 | 1103389 | 2021-03-09 | Piscataquis | Maine | 23021 | 333 | 1 |
1100143 | 1100143 | 2021-03-08 | Piscataquis | Maine | 23021 | 332 | 1 |
1096895 | 1096895 | 2021-03-07 | Piscataquis | Maine | 23021 | 328 | 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);