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 |
---|---|---|---|---|---|---|---|
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 |
735780 | 735780 | 2020-11-16 | Citrus | Florida | 12017 | 3957 | 148 |
732534 | 732534 | 2020-11-15 | Citrus | Florida | 12017 | 3927 | 147 |
729289 | 729289 | 2020-11-14 | Citrus | Florida | 12017 | 3856 | 146 |
726046 | 726046 | 2020-11-13 | Citrus | Florida | 12017 | 3828 | 143 |
722803 | 722803 | 2020-11-12 | Citrus | Florida | 12017 | 3741 | 143 |
719560 | 719560 | 2020-11-11 | Citrus | Florida | 12017 | 3696 | 143 |
716317 | 716317 | 2020-11-10 | Citrus | Florida | 12017 | 3655 | 143 |
713073 | 713073 | 2020-11-09 | Citrus | Florida | 12017 | 3614 | 142 |
709829 | 709829 | 2020-11-08 | Citrus | Florida | 12017 | 3584 | 142 |
706585 | 706585 | 2020-11-07 | Citrus | Florida | 12017 | 3493 | 142 |
703342 | 703342 | 2020-11-06 | Citrus | Florida | 12017 | 3440 | 139 |
700099 | 700099 | 2020-11-05 | Citrus | Florida | 12017 | 3402 | 136 |
696855 | 696855 | 2020-11-04 | Citrus | Florida | 12017 | 3369 | 136 |
693613 | 693613 | 2020-11-03 | Citrus | Florida | 12017 | 3344 | 136 |
690370 | 690370 | 2020-11-02 | Citrus | Florida | 12017 | 3328 | 135 |
687125 | 687125 | 2020-11-01 | Citrus | Florida | 12017 | 3308 | 135 |
683881 | 683881 | 2020-10-31 | Citrus | Florida | 12017 | 3275 | 135 |
680638 | 680638 | 2020-10-30 | Citrus | Florida | 12017 | 3260 | 135 |
677395 | 677395 | 2020-10-29 | Citrus | Florida | 12017 | 3224 | 134 |
674152 | 674152 | 2020-10-28 | Citrus | Florida | 12017 | 3210 | 131 |
670910 | 670910 | 2020-10-27 | Citrus | Florida | 12017 | 3195 | 130 |
667667 | 667667 | 2020-10-26 | Citrus | Florida | 12017 | 3178 | 130 |
664422 | 664422 | 2020-10-25 | Citrus | Florida | 12017 | 3162 | 130 |
661178 | 661178 | 2020-10-24 | Citrus | Florida | 12017 | 3145 | 130 |
657934 | 657934 | 2020-10-23 | Citrus | Florida | 12017 | 3124 | 130 |
654689 | 654689 | 2020-10-22 | Citrus | Florida | 12017 | 3091 | 130 |
651444 | 651444 | 2020-10-21 | Citrus | Florida | 12017 | 3070 | 131 |
648200 | 648200 | 2020-10-20 | Citrus | Florida | 12017 | 3059 | 131 |
644955 | 644955 | 2020-10-19 | Citrus | Florida | 12017 | 3045 | 131 |
641707 | 641707 | 2020-10-18 | Citrus | Florida | 12017 | 3040 | 130 |
638460 | 638460 | 2020-10-17 | Citrus | Florida | 12017 | 3030 | 126 |
635215 | 635215 | 2020-10-16 | Citrus | Florida | 12017 | 3000 | 125 |
631969 | 631969 | 2020-10-15 | Citrus | Florida | 12017 | 2988 | 124 |
628725 | 628725 | 2020-10-14 | Citrus | Florida | 12017 | 2983 | 124 |
625482 | 625482 | 2020-10-13 | Citrus | Florida | 12017 | 2960 | 121 |
622239 | 622239 | 2020-10-12 | Citrus | Florida | 12017 | 2950 | 118 |
618996 | 618996 | 2020-10-11 | Citrus | Florida | 12017 | 2947 | 118 |
615754 | 615754 | 2020-10-10 | Citrus | Florida | 12017 | 2914 | 115 |
612513 | 612513 | 2020-10-09 | Citrus | Florida | 12017 | 2914 | 115 |
609271 | 609271 | 2020-10-08 | Citrus | Florida | 12017 | 2898 | 112 |
606028 | 606028 | 2020-10-07 | Citrus | Florida | 12017 | 2883 | 112 |
602786 | 602786 | 2020-10-06 | Citrus | Florida | 12017 | 2863 | 111 |
599543 | 599543 | 2020-10-05 | Citrus | Florida | 12017 | 2846 | 110 |
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);