ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Franklin" and fips = 12037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053845 | 1053845 | 2021-02-22 | Franklin | Florida | 12037 | 1274 | 13 |
1050598 | 1050598 | 2021-02-21 | Franklin | Florida | 12037 | 1274 | 13 |
1047351 | 1047351 | 2021-02-20 | Franklin | Florida | 12037 | 1273 | 13 |
1044106 | 1044106 | 2021-02-19 | Franklin | Florida | 12037 | 1273 | 13 |
1040861 | 1040861 | 2021-02-18 | Franklin | Florida | 12037 | 1273 | 12 |
1037616 | 1037616 | 2021-02-17 | Franklin | Florida | 12037 | 1272 | 12 |
1034371 | 1034371 | 2021-02-16 | Franklin | Florida | 12037 | 1268 | 12 |
1031125 | 1031125 | 2021-02-15 | Franklin | Florida | 12037 | 1268 | 12 |
1027878 | 1027878 | 2021-02-14 | Franklin | Florida | 12037 | 1268 | 12 |
1024633 | 1024633 | 2021-02-13 | Franklin | Florida | 12037 | 1264 | 11 |
1021388 | 1021388 | 2021-02-12 | Franklin | Florida | 12037 | 1264 | 11 |
1018143 | 1018143 | 2021-02-11 | Franklin | Florida | 12037 | 1265 | 11 |
1014898 | 1014898 | 2021-02-10 | Franklin | Florida | 12037 | 1264 | 11 |
1011653 | 1011653 | 2021-02-09 | Franklin | Florida | 12037 | 1263 | 11 |
1008407 | 1008407 | 2021-02-08 | Franklin | Florida | 12037 | 1261 | 10 |
1005161 | 1005161 | 2021-02-07 | Franklin | Florida | 12037 | 1261 | 10 |
1001915 | 1001915 | 2021-02-06 | Franklin | Florida | 12037 | 1258 | 10 |
998669 | 998669 | 2021-02-05 | Franklin | Florida | 12037 | 1255 | 10 |
995423 | 995423 | 2021-02-04 | Franklin | Florida | 12037 | 1247 | 10 |
992177 | 992177 | 2021-02-03 | Franklin | Florida | 12037 | 1246 | 10 |
988931 | 988931 | 2021-02-02 | Franklin | Florida | 12037 | 1242 | 10 |
985684 | 985684 | 2021-02-01 | Franklin | Florida | 12037 | 1240 | 10 |
982437 | 982437 | 2021-01-31 | Franklin | Florida | 12037 | 1235 | 10 |
979191 | 979191 | 2021-01-30 | Franklin | Florida | 12037 | 1225 | 10 |
975946 | 975946 | 2021-01-29 | Franklin | Florida | 12037 | 1218 | 10 |
972701 | 972701 | 2021-01-28 | Franklin | Florida | 12037 | 1202 | 10 |
969456 | 969456 | 2021-01-27 | Franklin | Florida | 12037 | 1198 | 10 |
966212 | 966212 | 2021-01-26 | Franklin | Florida | 12037 | 1194 | 10 |
962967 | 962967 | 2021-01-25 | Franklin | Florida | 12037 | 1189 | 10 |
959722 | 959722 | 2021-01-24 | Franklin | Florida | 12037 | 1187 | 10 |
956476 | 956476 | 2021-01-23 | Franklin | Florida | 12037 | 1172 | 9 |
953231 | 953231 | 2021-01-22 | Franklin | Florida | 12037 | 1164 | 9 |
949986 | 949986 | 2021-01-21 | Franklin | Florida | 12037 | 1153 | 6 |
946740 | 946740 | 2021-01-20 | Franklin | Florida | 12037 | 1132 | 5 |
943493 | 943493 | 2021-01-19 | Franklin | Florida | 12037 | 1127 | 4 |
940248 | 940248 | 2021-01-18 | Franklin | Florida | 12037 | 1124 | 4 |
937003 | 937003 | 2021-01-17 | Franklin | Florida | 12037 | 1120 | 4 |
933758 | 933758 | 2021-01-16 | Franklin | Florida | 12037 | 1105 | 4 |
930513 | 930513 | 2021-01-15 | Franklin | Florida | 12037 | 1098 | 4 |
927268 | 927268 | 2021-01-14 | Franklin | Florida | 12037 | 1082 | 4 |
924022 | 924022 | 2021-01-13 | Franklin | Florida | 12037 | 1058 | 4 |
920777 | 920777 | 2021-01-12 | Franklin | Florida | 12037 | 1048 | 4 |
917532 | 917532 | 2021-01-11 | Franklin | Florida | 12037 | 1022 | 4 |
914287 | 914287 | 2021-01-10 | Franklin | Florida | 12037 | 1017 | 4 |
911042 | 911042 | 2021-01-09 | Franklin | Florida | 12037 | 1008 | 4 |
907797 | 907797 | 2021-01-08 | Franklin | Florida | 12037 | 1004 | 4 |
904551 | 904551 | 2021-01-07 | Franklin | Florida | 12037 | 992 | 4 |
901306 | 901306 | 2021-01-06 | Franklin | Florida | 12037 | 977 | 4 |
898061 | 898061 | 2021-01-05 | Franklin | Florida | 12037 | 964 | 4 |
894816 | 894816 | 2021-01-04 | Franklin | Florida | 12037 | 950 | 4 |
891569 | 891569 | 2021-01-03 | Franklin | Florida | 12037 | 948 | 4 |
888322 | 888322 | 2021-01-02 | Franklin | Florida | 12037 | 942 | 4 |
885077 | 885077 | 2021-01-01 | Franklin | Florida | 12037 | 900 | 4 |
881832 | 881832 | 2020-12-31 | Franklin | Florida | 12037 | 900 | 4 |
878587 | 878587 | 2020-12-30 | Franklin | Florida | 12037 | 892 | 4 |
875342 | 875342 | 2020-12-29 | Franklin | Florida | 12037 | 882 | 4 |
872097 | 872097 | 2020-12-28 | Franklin | Florida | 12037 | 878 | 4 |
868852 | 868852 | 2020-12-27 | Franklin | Florida | 12037 | 877 | 4 |
865607 | 865607 | 2020-12-26 | Franklin | Florida | 12037 | 876 | 4 |
862362 | 862362 | 2020-12-25 | Franklin | Florida | 12037 | 868 | 4 |
859117 | 859117 | 2020-12-24 | Franklin | Florida | 12037 | 868 | 4 |
855872 | 855872 | 2020-12-23 | Franklin | Florida | 12037 | 860 | 4 |
852627 | 852627 | 2020-12-22 | Franklin | Florida | 12037 | 860 | 4 |
849382 | 849382 | 2020-12-21 | Franklin | Florida | 12037 | 858 | 4 |
846137 | 846137 | 2020-12-20 | Franklin | Florida | 12037 | 858 | 4 |
842891 | 842891 | 2020-12-19 | Franklin | Florida | 12037 | 857 | 4 |
839646 | 839646 | 2020-12-18 | Franklin | Florida | 12037 | 854 | 4 |
836401 | 836401 | 2020-12-17 | Franklin | Florida | 12037 | 853 | 4 |
833155 | 833155 | 2020-12-16 | Franklin | Florida | 12037 | 852 | 4 |
829908 | 829908 | 2020-12-15 | Franklin | Florida | 12037 | 850 | 4 |
826662 | 826662 | 2020-12-14 | Franklin | Florida | 12037 | 850 | 4 |
823415 | 823415 | 2020-12-13 | Franklin | Florida | 12037 | 849 | 4 |
820169 | 820169 | 2020-12-12 | Franklin | Florida | 12037 | 848 | 4 |
816923 | 816923 | 2020-12-11 | Franklin | Florida | 12037 | 843 | 4 |
813677 | 813677 | 2020-12-10 | Franklin | Florida | 12037 | 842 | 4 |
810433 | 810433 | 2020-12-09 | Franklin | Florida | 12037 | 843 | 4 |
807188 | 807188 | 2020-12-08 | Franklin | Florida | 12037 | 840 | 4 |
803943 | 803943 | 2020-12-07 | Franklin | Florida | 12037 | 840 | 4 |
800698 | 800698 | 2020-12-06 | Franklin | Florida | 12037 | 838 | 4 |
797453 | 797453 | 2020-12-05 | Franklin | Florida | 12037 | 835 | 4 |
794208 | 794208 | 2020-12-04 | Franklin | Florida | 12037 | 834 | 4 |
790963 | 790963 | 2020-12-03 | Franklin | Florida | 12037 | 833 | 4 |
787718 | 787718 | 2020-12-02 | Franklin | Florida | 12037 | 832 | 4 |
784474 | 784474 | 2020-12-01 | Franklin | Florida | 12037 | 830 | 4 |
781229 | 781229 | 2020-11-30 | Franklin | Florida | 12037 | 830 | 4 |
777983 | 777983 | 2020-11-29 | Franklin | Florida | 12037 | 830 | 4 |
774738 | 774738 | 2020-11-28 | Franklin | Florida | 12037 | 830 | 4 |
771493 | 771493 | 2020-11-27 | Franklin | Florida | 12037 | 830 | 4 |
768248 | 768248 | 2020-11-26 | Franklin | Florida | 12037 | 828 | 4 |
765002 | 765002 | 2020-11-25 | Franklin | Florida | 12037 | 828 | 4 |
761757 | 761757 | 2020-11-24 | Franklin | Florida | 12037 | 826 | 4 |
758512 | 758512 | 2020-11-23 | Franklin | Florida | 12037 | 826 | 4 |
755265 | 755265 | 2020-11-22 | Franklin | Florida | 12037 | 826 | 4 |
752019 | 752019 | 2020-11-21 | Franklin | Florida | 12037 | 823 | 4 |
748773 | 748773 | 2020-11-20 | Franklin | Florida | 12037 | 816 | 4 |
745527 | 745527 | 2020-11-19 | Franklin | Florida | 12037 | 813 | 4 |
742280 | 742280 | 2020-11-18 | Franklin | Florida | 12037 | 809 | 4 |
739033 | 739033 | 2020-11-17 | Franklin | Florida | 12037 | 809 | 4 |
735789 | 735789 | 2020-11-16 | Franklin | Florida | 12037 | 809 | 4 |
732543 | 732543 | 2020-11-15 | Franklin | Florida | 12037 | 809 | 4 |
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);