ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 12017 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1060328 | 1060328 | 2021-02-24 | Citrus | Florida | 12017 | 9641 | 391 |
1057082 | 1057082 | 2021-02-23 | Citrus | Florida | 12017 | 9606 | 386 |
1053836 | 1053836 | 2021-02-22 | Citrus | Florida | 12017 | 9585 | 386 |
1050589 | 1050589 | 2021-02-21 | Citrus | Florida | 12017 | 9571 | 384 |
1047342 | 1047342 | 2021-02-20 | Citrus | Florida | 12017 | 9551 | 382 |
1044097 | 1044097 | 2021-02-19 | Citrus | Florida | 12017 | 9509 | 380 |
1040852 | 1040852 | 2021-02-18 | Citrus | Florida | 12017 | 9479 | 376 |
1037607 | 1037607 | 2021-02-17 | Citrus | Florida | 12017 | 9433 | 373 |
1034362 | 1034362 | 2021-02-16 | Citrus | Florida | 12017 | 9392 | 365 |
1031116 | 1031116 | 2021-02-15 | Citrus | Florida | 12017 | 9347 | 363 |
1027869 | 1027869 | 2021-02-14 | Citrus | Florida | 12017 | 9329 | 362 |
1024624 | 1024624 | 2021-02-13 | Citrus | Florida | 12017 | 9287 | 362 |
1021379 | 1021379 | 2021-02-12 | Citrus | Florida | 12017 | 9252 | 362 |
1018134 | 1018134 | 2021-02-11 | Citrus | Florida | 12017 | 9210 | 362 |
1014889 | 1014889 | 2021-02-10 | Citrus | Florida | 12017 | 9127 | 362 |
1011644 | 1011644 | 2021-02-09 | Citrus | Florida | 12017 | 9082 | 365 |
1008398 | 1008398 | 2021-02-08 | Citrus | Florida | 12017 | 9058 | 363 |
1005152 | 1005152 | 2021-02-07 | Citrus | Florida | 12017 | 9037 | 363 |
1001906 | 1001906 | 2021-02-06 | Citrus | Florida | 12017 | 8994 | 362 |
998660 | 998660 | 2021-02-05 | Citrus | Florida | 12017 | 8921 | 356 |
995414 | 995414 | 2021-02-04 | Citrus | Florida | 12017 | 8853 | 356 |
992168 | 992168 | 2021-02-03 | Citrus | Florida | 12017 | 8778 | 354 |
988922 | 988922 | 2021-02-02 | Citrus | Florida | 12017 | 8743 | 353 |
985675 | 985675 | 2021-02-01 | Citrus | Florida | 12017 | 8696 | 344 |
982428 | 982428 | 2021-01-31 | Citrus | Florida | 12017 | 8676 | 344 |
979182 | 979182 | 2021-01-30 | Citrus | Florida | 12017 | 8642 | 344 |
975937 | 975937 | 2021-01-29 | Citrus | Florida | 12017 | 8550 | 345 |
972692 | 972692 | 2021-01-28 | Citrus | Florida | 12017 | 8491 | 341 |
969447 | 969447 | 2021-01-27 | Citrus | Florida | 12017 | 8432 | 336 |
966203 | 966203 | 2021-01-26 | Citrus | Florida | 12017 | 8398 | 336 |
962958 | 962958 | 2021-01-25 | Citrus | Florida | 12017 | 8334 | 330 |
959713 | 959713 | 2021-01-24 | Citrus | Florida | 12017 | 8300 | 330 |
956467 | 956467 | 2021-01-23 | Citrus | Florida | 12017 | 8236 | 330 |
953222 | 953222 | 2021-01-22 | Citrus | Florida | 12017 | 8192 | 323 |
949977 | 949977 | 2021-01-21 | Citrus | Florida | 12017 | 8109 | 323 |
946731 | 946731 | 2021-01-20 | Citrus | Florida | 12017 | 8036 | 319 |
943484 | 943484 | 2021-01-19 | Citrus | Florida | 12017 | 7981 | 316 |
940239 | 940239 | 2021-01-18 | Citrus | Florida | 12017 | 7929 | 309 |
936994 | 936994 | 2021-01-17 | Citrus | Florida | 12017 | 7905 | 308 |
933749 | 933749 | 2021-01-16 | Citrus | Florida | 12017 | 7861 | 308 |
930504 | 930504 | 2021-01-15 | Citrus | Florida | 12017 | 7803 | 308 |
927259 | 927259 | 2021-01-14 | Citrus | Florida | 12017 | 7705 | 299 |
924013 | 924013 | 2021-01-13 | Citrus | Florida | 12017 | 7660 | 299 |
920768 | 920768 | 2021-01-12 | Citrus | Florida | 12017 | 7588 | 296 |
917523 | 917523 | 2021-01-11 | Citrus | Florida | 12017 | 7506 | 297 |
914278 | 914278 | 2021-01-10 | Citrus | Florida | 12017 | 7469 | 287 |
911033 | 911033 | 2021-01-09 | Citrus | Florida | 12017 | 7401 | 287 |
907788 | 907788 | 2021-01-08 | Citrus | Florida | 12017 | 7340 | 283 |
904542 | 904542 | 2021-01-07 | Citrus | Florida | 12017 | 7226 | 282 |
901297 | 901297 | 2021-01-06 | Citrus | Florida | 12017 | 7138 | 276 |
898052 | 898052 | 2021-01-05 | Citrus | Florida | 12017 | 7022 | 275 |
894807 | 894807 | 2021-01-04 | Citrus | Florida | 12017 | 6955 | 283 |
891560 | 891560 | 2021-01-03 | Citrus | Florida | 12017 | 6903 | 283 |
888313 | 888313 | 2021-01-02 | Citrus | Florida | 12017 | 6832 | 274 |
885068 | 885068 | 2021-01-01 | Citrus | Florida | 12017 | 6663 | 266 |
881823 | 881823 | 2020-12-31 | Citrus | Florida | 12017 | 6663 | 266 |
878578 | 878578 | 2020-12-30 | Citrus | Florida | 12017 | 6567 | 261 |
875333 | 875333 | 2020-12-29 | Citrus | Florida | 12017 | 6508 | 260 |
872088 | 872088 | 2020-12-28 | Citrus | Florida | 12017 | 6467 | 260 |
868843 | 868843 | 2020-12-27 | Citrus | Florida | 12017 | 6417 | 251 |
865598 | 865598 | 2020-12-26 | Citrus | Florida | 12017 | 6359 | 251 |
862353 | 862353 | 2020-12-25 | Citrus | Florida | 12017 | 6239 | 249 |
859108 | 859108 | 2020-12-24 | Citrus | Florida | 12017 | 6239 | 249 |
855863 | 855863 | 2020-12-23 | Citrus | Florida | 12017 | 6176 | 239 |
852618 | 852618 | 2020-12-22 | Citrus | Florida | 12017 | 6111 | 226 |
849373 | 849373 | 2020-12-21 | Citrus | Florida | 12017 | 6050 | 224 |
846128 | 846128 | 2020-12-20 | Citrus | Florida | 12017 | 5985 | 220 |
842882 | 842882 | 2020-12-19 | Citrus | Florida | 12017 | 5942 | 218 |
839637 | 839637 | 2020-12-18 | Citrus | Florida | 12017 | 5877 | 218 |
836392 | 836392 | 2020-12-17 | Citrus | Florida | 12017 | 5774 | 223 |
833146 | 833146 | 2020-12-16 | Citrus | Florida | 12017 | 5699 | 223 |
829899 | 829899 | 2020-12-15 | Citrus | Florida | 12017 | 5646 | 223 |
826653 | 826653 | 2020-12-14 | Citrus | Florida | 12017 | 5570 | 219 |
823406 | 823406 | 2020-12-13 | Citrus | Florida | 12017 | 5532 | 216 |
820160 | 820160 | 2020-12-12 | Citrus | Florida | 12017 | 5469 | 204 |
816914 | 816914 | 2020-12-11 | Citrus | Florida | 12017 | 5427 | 203 |
813668 | 813668 | 2020-12-10 | Citrus | Florida | 12017 | 5350 | 188 |
810424 | 810424 | 2020-12-09 | Citrus | Florida | 12017 | 5304 | 188 |
807179 | 807179 | 2020-12-08 | Citrus | Florida | 12017 | 5217 | 186 |
803934 | 803934 | 2020-12-07 | Citrus | Florida | 12017 | 5170 | 184 |
800689 | 800689 | 2020-12-06 | Citrus | Florida | 12017 | 5143 | 181 |
797444 | 797444 | 2020-12-05 | Citrus | Florida | 12017 | 5096 | 181 |
794199 | 794199 | 2020-12-04 | Citrus | Florida | 12017 | 5015 | 177 |
790954 | 790954 | 2020-12-03 | Citrus | Florida | 12017 | 4945 | 176 |
787709 | 787709 | 2020-12-02 | Citrus | Florida | 12017 | 4899 | 174 |
784465 | 784465 | 2020-12-01 | Citrus | Florida | 12017 | 4790 | 171 |
781220 | 781220 | 2020-11-30 | Citrus | Florida | 12017 | 4753 | 171 |
777974 | 777974 | 2020-11-29 | Citrus | Florida | 12017 | 4731 | 168 |
774729 | 774729 | 2020-11-28 | Citrus | Florida | 12017 | 4700 | 165 |
771484 | 771484 | 2020-11-27 | Citrus | Florida | 12017 | 4623 | 165 |
768239 | 768239 | 2020-11-26 | Citrus | Florida | 12017 | 4498 | 160 |
764993 | 764993 | 2020-11-25 | Citrus | Florida | 12017 | 4498 | 160 |
761748 | 761748 | 2020-11-24 | Citrus | Florida | 12017 | 4408 | 158 |
758503 | 758503 | 2020-11-23 | Citrus | Florida | 12017 | 4358 | 158 |
755256 | 755256 | 2020-11-22 | Citrus | Florida | 12017 | 4330 | 157 |
752010 | 752010 | 2020-11-21 | Citrus | Florida | 12017 | 4266 | 157 |
748764 | 748764 | 2020-11-20 | Citrus | Florida | 12017 | 4218 | 157 |
745518 | 745518 | 2020-11-19 | Citrus | Florida | 12017 | 4125 | 152 |
742271 | 742271 | 2020-11-18 | Citrus | Florida | 12017 | 4086 | 150 |
739024 | 739024 | 2020-11-17 | Citrus | Florida | 12017 | 4019 | 149 |
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);