johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Peru" and province_or_state = "Loreto" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3070198 | 3070198 | 2021-11-23 | Peru | Loreto | 45208 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-24 04:22:14 | Loreto, Peru | |||
3749296 | 3749296 | 2021-11-22 | Peru | Loreto | 45208 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-23 04:22:39 | Loreto, Peru | |||
1014503 | 1014503 | 2021-11-21 | Peru | Loreto | 45208 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-22 04:22:20 | Loreto, Peru | |||
722667 | 722667 | 2021-11-20 | Peru | Loreto | 45208 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-21 04:22:13 | Loreto, Peru | |||
162197 | 162197 | 2021-11-19 | Peru | Loreto | 45196 | 4174 | 0 | -4.124847 | -74.424115 | 2021-11-20 04:22:17 | Loreto, Peru | |||
3289084 | 3289084 | 2021-11-18 | Peru | Loreto | 45196 | 4174 | 0 | -4.124847 | -74.424115 | 2021-11-19 04:21:40 | Loreto, Peru | |||
447540 | 447540 | 2021-11-17 | Peru | Loreto | 45196 | 4174 | 0 | -4.124847 | -74.424115 | 2021-11-18 04:21:33 | Loreto, Peru | |||
3342790 | 3342790 | 2021-11-16 | Peru | Loreto | 45182 | 4173 | 0 | -4.124847 | -74.424115 | 2021-11-17 04:21:48 | Loreto, Peru | |||
2287626 | 2287626 | 2021-11-15 | Peru | Loreto | 45182 | 4173 | 0 | -4.124847 | -74.424115 | 2021-11-16 04:21:10 | Loreto, Peru | |||
1322400 | 1322400 | 2021-11-14 | Peru | Loreto | 45182 | 4173 | 0 | -4.124847 | -74.424115 | 2021-11-15 04:21:36 | Loreto, Peru | |||
686526 | 686526 | 2021-11-13 | Peru | Loreto | 45182 | 4173 | 0 | -4.124847 | -74.424115 | 2021-11-14 04:21:31 | Loreto, Peru | |||
714635 | 714635 | 2021-11-12 | Peru | Loreto | 45182 | 4173 | 0 | -4.124847 | -74.424115 | 2021-11-13 04:21:38 | Loreto, Peru | |||
28585 | 28585 | 2021-11-11 | Peru | Loreto | 45145 | 4171 | 0 | -4.124847 | -74.424115 | 2021-11-12 04:22:01 | Loreto, Peru | |||
2845024 | 2845024 | 2021-11-10 | Peru | Loreto | 45145 | 4171 | 0 | -4.124847 | -74.424115 | 2021-11-11 04:21:45 | Loreto, Peru | |||
87294 | 87294 | 2021-11-09 | Peru | Loreto | 45145 | 4171 | 0 | -4.124847 | -74.424115 | 2021-11-10 04:21:38 | Loreto, Peru | |||
3639722 | 3639722 | 2021-11-08 | Peru | Loreto | 45145 | 4171 | 0 | -4.124847 | -74.424115 | 2021-11-09 04:21:36 | Loreto, Peru | |||
2000830 | 2000830 | 2021-11-07 | Peru | Loreto | 45145 | 4171 | 0 | -4.124847 | -74.424115 | 2021-11-08 04:21:43 | Loreto, Peru | |||
495821 | 495821 | 2021-11-06 | Peru | Loreto | 45129 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-07 04:21:53 | Loreto, Peru | |||
3121676 | 3121676 | 2021-11-05 | Peru | Loreto | 45129 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-06 04:21:51 | Loreto, Peru | |||
698574 | 698574 | 2021-11-04 | Peru | Loreto | 45129 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-05 04:21:54 | Loreto, Peru | |||
276352 | 276352 | 2021-11-03 | Peru | Loreto | 45126 | 4176 | 0 | -4.124847 | -74.424115 | 2021-11-04 04:22:20 | Loreto, Peru | |||
43877 | 43877 | 2021-11-02 | Peru | Loreto | 45126 | 4176 | 0 | -4.124847 | -74.424115 | 2021-11-03 06:22:09 | Loreto, Peru | |||
3511573 | 3511573 | 2021-11-01 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-02 04:22:03 | Loreto, Peru | |||
288165 | 288165 | 2021-10-31 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-01 04:22:01 | Loreto, Peru | |||
2721171 | 2721171 | 2021-10-30 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-31 04:22:08 | Loreto, Peru | |||
567273 | 567273 | 2021-10-29 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-30 04:22:03 | Loreto, Peru | |||
4515 | 4515 | 2021-10-28 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-29 04:22:03 | Loreto, Peru | |||
534905 | 534905 | 2021-10-27 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-28 04:22:08 | Loreto, Peru | |||
3492342 | 3492342 | 2021-10-26 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-27 04:22:32 | Loreto, Peru | |||
3794064 | 3794064 | 2021-10-25 | Peru | Loreto | 45092 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-26 04:22:09 | Loreto, Peru | |||
682510 | 682510 | 2021-10-24 | Peru | Loreto | 45092 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-25 04:22:31 | Loreto, Peru | |||
770518 | 770518 | 2021-10-23 | Peru | Loreto | 45092 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-24 04:21:22 | Loreto, Peru | |||
654165 | 654165 | 2021-10-22 | Peru | Loreto | 45082 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-23 04:21:32 | Loreto, Peru | |||
2123912 | 2123912 | 2021-10-21 | Peru | Loreto | 45082 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-22 04:21:14 | Loreto, Peru | |||
443524 | 443524 | 2021-10-20 | Peru | Loreto | 45082 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-21 04:21:18 | Loreto, Peru | |||
597843 | 597843 | 2021-10-19 | Peru | Loreto | 45075 | 4172 | 0 | -4.124847 | -74.424115 | 2021-10-20 04:21:00 | Loreto, Peru | |||
2044020 | 2044020 | 2021-10-18 | Peru | Loreto | 45075 | 4172 | 0 | -4.124847 | -74.424115 | 2021-10-19 04:20:54 | Loreto, Peru | |||
1909381 | 1909381 | 2021-10-17 | Peru | Loreto | 45075 | 4172 | 0 | -4.124847 | -74.424115 | 2021-10-18 04:21:10 | Loreto, Peru | |||
934970 | 934970 | 2021-10-16 | Peru | Loreto | 45071 | 4174 | 0 | -4.124847 | -74.424115 | 2021-10-17 04:21:29 | Loreto, Peru | |||
2943525 | 2943525 | 2021-10-15 | Peru | Loreto | 45071 | 4174 | 0 | -4.124847 | -74.424115 | 2021-10-16 04:21:15 | Loreto, Peru | |||
491805 | 491805 | 2021-10-14 | Peru | Loreto | 45056 | 4174 | 0 | -4.124847 | -74.424115 | 2021-10-15 04:21:26 | Loreto, Peru | |||
634093 | 634093 | 2021-10-13 | Peru | Loreto | 45056 | 4174 | 0 | -4.124847 | -74.424115 | 2021-10-14 04:21:29 | Loreto, Peru | |||
1491771 | 1491771 | 2021-10-12 | Peru | Loreto | 45056 | 4174 | 0 | -4.124847 | -74.424115 | 2021-10-13 04:20:51 | Loreto, Peru | |||
3007504 | 3007504 | 2021-10-11 | Peru | Loreto | 45056 | 4173 | 0 | -4.124847 | -74.424115 | 2021-10-12 04:21:09 | Loreto, Peru | |||
423520 | 423520 | 2021-10-10 | Peru | Loreto | 45056 | 4173 | 0 | -4.124847 | -74.424115 | 2021-10-11 04:21:31 | Loreto, Peru | |||
2876377 | 2876377 | 2021-10-09 | Peru | Loreto | 45053 | 4172 | 0 | -4.124847 | -74.424115 | 2021-10-10 04:21:38 | Loreto, Peru | |||
2959543 | 2959543 | 2021-10-08 | Peru | Loreto | 45030 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-09 04:21:34 | Loreto, Peru | |||
467581 | 467581 | 2021-10-07 | Peru | Loreto | 45030 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-08 04:21:25 | Loreto, Peru | |||
2458961 | 2458961 | 2021-10-06 | Peru | Loreto | 45025 | 4173 | 0 | -4.124847 | -74.424115 | 2021-10-07 04:21:36 | Loreto, Peru | |||
3832655 | 3832655 | 2021-10-05 | Peru | Loreto | 45025 | 4173 | 0 | -4.124847 | -74.424115 | 2021-10-06 04:21:33 | Loreto, Peru | |||
987148 | 987148 | 2021-10-04 | Peru | Loreto | 45025 | 4173 | 0 | -4.124847 | -74.424115 | 2021-10-05 04:21:27 | Loreto, Peru | |||
1274458 | 1274458 | 2021-10-03 | Peru | Loreto | 45019 | 4170 | 0 | -4.124847 | -74.424115 | 2021-10-04 04:21:31 | Loreto, Peru | |||
3928211 | 3928211 | 2021-10-02 | Peru | Loreto | 45019 | 4170 | 0 | -4.124847 | -74.424115 | 2021-10-03 04:21:24 | Loreto, Peru | |||
2132191 | 2132191 | 2021-10-01 | Peru | Loreto | 45008 | 4169 | 0 | -4.124847 | -74.424115 | 2021-10-02 04:21:25 | Loreto, Peru | |||
2773148 | 2773148 | 2021-09-30 | Peru | Loreto | 45008 | 4169 | 0 | -4.124847 | -74.424115 | 2021-10-01 04:21:35 | Loreto, Peru | |||
706604 | 706604 | 2021-09-29 | Peru | Loreto | 44966 | 4171 | 0 | -4.124847 | -74.424115 | 2021-09-30 04:21:20 | Loreto, Peru | |||
1334446 | 1334446 | 2021-09-28 | Peru | Loreto | 44966 | 4171 | 0 | -4.124847 | -74.424115 | 2021-09-29 04:21:45 | Loreto, Peru | |||
1235815 | 1235815 | 2021-09-27 | Peru | Loreto | 44966 | 4171 | 0 | -4.124847 | -74.424115 | 2021-09-28 04:21:28 | Loreto, Peru | |||
2076116 | 2076116 | 2021-09-26 | Peru | Loreto | 44959 | 4170 | 0 | -4.124847 | -74.424115 | 2021-09-27 04:21:16 | Loreto, Peru | |||
1724668 | 1724668 | 2021-09-25 | Peru | Loreto | 44959 | 4170 | 0 | -4.124847 | -74.424115 | 2021-09-26 04:21:29 | Loreto, Peru | |||
1921388 | 1921388 | 2021-09-24 | Peru | Loreto | 44940 | 4168 | 0 | -4.124847 | -74.424115 | 2021-09-25 04:21:31 | Loreto, Peru | |||
601859 | 601859 | 2021-09-23 | Peru | Loreto | 44934 | 4169 | 0 | -4.124847 | -74.424115 | 2021-09-24 04:21:44 | Loreto, Peru | |||
3011503 | 3011503 | 2021-09-22 | Peru | Loreto | 44916 | 4169 | 0 | -4.124847 | -74.424115 | 2021-09-23 04:21:43 | Loreto, Peru | |||
3757641 | 3757641 | 2021-09-21 | Peru | Loreto | 44916 | 4169 | 0 | -4.124847 | -74.424115 | 2021-09-22 04:21:45 | Loreto, Peru | |||
809744 | 809744 | 2021-09-20 | Peru | Loreto | 44912 | 4168 | 0 | -4.124847 | -74.424115 | 2021-09-21 04:21:26 | Loreto, Peru | |||
1814943 | 1814943 | 2021-09-19 | Peru | Loreto | 44912 | 4168 | 0 | -4.124847 | -74.424115 | 2021-09-20 04:21:22 | Loreto, Peru | |||
16523 | 16523 | 2021-09-18 | Peru | Loreto | 44904 | 4168 | 0 | -4.124847 | -74.424115 | 2021-09-19 04:21:34 | Loreto, Peru | |||
2618208 | 2618208 | 2021-09-17 | Peru | Loreto | 44877 | 4167 | 0 | -4.124847 | -74.424115 | 2021-09-18 04:21:24 | Loreto, Peru | |||
2808916 | 2808916 | 2021-09-16 | Peru | Loreto | 44877 | 4167 | 0 | -4.124847 | -74.424115 | 2021-09-17 04:21:46 | Loreto, Peru | |||
1374661 | 1374661 | 2021-09-15 | Peru | Loreto | 44877 | 4167 | 0 | -4.124847 | -74.424115 | 2021-09-16 04:22:19 | Loreto, Peru | |||
2462960 | 2462960 | 2021-09-14 | Peru | Loreto | 44865 | 4167 | 0 | -4.124847 | -74.424115 | 2021-09-15 03:22:37 | Loreto, Peru | |||
1385799 | 1385799 | 2021-09-13 | Peru | Loreto | 44865 | 4167 | 0 | -4.124847 | -74.424115 | 2021-09-14 04:21:41 | Loreto, Peru | |||
1885168 | 1885168 | 2021-09-12 | Peru | Loreto | 44864 | 4164 | 0 | -4.124847 | -74.424115 | 2021-09-13 04:21:15 | Loreto, Peru | |||
3806071 | 3806071 | 2021-09-11 | Peru | Loreto | 44854 | 4164 | 0 | -4.124847 | -74.424115 | 2021-09-12 04:21:13 | Loreto, Peru | |||
3449011 | 3449011 | 2021-09-10 | Peru | Loreto | 44854 | 4164 | 0 | -4.124847 | -74.424115 | 2021-09-11 04:21:30 | Loreto, Peru | |||
1262957 | 1262957 | 2021-09-09 | Peru | Loreto | 44854 | 4164 | 0 | -4.124847 | -74.424115 | 2021-09-10 04:21:20 | Loreto, Peru | |||
2279327 | 2279327 | 2021-09-08 | Peru | Loreto | 44844 | 4165 | 0 | -4.124847 | -74.424115 | 2021-09-09 04:21:27 | Loreto, Peru | |||
642106 | 642106 | 2021-09-07 | Peru | Loreto | 44844 | 4165 | 0 | -4.124847 | -74.424115 | 2021-09-08 04:21:31 | Loreto, Peru | |||
3194169 | 3194169 | 2021-09-06 | Peru | Loreto | 44842 | 4165 | 0 | -4.124847 | -74.424115 | 2021-09-07 04:21:35 | Loreto, Peru | |||
3281037 | 3281037 | 2021-09-05 | Peru | Loreto | 44842 | 4165 | 0 | -4.124847 | -74.424115 | 2021-09-06 04:21:22 | Loreto, Peru | |||
249451 | 249451 | 2021-09-04 | Peru | Loreto | 44827 | 4163 | 0 | -4.124847 | -74.424115 | 2021-09-05 04:21:33 | Loreto, Peru | |||
3974732 | 3974732 | 2021-09-03 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-09-04 04:21:28 | Loreto, Peru | |||
178194 | 178194 | 2021-09-02 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-09-03 04:21:20 | Loreto, Peru | |||
67229 | 67229 | 2021-09-01 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-09-02 04:21:15 | Loreto, Peru | |||
2068071 | 2068071 | 2021-08-31 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-09-01 04:21:38 | Loreto, Peru | |||
1775525 | 1775525 | 2021-08-30 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-31 04:21:46 | Loreto, Peru | |||
3892099 | 3892099 | 2021-08-29 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-30 04:21:23 | Loreto, Peru | |||
2793202 | 2793202 | 2021-08-28 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-29 04:21:14 | Loreto, Peru | |||
2923361 | 2923361 | 2021-08-27 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-28 04:21:28 | Loreto, Peru | |||
1596375 | 1596375 | 2021-08-26 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-27 04:21:37 | Loreto, Peru | |||
32584 | 32584 | 2021-08-25 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-26 04:21:28 | Loreto, Peru | |||
3105623 | 3105623 | 2021-08-24 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-25 04:21:41 | Loreto, Peru | |||
3165794 | 3165794 | 2021-08-23 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-24 04:21:19 | Loreto, Peru | |||
2175721 | 2175721 | 2021-08-22 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-23 04:21:27 | Loreto, Peru | |||
3555817 | 3555817 | 2021-08-21 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-22 04:21:29 | Loreto, Peru | |||
1854159 | 1854159 | 2021-08-20 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-21 04:21:38 | Loreto, Peru | |||
511866 | 511866 | 2021-08-19 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-20 04:21:33 | Loreto, Peru | |||
2518345 | 2518345 | 2021-08-18 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-19 04:21:15 | Loreto, Peru | |||
245437 | 245437 | 2021-08-17 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-18 04:21:35 | Loreto, Peru | |||
1604400 | 1604400 | 2021-08-16 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-17 04:21:49 | Loreto, Peru |
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]);