ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lincoln" and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
869705 | 869705 | 2020-12-27 | Lincoln | Maine | 23015 | 280 | 2 |
866460 | 866460 | 2020-12-26 | Lincoln | Maine | 23015 | 275 | 2 |
863215 | 863215 | 2020-12-25 | Lincoln | Maine | 23015 | 275 | 2 |
859970 | 859970 | 2020-12-24 | Lincoln | Maine | 23015 | 272 | 2 |
856725 | 856725 | 2020-12-23 | Lincoln | Maine | 23015 | 255 | 2 |
853480 | 853480 | 2020-12-22 | Lincoln | Maine | 23015 | 246 | 2 |
850235 | 850235 | 2020-12-21 | Lincoln | Maine | 23015 | 237 | 2 |
846990 | 846990 | 2020-12-20 | Lincoln | Maine | 23015 | 235 | 2 |
843744 | 843744 | 2020-12-19 | Lincoln | Maine | 23015 | 234 | 2 |
840499 | 840499 | 2020-12-18 | Lincoln | Maine | 23015 | 226 | 2 |
837254 | 837254 | 2020-12-17 | Lincoln | Maine | 23015 | 213 | 2 |
834008 | 834008 | 2020-12-16 | Lincoln | Maine | 23015 | 208 | 2 |
830761 | 830761 | 2020-12-15 | Lincoln | Maine | 23015 | 194 | 2 |
827515 | 827515 | 2020-12-14 | Lincoln | Maine | 23015 | 189 | 2 |
824268 | 824268 | 2020-12-13 | Lincoln | Maine | 23015 | 189 | 2 |
821022 | 821022 | 2020-12-12 | Lincoln | Maine | 23015 | 189 | 2 |
817776 | 817776 | 2020-12-11 | Lincoln | Maine | 23015 | 189 | 2 |
814530 | 814530 | 2020-12-10 | Lincoln | Maine | 23015 | 188 | 2 |
811285 | 811285 | 2020-12-09 | Lincoln | Maine | 23015 | 186 | 2 |
808040 | 808040 | 2020-12-08 | Lincoln | Maine | 23015 | 185 | 2 |
804795 | 804795 | 2020-12-07 | Lincoln | Maine | 23015 | 183 | 2 |
801550 | 801550 | 2020-12-06 | Lincoln | Maine | 23015 | 180 | 2 |
798305 | 798305 | 2020-12-05 | Lincoln | Maine | 23015 | 178 | 2 |
795060 | 795060 | 2020-12-04 | Lincoln | Maine | 23015 | 173 | 2 |
791815 | 791815 | 2020-12-03 | Lincoln | Maine | 23015 | 168 | 2 |
788570 | 788570 | 2020-12-02 | Lincoln | Maine | 23015 | 161 | 2 |
785326 | 785326 | 2020-12-01 | Lincoln | Maine | 23015 | 156 | 2 |
782081 | 782081 | 2020-11-30 | Lincoln | Maine | 23015 | 156 | 2 |
778835 | 778835 | 2020-11-29 | Lincoln | Maine | 23015 | 155 | 2 |
775590 | 775590 | 2020-11-28 | Lincoln | Maine | 23015 | 151 | 2 |
772345 | 772345 | 2020-11-27 | Lincoln | Maine | 23015 | 151 | 2 |
769100 | 769100 | 2020-11-26 | Lincoln | Maine | 23015 | 151 | 2 |
765854 | 765854 | 2020-11-25 | Lincoln | Maine | 23015 | 149 | 2 |
762609 | 762609 | 2020-11-24 | Lincoln | Maine | 23015 | 146 | 2 |
759364 | 759364 | 2020-11-23 | Lincoln | Maine | 23015 | 139 | 2 |
756117 | 756117 | 2020-11-22 | Lincoln | Maine | 23015 | 134 | 1 |
752871 | 752871 | 2020-11-21 | Lincoln | Maine | 23015 | 132 | 1 |
749625 | 749625 | 2020-11-20 | Lincoln | Maine | 23015 | 131 | 1 |
746379 | 746379 | 2020-11-19 | Lincoln | Maine | 23015 | 127 | 1 |
743132 | 743132 | 2020-11-18 | Lincoln | Maine | 23015 | 117 | 1 |
739885 | 739885 | 2020-11-17 | Lincoln | Maine | 23015 | 113 | 1 |
736641 | 736641 | 2020-11-16 | Lincoln | Maine | 23015 | 107 | 1 |
733395 | 733395 | 2020-11-15 | Lincoln | Maine | 23015 | 106 | 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);