johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
69,765 rows where province_or_state = "Alabama" sorted by confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
726 | 726 | 2021-12-02 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
738 | 738 | 2021-12-02 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
4741 | 4741 | 2021-10-28 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
4753 | 4753 | 2021-10-28 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
8719 | 8719 | 2020-10-25 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-26 04:25:02 | Out of AL, Alabama, US |
8731 | 8731 | 2020-10-25 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Alabama, US |
12730 | 12730 | 2021-01-26 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US |
12742 | 12742 | 2021-01-26 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US |
16749 | 16749 | 2021-09-18 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
16761 | 16761 | 2021-09-18 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
20761 | 20761 | 2021-05-28 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
20773 | 20773 | 2021-05-28 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
24797 | 24797 | 2022-03-20 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
24809 | 24809 | 2022-03-20 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
28812 | 28812 | 2021-11-11 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
28824 | 28824 | 2021-11-11 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
32810 | 32810 | 2021-08-25 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
32822 | 32822 | 2021-08-25 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
36820 | 36820 | 2021-04-12 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
36832 | 36832 | 2021-04-12 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
42773 | 42773 | 2020-04-13 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Alabama, US |
44104 | 44104 | 2021-11-02 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
44116 | 44116 | 2021-11-02 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
49866 | 49866 | 2020-04-17 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Alabama, US |
51182 | 51182 | 2021-05-29 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
51194 | 51194 | 2021-05-29 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
55195 | 55195 | 2021-03-07 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
55207 | 55207 | 2021-03-07 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
60706 | 60706 | 2020-07-23 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-07-24 05:30:40 | Out of AL, Alabama, US |
61395 | 61395 | 2020-07-23 | US | Alabama | Unassigned | 90001 | 0 | 40 | 0 | 0 | 34.90171875 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Alabama, US |
63462 | 63462 | 2022-11-12 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
63474 | 63474 | 2022-11-12 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
67455 | 67455 | 2021-09-01 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
67467 | 67467 | 2021-09-01 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
71487 | 71487 | 2022-02-07 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
71499 | 71499 | 2022-02-07 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
75478 | 75478 | 2020-12-03 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-04 05:27:27 | Out of AL, Alabama, US |
75490 | 75490 | 2020-12-03 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Alabama, US |
79475 | 79475 | 2020-10-14 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-15 04:24:28 | Out of AL, Alabama, US |
79487 | 79487 | 2020-10-14 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Alabama, US |
83485 | 83485 | 2021-05-25 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
83497 | 83497 | 2021-05-25 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
87521 | 87521 | 2021-11-09 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
87533 | 87533 | 2021-11-09 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
91539 | 91539 | 2022-07-23 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
91551 | 91551 | 2022-07-23 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
97033 | 97033 | 2020-08-04 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-08-05 04:34:43 | Out of AL, Alabama, US |
97725 | 97725 | 2020-08-04 | US | Alabama | Unassigned | 90001 | 0 | 55 | 0 | 0 | 34.90171875 | 0.0 | 2020-08-05 04:34:43 | Unassigned, Alabama, US |
99722 | 99722 | 2022-01-14 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
99734 | 99734 | 2022-01-14 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
103720 | 103720 | 2021-08-15 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
103732 | 103732 | 2021-08-15 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
107844 | 107844 | 2021-06-19 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
107856 | 107856 | 2021-06-19 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
113784 | 113784 | 2020-05-08 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-05-09 02:32:35 | Unassigned, Alabama, US |
115149 | 115149 | 2022-09-06 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
115161 | 115161 | 2022-09-06 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
120633 | 120633 | 2020-07-19 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-07-20 05:34:40 | Out of AL, Alabama, US |
121319 | 121319 | 2020-07-19 | US | Alabama | Unassigned | 90001 | 0 | 33 | 0 | 0 | 34.90171875 | 0.0 | 2020-07-20 05:34:40 | Unassigned, Alabama, US |
123093 | 123093 | 2020-11-18 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-11-19 05:25:23 | Out of AL, Alabama, US |
123105 | 123105 | 2020-11-18 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Alabama, US |
127129 | 127129 | 2022-01-09 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
127141 | 127141 | 2022-01-09 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
131150 | 131150 | 2022-10-04 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
131162 | 131162 | 2022-10-04 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
137012 | 137012 | 2020-04-29 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-04-30 02:32:27 | Unassigned, Alabama, US |
138367 | 138367 | 2021-12-04 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
138379 | 138379 | 2021-12-04 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
142385 | 142385 | 2022-07-09 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
142397 | 142397 | 2022-07-09 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
146358 | 146358 | 2020-08-15 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-08-16 04:27:42 | Out of AL, Alabama, US |
146370 | 146370 | 2020-08-15 | US | Alabama | Unassigned | 90001 | 0 | 68 | 0 | 0 | 34.90171875 | 0.0 | 2020-08-16 04:27:42 | Unassigned, Alabama, US |
150380 | 150380 | 2021-11-29 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
150392 | 150392 | 2021-11-29 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
154372 | 154372 | 2021-01-08 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US |
154384 | 154384 | 2021-01-08 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US |
158409 | 158409 | 2022-03-29 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
158421 | 158421 | 2022-03-29 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
162424 | 162424 | 2021-11-19 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
162436 | 162436 | 2021-11-19 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
166442 | 166442 | 2022-06-21 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
166454 | 166454 | 2022-06-21 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
170434 | 170434 | 2021-04-16 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
170446 | 170446 | 2021-04-16 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
175946 | 175946 | 2020-07-27 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-07-28 04:58:43 | Out of AL, Alabama, US |
176635 | 176635 | 2020-07-27 | US | Alabama | Unassigned | 90001 | 0 | 45 | 0 | 0 | 34.90171875 | 0.0 | 2020-07-28 04:58:43 | Unassigned, Alabama, US |
178420 | 178420 | 2021-09-02 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
178432 | 178432 | 2021-09-02 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
182430 | 182430 | 2021-02-21 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US |
182442 | 182442 | 2021-02-21 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US |
186467 | 186467 | 2022-02-13 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
186479 | 186479 | 2022-02-13 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
190458 | 190458 | 2021-01-11 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US |
190470 | 190470 | 2021-01-11 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US |
194453 | 194453 | 2020-08-31 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-09-01 04:28:31 | Out of AL, Alabama, US |
194465 | 194465 | 2020-08-31 | US | Alabama | Unassigned | 90001 | 0 | 99 | 0 | 0 | 34.90171875 | 0.0 | 2020-09-01 04:28:31 | Unassigned, Alabama, US |
198659 | 198659 | 2022-10-19 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
198671 | 198671 | 2022-10-19 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
202645 | 202645 | 2020-12-25 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US |
202657 | 202657 | 2020-12-25 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, 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]);