johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where active = 18 and province_or_state = "Louisiana" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3260716 | 3260716 | 2020-05-18 | US | Louisiana | West Carroll | 22123 | 18 | 0 | 0 | 18 | 32.78550125 | -91.461201 | 2020-05-19 02:32:18 | West Carroll, Louisiana, US |
3415988 | 3415988 | 2020-05-17 | US | Louisiana | Vernon | 22115 | 20 | 2 | 0 | 18 | 31.10884837 | -93.18153838 | 2020-05-18 02:32:21 | Vernon, Louisiana, US |
1829222 | 1829222 | 2020-05-16 | US | Louisiana | Vernon | 22115 | 20 | 2 | 0 | 18 | 31.10884837 | -93.18153838 | 2020-05-17 02:32:32 | Vernon, Louisiana, US |
1403001 | 1403001 | 2020-05-14 | US | Louisiana | Madison | 22065 | 18 | 0 | 0 | 18 | 32.36918118 | -91.23973355 | 2020-05-15 02:33:02 | Madison, Louisiana, US |
2580707 | 2580707 | 2020-05-12 | US | Louisiana | Sabine | 22085 | 19 | 1 | 0 | 18 | 31.56388699 | -93.55433981 | 2020-05-13 03:32:26 | Sabine, Louisiana, US |
3328944 | 3328944 | 2020-05-11 | US | Louisiana | Grant | 22043 | 18 | 0 | 0 | 18 | 31.59882456 | -92.56124347 | 2020-05-12 03:32:27 | Grant, Louisiana, US |
3330241 | 3330241 | 2020-05-11 | US | Louisiana | Sabine | 22085 | 19 | 1 | 0 | 18 | 31.56388699 | -93.55433981 | 2020-05-12 03:32:27 | Sabine, Louisiana, US |
3457559 | 3457559 | 2020-05-10 | US | Louisiana | Grant | 22043 | 18 | 0 | 0 | 18 | 31.59882456 | -92.56124347 | 2020-05-11 02:32:30 | Grant, Louisiana, US |
2897101 | 2897101 | 2020-05-09 | US | Louisiana | Grant | 22043 | 18 | 0 | 0 | 18 | 31.59882456 | -92.56124347 | 2020-05-10 02:32:30 | Grant, Louisiana, US |
225985 | 225985 | 2020-04-30 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-05-01 02:32:28 | Caldwell, Louisiana, US |
228281 | 228281 | 2020-04-30 | US | Louisiana | Unassigned | 90022 | 61 | 43 | 0 | 18 | 32.83121059 | 0.0 | 2020-05-01 02:32:28 | Unassigned, Louisiana, US |
134739 | 134739 | 2020-04-29 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-30 02:32:27 | Caldwell, Louisiana, US |
137029 | 137029 | 2020-04-29 | US | Louisiana | Unassigned | 90022 | 61 | 43 | 0 | 18 | 32.83121059 | 0.0 | 2020-04-30 02:32:27 | Unassigned, Louisiana, US |
270825 | 270825 | 2020-04-28 | US | Louisiana | Red River | 22081 | 23 | 5 | 0 | 18 | 32.09530039 | -93.34213308 | 2020-04-29 02:32:29 | Red River, Louisiana, US |
271243 | 271243 | 2020-04-28 | US | Louisiana | Unassigned | 90022 | 61 | 43 | 0 | 18 | 32.83121059 | 0.0 | 2020-04-29 02:32:29 | Unassigned, Louisiana, US |
3591675 | 3591675 | 2020-04-26 | US | Louisiana | Red River | 22081 | 22 | 4 | 0 | 18 | 32.09530039 | -93.34213308 | 2020-04-27 02:30:52 | Red River, Louisiana, US |
3592332 | 3592332 | 2020-04-26 | US | Louisiana | Winn | 22127 | 20 | 2 | 0 | 18 | 31.94449367 | -92.63789413 | 2020-04-27 02:30:52 | Winn, Louisiana, US |
3501241 | 3501241 | 2020-04-25 | US | Louisiana | LaSalle | 22059 | 18 | 0 | 0 | 18 | 31.67884782 | -92.15907765 | 2020-04-26 02:30:51 | LaSalle, Louisiana, US |
3502025 | 3502025 | 2020-04-25 | US | Louisiana | Red River | 22081 | 22 | 4 | 0 | 18 | 32.09530039 | -93.34213308 | 2020-04-26 02:30:51 | Red River, Louisiana, US |
3502681 | 3502681 | 2020-04-25 | US | Louisiana | Winn | 22127 | 20 | 2 | 0 | 18 | 31.94449367 | -92.63789413 | 2020-04-26 02:30:51 | Winn, Louisiana, US |
1458427 | 1458427 | 2020-04-24 | US | Louisiana | Red River | 22081 | 22 | 4 | 0 | 18 | 32.09530039 | -93.34213308 | 2020-04-25 06:30:53 | Red River, Louisiana, US |
1459082 | 1459082 | 2020-04-24 | US | Louisiana | Winn | 22127 | 20 | 2 | 0 | 18 | 31.94449367 | -92.63789413 | 2020-04-25 06:30:53 | Winn, Louisiana, US |
2524017 | 2524017 | 2020-04-23 | US | Louisiana | Red River | 22081 | 22 | 4 | 0 | 18 | 32.09530039 | -93.34213308 | 2020-04-24 03:30:50 | Red River, Louisiana, US |
1198467 | 1198467 | 2020-04-22 | US | Louisiana | Red River | 22081 | 22 | 4 | 0 | 18 | 32.09530039 | -93.34213308 | 2020-04-22 23:30:53 | Red River, Louisiana, US |
1384534 | 1384534 | 2020-04-19 | US | Louisiana | St. Helena | 22091 | 19 | 1 | 0 | 18 | 30.82210324 | -90.71013176 | 2020-04-19 23:41:01 | St. Helena, Louisiana, US |
418226 | 418226 | 2020-04-18 | US | Louisiana | St. Helena | 22091 | 19 | 1 | 0 | 18 | 30.82210324 | -90.71013176 | 2020-04-18 22:32:47 | St. Helena, Louisiana, US |
857598 | 857598 | 2020-04-15 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-15 22:56:51 | Caldwell, Louisiana, US |
3335525 | 3335525 | 2020-04-14 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-14 23:33:31 | Caldwell, Louisiana, US |
3335771 | 3335771 | 2020-04-14 | US | Louisiana | Concordia | 22029 | 19 | 1 | 0 | 18 | 31.44817835 | -91.63814433 | 2020-04-14 23:33:31 | Concordia, Louisiana, US |
40633 | 40633 | 2020-04-13 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-13 23:07:54 | Caldwell, Louisiana, US |
40878 | 40878 | 2020-04-13 | US | Louisiana | Concordia | 22029 | 19 | 1 | 0 | 18 | 31.44817835 | -91.63814433 | 2020-04-13 23:07:54 | Concordia, Louisiana, US |
2575671 | 2575671 | 2020-04-12 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-12 23:18:00 | Caldwell, Louisiana, US |
2564528 | 2564528 | 2020-04-11 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-11 22:45:33 | Caldwell, Louisiana, US |
1247734 | 1247734 | 2020-04-10 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-10 22:54:07 | Caldwell, Louisiana, US |
1249461 | 1249461 | 2020-04-10 | US | Louisiana | Richland | 22083 | 18 | 0 | 0 | 18 | 32.41391005 | -91.76634876 | 2020-04-10 22:54:07 | Richland, Louisiana, US |
3947499 | 3947499 | 2020-04-09 | US | Louisiana | Caldwell | 22021 | 18 | 0 | 0 | 18 | 32.0902519 | -92.11752148 | 2020-04-09 23:02:37 | Caldwell, Louisiana, US |
3021429 | 3021429 | 2020-04-07 | US | Louisiana | Vermilion | 22113 | 19 | 1 | 0 | 18 | 29.83517605 | -92.30292538 | 2020-04-07 23:04:49 | Vermilion, Louisiana, US |
587804 | 587804 | 2020-04-05 | US | Louisiana | Lincoln | 22061 | 18 | 0 | 0 | 18 | 32.6003154 | -92.66597409999999 | 2020-04-05 23:06:45 | Lincoln, Louisiana, US |
1748640 | 1748640 | 2020-04-04 | US | Louisiana | Claiborne | 22027 | 20 | 2 | 0 | 18 | 32.82308512 | -92.99526883 | 4/4/20 23:34 | Claiborne, Louisiana, US |
1750558 | 1750558 | 2020-04-04 | US | Louisiana | West Feliciana | 22125 | 18 | 0 | 0 | 18 | 30.87882871 | -91.4148538 | 4/4/20 23:34 | West Feliciana, Louisiana, US |
3738777 | 3738777 | 2020-04-03 | US | Louisiana | Evangeline | 22039 | 18 | 0 | 0 | 18 | 30.72985248 | -92.39915924 | 2020-04-03 22:46:37 | Evangeline, Louisiana, US |
3701402 | 3701402 | 2020-04-02 | US | Louisiana | West Baton Rouge | 22121 | 19 | 1 | 0 | 18 | 30.46058217 | -91.30989571 | 4/2/20 23:25 | West Baton Rouge, Louisiana, US |
3815560 | 3815560 | 2020-03-31 | US | Louisiana | Unassigned | 22 | 4 | 0 | 18 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Louisiana, US | |
1870497 | 1870497 | 2020-03-30 | US | Louisiana | Iberia | 22045 | 18 | 0 | 0 | 18 | 29.86803617 | -91.75871777 | 3/30/20 22:52 | Iberia, Louisiana, US |
1871928 | 1871928 | 2020-03-30 | US | Louisiana | Tangipahoa | 22105 | 18 | 0 | 0 | 18 | 30.62888673 | -90.40664996 | 3/30/20 22:52 | Tangipahoa, Louisiana, US |
2874694 | 2874694 | 2020-03-29 | US | Louisiana | Plaquemines | 22075 | 20 | 2 | 0 | 18 | 29.42245447 | -89.60322085 | 3/29/20 23:08 | Plaquemines, Louisiana, US |
918070 | 918070 | 2020-03-26 | US | Louisiana | Ouachita | 22073 | 19 | 1 | 0 | 18 | 32.47645559 | -92.15704172 | 2020-03-26 23:48:35 | Ouachita, Louisiana, US |
2907654 | 2907654 | 2020-03-22 | US | Louisiana | East Baton Rouge | 22033 | 18 | 0 | 0 | 18 | 30.53842039 | -91.09777565 | 3/22/20 23:45 | East Baton Rouge, Louisiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);