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 cases
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 |
---|---|---|---|---|---|---|---|
78810 | 78810 | 2020-04-22 | Unknown | Florida | 0 | 34 | |
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 |
476 | 476 | 2020-03-03 | Manatee | Florida | 12081 | 1 | 0 |
511 | 511 | 2020-03-04 | Manatee | Florida | 12081 | 1 | 0 |
552 | 552 | 2020-03-05 | Manatee | Florida | 12081 | 1 | 0 |
553 | 553 | 2020-03-05 | Santa Rosa | Florida | 12113 | 1 | 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 |
685 | 685 | 2020-03-07 | Charlotte | Florida | 12015 | 1 | 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 |
781 | 781 | 2020-03-08 | Charlotte | Florida | 12015 | 1 | 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 |
898 | 898 | 2020-03-09 | Charlotte | Florida | 12015 | 1 | 0 |
902 | 902 | 2020-03-09 | Okaloosa | Florida | 12091 | 1 | 0 |
903 | 903 | 2020-03-09 | Santa Rosa | Florida | 12113 | 1 | 1 |
1032 | 1032 | 2020-03-10 | Alachua | Florida | 12001 | 1 | 0 |
1034 | 1034 | 2020-03-10 | Charlotte | Florida | 12015 | 1 | 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 |
1043 | 1043 | 2020-03-10 | Santa Rosa | Florida | 12113 | 1 | 1 |
1201 | 1201 | 2020-03-11 | Alachua | Florida | 12001 | 1 | 0 |
1203 | 1203 | 2020-03-11 | Charlotte | Florida | 12015 | 1 | 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 |
1213 | 1213 | 2020-03-11 | Santa Rosa | Florida | 12113 | 1 | 1 |
1214 | 1214 | 2020-03-11 | St. Johns | Florida | 12109 | 1 | 0 |
1412 | 1412 | 2020-03-12 | Charlotte | Florida | 12015 | 1 | 0 |
1413 | 1413 | 2020-03-12 | Clay | Florida | 12019 | 1 | 0 |
1415 | 1415 | 2020-03-12 | Duval | Florida | 12031 | 1 | 0 |
1420 | 1420 | 2020-03-12 | Nassau | Florida | 12089 | 1 | 0 |
1421 | 1421 | 2020-03-12 | Okaloosa | Florida | 12091 | 1 | 0 |
1423 | 1423 | 2020-03-12 | Pasco | Florida | 12101 | 1 | 0 |
1425 | 1425 | 2020-03-12 | Santa Rosa | Florida | 12113 | 1 | 1 |
1427 | 1427 | 2020-03-12 | Seminole | Florida | 12117 | 1 | 0 |
1428 | 1428 | 2020-03-12 | St. Johns | Florida | 12109 | 1 | 0 |
1678 | 1678 | 2020-03-13 | Charlotte | Florida | 12015 | 1 | 0 |
1679 | 1679 | 2020-03-13 | Clay | Florida | 12019 | 1 | 0 |
1681 | 1681 | 2020-03-13 | Duval | Florida | 12031 | 1 | 0 |
1686 | 1686 | 2020-03-13 | Nassau | Florida | 12089 | 1 | 0 |
1687 | 1687 | 2020-03-13 | Okaloosa | Florida | 12091 | 1 | 0 |
1688 | 1688 | 2020-03-13 | Orange | Florida | 12095 | 1 | 0 |
1689 | 1689 | 2020-03-13 | Osceola | Florida | 12097 | 1 | 0 |
1691 | 1691 | 2020-03-13 | Pasco | Florida | 12101 | 1 | 0 |
1693 | 1693 | 2020-03-13 | Santa Rosa | Florida | 12113 | 1 | 1 |
1695 | 1695 | 2020-03-13 | Seminole | Florida | 12117 | 1 | 0 |
1696 | 1696 | 2020-03-13 | St. Johns | Florida | 12109 | 1 | 0 |
2000 | 2000 | 2020-03-14 | Charlotte | Florida | 12015 | 1 | 0 |
2001 | 2001 | 2020-03-14 | Clay | Florida | 12019 | 1 | 0 |
2003 | 2003 | 2020-03-14 | Duval | Florida | 12031 | 1 | 0 |
2008 | 2008 | 2020-03-14 | Nassau | Florida | 12089 | 1 | 0 |
2009 | 2009 | 2020-03-14 | Okaloosa | Florida | 12091 | 1 | 0 |
2010 | 2010 | 2020-03-14 | Orange | Florida | 12095 | 1 | 0 |
2011 | 2011 | 2020-03-14 | Osceola | Florida | 12097 | 1 | 0 |
2013 | 2013 | 2020-03-14 | Pasco | Florida | 12101 | 1 | 0 |
2015 | 2015 | 2020-03-14 | Santa Rosa | Florida | 12113 | 1 | 1 |
2017 | 2017 | 2020-03-14 | Seminole | Florida | 12117 | 1 | 0 |
2018 | 2018 | 2020-03-14 | St. Johns | Florida | 12109 | 1 | 0 |
2381 | 2381 | 2020-03-15 | Baker | Florida | 12003 | 1 | 0 |
2383 | 2383 | 2020-03-15 | Charlotte | Florida | 12015 | 1 | 0 |
2384 | 2384 | 2020-03-15 | Citrus | Florida | 12017 | 1 | 0 |
2392 | 2392 | 2020-03-15 | Nassau | Florida | 12089 | 1 | 0 |
2393 | 2393 | 2020-03-15 | Okaloosa | Florida | 12091 | 1 | 0 |
2395 | 2395 | 2020-03-15 | Osceola | Florida | 12097 | 1 | 0 |
2399 | 2399 | 2020-03-15 | Santa Rosa | Florida | 12113 | 1 | 1 |
2401 | 2401 | 2020-03-15 | Seminole | Florida | 12117 | 1 | 0 |
2816 | 2816 | 2020-03-16 | Baker | Florida | 12003 | 1 | 0 |
2818 | 2818 | 2020-03-16 | Charlotte | Florida | 12015 | 1 | 0 |
2819 | 2819 | 2020-03-16 | Citrus | Florida | 12017 | 1 | 0 |
2823 | 2823 | 2020-03-16 | Escambia | Florida | 12033 | 1 | 0 |
2825 | 2825 | 2020-03-16 | Lake | Florida | 12069 | 1 | 0 |
2829 | 2829 | 2020-03-16 | Nassau | Florida | 12089 | 1 | 0 |
2830 | 2830 | 2020-03-16 | Okaloosa | Florida | 12091 | 1 | 0 |
2836 | 2836 | 2020-03-16 | Santa Rosa | Florida | 12113 | 1 | 1 |
3299 | 3299 | 2020-03-17 | Baker | Florida | 12003 | 1 | 0 |
3300 | 3300 | 2020-03-17 | Brevard | Florida | 12009 | 1 | 0 |
3302 | 3302 | 2020-03-17 | Charlotte | Florida | 12015 | 1 | 0 |
3307 | 3307 | 2020-03-17 | Escambia | Florida | 12033 | 1 | 0 |
3309 | 3309 | 2020-03-17 | Lake | Florida | 12069 | 1 | 0 |
3313 | 3313 | 2020-03-17 | Nassau | Florida | 12089 | 1 | 0 |
3320 | 3320 | 2020-03-17 | Polk | Florida | 12105 | 1 | 0 |
3321 | 3321 | 2020-03-17 | Santa Rosa | Florida | 12113 | 1 | 1 |
3856 | 3856 | 2020-03-18 | Baker | Florida | 12003 | 1 | 0 |
3859 | 3859 | 2020-03-18 | Charlotte | Florida | 12015 | 1 | 0 |
3864 | 3864 | 2020-03-18 | Escambia | Florida | 12033 | 1 | 0 |
3868 | 3868 | 2020-03-18 | Leon | Florida | 12073 | 1 | 0 |
3871 | 3871 | 2020-03-18 | Nassau | Florida | 12089 | 1 | 0 |
3879 | 3879 | 2020-03-18 | Santa Rosa | Florida | 12113 | 1 | 1 |
3883 | 3883 | 2020-03-18 | Sumter | Florida | 12119 | 1 | 0 |
3885 | 3885 | 2020-03-18 | Walton | Florida | 12131 | 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);