johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Loreto" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
499 | 499 | 2021-12-02 | Peru | Loreto | 45236 | 4268 | 0 | -4.124847 | -74.424115 | 2021-12-03 04:23:05 | Loreto, Peru | |||
4515 | 4515 | 2021-10-28 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-29 04:22:03 | Loreto, Peru | |||
16523 | 16523 | 2021-09-18 | Peru | Loreto | 44904 | 4168 | 0 | -4.124847 | -74.424115 | 2021-09-19 04:21:34 | Loreto, Peru | |||
24570 | 24570 | 2022-03-20 | Peru | Loreto | 57777 | 4368 | 0 | -4.124847 | -74.424115 | 2022-03-21 04:20:50 | Loreto, Peru | |||
28585 | 28585 | 2021-11-11 | Peru | Loreto | 45145 | 4171 | 0 | -4.124847 | -74.424115 | 2021-11-12 04:22:01 | Loreto, Peru | |||
32584 | 32584 | 2021-08-25 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-08-26 04:21:28 | Loreto, Peru | |||
43877 | 43877 | 2021-11-02 | Peru | Loreto | 45126 | 4176 | 0 | -4.124847 | -74.424115 | 2021-11-03 06:22:09 | Loreto, Peru | |||
63234 | 63234 | 2022-11-12 | Peru | Loreto | 63164 | 4424 | 0 | -4.124847 | -74.424115 | 2022-11-13 04:21:14 | Loreto, Peru | |||
67229 | 67229 | 2021-09-01 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-09-02 04:21:15 | Loreto, Peru | |||
71260 | 71260 | 2022-02-07 | Peru | Loreto | 56903 | 4317 | 0 | -4.124847 | -74.424115 | 2022-02-08 04:21:15 | Loreto, Peru | |||
87294 | 87294 | 2021-11-09 | Peru | Loreto | 45145 | 4171 | 0 | -4.124847 | -74.424115 | 2021-11-10 04:21:38 | Loreto, Peru | |||
91312 | 91312 | 2022-07-23 | Peru | Loreto | 59256 | 4402 | 0 | -4.124847 | -74.424115 | 2022-07-24 04:20:47 | Loreto, Peru | |||
99495 | 99495 | 2022-01-14 | Peru | Loreto | 45486 | 4285 | 0 | -4.124847 | -74.424115 | 2022-01-15 04:21:07 | Loreto, Peru | |||
103494 | 103494 | 2021-08-15 | Peru | Loreto | 44520 | 4141 | 0 | -4.124847 | -74.424115 | 2021-08-16 04:21:31 | Loreto, Peru | |||
114922 | 114922 | 2022-09-06 | Peru | Loreto | 62564 | 4418 | 0 | -4.124847 | -74.424115 | 2022-09-07 04:20:59 | Loreto, Peru | |||
126902 | 126902 | 2022-01-09 | Peru | Loreto | 45486 | 4285 | 0 | -4.124847 | -74.424115 | 2022-01-10 04:22:07 | Loreto, Peru | |||
130922 | 130922 | 2022-10-04 | Peru | Loreto | 62709 | 4424 | 0 | -4.124847 | -74.424115 | 2022-10-05 04:23:06 | Loreto, Peru | |||
138140 | 138140 | 2021-12-04 | Peru | Loreto | 45236 | 4268 | 0 | -4.124847 | -74.424115 | 2021-12-05 04:22:25 | Loreto, Peru | |||
142158 | 142158 | 2022-07-09 | Peru | Loreto | 58069 | 4394 | 0 | -4.124847 | -74.424115 | 2022-07-10 04:20:54 | Loreto, Peru | |||
150153 | 150153 | 2021-11-29 | Peru | Loreto | 45236 | 4268 | 0 | -4.124847 | -74.424115 | 2021-11-30 04:22:53 | Loreto, Peru | |||
158182 | 158182 | 2022-03-29 | Peru | Loreto | 57858 | 4376 | 0 | -4.124847 | -74.424115 | 2022-03-30 04:20:45 | Loreto, Peru | |||
162197 | 162197 | 2021-11-19 | Peru | Loreto | 45196 | 4174 | 0 | -4.124847 | -74.424115 | 2021-11-20 04:22:17 | Loreto, Peru | |||
166215 | 166215 | 2022-06-21 | Peru | Loreto | 58020 | 4393 | 0 | -4.124847 | -74.424115 | 2022-06-22 04:20:54 | Loreto, Peru | |||
178194 | 178194 | 2021-09-02 | Peru | Loreto | 44686 | 4153 | 0 | -4.124847 | -74.424115 | 2021-09-03 04:21:20 | Loreto, Peru | |||
186240 | 186240 | 2022-02-13 | Peru | Loreto | 56903 | 4317 | 0 | -4.124847 | -74.424115 | 2022-02-14 04:20:51 | Loreto, Peru | |||
198431 | 198431 | 2022-10-19 | Peru | Loreto | 62731 | 4422 | 0 | -4.124847 | -74.424115 | 2022-10-20 04:22:59 | Loreto, Peru | |||
218152 | 218152 | 2022-12-26 | Peru | Loreto | 64441 | 4459 | 0 | -4.124847 | -74.424115 | 2022-12-27 04:21:07 | Loreto, Peru | |||
222165 | 222165 | 2022-05-09 | Peru | Loreto | 57977 | 4386 | 0 | -4.124847 | -74.424115 | 2022-05-10 04:20:50 | Loreto, Peru | |||
229397 | 229397 | 2022-05-31 | Peru | Loreto | 58009 | 4389 | 0 | -4.124847 | -74.424115 | 2022-06-01 04:20:55 | Loreto, Peru | |||
233412 | 233412 | 2022-02-11 | Peru | Loreto | 56903 | 4317 | 0 | -4.124847 | -74.424115 | 2022-02-12 04:21:06 | Loreto, Peru | |||
245437 | 245437 | 2021-08-17 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-18 04:21:35 | Loreto, Peru | |||
249451 | 249451 | 2021-09-04 | Peru | Loreto | 44827 | 4163 | 0 | -4.124847 | -74.424115 | 2021-09-05 04:21:33 | Loreto, Peru | |||
253484 | 253484 | 2022-09-08 | Peru | Loreto | 62564 | 4418 | 0 | -4.124847 | -74.424115 | 2022-09-09 04:21:11 | Loreto, Peru | |||
257502 | 257502 | 2022-12-10 | Peru | Loreto | 63667 | 4454 | 0 | -4.124847 | -74.424115 | 2022-12-11 04:20:50 | Loreto, Peru | |||
261702 | 261702 | 2022-03-15 | Peru | Loreto | 57777 | 4368 | 0 | -4.124847 | -74.424115 | 2022-03-16 04:20:50 | Loreto, Peru | |||
276352 | 276352 | 2021-11-03 | Peru | Loreto | 45126 | 4176 | 0 | -4.124847 | -74.424115 | 2021-11-04 04:22:20 | Loreto, Peru | |||
288165 | 288165 | 2021-10-31 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-01 04:22:01 | Loreto, Peru | |||
292185 | 292185 | 2022-11-15 | Peru | Loreto | 63259 | 4436 | 0 | -4.124847 | -74.424115 | 2022-11-16 04:21:09 | Loreto, Peru | |||
304038 | 304038 | 2022-04-16 | Peru | Loreto | 57901 | 4381 | 0 | -4.124847 | -74.424115 | 2022-04-17 04:20:59 | Loreto, Peru | |||
308057 | 308057 | 2022-12-13 | Peru | Loreto | 63667 | 4454 | 0 | -4.124847 | -74.424115 | 2022-12-14 04:21:04 | Loreto, Peru | |||
312073 | 312073 | 2022-11-13 | Peru | Loreto | 63164 | 4424 | 0 | -4.124847 | -74.424115 | 2022-11-14 04:21:09 | Loreto, Peru | |||
316086 | 316086 | 2022-02-12 | Peru | Loreto | 56903 | 4317 | 0 | -4.124847 | -74.424115 | 2022-02-13 04:21:00 | Loreto, Peru | |||
320105 | 320105 | 2022-10-30 | Peru | Loreto | 62867 | 4422 | 0 | -4.124847 | -74.424115 | 2022-10-31 04:21:36 | Loreto, Peru | |||
328079 | 328079 | 2022-12-27 | Peru | Loreto | 64441 | 4459 | 0 | -4.124847 | -74.424115 | 2022-12-28 04:21:04 | Loreto, Peru | |||
336106 | 336106 | 2022-03-18 | Peru | Loreto | 57777 | 4368 | 0 | -4.124847 | -74.424115 | 2022-03-19 04:20:47 | Loreto, Peru | |||
348469 | 348469 | 2022-12-14 | Peru | Loreto | 63976 | 4455 | 0 | -4.124847 | -74.424115 | 2022-12-15 04:20:58 | Loreto, Peru | |||
356496 | 356496 | 2022-03-11 | Peru | Loreto | 57696 | 4365 | 0 | -4.124847 | -74.424115 | 2022-03-12 04:20:50 | Loreto, Peru | |||
360512 | 360512 | 2022-05-07 | Peru | Loreto | 57966 | 4383 | 0 | -4.124847 | -74.424115 | 2022-05-08 04:20:49 | Loreto, Peru | |||
372369 | 372369 | 2022-09-13 | Peru | Loreto | 62610 | 4419 | 0 | -4.124847 | -74.424115 | 2022-09-14 04:20:44 | Loreto, Peru | |||
384396 | 384396 | 2022-09-23 | Peru | Loreto | 62626 | 4422 | 0 | -4.124847 | -74.424115 | 2022-09-24 04:21:40 | Loreto, Peru | |||
396437 | 396437 | 2022-10-07 | Peru | Loreto | 62709 | 4424 | 0 | -4.124847 | -74.424115 | 2022-10-08 04:22:56 | Loreto, Peru | |||
404463 | 404463 | 2021-12-07 | Peru | Loreto | 45245 | 4266 | 0 | -4.124847 | -74.424115 | 2021-12-08 04:22:46 | Loreto, Peru | |||
419508 | 419508 | 2022-09-18 | Peru | Loreto | 62610 | 4419 | 0 | -4.124847 | -74.424115 | 2022-09-19 04:21:49 | Loreto, Peru | |||
423520 | 423520 | 2021-10-10 | Peru | Loreto | 45056 | 4173 | 0 | -4.124847 | -74.424115 | 2021-10-11 04:21:31 | Loreto, Peru | |||
431530 | 431530 | 2022-11-03 | Peru | Loreto | 63029 | 4423 | 0 | -4.124847 | -74.424115 | 2022-11-04 04:22:11 | Loreto, Peru | |||
443524 | 443524 | 2021-10-20 | Peru | Loreto | 45082 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-21 04:21:18 | Loreto, Peru | |||
447540 | 447540 | 2021-11-17 | Peru | Loreto | 45196 | 4174 | 0 | -4.124847 | -74.424115 | 2021-11-18 04:21:33 | Loreto, Peru | |||
451560 | 451560 | 2022-12-21 | Peru | Loreto | 63976 | 4455 | 0 | -4.124847 | -74.424115 | 2022-12-22 04:20:56 | Loreto, Peru | |||
459549 | 459549 | 2022-02-02 | Peru | Loreto | 49581 | 4292 | 0 | -4.124847 | -74.424115 | 2022-02-03 04:21:21 | Loreto, Peru | |||
463566 | 463566 | 2022-05-02 | Peru | Loreto | 57950 | 4385 | 0 | -4.124847 | -74.424115 | 2022-05-03 04:21:00 | Loreto, Peru | |||
467581 | 467581 | 2021-10-07 | Peru | Loreto | 45030 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-08 04:21:25 | Loreto, Peru | |||
475613 | 475613 | 2022-06-26 | Peru | Loreto | 58020 | 4393 | 0 | -4.124847 | -74.424115 | 2022-06-27 04:21:00 | Loreto, Peru | |||
479763 | 479763 | 2022-11-08 | Peru | Loreto | 63164 | 4424 | 0 | -4.124847 | -74.424115 | 2022-11-09 04:21:22 | Loreto, Peru | |||
487793 | 487793 | 2022-11-25 | Peru | Loreto | 63364 | 4437 | 0 | -4.124847 | -74.424115 | 2022-11-26 04:21:11 | Loreto, Peru | |||
491805 | 491805 | 2021-10-14 | Peru | Loreto | 45056 | 4174 | 0 | -4.124847 | -74.424115 | 2021-10-15 04:21:26 | Loreto, Peru | |||
495821 | 495821 | 2021-11-06 | Peru | Loreto | 45129 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-07 04:21:53 | Loreto, Peru | |||
499838 | 499838 | 2022-04-02 | Peru | Loreto | 57858 | 4376 | 0 | -4.124847 | -74.424115 | 2022-04-03 04:20:48 | Loreto, Peru | |||
503857 | 503857 | 2022-12-17 | Peru | Loreto | 63976 | 4455 | 0 | -4.124847 | -74.424115 | 2022-12-18 04:21:03 | Loreto, Peru | |||
507852 | 507852 | 2021-08-14 | Peru | Loreto | 44520 | 4141 | 0 | -4.124847 | -74.424115 | 2021-08-15 04:21:41 | Loreto, Peru | |||
511866 | 511866 | 2021-08-19 | Peru | Loreto | 44614 | 4150 | 0 | -4.124847 | -74.424115 | 2021-08-20 04:21:33 | Loreto, Peru | |||
515901 | 515901 | 2022-10-15 | Peru | Loreto | 62731 | 4422 | 0 | -4.124847 | -74.424115 | 2022-10-16 04:22:39 | Loreto, Peru | |||
534905 | 534905 | 2021-10-27 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-28 04:22:08 | Loreto, Peru | |||
538925 | 538925 | 2022-10-26 | Peru | Loreto | 62867 | 4422 | 0 | -4.124847 | -74.424115 | 2022-10-27 04:22:01 | Loreto, Peru | |||
542941 | 542941 | 2022-12-15 | Peru | Loreto | 63976 | 4455 | 0 | -4.124847 | -74.424115 | 2022-12-16 04:21:01 | Loreto, Peru | |||
550943 | 550943 | 2021-12-08 | Peru | Loreto | 45245 | 4266 | 0 | -4.124847 | -74.424115 | 2021-12-09 04:22:49 | Loreto, Peru | |||
554959 | 554959 | 2022-01-16 | Peru | Loreto | 46244 | 4285 | 0 | -4.124847 | -74.424115 | 2022-01-17 04:21:08 | Loreto, Peru | |||
558977 | 558977 | 2022-06-16 | Peru | Loreto | 58014 | 4396 | 0 | -4.124847 | -74.424115 | 2022-06-17 04:20:56 | Loreto, Peru | |||
567273 | 567273 | 2021-10-29 | Peru | Loreto | 45108 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-30 04:22:03 | Loreto, Peru | |||
575002 | 575002 | 2022-02-25 | Peru | Loreto | 57565 | 4332 | 0 | -4.124847 | -74.424115 | 2022-02-26 04:21:12 | Loreto, Peru | |||
589796 | 589796 | 2021-08-08 | Peru | Loreto | 44394 | 4137 | 0 | -4.124847 | -74.424115 | 2021-08-09 04:21:24 | Loreto, Peru | |||
593829 | 593829 | 2022-07-01 | Peru | Loreto | 58030 | 4396 | 0 | -4.124847 | -74.424115 | 2022-07-02 04:21:16 | Loreto, Peru | |||
597843 | 597843 | 2021-10-19 | Peru | Loreto | 45075 | 4172 | 0 | -4.124847 | -74.424115 | 2021-10-20 04:21:00 | Loreto, Peru | |||
601859 | 601859 | 2021-09-23 | Peru | Loreto | 44934 | 4169 | 0 | -4.124847 | -74.424115 | 2021-09-24 04:21:44 | Loreto, Peru | |||
618035 | 618035 | 2022-11-05 | Peru | Loreto | 63029 | 4423 | 0 | -4.124847 | -74.424115 | 2022-11-06 04:21:24 | Loreto, Peru | |||
622049 | 622049 | 2022-05-22 | Peru | Loreto | 57993 | 4389 | 0 | -4.124847 | -74.424115 | 2022-05-26 04:20:50 | Loreto, Peru | |||
630079 | 630079 | 2022-07-12 | Peru | Loreto | 58276 | 4396 | 0 | -4.124847 | -74.424115 | 2022-07-13 04:20:58 | Loreto, Peru | |||
634093 | 634093 | 2021-10-13 | Peru | Loreto | 45056 | 4174 | 0 | -4.124847 | -74.424115 | 2021-10-14 04:21:29 | Loreto, Peru | |||
642106 | 642106 | 2021-09-07 | Peru | Loreto | 44844 | 4165 | 0 | -4.124847 | -74.424115 | 2021-09-08 04:21:31 | Loreto, Peru | |||
650134 | 650134 | 2021-08-09 | Peru | Loreto | 44394 | 4137 | 0 | -4.124847 | -74.424115 | 2021-08-10 04:21:27 | Loreto, Peru | |||
654165 | 654165 | 2021-10-22 | Peru | Loreto | 45082 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-23 04:21:32 | Loreto, Peru | |||
658484 | 658484 | 2022-05-13 | Peru | Loreto | 57977 | 4386 | 0 | -4.124847 | -74.424115 | 2022-05-14 04:20:48 | Loreto, Peru | |||
670470 | 670470 | 2022-07-21 | Peru | Loreto | 59256 | 4402 | 0 | -4.124847 | -74.424115 | 2022-07-22 04:21:15 | Loreto, Peru | |||
674486 | 674486 | 2022-07-30 | Peru | Loreto | 60926 | 4404 | 0 | -4.124847 | -74.424115 | 2022-07-31 04:21:02 | Loreto, Peru | |||
682510 | 682510 | 2021-10-24 | Peru | Loreto | 45092 | 4175 | 0 | -4.124847 | -74.424115 | 2021-10-25 04:22:31 | Loreto, Peru | |||
686526 | 686526 | 2021-11-13 | Peru | Loreto | 45182 | 4173 | 0 | -4.124847 | -74.424115 | 2021-11-14 04:21:31 | Loreto, Peru | |||
690546 | 690546 | 2022-12-23 | Peru | Loreto | 63976 | 4455 | 0 | -4.124847 | -74.424115 | 2022-12-24 04:21:02 | Loreto, Peru | |||
694559 | 694559 | 2022-03-17 | Peru | Loreto | 57777 | 4368 | 0 | -4.124847 | -74.424115 | 2022-03-18 04:20:55 | Loreto, Peru | |||
698574 | 698574 | 2021-11-04 | Peru | Loreto | 45129 | 4175 | 0 | -4.124847 | -74.424115 | 2021-11-05 04:21:54 | Loreto, Peru | |||
706604 | 706604 | 2021-09-29 | Peru | Loreto | 44966 | 4171 | 0 | -4.124847 | -74.424115 | 2021-09-30 04:21:20 | Loreto, Peru | |||
710623 | 710623 | 2022-11-01 | Peru | Loreto | 63029 | 4423 | 0 | -4.124847 | -74.424115 | 2022-11-02 04:22:09 | 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]);