johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where active = 48 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3783428 | 3783428 | 2020-10-13 | US | Louisiana | Unassigned | 90022 | 241 | 193 | 0 | 48 | 32.83121059 | 0.0 | 2020-10-14 04:24:05 | Unassigned, Louisiana, US |
441870 | 441870 | 2020-07-26 | US | Louisiana | Tensas | 22107 | 48 | 0 | 0 | 48 | 32.00760749 | -91.32915234 | 2020-07-27 04:35:02 | Tensas, Louisiana, US |
2038804 | 2038804 | 2020-06-27 | US | Louisiana | Red River | 22081 | 56 | 8 | 0 | 48 | 32.09530039 | -93.34213308 | 2020-06-28 04:34:04 | Red River, Louisiana, US |
1135085 | 1135085 | 2020-06-26 | US | Louisiana | Red River | 22081 | 56 | 8 | 0 | 48 | 32.09530039 | -93.34213308 | 2020-06-27 04:33:35 | Red River, Louisiana, US |
3060716 | 3060716 | 2020-06-13 | US | Louisiana | Vernon | 22115 | 51 | 3 | 0 | 48 | 31.10884837 | -93.18153838 | 2020-06-14 03:33:15 | Vernon, Louisiana, US |
1040845 | 1040845 | 2020-05-26 | US | Louisiana | Vermilion | 22113 | 51 | 3 | 0 | 48 | 29.83517605 | -92.30292538 | 2020-05-27 02:32:31 | Vermilion, Louisiana, US |
1104304 | 1104304 | 2020-05-25 | US | Louisiana | St. Helena | 22091 | 49 | 1 | 0 | 48 | 30.82210324 | -90.71013176 | 2020-05-26 02:32:35 | St. Helena, Louisiana, US |
995166 | 995166 | 2020-05-23 | US | Louisiana | Claiborne | 22027 | 58 | 10 | 0 | 48 | 32.82308512 | -92.99526883 | 2020-05-24 02:32:43 | Claiborne, Louisiana, US |
1862191 | 1862191 | 2020-05-22 | US | Louisiana | Claiborne | 22027 | 58 | 10 | 0 | 48 | 32.82308512 | -92.99526883 | 2020-05-23 02:32:42 | Claiborne, Louisiana, US |
265703 | 265703 | 2020-05-21 | US | Louisiana | Claiborne | 22027 | 58 | 10 | 0 | 48 | 32.82308512 | -92.99526883 | 2020-05-22 02:36:51 | Claiborne, Louisiana, US |
1428954 | 1428954 | 2020-05-20 | US | Louisiana | Beauregard | 22011 | 52 | 4 | 0 | 48 | 30.64836518 | -93.34173616 | 2020-05-21 02:32:48 | Beauregard, Louisiana, US |
1429288 | 1429288 | 2020-05-20 | US | Louisiana | Claiborne | 22027 | 58 | 10 | 0 | 48 | 32.82308512 | -92.99526883 | 2020-05-21 02:32:48 | Claiborne, Louisiana, US |
2387254 | 2387254 | 2020-05-19 | US | Louisiana | Beauregard | 22011 | 52 | 4 | 0 | 48 | 30.64836518 | -93.34173616 | 2020-05-20 02:32:19 | Beauregard, Louisiana, US |
2387588 | 2387588 | 2020-05-19 | US | Louisiana | Claiborne | 22027 | 58 | 10 | 0 | 48 | 32.82308512 | -92.99526883 | 2020-05-20 02:32:19 | Claiborne, Louisiana, US |
3257997 | 3257997 | 2020-05-18 | US | Louisiana | Beauregard | 22011 | 52 | 4 | 0 | 48 | 30.64836518 | -93.34173616 | 2020-05-19 02:32:18 | Beauregard, Louisiana, US |
3258330 | 3258330 | 2020-05-18 | US | Louisiana | Claiborne | 22027 | 58 | 10 | 0 | 48 | 32.82308512 | -92.99526883 | 2020-05-19 02:32:18 | Claiborne, Louisiana, US |
3413392 | 3413392 | 2020-05-17 | US | Louisiana | Beauregard | 22011 | 52 | 4 | 0 | 48 | 30.64836518 | -93.34173616 | 2020-05-18 02:32:21 | Beauregard, Louisiana, US |
3413724 | 3413724 | 2020-05-17 | US | Louisiana | Claiborne | 22027 | 58 | 10 | 0 | 48 | 32.82308512 | -92.99526883 | 2020-05-18 02:32:21 | Claiborne, Louisiana, US |
1826960 | 1826960 | 2020-05-16 | US | Louisiana | Claiborne | 22027 | 58 | 10 | 0 | 48 | 32.82308512 | -92.99526883 | 2020-05-17 02:32:32 | Claiborne, Louisiana, US |
3273515 | 3273515 | 2020-05-15 | US | Louisiana | Caldwell | 22021 | 48 | 0 | 0 | 48 | 32.0902519 | -92.11752148 | 2020-05-16 02:32:19 | Caldwell, Louisiana, US |
1401694 | 1401694 | 2020-05-14 | US | Louisiana | Caldwell | 22021 | 48 | 0 | 0 | 48 | 32.0902519 | -92.11752148 | 2020-05-15 02:33:02 | Caldwell, Louisiana, US |
3844511 | 3844511 | 2020-05-13 | US | Louisiana | Caldwell | 22021 | 48 | 0 | 0 | 48 | 32.0902519 | -92.11752148 | 2020-05-14 03:32:28 | Caldwell, Louisiana, US |
2578719 | 2578719 | 2020-05-12 | US | Louisiana | Caldwell | 22021 | 48 | 0 | 0 | 48 | 32.0902519 | -92.11752148 | 2020-05-13 03:32:26 | Caldwell, Louisiana, US |
3328256 | 3328256 | 2020-05-11 | US | Louisiana | Caldwell | 22021 | 48 | 0 | 0 | 48 | 32.0902519 | -92.11752148 | 2020-05-12 03:32:27 | Caldwell, Louisiana, US |
3456871 | 3456871 | 2020-05-10 | US | Louisiana | Caldwell | 22021 | 48 | 0 | 0 | 48 | 32.0902519 | -92.11752148 | 2020-05-11 02:32:30 | Caldwell, Louisiana, US |
2896413 | 2896413 | 2020-05-09 | US | Louisiana | Caldwell | 22021 | 48 | 0 | 0 | 48 | 32.0902519 | -92.11752148 | 2020-05-10 02:32:30 | Caldwell, Louisiana, US |
1183006 | 1183006 | 2020-05-01 | US | Louisiana | Morehouse | 22067 | 52 | 4 | 0 | 48 | 32.81686191 | -91.80421614 | 2020-05-02 02:32:27 | Morehouse, Louisiana, US |
226486 | 226486 | 2020-04-30 | US | Louisiana | Evangeline | 22039 | 49 | 1 | 0 | 48 | 30.72985248 | -92.39915924 | 2020-05-01 02:32:28 | Evangeline, Louisiana, US |
227490 | 227490 | 2020-04-30 | US | Louisiana | Morehouse | 22067 | 52 | 4 | 0 | 48 | 32.81686191 | -91.80421614 | 2020-05-01 02:32:28 | Morehouse, Louisiana, US |
3591689 | 3591689 | 2020-04-26 | US | Louisiana | Richland | 22083 | 48 | 0 | 0 | 48 | 32.41391005 | -91.76634876 | 2020-04-27 02:30:52 | Richland, Louisiana, US |
3502039 | 3502039 | 2020-04-25 | US | Louisiana | Richland | 22083 | 48 | 0 | 0 | 48 | 32.41391005 | -91.76634876 | 2020-04-26 02:30:51 | Richland, Louisiana, US |
417142 | 417142 | 2020-04-18 | US | Louisiana | Jefferson Davis | 22053 | 53 | 5 | 0 | 48 | 30.26896765 | -92.81210004 | 2020-04-18 22:32:47 | Jefferson Davis, Louisiana, US |
41168 | 41168 | 2020-04-13 | US | Louisiana | Franklin | 22041 | 49 | 1 | 0 | 48 | 32.13675181 | -91.67589857 | 2020-04-13 23:07:54 | Franklin, Louisiana, US |
3949752 | 3949752 | 2020-04-09 | US | Louisiana | West Baton Rouge | 22121 | 57 | 9 | 0 | 48 | 30.46058217 | -91.30989571 | 2020-04-09 23:02:37 | West Baton Rouge, Louisiana, US |
3021531 | 3021531 | 2020-04-07 | US | Louisiana | Webster | 22119 | 50 | 2 | 0 | 48 | 32.70847669 | -93.33121835 | 2020-04-07 23:04:49 | Webster, Louisiana, US |
3626887 | 3626887 | 2020-04-06 | US | Louisiana | St. Landry | 22097 | 52 | 4 | 0 | 48 | 30.59724262 | -92.00135806 | 4/6/20 23:22 | St. Landry, Louisiana, US |
3701357 | 3701357 | 2020-04-02 | US | Louisiana | Washington | 22117 | 50 | 2 | 0 | 48 | 30.85288548 | -90.03866652 | 4/2/20 23:25 | Washington, Louisiana, US |
3363396 | 3363396 | 2020-04-01 | US | Louisiana | Iberia | 22045 | 49 | 1 | 0 | 48 | 29.86803617 | -91.75871777 | 2020-04-01 21:58:49 | Iberia, 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]);