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)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-23 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 2020-03-23 23:19:34 | Calhoun, Florida, US |
2020-03-23 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 2020-03-23 23:19:34 | Dixie, Florida, US |
2020-03-23 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 2020-03-23 23:19:34 | Franklin, Florida, US |
2020-03-23 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 2020-03-23 23:19:34 | Gilchrist, Florida, US |
2020-03-23 | US | Florida | Glades | 12043 | 0 | 0 | 0 | 0 | 26.95635849 | -81.18996211 | 2020-03-23 23:19:34 | Glades, Florida, US |
2020-03-23 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.24270990000002 | 2020-03-23 23:19:34 | Gulf, Florida, US |
2020-03-23 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 2020-03-23 23:19:34 | Hamilton, Florida, US |
2020-03-23 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 2020-03-23 23:19:34 | Hardee, Florida, US |
2020-03-23 | US | Florida | Hendry | 12051 | 0 | 0 | 0 | 0 | 26.55386945 | -81.16469006 | 2020-03-23 23:19:34 | Hendry, Florida, US |
2020-03-23 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 2020-03-23 23:19:34 | Holmes, Florida, US |
2020-03-23 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 2020-03-23 23:19:34 | Jefferson, Florida, US |
2020-03-23 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 2020-03-23 23:19:34 | Lafayette, Florida, US |
2020-03-23 | US | Florida | Levy | 12075 | 0 | 0 | 0 | 0 | 29.31829741 | -82.74007147 | 2020-03-23 23:19:34 | Levy, Florida, US |
2020-03-23 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 2020-03-23 23:19:34 | Liberty, Florida, US |
2020-03-23 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 2020-03-23 23:19:34 | Madison, Florida, US |
2020-03-23 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.386336199999995 | -80.88944347 | 2020-03-23 23:19:34 | Okeechobee, Florida, US |
2020-03-23 | US | Florida | Suwannee | 12121 | 0 | 0 | 0 | 0 | 30.19746066 | -82.99099670000003 | 2020-03-23 23:19:34 | Suwannee, Florida, US |
2020-03-23 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 2020-03-23 23:19:34 | Taylor, Florida, US |
2020-03-23 | US | Florida | Unassigned | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-03-23 23:19:34 | Unassigned, Florida, US | |
2020-03-23 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 2020-03-23 23:19:34 | Union, Florida, US |
2020-03-23 | US | Florida | Wakulla | 12129 | 0 | 0 | 0 | 0 | 30.16548905 | -84.39895211 | 2020-03-23 23:19:34 | Wakulla, Florida, US |
2020-03-23 | US | Florida | Washington | 12133 | 0 | 0 | 0 | 0 | 30.61359259 | -85.66002461 | 2020-03-23 23:19:34 | Washington, Florida, US |
2020-04-23 | US | Florida | Unassigned | 90012 | 0 | 0 | 0 | 0 | 30.86747479 | 0.0 | 2020-04-24 03:30:50 | Unassigned, Florida, US |
2020-03-29 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 3/29/20 23:08 | Calhoun, Florida, US |
2020-03-29 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 3/29/20 23:08 | Dixie, Florida, US |
2020-03-29 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 3/29/20 23:08 | Franklin, Florida, US |
2020-03-29 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 3/29/20 23:08 | Gilchrist, Florida, US |
2020-03-29 | US | Florida | Glades | 12043 | 0 | 0 | 0 | 0 | 26.95635849 | -81.18996211 | 3/29/20 23:08 | Glades, Florida, US |
2020-03-29 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.2427099 | 3/29/20 23:08 | Gulf, Florida, US |
2020-03-29 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 3/29/20 23:08 | Hamilton, Florida, US |
2020-03-29 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 3/29/20 23:08 | Hardee, Florida, US |
2020-03-29 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 3/29/20 23:08 | Holmes, Florida, US |
2020-03-29 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 3/29/20 23:08 | Jefferson, Florida, US |
2020-03-29 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 3/29/20 23:08 | Lafayette, Florida, US |
2020-03-29 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 3/29/20 23:08 | Liberty, Florida, US |
2020-03-29 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 3/29/20 23:08 | Madison, Florida, US |
2020-03-29 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.3863362 | -80.88944347 | 3/29/20 23:08 | Okeechobee, Florida, US |
2020-03-29 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 3/29/20 23:08 | Taylor, Florida, US |
2020-03-29 | US | Florida | Unassigned | 0 | 2 | 0 | 0 | 0.0 | 0.0 | 3/29/20 23:08 | Unassigned, Florida, US | |
2020-03-29 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 3/29/20 23:08 | Union, Florida, US |
2020-03-29 | US | Florida | Wakulla | 12129 | 0 | 0 | 0 | 0 | 30.16548905 | -84.39895211 | 3/29/20 23:08 | Wakulla, Florida, US |
2020-03-22 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 3/22/20 23:45 | Calhoun, Florida, US |
2020-03-22 | US | Florida | DeSoto | 12027 | 0 | 0 | 0 | 0 | 27.18677893 | -81.80941373 | 3/22/20 23:45 | DeSoto, Florida, US |
2020-03-22 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 3/22/20 23:45 | Dixie, Florida, US |
2020-03-22 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 3/22/20 23:45 | Franklin, Florida, US |
2020-03-22 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 3/22/20 23:45 | Gilchrist, Florida, US |
2020-03-22 | US | Florida | Glades | 12043 | 0 | 0 | 0 | 0 | 26.95635849 | -81.18996211 | 3/22/20 23:45 | Glades, Florida, US |
2020-03-22 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.2427099 | 3/22/20 23:45 | Gulf, Florida, US |
2020-03-22 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 3/22/20 23:45 | Hamilton, Florida, US |
2020-03-22 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 3/22/20 23:45 | Hardee, Florida, US |
2020-03-22 | US | Florida | Hendry | 12051 | 0 | 0 | 0 | 0 | 26.55386945 | -81.16469006 | 3/22/20 23:45 | Hendry, Florida, US |
2020-03-22 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 3/22/20 23:45 | Holmes, Florida, US |
2020-03-22 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 3/22/20 23:45 | Jefferson, Florida, US |
2020-03-22 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 3/22/20 23:45 | Lafayette, Florida, US |
2020-03-22 | US | Florida | Levy | 12075 | 0 | 0 | 0 | 0 | 29.31829741 | -82.74007147 | 3/22/20 23:45 | Levy, Florida, US |
2020-03-22 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 3/22/20 23:45 | Liberty, Florida, US |
2020-03-22 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 3/22/20 23:45 | Madison, Florida, US |
2020-03-22 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.3863362 | -80.88944347 | 3/22/20 23:45 | Okeechobee, Florida, US |
2020-03-22 | US | Florida | Suwannee | 12121 | 0 | 0 | 0 | 0 | 30.19746066 | -82.9909967 | 3/22/20 23:45 | Suwannee, Florida, US |
2020-03-22 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 3/22/20 23:45 | Taylor, Florida, US |
2020-03-22 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 3/22/20 23:45 | Union, Florida, US |
2020-03-22 | US | Florida | Wakulla | 12129 | 0 | 0 | 0 | 0 | 30.16548905 | -84.39895211 | 3/22/20 23:45 | Wakulla, Florida, US |
2020-03-22 | US | Florida | Washington | 12133 | 0 | 0 | 0 | 0 | 30.61359259 | -85.66002461 | 3/22/20 23:45 | Washington, Florida, US |
2020-03-28 | US | Florida | Calhoun | 12013 | 0 | 0 | 0 | 0 | 30.40666734 | -85.19394153 | 3/28/20 23:05 | Calhoun, Florida, US |
2020-03-28 | US | Florida | Dixie | 12029 | 0 | 0 | 0 | 0 | 29.60631086 | -83.15724673 | 3/28/20 23:05 | Dixie, Florida, US |
2020-03-28 | US | Florida | Franklin | 12037 | 0 | 0 | 0 | 0 | 29.83791238 | -84.82731662 | 3/28/20 23:05 | Franklin, Florida, US |
2020-03-28 | US | Florida | Gilchrist | 12041 | 0 | 0 | 0 | 0 | 29.72856978 | -82.79880657 | 3/28/20 23:05 | Gilchrist, Florida, US |
2020-03-28 | US | Florida | Glades | 12043 | 0 | 0 | 0 | 0 | 26.95635849 | -81.18996211 | 3/28/20 23:05 | Glades, Florida, US |
2020-03-28 | US | Florida | Gulf | 12045 | 0 | 0 | 0 | 0 | 29.93543004 | -85.2427099 | 3/28/20 23:05 | Gulf, Florida, US |
2020-03-28 | US | Florida | Hamilton | 12047 | 0 | 0 | 0 | 0 | 30.49673973 | -82.94998918 | 3/28/20 23:05 | Hamilton, Florida, US |
2020-03-28 | US | Florida | Hardee | 12049 | 0 | 0 | 0 | 0 | 27.49293939 | -81.80956574 | 3/28/20 23:05 | Hardee, Florida, US |
2020-03-28 | US | Florida | Hendry | 12051 | 0 | 0 | 0 | 0 | 26.55386945 | -81.16469006 | 3/28/20 23:05 | Hendry, Florida, US |
2020-03-28 | US | Florida | Holmes | 12059 | 0 | 0 | 0 | 0 | 30.86747479 | -85.81319222 | 3/28/20 23:05 | Holmes, Florida, US |
2020-03-28 | US | Florida | Jefferson | 12065 | 0 | 0 | 0 | 0 | 30.43669112 | -83.89442308 | 3/28/20 23:05 | Jefferson, Florida, US |
2020-03-28 | US | Florida | Lafayette | 12067 | 0 | 0 | 0 | 0 | 29.98484137 | -83.18166636 | 3/28/20 23:05 | Lafayette, Florida, US |
2020-03-28 | US | Florida | Liberty | 12077 | 0 | 0 | 0 | 0 | 30.23766008 | -84.8829258 | 3/28/20 23:05 | Liberty, Florida, US |
2020-03-28 | US | Florida | Madison | 12079 | 0 | 0 | 0 | 0 | 30.44396917 | -83.47398594 | 3/28/20 23:05 | Madison, Florida, US |
2020-03-28 | US | Florida | Okeechobee | 12093 | 0 | 0 | 0 | 0 | 27.3863362 | -80.88944347 | 3/28/20 23:05 | Okeechobee, Florida, US |
2020-03-28 | US | Florida | Taylor | 12123 | 0 | 0 | 0 | 0 | 30.04848048 | -83.60445406 | 3/28/20 23:05 | Taylor, Florida, US |
2020-03-28 | US | Florida | Unassigned | 0 | 8 | 0 | 0 | 0.0 | 0.0 | 3/28/20 23:05 | Unassigned, Florida, US | |
2020-03-28 | US | Florida | Union | 12125 | 0 | 0 | 0 | 0 | 30.04412971 | -82.37497443 | 3/28/20 23:05 | Union, Florida, US |
2020-03-28 | US | Florida | Wakulla | 12129 | 0 | 0 | 0 | 0 | 30.16548905 | -84.39895211 | 3/28/20 23:05 | Wakulla, Florida, US |
2020-04-13 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.24270990000002 | 2020-04-13 23:07:54 | Gulf, Florida, US |
2020-04-13 | US | Florida | Lafayette | 12067 | 1 | 0 | 0 | 1 | 29.98484137 | -83.18166636 | 2020-04-13 23:07:54 | Lafayette, Florida, US |
2020-04-13 | US | Florida | Taylor | 12123 | 1 | 0 | 0 | 1 | 30.04848048 | -83.60445406 | 2020-04-13 23:07:54 | Taylor, Florida, US |
2020-04-17 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.24270990000002 | 2020-04-17 23:30:52 | Gulf, Florida, US |
2020-04-17 | US | Florida | Lafayette | 12067 | 1 | 0 | 0 | 1 | 29.98484137 | -83.18166636 | 2020-04-17 23:30:52 | Lafayette, Florida, US |
2020-04-17 | US | Florida | Taylor | 12123 | 1 | 0 | 0 | 1 | 30.04848048 | -83.60445406 | 2020-04-17 23:30:52 | Taylor, Florida, US |
2020-05-08 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.24270990000002 | 2020-05-09 02:32:35 | Gulf, Florida, US |
2020-04-29 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.24270990000002 | 2020-04-30 02:32:27 | Gulf, Florida, US |
2020-04-29 | US | Florida | Lafayette | 12067 | 1 | 0 | 0 | 1 | 29.98484137 | -83.18166636 | 2020-04-30 02:32:27 | Lafayette, Florida, US |
2020-04-30 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.24270990000002 | 2020-05-01 02:32:28 | Gulf, Florida, US |
2020-04-30 | US | Florida | Lafayette | 12067 | 1 | 0 | 0 | 1 | 29.98484137 | -83.18166636 | 2020-05-01 02:32:28 | Lafayette, Florida, US |
2020-05-21 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.24270990000002 | 2020-05-22 02:36:51 | Gulf, Florida, US |
2020-04-28 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.24270990000002 | 2020-04-29 02:32:29 | Gulf, Florida, US |
2020-04-28 | US | Florida | Lafayette | 12067 | 1 | 0 | 0 | 1 | 29.98484137 | -83.18166636 | 2020-04-29 02:32:29 | Lafayette, Florida, US |
2020-04-18 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.2427099 | 2020-04-18 22:32:47 | Gulf, Florida, US |
2020-04-18 | US | Florida | Lafayette | 12067 | 1 | 0 | 0 | 1 | 29.98484137 | -83.18166636 | 2020-04-18 22:32:47 | Lafayette, Florida, US |
2020-04-18 | US | Florida | Taylor | 12123 | 1 | 0 | 0 | 1 | 30.04848048 | -83.60445406 | 2020-04-18 22:32:47 | Taylor, Florida, US |
2020-04-21 | US | Florida | Gulf | 12045 | 1 | 0 | 0 | 1 | 29.93543004 | -85.24270990000002 | 2020-04-21 23:30:50 | Gulf, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;