ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lincoln" and fips = 23015 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194302 | 1194302 | 2021-04-06 | Lincoln | Maine | 23015 | 682 | 2 |
1191052 | 1191052 | 2021-04-05 | Lincoln | Maine | 23015 | 681 | 2 |
1187805 | 1187805 | 2021-04-04 | Lincoln | Maine | 23015 | 680 | 2 |
1184558 | 1184558 | 2021-04-03 | Lincoln | Maine | 23015 | 675 | 2 |
1181311 | 1181311 | 2021-04-02 | Lincoln | Maine | 23015 | 668 | 2 |
1178064 | 1178064 | 2021-04-01 | Lincoln | Maine | 23015 | 661 | 2 |
1174817 | 1174817 | 2021-03-31 | Lincoln | Maine | 23015 | 657 | 2 |
1171570 | 1171570 | 2021-03-30 | Lincoln | Maine | 23015 | 653 | 2 |
1168322 | 1168322 | 2021-03-29 | Lincoln | Maine | 23015 | 651 | 2 |
1165074 | 1165074 | 2021-03-28 | Lincoln | Maine | 23015 | 647 | 2 |
1161826 | 1161826 | 2021-03-27 | Lincoln | Maine | 23015 | 647 | 2 |
1158578 | 1158578 | 2021-03-26 | Lincoln | Maine | 23015 | 642 | 2 |
1155331 | 1155331 | 2021-03-25 | Lincoln | Maine | 23015 | 639 | 2 |
1152084 | 1152084 | 2021-03-24 | Lincoln | Maine | 23015 | 632 | 2 |
1148837 | 1148837 | 2021-03-23 | Lincoln | Maine | 23015 | 632 | 2 |
1145590 | 1145590 | 2021-03-22 | Lincoln | Maine | 23015 | 629 | 2 |
1142343 | 1142343 | 2021-03-21 | Lincoln | Maine | 23015 | 629 | 2 |
1139097 | 1139097 | 2021-03-20 | Lincoln | Maine | 23015 | 628 | 2 |
1135851 | 1135851 | 2021-03-19 | Lincoln | Maine | 23015 | 624 | 2 |
1132604 | 1132604 | 2021-03-18 | Lincoln | Maine | 23015 | 619 | 2 |
1129356 | 1129356 | 2021-03-17 | Lincoln | Maine | 23015 | 614 | 2 |
1126110 | 1126110 | 2021-03-16 | Lincoln | Maine | 23015 | 611 | 2 |
1122864 | 1122864 | 2021-03-15 | Lincoln | Maine | 23015 | 609 | 2 |
1119617 | 1119617 | 2021-03-14 | Lincoln | Maine | 23015 | 607 | 2 |
1116370 | 1116370 | 2021-03-13 | Lincoln | Maine | 23015 | 604 | 2 |
1113124 | 1113124 | 2021-03-12 | Lincoln | Maine | 23015 | 602 | 2 |
1109878 | 1109878 | 2021-03-11 | Lincoln | Maine | 23015 | 598 | 2 |
1106632 | 1106632 | 2021-03-10 | Lincoln | Maine | 23015 | 597 | 2 |
1103386 | 1103386 | 2021-03-09 | Lincoln | Maine | 23015 | 595 | 2 |
1100140 | 1100140 | 2021-03-08 | Lincoln | Maine | 23015 | 594 | 2 |
1096892 | 1096892 | 2021-03-07 | Lincoln | Maine | 23015 | 594 | 2 |
1093646 | 1093646 | 2021-03-06 | Lincoln | Maine | 23015 | 593 | 2 |
1090400 | 1090400 | 2021-03-05 | Lincoln | Maine | 23015 | 590 | 2 |
1087155 | 1087155 | 2021-03-04 | Lincoln | Maine | 23015 | 587 | 2 |
1083909 | 1083909 | 2021-03-03 | Lincoln | Maine | 23015 | 585 | 2 |
1080663 | 1080663 | 2021-03-02 | Lincoln | Maine | 23015 | 583 | 2 |
1077418 | 1077418 | 2021-03-01 | Lincoln | Maine | 23015 | 583 | 2 |
1074172 | 1074172 | 2021-02-28 | Lincoln | Maine | 23015 | 582 | 2 |
1070926 | 1070926 | 2021-02-27 | Lincoln | Maine | 23015 | 579 | 2 |
1067681 | 1067681 | 2021-02-26 | Lincoln | Maine | 23015 | 577 | 2 |
1064436 | 1064436 | 2021-02-25 | Lincoln | Maine | 23015 | 576 | 2 |
1061191 | 1061191 | 2021-02-24 | Lincoln | Maine | 23015 | 574 | 1 |
1057945 | 1057945 | 2021-02-23 | Lincoln | Maine | 23015 | 571 | 1 |
1054699 | 1054699 | 2021-02-22 | Lincoln | Maine | 23015 | 568 | 1 |
1051452 | 1051452 | 2021-02-21 | Lincoln | Maine | 23015 | 566 | 1 |
1048205 | 1048205 | 2021-02-20 | Lincoln | Maine | 23015 | 563 | 1 |
1044960 | 1044960 | 2021-02-19 | Lincoln | Maine | 23015 | 559 | 1 |
1041715 | 1041715 | 2021-02-18 | Lincoln | Maine | 23015 | 554 | 1 |
1038470 | 1038470 | 2021-02-17 | Lincoln | Maine | 23015 | 551 | 1 |
1035225 | 1035225 | 2021-02-16 | Lincoln | Maine | 23015 | 544 | 1 |
1031979 | 1031979 | 2021-02-15 | Lincoln | Maine | 23015 | 544 | 1 |
1028732 | 1028732 | 2021-02-14 | Lincoln | Maine | 23015 | 538 | 1 |
1025487 | 1025487 | 2021-02-13 | Lincoln | Maine | 23015 | 539 | 1 |
1022242 | 1022242 | 2021-02-12 | Lincoln | Maine | 23015 | 534 | 1 |
1018997 | 1018997 | 2021-02-11 | Lincoln | Maine | 23015 | 528 | 1 |
1015752 | 1015752 | 2021-02-10 | Lincoln | Maine | 23015 | 526 | 1 |
1012507 | 1012507 | 2021-02-09 | Lincoln | Maine | 23015 | 521 | 1 |
1009261 | 1009261 | 2021-02-08 | Lincoln | Maine | 23015 | 516 | 1 |
1006015 | 1006015 | 2021-02-07 | Lincoln | Maine | 23015 | 511 | 1 |
1002769 | 1002769 | 2021-02-06 | Lincoln | Maine | 23015 | 509 | 1 |
999523 | 999523 | 2021-02-05 | Lincoln | Maine | 23015 | 505 | 2 |
996277 | 996277 | 2021-02-04 | Lincoln | Maine | 23015 | 499 | 2 |
993031 | 993031 | 2021-02-03 | Lincoln | Maine | 23015 | 496 | 2 |
989785 | 989785 | 2021-02-02 | Lincoln | Maine | 23015 | 487 | 2 |
986538 | 986538 | 2021-02-01 | Lincoln | Maine | 23015 | 474 | 2 |
983291 | 983291 | 2021-01-31 | Lincoln | Maine | 23015 | 471 | 2 |
980045 | 980045 | 2021-01-30 | Lincoln | Maine | 23015 | 468 | 2 |
976799 | 976799 | 2021-01-29 | Lincoln | Maine | 23015 | 465 | 2 |
973554 | 973554 | 2021-01-28 | Lincoln | Maine | 23015 | 462 | 2 |
970309 | 970309 | 2021-01-27 | Lincoln | Maine | 23015 | 456 | 2 |
967065 | 967065 | 2021-01-26 | Lincoln | Maine | 23015 | 445 | 2 |
963820 | 963820 | 2021-01-25 | Lincoln | Maine | 23015 | 440 | 2 |
960575 | 960575 | 2021-01-24 | Lincoln | Maine | 23015 | 437 | 2 |
957329 | 957329 | 2021-01-23 | Lincoln | Maine | 23015 | 437 | 2 |
954084 | 954084 | 2021-01-22 | Lincoln | Maine | 23015 | 426 | 2 |
950839 | 950839 | 2021-01-21 | Lincoln | Maine | 23015 | 414 | 2 |
947593 | 947593 | 2021-01-20 | Lincoln | Maine | 23015 | 407 | 2 |
944346 | 944346 | 2021-01-19 | Lincoln | Maine | 23015 | 396 | 2 |
941101 | 941101 | 2021-01-18 | Lincoln | Maine | 23015 | 394 | 2 |
937856 | 937856 | 2021-01-17 | Lincoln | Maine | 23015 | 393 | 2 |
934611 | 934611 | 2021-01-16 | Lincoln | Maine | 23015 | 393 | 2 |
931366 | 931366 | 2021-01-15 | Lincoln | Maine | 23015 | 385 | 2 |
928121 | 928121 | 2021-01-14 | Lincoln | Maine | 23015 | 378 | 2 |
924875 | 924875 | 2021-01-13 | Lincoln | Maine | 23015 | 376 | 2 |
921630 | 921630 | 2021-01-12 | Lincoln | Maine | 23015 | 367 | 2 |
918385 | 918385 | 2021-01-11 | Lincoln | Maine | 23015 | 357 | 2 |
915140 | 915140 | 2021-01-10 | Lincoln | Maine | 23015 | 355 | 2 |
911895 | 911895 | 2021-01-09 | Lincoln | Maine | 23015 | 355 | 2 |
908650 | 908650 | 2021-01-08 | Lincoln | Maine | 23015 | 348 | 2 |
905404 | 905404 | 2021-01-07 | Lincoln | Maine | 23015 | 334 | 2 |
902159 | 902159 | 2021-01-06 | Lincoln | Maine | 23015 | 325 | 2 |
898914 | 898914 | 2021-01-05 | Lincoln | Maine | 23015 | 321 | 2 |
895669 | 895669 | 2021-01-04 | Lincoln | Maine | 23015 | 315 | 2 |
892422 | 892422 | 2021-01-03 | Lincoln | Maine | 23015 | 312 | 2 |
889176 | 889176 | 2021-01-02 | Lincoln | Maine | 23015 | 308 | 2 |
885930 | 885930 | 2021-01-01 | Lincoln | Maine | 23015 | 301 | 2 |
882685 | 882685 | 2020-12-31 | Lincoln | Maine | 23015 | 301 | 2 |
879440 | 879440 | 2020-12-30 | Lincoln | Maine | 23015 | 296 | 2 |
876195 | 876195 | 2020-12-29 | Lincoln | Maine | 23015 | 291 | 2 |
872950 | 872950 | 2020-12-28 | Lincoln | Maine | 23015 | 283 | 2 |
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);