ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Franklin" and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921626 | 921626 | 2021-01-12 | Franklin | Maine | 23007 | 525 | 7 |
918381 | 918381 | 2021-01-11 | Franklin | Maine | 23007 | 514 | 7 |
915136 | 915136 | 2021-01-10 | Franklin | Maine | 23007 | 514 | 7 |
911891 | 911891 | 2021-01-09 | Franklin | Maine | 23007 | 514 | 7 |
908646 | 908646 | 2021-01-08 | Franklin | Maine | 23007 | 508 | 7 |
905400 | 905400 | 2021-01-07 | Franklin | Maine | 23007 | 503 | 5 |
902155 | 902155 | 2021-01-06 | Franklin | Maine | 23007 | 496 | 5 |
898910 | 898910 | 2021-01-05 | Franklin | Maine | 23007 | 487 | 5 |
895665 | 895665 | 2021-01-04 | Franklin | Maine | 23007 | 469 | 5 |
892418 | 892418 | 2021-01-03 | Franklin | Maine | 23007 | 464 | 5 |
889172 | 889172 | 2021-01-02 | Franklin | Maine | 23007 | 454 | 5 |
885926 | 885926 | 2021-01-01 | Franklin | Maine | 23007 | 451 | 5 |
882681 | 882681 | 2020-12-31 | Franklin | Maine | 23007 | 451 | 5 |
879436 | 879436 | 2020-12-30 | Franklin | Maine | 23007 | 449 | 5 |
876191 | 876191 | 2020-12-29 | Franklin | Maine | 23007 | 448 | 5 |
872946 | 872946 | 2020-12-28 | Franklin | Maine | 23007 | 439 | 5 |
869701 | 869701 | 2020-12-27 | Franklin | Maine | 23007 | 436 | 5 |
866456 | 866456 | 2020-12-26 | Franklin | Maine | 23007 | 436 | 5 |
863211 | 863211 | 2020-12-25 | Franklin | Maine | 23007 | 436 | 5 |
859966 | 859966 | 2020-12-24 | Franklin | Maine | 23007 | 435 | 5 |
856721 | 856721 | 2020-12-23 | Franklin | Maine | 23007 | 431 | 5 |
853476 | 853476 | 2020-12-22 | Franklin | Maine | 23007 | 411 | 5 |
850231 | 850231 | 2020-12-21 | Franklin | Maine | 23007 | 389 | 5 |
846986 | 846986 | 2020-12-20 | Franklin | Maine | 23007 | 384 | 5 |
843740 | 843740 | 2020-12-19 | Franklin | Maine | 23007 | 384 | 5 |
840495 | 840495 | 2020-12-18 | Franklin | Maine | 23007 | 372 | 4 |
837250 | 837250 | 2020-12-17 | Franklin | Maine | 23007 | 365 | 4 |
834004 | 834004 | 2020-12-16 | Franklin | Maine | 23007 | 356 | 4 |
830757 | 830757 | 2020-12-15 | Franklin | Maine | 23007 | 349 | 4 |
827511 | 827511 | 2020-12-14 | Franklin | Maine | 23007 | 345 | 4 |
824264 | 824264 | 2020-12-13 | Franklin | Maine | 23007 | 336 | 4 |
821018 | 821018 | 2020-12-12 | Franklin | Maine | 23007 | 332 | 4 |
817772 | 817772 | 2020-12-11 | Franklin | Maine | 23007 | 296 | 4 |
814526 | 814526 | 2020-12-10 | Franklin | Maine | 23007 | 290 | 4 |
811281 | 811281 | 2020-12-09 | Franklin | Maine | 23007 | 281 | 4 |
808036 | 808036 | 2020-12-08 | Franklin | Maine | 23007 | 271 | 4 |
804791 | 804791 | 2020-12-07 | Franklin | Maine | 23007 | 268 | 4 |
801546 | 801546 | 2020-12-06 | Franklin | Maine | 23007 | 258 | 4 |
798301 | 798301 | 2020-12-05 | Franklin | Maine | 23007 | 251 | 4 |
795056 | 795056 | 2020-12-04 | Franklin | Maine | 23007 | 249 | 4 |
791811 | 791811 | 2020-12-03 | Franklin | Maine | 23007 | 239 | 4 |
788566 | 788566 | 2020-12-02 | Franklin | Maine | 23007 | 229 | 4 |
785322 | 785322 | 2020-12-01 | Franklin | Maine | 23007 | 223 | 4 |
782077 | 782077 | 2020-11-30 | Franklin | Maine | 23007 | 215 | 4 |
778831 | 778831 | 2020-11-29 | Franklin | Maine | 23007 | 212 | 4 |
775586 | 775586 | 2020-11-28 | Franklin | Maine | 23007 | 210 | 4 |
772341 | 772341 | 2020-11-27 | Franklin | Maine | 23007 | 208 | 4 |
769096 | 769096 | 2020-11-26 | Franklin | Maine | 23007 | 208 | 4 |
765850 | 765850 | 2020-11-25 | Franklin | Maine | 23007 | 204 | 4 |
762605 | 762605 | 2020-11-24 | Franklin | Maine | 23007 | 201 | 4 |
759360 | 759360 | 2020-11-23 | Franklin | Maine | 23007 | 196 | 3 |
756113 | 756113 | 2020-11-22 | Franklin | Maine | 23007 | 194 | 3 |
752867 | 752867 | 2020-11-21 | Franklin | Maine | 23007 | 192 | 2 |
749621 | 749621 | 2020-11-20 | Franklin | Maine | 23007 | 187 | 2 |
746375 | 746375 | 2020-11-19 | Franklin | Maine | 23007 | 179 | 2 |
743128 | 743128 | 2020-11-18 | Franklin | Maine | 23007 | 170 | 2 |
739881 | 739881 | 2020-11-17 | Franklin | Maine | 23007 | 163 | 2 |
736637 | 736637 | 2020-11-16 | Franklin | Maine | 23007 | 156 | 2 |
733391 | 733391 | 2020-11-15 | Franklin | Maine | 23007 | 151 | 2 |
730146 | 730146 | 2020-11-14 | Franklin | Maine | 23007 | 145 | 2 |
726903 | 726903 | 2020-11-13 | Franklin | Maine | 23007 | 139 | 2 |
723660 | 723660 | 2020-11-12 | Franklin | Maine | 23007 | 134 | 2 |
720417 | 720417 | 2020-11-11 | Franklin | Maine | 23007 | 132 | 2 |
717174 | 717174 | 2020-11-10 | Franklin | Maine | 23007 | 131 | 2 |
713930 | 713930 | 2020-11-09 | Franklin | Maine | 23007 | 128 | 2 |
710686 | 710686 | 2020-11-08 | Franklin | Maine | 23007 | 125 | 2 |
707442 | 707442 | 2020-11-07 | Franklin | Maine | 23007 | 124 | 2 |
704199 | 704199 | 2020-11-06 | Franklin | Maine | 23007 | 120 | 2 |
700957 | 700957 | 2020-11-05 | Franklin | Maine | 23007 | 113 | 2 |
697713 | 697713 | 2020-11-04 | Franklin | Maine | 23007 | 101 | 2 |
694470 | 694470 | 2020-11-03 | Franklin | Maine | 23007 | 96 | 1 |
691228 | 691228 | 2020-11-02 | Franklin | Maine | 23007 | 90 | 1 |
687983 | 687983 | 2020-11-01 | Franklin | Maine | 23007 | 86 | 1 |
684739 | 684739 | 2020-10-31 | Franklin | Maine | 23007 | 82 | 1 |
681496 | 681496 | 2020-10-30 | Franklin | Maine | 23007 | 80 | 1 |
678252 | 678252 | 2020-10-29 | Franklin | Maine | 23007 | 79 | 1 |
675010 | 675010 | 2020-10-28 | Franklin | Maine | 23007 | 77 | 1 |
671767 | 671767 | 2020-10-27 | Franklin | Maine | 23007 | 74 | 1 |
668525 | 668525 | 2020-10-26 | Franklin | Maine | 23007 | 74 | 1 |
665281 | 665281 | 2020-10-25 | Franklin | Maine | 23007 | 74 | 1 |
662036 | 662036 | 2020-10-24 | Franklin | Maine | 23007 | 74 | 1 |
658792 | 658792 | 2020-10-23 | Franklin | Maine | 23007 | 74 | 1 |
655547 | 655547 | 2020-10-22 | Franklin | Maine | 23007 | 74 | 1 |
652302 | 652302 | 2020-10-21 | Franklin | Maine | 23007 | 74 | 1 |
649057 | 649057 | 2020-10-20 | Franklin | Maine | 23007 | 73 | 1 |
645813 | 645813 | 2020-10-19 | Franklin | Maine | 23007 | 73 | 1 |
642566 | 642566 | 2020-10-18 | Franklin | Maine | 23007 | 73 | 1 |
639319 | 639319 | 2020-10-17 | Franklin | Maine | 23007 | 73 | 1 |
636073 | 636073 | 2020-10-16 | Franklin | Maine | 23007 | 73 | 1 |
632827 | 632827 | 2020-10-15 | Franklin | Maine | 23007 | 73 | 1 |
629583 | 629583 | 2020-10-14 | Franklin | Maine | 23007 | 71 | 1 |
626339 | 626339 | 2020-10-13 | Franklin | Maine | 23007 | 72 | 1 |
623097 | 623097 | 2020-10-12 | Franklin | Maine | 23007 | 71 | 1 |
619853 | 619853 | 2020-10-11 | Franklin | Maine | 23007 | 69 | 1 |
616611 | 616611 | 2020-10-10 | Franklin | Maine | 23007 | 67 | 1 |
613370 | 613370 | 2020-10-09 | Franklin | Maine | 23007 | 66 | 1 |
610128 | 610128 | 2020-10-08 | Franklin | Maine | 23007 | 64 | 1 |
606886 | 606886 | 2020-10-07 | Franklin | Maine | 23007 | 64 | 1 |
603644 | 603644 | 2020-10-06 | Franklin | Maine | 23007 | 64 | 1 |
600401 | 600401 | 2020-10-05 | Franklin | Maine | 23007 | 63 | 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);