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 = "Huila" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069862 | 3069862 | 2021-11-23 | Colombia | Huila | 88825 | 3153 | 0 | 2.5359 | -75.5277 | 2021-11-24 04:22:14 | Huila, Colombia | |||
3748960 | 3748960 | 2021-11-22 | Colombia | Huila | 88770 | 3151 | 0 | 2.5359 | -75.5277 | 2021-11-23 04:22:39 | Huila, Colombia | |||
1014167 | 1014167 | 2021-11-21 | Colombia | Huila | 88770 | 3151 | 0 | 2.5359 | -75.5277 | 2021-11-22 04:22:20 | Huila, Colombia | |||
722331 | 722331 | 2021-11-20 | Colombia | Huila | 88750 | 3151 | 0 | 2.5359 | -75.5277 | 2021-11-21 04:22:13 | Huila, Colombia | |||
161861 | 161861 | 2021-11-19 | Colombia | Huila | 88732 | 3151 | 0 | 2.5359 | -75.5277 | 2021-11-20 04:22:17 | Huila, Colombia | |||
3288748 | 3288748 | 2021-11-18 | Colombia | Huila | 88716 | 3149 | 0 | 2.5359 | -75.5277 | 2021-11-19 04:21:40 | Huila, Colombia | |||
447204 | 447204 | 2021-11-17 | Colombia | Huila | 88709 | 3149 | 0 | 2.5359 | -75.5277 | 2021-11-18 04:21:33 | Huila, Colombia | |||
3342454 | 3342454 | 2021-11-16 | Colombia | Huila | 88694 | 3149 | 0 | 2.5359 | -75.5277 | 2021-11-17 04:21:48 | Huila, Colombia | |||
2287290 | 2287290 | 2021-11-15 | Colombia | Huila | 88666 | 3149 | 0 | 2.5359 | -75.5277 | 2021-11-16 04:21:10 | Huila, Colombia | |||
1322064 | 1322064 | 2021-11-14 | Colombia | Huila | 88654 | 3149 | 0 | 2.5359 | -75.5277 | 2021-11-15 04:21:36 | Huila, Colombia | |||
686190 | 686190 | 2021-11-13 | Colombia | Huila | 88647 | 3147 | 0 | 2.5359 | -75.5277 | 2021-11-14 04:21:31 | Huila, Colombia | |||
714299 | 714299 | 2021-11-12 | Colombia | Huila | 88631 | 3147 | 0 | 2.5359 | -75.5277 | 2021-11-13 04:21:38 | Huila, Colombia | |||
28249 | 28249 | 2021-11-11 | Colombia | Huila | 88623 | 3147 | 0 | 2.5359 | -75.5277 | 2021-11-12 04:22:01 | Huila, Colombia | |||
2844688 | 2844688 | 2021-11-10 | Colombia | Huila | 88609 | 3146 | 0 | 2.5359 | -75.5277 | 2021-11-11 04:21:45 | Huila, Colombia | |||
86958 | 86958 | 2021-11-09 | Colombia | Huila | 88571 | 3146 | 0 | 2.5359 | -75.5277 | 2021-11-10 04:21:38 | Huila, Colombia | |||
3639386 | 3639386 | 2021-11-08 | Colombia | Huila | 88533 | 3145 | 0 | 2.5359 | -75.5277 | 2021-11-09 04:21:36 | Huila, Colombia | |||
2000494 | 2000494 | 2021-11-07 | Colombia | Huila | 88510 | 3145 | 0 | 2.5359 | -75.5277 | 2021-11-08 04:21:43 | Huila, Colombia | |||
495485 | 495485 | 2021-11-06 | Colombia | Huila | 88488 | 3145 | 0 | 2.5359 | -75.5277 | 2021-11-07 04:21:53 | Huila, Colombia | |||
3121340 | 3121340 | 2021-11-05 | Colombia | Huila | 88472 | 3145 | 0 | 2.5359 | -75.5277 | 2021-11-06 04:21:51 | Huila, Colombia | |||
698238 | 698238 | 2021-11-04 | Colombia | Huila | 88465 | 3144 | 0 | 2.5359 | -75.5277 | 2021-11-05 04:21:54 | Huila, Colombia | |||
276016 | 276016 | 2021-11-03 | Colombia | Huila | 88453 | 3144 | 0 | 2.5359 | -75.5277 | 2021-11-04 04:22:20 | Huila, Colombia | |||
43541 | 43541 | 2021-11-02 | Colombia | Huila | 88446 | 3144 | 0 | 2.5359 | -75.5277 | 2021-11-03 06:22:09 | Huila, Colombia | |||
3511237 | 3511237 | 2021-11-01 | Colombia | Huila | 88444 | 3143 | 0 | 2.5359 | -75.5277 | 2021-11-02 04:22:03 | Huila, Colombia | |||
287829 | 287829 | 2021-10-31 | Colombia | Huila | 88440 | 3143 | 0 | 2.5359 | -75.5277 | 2021-11-01 04:22:01 | Huila, Colombia | |||
2720835 | 2720835 | 2021-10-30 | Colombia | Huila | 88431 | 3143 | 0 | 2.5359 | -75.5277 | 2021-10-31 04:22:08 | Huila, Colombia | |||
566937 | 566937 | 2021-10-29 | Colombia | Huila | 88416 | 3143 | 0 | 2.5359 | -75.5277 | 2021-10-30 04:22:03 | Huila, Colombia | |||
4179 | 4179 | 2021-10-28 | Colombia | Huila | 88404 | 3143 | 0 | 2.5359 | -75.5277 | 2021-10-29 04:22:03 | Huila, Colombia | |||
534569 | 534569 | 2021-10-27 | Colombia | Huila | 88396 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-28 04:22:08 | Huila, Colombia | |||
3492006 | 3492006 | 2021-10-26 | Colombia | Huila | 88387 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-27 04:22:32 | Huila, Colombia | |||
3793728 | 3793728 | 2021-10-25 | Colombia | Huila | 88383 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-26 04:22:09 | Huila, Colombia | |||
682174 | 682174 | 2021-10-24 | Colombia | Huila | 88380 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-25 04:22:31 | Huila, Colombia | |||
770182 | 770182 | 2021-10-23 | Colombia | Huila | 88374 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-24 04:21:22 | Huila, Colombia | |||
653829 | 653829 | 2021-10-22 | Colombia | Huila | 88366 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-23 04:21:32 | Huila, Colombia | |||
2123576 | 2123576 | 2021-10-21 | Colombia | Huila | 88359 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-22 04:21:14 | Huila, Colombia | |||
443188 | 443188 | 2021-10-20 | Colombia | Huila | 88356 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-21 04:21:18 | Huila, Colombia | |||
597507 | 597507 | 2021-10-19 | Colombia | Huila | 88351 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-20 04:21:00 | Huila, Colombia | |||
2043684 | 2043684 | 2021-10-18 | Colombia | Huila | 88351 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-19 04:20:54 | Huila, Colombia | |||
1909045 | 1909045 | 2021-10-17 | Colombia | Huila | 88345 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-18 04:21:10 | Huila, Colombia | |||
934634 | 934634 | 2021-10-16 | Colombia | Huila | 88337 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-17 04:21:29 | Huila, Colombia | |||
2943189 | 2943189 | 2021-10-15 | Colombia | Huila | 88331 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-16 04:21:15 | Huila, Colombia | |||
491469 | 491469 | 2021-10-14 | Colombia | Huila | 88321 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-15 04:21:26 | Huila, Colombia | |||
633757 | 633757 | 2021-10-13 | Colombia | Huila | 88307 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-14 04:21:29 | Huila, Colombia | |||
1491435 | 1491435 | 2021-10-12 | Colombia | Huila | 88303 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-13 04:20:51 | Huila, Colombia | |||
3007168 | 3007168 | 2021-10-11 | Colombia | Huila | 88300 | 3141 | 0 | 2.5359 | -75.5277 | 2021-10-12 04:21:09 | Huila, Colombia | |||
423184 | 423184 | 2021-10-10 | Colombia | Huila | 88293 | 3141 | 0 | 2.5359 | -75.5277 | 2021-10-11 04:21:31 | Huila, Colombia | |||
2876041 | 2876041 | 2021-10-09 | Colombia | Huila | 88292 | 3141 | 0 | 2.5359 | -75.5277 | 2021-10-10 04:21:38 | Huila, Colombia | |||
2959207 | 2959207 | 2021-10-08 | Colombia | Huila | 88279 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-09 04:21:34 | Huila, Colombia | |||
467245 | 467245 | 2021-10-07 | Colombia | Huila | 88266 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-08 04:21:25 | Huila, Colombia | |||
2458625 | 2458625 | 2021-10-06 | Colombia | Huila | 88241 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-07 04:21:36 | Huila, Colombia | |||
3832319 | 3832319 | 2021-10-05 | Colombia | Huila | 88238 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-06 04:21:33 | Huila, Colombia | |||
986812 | 986812 | 2021-10-04 | Colombia | Huila | 88235 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-05 04:21:27 | Huila, Colombia | |||
1274122 | 1274122 | 2021-10-03 | Colombia | Huila | 88234 | 3139 | 0 | 2.5359 | -75.5277 | 2021-10-04 04:21:31 | Huila, Colombia | |||
3927875 | 3927875 | 2021-10-02 | Colombia | Huila | 88223 | 3139 | 0 | 2.5359 | -75.5277 | 2021-10-03 04:21:24 | Huila, Colombia | |||
2131855 | 2131855 | 2021-10-01 | Colombia | Huila | 88206 | 3139 | 0 | 2.5359 | -75.5277 | 2021-10-02 04:21:25 | Huila, Colombia | |||
2772812 | 2772812 | 2021-09-30 | Colombia | Huila | 88195 | 3139 | 0 | 2.5359 | -75.5277 | 2021-10-01 04:21:35 | Huila, Colombia | |||
706268 | 706268 | 2021-09-29 | Colombia | Huila | 88187 | 3139 | 0 | 2.5359 | -75.5277 | 2021-09-30 04:21:20 | Huila, Colombia | |||
1334110 | 1334110 | 2021-09-28 | Colombia | Huila | 88186 | 3139 | 0 | 2.5359 | -75.5277 | 2021-09-29 04:21:45 | Huila, Colombia | |||
1235479 | 1235479 | 2021-09-27 | Colombia | Huila | 88168 | 3139 | 0 | 2.5359 | -75.5277 | 2021-09-28 04:21:28 | Huila, Colombia | |||
2075780 | 2075780 | 2021-09-26 | Colombia | Huila | 88168 | 3138 | 0 | 2.5359 | -75.5277 | 2021-09-27 04:21:16 | Huila, Colombia | |||
1724332 | 1724332 | 2021-09-25 | Colombia | Huila | 88158 | 3137 | 0 | 2.5359 | -75.5277 | 2021-09-26 04:21:29 | Huila, Colombia | |||
1921052 | 1921052 | 2021-09-24 | Colombia | Huila | 88149 | 3137 | 0 | 2.5359 | -75.5277 | 2021-09-25 04:21:31 | Huila, Colombia | |||
601523 | 601523 | 2021-09-23 | Colombia | Huila | 88142 | 3135 | 0 | 2.5359 | -75.5277 | 2021-09-24 04:21:44 | Huila, Colombia | |||
3011184 | 3011184 | 2021-09-22 | Colombia | Huila | 88126 | 3135 | 0 | 2.5359 | -75.5277 | 2021-09-23 04:21:43 | Huila, Colombia | |||
3757322 | 3757322 | 2021-09-21 | Colombia | Huila | 88111 | 3135 | 0 | 2.5359 | -75.5277 | 2021-09-22 04:21:45 | Huila, Colombia | |||
809425 | 809425 | 2021-09-20 | Colombia | Huila | 88105 | 3135 | 0 | 2.5359 | -75.5277 | 2021-09-21 04:21:26 | Huila, Colombia | |||
1814624 | 1814624 | 2021-09-19 | Colombia | Huila | 88099 | 3134 | 0 | 2.5359 | -75.5277 | 2021-09-20 04:21:22 | Huila, Colombia | |||
16204 | 16204 | 2021-09-18 | Colombia | Huila | 88080 | 3133 | 0 | 2.5359 | -75.5277 | 2021-09-19 04:21:34 | Huila, Colombia | |||
2617889 | 2617889 | 2021-09-17 | Colombia | Huila | 88066 | 3132 | 0 | 2.5359 | -75.5277 | 2021-09-18 04:21:24 | Huila, Colombia | |||
2808597 | 2808597 | 2021-09-16 | Colombia | Huila | 88049 | 3132 | 0 | 2.5359 | -75.5277 | 2021-09-17 04:21:46 | Huila, Colombia | |||
1374342 | 1374342 | 2021-09-15 | Colombia | Huila | 88024 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-16 04:22:19 | Huila, Colombia | |||
2462641 | 2462641 | 2021-09-14 | Colombia | Huila | 88024 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-15 03:22:37 | Huila, Colombia | |||
1385480 | 1385480 | 2021-09-13 | Colombia | Huila | 88012 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-14 04:21:41 | Huila, Colombia | |||
1884849 | 1884849 | 2021-09-12 | Colombia | Huila | 88008 | 3130 | 0 | 2.5359 | -75.5277 | 2021-09-13 04:21:15 | Huila, Colombia | |||
3805752 | 3805752 | 2021-09-11 | Colombia | Huila | 87994 | 3129 | 0 | 2.5359 | -75.5277 | 2021-09-12 04:21:13 | Huila, Colombia | |||
3448692 | 3448692 | 2021-09-10 | Colombia | Huila | 87975 | 3128 | 0 | 2.5359 | -75.5277 | 2021-09-11 04:21:30 | Huila, Colombia | |||
1262638 | 1262638 | 2021-09-09 | Colombia | Huila | 87948 | 3127 | 0 | 2.5359 | -75.5277 | 2021-09-10 04:21:20 | Huila, Colombia | |||
2279008 | 2279008 | 2021-09-08 | Colombia | Huila | 87937 | 3126 | 0 | 2.5359 | -75.5277 | 2021-09-09 04:21:27 | Huila, Colombia | |||
641787 | 641787 | 2021-09-07 | Colombia | Huila | 87921 | 3124 | 0 | 2.5359 | -75.5277 | 2021-09-08 04:21:31 | Huila, Colombia | |||
3193850 | 3193850 | 2021-09-06 | Colombia | Huila | 87914 | 3122 | 0 | 2.5359 | -75.5277 | 2021-09-07 04:21:35 | Huila, Colombia | |||
3280718 | 3280718 | 2021-09-05 | Colombia | Huila | 87901 | 3118 | 0 | 2.5359 | -75.5277 | 2021-09-06 04:21:22 | Huila, Colombia | |||
249132 | 249132 | 2021-09-04 | Colombia | Huila | 87881 | 3117 | 0 | 2.5359 | -75.5277 | 2021-09-05 04:21:33 | Huila, Colombia | |||
3974413 | 3974413 | 2021-09-03 | Colombia | Huila | 87858 | 3116 | 0 | 2.5359 | -75.5277 | 2021-09-04 04:21:28 | Huila, Colombia | |||
177875 | 177875 | 2021-09-02 | Colombia | Huila | 87838 | 3113 | 0 | 2.5359 | -75.5277 | 2021-09-03 04:21:20 | Huila, Colombia | |||
66910 | 66910 | 2021-09-01 | Colombia | Huila | 87817 | 3112 | 0 | 2.5359 | -75.5277 | 2021-09-02 04:21:15 | Huila, Colombia | |||
2067752 | 2067752 | 2021-08-31 | Colombia | Huila | 87794 | 3108 | 0 | 2.5359 | -75.5277 | 2021-09-01 04:21:38 | Huila, Colombia | |||
1775206 | 1775206 | 2021-08-30 | Colombia | Huila | 87775 | 3108 | 0 | 2.5359 | -75.5277 | 2021-08-31 04:21:46 | Huila, Colombia | |||
3891780 | 3891780 | 2021-08-29 | Colombia | Huila | 87741 | 3105 | 0 | 2.5359 | -75.5277 | 2021-08-30 04:21:23 | Huila, Colombia | |||
2792883 | 2792883 | 2021-08-28 | Colombia | Huila | 87699 | 3102 | 0 | 2.5359 | -75.5277 | 2021-08-29 04:21:14 | Huila, Colombia | |||
2923042 | 2923042 | 2021-08-27 | Colombia | Huila | 87662 | 3100 | 0 | 2.5359 | -75.5277 | 2021-08-28 04:21:28 | Huila, Colombia | |||
1596056 | 1596056 | 2021-08-26 | Colombia | Huila | 87625 | 3097 | 0 | 2.5359 | -75.5277 | 2021-08-27 04:21:37 | Huila, Colombia | |||
32265 | 32265 | 2021-08-25 | Colombia | Huila | 87566 | 3095 | 0 | 2.5359 | -75.5277 | 2021-08-26 04:21:28 | Huila, Colombia | |||
3105304 | 3105304 | 2021-08-24 | Colombia | Huila | 87566 | 3093 | 0 | 2.5359 | -75.5277 | 2021-08-25 04:21:41 | Huila, Colombia | |||
3165475 | 3165475 | 2021-08-23 | Colombia | Huila | 87528 | 3092 | 0 | 2.5359 | -75.5277 | 2021-08-24 04:21:19 | Huila, Colombia | |||
2175402 | 2175402 | 2021-08-22 | Colombia | Huila | 87498 | 3090 | 0 | 2.5359 | -75.5277 | 2021-08-23 04:21:27 | Huila, Colombia | |||
3555498 | 3555498 | 2021-08-21 | Colombia | Huila | 87456 | 3082 | 0 | 2.5359 | -75.5277 | 2021-08-22 04:21:29 | Huila, Colombia | |||
1853840 | 1853840 | 2021-08-20 | Colombia | Huila | 87406 | 3082 | 0 | 2.5359 | -75.5277 | 2021-08-21 04:21:38 | Huila, Colombia | |||
511547 | 511547 | 2021-08-19 | Colombia | Huila | 87347 | 3081 | 0 | 2.5359 | -75.5277 | 2021-08-20 04:21:33 | Huila, Colombia | |||
2518026 | 2518026 | 2021-08-18 | Colombia | Huila | 87314 | 3072 | 0 | 2.5359 | -75.5277 | 2021-08-19 04:21:15 | Huila, Colombia | |||
245118 | 245118 | 2021-08-17 | Colombia | Huila | 87280 | 3072 | 0 | 2.5359 | -75.5277 | 2021-08-18 04:21:35 | Huila, Colombia | |||
1604081 | 1604081 | 2021-08-16 | Colombia | Huila | 87246 | 3067 | 0 | 2.5359 | -75.5277 | 2021-08-17 04:21:49 | Huila, 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]);