ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922375 | 922375 | 2021-01-12 | Franklin | North Carolina | 37069 | 3827 | 39 |
919130 | 919130 | 2021-01-11 | Franklin | North Carolina | 37069 | 3743 | 39 |
915885 | 915885 | 2021-01-10 | Franklin | North Carolina | 37069 | 3691 | 39 |
912640 | 912640 | 2021-01-09 | Franklin | North Carolina | 37069 | 3668 | 39 |
909395 | 909395 | 2021-01-08 | Franklin | North Carolina | 37069 | 3558 | 39 |
906150 | 906150 | 2021-01-07 | Franklin | North Carolina | 37069 | 3522 | 39 |
902904 | 902904 | 2021-01-06 | Franklin | North Carolina | 37069 | 3436 | 39 |
899659 | 899659 | 2021-01-05 | Franklin | North Carolina | 37069 | 3365 | 39 |
896414 | 896414 | 2021-01-04 | Franklin | North Carolina | 37069 | 3342 | 37 |
893168 | 893168 | 2021-01-03 | Franklin | North Carolina | 37069 | 3292 | 37 |
889922 | 889922 | 2021-01-02 | Franklin | North Carolina | 37069 | 3251 | 37 |
886675 | 886675 | 2021-01-01 | Franklin | North Carolina | 37069 | 3186 | 37 |
883430 | 883430 | 2020-12-31 | Franklin | North Carolina | 37069 | 3186 | 37 |
880185 | 880185 | 2020-12-30 | Franklin | North Carolina | 37069 | 3072 | 37 |
876940 | 876940 | 2020-12-29 | Franklin | North Carolina | 37069 | 3014 | 37 |
873695 | 873695 | 2020-12-28 | Franklin | North Carolina | 37069 | 2982 | 37 |
870450 | 870450 | 2020-12-27 | Franklin | North Carolina | 37069 | 2928 | 37 |
867205 | 867205 | 2020-12-26 | Franklin | North Carolina | 37069 | 2909 | 37 |
863960 | 863960 | 2020-12-25 | Franklin | North Carolina | 37069 | 2815 | 37 |
860715 | 860715 | 2020-12-24 | Franklin | North Carolina | 37069 | 2815 | 37 |
857470 | 857470 | 2020-12-23 | Franklin | North Carolina | 37069 | 2815 | 37 |
854225 | 854225 | 2020-12-22 | Franklin | North Carolina | 37069 | 2795 | 37 |
850980 | 850980 | 2020-12-21 | Franklin | North Carolina | 37069 | 2785 | 37 |
847735 | 847735 | 2020-12-20 | Franklin | North Carolina | 37069 | 2748 | 37 |
844490 | 844490 | 2020-12-19 | Franklin | North Carolina | 37069 | 2690 | 37 |
841244 | 841244 | 2020-12-18 | Franklin | North Carolina | 37069 | 2642 | 37 |
837999 | 837999 | 2020-12-17 | Franklin | North Carolina | 37069 | 2557 | 37 |
834753 | 834753 | 2020-12-16 | Franklin | North Carolina | 37069 | 2532 | 37 |
831507 | 831507 | 2020-12-15 | Franklin | North Carolina | 37069 | 2491 | 37 |
828260 | 828260 | 2020-12-14 | Franklin | North Carolina | 37069 | 2462 | 36 |
825014 | 825014 | 2020-12-13 | Franklin | North Carolina | 37069 | 2448 | 36 |
821767 | 821767 | 2020-12-12 | Franklin | North Carolina | 37069 | 2403 | 36 |
818521 | 818521 | 2020-12-11 | Franklin | North Carolina | 37069 | 2367 | 36 |
815275 | 815275 | 2020-12-10 | Franklin | North Carolina | 37069 | 2321 | 35 |
812030 | 812030 | 2020-12-09 | Franklin | North Carolina | 37069 | 2306 | 34 |
808785 | 808785 | 2020-12-08 | Franklin | North Carolina | 37069 | 2266 | 34 |
805540 | 805540 | 2020-12-07 | Franklin | North Carolina | 37069 | 2253 | 33 |
802295 | 802295 | 2020-12-06 | Franklin | North Carolina | 37069 | 2218 | 33 |
799050 | 799050 | 2020-12-05 | Franklin | North Carolina | 37069 | 2177 | 33 |
795805 | 795805 | 2020-12-04 | Franklin | North Carolina | 37069 | 2127 | 33 |
792560 | 792560 | 2020-12-03 | Franklin | North Carolina | 37069 | 2101 | 33 |
789315 | 789315 | 2020-12-02 | Franklin | North Carolina | 37069 | 2075 | 33 |
786070 | 786070 | 2020-12-01 | Franklin | North Carolina | 37069 | 2045 | 33 |
782826 | 782826 | 2020-11-30 | Franklin | North Carolina | 37069 | 2022 | 33 |
779580 | 779580 | 2020-11-29 | Franklin | North Carolina | 37069 | 2011 | 33 |
776335 | 776335 | 2020-11-28 | Franklin | North Carolina | 37069 | 1984 | 33 |
773090 | 773090 | 2020-11-27 | Franklin | North Carolina | 37069 | 1957 | 33 |
769845 | 769845 | 2020-11-26 | Franklin | North Carolina | 37069 | 1907 | 33 |
766599 | 766599 | 2020-11-25 | Franklin | North Carolina | 37069 | 1907 | 33 |
763354 | 763354 | 2020-11-24 | Franklin | North Carolina | 37069 | 1867 | 32 |
760109 | 760109 | 2020-11-23 | Franklin | North Carolina | 37069 | 1843 | 32 |
756863 | 756863 | 2020-11-22 | Franklin | North Carolina | 37069 | 1838 | 32 |
753616 | 753616 | 2020-11-21 | Franklin | North Carolina | 37069 | 1813 | 32 |
750370 | 750370 | 2020-11-20 | Franklin | North Carolina | 37069 | 1798 | 32 |
747124 | 747124 | 2020-11-19 | Franklin | North Carolina | 37069 | 1779 | 32 |
743878 | 743878 | 2020-11-18 | Franklin | North Carolina | 37069 | 1746 | 32 |
740631 | 740631 | 2020-11-17 | Franklin | North Carolina | 37069 | 1732 | 32 |
737386 | 737386 | 2020-11-16 | Franklin | North Carolina | 37069 | 1716 | 32 |
734142 | 734142 | 2020-11-15 | Franklin | North Carolina | 37069 | 1713 | 32 |
730896 | 730896 | 2020-11-14 | Franklin | North Carolina | 37069 | 1704 | 32 |
727652 | 727652 | 2020-11-13 | Franklin | North Carolina | 37069 | 1682 | 32 |
724408 | 724408 | 2020-11-12 | Franklin | North Carolina | 37069 | 1675 | 32 |
721165 | 721165 | 2020-11-11 | Franklin | North Carolina | 37069 | 1646 | 32 |
717922 | 717922 | 2020-11-10 | Franklin | North Carolina | 37069 | 1631 | 32 |
714679 | 714679 | 2020-11-09 | Franklin | North Carolina | 37069 | 1614 | 32 |
711435 | 711435 | 2020-11-08 | Franklin | North Carolina | 37069 | 1608 | 32 |
708191 | 708191 | 2020-11-07 | Franklin | North Carolina | 37069 | 1588 | 32 |
704948 | 704948 | 2020-11-06 | Franklin | North Carolina | 37069 | 1555 | 32 |
701705 | 701705 | 2020-11-05 | Franklin | North Carolina | 37069 | 1544 | 32 |
698461 | 698461 | 2020-11-04 | Franklin | North Carolina | 37069 | 1528 | 32 |
695218 | 695218 | 2020-11-03 | Franklin | North Carolina | 37069 | 1510 | 32 |
691976 | 691976 | 2020-11-02 | Franklin | North Carolina | 37069 | 1509 | 32 |
688732 | 688732 | 2020-11-01 | Franklin | North Carolina | 37069 | 1497 | 32 |
685487 | 685487 | 2020-10-31 | Franklin | North Carolina | 37069 | 1490 | 32 |
682244 | 682244 | 2020-10-30 | Franklin | North Carolina | 37069 | 1488 | 32 |
679001 | 679001 | 2020-10-29 | Franklin | North Carolina | 37069 | 1474 | 32 |
675758 | 675758 | 2020-10-28 | Franklin | North Carolina | 37069 | 1467 | 32 |
672515 | 672515 | 2020-10-27 | Franklin | North Carolina | 37069 | 1449 | 32 |
669273 | 669273 | 2020-10-26 | Franklin | North Carolina | 37069 | 1430 | 31 |
666029 | 666029 | 2020-10-25 | Franklin | North Carolina | 37069 | 1422 | 31 |
662784 | 662784 | 2020-10-24 | Franklin | North Carolina | 37069 | 1411 | 31 |
659540 | 659540 | 2020-10-23 | Franklin | North Carolina | 37069 | 1401 | 31 |
656296 | 656296 | 2020-10-22 | Franklin | North Carolina | 37069 | 1394 | 31 |
653051 | 653051 | 2020-10-21 | Franklin | North Carolina | 37069 | 1386 | 31 |
649806 | 649806 | 2020-10-20 | Franklin | North Carolina | 37069 | 1376 | 31 |
646562 | 646562 | 2020-10-19 | Franklin | North Carolina | 37069 | 1374 | 31 |
643316 | 643316 | 2020-10-18 | Franklin | North Carolina | 37069 | 1373 | 31 |
640068 | 640068 | 2020-10-17 | Franklin | North Carolina | 37069 | 1367 | 31 |
636822 | 636822 | 2020-10-16 | Franklin | North Carolina | 37069 | 1362 | 31 |
633576 | 633576 | 2020-10-15 | Franklin | North Carolina | 37069 | 1358 | 31 |
630331 | 630331 | 2020-10-14 | Franklin | North Carolina | 37069 | 1350 | 31 |
627087 | 627087 | 2020-10-13 | Franklin | North Carolina | 37069 | 1345 | 31 |
623845 | 623845 | 2020-10-12 | Franklin | North Carolina | 37069 | 1342 | 31 |
620602 | 620602 | 2020-10-11 | Franklin | North Carolina | 37069 | 1338 | 31 |
617360 | 617360 | 2020-10-10 | Franklin | North Carolina | 37069 | 1336 | 31 |
614118 | 614118 | 2020-10-09 | Franklin | North Carolina | 37069 | 1328 | 31 |
610877 | 610877 | 2020-10-08 | Franklin | North Carolina | 37069 | 1315 | 31 |
607635 | 607635 | 2020-10-07 | Franklin | North Carolina | 37069 | 1295 | 31 |
604392 | 604392 | 2020-10-06 | Franklin | North Carolina | 37069 | 1282 | 31 |
601150 | 601150 | 2020-10-05 | Franklin | North Carolina | 37069 | 1270 | 31 |
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);