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 = "Piaui" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237625 | 3237625 | 2020-07-10 | Brazil | Piaui | 32465 | 914 | 30676 | 0 | -7.7183 | -42.7289 | 2020-07-11 04:34:26 | Piaui, Brazil | ||
1005610 | 1005610 | 2020-07-09 | Brazil | Piaui | 31269 | 896 | 29471 | 0 | -7.7183 | -42.7289 | 2020-07-10 04:34:24 | Piaui, Brazil | ||
2222826 | 2222826 | 2020-07-08 | Brazil | Piaui | 29745 | 884 | 27927 | 0 | -7.7183 | -42.7289 | 2020-07-09 04:34:23 | Piaui, Brazil | ||
887435 | 887435 | 2020-07-07 | Brazil | Piaui | 28411 | 858 | 26642 | 38 | -7.7183 | -42.7289 | 2020-07-08 05:33:48 | Piaui, Brazil | ||
2684995 | 2684995 | 2020-07-06 | Brazil | Piaui | 27514 | 834 | 25771 | 0 | -7.7183 | -42.7289 | 2020-07-07 04:34:00 | Piaui, Brazil | ||
415460 | 415460 | 2020-07-05 | Brazil | Piaui | 26511 | 809 | 24389 | 906 | -7.7183 | -42.7289 | 2020-07-06 04:33:57 | Piaui, Brazil | ||
530022 | 530022 | 2020-07-04 | Brazil | Piaui | 26079 | 784 | 23880 | 919 | -7.7183 | -42.7289 | 2020-07-05 04:33:46 | Piaui, Brazil | ||
2234683 | 2234683 | 2020-07-03 | Brazil | Piaui | 25561 | 762 | 23880 | 0 | -7.7183 | -42.7289 | 2020-07-04 04:33:51 | Piaui, Brazil | ||
3045477 | 3045477 | 2020-07-02 | Brazil | Piaui | 24376 | 726 | 21717 | 893 | -7.7183 | -42.7289 | 2020-07-03 04:33:54 | Piaui, Brazil | ||
303168 | 303168 | 2020-07-01 | Brazil | Piaui | 23307 | 697 | 21717 | 0 | -7.7183 | -42.7289 | 2020-07-02 04:33:46 | Piaui, Brazil | ||
2974546 | 2974546 | 2020-06-30 | Brazil | Piaui | 22059 | 686 | 20479 | 0 | -7.7183 | -42.7289 | 2020-07-01 04:33:52 | Piaui, Brazil | ||
2633023 | 2633023 | 2020-06-29 | Brazil | Piaui | 20422 | 663 | 18878 | 232 | -7.7183 | -42.7289 | 2020-06-30 04:33:48 | Piaui, Brazil | ||
2306586 | 2306586 | 2020-06-28 | Brazil | Piaui | 19753 | 643 | 17648 | 895 | -7.7183 | -42.7289 | 2020-06-29 04:33:44 | Piaui, Brazil | ||
2039921 | 2039921 | 2020-06-27 | Brazil | Piaui | 19158 | 615 | 17648 | 425 | -7.7183 | -42.7289 | 2020-06-28 04:34:04 | Piaui, Brazil | ||
1136202 | 1136202 | 2020-06-26 | Brazil | Piaui | 18665 | 592 | 17194 | 255 | -7.7183 | -42.7289 | 2020-06-27 04:33:35 | Piaui, Brazil | ||
2625189 | 2625189 | 2020-06-25 | Brazil | Piaui | 18023 | 574 | 16570 | 0 | -7.7183 | -42.7289 | 2020-06-26 04:33:43 | Piaui, Brazil | ||
2700829 | 2700829 | 2020-06-24 | Brazil | Piaui | 17080 | 546 | 15675 | 18 | -7.7183 | -42.7289 | 2020-06-25 05:26:54 | Piaui, Brazil | ||
1522514 | 1522514 | 2020-06-23 | Brazil | Piaui | 16227 | 534 | 13925 | 827 | -7.7183 | -42.7289 | 2020-06-24 04:33:28 | Piaui, Brazil | ||
1510708 | 1510708 | 2020-06-22 | Brazil | Piaui | 15269 | 517 | 861 | 13113 | -7.7183 | -42.7289 | 2020-06-23 04:33:22 | Piaui, Brazil | ||
3249447 | 3249447 | 2020-06-21 | Brazil | Piaui | 14476 | 502 | 13192 | 587 | -7.7183 | -42.7289 | 2020-06-22 04:33:20 | Piaui, Brazil | ||
2438040 | 2438040 | 2020-06-20 | Brazil | Piaui | 14264 | 485 | 13029 | 0 | -7.7183 | -42.7289 | 2020-06-21 04:33:19 | Piaui, Brazil | ||
1691618 | 1691618 | 2020-06-19 | Brazil | Piaui | 13813 | 459 | 734 | 11398 | -7.7183 | -42.7289 | 2020-06-20 04:33:19 | Piaui, Brazil | ||
3682767 | 3682767 | 2020-06-18 | Brazil | Piaui | 12567 | 435 | 734 | 10944 | -7.7183 | -42.7289 | 2020-06-19 04:33:17 | Piaui, Brazil | ||
1195970 | 1195970 | 2020-06-17 | Brazil | Piaui | 12099 | 421 | 734 | 10427 | -7.7183 | -42.7289 | 2020-06-18 04:33:18 | Piaui, Brazil | ||
2386733 | 2386733 | 2020-06-16 | Brazil | Piaui | 11559 | 398 | 709 | 9779 | -7.7183 | -42.7289 | 2020-06-17 04:33:21 | Piaui, Brazil | ||
287296 | 287296 | 2020-06-15 | Brazil | Piaui | 10881 | 393 | 709 | 9274 | -7.7183 | -42.7289 | 2020-06-16 04:33:09 | Piaui, Brazil | ||
1837247 | 1837247 | 2020-06-14 | Brazil | Piaui | 10357 | 374 | 696 | 9097 | -7.7183 | -42.7289 | 2020-06-15 03:33:14 | Piaui, Brazil | ||
3061299 | 3061299 | 2020-06-13 | Brazil | Piaui | 10153 | 360 | 681 | 8809 | -7.7183 | -42.7289 | 2020-06-14 03:33:15 | Piaui, Brazil | ||
737619 | 737619 | 2020-06-12 | Brazil | Piaui | 9825 | 335 | 671 | 8349 | -7.7183 | -42.7289 | 2020-06-13 03:33:14 | Piaui, Brazil | ||
1273589 | 1273589 | 2020-06-11 | Brazil | Piaui | 9337 | 317 | 641 | 7883 | -7.7183 | -42.7289 | 2020-06-12 05:09:52 | Piaui, Brazil | ||
2864031 | 2864031 | 2020-06-10 | Brazil | Piaui | 8823 | 299 | 641 | 7435 | -7.7183 | -42.7289 | 2020-06-11 03:33:41 | Piaui, Brazil | ||
1210861 | 1210861 | 2020-06-09 | Brazil | Piaui | 8359 | 283 | 622 | 7040 | -7.7183 | -42.7289 | 2020-06-10 04:07:00 | Piaui, Brazil | ||
217288 | 217288 | 2020-06-08 | Brazil | Piaui | 7927 | 265 | 599 | 6768 | -7.7183 | -42.7289 | 2020-06-09 03:33:03 | Piaui, Brazil | ||
2800084 | 2800084 | 2020-06-07 | Brazil | Piaui | 7621 | 254 | 0 | 7239 | -7.7183 | -42.7289 | 2020-06-08 03:33:22 | Piaui, Brazil | ||
574140 | 574140 | 2020-06-06 | Brazil | Piaui | 7478 | 239 | 0 | 6881 | -7.7183 | -42.7289 | 2020-06-07 03:53:30 | Piaui, Brazil | ||
1269837 | 1269837 | 2020-06-05 | Brazil | Piaui | 7105 | 224 | 0 | 6500 | -7.7183 | -42.7289 | 2020-06-06 02:33:00 | Piaui, Brazil | ||
1281306 | 1281306 | 2020-06-04 | Brazil | Piaui | 6717 | 217 | 0 | 5862 | -7.7183 | -42.7289 | 2020-06-05 02:33:06 | Piaui, Brazil | ||
3866861 | 3866861 | 2020-06-03 | Brazil | Piaui | 6064 | 202 | 0 | 5636 | -7.7183 | -42.7289 | 2020-06-04 02:33:14 | Piaui, Brazil | ||
2555903 | 2555903 | 2020-06-02 | Brazil | Piaui | 5828 | 192 | 0 | 5326 | -7.7183 | -42.7289 | 2020-06-03 02:33:13 | Piaui, Brazil | ||
805440 | 805440 | 2020-06-01 | Brazil | Piaui | 5506 | 180 | 0 | 4951 | -7.7183 | -42.7289 | 2020-06-02 02:33:08 | Piaui, Brazil | ||
1794013 | 1794013 | 2020-05-31 | Brazil | Piaui | 5119 | 168 | 0 | 4770 | -7.7183 | -42.7289 | 2020-06-01 02:32:46 | Piaui, Brazil | ||
3638906 | 3638906 | 2020-05-30 | Brazil | Piaui | 4931 | 161 | 0 | 4588 | -7.7183 | -42.7289 | 2020-05-31 02:32:45 | Piaui, Brazil | ||
1790447 | 1790447 | 2020-05-29 | Brazil | Piaui | 4745 | 157 | 0 | 4357 | -7.7183 | -42.7289 | 2020-05-30 02:32:48 | Piaui, Brazil | ||
2712326 | 2712326 | 2020-05-28 | Brazil | Piaui | 4503 | 146 | 0 | 4105 | -7.7183 | -42.7289 | 2020-05-29 02:32:50 | Piaui, Brazil | ||
2548274 | 2548274 | 2020-05-27 | Brazil | Piaui | 4243 | 138 | 0 | 3832 | -7.7183 | -42.7289 | 2020-05-28 02:32:31 | Piaui, Brazil | ||
1041237 | 1041237 | 2020-05-26 | Brazil | Piaui | 3966 | 134 | 0 | 3601 | -7.7183 | -42.7289 | 2020-05-27 02:32:31 | Piaui, Brazil | ||
1104967 | 1104967 | 2020-05-25 | Brazil | Piaui | 3720 | 119 | 0 | 3440 | -7.7183 | -42.7289 | 2020-05-26 02:32:35 | Piaui, Brazil | ||
875647 | 875647 | 2020-05-24 | Brazil | Piaui | 3550 | 110 | 0 | 3283 | -7.7183 | -42.7289 | 2020-05-25 02:32:44 | Piaui, Brazil | ||
997838 | 997838 | 2020-05-23 | Brazil | Piaui | 3390 | 107 | 0 | 3159 | -7.7183 | -42.7289 | 2020-05-24 02:32:43 | Piaui, Brazil | ||
1864861 | 1864861 | 2020-05-22 | Brazil | Piaui | 3258 | 99 | 0 | 2981 | -7.7183 | -42.7289 | 2020-05-23 02:32:42 | Piaui, Brazil | ||
268367 | 268367 | 2020-05-21 | Brazil | Piaui | 3074 | 93 | 0 | 2761 | -7.7183 | -42.7289 | 2020-05-22 02:36:51 | Piaui, Brazil | ||
1431950 | 1431950 | 2020-05-20 | Brazil | Piaui | 2852 | 91 | 0 | 2550 | -7.7183 | -42.7289 | 2020-05-21 02:32:48 | Piaui, 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]);