johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66,723 rows where province_or_state = "Louisiana" sorted by latitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▲ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1853 | 1853 | 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 | |
1872 | 1872 | 2021-12-02 | US | Louisiana | Unassigned | 90022 | 588 | 0 | 0 | 32.83121059 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Louisiana, US | |
1873 | 1873 | 2021-12-02 | US | Louisiana | Union | 22111 | 4188 | 108 | 0 | 32.83121059 | -92.3749373 | 2021-12-03 04:23:05 | Union, Louisiana, US | |
5868 | 5868 | 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 | |
5887 | 5887 | 2021-10-28 | US | Louisiana | Unassigned | 90022 | 578 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Louisiana, US | |
5888 | 5888 | 2021-10-28 | US | Louisiana | Union | 22111 | 4002 | 105 | 0 | 32.83121059 | -92.3749373 | 2021-10-29 04:22:03 | Union, Louisiana, US | |
9840 | 9840 | 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 |
9859 | 9859 | 2020-10-25 | US | Louisiana | Unassigned | 90022 | 249 | 206 | 0 | 43 | 32.83121059 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Louisiana, US |
9860 | 9860 | 2020-10-25 | US | Louisiana | Union | 22111 | 1104 | 51 | 0 | 1053 | 32.83121059 | -92.3749373 | 2020-10-26 04:25:02 | Union, Louisiana, US |
13853 | 13853 | 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 |
13872 | 13872 | 2021-01-26 | US | Louisiana | Unassigned | 90022 | 412 | 0 | 0 | 412 | 32.83121059 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Louisiana, US |
13873 | 13873 | 2021-01-26 | US | Louisiana | Union | 22111 | 2184 | 71 | 0 | 2113 | 32.83121059 | -92.3749373 | 2021-01-27 05:23:41 | Union, Louisiana, US |
17875 | 17875 | 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 | |
17894 | 17894 | 2021-09-18 | US | Louisiana | Unassigned | 90022 | 530 | 0 | 0 | 32.83121059 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Louisiana, US | |
17895 | 17895 | 2021-09-18 | US | Louisiana | Union | 22111 | 3752 | 95 | 0 | 32.83121059 | -92.3749373 | 2021-09-19 04:21:34 | Union, Louisiana, US | |
21886 | 21886 | 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 | |
21905 | 21905 | 2021-05-28 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Louisiana, US | |
21906 | 21906 | 2021-05-28 | US | Louisiana | Union | 22111 | 2424 | 80 | 0 | 32.83121059 | -92.3749373 | 2021-05-29 04:20:41 | Union, Louisiana, US | |
25924 | 25924 | 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 | |
25943 | 25943 | 2022-03-20 | US | Louisiana | Unassigned | 90022 | 975 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Louisiana, US | |
25944 | 25944 | 2022-03-20 | US | Louisiana | Union | 22111 | 6905 | 130 | 0 | 32.83121059 | -92.3749373 | 2022-03-21 04:20:50 | Union, Louisiana, US | |
29939 | 29939 | 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 | |
29958 | 29958 | 2021-11-11 | US | Louisiana | Unassigned | 90022 | 581 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Louisiana, US | |
29959 | 29959 | 2021-11-11 | US | Louisiana | Union | 22111 | 4052 | 105 | 0 | 32.83121059 | -92.3749373 | 2021-11-12 04:22:01 | Union, Louisiana, US | |
33935 | 33935 | 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 | |
33954 | 33954 | 2021-08-25 | US | Louisiana | Unassigned | 90022 | 464 | 0 | 0 | 32.83121059 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Louisiana, US | |
33955 | 33955 | 2021-08-25 | US | Louisiana | Union | 22111 | 3302 | 90 | 0 | 32.83121059 | -92.3749373 | 2021-08-26 04:21:28 | Union, Louisiana, US | |
37945 | 37945 | 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 | |
37964 | 37964 | 2021-04-12 | US | Louisiana | Unassigned | 90022 | 420 | 0 | 0 | 32.83121059 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Louisiana, US | |
37965 | 37965 | 2021-04-12 | US | Louisiana | Union | 22111 | 2352 | 77 | 0 | 32.83121059 | -92.3749373 | 2021-04-13 04:20:37 | Union, Louisiana, US | |
42790 | 42790 | 2020-04-13 | US | Louisiana | Unassigned | 90022 | 56 | 0 | 0 | 56 | 32.83121059 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Louisiana, US |
42824 | 42824 | 2020-04-13 | US | Louisiana | Union | 22111 | 48 | 3 | 0 | 45 | 32.83121059 | -92.3749373 | 2020-04-13 23:07:54 | Union, Louisiana, US |
45231 | 45231 | 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 | |
45250 | 45250 | 2021-11-02 | US | Louisiana | Unassigned | 90022 | 579 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Louisiana, US | |
45251 | 45251 | 2021-11-02 | US | Louisiana | Union | 22111 | 4019 | 105 | 0 | 32.83121059 | -92.3749373 | 2021-11-03 06:22:09 | Union, Louisiana, US | |
49883 | 49883 | 2020-04-17 | US | Louisiana | Unassigned | 90022 | 56 | 1 | 0 | 55 | 32.83121059 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Louisiana, US |
49919 | 49919 | 2020-04-17 | US | Louisiana | Union | 22111 | 71 | 5 | 0 | 66 | 32.83121059 | -92.3749373 | 2020-04-17 23:30:52 | Union, Louisiana, US |
52307 | 52307 | 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 | |
52326 | 52326 | 2021-05-29 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Louisiana, US | |
52327 | 52327 | 2021-05-29 | US | Louisiana | Union | 22111 | 2424 | 80 | 0 | 32.83121059 | -92.3749373 | 2021-05-30 04:20:55 | Union, Louisiana, US | |
56318 | 56318 | 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 | |
56337 | 56337 | 2021-03-07 | US | Louisiana | Unassigned | 90022 | 419 | 0 | 0 | 32.83121059 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Louisiana, US | |
56338 | 56338 | 2021-03-07 | US | Louisiana | Union | 22111 | 2307 | 76 | 0 | 32.83121059 | -92.3749373 | 2021-03-08 05:24:48 | Union, Louisiana, US | |
60710 | 60710 | 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 |
61412 | 61412 | 2020-07-23 | US | Louisiana | Unassigned | 90022 | 9 | 0 | 0 | 9 | 32.83121059 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Louisiana, US |
61454 | 61454 | 2020-07-23 | US | Louisiana | Union | 22111 | 525 | 31 | 0 | 494 | 32.83121059 | -92.3749373 | 2020-07-24 05:30:40 | Union, Louisiana, US |
64589 | 64589 | 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 | |
64608 | 64608 | 2022-11-12 | US | Louisiana | Unassigned | 90022 | 1161 | 0 | 0 | 32.83121059 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Louisiana, US | |
64609 | 64609 | 2022-11-12 | US | Louisiana | Union | 22111 | 8454 | 142 | 0 | 32.83121059 | -92.3749373 | 2022-11-13 04:21:14 | Union, Louisiana, US | |
68580 | 68580 | 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 | |
68599 | 68599 | 2021-09-01 | US | Louisiana | Unassigned | 90022 | 489 | 0 | 0 | 32.83121059 | 0.0 | 2021-09-02 04:21:15 | Unassigned, Louisiana, US | |
68600 | 68600 | 2021-09-01 | US | Louisiana | Union | 22111 | 3462 | 91 | 0 | 32.83121059 | -92.3749373 | 2021-09-02 04:21:15 | Union, Louisiana, US | |
72614 | 72614 | 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 | |
72633 | 72633 | 2022-02-07 | US | Louisiana | Unassigned | 90022 | 958 | 0 | 0 | 32.83121059 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Louisiana, US | |
72634 | 72634 | 2022-02-07 | US | Louisiana | Union | 22111 | 6679 | 121 | 0 | 32.83121059 | -92.3749373 | 2022-02-08 04:21:15 | Union, Louisiana, US | |
76600 | 76600 | 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 |
76619 | 76619 | 2020-12-03 | US | Louisiana | Unassigned | 90022 | 401 | 0 | 0 | 401 | 32.83121059 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Louisiana, US |
76620 | 76620 | 2020-12-03 | US | Louisiana | Union | 22111 | 1446 | 59 | 0 | 1387 | 32.83121059 | -92.3749373 | 2020-12-04 05:27:27 | Union, Louisiana, US |
80594 | 80594 | 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 |
80613 | 80613 | 2020-10-14 | US | Louisiana | Unassigned | 90022 | 243 | 200 | 0 | 43 | 32.83121059 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Louisiana, US |
80614 | 80614 | 2020-10-14 | US | Louisiana | Union | 22111 | 1042 | 49 | 0 | 993 | 32.83121059 | -92.3749373 | 2020-10-15 04:24:28 | Union, Louisiana, US |
84610 | 84610 | 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 | |
84629 | 84629 | 2021-05-25 | US | Louisiana | Unassigned | 90022 | 409 | 0 | 0 | 32.83121059 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Louisiana, US | |
84630 | 84630 | 2021-05-25 | US | Louisiana | Union | 22111 | 2419 | 80 | 0 | 32.83121059 | -92.3749373 | 2021-05-26 04:20:35 | Union, Louisiana, US | |
88648 | 88648 | 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 | |
88667 | 88667 | 2021-11-09 | US | Louisiana | Unassigned | 90022 | 581 | 0 | 0 | 32.83121059 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Louisiana, US | |
88668 | 88668 | 2021-11-09 | US | Louisiana | Union | 22111 | 4045 | 105 | 0 | 32.83121059 | -92.3749373 | 2021-11-10 04:21:38 | Union, Louisiana, US | |
92666 | 92666 | 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 | |
92685 | 92685 | 2022-07-23 | US | Louisiana | Unassigned | 90022 | 1086 | 0 | 0 | 32.83121059 | 0.0 | 2022-07-24 04:20:47 | Unassigned, Louisiana, US | |
92686 | 92686 | 2022-07-23 | US | Louisiana | Union | 22111 | 7558 | 137 | 0 | 32.83121059 | -92.3749373 | 2022-07-24 04:20:47 | Union, Louisiana, US | |
97037 | 97037 | 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 |
97742 | 97742 | 2020-08-04 | US | Louisiana | Unassigned | 90022 | 218 | 114 | 0 | 104 | 32.83121059 | 0.0 | 2020-08-05 04:34:43 | Unassigned, Louisiana, US |
97783 | 97783 | 2020-08-04 | US | Louisiana | Union | 22111 | 646 | 33 | 0 | 613 | 32.83121059 | -92.3749373 | 2020-08-05 04:34:43 | Union, Louisiana, US |
100849 | 100849 | 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 | |
100868 | 100868 | 2022-01-14 | US | Louisiana | Unassigned | 90022 | 799 | 0 | 0 | 32.83121059 | 0.0 | 2022-01-15 04:21:07 | Unassigned, Louisiana, US | |
100869 | 100869 | 2022-01-14 | US | Louisiana | Union | 22111 | 5228 | 114 | 0 | 32.83121059 | -92.3749373 | 2022-01-15 04:21:07 | Union, Louisiana, US | |
104845 | 104845 | 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 | |
104864 | 104864 | 2021-08-15 | US | Louisiana | Unassigned | 90022 | 429 | 0 | 0 | 32.83121059 | 0.0 | 2021-08-16 04:21:31 | Unassigned, Louisiana, US | |
104865 | 104865 | 2021-08-15 | US | Louisiana | Union | 22111 | 3032 | 88 | 0 | 32.83121059 | -92.3749373 | 2021-08-16 04:21:31 | Union, Louisiana, US | |
108969 | 108969 | 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 | |
108988 | 108988 | 2021-06-19 | US | Louisiana | Unassigned | 90022 | 389 | 0 | 0 | 32.83121059 | 0.0 | 2021-06-20 04:21:48 | Unassigned, Louisiana, US | |
108989 | 108989 | 2021-06-19 | US | Louisiana | Union | 22111 | 2442 | 81 | 0 | 32.83121059 | -92.3749373 | 2021-06-20 04:21:48 | Union, Louisiana, US | |
113801 | 113801 | 2020-05-08 | US | Louisiana | Unassigned | 90022 | 63 | 74 | 0 | 0 | 32.83121059 | 0.0 | 2020-05-09 02:32:35 | Unassigned, Louisiana, US |
113842 | 113842 | 2020-05-08 | US | Louisiana | Union | 22111 | 153 | 8 | 0 | 145 | 32.83121059 | -92.3749373 | 2020-05-09 02:32:35 | Union, Louisiana, US |
116276 | 116276 | 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 | |
116295 | 116295 | 2022-09-06 | US | Louisiana | Unassigned | 90022 | 1144 | 0 | 0 | 32.83121059 | 0.0 | 2022-09-07 04:20:59 | Unassigned, Louisiana, US | |
116296 | 116296 | 2022-09-06 | US | Louisiana | Union | 22111 | 8216 | 141 | 0 | 32.83121059 | -92.3749373 | 2022-09-07 04:20:59 | Union, Louisiana, US | |
121336 | 121336 | 2020-07-19 | US | Louisiana | Unassigned | 90022 | 5 | 110 | 0 | 0 | 32.83121059 | 0.0 | 2020-07-20 05:34:40 | Unassigned, Louisiana, US |
121378 | 121378 | 2020-07-19 | US | Louisiana | Union | 22111 | 499 | 30 | 0 | 469 | 32.83121059 | -92.3749373 | 2020-07-20 05:34:40 | Union, Louisiana, US |
124215 | 124215 | 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 |
124234 | 124234 | 2020-11-18 | US | Louisiana | Unassigned | 90022 | 330 | 0 | 0 | 330 | 32.83121059 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Louisiana, US |
124235 | 124235 | 2020-11-18 | US | Louisiana | Union | 22111 | 1314 | 56 | 0 | 1258 | 32.83121059 | -92.3749373 | 2020-11-19 05:25:23 | Union, Louisiana, US |
128256 | 128256 | 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 | |
128275 | 128275 | 2022-01-09 | US | Louisiana | Unassigned | 90022 | 691 | 0 | 0 | 32.83121059 | 0.0 | 2022-01-10 04:22:07 | Unassigned, Louisiana, US | |
128276 | 128276 | 2022-01-09 | US | Louisiana | Union | 22111 | 4849 | 114 | 0 | 32.83121059 | -92.3749373 | 2022-01-10 04:22:07 | Union, Louisiana, US | |
132277 | 132277 | 2022-10-04 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-09-12 23:21:04 | Out of LA, Louisiana, US | |
132296 | 132296 | 2022-10-04 | US | Louisiana | Unassigned | 90022 | 1152 | 0 | 0 | 32.83121059 | 0.0 | 2022-10-05 04:23:06 | Unassigned, Louisiana, US | |
132297 | 132297 | 2022-10-04 | US | Louisiana | Union | 22111 | 8401 | 142 | 0 | 32.83121059 | -92.3749373 | 2022-10-05 04:23:06 | Union, 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 |
137070 | 137070 | 2020-04-29 | US | Louisiana | Union | 22111 | 114 | 6 | 0 | 108 | 32.83121059 | -92.3749373 | 2020-04-30 02:32:27 | Union, 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]);