ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 12057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053855 | 1053855 | 2021-02-22 | Hillsborough | Florida | 12057 | 109174 | 1455 |
1050608 | 1050608 | 2021-02-21 | Hillsborough | Florida | 12057 | 108964 | 1448 |
1047361 | 1047361 | 2021-02-20 | Hillsborough | Florida | 12057 | 108648 | 1448 |
1044116 | 1044116 | 2021-02-19 | Hillsborough | Florida | 12057 | 108218 | 1447 |
1040871 | 1040871 | 2021-02-18 | Hillsborough | Florida | 12057 | 107806 | 1438 |
1037626 | 1037626 | 2021-02-17 | Hillsborough | Florida | 12057 | 107513 | 1427 |
1034381 | 1034381 | 2021-02-16 | Hillsborough | Florida | 12057 | 106996 | 1418 |
1031135 | 1031135 | 2021-02-15 | Hillsborough | Florida | 12057 | 106661 | 1402 |
1027888 | 1027888 | 2021-02-14 | Hillsborough | Florida | 12057 | 106420 | 1397 |
1024643 | 1024643 | 2021-02-13 | Hillsborough | Florida | 12057 | 106060 | 1395 |
1021398 | 1021398 | 2021-02-12 | Hillsborough | Florida | 12057 | 105621 | 1395 |
1018153 | 1018153 | 2021-02-11 | Hillsborough | Florida | 12057 | 105142 | 1387 |
1014908 | 1014908 | 2021-02-10 | Hillsborough | Florida | 12057 | 104604 | 1377 |
1011663 | 1011663 | 2021-02-09 | Hillsborough | Florida | 12057 | 104210 | 1371 |
1008417 | 1008417 | 2021-02-08 | Hillsborough | Florida | 12057 | 103835 | 1358 |
1005171 | 1005171 | 2021-02-07 | Hillsborough | Florida | 12057 | 103599 | 1353 |
1001925 | 1001925 | 2021-02-06 | Hillsborough | Florida | 12057 | 103297 | 1350 |
998679 | 998679 | 2021-02-05 | Hillsborough | Florida | 12057 | 102944 | 1352 |
995433 | 995433 | 2021-02-04 | Hillsborough | Florida | 12057 | 102337 | 1342 |
992187 | 992187 | 2021-02-03 | Hillsborough | Florida | 12057 | 101910 | 1336 |
988941 | 988941 | 2021-02-02 | Hillsborough | Florida | 12057 | 101551 | 1317 |
985694 | 985694 | 2021-02-01 | Hillsborough | Florida | 12057 | 100990 | 1319 |
982447 | 982447 | 2021-01-31 | Hillsborough | Florida | 12057 | 100764 | 1293 |
979201 | 979201 | 2021-01-30 | Hillsborough | Florida | 12057 | 100334 | 1293 |
975956 | 975956 | 2021-01-29 | Hillsborough | Florida | 12057 | 99421 | 1293 |
972711 | 972711 | 2021-01-28 | Hillsborough | Florida | 12057 | 98900 | 1285 |
969466 | 969466 | 2021-01-27 | Hillsborough | Florida | 12057 | 98230 | 1270 |
966222 | 966222 | 2021-01-26 | Hillsborough | Florida | 12057 | 97809 | 1258 |
962977 | 962977 | 2021-01-25 | Hillsborough | Florida | 12057 | 97288 | 1250 |
959732 | 959732 | 2021-01-24 | Hillsborough | Florida | 12057 | 96795 | 1238 |
956486 | 956486 | 2021-01-23 | Hillsborough | Florida | 12057 | 96338 | 1233 |
953241 | 953241 | 2021-01-22 | Hillsborough | Florida | 12057 | 95477 | 1220 |
949996 | 949996 | 2021-01-21 | Hillsborough | Florida | 12057 | 94870 | 1215 |
946750 | 946750 | 2021-01-20 | Hillsborough | Florida | 12057 | 94012 | 1198 |
943503 | 943503 | 2021-01-19 | Hillsborough | Florida | 12057 | 93487 | 1197 |
940258 | 940258 | 2021-01-18 | Hillsborough | Florida | 12057 | 92891 | 1202 |
937013 | 937013 | 2021-01-17 | Hillsborough | Florida | 12057 | 92438 | 1175 |
933768 | 933768 | 2021-01-16 | Hillsborough | Florida | 12057 | 91632 | 1175 |
930523 | 930523 | 2021-01-15 | Hillsborough | Florida | 12057 | 90966 | 1173 |
927278 | 927278 | 2021-01-14 | Hillsborough | Florida | 12057 | 89989 | 1165 |
924032 | 924032 | 2021-01-13 | Hillsborough | Florida | 12057 | 89043 | 1153 |
920787 | 920787 | 2021-01-12 | Hillsborough | Florida | 12057 | 88217 | 1142 |
917542 | 917542 | 2021-01-11 | Hillsborough | Florida | 12057 | 87511 | 1142 |
914297 | 914297 | 2021-01-10 | Hillsborough | Florida | 12057 | 86509 | 1121 |
911052 | 911052 | 2021-01-09 | Hillsborough | Florida | 12057 | 85855 | 1121 |
907807 | 907807 | 2021-01-08 | Hillsborough | Florida | 12057 | 84714 | 1118 |
904561 | 904561 | 2021-01-07 | Hillsborough | Florida | 12057 | 83574 | 1110 |
901316 | 901316 | 2021-01-06 | Hillsborough | Florida | 12057 | 82257 | 1102 |
898071 | 898071 | 2021-01-05 | Hillsborough | Florida | 12057 | 81105 | 1093 |
894826 | 894826 | 2021-01-04 | Hillsborough | Florida | 12057 | 80586 | 1092 |
891579 | 891579 | 2021-01-03 | Hillsborough | Florida | 12057 | 80035 | 1090 |
888332 | 888332 | 2021-01-02 | Hillsborough | Florida | 12057 | 79472 | 1084 |
885087 | 885087 | 2021-01-01 | Hillsborough | Florida | 12057 | 77118 | 1071 |
881842 | 881842 | 2020-12-31 | Hillsborough | Florida | 12057 | 77118 | 1071 |
878597 | 878597 | 2020-12-30 | Hillsborough | Florida | 12057 | 76221 | 1068 |
875352 | 875352 | 2020-12-29 | Hillsborough | Florida | 12057 | 75547 | 1064 |
872107 | 872107 | 2020-12-28 | Hillsborough | Florida | 12057 | 74788 | 1064 |
868862 | 868862 | 2020-12-27 | Hillsborough | Florida | 12057 | 74368 | 1058 |
865617 | 865617 | 2020-12-26 | Hillsborough | Florida | 12057 | 73980 | 1058 |
862372 | 862372 | 2020-12-25 | Hillsborough | Florida | 12057 | 72860 | 1056 |
859127 | 859127 | 2020-12-24 | Hillsborough | Florida | 12057 | 72860 | 1056 |
855882 | 855882 | 2020-12-23 | Hillsborough | Florida | 12057 | 71957 | 1046 |
852637 | 852637 | 2020-12-22 | Hillsborough | Florida | 12057 | 71388 | 1038 |
849392 | 849392 | 2020-12-21 | Hillsborough | Florida | 12057 | 70849 | 1034 |
846147 | 846147 | 2020-12-20 | Hillsborough | Florida | 12057 | 70027 | 1026 |
842901 | 842901 | 2020-12-19 | Hillsborough | Florida | 12057 | 69530 | 1023 |
839656 | 839656 | 2020-12-18 | Hillsborough | Florida | 12057 | 68739 | 1021 |
836411 | 836411 | 2020-12-17 | Hillsborough | Florida | 12057 | 67801 | 1015 |
833165 | 833165 | 2020-12-16 | Hillsborough | Florida | 12057 | 67060 | 1011 |
829918 | 829918 | 2020-12-15 | Hillsborough | Florida | 12057 | 66548 | 996 |
826672 | 826672 | 2020-12-14 | Hillsborough | Florida | 12057 | 66041 | 999 |
823425 | 823425 | 2020-12-13 | Hillsborough | Florida | 12057 | 65502 | 986 |
820179 | 820179 | 2020-12-12 | Hillsborough | Florida | 12057 | 64999 | 985 |
816933 | 816933 | 2020-12-11 | Hillsborough | Florida | 12057 | 64281 | 984 |
813687 | 813687 | 2020-12-10 | Hillsborough | Florida | 12057 | 63339 | 977 |
810443 | 810443 | 2020-12-09 | Hillsborough | Florida | 12057 | 62439 | 972 |
807198 | 807198 | 2020-12-08 | Hillsborough | Florida | 12057 | 62149 | 969 |
803953 | 803953 | 2020-12-07 | Hillsborough | Florida | 12057 | 61599 | 967 |
800708 | 800708 | 2020-12-06 | Hillsborough | Florida | 12057 | 61276 | 960 |
797463 | 797463 | 2020-12-05 | Hillsborough | Florida | 12057 | 60761 | 959 |
794218 | 794218 | 2020-12-04 | Hillsborough | Florida | 12057 | 60241 | 955 |
790973 | 790973 | 2020-12-03 | Hillsborough | Florida | 12057 | 59809 | 947 |
787728 | 787728 | 2020-12-02 | Hillsborough | Florida | 12057 | 59270 | 938 |
784484 | 784484 | 2020-12-01 | Hillsborough | Florida | 12057 | 58749 | 933 |
781239 | 781239 | 2020-11-30 | Hillsborough | Florida | 12057 | 58293 | 932 |
777993 | 777993 | 2020-11-29 | Hillsborough | Florida | 12057 | 58092 | 929 |
774748 | 774748 | 2020-11-28 | Hillsborough | Florida | 12057 | 57728 | 923 |
771503 | 771503 | 2020-11-27 | Hillsborough | Florida | 12057 | 57371 | 920 |
768258 | 768258 | 2020-11-26 | Hillsborough | Florida | 12057 | 56497 | 904 |
765012 | 765012 | 2020-11-25 | Hillsborough | Florida | 12057 | 56497 | 904 |
761767 | 761767 | 2020-11-24 | Hillsborough | Florida | 12057 | 56166 | 892 |
758522 | 758522 | 2020-11-23 | Hillsborough | Florida | 12057 | 55835 | 897 |
755275 | 755275 | 2020-11-22 | Hillsborough | Florida | 12057 | 55482 | 885 |
752029 | 752029 | 2020-11-21 | Hillsborough | Florida | 12057 | 55257 | 884 |
748783 | 748783 | 2020-11-20 | Hillsborough | Florida | 12057 | 54792 | 885 |
745537 | 745537 | 2020-11-19 | Hillsborough | Florida | 12057 | 54326 | 883 |
742290 | 742290 | 2020-11-18 | Hillsborough | Florida | 12057 | 53900 | 877 |
739043 | 739043 | 2020-11-17 | Hillsborough | Florida | 12057 | 53432 | 866 |
735799 | 735799 | 2020-11-16 | Hillsborough | Florida | 12057 | 53187 | 866 |
732553 | 732553 | 2020-11-15 | Hillsborough | Florida | 12057 | 52907 | 857 |
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);