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 |
---|---|---|---|---|---|---|---|
1193431 | 1193431 | 2021-04-06 | Alachua | Florida | 12001 | 23645 | 259 |
1190181 | 1190181 | 2021-04-05 | Alachua | Florida | 12001 | 23611 | 259 |
1186934 | 1186934 | 2021-04-04 | Alachua | Florida | 12001 | 23588 | 259 |
1183687 | 1183687 | 2021-04-03 | Alachua | Florida | 12001 | 23559 | 259 |
1180440 | 1180440 | 2021-04-02 | Alachua | Florida | 12001 | 23506 | 259 |
1177193 | 1177193 | 2021-04-01 | Alachua | Florida | 12001 | 23440 | 259 |
1173946 | 1173946 | 2021-03-31 | Alachua | Florida | 12001 | 23378 | 259 |
1170699 | 1170699 | 2021-03-30 | Alachua | Florida | 12001 | 23339 | 259 |
1167451 | 1167451 | 2021-03-29 | Alachua | Florida | 12001 | 23283 | 259 |
1164203 | 1164203 | 2021-03-28 | Alachua | Florida | 12001 | 23273 | 258 |
1160955 | 1160955 | 2021-03-27 | Alachua | Florida | 12001 | 23239 | 258 |
1157707 | 1157707 | 2021-03-26 | Alachua | Florida | 12001 | 23192 | 255 |
1154460 | 1154460 | 2021-03-25 | Alachua | Florida | 12001 | 23139 | 255 |
1151213 | 1151213 | 2021-03-24 | Alachua | Florida | 12001 | 23098 | 255 |
1147966 | 1147966 | 2021-03-23 | Alachua | Florida | 12001 | 23068 | 252 |
1144719 | 1144719 | 2021-03-22 | Alachua | Florida | 12001 | 23039 | 252 |
1141472 | 1141472 | 2021-03-21 | Alachua | Florida | 12001 | 23015 | 252 |
1138226 | 1138226 | 2021-03-20 | Alachua | Florida | 12001 | 22994 | 252 |
1134980 | 1134980 | 2021-03-19 | Alachua | Florida | 12001 | 22957 | 252 |
1131733 | 1131733 | 2021-03-18 | Alachua | Florida | 12001 | 22911 | 252 |
1128485 | 1128485 | 2021-03-17 | Alachua | Florida | 12001 | 22880 | 251 |
1125239 | 1125239 | 2021-03-16 | Alachua | Florida | 12001 | 22860 | 250 |
1121993 | 1121993 | 2021-03-15 | Alachua | Florida | 12001 | 22828 | 250 |
1118746 | 1118746 | 2021-03-14 | Alachua | Florida | 12001 | 22816 | 249 |
1115499 | 1115499 | 2021-03-13 | Alachua | Florida | 12001 | 22798 | 249 |
1112253 | 1112253 | 2021-03-12 | Alachua | Florida | 12001 | 22763 | 248 |
1109007 | 1109007 | 2021-03-11 | Alachua | Florida | 12001 | 22736 | 248 |
1105761 | 1105761 | 2021-03-10 | Alachua | Florida | 12001 | 22697 | 248 |
1102515 | 1102515 | 2021-03-09 | Alachua | Florida | 12001 | 22655 | 242 |
1099269 | 1099269 | 2021-03-08 | Alachua | Florida | 12001 | 22612 | 242 |
1096021 | 1096021 | 2021-03-07 | Alachua | Florida | 12001 | 22599 | 236 |
1092775 | 1092775 | 2021-03-06 | Alachua | Florida | 12001 | 22588 | 235 |
1089529 | 1089529 | 2021-03-05 | Alachua | Florida | 12001 | 22555 | 235 |
1086284 | 1086284 | 2021-03-04 | Alachua | Florida | 12001 | 22512 | 235 |
1083038 | 1083038 | 2021-03-03 | Alachua | Florida | 12001 | 22458 | 235 |
1079792 | 1079792 | 2021-03-02 | Alachua | Florida | 12001 | 22412 | 235 |
1076547 | 1076547 | 2021-03-01 | Alachua | Florida | 12001 | 22371 | 234 |
1073301 | 1073301 | 2021-02-28 | Alachua | Florida | 12001 | 22354 | 232 |
1070055 | 1070055 | 2021-02-27 | Alachua | Florida | 12001 | 22319 | 228 |
1066810 | 1066810 | 2021-02-26 | Alachua | Florida | 12001 | 22293 | 228 |
1063565 | 1063565 | 2021-02-25 | Alachua | Florida | 12001 | 22272 | 228 |
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 |
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);