daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68,836 rows where province_or_state = "Florida" sorted by deaths
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-10-25 | US | Florida | Unassigned | 90012 | 1857 | 0 | 0 | 1857 | 30.86747479 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Florida, US |
2021-01-26 | US | Florida | Unassigned | 90012 | 3314 | 0 | 0 | 3314 | 30.86747479 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Florida, US |
2021-05-28 | US | Florida | Unassigned | 90012 | 3034 | 0 | 0 | 30.86747479 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Florida, US | |
2021-04-12 | US | Florida | Unassigned | 90012 | 3555 | 0 | 0 | 30.86747479 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Florida, US | |
2020-04-13 | US | Florida | Alachua | 12001 | 187 | 0 | 0 | 187 | 29.67866525 | -82.35928158 | 2020-04-13 23:07:54 | Alachua, Florida, US |
2020-04-13 | US | Florida | Calhoun | 12013 | 5 | 0 | 0 | 5 | 30.40666734 | -85.19394153 | 2020-04-13 23:07:54 | Calhoun, Florida, US |
2020-04-13 | US | Florida | Columbia | 12023 | 27 | 0 | 0 | 27 | 30.22509788 | -82.62160164 | 2020-04-13 23:07:54 | Columbia, Florida, US |
2020-04-13 | US | Florida | Dixie | 12029 | 2 | 0 | 0 | 2 | 29.60631086 | -83.15724673 | 2020-04-13 23:07:54 | Dixie, Florida, US |
2020-04-13 | US | Florida | Franklin | 12037 | 2 | 0 | 0 | 2 | 29.83791238 | -84.82731662 | 2020-04-13 23:07:54 | Franklin, Florida, US |
2020-04-13 | US | Florida | Gadsden | 12039 | 36 | 0 | 0 | 36 | 30.57796289 | -84.61915825 | 2020-04-13 23:07:54 | Gadsden, Florida, US |
2020-04-13 | US | Florida | Gilchrist | 12041 | 4 | 0 | 0 | 4 | 29.72856978 | -82.79880657 | 2020-04-13 23:07:54 | Gilchrist, 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 | Hamilton | 12047 | 2 | 0 | 0 | 2 | 30.49673973 | -82.94998918 | 2020-04-13 23:07:54 | Hamilton, Florida, US |
2020-04-13 | US | Florida | Hardee | 12049 | 3 | 0 | 0 | 3 | 27.49293939 | -81.80956574 | 2020-04-13 23:07:54 | Hardee, Florida, US |
2020-04-13 | US | Florida | Hendry | 12051 | 22 | 0 | 0 | 22 | 26.55386945 | -81.16469006 | 2020-04-13 23:07:54 | Hendry, Florida, US |
2020-04-13 | US | Florida | Holmes | 12059 | 2 | 0 | 0 | 2 | 30.86747479 | -85.81319222 | 2020-04-13 23:07:54 | Holmes, Florida, US |
2020-04-13 | US | Florida | Jackson | 12063 | 6 | 0 | 0 | 6 | 30.795459700000002 | -85.21500423 | 2020-04-13 23:07:54 | Jackson, 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 | Leon | 12073 | 150 | 0 | 0 | 150 | 30.45955727 | -84.27491114 | 2020-04-13 23:07:54 | Leon, Florida, US |
2020-04-13 | US | Florida | Levy | 12075 | 7 | 0 | 0 | 7 | 29.31829741 | -82.74007147 | 2020-04-13 23:07:54 | Levy, Florida, US |
2020-04-13 | US | Florida | Liberty | 12077 | 2 | 0 | 0 | 2 | 30.23766008 | -84.8829258 | 2020-04-13 23:07:54 | Liberty, Florida, US |
2020-04-13 | US | Florida | Madison | 12079 | 14 | 0 | 0 | 14 | 30.44396917 | -83.47398594 | 2020-04-13 23:07:54 | Madison, Florida, US |
2020-04-13 | US | Florida | Nassau | 12089 | 34 | 0 | 0 | 34 | 30.61037141 | -81.80297522 | 2020-04-13 23:07:54 | Nassau, Florida, US |
2020-04-13 | US | Florida | Okeechobee | 12093 | 5 | 0 | 0 | 5 | 27.386336199999995 | -80.88944347 | 2020-04-13 23:07:54 | Okeechobee, 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-13 | US | Florida | Unassigned | 90012 | 2 | 0 | 0 | 2 | 30.86747479 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Florida, US |
2020-04-13 | US | Florida | Union | 12125 | 2 | 0 | 0 | 2 | 30.04412971 | -82.37497443 | 2020-04-13 23:07:54 | Union, Florida, US |
2020-04-13 | US | Florida | Walton | 12131 | 29 | 0 | 0 | 29 | 30.64204028 | -86.16935664 | 2020-04-13 23:07:54 | Walton, Florida, US |
2020-04-13 | US | Florida | Washington | 12133 | 4 | 0 | 0 | 4 | 30.61359259 | -85.66002461 | 2020-04-13 23:07:54 | Washington, Florida, US |
2020-04-17 | US | Florida | Alachua | 12001 | 202 | 0 | 0 | 202 | 29.67866525 | -82.35928158 | 2020-04-17 23:30:52 | Alachua, Florida, US |
2020-04-17 | US | Florida | Calhoun | 12013 | 6 | 0 | 0 | 6 | 30.40666734 | -85.19394153 | 2020-04-17 23:30:52 | Calhoun, Florida, US |
2020-04-17 | US | Florida | Columbia | 12023 | 35 | 0 | 0 | 35 | 30.22509788 | -82.62160164 | 2020-04-17 23:30:52 | Columbia, Florida, US |
2020-04-17 | US | Florida | Dixie | 12029 | 3 | 0 | 0 | 3 | 29.60631086 | -83.15724673 | 2020-04-17 23:30:52 | Dixie, Florida, US |
2020-04-17 | US | Florida | Franklin | 12037 | 2 | 0 | 0 | 2 | 29.83791238 | -84.82731662 | 2020-04-17 23:30:52 | Franklin, Florida, US |
2020-04-17 | US | Florida | Gadsden | 12039 | 47 | 0 | 0 | 47 | 30.57796289 | -84.61915825 | 2020-04-17 23:30:52 | Gadsden, Florida, US |
2020-04-17 | US | Florida | Gilchrist | 12041 | 4 | 0 | 0 | 4 | 29.72856978 | -82.79880657 | 2020-04-17 23:30:52 | Gilchrist, 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 | Hamilton | 12047 | 3 | 0 | 0 | 3 | 30.49673973 | -82.94998918 | 2020-04-17 23:30:52 | Hamilton, Florida, US |
2020-04-17 | US | Florida | Hardee | 12049 | 4 | 0 | 0 | 4 | 27.49293939 | -81.80956574 | 2020-04-17 23:30:52 | Hardee, Florida, US |
2020-04-17 | US | Florida | Hendry | 12051 | 31 | 0 | 0 | 31 | 26.55386945 | -81.16469006 | 2020-04-17 23:30:52 | Hendry, Florida, US |
2020-04-17 | US | Florida | Holmes | 12059 | 5 | 0 | 0 | 5 | 30.86747479 | -85.81319222 | 2020-04-17 23:30:52 | Holmes, Florida, US |
2020-04-17 | US | Florida | Jackson | 12063 | 8 | 0 | 0 | 8 | 30.795459700000002 | -85.21500423 | 2020-04-17 23:30:52 | Jackson, 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 | Leon | 12073 | 174 | 0 | 0 | 174 | 30.45955727 | -84.27491114 | 2020-04-17 23:30:52 | Leon, Florida, US |
2020-04-17 | US | Florida | Levy | 12075 | 9 | 0 | 0 | 9 | 29.31829741 | -82.74007147 | 2020-04-17 23:30:52 | Levy, Florida, US |
2020-04-17 | US | Florida | Liberty | 12077 | 2 | 0 | 0 | 2 | 30.23766008 | -84.8829258 | 2020-04-17 23:30:52 | Liberty, Florida, US |
2020-04-17 | US | Florida | Madison | 12079 | 19 | 0 | 0 | 19 | 30.44396917 | -83.47398594 | 2020-04-17 23:30:52 | Madison, Florida, US |
2020-04-17 | US | Florida | Nassau | 12089 | 42 | 0 | 0 | 42 | 30.61037141 | -81.80297522 | 2020-04-17 23:30:52 | Nassau, Florida, US |
2020-04-17 | US | Florida | Okeechobee | 12093 | 5 | 0 | 0 | 5 | 27.386336199999995 | -80.88944347 | 2020-04-17 23:30:52 | Okeechobee, 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-04-17 | US | Florida | Unassigned | 90012 | 4 | 0 | 0 | 4 | 30.86747479 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Florida, US |
2020-04-17 | US | Florida | Union | 12125 | 2 | 0 | 0 | 2 | 30.04412971 | -82.37497443 | 2020-04-17 23:30:52 | Union, Florida, US |
2020-04-17 | US | Florida | Walton | 12131 | 31 | 0 | 0 | 31 | 30.64204028 | -86.16935664 | 2020-04-17 23:30:52 | Walton, Florida, US |
2020-04-17 | US | Florida | Washington | 12133 | 6 | 0 | 0 | 6 | 30.61359259 | -85.66002461 | 2020-04-17 23:30:52 | Washington, Florida, US |
2021-05-29 | US | Florida | Unassigned | 90012 | 3034 | 0 | 0 | 30.86747479 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Florida, US | |
2021-03-07 | US | Florida | Unassigned | 90012 | 3499 | 0 | 0 | 30.86747479 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Florida, US | |
2020-07-23 | US | Florida | Gilchrist | 12041 | 283 | 0 | 0 | 283 | 29.72856978 | -82.79880657 | 2020-07-24 05:30:40 | Gilchrist, Florida, US |
2020-07-23 | US | Florida | Gulf | 12045 | 212 | 0 | 0 | 212 | 29.93543004 | -85.24270990000002 | 2020-07-24 05:30:40 | Gulf, Florida, US |
2020-07-23 | US | Florida | Lafayette | 12067 | 75 | 0 | 0 | 75 | 29.98484137 | -83.18166636 | 2020-07-24 05:30:40 | Lafayette, Florida, US |
2020-07-23 | US | Florida | Unassigned | 90012 | 433 | 0 | 0 | 433 | 30.86747479 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Florida, US |
2020-12-03 | US | Florida | Unassigned | 90012 | 2869 | 0 | 0 | 2869 | 30.86747479 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Florida, US |
2020-10-14 | US | Florida | Unassigned | 90012 | 1906 | 0 | 0 | 1906 | 30.86747479 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Florida, US |
2021-05-25 | US | Florida | Unassigned | 90012 | 3057 | 0 | 0 | 30.86747479 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Florida, US | |
2020-08-04 | US | Florida | Unassigned | 90012 | 638 | 0 | 0 | 638 | 30.86747479 | 0.0 | 2020-08-05 04:34:43 | Unassigned, Florida, US |
2020-05-08 | US | Florida | Calhoun | 12013 | 24 | 0 | 0 | 24 | 30.40666734 | -85.19394153 | 2020-05-09 02:32:35 | Calhoun, Florida, US |
2020-05-08 | US | Florida | Dixie | 12029 | 12 | 0 | 0 | 12 | 29.60631086 | -83.15724673 | 2020-05-09 02:32:35 | Dixie, Florida, US |
2020-05-08 | US | Florida | Franklin | 12037 | 2 | 0 | 0 | 2 | 29.83791238 | -84.82731662 | 2020-05-09 02:32:35 | Franklin, Florida, US |
2020-05-08 | US | Florida | Gadsden | 12039 | 123 | 0 | 0 | 123 | 30.57796289 | -84.61915825 | 2020-05-09 02:32:35 | Gadsden, Florida, US |
2020-05-08 | US | Florida | Gilchrist | 12041 | 6 | 0 | 0 | 6 | 29.72856978 | -82.79880657 | 2020-05-09 02:32:35 | Gilchrist, 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-05-08 | US | Florida | Hamilton | 12047 | 8 | 0 | 0 | 8 | 30.49673973 | -82.94998918 | 2020-05-09 02:32:35 | Hamilton, Florida, US |
2020-05-08 | US | Florida | Hardee | 12049 | 35 | 0 | 0 | 35 | 27.49293939 | -81.80956574 | 2020-05-09 02:32:35 | Hardee, Florida, US |
2020-05-08 | US | Florida | Holmes | 12059 | 10 | 0 | 0 | 10 | 30.86747479 | -85.81319222 | 2020-05-09 02:32:35 | Holmes, Florida, US |
2020-05-08 | US | Florida | Jackson | 12063 | 74 | 0 | 0 | 74 | 30.7954597 | -85.21500423 | 2020-05-09 02:32:35 | Jackson, Florida, US |
2020-05-08 | US | Florida | Lafayette | 12067 | 3 | 0 | 0 | 3 | 29.98484137 | -83.18166636 | 2020-05-09 02:32:35 | Lafayette, Florida, US |
2020-05-08 | US | Florida | Levy | 12075 | 20 | 0 | 0 | 20 | 29.31829741 | -82.74007147 | 2020-05-09 02:32:35 | Levy, Florida, US |
2020-05-08 | US | Florida | Liberty | 12077 | 196 | 0 | 0 | 196 | 30.23766008 | -84.8829258 | 2020-05-09 02:32:35 | Liberty, Florida, US |
2020-05-08 | US | Florida | Okeechobee | 12093 | 23 | 0 | 0 | 23 | 27.386336199999995 | -80.88944347 | 2020-05-09 02:32:35 | Okeechobee, Florida, US |
2020-05-08 | US | Florida | Taylor | 12123 | 3 | 0 | 0 | 3 | 30.04848048 | -83.60445406 | 2020-05-09 02:32:35 | Taylor, Florida, US |
2020-05-08 | US | Florida | Unassigned | 90012 | 33 | 0 | 0 | 33 | 30.86747479 | 0.0 | 2020-05-09 02:32:35 | Unassigned, Florida, US |
2020-05-08 | US | Florida | Union | 12125 | 5 | 0 | 0 | 5 | 30.04412971 | -82.37497443 | 2020-05-09 02:32:35 | Union, Florida, US |
2020-05-08 | US | Florida | Washington | 12133 | 12 | 0 | 0 | 12 | 30.61359259 | -85.66002461 | 2020-05-09 02:32:35 | Washington, Florida, US |
2020-07-19 | US | Florida | Franklin | 12037 | 56 | 0 | 0 | 56 | 29.83791238 | -84.82731662 | 2020-07-20 05:34:40 | Franklin, Florida, US |
2020-07-19 | US | Florida | Gilchrist | 12041 | 217 | 0 | 0 | 217 | 29.72856978 | -82.79880657 | 2020-07-20 05:34:40 | Gilchrist, Florida, US |
2020-07-19 | US | Florida | Gulf | 12045 | 141 | 0 | 0 | 141 | 29.93543004 | -85.24270990000002 | 2020-07-20 05:34:40 | Gulf, Florida, US |
2020-07-19 | US | Florida | Lafayette | 12067 | 73 | 0 | 0 | 73 | 29.98484137 | -83.18166636 | 2020-07-20 05:34:40 | Lafayette, Florida, US |
2020-07-19 | US | Florida | Unassigned | 90012 | 388 | 0 | 0 | 388 | 30.86747479 | 0.0 | 2020-07-20 05:34:40 | Unassigned, Florida, US |
2020-11-18 | US | Florida | Unassigned | 90012 | 2160 | 0 | 0 | 2160 | 30.86747479 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Florida, US |
2020-04-29 | US | Florida | Calhoun | 12013 | 8 | 0 | 0 | 8 | 30.40666734 | -85.19394153 | 2020-04-30 02:32:27 | Calhoun, Florida, US |
2020-04-29 | US | Florida | Dixie | 12029 | 6 | 0 | 0 | 6 | 29.60631086 | -83.15724673 | 2020-04-30 02:32:27 | Dixie, Florida, US |
2020-04-29 | US | Florida | Franklin | 12037 | 2 | 0 | 0 | 2 | 29.83791238 | -84.82731662 | 2020-04-30 02:32:27 | Franklin, Florida, US |
2020-04-29 | US | Florida | Gadsden | 12039 | 94 | 0 | 0 | 94 | 30.57796289 | -84.61915825 | 2020-04-30 02:32:27 | Gadsden, Florida, US |
2020-04-29 | US | Florida | Gilchrist | 12041 | 4 | 0 | 0 | 4 | 29.72856978 | -82.79880657 | 2020-04-30 02:32:27 | Gilchrist, 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 | Hamilton | 12047 | 6 | 0 | 0 | 6 | 30.49673973 | -82.94998918 | 2020-04-30 02:32:27 | Hamilton, Florida, US |
2020-04-29 | US | Florida | Hardee | 12049 | 16 | 0 | 0 | 16 | 27.49293939 | -81.80956574 | 2020-04-30 02:32:27 | Hardee, Florida, US |
2020-04-29 | US | Florida | Holmes | 12059 | 9 | 0 | 0 | 9 | 30.86747479 | -85.81319222 | 2020-04-30 02:32:27 | Holmes, Florida, US |
2020-04-29 | US | Florida | Jackson | 12063 | 14 | 0 | 0 | 14 | 30.795459700000002 | -85.21500423 | 2020-04-30 02:32:27 | Jackson, 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-29 | US | Florida | Levy | 12075 | 18 | 0 | 0 | 18 | 29.31829741 | -82.74007147 | 2020-04-30 02:32:27 | Levy, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;