ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53,362 rows where state = "Florida" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 12057 804
- 12081 804
- 12113 800
- 12011 799
- 12071 799
- 12015 798
- 12091 798
- 12127 798
- 12001 795
- 12021 795
- 12089 795
- 12101 795
- 12103 795
- 12086 794
- 12109 794
- 12019 793
- 12031 793
- 12099 793
- 12115 793
- 12117 793
- 12095 792
- 12097 792
- 12003 790
- 12017 790
- 12033 789
- 12069 789
- 12009 788
- 12105 788
- 12073 787
- 12119 787
- …
county >30
- Hillsborough 804
- Manatee 804
- Santa Rosa 800
- Broward 799
- Lee 799
- Charlotte 798
- Okaloosa 798
- Volusia 798
- Alachua 795
- Collier 795
- Nassau 795
- Pasco 795
- Pinellas 795
- Miami-Dade 794
- St. Johns 794
- Clay 793
- Duval 793
- Palm Beach 793
- Sarasota 793
- Seminole 793
- Orange 792
- Osceola 792
- Baker 790
- Citrus 790
- Escambia 789
- Lake 789
- Brevard 788
- Polk 788
- Leon 787
- Sumter 787
- …
state 1
- Florida · 53,362 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
412 | 412 | 2020-03-01 | Hillsborough | Florida | 12057 | 1 | 0 |
413 | 413 | 2020-03-01 | Manatee | Florida | 12081 | 1 | 0 |
441 | 441 | 2020-03-02 | Hillsborough | Florida | 12057 | 1 | 0 |
442 | 442 | 2020-03-02 | Manatee | Florida | 12081 | 1 | 0 |
475 | 475 | 2020-03-03 | Hillsborough | Florida | 12057 | 2 | 0 |
476 | 476 | 2020-03-03 | Manatee | Florida | 12081 | 1 | 0 |
510 | 510 | 2020-03-04 | Hillsborough | Florida | 12057 | 2 | 0 |
511 | 511 | 2020-03-04 | Manatee | Florida | 12081 | 1 | 0 |
551 | 551 | 2020-03-05 | Hillsborough | Florida | 12057 | 2 | 0 |
552 | 552 | 2020-03-05 | Manatee | Florida | 12081 | 1 | 0 |
553 | 553 | 2020-03-05 | Santa Rosa | Florida | 12113 | 1 | 0 |
605 | 605 | 2020-03-06 | Broward | Florida | 12011 | 2 | 0 |
606 | 606 | 2020-03-06 | Hillsborough | Florida | 12057 | 2 | 0 |
607 | 607 | 2020-03-06 | Lee | Florida | 12071 | 1 | 1 |
608 | 608 | 2020-03-06 | Manatee | Florida | 12081 | 1 | 0 |
609 | 609 | 2020-03-06 | Santa Rosa | Florida | 12113 | 1 | 1 |
684 | 684 | 2020-03-07 | Broward | Florida | 12011 | 2 | 0 |
685 | 685 | 2020-03-07 | Charlotte | Florida | 12015 | 1 | 0 |
686 | 686 | 2020-03-07 | Hillsborough | Florida | 12057 | 2 | 0 |
687 | 687 | 2020-03-07 | Lee | Florida | 12071 | 2 | 1 |
688 | 688 | 2020-03-07 | Manatee | Florida | 12081 | 2 | 0 |
689 | 689 | 2020-03-07 | Okaloosa | Florida | 12091 | 1 | 0 |
690 | 690 | 2020-03-07 | Santa Rosa | Florida | 12113 | 1 | 1 |
691 | 691 | 2020-03-07 | Volusia | Florida | 12127 | 1 | 0 |
780 | 780 | 2020-03-08 | Broward | Florida | 12011 | 3 | 0 |
781 | 781 | 2020-03-08 | Charlotte | Florida | 12015 | 1 | 0 |
782 | 782 | 2020-03-08 | Hillsborough | Florida | 12057 | 2 | 0 |
783 | 783 | 2020-03-08 | Lee | Florida | 12071 | 2 | 1 |
784 | 784 | 2020-03-08 | Manatee | Florida | 12081 | 2 | 0 |
785 | 785 | 2020-03-08 | Okaloosa | Florida | 12091 | 1 | 0 |
786 | 786 | 2020-03-08 | Santa Rosa | Florida | 12113 | 1 | 1 |
787 | 787 | 2020-03-08 | Volusia | Florida | 12127 | 1 | 0 |
897 | 897 | 2020-03-09 | Broward | Florida | 12011 | 3 | 0 |
898 | 898 | 2020-03-09 | Charlotte | Florida | 12015 | 1 | 0 |
899 | 899 | 2020-03-09 | Hillsborough | Florida | 12057 | 2 | 0 |
900 | 900 | 2020-03-09 | Lee | Florida | 12071 | 2 | 1 |
901 | 901 | 2020-03-09 | Manatee | Florida | 12081 | 2 | 0 |
902 | 902 | 2020-03-09 | Okaloosa | Florida | 12091 | 1 | 0 |
903 | 903 | 2020-03-09 | Santa Rosa | Florida | 12113 | 1 | 1 |
904 | 904 | 2020-03-09 | Volusia | Florida | 12127 | 2 | 0 |
1032 | 1032 | 2020-03-10 | Alachua | Florida | 12001 | 1 | 0 |
1033 | 1033 | 2020-03-10 | Broward | Florida | 12011 | 4 | 0 |
1034 | 1034 | 2020-03-10 | Charlotte | Florida | 12015 | 1 | 0 |
1035 | 1035 | 2020-03-10 | Collier | Florida | 12021 | 3 | 0 |
1036 | 1036 | 2020-03-10 | Hillsborough | Florida | 12057 | 2 | 0 |
1037 | 1037 | 2020-03-10 | Lee | Florida | 12071 | 2 | 1 |
1038 | 1038 | 2020-03-10 | Manatee | Florida | 12081 | 2 | 0 |
1039 | 1039 | 2020-03-10 | Nassau | Florida | 12089 | 1 | 0 |
1040 | 1040 | 2020-03-10 | Okaloosa | Florida | 12091 | 1 | 0 |
1041 | 1041 | 2020-03-10 | Pasco | Florida | 12101 | 1 | 0 |
1042 | 1042 | 2020-03-10 | Pinellas | Florida | 12103 | 2 | 0 |
1043 | 1043 | 2020-03-10 | Santa Rosa | Florida | 12113 | 1 | 1 |
1044 | 1044 | 2020-03-10 | Volusia | Florida | 12127 | 2 | 0 |
1201 | 1201 | 2020-03-11 | Alachua | Florida | 12001 | 1 | 0 |
1202 | 1202 | 2020-03-11 | Broward | Florida | 12011 | 5 | 0 |
1203 | 1203 | 2020-03-11 | Charlotte | Florida | 12015 | 1 | 0 |
1204 | 1204 | 2020-03-11 | Collier | Florida | 12021 | 3 | 0 |
1205 | 1205 | 2020-03-11 | Hillsborough | Florida | 12057 | 2 | 0 |
1206 | 1206 | 2020-03-11 | Lee | Florida | 12071 | 2 | 1 |
1207 | 1207 | 2020-03-11 | Manatee | Florida | 12081 | 2 | 0 |
1208 | 1208 | 2020-03-11 | Miami-Dade | Florida | 12086 | 1 | 0 |
1209 | 1209 | 2020-03-11 | Nassau | Florida | 12089 | 1 | 0 |
1210 | 1210 | 2020-03-11 | Okaloosa | Florida | 12091 | 1 | 0 |
1211 | 1211 | 2020-03-11 | Pasco | Florida | 12101 | 1 | 0 |
1212 | 1212 | 2020-03-11 | Pinellas | Florida | 12103 | 2 | 0 |
1213 | 1213 | 2020-03-11 | Santa Rosa | Florida | 12113 | 1 | 1 |
1214 | 1214 | 2020-03-11 | St. Johns | Florida | 12109 | 1 | 0 |
1215 | 1215 | 2020-03-11 | Volusia | Florida | 12127 | 2 | 0 |
1410 | 1410 | 2020-03-12 | Alachua | Florida | 12001 | 2 | 0 |
1411 | 1411 | 2020-03-12 | Broward | Florida | 12011 | 12 | 0 |
1412 | 1412 | 2020-03-12 | Charlotte | Florida | 12015 | 1 | 0 |
1413 | 1413 | 2020-03-12 | Clay | Florida | 12019 | 1 | 0 |
1414 | 1414 | 2020-03-12 | Collier | Florida | 12021 | 3 | 0 |
1415 | 1415 | 2020-03-12 | Duval | Florida | 12031 | 1 | 0 |
1416 | 1416 | 2020-03-12 | Hillsborough | Florida | 12057 | 3 | 0 |
1417 | 1417 | 2020-03-12 | Lee | Florida | 12071 | 4 | 1 |
1418 | 1418 | 2020-03-12 | Manatee | Florida | 12081 | 2 | 0 |
1419 | 1419 | 2020-03-12 | Miami-Dade | Florida | 12086 | 2 | 0 |
1420 | 1420 | 2020-03-12 | Nassau | Florida | 12089 | 1 | 0 |
1421 | 1421 | 2020-03-12 | Okaloosa | Florida | 12091 | 1 | 0 |
1422 | 1422 | 2020-03-12 | Palm Beach | Florida | 12099 | 2 | 0 |
1423 | 1423 | 2020-03-12 | Pasco | Florida | 12101 | 1 | 0 |
1424 | 1424 | 2020-03-12 | Pinellas | Florida | 12103 | 2 | 0 |
1425 | 1425 | 2020-03-12 | Santa Rosa | Florida | 12113 | 1 | 1 |
1426 | 1426 | 2020-03-12 | Sarasota | Florida | 12115 | 2 | 0 |
1427 | 1427 | 2020-03-12 | Seminole | Florida | 12117 | 1 | 0 |
1428 | 1428 | 2020-03-12 | St. Johns | Florida | 12109 | 1 | 0 |
1429 | 1429 | 2020-03-12 | Volusia | Florida | 12127 | 3 | 0 |
1676 | 1676 | 2020-03-13 | Alachua | Florida | 12001 | 3 | 0 |
1677 | 1677 | 2020-03-13 | Broward | Florida | 12011 | 21 | 0 |
1678 | 1678 | 2020-03-13 | Charlotte | Florida | 12015 | 1 | 0 |
1679 | 1679 | 2020-03-13 | Clay | Florida | 12019 | 1 | 0 |
1680 | 1680 | 2020-03-13 | Collier | Florida | 12021 | 3 | 0 |
1681 | 1681 | 2020-03-13 | Duval | Florida | 12031 | 1 | 0 |
1682 | 1682 | 2020-03-13 | Hillsborough | Florida | 12057 | 3 | 0 |
1683 | 1683 | 2020-03-13 | Lee | Florida | 12071 | 4 | 1 |
1684 | 1684 | 2020-03-13 | Manatee | Florida | 12081 | 4 | 0 |
1685 | 1685 | 2020-03-13 | Miami-Dade | Florida | 12086 | 8 | 0 |
1686 | 1686 | 2020-03-13 | Nassau | Florida | 12089 | 1 | 0 |
1687 | 1687 | 2020-03-13 | Okaloosa | Florida | 12091 | 1 | 0 |
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);