ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
398 rows where deaths = 12 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Citrus 43
- Levy 33
- Seminole 27
- Alachua 23
- Hamilton 23
- Gilchrist 20
- Lafayette 18
- Glades 14
- Holmes 14
- Okeechobee 13
- Hendry 12
- Jefferson 12
- Wakulla 11
- Madison 8
- Pasco 8
- Taylor 8
- Brevard 7
- Dixie 7
- Marion 7
- Union 7
- Liberty 6
- Bradford 5
- Franklin 5
- Sumter 5
- Walton 5
- Washington 5
- Baker 4
- Gadsden 4
- Highlands 4
- Indian River 4
- …
state 1
- Florida · 398 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1040861 | 1040861 | 2021-02-18 | Franklin | Florida | 12037 | 1273 | 12 |
1037616 | 1037616 | 2021-02-17 | Franklin | Florida | 12037 | 1272 | 12 |
1034371 | 1034371 | 2021-02-16 | Franklin | Florida | 12037 | 1268 | 12 |
1031125 | 1031125 | 2021-02-15 | Franklin | Florida | 12037 | 1268 | 12 |
1027878 | 1027878 | 2021-02-14 | Franklin | Florida | 12037 | 1268 | 12 |
966215 | 966215 | 2021-01-26 | Glades | Florida | 12043 | 860 | 12 |
962970 | 962970 | 2021-01-25 | Glades | Florida | 12043 | 860 | 12 |
959725 | 959725 | 2021-01-24 | Glades | Florida | 12043 | 855 | 12 |
956472 | 956472 | 2021-01-23 | Dixie | Florida | 12029 | 1357 | 12 |
956479 | 956479 | 2021-01-23 | Glades | Florida | 12043 | 854 | 12 |
953227 | 953227 | 2021-01-22 | Dixie | Florida | 12029 | 1340 | 12 |
953234 | 953234 | 2021-01-22 | Glades | Florida | 12043 | 850 | 12 |
949982 | 949982 | 2021-01-21 | Dixie | Florida | 12029 | 1332 | 12 |
949989 | 949989 | 2021-01-21 | Glades | Florida | 12043 | 848 | 12 |
946736 | 946736 | 2021-01-20 | Dixie | Florida | 12029 | 1328 | 12 |
946743 | 946743 | 2021-01-20 | Glades | Florida | 12043 | 846 | 12 |
943489 | 943489 | 2021-01-19 | Dixie | Florida | 12029 | 1322 | 12 |
943496 | 943496 | 2021-01-19 | Glades | Florida | 12043 | 845 | 12 |
940244 | 940244 | 2021-01-18 | Dixie | Florida | 12029 | 1321 | 12 |
940251 | 940251 | 2021-01-18 | Glades | Florida | 12043 | 837 | 12 |
936999 | 936999 | 2021-01-17 | Dixie | Florida | 12029 | 1316 | 12 |
937006 | 937006 | 2021-01-17 | Glades | Florida | 12043 | 837 | 12 |
933761 | 933761 | 2021-01-16 | Glades | Florida | 12043 | 833 | 12 |
930516 | 930516 | 2021-01-15 | Glades | Florida | 12043 | 825 | 12 |
927271 | 927271 | 2021-01-14 | Glades | Florida | 12043 | 824 | 12 |
924025 | 924025 | 2021-01-13 | Glades | Florida | 12043 | 821 | 12 |
875347 | 875347 | 2020-12-29 | Hamilton | Florida | 12047 | 1230 | 12 |
872102 | 872102 | 2020-12-28 | Hamilton | Florida | 12047 | 1224 | 12 |
868857 | 868857 | 2020-12-27 | Hamilton | Florida | 12047 | 1220 | 12 |
865612 | 865612 | 2020-12-26 | Hamilton | Florida | 12047 | 1213 | 12 |
862367 | 862367 | 2020-12-25 | Hamilton | Florida | 12047 | 1197 | 12 |
859122 | 859122 | 2020-12-24 | Hamilton | Florida | 12047 | 1197 | 12 |
855877 | 855877 | 2020-12-23 | Hamilton | Florida | 12047 | 1153 | 12 |
852632 | 852632 | 2020-12-22 | Hamilton | Florida | 12047 | 1141 | 12 |
849387 | 849387 | 2020-12-21 | Hamilton | Florida | 12047 | 1128 | 12 |
846142 | 846142 | 2020-12-20 | Hamilton | Florida | 12047 | 1126 | 12 |
842896 | 842896 | 2020-12-19 | Hamilton | Florida | 12047 | 1121 | 12 |
839651 | 839651 | 2020-12-18 | Hamilton | Florida | 12047 | 1105 | 12 |
836406 | 836406 | 2020-12-17 | Hamilton | Florida | 12047 | 1099 | 12 |
833160 | 833160 | 2020-12-16 | Hamilton | Florida | 12047 | 1084 | 12 |
829913 | 829913 | 2020-12-15 | Hamilton | Florida | 12047 | 1063 | 12 |
829922 | 829922 | 2020-12-15 | Jefferson | Florida | 12065 | 848 | 12 |
826667 | 826667 | 2020-12-14 | Hamilton | Florida | 12047 | 1056 | 12 |
826676 | 826676 | 2020-12-14 | Jefferson | Florida | 12065 | 842 | 12 |
823420 | 823420 | 2020-12-13 | Hamilton | Florida | 12047 | 1055 | 12 |
823429 | 823429 | 2020-12-13 | Jefferson | Florida | 12065 | 836 | 12 |
820174 | 820174 | 2020-12-12 | Hamilton | Florida | 12047 | 1051 | 12 |
820183 | 820183 | 2020-12-12 | Jefferson | Florida | 12065 | 833 | 12 |
816928 | 816928 | 2020-12-11 | Hamilton | Florida | 12047 | 1044 | 12 |
816937 | 816937 | 2020-12-11 | Jefferson | Florida | 12065 | 826 | 12 |
813682 | 813682 | 2020-12-10 | Hamilton | Florida | 12047 | 1042 | 12 |
813691 | 813691 | 2020-12-10 | Jefferson | Florida | 12065 | 816 | 12 |
810438 | 810438 | 2020-12-09 | Hamilton | Florida | 12047 | 1038 | 12 |
810447 | 810447 | 2020-12-09 | Jefferson | Florida | 12065 | 815 | 12 |
807193 | 807193 | 2020-12-08 | Hamilton | Florida | 12047 | 1030 | 12 |
807202 | 807202 | 2020-12-08 | Jefferson | Florida | 12065 | 810 | 12 |
803948 | 803948 | 2020-12-07 | Hamilton | Florida | 12047 | 1024 | 12 |
803957 | 803957 | 2020-12-07 | Jefferson | Florida | 12065 | 803 | 12 |
800712 | 800712 | 2020-12-06 | Jefferson | Florida | 12065 | 802 | 12 |
797467 | 797467 | 2020-12-05 | Jefferson | Florida | 12065 | 802 | 12 |
794222 | 794222 | 2020-12-04 | Jefferson | Florida | 12065 | 799 | 12 |
752038 | 752038 | 2020-11-21 | Levy | Florida | 12075 | 1329 | 12 |
752067 | 752067 | 2020-11-21 | Wakulla | Florida | 12129 | 1549 | 12 |
748792 | 748792 | 2020-11-20 | Levy | Florida | 12075 | 1319 | 12 |
748821 | 748821 | 2020-11-20 | Wakulla | Florida | 12129 | 1537 | 12 |
745546 | 745546 | 2020-11-19 | Levy | Florida | 12075 | 1308 | 12 |
745575 | 745575 | 2020-11-19 | Wakulla | Florida | 12129 | 1518 | 12 |
742299 | 742299 | 2020-11-18 | Levy | Florida | 12075 | 1284 | 12 |
742328 | 742328 | 2020-11-18 | Wakulla | Florida | 12129 | 1502 | 12 |
739052 | 739052 | 2020-11-17 | Levy | Florida | 12075 | 1270 | 12 |
739081 | 739081 | 2020-11-17 | Wakulla | Florida | 12129 | 1493 | 12 |
735808 | 735808 | 2020-11-16 | Levy | Florida | 12075 | 1256 | 12 |
735837 | 735837 | 2020-11-16 | Wakulla | Florida | 12129 | 1473 | 12 |
732562 | 732562 | 2020-11-15 | Levy | Florida | 12075 | 1253 | 12 |
732591 | 732591 | 2020-11-15 | Wakulla | Florida | 12129 | 1472 | 12 |
729317 | 729317 | 2020-11-14 | Levy | Florida | 12075 | 1243 | 12 |
729346 | 729346 | 2020-11-14 | Wakulla | Florida | 12129 | 1448 | 12 |
726074 | 726074 | 2020-11-13 | Levy | Florida | 12075 | 1235 | 12 |
726103 | 726103 | 2020-11-13 | Wakulla | Florida | 12129 | 1446 | 12 |
722831 | 722831 | 2020-11-12 | Levy | Florida | 12075 | 1229 | 12 |
722832 | 722832 | 2020-11-12 | Liberty | Florida | 12077 | 552 | 12 |
722860 | 722860 | 2020-11-12 | Wakulla | Florida | 12129 | 1430 | 12 |
719588 | 719588 | 2020-11-11 | Levy | Florida | 12075 | 1227 | 12 |
719589 | 719589 | 2020-11-11 | Liberty | Florida | 12077 | 551 | 12 |
719617 | 719617 | 2020-11-11 | Wakulla | Florida | 12129 | 1418 | 12 |
716345 | 716345 | 2020-11-10 | Levy | Florida | 12075 | 1218 | 12 |
716346 | 716346 | 2020-11-10 | Liberty | Florida | 12077 | 550 | 12 |
713101 | 713101 | 2020-11-09 | Levy | Florida | 12075 | 1215 | 12 |
713102 | 713102 | 2020-11-09 | Liberty | Florida | 12077 | 549 | 12 |
709857 | 709857 | 2020-11-08 | Levy | Florida | 12075 | 1209 | 12 |
709858 | 709858 | 2020-11-08 | Liberty | Florida | 12077 | 549 | 12 |
706613 | 706613 | 2020-11-07 | Levy | Florida | 12075 | 1194 | 12 |
706614 | 706614 | 2020-11-07 | Liberty | Florida | 12077 | 549 | 12 |
703370 | 703370 | 2020-11-06 | Levy | Florida | 12075 | 1189 | 12 |
700127 | 700127 | 2020-11-05 | Levy | Florida | 12075 | 1183 | 12 |
696883 | 696883 | 2020-11-04 | Levy | Florida | 12075 | 1173 | 12 |
693641 | 693641 | 2020-11-03 | Levy | Florida | 12075 | 1167 | 12 |
690390 | 690390 | 2020-11-02 | Holmes | Florida | 12059 | 936 | 12 |
690398 | 690398 | 2020-11-02 | Levy | Florida | 12075 | 1161 | 12 |
687145 | 687145 | 2020-11-01 | Holmes | Florida | 12059 | 932 | 12 |
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);