johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Brazil" and province_or_state = "Alagoas" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237288 | 3237288 | 2020-07-10 | Brazil | Alagoas | 43959 | 1246 | 36343 | 6370 | -9.5713 | -36.782 | 2020-07-11 04:34:26 | Alagoas, Brazil | ||
1005273 | 1005273 | 2020-07-09 | Brazil | Alagoas | 43191 | 1230 | 34309 | 7652 | -9.5713 | -36.782 | 2020-07-10 04:34:24 | Alagoas, Brazil | ||
2222489 | 2222489 | 2020-07-08 | Brazil | Alagoas | 42322 | 1213 | 34309 | 6800 | -9.5713 | -36.782 | 2020-07-09 04:34:23 | Alagoas, Brazil | ||
887098 | 887098 | 2020-07-07 | Brazil | Alagoas | 41524 | 1192 | 33736 | 6596 | -9.5713 | -36.782 | 2020-07-08 05:33:48 | Alagoas, Brazil | ||
2684658 | 2684658 | 2020-07-06 | Brazil | Alagoas | 40569 | 1172 | 32468 | 6929 | -9.5713 | -36.782 | 2020-07-07 04:34:00 | Alagoas, Brazil | ||
415123 | 415123 | 2020-07-05 | Brazil | Alagoas | 39935 | 1153 | 31245 | 7537 | -9.5713 | -36.782 | 2020-07-06 04:33:57 | Alagoas, Brazil | ||
529685 | 529685 | 2020-07-04 | Brazil | Alagoas | 39255 | 1134 | 30181 | 7940 | -9.5713 | -36.782 | 2020-07-05 04:33:46 | Alagoas, Brazil | ||
2234346 | 2234346 | 2020-07-03 | Brazil | Alagoas | 38404 | 1113 | 30181 | 7110 | -9.5713 | -36.782 | 2020-07-04 04:33:51 | Alagoas, Brazil | ||
3045140 | 3045140 | 2020-07-02 | Brazil | Alagoas | 37328 | 1091 | 29185 | 7052 | -9.5713 | -36.782 | 2020-07-03 04:33:54 | Alagoas, Brazil | ||
302831 | 302831 | 2020-07-01 | Brazil | Alagoas | 36819 | 1072 | 28236 | 7511 | -9.5713 | -36.782 | 2020-07-02 04:33:46 | Alagoas, Brazil | ||
2974209 | 2974209 | 2020-06-30 | Brazil | Alagoas | 35962 | 1052 | 27502 | 7408 | -9.5713 | -36.782 | 2020-07-01 04:33:52 | Alagoas, Brazil | ||
2632686 | 2632686 | 2020-06-29 | Brazil | Alagoas | 35117 | 1032 | 25512 | 8573 | -9.5713 | -36.782 | 2020-06-30 04:33:48 | Alagoas, Brazil | ||
2306249 | 2306249 | 2020-06-28 | Brazil | Alagoas | 34312 | 1012 | 25382 | 7918 | -9.5713 | -36.782 | 2020-06-29 04:33:44 | Alagoas, Brazil | ||
2039584 | 2039584 | 2020-06-27 | Brazil | Alagoas | 33521 | 993 | 24796 | 7732 | -9.5713 | -36.782 | 2020-06-28 04:34:04 | Alagoas, Brazil | ||
1135865 | 1135865 | 2020-06-26 | Brazil | Alagoas | 32864 | 975 | 24380 | 7509 | -9.5713 | -36.782 | 2020-06-27 04:33:35 | Alagoas, Brazil | ||
2624852 | 2624852 | 2020-06-25 | Brazil | Alagoas | 32065 | 958 | 23766 | 7341 | -9.5713 | -36.782 | 2020-06-26 04:33:43 | Alagoas, Brazil | ||
2700492 | 2700492 | 2020-06-24 | Brazil | Alagoas | 31230 | 938 | 23185 | 7107 | -9.5713 | -36.782 | 2020-06-25 05:26:54 | Alagoas, Brazil | ||
1522177 | 1522177 | 2020-06-23 | Brazil | Alagoas | 30248 | 920 | 22189 | 7139 | -9.5713 | -36.782 | 2020-06-24 04:33:28 | Alagoas, Brazil | ||
1510371 | 1510371 | 2020-06-22 | Brazil | Alagoas | 29395 | 903 | 21362 | 7130 | -9.5713 | -36.782 | 2020-06-23 04:33:22 | Alagoas, Brazil | ||
3249110 | 3249110 | 2020-06-21 | Brazil | Alagoas | 28657 | 884 | 20320 | 7453 | -9.5713 | -36.782 | 2020-06-22 04:33:20 | Alagoas, Brazil | ||
2437703 | 2437703 | 2020-06-20 | Brazil | Alagoas | 27698 | 866 | 19644 | 6396 | -9.5713 | -36.782 | 2020-06-21 04:33:19 | Alagoas, Brazil | ||
1691281 | 1691281 | 2020-06-19 | Brazil | Alagoas | 26906 | 848 | 19154 | 6904 | -9.5713 | -36.782 | 2020-06-20 04:33:19 | Alagoas, Brazil | ||
3682430 | 3682430 | 2020-06-18 | Brazil | Alagoas | 25633 | 831 | 17941 | 6861 | -9.5713 | -36.782 | 2020-06-19 04:33:17 | Alagoas, Brazil | ||
1195633 | 1195633 | 2020-06-17 | Brazil | Alagoas | 24867 | 811 | 17065 | 6991 | -9.5713 | -36.782 | 2020-06-18 04:33:18 | Alagoas, Brazil | ||
2386396 | 2386396 | 2020-06-16 | Brazil | Alagoas | 23632 | 793 | 16115 | 6724 | -9.5713 | -36.782 | 2020-06-17 04:33:21 | Alagoas, Brazil | ||
286959 | 286959 | 2020-06-15 | Brazil | Alagoas | 22962 | 768 | 15169 | 7025 | -9.5713 | -36.782 | 2020-06-16 04:33:09 | Alagoas, Brazil | ||
1836910 | 1836910 | 2020-06-14 | Brazil | Alagoas | 22199 | 744 | 14261 | 7194 | -9.5713 | -36.782 | 2020-06-15 03:33:14 | Alagoas, Brazil | ||
3060962 | 3060962 | 2020-06-13 | Brazil | Alagoas | 20887 | 723 | 13761 | 6403 | -9.5713 | -36.782 | 2020-06-14 03:33:15 | Alagoas, Brazil | ||
737282 | 737282 | 2020-06-12 | Brazil | Alagoas | 20031 | 701 | 13094 | 6236 | -9.5713 | -36.782 | 2020-06-13 03:33:14 | Alagoas, Brazil | ||
1273252 | 1273252 | 2020-06-11 | Brazil | Alagoas | 19200 | 681 | 12177 | 6342 | -9.5713 | -36.782 | 2020-06-12 05:09:52 | Alagoas, Brazil | ||
2863696 | 2863696 | 2020-06-10 | Brazil | Alagoas | 18176 | 660 | 11220 | 6296 | -9.5713 | -36.782 | 2020-06-11 03:33:41 | Alagoas, Brazil | ||
1210556 | 1210556 | 2020-06-09 | Brazil | Alagoas | 17193 | 640 | 10290 | 6263 | -9.5713 | -36.782 | 2020-06-10 04:07:00 | Alagoas, Brazil | ||
216983 | 216983 | 2020-06-08 | Brazil | Alagoas | 16340 | 622 | 9645 | 5460 | -9.5713 | -36.782 | 2020-06-09 03:33:03 | Alagoas, Brazil | ||
2799780 | 2799780 | 2020-06-07 | Brazil | Alagoas | 15707 | 601 | 0 | 15105 | -9.5713 | -36.782 | 2020-06-08 03:33:22 | Alagoas, Brazil | ||
573836 | 573836 | 2020-06-06 | Brazil | Alagoas | 14818 | 582 | 0 | 14236 | -9.5713 | -36.782 | 2020-06-07 03:53:30 | Alagoas, Brazil | ||
1269533 | 1269533 | 2020-06-05 | Brazil | Alagoas | 13939 | 557 | 0 | 13380 | -9.5713 | -36.782 | 2020-06-06 02:33:00 | Alagoas, Brazil | ||
1281014 | 1281014 | 2020-06-04 | Brazil | Alagoas | 13097 | 531 | 0 | 12566 | -9.5713 | -36.782 | 2020-06-05 02:33:06 | Alagoas, Brazil | ||
3866569 | 3866569 | 2020-06-03 | Brazil | Alagoas | 12407 | 506 | 0 | 11901 | -9.5713 | -36.782 | 2020-06-04 02:33:14 | Alagoas, Brazil | ||
2555612 | 2555612 | 2020-06-02 | Brazil | Alagoas | 11559 | 482 | 0 | 11077 | -9.5713 | -36.782 | 2020-06-03 02:33:13 | Alagoas, Brazil | ||
805148 | 805148 | 2020-06-01 | Brazil | Alagoas | 10837 | 461 | 0 | 10376 | -9.5713 | -36.782 | 2020-06-02 02:33:08 | Alagoas, Brazil | ||
1793792 | 1793792 | 2020-05-31 | Brazil | Alagoas | 10288 | 443 | 0 | 9845 | -9.5713 | -36.782 | 2020-06-01 02:32:46 | Alagoas, Brazil | ||
3638685 | 3638685 | 2020-05-30 | Brazil | Alagoas | 9223 | 424 | 0 | 8799 | -9.5713 | -36.782 | 2020-05-31 02:32:45 | Alagoas, Brazil | ||
1790226 | 1790226 | 2020-05-29 | Brazil | Alagoas | 8619 | 406 | 0 | 8212 | -9.5713 | -36.782 | 2020-05-30 02:32:48 | Alagoas, Brazil | ||
2712106 | 2712106 | 2020-05-28 | Brazil | Alagoas | 8056 | 385 | 0 | 7670 | -9.5713 | -36.782 | 2020-05-29 02:32:50 | Alagoas, Brazil | ||
2548124 | 2548124 | 2020-05-27 | Brazil | Alagoas | 7580 | 368 | 0 | 7212 | -9.5713 | -36.782 | 2020-05-28 02:32:31 | Alagoas, Brazil | ||
1041087 | 1041087 | 2020-05-26 | Brazil | Alagoas | 7058 | 354 | 0 | 6704 | -9.5713 | -36.782 | 2020-05-27 02:32:31 | Alagoas, Brazil | ||
1104817 | 1104817 | 2020-05-25 | Brazil | Alagoas | 6682 | 337 | 0 | 6345 | -9.5713 | -36.782 | 2020-05-26 02:32:35 | Alagoas, Brazil | ||
875497 | 875497 | 2020-05-24 | Brazil | Alagoas | 6214 | 316 | 0 | 5898 | -9.5713 | -36.782 | 2020-05-25 02:32:44 | Alagoas, Brazil | ||
997688 | 997688 | 2020-05-23 | Brazil | Alagoas | 5630 | 301 | 0 | 5329 | -9.5713 | -36.782 | 2020-05-24 02:32:43 | Alagoas, Brazil | ||
1864711 | 1864711 | 2020-05-22 | Brazil | Alagoas | 5302 | 280 | 0 | 5022 | -9.5713 | -36.782 | 2020-05-23 02:32:42 | Alagoas, Brazil | ||
268217 | 268217 | 2020-05-21 | Brazil | Alagoas | 4916 | 262 | 0 | 4654 | -9.5713 | -36.782 | 2020-05-22 02:36:51 | Alagoas, Brazil | ||
1431800 | 1431800 | 2020-05-20 | Brazil | Alagoas | 4437 | 251 | 0 | 4186 | -9.5713 | -36.782 | 2020-05-21 02:32:48 | Alagoas, Brazil |
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]);