ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where deaths = 4 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Franklin 113
- Baker 87
- Dixie 77
- Jefferson 41
- Flagler 37
- Monroe 37
- Glades 32
- Bay 27
- St. Johns 27
- Madison 25
- Bradford 24
- Hamilton 24
- DeSoto 19
- Hardee 16
- Holmes 15
- Calhoun 14
- Union 14
- Columbia 13
- Putnam 13
- Gadsden 11
- Wakulla 10
- Martin 9
- Lafayette 8
- Marion 8
- Osceola 7
- Washington 7
- Levy 6
- Orange 6
- Taylor 6
- Clay 4
- …
state 1
- Florida · 787 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
943493 | 943493 | 2021-01-19 | Franklin | Florida | 12037 | 1127 | 4 |
940248 | 940248 | 2021-01-18 | Franklin | Florida | 12037 | 1124 | 4 |
937003 | 937003 | 2021-01-17 | Franklin | Florida | 12037 | 1120 | 4 |
933758 | 933758 | 2021-01-16 | Franklin | Florida | 12037 | 1105 | 4 |
930513 | 930513 | 2021-01-15 | Franklin | Florida | 12037 | 1098 | 4 |
927268 | 927268 | 2021-01-14 | Franklin | Florida | 12037 | 1082 | 4 |
924022 | 924022 | 2021-01-13 | Franklin | Florida | 12037 | 1058 | 4 |
920777 | 920777 | 2021-01-12 | Franklin | Florida | 12037 | 1048 | 4 |
917532 | 917532 | 2021-01-11 | Franklin | Florida | 12037 | 1022 | 4 |
914287 | 914287 | 2021-01-10 | Franklin | Florida | 12037 | 1017 | 4 |
911042 | 911042 | 2021-01-09 | Franklin | Florida | 12037 | 1008 | 4 |
907797 | 907797 | 2021-01-08 | Franklin | Florida | 12037 | 1004 | 4 |
904551 | 904551 | 2021-01-07 | Franklin | Florida | 12037 | 992 | 4 |
901306 | 901306 | 2021-01-06 | Franklin | Florida | 12037 | 977 | 4 |
898061 | 898061 | 2021-01-05 | Franklin | Florida | 12037 | 964 | 4 |
894816 | 894816 | 2021-01-04 | Franklin | Florida | 12037 | 950 | 4 |
891569 | 891569 | 2021-01-03 | Franklin | Florida | 12037 | 948 | 4 |
888322 | 888322 | 2021-01-02 | Franklin | Florida | 12037 | 942 | 4 |
885077 | 885077 | 2021-01-01 | Franklin | Florida | 12037 | 900 | 4 |
881832 | 881832 | 2020-12-31 | Franklin | Florida | 12037 | 900 | 4 |
878587 | 878587 | 2020-12-30 | Franklin | Florida | 12037 | 892 | 4 |
875342 | 875342 | 2020-12-29 | Franklin | Florida | 12037 | 882 | 4 |
872097 | 872097 | 2020-12-28 | Franklin | Florida | 12037 | 878 | 4 |
868852 | 868852 | 2020-12-27 | Franklin | Florida | 12037 | 877 | 4 |
865607 | 865607 | 2020-12-26 | Franklin | Florida | 12037 | 876 | 4 |
862362 | 862362 | 2020-12-25 | Franklin | Florida | 12037 | 868 | 4 |
859117 | 859117 | 2020-12-24 | Franklin | Florida | 12037 | 868 | 4 |
855872 | 855872 | 2020-12-23 | Franklin | Florida | 12037 | 860 | 4 |
852627 | 852627 | 2020-12-22 | Franklin | Florida | 12037 | 860 | 4 |
849382 | 849382 | 2020-12-21 | Franklin | Florida | 12037 | 858 | 4 |
846137 | 846137 | 2020-12-20 | Franklin | Florida | 12037 | 858 | 4 |
842891 | 842891 | 2020-12-19 | Franklin | Florida | 12037 | 857 | 4 |
839646 | 839646 | 2020-12-18 | Franklin | Florida | 12037 | 854 | 4 |
836401 | 836401 | 2020-12-17 | Franklin | Florida | 12037 | 853 | 4 |
833155 | 833155 | 2020-12-16 | Franklin | Florida | 12037 | 852 | 4 |
829908 | 829908 | 2020-12-15 | Franklin | Florida | 12037 | 850 | 4 |
826662 | 826662 | 2020-12-14 | Franklin | Florida | 12037 | 850 | 4 |
823415 | 823415 | 2020-12-13 | Franklin | Florida | 12037 | 849 | 4 |
820169 | 820169 | 2020-12-12 | Franklin | Florida | 12037 | 848 | 4 |
816923 | 816923 | 2020-12-11 | Franklin | Florida | 12037 | 843 | 4 |
813677 | 813677 | 2020-12-10 | Franklin | Florida | 12037 | 842 | 4 |
810433 | 810433 | 2020-12-09 | Franklin | Florida | 12037 | 843 | 4 |
807188 | 807188 | 2020-12-08 | Franklin | Florida | 12037 | 840 | 4 |
803943 | 803943 | 2020-12-07 | Franklin | Florida | 12037 | 840 | 4 |
800698 | 800698 | 2020-12-06 | Franklin | Florida | 12037 | 838 | 4 |
797453 | 797453 | 2020-12-05 | Franklin | Florida | 12037 | 835 | 4 |
794208 | 794208 | 2020-12-04 | Franklin | Florida | 12037 | 834 | 4 |
790963 | 790963 | 2020-12-03 | Franklin | Florida | 12037 | 833 | 4 |
787718 | 787718 | 2020-12-02 | Franklin | Florida | 12037 | 832 | 4 |
784474 | 784474 | 2020-12-01 | Franklin | Florida | 12037 | 830 | 4 |
781229 | 781229 | 2020-11-30 | Franklin | Florida | 12037 | 830 | 4 |
777983 | 777983 | 2020-11-29 | Franklin | Florida | 12037 | 830 | 4 |
774738 | 774738 | 2020-11-28 | Franklin | Florida | 12037 | 830 | 4 |
771493 | 771493 | 2020-11-27 | Franklin | Florida | 12037 | 830 | 4 |
768248 | 768248 | 2020-11-26 | Franklin | Florida | 12037 | 828 | 4 |
765002 | 765002 | 2020-11-25 | Franklin | Florida | 12037 | 828 | 4 |
761757 | 761757 | 2020-11-24 | Franklin | Florida | 12037 | 826 | 4 |
758512 | 758512 | 2020-11-23 | Franklin | Florida | 12037 | 826 | 4 |
755265 | 755265 | 2020-11-22 | Franklin | Florida | 12037 | 826 | 4 |
752019 | 752019 | 2020-11-21 | Franklin | Florida | 12037 | 823 | 4 |
748773 | 748773 | 2020-11-20 | Franklin | Florida | 12037 | 816 | 4 |
745527 | 745527 | 2020-11-19 | Franklin | Florida | 12037 | 813 | 4 |
742280 | 742280 | 2020-11-18 | Franklin | Florida | 12037 | 809 | 4 |
739033 | 739033 | 2020-11-17 | Franklin | Florida | 12037 | 809 | 4 |
735789 | 735789 | 2020-11-16 | Franklin | Florida | 12037 | 809 | 4 |
732543 | 732543 | 2020-11-15 | Franklin | Florida | 12037 | 809 | 4 |
729298 | 729298 | 2020-11-14 | Franklin | Florida | 12037 | 808 | 4 |
726055 | 726055 | 2020-11-13 | Franklin | Florida | 12037 | 806 | 4 |
722812 | 722812 | 2020-11-12 | Franklin | Florida | 12037 | 805 | 4 |
719569 | 719569 | 2020-11-11 | Franklin | Florida | 12037 | 802 | 4 |
716326 | 716326 | 2020-11-10 | Franklin | Florida | 12037 | 796 | 4 |
713082 | 713082 | 2020-11-09 | Franklin | Florida | 12037 | 796 | 4 |
709838 | 709838 | 2020-11-08 | Franklin | Florida | 12037 | 794 | 4 |
706594 | 706594 | 2020-11-07 | Franklin | Florida | 12037 | 791 | 4 |
703351 | 703351 | 2020-11-06 | Franklin | Florida | 12037 | 791 | 4 |
700108 | 700108 | 2020-11-05 | Franklin | Florida | 12037 | 792 | 4 |
696864 | 696864 | 2020-11-04 | Franklin | Florida | 12037 | 791 | 4 |
693622 | 693622 | 2020-11-03 | Franklin | Florida | 12037 | 786 | 4 |
690379 | 690379 | 2020-11-02 | Franklin | Florida | 12037 | 785 | 4 |
687134 | 687134 | 2020-11-01 | Franklin | Florida | 12037 | 784 | 4 |
683890 | 683890 | 2020-10-31 | Franklin | Florida | 12037 | 773 | 4 |
680647 | 680647 | 2020-10-30 | Franklin | Florida | 12037 | 773 | 4 |
677404 | 677404 | 2020-10-29 | Franklin | Florida | 12037 | 771 | 4 |
674161 | 674161 | 2020-10-28 | Franklin | Florida | 12037 | 764 | 4 |
670919 | 670919 | 2020-10-27 | Franklin | Florida | 12037 | 759 | 4 |
667676 | 667676 | 2020-10-26 | Franklin | Florida | 12037 | 755 | 4 |
664431 | 664431 | 2020-10-25 | Franklin | Florida | 12037 | 747 | 4 |
661187 | 661187 | 2020-10-24 | Franklin | Florida | 12037 | 747 | 4 |
657943 | 657943 | 2020-10-23 | Franklin | Florida | 12037 | 742 | 4 |
654698 | 654698 | 2020-10-22 | Franklin | Florida | 12037 | 737 | 4 |
651453 | 651453 | 2020-10-21 | Franklin | Florida | 12037 | 722 | 4 |
648209 | 648209 | 2020-10-20 | Franklin | Florida | 12037 | 717 | 4 |
644964 | 644964 | 2020-10-19 | Franklin | Florida | 12037 | 718 | 4 |
641716 | 641716 | 2020-10-18 | Franklin | Florida | 12037 | 699 | 4 |
638469 | 638469 | 2020-10-17 | Franklin | Florida | 12037 | 691 | 4 |
635224 | 635224 | 2020-10-16 | Franklin | Florida | 12037 | 687 | 4 |
631978 | 631978 | 2020-10-15 | Franklin | Florida | 12037 | 686 | 4 |
628734 | 628734 | 2020-10-14 | Franklin | Florida | 12037 | 676 | 4 |
625491 | 625491 | 2020-10-13 | Franklin | Florida | 12037 | 674 | 4 |
622248 | 622248 | 2020-10-12 | Franklin | Florida | 12037 | 674 | 4 |
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);