johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Amazonas" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146 | 146 | 2021-12-02 | Colombia | Amazonas | 6914 | 257 | 0 | -1.4429 | -71.5724 | 2021-12-03 04:23:05 | Amazonas, Colombia | |||
4162 | 4162 | 2021-10-28 | Colombia | Amazonas | 6837 | 256 | 0 | -1.4429 | -71.5724 | 2021-10-29 04:22:03 | Amazonas, Colombia | |||
16187 | 16187 | 2021-09-18 | Colombia | Amazonas | 6818 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-19 04:21:34 | Amazonas, Colombia | |||
24217 | 24217 | 2022-03-20 | Colombia | Amazonas | 7560 | 264 | 0 | -1.4429 | -71.5724 | 2022-03-21 04:20:50 | Amazonas, Colombia | |||
28232 | 28232 | 2021-11-11 | Colombia | Amazonas | 6857 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-12 04:22:01 | Amazonas, Colombia | |||
32248 | 32248 | 2021-08-25 | Colombia | Amazonas | 6780 | 254 | 0 | -1.4429 | -71.5724 | 2021-08-26 04:21:28 | Amazonas, Colombia | |||
43524 | 43524 | 2021-11-02 | Colombia | Amazonas | 6843 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-03 06:22:09 | Amazonas, Colombia | |||
62878 | 62878 | 2022-11-12 | Colombia | Amazonas | 7819 | 265 | 0 | -1.4429 | -71.5724 | 2022-11-13 04:21:14 | Amazonas, Colombia | |||
66893 | 66893 | 2021-09-01 | Colombia | Amazonas | 6795 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-02 04:21:15 | Amazonas, Colombia | |||
70907 | 70907 | 2022-02-07 | Colombia | Amazonas | 7467 | 260 | 0 | -1.4429 | -71.5724 | 2022-02-08 04:21:15 | Amazonas, Colombia | |||
86941 | 86941 | 2021-11-09 | Colombia | Amazonas | 6855 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-10 04:21:38 | Amazonas, Colombia | |||
90958 | 90958 | 2022-07-23 | Colombia | Amazonas | 7607 | 265 | 0 | -1.4429 | -71.5724 | 2022-07-24 04:20:47 | Amazonas, Colombia | |||
99142 | 99142 | 2022-01-14 | Colombia | Amazonas | 7137 | 260 | 0 | -1.4429 | -71.5724 | 2022-01-15 04:21:07 | Amazonas, Colombia | |||
103158 | 103158 | 2021-08-15 | Colombia | Amazonas | 6714 | 253 | 0 | -1.4429 | -71.5724 | 2021-08-16 04:21:31 | Amazonas, Colombia | |||
114568 | 114568 | 2022-09-06 | Colombia | Amazonas | 7808 | 265 | 0 | -1.4429 | -71.5724 | 2022-09-07 04:20:59 | Amazonas, Colombia | |||
126549 | 126549 | 2022-01-09 | Colombia | Amazonas | 7105 | 260 | 0 | -1.4429 | -71.5724 | 2022-01-10 04:22:07 | Amazonas, Colombia | |||
130566 | 130566 | 2022-10-04 | Colombia | Amazonas | 7812 | 265 | 0 | -1.4429 | -71.5724 | 2022-10-05 04:23:06 | Amazonas, Colombia | |||
137787 | 137787 | 2021-12-04 | Colombia | Amazonas | 6924 | 257 | 0 | -1.4429 | -71.5724 | 2021-12-05 04:22:25 | Amazonas, Colombia | |||
141804 | 141804 | 2022-07-09 | Colombia | Amazonas | 7593 | 265 | 0 | -1.4429 | -71.5724 | 2022-07-10 04:20:54 | Amazonas, Colombia | |||
149800 | 149800 | 2021-11-29 | Colombia | Amazonas | 6904 | 257 | 0 | -1.4429 | -71.5724 | 2021-11-30 04:22:53 | Amazonas, Colombia | |||
157829 | 157829 | 2022-03-29 | Colombia | Amazonas | 7564 | 264 | 0 | -1.4429 | -71.5724 | 2022-03-30 04:20:45 | Amazonas, Colombia | |||
161844 | 161844 | 2021-11-19 | Colombia | Amazonas | 6873 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-20 04:22:17 | Amazonas, Colombia | |||
165861 | 165861 | 2022-06-21 | Colombia | Amazonas | 7578 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-22 04:20:54 | Amazonas, Colombia | |||
177858 | 177858 | 2021-09-02 | Colombia | Amazonas | 6798 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-03 04:21:20 | Amazonas, Colombia | |||
185887 | 185887 | 2022-02-13 | Colombia | Amazonas | 7501 | 263 | 0 | -1.4429 | -71.5724 | 2022-02-14 04:20:51 | Amazonas, Colombia | |||
198075 | 198075 | 2022-10-19 | Colombia | Amazonas | 7814 | 265 | 0 | -1.4429 | -71.5724 | 2022-10-20 04:22:59 | Amazonas, Colombia | |||
217796 | 217796 | 2022-12-26 | Colombia | Amazonas | 7830 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-27 04:21:07 | Amazonas, Colombia | |||
221812 | 221812 | 2022-05-09 | Colombia | Amazonas | 7574 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-10 04:20:50 | Amazonas, Colombia | |||
229043 | 229043 | 2022-05-31 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-01 04:20:55 | Amazonas, Colombia | |||
233059 | 233059 | 2022-02-11 | Colombia | Amazonas | 7500 | 263 | 0 | -1.4429 | -71.5724 | 2022-02-12 04:21:06 | Amazonas, Colombia | |||
245101 | 245101 | 2021-08-17 | Colombia | Amazonas | 6719 | 253 | 0 | -1.4429 | -71.5724 | 2021-08-18 04:21:35 | Amazonas, Colombia | |||
249115 | 249115 | 2021-09-04 | Colombia | Amazonas | 6802 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-05 04:21:33 | Amazonas, Colombia | |||
253130 | 253130 | 2022-09-08 | Colombia | Amazonas | 7810 | 265 | 0 | -1.4429 | -71.5724 | 2022-09-09 04:21:11 | Amazonas, Colombia | |||
257146 | 257146 | 2022-12-10 | Colombia | Amazonas | 7824 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-11 04:20:50 | Amazonas, Colombia | |||
261349 | 261349 | 2022-03-15 | Colombia | Amazonas | 7557 | 264 | 0 | -1.4429 | -71.5724 | 2022-03-16 04:20:50 | Amazonas, Colombia | |||
275999 | 275999 | 2021-11-03 | Colombia | Amazonas | 6845 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-04 04:22:20 | Amazonas, Colombia | |||
287812 | 287812 | 2021-10-31 | Colombia | Amazonas | 6842 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-01 04:22:01 | Amazonas, Colombia | |||
291829 | 291829 | 2022-11-15 | Colombia | Amazonas | 7819 | 265 | 0 | -1.4429 | -71.5724 | 2022-11-16 04:21:09 | Amazonas, Colombia | |||
303685 | 303685 | 2022-04-16 | Colombia | Amazonas | 7569 | 265 | 0 | -1.4429 | -71.5724 | 2022-04-17 04:20:59 | Amazonas, Colombia | |||
307701 | 307701 | 2022-12-13 | Colombia | Amazonas | 7824 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-14 04:21:04 | Amazonas, Colombia | |||
311717 | 311717 | 2022-11-13 | Colombia | Amazonas | 7819 | 265 | 0 | -1.4429 | -71.5724 | 2022-11-14 04:21:09 | Amazonas, Colombia | |||
315733 | 315733 | 2022-02-12 | Colombia | Amazonas | 7501 | 263 | 0 | -1.4429 | -71.5724 | 2022-02-13 04:21:00 | Amazonas, Colombia | |||
319749 | 319749 | 2022-10-30 | Colombia | Amazonas | 7817 | 265 | 0 | -1.4429 | -71.5724 | 2022-10-31 04:21:36 | Amazonas, Colombia | |||
327723 | 327723 | 2022-12-27 | Colombia | Amazonas | 7830 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-28 04:21:04 | Amazonas, Colombia | |||
335753 | 335753 | 2022-03-18 | Colombia | Amazonas | 7560 | 264 | 0 | -1.4429 | -71.5724 | 2022-03-19 04:20:47 | Amazonas, Colombia | |||
348113 | 348113 | 2022-12-14 | Colombia | Amazonas | 7824 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-15 04:20:58 | Amazonas, Colombia | |||
356143 | 356143 | 2022-03-11 | Colombia | Amazonas | 7555 | 264 | 0 | -1.4429 | -71.5724 | 2022-03-12 04:20:50 | Amazonas, Colombia | |||
360159 | 360159 | 2022-05-07 | Colombia | Amazonas | 7574 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-08 04:20:49 | Amazonas, Colombia | |||
372013 | 372013 | 2022-09-13 | Colombia | Amazonas | 7810 | 265 | 0 | -1.4429 | -71.5724 | 2022-09-14 04:20:44 | Amazonas, Colombia | |||
384040 | 384040 | 2022-09-23 | Colombia | Amazonas | 7812 | 265 | 0 | -1.4429 | -71.5724 | 2022-09-24 04:21:40 | Amazonas, Colombia | |||
396081 | 396081 | 2022-10-07 | Colombia | Amazonas | 7814 | 265 | 0 | -1.4429 | -71.5724 | 2022-10-08 04:22:56 | Amazonas, Colombia | |||
404110 | 404110 | 2021-12-07 | Colombia | Amazonas | 6928 | 257 | 0 | -1.4429 | -71.5724 | 2021-12-08 04:22:46 | Amazonas, Colombia | |||
419152 | 419152 | 2022-09-18 | Colombia | Amazonas | 7812 | 265 | 0 | -1.4429 | -71.5724 | 2022-09-19 04:21:49 | Amazonas, Colombia | |||
423167 | 423167 | 2021-10-10 | Colombia | Amazonas | 6833 | 255 | 0 | -1.4429 | -71.5724 | 2021-10-11 04:21:31 | Amazonas, Colombia | |||
431174 | 431174 | 2022-11-03 | Colombia | Amazonas | 7817 | 265 | 0 | -1.4429 | -71.5724 | 2022-11-04 04:22:11 | Amazonas, Colombia | |||
443171 | 443171 | 2021-10-20 | Colombia | Amazonas | 6828 | 255 | 0 | -1.4429 | -71.5724 | 2021-10-21 04:21:18 | Amazonas, Colombia | |||
447187 | 447187 | 2021-11-17 | Colombia | Amazonas | 6867 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-18 04:21:33 | Amazonas, Colombia | |||
451204 | 451204 | 2022-12-21 | Colombia | Amazonas | 7827 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-22 04:20:56 | Amazonas, Colombia | |||
459196 | 459196 | 2022-02-02 | Colombia | Amazonas | 7423 | 260 | 0 | -1.4429 | -71.5724 | 2022-02-03 04:21:21 | Amazonas, Colombia | |||
463213 | 463213 | 2022-05-02 | Colombia | Amazonas | 7571 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-03 04:21:00 | Amazonas, Colombia | |||
467228 | 467228 | 2021-10-07 | Colombia | Amazonas | 6833 | 255 | 0 | -1.4429 | -71.5724 | 2021-10-08 04:21:25 | Amazonas, Colombia | |||
475259 | 475259 | 2022-06-26 | Colombia | Amazonas | 7578 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-27 04:21:00 | Amazonas, Colombia | |||
479407 | 479407 | 2022-11-08 | Colombia | Amazonas | 7817 | 265 | 0 | -1.4429 | -71.5724 | 2022-11-09 04:21:22 | Amazonas, Colombia | |||
487437 | 487437 | 2022-11-25 | Colombia | Amazonas | 7824 | 265 | 0 | -1.4429 | -71.5724 | 2022-11-26 04:21:11 | Amazonas, Colombia | |||
491452 | 491452 | 2021-10-14 | Colombia | Amazonas | 6828 | 255 | 0 | -1.4429 | -71.5724 | 2021-10-15 04:21:26 | Amazonas, Colombia | |||
495468 | 495468 | 2021-11-06 | Colombia | Amazonas | 6848 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-07 04:21:53 | Amazonas, Colombia | |||
499485 | 499485 | 2022-04-02 | Colombia | Amazonas | 7565 | 264 | 0 | -1.4429 | -71.5724 | 2022-04-03 04:20:48 | Amazonas, Colombia | |||
503501 | 503501 | 2022-12-17 | Colombia | Amazonas | 7827 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-18 04:21:03 | Amazonas, Colombia | |||
507516 | 507516 | 2021-08-14 | Colombia | Amazonas | 6714 | 253 | 0 | -1.4429 | -71.5724 | 2021-08-15 04:21:41 | Amazonas, Colombia | |||
511530 | 511530 | 2021-08-19 | Colombia | Amazonas | 6748 | 253 | 0 | -1.4429 | -71.5724 | 2021-08-20 04:21:33 | Amazonas, Colombia | |||
515545 | 515545 | 2022-10-15 | Colombia | Amazonas | 7814 | 265 | 0 | -1.4429 | -71.5724 | 2022-10-16 04:22:39 | Amazonas, Colombia | |||
534552 | 534552 | 2021-10-27 | Colombia | Amazonas | 6837 | 256 | 0 | -1.4429 | -71.5724 | 2021-10-28 04:22:08 | Amazonas, Colombia | |||
538569 | 538569 | 2022-10-26 | Colombia | Amazonas | 7816 | 265 | 0 | -1.4429 | -71.5724 | 2022-10-27 04:22:01 | Amazonas, Colombia | |||
542585 | 542585 | 2022-12-15 | Colombia | Amazonas | 7827 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-16 04:21:01 | Amazonas, Colombia | |||
550590 | 550590 | 2021-12-08 | Colombia | Amazonas | 6934 | 257 | 0 | -1.4429 | -71.5724 | 2021-12-09 04:22:49 | Amazonas, Colombia | |||
554606 | 554606 | 2022-01-16 | Colombia | Amazonas | 7156 | 260 | 0 | -1.4429 | -71.5724 | 2022-01-17 04:21:08 | Amazonas, Colombia | |||
558623 | 558623 | 2022-06-16 | Colombia | Amazonas | 7578 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-17 04:20:56 | Amazonas, Colombia | |||
566920 | 566920 | 2021-10-29 | Colombia | Amazonas | 6838 | 256 | 0 | -1.4429 | -71.5724 | 2021-10-30 04:22:03 | Amazonas, Colombia | |||
574649 | 574649 | 2022-02-25 | Colombia | Amazonas | 7533 | 264 | 0 | -1.4429 | -71.5724 | 2022-02-26 04:21:12 | Amazonas, Colombia | |||
589460 | 589460 | 2021-08-08 | Colombia | Amazonas | 6666 | 251 | 0 | -1.4429 | -71.5724 | 2021-08-09 04:21:24 | Amazonas, Colombia | |||
593475 | 593475 | 2022-07-01 | Colombia | Amazonas | 7586 | 265 | 0 | -1.4429 | -71.5724 | 2022-07-02 04:21:16 | Amazonas, Colombia | |||
597490 | 597490 | 2021-10-19 | Colombia | Amazonas | 6828 | 255 | 0 | -1.4429 | -71.5724 | 2021-10-20 04:21:00 | Amazonas, Colombia | |||
601506 | 601506 | 2021-09-23 | Colombia | Amazonas | 6826 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-24 04:21:44 | Amazonas, Colombia | |||
617679 | 617679 | 2022-11-05 | Colombia | Amazonas | 7817 | 265 | 0 | -1.4429 | -71.5724 | 2022-11-06 04:21:24 | Amazonas, Colombia | |||
621695 | 621695 | 2022-05-22 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-26 04:20:50 | Amazonas, Colombia | |||
629725 | 629725 | 2022-07-12 | Colombia | Amazonas | 7593 | 265 | 0 | -1.4429 | -71.5724 | 2022-07-13 04:20:58 | Amazonas, Colombia | |||
633740 | 633740 | 2021-10-13 | Colombia | Amazonas | 6828 | 255 | 0 | -1.4429 | -71.5724 | 2021-10-14 04:21:29 | Amazonas, Colombia | |||
641770 | 641770 | 2021-09-07 | Colombia | Amazonas | 6808 | 254 | 0 | -1.4429 | -71.5724 | 2021-09-08 04:21:31 | Amazonas, Colombia | |||
649798 | 649798 | 2021-08-09 | Colombia | Amazonas | 6676 | 251 | 0 | -1.4429 | -71.5724 | 2021-08-10 04:21:27 | Amazonas, Colombia | |||
653812 | 653812 | 2021-10-22 | Colombia | Amazonas | 6828 | 255 | 0 | -1.4429 | -71.5724 | 2021-10-23 04:21:32 | Amazonas, Colombia | |||
658131 | 658131 | 2022-05-13 | Colombia | Amazonas | 7575 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-14 04:20:48 | Amazonas, Colombia | |||
670116 | 670116 | 2022-07-21 | Colombia | Amazonas | 7593 | 265 | 0 | -1.4429 | -71.5724 | 2022-07-22 04:21:15 | Amazonas, Colombia | |||
674132 | 674132 | 2022-07-30 | Colombia | Amazonas | 7660 | 265 | 0 | -1.4429 | -71.5724 | 2022-07-31 04:21:02 | Amazonas, Colombia | |||
682157 | 682157 | 2021-10-24 | Colombia | Amazonas | 6825 | 255 | 0 | -1.4429 | -71.5724 | 2021-10-25 04:22:31 | Amazonas, Colombia | |||
686173 | 686173 | 2021-11-13 | Colombia | Amazonas | 6860 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-14 04:21:31 | Amazonas, Colombia | |||
690190 | 690190 | 2022-12-23 | Colombia | Amazonas | 7830 | 265 | 0 | -1.4429 | -71.5724 | 2022-12-24 04:21:02 | Amazonas, Colombia | |||
694206 | 694206 | 2022-03-17 | Colombia | Amazonas | 7560 | 264 | 0 | -1.4429 | -71.5724 | 2022-03-18 04:20:55 | Amazonas, Colombia | |||
698221 | 698221 | 2021-11-04 | Colombia | Amazonas | 6845 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-05 04:21:54 | Amazonas, Colombia | |||
706251 | 706251 | 2021-09-29 | Colombia | Amazonas | 6828 | 255 | 0 | -1.4429 | -71.5724 | 2021-09-30 04:21:20 | Amazonas, Colombia | |||
710267 | 710267 | 2022-11-01 | Colombia | Amazonas | 7817 | 265 | 0 | -1.4429 | -71.5724 | 2022-11-02 04:22:09 | Amazonas, Colombia |
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]);