ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where deaths = 47 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Taylor 16
- Holmes 11
- Monroe 8
- Clay 7
- Gadsden 7
- Hamilton 7
- Flagler 5
- Orange 5
- Washington 4
- Bradford 3
- Escambia 3
- Santa Rosa 3
- Sarasota 3
- Union 3
- Calhoun 2
- Hernando 2
- Levy 2
- Okeechobee 2
- Suwannee 2
- Volusia 2
- Baker 1
- Broward 1
- Duval 1
- Highlands 1
- Hillsborough 1
- Jackson 1
- Martin 1
- Miami-Dade 1
- Putnam 1
- St. Johns 1
- …
state 1
- Florida · 110 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2011994 | 2011994 | 2021-12-14 | Unknown | Florida | 9640 | 47 | |
1846202 | 1846202 | 2021-10-24 | Hamilton | Florida | 12047 | 2726 | 47 |
1842952 | 1842952 | 2021-10-23 | Hamilton | Florida | 12047 | 2726 | 47 |
1839702 | 1839702 | 2021-10-22 | Hamilton | Florida | 12047 | 2726 | 47 |
1836453 | 1836453 | 2021-10-21 | Hamilton | Florida | 12047 | 2708 | 47 |
1833204 | 1833204 | 2021-10-20 | Hamilton | Florida | 12047 | 2708 | 47 |
1829955 | 1829955 | 2021-10-19 | Hamilton | Florida | 12047 | 2708 | 47 |
1826706 | 1826706 | 2021-10-18 | Hamilton | Florida | 12047 | 2708 | 47 |
1336365 | 1336365 | 2021-05-20 | Taylor | Florida | 12123 | 2746 | 47 |
1333118 | 1333118 | 2021-05-19 | Taylor | Florida | 12123 | 2746 | 47 |
1329871 | 1329871 | 2021-05-18 | Taylor | Florida | 12123 | 2745 | 47 |
1326624 | 1326624 | 2021-05-17 | Taylor | Florida | 12123 | 2745 | 47 |
1323378 | 1323378 | 2021-05-16 | Taylor | Florida | 12123 | 2745 | 47 |
1320132 | 1320132 | 2021-05-15 | Taylor | Florida | 12123 | 2745 | 47 |
1316885 | 1316885 | 2021-05-14 | Taylor | Florida | 12123 | 2743 | 47 |
1313638 | 1313638 | 2021-05-13 | Taylor | Florida | 12123 | 2741 | 47 |
1310391 | 1310391 | 2021-05-12 | Taylor | Florida | 12123 | 2738 | 47 |
1307145 | 1307145 | 2021-05-11 | Taylor | Florida | 12123 | 2738 | 47 |
1303899 | 1303899 | 2021-05-10 | Taylor | Florida | 12123 | 2737 | 47 |
1300652 | 1300652 | 2021-05-09 | Taylor | Florida | 12123 | 2735 | 47 |
1297405 | 1297405 | 2021-05-08 | Taylor | Florida | 12123 | 2735 | 47 |
1294159 | 1294159 | 2021-05-07 | Taylor | Florida | 12123 | 2733 | 47 |
1290913 | 1290913 | 2021-05-06 | Taylor | Florida | 12123 | 2727 | 47 |
1287667 | 1287667 | 2021-05-05 | Taylor | Florida | 12123 | 2725 | 47 |
1222700 | 1222700 | 2021-04-15 | Levy | Florida | 12075 | 3255 | 47 |
1219452 | 1219452 | 2021-04-14 | Levy | Florida | 12075 | 3239 | 47 |
1206430 | 1206430 | 2021-04-10 | Calhoun | Florida | 12013 | 1666 | 47 |
1203182 | 1203182 | 2021-04-09 | Calhoun | Florida | 12013 | 1666 | 47 |
1196707 | 1196707 | 2021-04-07 | Holmes | Florida | 12059 | 2219 | 47 |
1193459 | 1193459 | 2021-04-06 | Holmes | Florida | 12059 | 2218 | 47 |
1190209 | 1190209 | 2021-04-05 | Holmes | Florida | 12059 | 2216 | 47 |
1186962 | 1186962 | 2021-04-04 | Holmes | Florida | 12059 | 2216 | 47 |
1183715 | 1183715 | 2021-04-03 | Holmes | Florida | 12059 | 2216 | 47 |
1180468 | 1180468 | 2021-04-02 | Holmes | Florida | 12059 | 2215 | 47 |
1177221 | 1177221 | 2021-04-01 | Holmes | Florida | 12059 | 2214 | 47 |
1173974 | 1173974 | 2021-03-31 | Holmes | Florida | 12059 | 2212 | 47 |
1170727 | 1170727 | 2021-03-30 | Holmes | Florida | 12059 | 2212 | 47 |
1167479 | 1167479 | 2021-03-29 | Holmes | Florida | 12059 | 2210 | 47 |
1128528 | 1128528 | 2021-03-17 | Monroe | Florida | 12087 | 6161 | 47 |
1125282 | 1125282 | 2021-03-16 | Monroe | Florida | 12087 | 6139 | 47 |
1122036 | 1122036 | 2021-03-15 | Monroe | Florida | 12087 | 6129 | 47 |
1118789 | 1118789 | 2021-03-14 | Monroe | Florida | 12087 | 6116 | 47 |
1115542 | 1115542 | 2021-03-13 | Monroe | Florida | 12087 | 6107 | 47 |
1112296 | 1112296 | 2021-03-12 | Monroe | Florida | 12087 | 6086 | 47 |
1109050 | 1109050 | 2021-03-11 | Monroe | Florida | 12087 | 6059 | 47 |
1105804 | 1105804 | 2021-03-10 | Monroe | Florida | 12087 | 6038 | 47 |
1105828 | 1105828 | 2021-03-10 | Washington | Florida | 12133 | 2639 | 47 |
1102582 | 1102582 | 2021-03-09 | Washington | Florida | 12133 | 2638 | 47 |
1099297 | 1099297 | 2021-03-08 | Holmes | Florida | 12059 | 2195 | 47 |
1070122 | 1070122 | 2021-02-27 | Washington | Florida | 12133 | 2619 | 47 |
1066877 | 1066877 | 2021-02-26 | Washington | Florida | 12133 | 2618 | 47 |
1014884 | 1014884 | 2021-02-10 | Bradford | Florida | 12007 | 2750 | 47 |
1011639 | 1011639 | 2021-02-09 | Bradford | Florida | 12007 | 2739 | 47 |
1008393 | 1008393 | 2021-02-08 | Bradford | Florida | 12007 | 2729 | 47 |
966196 | 966196 | 2021-01-26 | Baker | Florida | 12003 | 2958 | 47 |
862361 | 862361 | 2020-12-25 | Flagler | Florida | 12035 | 3445 | 47 |
859116 | 859116 | 2020-12-24 | Flagler | Florida | 12035 | 3445 | 47 |
855871 | 855871 | 2020-12-23 | Flagler | Florida | 12035 | 3378 | 47 |
849381 | 849381 | 2020-12-21 | Flagler | Florida | 12035 | 3314 | 47 |
836400 | 836400 | 2020-12-17 | Flagler | Florida | 12035 | 3179 | 47 |
823444 | 823444 | 2020-12-13 | Okeechobee | Florida | 12093 | 2171 | 47 |
820198 | 820198 | 2020-12-12 | Okeechobee | Florida | 12093 | 2166 | 47 |
703396 | 703396 | 2020-11-06 | Union | Florida | 12125 | 1174 | 47 |
700153 | 700153 | 2020-11-05 | Union | Florida | 12125 | 1172 | 47 |
696909 | 696909 | 2020-11-04 | Union | Florida | 12125 | 1167 | 47 |
635260 | 635260 | 2020-10-16 | Putnam | Florida | 12107 | 2253 | 47 |
599553 | 599553 | 2020-10-05 | Gadsden | Florida | 12039 | 2906 | 47 |
596310 | 596310 | 2020-10-04 | Gadsden | Florida | 12039 | 2893 | 47 |
593068 | 593068 | 2020-10-03 | Gadsden | Florida | 12039 | 2882 | 47 |
589828 | 589828 | 2020-10-02 | Gadsden | Florida | 12039 | 2854 | 47 |
586587 | 586587 | 2020-10-01 | Gadsden | Florida | 12039 | 2839 | 47 |
583347 | 583347 | 2020-09-30 | Gadsden | Florida | 12039 | 2832 | 47 |
580108 | 580108 | 2020-09-29 | Gadsden | Florida | 12039 | 2827 | 47 |
470121 | 470121 | 2020-08-26 | Sumter | Florida | 12119 | 1742 | 47 |
447490 | 447490 | 2020-08-19 | Highlands | Florida | 12055 | 1660 | 47 |
441065 | 441065 | 2020-08-17 | Santa Rosa | Florida | 12113 | 4237 | 47 |
441068 | 441068 | 2020-08-17 | St. Johns | Florida | 12109 | 3978 | 47 |
441071 | 441071 | 2020-08-17 | Suwannee | Florida | 12121 | 2259 | 47 |
437839 | 437839 | 2020-08-16 | Santa Rosa | Florida | 12113 | 4223 | 47 |
437845 | 437845 | 2020-08-16 | Suwannee | Florida | 12121 | 2253 | 47 |
434613 | 434613 | 2020-08-15 | Santa Rosa | Florida | 12113 | 4173 | 47 |
431364 | 431364 | 2020-08-14 | Jackson | Florida | 12063 | 2007 | 47 |
415244 | 415244 | 2020-08-09 | Hernando | Florida | 12053 | 2022 | 47 |
412024 | 412024 | 2020-08-08 | Hernando | Florida | 12053 | 1975 | 47 |
383051 | 383051 | 2020-07-30 | Clay | Florida | 12019 | 2758 | 47 |
379834 | 379834 | 2020-07-29 | Clay | Florida | 12019 | 2697 | 47 |
376617 | 376617 | 2020-07-28 | Clay | Florida | 12019 | 2615 | 47 |
373403 | 373403 | 2020-07-27 | Clay | Florida | 12019 | 2577 | 47 |
370191 | 370191 | 2020-07-26 | Clay | Florida | 12019 | 2538 | 47 |
366981 | 366981 | 2020-07-25 | Clay | Florida | 12019 | 2473 | 47 |
363774 | 363774 | 2020-07-24 | Clay | Florida | 12019 | 2389 | 47 |
341389 | 341389 | 2020-07-17 | Martin | Florida | 12085 | 3023 | 47 |
306359 | 306359 | 2020-07-06 | Escambia | Florida | 12033 | 2942 | 47 |
303195 | 303195 | 2020-07-05 | Escambia | Florida | 12033 | 2809 | 47 |
300031 | 300031 | 2020-07-04 | Escambia | Florida | 12033 | 2597 | 47 |
287451 | 287451 | 2020-06-30 | St. Lucie | Florida | 12111 | 1724 | 47 |
259192 | 259192 | 2020-06-21 | Orange | Florida | 12095 | 4913 | 47 |
256065 | 256065 | 2020-06-20 | Orange | Florida | 12095 | 4568 | 47 |
252946 | 252946 | 2020-06-19 | Orange | Florida | 12095 | 4273 | 47 |
249831 | 249831 | 2020-06-18 | Orange | Florida | 12095 | 3899 | 47 |
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);