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 = "Pernambuco" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237624 | 3237624 | 2020-07-10 | Brazil | Pernambuco | 70100 | 5482 | 49483 | 15135 | -8.8137 | -36.9541 | 2020-07-11 04:34:26 | Pernambuco, Brazil | ||
1005609 | 1005609 | 2020-07-09 | Brazil | Pernambuco | 68767 | 5409 | 47881 | 15477 | -8.8137 | -36.9541 | 2020-07-10 04:34:24 | Pernambuco, Brazil | ||
2222825 | 2222825 | 2020-07-08 | Brazil | Pernambuco | 67604 | 5323 | 47881 | 14400 | -8.8137 | -36.9541 | 2020-07-09 04:34:23 | Pernambuco, Brazil | ||
887434 | 887434 | 2020-07-07 | Brazil | Pernambuco | 66151 | 5234 | 46417 | 14500 | -8.8137 | -36.9541 | 2020-07-08 05:33:48 | Pernambuco, Brazil | ||
2684994 | 2684994 | 2020-07-06 | Brazil | Pernambuco | 65642 | 5163 | 46417 | 14062 | -8.8137 | -36.9541 | 2020-07-07 04:34:00 | Pernambuco, Brazil | ||
415459 | 415459 | 2020-07-05 | Brazil | Pernambuco | 65129 | 5143 | 44568 | 15418 | -8.8137 | -36.9541 | 2020-07-06 04:33:57 | Pernambuco, Brazil | ||
530021 | 530021 | 2020-07-04 | Brazil | Pernambuco | 63457 | 5116 | 41925 | 16416 | -8.8137 | -36.9541 | 2020-07-05 04:33:46 | Pernambuco, Brazil | ||
2234682 | 2234682 | 2020-07-03 | Brazil | Pernambuco | 62362 | 5068 | 41925 | 15369 | -8.8137 | -36.9541 | 2020-07-04 04:33:51 | Pernambuco, Brazil | ||
3045476 | 3045476 | 2020-07-02 | Brazil | Pernambuco | 61119 | 4968 | 41925 | 14226 | -8.8137 | -36.9541 | 2020-07-03 04:33:54 | Pernambuco, Brazil | ||
303167 | 303167 | 2020-07-01 | Brazil | Pernambuco | 59705 | 4894 | 41343 | 13468 | -8.8137 | -36.9541 | 2020-07-02 04:33:46 | Pernambuco, Brazil | ||
2974545 | 2974545 | 2020-06-30 | Brazil | Pernambuco | 58858 | 4829 | 40347 | 13682 | -8.8137 | -36.9541 | 2020-07-01 04:33:52 | Pernambuco, Brazil | ||
2633022 | 2633022 | 2020-06-29 | Brazil | Pernambuco | 58476 | 4782 | 39956 | 13738 | -8.8137 | -36.9541 | 2020-06-30 04:33:48 | Pernambuco, Brazil | ||
2306585 | 2306585 | 2020-06-28 | Brazil | Pernambuco | 58107 | 4751 | 39956 | 13400 | -8.8137 | -36.9541 | 2020-06-29 04:33:44 | Pernambuco, Brazil | ||
2039920 | 2039920 | 2020-06-27 | Brazil | Pernambuco | 57089 | 4708 | 38489 | 13892 | -8.8137 | -36.9541 | 2020-06-28 04:34:04 | Pernambuco, Brazil | ||
1136201 | 1136201 | 2020-06-26 | Brazil | Pernambuco | 55804 | 4610 | 38155 | 13039 | -8.8137 | -36.9541 | 2020-06-27 04:33:35 | Pernambuco, Brazil | ||
2625188 | 2625188 | 2020-06-25 | Brazil | Pernambuco | 55136 | 4488 | 36996 | 13652 | -8.8137 | -36.9541 | 2020-06-26 04:33:43 | Pernambuco, Brazil | ||
2700828 | 2700828 | 2020-06-24 | Brazil | Pernambuco | 54022 | 4425 | 36710 | 12887 | -8.8137 | -36.9541 | 2020-06-25 05:26:54 | Pernambuco, Brazil | ||
1522513 | 1522513 | 2020-06-23 | Brazil | Pernambuco | 52831 | 4339 | 35805 | 12687 | -8.8137 | -36.9541 | 2020-06-24 04:33:28 | Pernambuco, Brazil | ||
1510707 | 1510707 | 2020-06-22 | Brazil | Pernambuco | 52494 | 4252 | 33497 | 14745 | -8.8137 | -36.9541 | 2020-06-23 04:33:22 | Pernambuco, Brazil | ||
3249446 | 3249446 | 2020-06-21 | Brazil | Pernambuco | 52113 | 4234 | 33497 | 14382 | -8.8137 | -36.9541 | 2020-06-22 04:33:20 | Pernambuco, Brazil | ||
2438039 | 2438039 | 2020-06-20 | Brazil | Pernambuco | 51118 | 4148 | 33497 | 12075 | -8.8137 | -36.9541 | 2020-06-21 04:33:19 | Pernambuco, Brazil | ||
1691617 | 1691617 | 2020-06-19 | Brazil | Pernambuco | 49720 | 4102 | 30986 | 14632 | -8.8137 | -36.9541 | 2020-06-20 04:33:19 | Pernambuco, Brazil | ||
3682766 | 3682766 | 2020-06-18 | Brazil | Pernambuco | 48626 | 4057 | 30986 | 13583 | -8.8137 | -36.9541 | 2020-06-19 04:33:17 | Pernambuco, Brazil | ||
1195969 | 1195969 | 2020-06-17 | Brazil | Pernambuco | 47446 | 4009 | 30986 | 12451 | -8.8137 | -36.9541 | 2020-06-18 04:33:18 | Pernambuco, Brazil | ||
2386732 | 2386732 | 2020-06-16 | Brazil | Pernambuco | 46427 | 3959 | 30767 | 11701 | -8.8137 | -36.9541 | 2020-06-17 04:33:21 | Pernambuco, Brazil | ||
287295 | 287295 | 2020-06-15 | Brazil | Pernambuco | 45507 | 3886 | 28894 | 12727 | -8.8137 | -36.9541 | 2020-06-16 04:33:09 | Pernambuco, Brazil | ||
1837246 | 1837246 | 2020-06-14 | Brazil | Pernambuco | 45261 | 3855 | 28770 | 12636 | -8.8137 | -36.9541 | 2020-06-15 03:33:14 | Pernambuco, Brazil | ||
3061298 | 3061298 | 2020-06-13 | Brazil | Pernambuco | 44671 | 3784 | 27903 | 12984 | -8.8137 | -36.9541 | 2020-06-14 03:33:15 | Pernambuco, Brazil | ||
737618 | 737618 | 2020-06-12 | Brazil | Pernambuco | 43872 | 3694 | 25794 | 14384 | -8.8137 | -36.9541 | 2020-06-13 03:33:14 | Pernambuco, Brazil | ||
1273588 | 1273588 | 2020-06-11 | Brazil | Pernambuco | 42994 | 3633 | 25794 | 13567 | -8.8137 | -36.9541 | 2020-06-12 05:09:52 | Pernambuco, Brazil | ||
2864030 | 2864030 | 2020-06-10 | Brazil | Pernambuco | 41935 | 3531 | 25569 | 12835 | -8.8137 | -36.9541 | 2020-06-11 03:33:41 | Pernambuco, Brazil | ||
1210860 | 1210860 | 2020-06-09 | Brazil | Pernambuco | 41010 | 3453 | 23723 | 13834 | -8.8137 | -36.9541 | 2020-06-10 04:07:00 | Pernambuco, Brazil | ||
217287 | 217287 | 2020-06-08 | Brazil | Pernambuco | 40705 | 3350 | 23417 | 13938 | -8.8137 | -36.9541 | 2020-06-09 03:33:03 | Pernambuco, Brazil | ||
2800083 | 2800083 | 2020-06-07 | Brazil | Pernambuco | 40242 | 3305 | 0 | 36937 | -8.8137 | -36.9541 | 2020-06-08 03:33:22 | Pernambuco, Brazil | ||
574139 | 574139 | 2020-06-06 | Brazil | Pernambuco | 39361 | 3270 | 0 | 36091 | -8.8137 | -36.9541 | 2020-06-07 03:53:30 | Pernambuco, Brazil | ||
1269836 | 1269836 | 2020-06-05 | Brazil | Pernambuco | 38511 | 3205 | 0 | 35306 | -8.8137 | -36.9541 | 2020-06-06 02:33:00 | Pernambuco, Brazil | ||
1281305 | 1281305 | 2020-06-04 | Brazil | Pernambuco | 37507 | 3134 | 0 | 34373 | -8.8137 | -36.9541 | 2020-06-05 02:33:06 | Pernambuco, Brazil | ||
3866860 | 3866860 | 2020-06-03 | Brazil | Pernambuco | 36463 | 3012 | 0 | 33451 | -8.8137 | -36.9541 | 2020-06-04 02:33:14 | Pernambuco, Brazil | ||
2555902 | 2555902 | 2020-06-02 | Brazil | Pernambuco | 35508 | 2933 | 0 | 32575 | -8.8137 | -36.9541 | 2020-06-03 02:33:13 | Pernambuco, Brazil | ||
805439 | 805439 | 2020-06-01 | Brazil | Pernambuco | 34900 | 2875 | 0 | 32025 | -8.8137 | -36.9541 | 2020-06-02 02:33:08 | Pernambuco, Brazil | ||
1794012 | 1794012 | 2020-05-31 | Brazil | Pernambuco | 34450 | 2807 | 0 | 31643 | -8.8137 | -36.9541 | 2020-06-01 02:32:46 | Pernambuco, Brazil | ||
3638905 | 3638905 | 2020-05-30 | Brazil | Pernambuco | 33427 | 2740 | 0 | 30687 | -8.8137 | -36.9541 | 2020-05-31 02:32:45 | Pernambuco, Brazil | ||
1790446 | 1790446 | 2020-05-29 | Brazil | Pernambuco | 32255 | 2669 | 0 | 29586 | -8.8137 | -36.9541 | 2020-05-30 02:32:48 | Pernambuco, Brazil | ||
2712325 | 2712325 | 2020-05-28 | Brazil | Pernambuco | 30713 | 2566 | 0 | 28147 | -8.8137 | -36.9541 | 2020-05-29 02:32:50 | Pernambuco, Brazil | ||
2548273 | 2548273 | 2020-05-27 | Brazil | Pernambuco | 29919 | 2468 | 0 | 27451 | -8.8137 | -36.9541 | 2020-05-28 02:32:31 | Pernambuco, Brazil | ||
1041236 | 1041236 | 2020-05-26 | Brazil | Pernambuco | 28854 | 2328 | 0 | 26526 | -8.8137 | -36.9541 | 2020-05-27 02:32:31 | Pernambuco, Brazil | ||
1104966 | 1104966 | 2020-05-25 | Brazil | Pernambuco | 28366 | 2248 | 0 | 26118 | -8.8137 | -36.9541 | 2020-05-26 02:32:35 | Pernambuco, Brazil | ||
875646 | 875646 | 2020-05-24 | Brazil | Pernambuco | 27759 | 2200 | 0 | 25559 | -8.8137 | -36.9541 | 2020-05-25 02:32:44 | Pernambuco, Brazil | ||
997837 | 997837 | 2020-05-23 | Brazil | Pernambuco | 26786 | 2144 | 0 | 24642 | -8.8137 | -36.9541 | 2020-05-24 02:32:43 | Pernambuco, Brazil | ||
1864860 | 1864860 | 2020-05-22 | Brazil | Pernambuco | 25760 | 2057 | 0 | 23703 | -8.8137 | -36.9541 | 2020-05-23 02:32:42 | Pernambuco, Brazil | ||
268366 | 268366 | 2020-05-21 | Brazil | Pernambuco | 23911 | 1925 | 0 | 21986 | -8.8137 | -36.9541 | 2020-05-22 02:36:51 | Pernambuco, Brazil | ||
1431949 | 1431949 | 2020-05-20 | Brazil | Pernambuco | 22560 | 1834 | 0 | 20726 | -8.8137 | -36.9541 | 2020-05-21 02:32:48 | Pernambuco, 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]);