daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66,723 rows where province_or_state = "Louisiana" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-12-03 04:23:05 | Out of LA, Louisiana, US | |
2021-12-02 | US | Louisiana | Unassigned | 90022 | 588 | 0 | 0 | 32.83121059 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Louisiana, US | |
2021-10-28 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-29 04:22:03 | Out of LA, Louisiana, US | |
2021-10-28 | US | Louisiana | Unassigned | 90022 | 578 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Louisiana, US | |
2020-10-25 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2020-10-26 04:25:02 | Out of LA, Louisiana, US |
2021-01-26 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-01-27 05:23:41 | Out of LA, Louisiana, US |
2021-01-26 | US | Louisiana | Unassigned | 90022 | 412 | 0 | 0 | 412 | 32.83121059 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Louisiana, US |
2021-09-18 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-09-19 04:21:34 | Out of LA, Louisiana, US | |
2021-09-18 | US | Louisiana | Unassigned | 90022 | 530 | 0 | 0 | 32.83121059 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Louisiana, US | |
2021-05-28 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-29 04:20:41 | Out of LA, Louisiana, US | |
2021-05-28 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Louisiana, US | |
2022-03-20 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-21 04:20:50 | Out of LA, Louisiana, US | |
2022-03-20 | US | Louisiana | Unassigned | 90022 | 975 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Louisiana, US | |
2021-11-11 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-12 04:22:01 | Out of LA, Louisiana, US | |
2021-11-11 | US | Louisiana | Unassigned | 90022 | 581 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Louisiana, US | |
2021-08-25 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-08-26 04:21:28 | Out of LA, Louisiana, US | |
2021-08-25 | US | Louisiana | Unassigned | 90022 | 464 | 0 | 0 | 32.83121059 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Louisiana, US | |
2021-04-12 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-04-13 04:20:37 | Out of LA, Louisiana, US | |
2021-04-12 | US | Louisiana | Unassigned | 90022 | 420 | 0 | 0 | 32.83121059 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Louisiana, US | |
2020-04-13 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-13 23:07:54 | Caldwell, Louisiana, US |
2020-04-13 | US | Louisiana | Cameron | 22023 | 2 | 0 | 0 | 2 | 29.87592238 | -93.19310676 | 2020-04-13 23:07:54 | Cameron, Louisiana, US |
2020-04-13 | US | Louisiana | East Carroll | 22035 | 1 | 0 | 0 | 1 | 32.73926954 | -91.23425694 | 2020-04-13 23:07:54 | East Carroll, Louisiana, US |
2020-04-13 | US | Louisiana | Evangeline | 22039 | 38 | 0 | 0 | 38 | 30.72985248 | -92.39915924 | 2020-04-13 23:07:54 | Evangeline, Louisiana, US |
2020-04-13 | US | Louisiana | Grant | 22043 | 12 | 0 | 0 | 12 | 31.59882456 | -92.56124347 | 2020-04-13 23:07:54 | Grant, Louisiana, US |
2020-04-13 | US | Louisiana | Jackson | 22049 | 8 | 0 | 0 | 8 | 32.30251776 | -92.55692092 | 2020-04-13 23:07:54 | Jackson, Louisiana, US |
2020-04-13 | US | Louisiana | LaSalle | 13 | 0 | 0 | 13 | 31.67884782 | -92.15907765 | 2020-04-13 23:07:54 | LaSalle, Louisiana, US | |
2020-04-13 | US | Louisiana | Lincoln | 22061 | 39 | 0 | 0 | 39 | 32.6003154 | -92.66597409999999 | 2020-04-13 23:07:54 | Lincoln, Louisiana, US |
2020-04-13 | US | Louisiana | Madison | 22065 | 2 | 0 | 0 | 2 | 32.36918118 | -91.23973355 | 2020-04-13 23:07:54 | Madison, Louisiana, US |
2020-04-13 | US | Louisiana | Natchitoches | 22069 | 41 | 0 | 0 | 41 | 31.72321584 | -93.09816516 | 2020-04-13 23:07:54 | Natchitoches, Louisiana, US |
2020-04-13 | US | Louisiana | Richland | 22083 | 20 | 0 | 0 | 20 | 32.41391005 | -91.76634876 | 2020-04-13 23:07:54 | Richland, Louisiana, US |
2020-04-13 | US | Louisiana | Sabine | 22085 | 9 | 0 | 0 | 9 | 31.56388699 | -93.55433981 | 2020-04-13 23:07:54 | Sabine, Louisiana, US |
2020-04-13 | US | Louisiana | St. Helena | 22091 | 14 | 0 | 0 | 14 | 30.82210324 | -90.71013176 | 2020-04-13 23:07:54 | St. Helena, Louisiana, US |
2020-04-13 | US | Louisiana | Tensas | 22107 | 1 | 0 | 0 | 1 | 32.00760749 | -91.32915234 | 2020-04-13 23:07:54 | Tensas, Louisiana, US |
2020-04-13 | US | Louisiana | Unassigned | 90022 | 56 | 0 | 0 | 56 | 32.83121059 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Louisiana, US |
2020-04-13 | US | Louisiana | Vernon | 22115 | 14 | 0 | 0 | 14 | 31.10884837 | -93.18153838 | 2020-04-13 23:07:54 | Vernon, Louisiana, US |
2020-04-13 | US | Louisiana | West Carroll | 22123 | 4 | 0 | 0 | 4 | 32.78550125 | -91.461201 | 2020-04-13 23:07:54 | West Carroll, Louisiana, US |
2020-04-13 | US | Louisiana | West Feliciana | 22125 | 46 | 0 | 0 | 46 | 30.87882871 | -91.41485379999999 | 2020-04-13 23:07:54 | West Feliciana, Louisiana, US |
2021-11-02 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-03 06:22:09 | Out of LA, Louisiana, US | |
2021-11-02 | US | Louisiana | Unassigned | 90022 | 579 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Louisiana, US | |
2020-04-17 | US | Louisiana | Caldwell | 22021 | 19 | 0 | 0 | 19 | 32.0902519 | -92.11752148 | 2020-04-17 23:30:52 | Caldwell, Louisiana, US |
2020-04-17 | US | Louisiana | Cameron | 22023 | 2 | 0 | 0 | 2 | 29.87592238 | -93.19310676 | 2020-04-17 23:30:52 | Cameron, Louisiana, US |
2020-04-17 | US | Louisiana | East Carroll | 22035 | 1 | 0 | 0 | 1 | 32.73926954 | -91.23425694 | 2020-04-17 23:30:52 | East Carroll, Louisiana, US |
2020-04-17 | US | Louisiana | Evangeline | 22039 | 42 | 0 | 0 | 42 | 30.72985248 | -92.39915924 | 2020-04-17 23:30:52 | Evangeline, Louisiana, US |
2020-04-17 | US | Louisiana | Grant | 22043 | 12 | 0 | 0 | 12 | 31.59882456 | -92.56124347 | 2020-04-17 23:30:52 | Grant, Louisiana, US |
2020-04-17 | US | Louisiana | Jackson | 22049 | 14 | 0 | 0 | 14 | 32.30251776 | -92.55692092 | 2020-04-17 23:30:52 | Jackson, Louisiana, US |
2020-04-17 | US | Louisiana | LaSalle | 22059 | 13 | 0 | 0 | 13 | 31.67884782 | -92.15907765 | 2020-04-17 23:30:52 | LaSalle, Louisiana, US |
2020-04-17 | US | Louisiana | Madison | 22065 | 4 | 0 | 0 | 4 | 32.36918118 | -91.23973355 | 2020-04-17 23:30:52 | Madison, Louisiana, US |
2020-04-17 | US | Louisiana | Richland | 22083 | 27 | 0 | 0 | 27 | 32.41391005 | -91.76634876 | 2020-04-17 23:30:52 | Richland, Louisiana, US |
2020-04-17 | US | Louisiana | Sabine | 22085 | 13 | 0 | 0 | 13 | 31.56388699 | -93.55433981 | 2020-04-17 23:30:52 | Sabine, Louisiana, US |
2020-04-17 | US | Louisiana | Tensas | 22107 | 1 | 0 | 0 | 1 | 32.00760749 | -91.32915234 | 2020-04-17 23:30:52 | Tensas, Louisiana, US |
2020-04-17 | US | Louisiana | West Carroll | 22123 | 4 | 0 | 0 | 4 | 32.78550125 | -91.461201 | 2020-04-17 23:30:52 | West Carroll, Louisiana, US |
2020-04-17 | US | Louisiana | West Feliciana | 22125 | 60 | 0 | 0 | 60 | 30.87882871 | -91.41485379999999 | 2020-04-17 23:30:52 | West Feliciana, Louisiana, US |
2021-05-29 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-30 04:20:55 | Out of LA, Louisiana, US | |
2021-05-29 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Louisiana, US | |
2021-03-07 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-03-08 05:24:48 | Out of LA, Louisiana, US | |
2021-03-07 | US | Louisiana | Unassigned | 90022 | 419 | 0 | 0 | 32.83121059 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Louisiana, US | |
2020-07-23 | US | Louisiana | Cameron | 22023 | 150 | 0 | 0 | 150 | 29.87592238 | -93.19310676 | 2020-07-24 05:30:40 | Cameron, Louisiana, US |
2020-07-23 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2020-07-24 05:30:40 | Out of LA, Louisiana, US |
2020-07-23 | US | Louisiana | Tensas | 22107 | 46 | 0 | 0 | 46 | 32.00760749 | -91.32915234 | 2020-07-24 05:30:40 | Tensas, Louisiana, US |
2020-07-23 | US | Louisiana | Unassigned | 90022 | 9 | 0 | 0 | 9 | 32.83121059 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Louisiana, US |
2022-11-12 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-09-12 23:21:04 | Out of LA, Louisiana, US | |
2022-11-12 | US | Louisiana | Unassigned | 90022 | 1161 | 0 | 0 | 32.83121059 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Louisiana, US | |
2021-09-01 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-09-02 04:21:15 | Out of LA, Louisiana, US | |
2021-09-01 | US | Louisiana | Unassigned | 90022 | 489 | 0 | 0 | 32.83121059 | 0.0 | 2021-09-02 04:21:15 | Unassigned, Louisiana, US | |
2022-02-07 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-02-08 04:21:15 | Out of LA, Louisiana, US | |
2022-02-07 | US | Louisiana | Unassigned | 90022 | 958 | 0 | 0 | 32.83121059 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Louisiana, US | |
2020-12-03 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2020-12-04 05:27:27 | Out of LA, Louisiana, US |
2020-12-03 | US | Louisiana | Unassigned | 90022 | 401 | 0 | 0 | 401 | 32.83121059 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Louisiana, US |
2020-10-14 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2020-10-15 04:24:28 | Out of LA, Louisiana, US |
2021-05-25 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-26 04:20:35 | Out of LA, Louisiana, US | |
2021-05-25 | US | Louisiana | Unassigned | 90022 | 409 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Louisiana, US | |
2021-11-09 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-10 04:21:38 | Out of LA, Louisiana, US | |
2021-11-09 | US | Louisiana | Unassigned | 90022 | 581 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Louisiana, US | |
2022-07-23 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-07-24 04:20:47 | Out of LA, Louisiana, US | |
2022-07-23 | US | Louisiana | Unassigned | 90022 | 1086 | 0 | 0 | 32.83121059 | 0.0 | 2022-07-24 04:20:47 | Unassigned, Louisiana, US | |
2020-08-04 | US | Louisiana | Cameron | 22023 | 167 | 0 | 0 | 167 | 29.87592238 | -93.19310676 | 2020-08-05 04:34:43 | Cameron, Louisiana, US |
2020-08-04 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2020-08-05 04:34:43 | Out of LA, Louisiana, US |
2020-08-04 | US | Louisiana | Tensas | 22107 | 68 | 0 | 0 | 68 | 32.00760749 | -91.32915234 | 2020-08-05 04:34:43 | Tensas, Louisiana, US |
2022-01-14 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-01-15 04:21:07 | Out of LA, Louisiana, US | |
2022-01-14 | US | Louisiana | Unassigned | 90022 | 799 | 0 | 0 | 32.83121059 | 0.0 | 2022-01-15 04:21:07 | Unassigned, Louisiana, US | |
2021-08-15 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-08-16 04:21:31 | Out of LA, Louisiana, US | |
2021-08-15 | US | Louisiana | Unassigned | 90022 | 429 | 0 | 0 | 32.83121059 | 0.0 | 2021-08-16 04:21:31 | Unassigned, Louisiana, US | |
2021-06-19 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-06-20 04:21:48 | Out of LA, Louisiana, US | |
2021-06-19 | US | Louisiana | Unassigned | 90022 | 389 | 0 | 0 | 32.83121059 | 0.0 | 2021-06-20 04:21:48 | Unassigned, Louisiana, US | |
2020-05-08 | US | Louisiana | Caldwell | 22021 | 47 | 0 | 0 | 47 | 32.0902519 | -92.11752148 | 2020-05-09 02:32:35 | Caldwell, Louisiana, US |
2020-05-08 | US | Louisiana | Cameron | 22023 | 3 | 0 | 0 | 3 | 29.87592238 | -93.19310676 | 2020-05-09 02:32:35 | Cameron, Louisiana, US |
2020-05-08 | US | Louisiana | East Carroll | 22035 | 15 | 0 | 0 | 15 | 32.73926954 | -91.23425694 | 2020-05-09 02:32:35 | East Carroll, Louisiana, US |
2020-05-08 | US | Louisiana | Grant | 22043 | 17 | 0 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-09 02:32:35 | Grant, Louisiana, US |
2020-05-08 | US | Louisiana | LaSalle | 22059 | 31 | 0 | 0 | 31 | 31.67884782 | -92.15907765 | 2020-05-09 02:32:35 | LaSalle, Louisiana, US |
2020-05-08 | US | Louisiana | Madison | 22065 | 8 | 0 | 0 | 8 | 32.36918118 | -91.23973355 | 2020-05-09 02:32:35 | Madison, Louisiana, US |
2020-05-08 | US | Louisiana | Tensas | 22107 | 3 | 0 | 0 | 3 | 32.00760749 | -91.32915234 | 2020-05-09 02:32:35 | Tensas, Louisiana, US |
2020-05-08 | US | Louisiana | West Carroll | 22123 | 4 | 0 | 0 | 4 | 32.78550125 | -91.461201 | 2020-05-09 02:32:35 | West Carroll, Louisiana, US |
2022-09-06 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-09-07 04:20:59 | Out of LA, Louisiana, US | |
2022-09-06 | US | Louisiana | Unassigned | 90022 | 1144 | 0 | 0 | 32.83121059 | 0.0 | 2022-09-07 04:20:59 | Unassigned, Louisiana, US | |
2020-07-19 | US | Louisiana | Cameron | 22023 | 123 | 0 | 0 | 123 | 29.87592238 | -93.19310676 | 2020-07-20 05:34:40 | Cameron, Louisiana, US |
2020-07-19 | US | Louisiana | Tensas | 22107 | 40 | 0 | 0 | 40 | 32.00760749 | -91.32915234 | 2020-07-20 05:34:40 | Tensas, Louisiana, US |
2020-11-18 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2020-11-19 05:25:23 | Out of LA, Louisiana, US |
2020-11-18 | US | Louisiana | Unassigned | 90022 | 330 | 0 | 0 | 330 | 32.83121059 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Louisiana, US |
2022-01-09 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-01-10 04:22:07 | Out of LA, Louisiana, US | |
2022-01-09 | US | Louisiana | Unassigned | 90022 | 691 | 0 | 0 | 32.83121059 | 0.0 | 2022-01-10 04:22:07 | Unassigned, Louisiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;