daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68,836 rows where province_or_state = "Florida" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-27 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 2020-03-27 22:14:55 | Calhoun, Florida, US |
2020-03-27 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 2020-03-27 22:14:55 | Dixie, Florida, US |
2020-03-27 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 2020-03-27 22:14:55 | Franklin, Florida, US |
2020-03-27 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 2020-03-27 22:14:55 | Gilchrist, Florida, US |
2020-03-27 | US | Florida | Glades | 12043 | 0 | 0 | 0 | 0 | 26.95635849 | -81.18996211 | 2020-03-27 22:14:55 | Glades, Florida, US |
2020-03-27 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.24270990000002 | 2020-03-27 22:14:55 | Gulf, Florida, US |
2020-03-27 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 2020-03-27 22:14:55 | Hamilton, Florida, US |
2020-03-27 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 2020-03-27 22:14:55 | Hardee, Florida, US |
2020-03-27 | US | Florida | Hendry | 12051 | 0 | 0 | 0 | 0 | 26.55386945 | -81.16469006 | 2020-03-27 22:14:55 | Hendry, Florida, US |
2020-03-27 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 2020-03-27 22:14:55 | Holmes, Florida, US |
2020-03-27 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 2020-03-27 22:14:55 | Jefferson, Florida, US |
2020-03-27 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 2020-03-27 22:14:55 | Lafayette, Florida, US |
2020-03-27 | US | Florida | Levy | 12075 | 0 | 0 | 0 | 0 | 29.31829741 | -82.74007147 | 2020-03-27 22:14:55 | Levy, Florida, US |
2020-03-27 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 2020-03-27 22:14:55 | Liberty, Florida, US |
2020-03-27 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 2020-03-27 22:14:55 | Madison, Florida, US |
2020-03-27 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.386336199999995 | -80.88944347 | 2020-03-27 22:14:55 | Okeechobee, Florida, US |
2020-03-27 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 2020-03-27 22:14:55 | Taylor, Florida, US |
2020-03-27 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 2020-03-27 22:14:55 | Union, Florida, US |
2020-03-27 | US | Florida | Wakulla | 12129 | 0 | 0 | 0 | 0 | 30.16548905 | -84.39895211 | 2020-03-27 22:14:55 | Wakulla, Florida, US |
2020-03-26 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 2020-03-26 23:48:35 | Calhoun, Florida, US |
2020-03-26 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 2020-03-26 23:48:35 | Dixie, Florida, US |
2020-03-26 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 2020-03-26 23:48:35 | Franklin, Florida, US |
2020-03-26 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 2020-03-26 23:48:35 | Gilchrist, Florida, US |
2020-03-26 | US | Florida | Glades | 12043 | 0 | 0 | 0 | 0 | 26.95635849 | -81.18996211 | 2020-03-26 23:48:35 | Glades, Florida, US |
2020-03-26 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.24270990000002 | 2020-03-26 23:48:35 | Gulf, Florida, US |
2020-03-26 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 2020-03-26 23:48:35 | Hamilton, Florida, US |
2020-03-26 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 2020-03-26 23:48:35 | Hardee, Florida, US |
2020-03-26 | US | Florida | Hendry | 12051 | 0 | 0 | 0 | 0 | 26.55386945 | -81.16469006 | 2020-03-26 23:48:35 | Hendry, Florida, US |
2020-03-26 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 2020-03-26 23:48:35 | Holmes, Florida, US |
2020-03-26 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 2020-03-26 23:48:35 | Jefferson, Florida, US |
2020-03-26 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 2020-03-26 23:48:35 | Lafayette, Florida, US |
2020-03-26 | US | Florida | Levy | 12075 | 0 | 0 | 0 | 0 | 29.31829741 | -82.74007147 | 2020-03-26 23:48:35 | Levy, Florida, US |
2020-03-26 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 2020-03-26 23:48:35 | Liberty, Florida, US |
2020-03-26 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 2020-03-26 23:48:35 | Madison, Florida, US |
2020-03-26 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.386336199999995 | -80.88944347 | 2020-03-26 23:48:35 | Okeechobee, Florida, US |
2020-03-26 | US | Florida | Suwannee | 12121 | 0 | 0 | 0 | 0 | 30.19746066 | -82.99099670000003 | 2020-03-26 23:48:35 | Suwannee, Florida, US |
2020-03-26 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 2020-03-26 23:48:35 | Taylor, Florida, US |
2020-03-26 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 2020-03-26 23:48:35 | Union, Florida, US |
2020-03-26 | US | Florida | Wakulla | 12129 | 0 | 0 | 0 | 0 | 30.16548905 | -84.39895211 | 2020-03-26 23:48:35 | Wakulla, Florida, US |
2020-03-26 | US | Florida | Washington | 12133 | 0 | 0 | 0 | 0 | 30.61359259 | -85.66002461 | 2020-03-26 23:48:35 | Washington, Florida, US |
2020-03-25 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 2020-03-25 23:33:19 | Calhoun, Florida, US |
2020-03-25 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 2020-03-25 23:33:19 | Dixie, Florida, US |
2020-03-25 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 2020-03-25 23:33:19 | Franklin, Florida, US |
2020-03-25 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 2020-03-25 23:33:19 | Gilchrist, Florida, US |
2020-03-25 | US | Florida | Glades | 12043 | 0 | 0 | 0 | 0 | 26.95635849 | -81.18996211 | 2020-03-25 23:33:19 | Glades, Florida, US |
2020-03-25 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.24270990000002 | 2020-03-25 23:33:19 | Gulf, Florida, US |
2020-03-25 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 2020-03-25 23:33:19 | Hamilton, Florida, US |
2020-03-25 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 2020-03-25 23:33:19 | Hardee, Florida, US |
2020-03-25 | US | Florida | Hendry | 12051 | 0 | 0 | 0 | 0 | 26.55386945 | -81.16469006 | 2020-03-25 23:33:19 | Hendry, Florida, US |
2020-03-25 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 2020-03-25 23:33:19 | Holmes, Florida, US |
2020-03-25 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 2020-03-25 23:33:19 | Jefferson, Florida, US |
2020-03-25 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 2020-03-25 23:33:19 | Lafayette, Florida, US |
2020-03-25 | US | Florida | Levy | 12075 | 0 | 0 | 0 | 0 | 29.31829741 | -82.74007147 | 2020-03-25 23:33:19 | Levy, Florida, US |
2020-03-25 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 2020-03-25 23:33:19 | Liberty, Florida, US |
2020-03-25 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 2020-03-25 23:33:19 | Madison, Florida, US |
2020-03-25 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.386336199999995 | -80.88944347 | 2020-03-25 23:33:19 | Okeechobee, Florida, US |
2020-03-25 | US | Florida | Suwannee | 12121 | 0 | 0 | 0 | 0 | 30.19746066 | -82.99099670000003 | 2020-03-25 23:33:19 | Suwannee, Florida, US |
2020-03-25 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 2020-03-25 23:33:19 | Taylor, Florida, US |
2020-03-25 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 2020-03-25 23:33:19 | Union, Florida, US |
2020-03-25 | US | Florida | Wakulla | 12129 | 0 | 0 | 0 | 0 | 30.16548905 | -84.39895211 | 2020-03-25 23:33:19 | Wakulla, Florida, US |
2020-03-25 | US | Florida | Washington | 12133 | 0 | 0 | 0 | 0 | 30.61359259 | -85.66002461 | 2020-03-25 23:33:19 | Washington, Florida, US |
2020-04-22 | US | Florida | Unassigned | 90012 | 0 | 0 | 0 | 0 | 30.86747479 | 0.0 | 2020-04-22 23:30:53 | Unassigned, Florida, US |
2020-04-24 | US | Florida | Unassigned | 90012 | 0 | 0 | 0 | 0 | 30.86747479 | 0.0 | 2020-04-25 06:30:53 | Unassigned, Florida, US |
2020-03-24 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 2020-03-24 23:37:31 | Calhoun, Florida, US |
2020-03-24 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 2020-03-24 23:37:31 | Dixie, Florida, US |
2020-03-24 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 2020-03-24 23:37:31 | Franklin, Florida, US |
2020-03-24 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 2020-03-24 23:37:31 | Gilchrist, Florida, US |
2020-03-24 | US | Florida | Glades | 12043 | 0 | 0 | 0 | 0 | 26.95635849 | -81.18996211 | 2020-03-24 23:37:31 | Glades, Florida, US |
2020-03-24 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.24270990000002 | 2020-03-24 23:37:31 | Gulf, Florida, US |
2020-03-24 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 2020-03-24 23:37:31 | Hamilton, Florida, US |
2020-03-24 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 2020-03-24 23:37:31 | Hardee, Florida, US |
2020-03-24 | US | Florida | Hendry | 12051 | 0 | 0 | 0 | 0 | 26.55386945 | -81.16469006 | 2020-03-24 23:37:31 | Hendry, Florida, US |
2020-03-24 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 2020-03-24 23:37:31 | Holmes, Florida, US |
2020-03-24 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 2020-03-24 23:37:31 | Jefferson, Florida, US |
2020-03-24 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 2020-03-24 23:37:31 | Lafayette, Florida, US |
2020-03-24 | US | Florida | Levy | 12075 | 0 | 0 | 0 | 0 | 29.31829741 | -82.74007147 | 2020-03-24 23:37:31 | Levy, Florida, US |
2020-03-24 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 2020-03-24 23:37:31 | Liberty, Florida, US |
2020-03-24 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 2020-03-24 23:37:31 | Madison, Florida, US |
2020-03-24 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.386336199999995 | -80.88944347 | 2020-03-24 23:37:31 | Okeechobee, Florida, US |
2020-03-24 | US | Florida | Suwannee | 12121 | 0 | 0 | 0 | 0 | 30.19746066 | -82.99099670000003 | 2020-03-24 23:37:31 | Suwannee, Florida, US |
2020-03-24 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 2020-03-24 23:37:31 | Taylor, Florida, US |
2020-03-24 | US | Florida | Unassigned | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-03-24 23:37:31 | Unassigned, Florida, US | |
2020-03-24 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 2020-03-24 23:37:31 | Union, Florida, US |
2020-03-24 | US | Florida | Wakulla | 12129 | 0 | 0 | 0 | 0 | 30.16548905 | -84.39895211 | 2020-03-24 23:37:31 | Wakulla, Florida, US |
2020-03-24 | US | Florida | Washington | 12133 | 0 | 0 | 0 | 0 | 30.61359259 | -85.66002461 | 2020-03-24 23:37:31 | Washington, Florida, US |
2020-03-30 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 3/30/20 22:52 | Calhoun, Florida, US |
2020-03-30 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 3/30/20 22:52 | Dixie, Florida, US |
2020-03-30 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 3/30/20 22:52 | Franklin, Florida, US |
2020-03-30 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 3/30/20 22:52 | Gilchrist, Florida, US |
2020-03-30 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.2427099 | 3/30/20 22:52 | Gulf, Florida, US |
2020-03-30 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 3/30/20 22:52 | Hamilton, Florida, US |
2020-03-30 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 3/30/20 22:52 | Hardee, Florida, US |
2020-03-30 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 3/30/20 22:52 | Holmes, Florida, US |
2020-03-30 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 3/30/20 22:52 | Jefferson, Florida, US |
2020-03-30 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 3/30/20 22:52 | Lafayette, Florida, US |
2020-03-30 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 3/30/20 22:52 | Liberty, Florida, US |
2020-03-30 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 3/30/20 22:52 | Madison, Florida, US |
2020-03-30 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.3863362 | -80.88944347 | 3/30/20 22:52 | Okeechobee, Florida, US |
2020-03-30 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 3/30/20 22:52 | Taylor, Florida, US |
2020-03-30 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 3/30/20 22:52 | Union, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;