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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 12095 792
- 12097 792
- 12099 792
- 12101 792
- 12103 792
- 12109 792
- 12113 792
- 12115 792
- 12117 792
- 12127 792
- 12001 791
- 12011 791
- 12015 791
- 12019 791
- 12021 791
- 12031 791
- 12057 791
- 12071 791
- 12081 791
- 12086 791
- 12089 791
- 12091 791
- 12003 790
- 12017 790
- 12033 789
- 12069 789
- 12009 788
- 12105 788
- 12073 787
- 12119 787
- …
county >30
- Orange 792
- Osceola 792
- Palm Beach 792
- Pasco 792
- Pinellas 792
- Santa Rosa 792
- Sarasota 792
- Seminole 792
- St. Johns 792
- Volusia 792
- Alachua 791
- Broward 791
- Charlotte 791
- Clay 791
- Collier 791
- Duval 791
- Hillsborough 791
- Lee 791
- Manatee 791
- Miami-Dade 791
- Nassau 791
- Okaloosa 791
- Baker 790
- Citrus 790
- Escambia 789
- Lake 789
- Brevard 788
- Polk 788
- Leon 787
- Sumter 787
- …
state 1
- Florida · 53,262 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1688 | 1688 | 2020-03-13 | Orange | Florida | 12095 | 1 | 0 |
1689 | 1689 | 2020-03-13 | Osceola | Florida | 12097 | 1 | 0 |
1690 | 1690 | 2020-03-13 | Palm Beach | Florida | 12099 | 5 | 0 |
1691 | 1691 | 2020-03-13 | Pasco | Florida | 12101 | 1 | 0 |
1692 | 1692 | 2020-03-13 | Pinellas | Florida | 12103 | 2 | 0 |
1693 | 1693 | 2020-03-13 | Santa Rosa | Florida | 12113 | 1 | 1 |
1694 | 1694 | 2020-03-13 | Sarasota | Florida | 12115 | 2 | 0 |
1695 | 1695 | 2020-03-13 | Seminole | Florida | 12117 | 1 | 0 |
1696 | 1696 | 2020-03-13 | St. Johns | Florida | 12109 | 1 | 0 |
1697 | 1697 | 2020-03-13 | Volusia | Florida | 12127 | 4 | 0 |
1998 | 1998 | 2020-03-14 | Alachua | Florida | 12001 | 3 | 0 |
1999 | 1999 | 2020-03-14 | Broward | Florida | 12011 | 21 | 0 |
2000 | 2000 | 2020-03-14 | Charlotte | Florida | 12015 | 1 | 0 |
2001 | 2001 | 2020-03-14 | Clay | Florida | 12019 | 1 | 0 |
2002 | 2002 | 2020-03-14 | Collier | Florida | 12021 | 3 | 0 |
2003 | 2003 | 2020-03-14 | Duval | Florida | 12031 | 1 | 0 |
2004 | 2004 | 2020-03-14 | Hillsborough | Florida | 12057 | 3 | 0 |
2005 | 2005 | 2020-03-14 | Lee | Florida | 12071 | 4 | 2 |
2006 | 2006 | 2020-03-14 | Manatee | Florida | 12081 | 4 | 0 |
2007 | 2007 | 2020-03-14 | Miami-Dade | Florida | 12086 | 8 | 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 |
2012 | 2012 | 2020-03-14 | Palm Beach | Florida | 12099 | 5 | 0 |
2013 | 2013 | 2020-03-14 | Pasco | Florida | 12101 | 1 | 0 |
2014 | 2014 | 2020-03-14 | Pinellas | Florida | 12103 | 2 | 0 |
2015 | 2015 | 2020-03-14 | Santa Rosa | Florida | 12113 | 1 | 1 |
2016 | 2016 | 2020-03-14 | Sarasota | Florida | 12115 | 2 | 0 |
2017 | 2017 | 2020-03-14 | Seminole | Florida | 12117 | 1 | 0 |
2018 | 2018 | 2020-03-14 | St. Johns | Florida | 12109 | 1 | 0 |
2019 | 2019 | 2020-03-14 | Volusia | Florida | 12127 | 4 | 0 |
2380 | 2380 | 2020-03-15 | Alachua | Florida | 12001 | 4 | 0 |
2381 | 2381 | 2020-03-15 | Baker | Florida | 12003 | 1 | 0 |
2382 | 2382 | 2020-03-15 | Broward | Florida | 12011 | 37 | 0 |
2383 | 2383 | 2020-03-15 | Charlotte | Florida | 12015 | 1 | 0 |
2384 | 2384 | 2020-03-15 | Citrus | Florida | 12017 | 1 | 0 |
2385 | 2385 | 2020-03-15 | Clay | Florida | 12019 | 3 | 0 |
2386 | 2386 | 2020-03-15 | Collier | Florida | 12021 | 5 | 0 |
2387 | 2387 | 2020-03-15 | Duval | Florida | 12031 | 4 | 0 |
2388 | 2388 | 2020-03-15 | Hillsborough | Florida | 12057 | 6 | 0 |
2389 | 2389 | 2020-03-15 | Lee | Florida | 12071 | 5 | 2 |
2390 | 2390 | 2020-03-15 | Manatee | Florida | 12081 | 4 | 0 |
2391 | 2391 | 2020-03-15 | Miami-Dade | Florida | 12086 | 13 | 0 |
2392 | 2392 | 2020-03-15 | Nassau | Florida | 12089 | 1 | 0 |
2393 | 2393 | 2020-03-15 | Okaloosa | Florida | 12091 | 1 | 0 |
2394 | 2394 | 2020-03-15 | Orange | Florida | 12095 | 2 | 0 |
2395 | 2395 | 2020-03-15 | Osceola | Florida | 12097 | 1 | 0 |
2396 | 2396 | 2020-03-15 | Palm Beach | Florida | 12099 | 5 | 0 |
2397 | 2397 | 2020-03-15 | Pasco | Florida | 12101 | 2 | 0 |
2398 | 2398 | 2020-03-15 | Pinellas | Florida | 12103 | 2 | 0 |
2399 | 2399 | 2020-03-15 | Santa Rosa | Florida | 12113 | 1 | 1 |
2400 | 2400 | 2020-03-15 | Sarasota | Florida | 12115 | 2 | 0 |
2401 | 2401 | 2020-03-15 | Seminole | Florida | 12117 | 1 | 0 |
2402 | 2402 | 2020-03-15 | St. Johns | Florida | 12109 | 2 | 0 |
2403 | 2403 | 2020-03-15 | Volusia | Florida | 12127 | 5 | 0 |
2815 | 2815 | 2020-03-16 | Alachua | Florida | 12001 | 4 | 0 |
2816 | 2816 | 2020-03-16 | Baker | Florida | 12003 | 1 | 0 |
2817 | 2817 | 2020-03-16 | Broward | Florida | 12011 | 39 | 0 |
2818 | 2818 | 2020-03-16 | Charlotte | Florida | 12015 | 1 | 0 |
2819 | 2819 | 2020-03-16 | Citrus | Florida | 12017 | 1 | 0 |
2820 | 2820 | 2020-03-16 | Clay | Florida | 12019 | 3 | 0 |
2821 | 2821 | 2020-03-16 | Collier | Florida | 12021 | 6 | 0 |
2822 | 2822 | 2020-03-16 | Duval | Florida | 12031 | 5 | 0 |
2823 | 2823 | 2020-03-16 | Escambia | Florida | 12033 | 1 | 0 |
2824 | 2824 | 2020-03-16 | Hillsborough | Florida | 12057 | 6 | 0 |
2825 | 2825 | 2020-03-16 | Lake | Florida | 12069 | 1 | 0 |
2826 | 2826 | 2020-03-16 | Lee | Florida | 12071 | 5 | 2 |
2827 | 2827 | 2020-03-16 | Manatee | Florida | 12081 | 5 | 0 |
2828 | 2828 | 2020-03-16 | Miami-Dade | Florida | 12086 | 23 | 0 |
2829 | 2829 | 2020-03-16 | Nassau | Florida | 12089 | 1 | 0 |
2830 | 2830 | 2020-03-16 | Okaloosa | Florida | 12091 | 1 | 0 |
2831 | 2831 | 2020-03-16 | Orange | Florida | 12095 | 4 | 1 |
2832 | 2832 | 2020-03-16 | Osceola | Florida | 12097 | 4 | 0 |
2833 | 2833 | 2020-03-16 | Palm Beach | Florida | 12099 | 7 | 0 |
2834 | 2834 | 2020-03-16 | Pasco | Florida | 12101 | 2 | 0 |
2835 | 2835 | 2020-03-16 | Pinellas | Florida | 12103 | 4 | 0 |
2836 | 2836 | 2020-03-16 | Santa Rosa | Florida | 12113 | 1 | 1 |
2837 | 2837 | 2020-03-16 | Sarasota | Florida | 12115 | 3 | 0 |
2838 | 2838 | 2020-03-16 | Seminole | Florida | 12117 | 4 | 0 |
2839 | 2839 | 2020-03-16 | St. Johns | Florida | 12109 | 2 | 0 |
2840 | 2840 | 2020-03-16 | Volusia | Florida | 12127 | 7 | 0 |
3298 | 3298 | 2020-03-17 | Alachua | Florida | 12001 | 6 | 0 |
3299 | 3299 | 2020-03-17 | Baker | Florida | 12003 | 1 | 0 |
3300 | 3300 | 2020-03-17 | Brevard | Florida | 12009 | 1 | 0 |
3301 | 3301 | 2020-03-17 | Broward | Florida | 12011 | 55 | 1 |
3302 | 3302 | 2020-03-17 | Charlotte | Florida | 12015 | 1 | 0 |
3303 | 3303 | 2020-03-17 | Citrus | Florida | 12017 | 2 | 0 |
3304 | 3304 | 2020-03-17 | Clay | Florida | 12019 | 4 | 0 |
3305 | 3305 | 2020-03-17 | Collier | Florida | 12021 | 7 | 0 |
3306 | 3306 | 2020-03-17 | Duval | Florida | 12031 | 10 | 0 |
3307 | 3307 | 2020-03-17 | Escambia | Florida | 12033 | 1 | 0 |
3308 | 3308 | 2020-03-17 | Hillsborough | Florida | 12057 | 9 | 0 |
3309 | 3309 | 2020-03-17 | Lake | Florida | 12069 | 1 | 0 |
3310 | 3310 | 2020-03-17 | Lee | Florida | 12071 | 7 | 2 |
3311 | 3311 | 2020-03-17 | Manatee | Florida | 12081 | 7 | 1 |
3312 | 3312 | 2020-03-17 | Miami-Dade | Florida | 12086 | 43 | 0 |
3313 | 3313 | 2020-03-17 | Nassau | Florida | 12089 | 1 | 0 |
3314 | 3314 | 2020-03-17 | Okaloosa | Florida | 12091 | 2 | 0 |
3315 | 3315 | 2020-03-17 | Orange | Florida | 12095 | 6 | 1 |
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);