johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where active = 17 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3275938 | 3275938 | 2020-05-15 | US | Louisiana | Vernon | 22115 | 19 | 2 | 0 | 17 | 31.10884837 | -93.18153838 | 2020-05-16 02:32:19 | Vernon, Louisiana, US |
1402383 | 1402383 | 2020-05-14 | US | Louisiana | Grant | 22043 | 18 | 1 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-15 02:33:02 | Grant, Louisiana, US |
1404113 | 1404113 | 2020-05-14 | US | Louisiana | Vernon | 22115 | 19 | 2 | 0 | 17 | 31.10884837 | -93.18153838 | 2020-05-15 02:33:02 | Vernon, Louisiana, US |
3845200 | 3845200 | 2020-05-13 | US | Louisiana | Grant | 22043 | 18 | 1 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-14 03:32:28 | Grant, Louisiana, US |
3846929 | 3846929 | 2020-05-13 | US | Louisiana | Vernon | 22115 | 19 | 2 | 0 | 17 | 31.10884837 | -93.18153838 | 2020-05-14 03:32:28 | Vernon, Louisiana, US |
2579408 | 2579408 | 2020-05-12 | US | Louisiana | Grant | 22043 | 18 | 1 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-13 03:32:26 | Grant, Louisiana, US |
3457335 | 3457335 | 2020-05-10 | US | Louisiana | East Carroll | 22035 | 17 | 0 | 0 | 17 | 32.73926954 | -91.23425694 | 2020-05-11 02:32:30 | East Carroll, Louisiana, US |
2896877 | 2896877 | 2020-05-09 | US | Louisiana | East Carroll | 22035 | 17 | 0 | 0 | 17 | 32.73926954 | -91.23425694 | 2020-05-10 02:32:30 | East Carroll, Louisiana, US |
112152 | 112152 | 2020-05-08 | US | Louisiana | Grant | 22043 | 17 | 0 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-09 02:32:35 | Grant, Louisiana, US |
3293598 | 3293598 | 2020-05-07 | US | Louisiana | Grant | 22043 | 17 | 0 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-08 02:32:32 | Grant, Louisiana, US |
2108824 | 2108824 | 2020-05-06 | US | Louisiana | Grant | 22043 | 17 | 0 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-07 02:32:28 | Grant, Louisiana, US |
1929869 | 1929869 | 2020-05-05 | US | Louisiana | Grant | 22043 | 17 | 0 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-06 02:32:31 | Grant, Louisiana, US |
3082735 | 3082735 | 2020-05-04 | US | Louisiana | Grant | 22043 | 17 | 0 | 0 | 17 | 31.59882456 | -92.56124347 | 2020-05-05 02:32:34 | Grant, Louisiana, US |
268958 | 268958 | 2020-04-28 | US | Louisiana | Caldwell | 22021 | 17 | 0 | 0 | 17 | 32.0902519 | -92.11752148 | 2020-04-29 02:32:29 | Caldwell, Louisiana, US |
3586631 | 3586631 | 2020-04-27 | US | Louisiana | Caldwell | 22021 | 17 | 0 | 0 | 17 | 32.0902519 | -92.11752148 | 2020-04-28 02:30:51 | Caldwell, Louisiana, US |
3588491 | 3588491 | 2020-04-27 | US | Louisiana | Red River | 22081 | 22 | 5 | 0 | 17 | 32.09530039 | -93.34213308 | 2020-04-28 02:30:51 | Red River, Louisiana, US |
3589821 | 3589821 | 2020-04-26 | US | Louisiana | Caldwell | 22021 | 17 | 0 | 0 | 17 | 32.0902519 | -92.11752148 | 2020-04-27 02:30:52 | Caldwell, Louisiana, US |
3500177 | 3500177 | 2020-04-25 | US | Louisiana | Caldwell | 22021 | 17 | 0 | 0 | 17 | 32.0902519 | -92.11752148 | 2020-04-26 02:30:51 | Caldwell, Louisiana, US |
1456584 | 1456584 | 2020-04-24 | US | Louisiana | Caldwell | 22021 | 17 | 0 | 0 | 17 | 32.0902519 | -92.11752148 | 2020-04-25 06:30:53 | Caldwell, Louisiana, US |
1457647 | 1457647 | 2020-04-24 | US | Louisiana | LaSalle | 22059 | 17 | 0 | 0 | 17 | 31.67884782 | -92.15907765 | 2020-04-25 06:30:53 | LaSalle, Louisiana, US |
2522179 | 2522179 | 2020-04-23 | US | Louisiana | Caldwell | 22021 | 17 | 0 | 0 | 17 | 32.0902519 | -92.11752148 | 2020-04-24 03:30:50 | Caldwell, Louisiana, US |
2524668 | 2524668 | 2020-04-23 | US | Louisiana | Winn | 22127 | 19 | 2 | 0 | 17 | 31.94449367 | -92.63789413 | 2020-04-24 03:30:50 | Winn, Louisiana, US |
1199111 | 1199111 | 2020-04-22 | US | Louisiana | Winn | 22127 | 19 | 2 | 0 | 17 | 31.94449367 | -92.63789413 | 2020-04-22 23:30:53 | Winn, Louisiana, US |
521534 | 521534 | 2020-04-21 | US | Louisiana | Red River | 22081 | 21 | 4 | 0 | 17 | 32.09530039 | -93.34213308 | 2020-04-21 23:30:50 | Red River, Louisiana, US |
522176 | 522176 | 2020-04-21 | US | Louisiana | Winn | 22127 | 19 | 2 | 0 | 17 | 31.94449367 | -92.63789413 | 2020-04-21 23:30:50 | Winn, Louisiana, US |
2472617 | 2472617 | 2020-04-20 | US | Louisiana | Red River | 22081 | 21 | 4 | 0 | 17 | 32.09530039 | -93.34213308 | 2020-04-20 23:36:47 | Red River, Louisiana, US |
2473258 | 2473258 | 2020-04-20 | US | Louisiana | Winn | 22127 | 19 | 2 | 0 | 17 | 31.94449367 | -92.63789413 | 2020-04-20 23:36:47 | Winn, Louisiana, US |
1384311 | 1384311 | 2020-04-19 | US | Louisiana | Red River | 22081 | 20 | 3 | 0 | 17 | 32.09530039 | -93.34213308 | 2020-04-19 23:41:01 | Red River, Louisiana, US |
1384950 | 1384950 | 2020-04-19 | US | Louisiana | Winn | 22127 | 19 | 2 | 0 | 17 | 31.94449367 | -92.63789413 | 2020-04-19 23:41:01 | Winn, Louisiana, US |
49699 | 49699 | 2020-04-17 | US | Louisiana | St. Helena | 22091 | 18 | 1 | 0 | 17 | 30.82210324 | -90.71013176 | 2020-04-17 23:30:52 | St. Helena, Louisiana, US |
2575915 | 2575915 | 2020-04-12 | US | Louisiana | Concordia | 22029 | 18 | 1 | 0 | 17 | 31.44817835 | -91.63814433 | 2020-04-12 23:18:00 | Concordia, Louisiana, US |
1247809 | 1247809 | 2020-04-10 | US | Louisiana | Catahoula | 22025 | 18 | 1 | 0 | 17 | 31.66778967 | -91.84526385 | 2020-04-10 22:54:07 | Catahoula, Louisiana, US |
588313 | 588313 | 2020-04-05 | US | Louisiana | Pointe Coupee | 22077 | 17 | 0 | 0 | 17 | 30.71409502 | -91.60209535 | 2020-04-05 23:06:45 | Pointe Coupee, Louisiana, US |
1749489 | 1749489 | 2020-04-04 | US | Louisiana | Lincoln | 22061 | 17 | 0 | 0 | 17 | 32.6003154 | -92.6659741 | 4/4/20 23:34 | Lincoln, Louisiana, US |
3739324 | 3739324 | 2020-04-03 | US | Louisiana | Lincoln | 22061 | 17 | 0 | 0 | 17 | 32.6003154 | -92.66597409999999 | 2020-04-03 22:46:37 | Lincoln, Louisiana, US |
3740235 | 3740235 | 2020-04-03 | US | Louisiana | Union | 22111 | 17 | 0 | 0 | 17 | 32.83121059 | -92.3749373 | 2020-04-03 22:46:37 | Union, Louisiana, US |
3740263 | 3740263 | 2020-04-03 | US | Louisiana | Vermilion | 22113 | 18 | 1 | 0 | 17 | 29.83517605 | -92.30292538 | 2020-04-03 22:46:37 | Vermilion, Louisiana, US |
3701397 | 3701397 | 2020-04-02 | US | Louisiana | Webster | 22119 | 19 | 2 | 0 | 17 | 32.70847669 | -93.33121835 | 4/2/20 23:25 | Webster, Louisiana, US |
1869260 | 1869260 | 2020-03-30 | US | Louisiana | Assumption | 22007 | 17 | 0 | 0 | 17 | 29.89946234 | -91.06461642 | 3/30/20 22:52 | Assumption, Louisiana, US |
1871839 | 1871839 | 2020-03-30 | US | Louisiana | St. Martin | 22099 | 20 | 3 | 0 | 17 | 30.13112107 | -91.61403569 | 3/30/20 22:52 | St. Martin, Louisiana, US |
3946034 | 3946034 | 2020-03-28 | US | Louisiana | Plaquemines | 22075 | 19 | 2 | 0 | 17 | 29.42245447 | -89.60322085 | 3/28/20 23:05 | Plaquemines, Louisiana, US |
1130856 | 1130856 | 2020-03-25 | US | Louisiana | Lafourche | 22057 | 18 | 1 | 0 | 17 | 29.52470226 | -90.40976986 | 2020-03-25 23:33:19 | Lafourche, 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]);