ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 12001 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1060320 | 1060320 | 2021-02-24 | Alachua | Florida | 12001 | 22228 | 226 |
1057074 | 1057074 | 2021-02-23 | Alachua | Florida | 12001 | 22197 | 222 |
1053828 | 1053828 | 2021-02-22 | Alachua | Florida | 12001 | 22154 | 220 |
1050581 | 1050581 | 2021-02-21 | Alachua | Florida | 12001 | 22133 | 214 |
1047334 | 1047334 | 2021-02-20 | Alachua | Florida | 12001 | 22102 | 208 |
1044089 | 1044089 | 2021-02-19 | Alachua | Florida | 12001 | 22062 | 206 |
1040844 | 1040844 | 2021-02-18 | Alachua | Florida | 12001 | 22004 | 203 |
1037599 | 1037599 | 2021-02-17 | Alachua | Florida | 12001 | 21960 | 203 |
1034354 | 1034354 | 2021-02-16 | Alachua | Florida | 12001 | 21887 | 201 |
1031108 | 1031108 | 2021-02-15 | Alachua | Florida | 12001 | 21830 | 199 |
1027861 | 1027861 | 2021-02-14 | Alachua | Florida | 12001 | 21791 | 195 |
1024616 | 1024616 | 2021-02-13 | Alachua | Florida | 12001 | 21756 | 191 |
1021371 | 1021371 | 2021-02-12 | Alachua | Florida | 12001 | 21693 | 191 |
1018126 | 1018126 | 2021-02-11 | Alachua | Florida | 12001 | 21649 | 189 |
1014881 | 1014881 | 2021-02-10 | Alachua | Florida | 12001 | 21552 | 186 |
1011636 | 1011636 | 2021-02-09 | Alachua | Florida | 12001 | 21482 | 186 |
1008390 | 1008390 | 2021-02-08 | Alachua | Florida | 12001 | 21401 | 185 |
1005144 | 1005144 | 2021-02-07 | Alachua | Florida | 12001 | 21353 | 183 |
1001898 | 1001898 | 2021-02-06 | Alachua | Florida | 12001 | 21302 | 182 |
998652 | 998652 | 2021-02-05 | Alachua | Florida | 12001 | 21197 | 179 |
995406 | 995406 | 2021-02-04 | Alachua | Florida | 12001 | 21055 | 176 |
992160 | 992160 | 2021-02-03 | Alachua | Florida | 12001 | 20922 | 176 |
988914 | 988914 | 2021-02-02 | Alachua | Florida | 12001 | 20817 | 174 |
985667 | 985667 | 2021-02-01 | Alachua | Florida | 12001 | 20692 | 174 |
982420 | 982420 | 2021-01-31 | Alachua | Florida | 12001 | 20655 | 171 |
979174 | 979174 | 2021-01-30 | Alachua | Florida | 12001 | 20566 | 166 |
975929 | 975929 | 2021-01-29 | Alachua | Florida | 12001 | 20361 | 165 |
972684 | 972684 | 2021-01-28 | Alachua | Florida | 12001 | 20227 | 165 |
969439 | 969439 | 2021-01-27 | Alachua | Florida | 12001 | 20062 | 164 |
966195 | 966195 | 2021-01-26 | Alachua | Florida | 12001 | 19928 | 166 |
962950 | 962950 | 2021-01-25 | Alachua | Florida | 12001 | 19799 | 164 |
959705 | 959705 | 2021-01-24 | Alachua | Florida | 12001 | 19723 | 163 |
956459 | 956459 | 2021-01-23 | Alachua | Florida | 12001 | 19581 | 158 |
953214 | 953214 | 2021-01-22 | Alachua | Florida | 12001 | 19408 | 158 |
949969 | 949969 | 2021-01-21 | Alachua | Florida | 12001 | 19274 | 158 |
946723 | 946723 | 2021-01-20 | Alachua | Florida | 12001 | 19136 | 156 |
943476 | 943476 | 2021-01-19 | Alachua | Florida | 12001 | 18986 | 156 |
940231 | 940231 | 2021-01-18 | Alachua | Florida | 12001 | 18862 | 154 |
936986 | 936986 | 2021-01-17 | Alachua | Florida | 12001 | 18777 | 146 |
933741 | 933741 | 2021-01-16 | Alachua | Florida | 12001 | 18655 | 145 |
930496 | 930496 | 2021-01-15 | Alachua | Florida | 12001 | 18508 | 144 |
927251 | 927251 | 2021-01-14 | Alachua | Florida | 12001 | 18291 | 143 |
924005 | 924005 | 2021-01-13 | Alachua | Florida | 12001 | 18103 | 141 |
920760 | 920760 | 2021-01-12 | Alachua | Florida | 12001 | 17878 | 141 |
917515 | 917515 | 2021-01-11 | Alachua | Florida | 12001 | 17727 | 141 |
914270 | 914270 | 2021-01-10 | Alachua | Florida | 12001 | 17614 | 139 |
911025 | 911025 | 2021-01-09 | Alachua | Florida | 12001 | 17430 | 138 |
907780 | 907780 | 2021-01-08 | Alachua | Florida | 12001 | 17254 | 137 |
904534 | 904534 | 2021-01-07 | Alachua | Florida | 12001 | 17000 | 136 |
901289 | 901289 | 2021-01-06 | Alachua | Florida | 12001 | 16804 | 136 |
898044 | 898044 | 2021-01-05 | Alachua | Florida | 12001 | 16585 | 136 |
894799 | 894799 | 2021-01-04 | Alachua | Florida | 12001 | 16437 | 136 |
891552 | 891552 | 2021-01-03 | Alachua | Florida | 12001 | 16335 | 133 |
888305 | 888305 | 2021-01-02 | Alachua | Florida | 12001 | 16230 | 133 |
885060 | 885060 | 2021-01-01 | Alachua | Florida | 12001 | 15866 | 129 |
881815 | 881815 | 2020-12-31 | Alachua | Florida | 12001 | 15866 | 129 |
878570 | 878570 | 2020-12-30 | Alachua | Florida | 12001 | 15674 | 128 |
875325 | 875325 | 2020-12-29 | Alachua | Florida | 12001 | 15574 | 128 |
872080 | 872080 | 2020-12-28 | Alachua | Florida | 12001 | 15473 | 128 |
868835 | 868835 | 2020-12-27 | Alachua | Florida | 12001 | 15420 | 124 |
865590 | 865590 | 2020-12-26 | Alachua | Florida | 12001 | 15370 | 122 |
862345 | 862345 | 2020-12-25 | Alachua | Florida | 12001 | 15182 | 116 |
859100 | 859100 | 2020-12-24 | Alachua | Florida | 12001 | 15182 | 116 |
855855 | 855855 | 2020-12-23 | Alachua | Florida | 12001 | 15074 | 116 |
852610 | 852610 | 2020-12-22 | Alachua | Florida | 12001 | 14981 | 116 |
849365 | 849365 | 2020-12-21 | Alachua | Florida | 12001 | 14890 | 116 |
846120 | 846120 | 2020-12-20 | Alachua | Florida | 12001 | 14768 | 115 |
842874 | 842874 | 2020-12-19 | Alachua | Florida | 12001 | 14716 | 114 |
839629 | 839629 | 2020-12-18 | Alachua | Florida | 12001 | 14585 | 112 |
836384 | 836384 | 2020-12-17 | Alachua | Florida | 12001 | 14468 | 110 |
833138 | 833138 | 2020-12-16 | Alachua | Florida | 12001 | 14323 | 110 |
829891 | 829891 | 2020-12-15 | Alachua | Florida | 12001 | 14225 | 108 |
826645 | 826645 | 2020-12-14 | Alachua | Florida | 12001 | 14128 | 108 |
823398 | 823398 | 2020-12-13 | Alachua | Florida | 12001 | 14039 | 106 |
820152 | 820152 | 2020-12-12 | Alachua | Florida | 12001 | 13971 | 106 |
816906 | 816906 | 2020-12-11 | Alachua | Florida | 12001 | 13869 | 106 |
813660 | 813660 | 2020-12-10 | Alachua | Florida | 12001 | 13782 | 106 |
810416 | 810416 | 2020-12-09 | Alachua | Florida | 12001 | 13649 | 106 |
807171 | 807171 | 2020-12-08 | Alachua | Florida | 12001 | 13567 | 104 |
803926 | 803926 | 2020-12-07 | Alachua | Florida | 12001 | 13479 | 104 |
800681 | 800681 | 2020-12-06 | Alachua | Florida | 12001 | 13382 | 103 |
797436 | 797436 | 2020-12-05 | Alachua | Florida | 12001 | 13314 | 103 |
794191 | 794191 | 2020-12-04 | Alachua | Florida | 12001 | 13190 | 103 |
790946 | 790946 | 2020-12-03 | Alachua | Florida | 12001 | 13118 | 102 |
787701 | 787701 | 2020-12-02 | Alachua | Florida | 12001 | 13017 | 102 |
784457 | 784457 | 2020-12-01 | Alachua | Florida | 12001 | 12911 | 102 |
781212 | 781212 | 2020-11-30 | Alachua | Florida | 12001 | 12864 | 102 |
777966 | 777966 | 2020-11-29 | Alachua | Florida | 12001 | 12813 | 102 |
774721 | 774721 | 2020-11-28 | Alachua | Florida | 12001 | 12769 | 99 |
771476 | 771476 | 2020-11-27 | Alachua | Florida | 12001 | 12704 | 99 |
768231 | 768231 | 2020-11-26 | Alachua | Florida | 12001 | 12549 | 98 |
764985 | 764985 | 2020-11-25 | Alachua | Florida | 12001 | 12549 | 98 |
761740 | 761740 | 2020-11-24 | Alachua | Florida | 12001 | 12468 | 98 |
758495 | 758495 | 2020-11-23 | Alachua | Florida | 12001 | 12395 | 97 |
755248 | 755248 | 2020-11-22 | Alachua | Florida | 12001 | 12339 | 96 |
752002 | 752002 | 2020-11-21 | Alachua | Florida | 12001 | 12272 | 92 |
748756 | 748756 | 2020-11-20 | Alachua | Florida | 12001 | 12176 | 92 |
745510 | 745510 | 2020-11-19 | Alachua | Florida | 12001 | 12113 | 91 |
742263 | 742263 | 2020-11-18 | Alachua | Florida | 12001 | 11994 | 91 |
739016 | 739016 | 2020-11-17 | Alachua | Florida | 12001 | 11854 | 88 |
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);