ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
463 rows where deaths = 11 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Dixie 100
- Glades 35
- Jefferson 31
- Hamilton 29
- Wakulla 28
- Hardee 25
- Citrus 21
- Liberty 12
- Nassau 12
- Highlands 11
- Baker 10
- Indian River 10
- Walton 9
- Alachua 8
- Sumter 8
- Brevard 7
- Calhoun 7
- Escambia 7
- Seminole 7
- Taylor 7
- Washington 7
- Bradford 6
- DeSoto 6
- Franklin 5
- Santa Rosa 5
- Clay 4
- Gulf 4
- Charlotte 3
- Holmes 3
- Lee 3
- …
state 1
- Florida · 463 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1024633 | 1024633 | 2021-02-13 | Franklin | Florida | 12037 | 1264 | 11 |
1021388 | 1021388 | 2021-02-12 | Franklin | Florida | 12037 | 1264 | 11 |
1018143 | 1018143 | 2021-02-11 | Franklin | Florida | 12037 | 1265 | 11 |
1014898 | 1014898 | 2021-02-10 | Franklin | Florida | 12037 | 1264 | 11 |
1011653 | 1011653 | 2021-02-09 | Franklin | Florida | 12037 | 1263 | 11 |
933754 | 933754 | 2021-01-16 | Dixie | Florida | 12029 | 1310 | 11 |
930509 | 930509 | 2021-01-15 | Dixie | Florida | 12029 | 1300 | 11 |
927264 | 927264 | 2021-01-14 | Dixie | Florida | 12029 | 1281 | 11 |
924018 | 924018 | 2021-01-13 | Dixie | Florida | 12029 | 1259 | 11 |
920773 | 920773 | 2021-01-12 | Dixie | Florida | 12029 | 1250 | 11 |
920780 | 920780 | 2021-01-12 | Glades | Florida | 12043 | 818 | 11 |
917528 | 917528 | 2021-01-11 | Dixie | Florida | 12029 | 1238 | 11 |
917535 | 917535 | 2021-01-11 | Glades | Florida | 12043 | 811 | 11 |
914283 | 914283 | 2021-01-10 | Dixie | Florida | 12029 | 1226 | 11 |
914290 | 914290 | 2021-01-10 | Glades | Florida | 12043 | 807 | 11 |
911038 | 911038 | 2021-01-09 | Dixie | Florida | 12029 | 1211 | 11 |
911045 | 911045 | 2021-01-09 | Glades | Florida | 12043 | 803 | 11 |
907793 | 907793 | 2021-01-08 | Dixie | Florida | 12029 | 1208 | 11 |
907800 | 907800 | 2021-01-08 | Glades | Florida | 12043 | 800 | 11 |
904547 | 904547 | 2021-01-07 | Dixie | Florida | 12029 | 1193 | 11 |
904554 | 904554 | 2021-01-07 | Glades | Florida | 12043 | 798 | 11 |
901302 | 901302 | 2021-01-06 | Dixie | Florida | 12029 | 1175 | 11 |
901309 | 901309 | 2021-01-06 | Glades | Florida | 12043 | 794 | 11 |
898057 | 898057 | 2021-01-05 | Dixie | Florida | 12029 | 1163 | 11 |
898064 | 898064 | 2021-01-05 | Glades | Florida | 12043 | 790 | 11 |
894812 | 894812 | 2021-01-04 | Dixie | Florida | 12029 | 1158 | 11 |
894819 | 894819 | 2021-01-04 | Glades | Florida | 12043 | 786 | 11 |
891565 | 891565 | 2021-01-03 | Dixie | Florida | 12029 | 1154 | 11 |
891572 | 891572 | 2021-01-03 | Glades | Florida | 12043 | 781 | 11 |
888318 | 888318 | 2021-01-02 | Dixie | Florida | 12029 | 1152 | 11 |
888325 | 888325 | 2021-01-02 | Glades | Florida | 12043 | 775 | 11 |
885073 | 885073 | 2021-01-01 | Dixie | Florida | 12029 | 1115 | 11 |
885080 | 885080 | 2021-01-01 | Glades | Florida | 12043 | 769 | 11 |
881828 | 881828 | 2020-12-31 | Dixie | Florida | 12029 | 1115 | 11 |
881835 | 881835 | 2020-12-31 | Glades | Florida | 12043 | 769 | 11 |
878583 | 878583 | 2020-12-30 | Dixie | Florida | 12029 | 1099 | 11 |
878590 | 878590 | 2020-12-30 | Glades | Florida | 12043 | 769 | 11 |
875338 | 875338 | 2020-12-29 | Dixie | Florida | 12029 | 1094 | 11 |
875345 | 875345 | 2020-12-29 | Glades | Florida | 12043 | 764 | 11 |
872093 | 872093 | 2020-12-28 | Dixie | Florida | 12029 | 1088 | 11 |
872100 | 872100 | 2020-12-28 | Glades | Florida | 12043 | 762 | 11 |
868848 | 868848 | 2020-12-27 | Dixie | Florida | 12029 | 1083 | 11 |
868855 | 868855 | 2020-12-27 | Glades | Florida | 12043 | 761 | 11 |
865603 | 865603 | 2020-12-26 | Dixie | Florida | 12029 | 1082 | 11 |
865610 | 865610 | 2020-12-26 | Glades | Florida | 12043 | 760 | 11 |
862358 | 862358 | 2020-12-25 | Dixie | Florida | 12029 | 1072 | 11 |
862365 | 862365 | 2020-12-25 | Glades | Florida | 12043 | 759 | 11 |
859113 | 859113 | 2020-12-24 | Dixie | Florida | 12029 | 1072 | 11 |
859120 | 859120 | 2020-12-24 | Glades | Florida | 12043 | 759 | 11 |
855868 | 855868 | 2020-12-23 | Dixie | Florida | 12029 | 1063 | 11 |
855875 | 855875 | 2020-12-23 | Glades | Florida | 12043 | 750 | 11 |
852623 | 852623 | 2020-12-22 | Dixie | Florida | 12029 | 1059 | 11 |
852630 | 852630 | 2020-12-22 | Glades | Florida | 12043 | 742 | 11 |
849378 | 849378 | 2020-12-21 | Dixie | Florida | 12029 | 1055 | 11 |
849385 | 849385 | 2020-12-21 | Glades | Florida | 12043 | 740 | 11 |
846133 | 846133 | 2020-12-20 | Dixie | Florida | 12029 | 1038 | 11 |
846140 | 846140 | 2020-12-20 | Glades | Florida | 12043 | 739 | 11 |
842887 | 842887 | 2020-12-19 | Dixie | Florida | 12029 | 1035 | 11 |
842894 | 842894 | 2020-12-19 | Glades | Florida | 12043 | 739 | 11 |
839642 | 839642 | 2020-12-18 | Dixie | Florida | 12029 | 1032 | 11 |
839649 | 839649 | 2020-12-18 | Glades | Florida | 12043 | 734 | 11 |
836397 | 836397 | 2020-12-17 | Dixie | Florida | 12029 | 1024 | 11 |
836404 | 836404 | 2020-12-17 | Glades | Florida | 12043 | 732 | 11 |
833151 | 833151 | 2020-12-16 | Dixie | Florida | 12029 | 1012 | 11 |
833158 | 833158 | 2020-12-16 | Glades | Florida | 12043 | 728 | 11 |
829904 | 829904 | 2020-12-15 | Dixie | Florida | 12029 | 1005 | 11 |
829911 | 829911 | 2020-12-15 | Glades | Florida | 12043 | 721 | 11 |
826658 | 826658 | 2020-12-14 | Dixie | Florida | 12029 | 1001 | 11 |
826665 | 826665 | 2020-12-14 | Glades | Florida | 12043 | 718 | 11 |
823411 | 823411 | 2020-12-13 | Dixie | Florida | 12029 | 999 | 11 |
823418 | 823418 | 2020-12-13 | Glades | Florida | 12043 | 717 | 11 |
820165 | 820165 | 2020-12-12 | Dixie | Florida | 12029 | 999 | 11 |
820172 | 820172 | 2020-12-12 | Glades | Florida | 12043 | 713 | 11 |
816919 | 816919 | 2020-12-11 | Dixie | Florida | 12029 | 996 | 11 |
816926 | 816926 | 2020-12-11 | Glades | Florida | 12043 | 713 | 11 |
813673 | 813673 | 2020-12-10 | Dixie | Florida | 12029 | 993 | 11 |
813680 | 813680 | 2020-12-10 | Glades | Florida | 12043 | 712 | 11 |
810429 | 810429 | 2020-12-09 | Dixie | Florida | 12029 | 992 | 11 |
810436 | 810436 | 2020-12-09 | Glades | Florida | 12043 | 711 | 11 |
807184 | 807184 | 2020-12-08 | Dixie | Florida | 12029 | 987 | 11 |
803939 | 803939 | 2020-12-07 | Dixie | Florida | 12029 | 987 | 11 |
800694 | 800694 | 2020-12-06 | Dixie | Florida | 12029 | 984 | 11 |
800703 | 800703 | 2020-12-06 | Hamilton | Florida | 12047 | 1023 | 11 |
797449 | 797449 | 2020-12-05 | Dixie | Florida | 12029 | 983 | 11 |
797458 | 797458 | 2020-12-05 | Hamilton | Florida | 12047 | 1019 | 11 |
794204 | 794204 | 2020-12-04 | Dixie | Florida | 12029 | 979 | 11 |
794213 | 794213 | 2020-12-04 | Hamilton | Florida | 12047 | 1017 | 11 |
790959 | 790959 | 2020-12-03 | Dixie | Florida | 12029 | 974 | 11 |
790968 | 790968 | 2020-12-03 | Hamilton | Florida | 12047 | 1006 | 11 |
790977 | 790977 | 2020-12-03 | Jefferson | Florida | 12065 | 792 | 11 |
787714 | 787714 | 2020-12-02 | Dixie | Florida | 12029 | 968 | 11 |
787723 | 787723 | 2020-12-02 | Hamilton | Florida | 12047 | 999 | 11 |
787732 | 787732 | 2020-12-02 | Jefferson | Florida | 12065 | 789 | 11 |
784470 | 784470 | 2020-12-01 | Dixie | Florida | 12029 | 965 | 11 |
784479 | 784479 | 2020-12-01 | Hamilton | Florida | 12047 | 982 | 11 |
784488 | 784488 | 2020-12-01 | Jefferson | Florida | 12065 | 785 | 11 |
781225 | 781225 | 2020-11-30 | Dixie | Florida | 12029 | 963 | 11 |
781234 | 781234 | 2020-11-30 | Hamilton | Florida | 12047 | 978 | 11 |
781243 | 781243 | 2020-11-30 | Jefferson | Florida | 12065 | 774 | 11 |
777979 | 777979 | 2020-11-29 | Dixie | Florida | 12029 | 962 | 11 |
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);