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 = "Capital District" sorted by country_or_region
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
153 | 153 | 2021-12-02 | Colombia | Capital District | 1463367 | 27635 | 0 | 4.711 | -74.0721 | 2021-12-03 04:23:05 | Capital District, Colombia | |||
4169 | 4169 | 2021-10-28 | Colombia | Capital District | 1454485 | 27547 | 0 | 4.711 | -74.0721 | 2021-10-29 04:22:03 | Capital District, Colombia | |||
8172 | 8172 | 2020-10-25 | Colombia | Capital District | 309903 | 7490 | 277868 | 24545 | 4.711 | -74.0721 | 2020-10-26 04:25:02 | Capital District, Colombia | ||
12179 | 12179 | 2021-01-26 | Colombia | Capital District | 595731 | 12095 | 536064 | 47572 | 4.711 | -74.0721 | 2021-01-27 05:23:41 | Capital District, Colombia | ||
16194 | 16194 | 2021-09-18 | Colombia | Capital District | 1447491 | 27441 | 0 | 4.711 | -74.0721 | 2021-09-19 04:21:34 | Capital District, Colombia | |||
20209 | 20209 | 2021-05-28 | Colombia | Capital District | 942368 | 18553 | 862145 | 61670 | 4.711 | -74.0721 | 2021-05-29 04:20:41 | Capital District, Colombia | ||
24224 | 24224 | 2022-03-20 | Colombia | Capital District | 1764497 | 29304 | 0 | 4.711 | -74.0721 | 2022-03-21 04:20:50 | Capital District, Colombia | |||
28239 | 28239 | 2021-11-11 | Colombia | Capital District | 1457399 | 27574 | 0 | 4.711 | -74.0721 | 2021-11-12 04:22:01 | Capital District, Colombia | |||
32255 | 32255 | 2021-08-25 | Colombia | Capital District | 1438030 | 27242 | 0 | 4.711 | -74.0721 | 2021-08-26 04:21:28 | Capital District, Colombia | |||
36269 | 36269 | 2021-04-12 | Colombia | Capital District | 713559 | 14706 | 675448 | 23405 | 4.711 | -74.0721 | 2021-04-13 04:20:37 | Capital District, Colombia | ||
43531 | 43531 | 2021-11-02 | Colombia | Capital District | 1455372 | 27555 | 0 | 4.711 | -74.0721 | 2021-11-03 06:22:09 | Capital District, Colombia | |||
50630 | 50630 | 2021-05-29 | Colombia | Capital District | 951083 | 18683 | 869117 | 63283 | 4.711 | -74.0721 | 2021-05-30 04:20:55 | Capital District, Colombia | ||
54644 | 54644 | 2021-03-07 | Colombia | Capital District | 663603 | 13980 | 638247 | 11376 | 4.711 | -74.0721 | 2021-03-08 05:24:48 | Capital District, Colombia | ||
61813 | 61813 | 2020-07-23 | Colombia | Capital District | 74599 | 1905 | 29333 | 43361 | 4.711 | -74.0721 | 2020-07-24 05:30:40 | Capital District, Colombia | ||
62885 | 62885 | 2022-11-12 | Colombia | Capital District | 1855114 | 29845 | 0 | 4.711 | -74.0721 | 2022-11-13 04:21:14 | Capital District, Colombia | |||
66900 | 66900 | 2021-09-01 | Colombia | Capital District | 1441483 | 27321 | 0 | 4.711 | -74.0721 | 2021-09-02 04:21:15 | Capital District, Colombia | |||
70914 | 70914 | 2022-02-07 | Colombia | Capital District | 1720356 | 28509 | 0 | 4.711 | -74.0721 | 2022-02-08 04:21:15 | Capital District, Colombia | |||
74929 | 74929 | 2020-12-03 | Colombia | Capital District | 382704 | 8634 | 351110 | 22960 | 4.711 | -74.0721 | 2020-12-04 05:27:27 | Capital District, Colombia | ||
78928 | 78928 | 2020-10-14 | Colombia | Capital District | 291544 | 7186 | 258316 | 26042 | 4.711 | -74.0721 | 2020-10-15 04:24:28 | Capital District, Colombia | ||
82934 | 82934 | 2021-05-25 | Colombia | Capital District | 916103 | 18221 | 845333 | 52549 | 4.711 | -74.0721 | 2021-05-26 04:20:35 | Capital District, Colombia | ||
86948 | 86948 | 2021-11-09 | Colombia | Capital District | 1456819 | 27571 | 0 | 4.711 | -74.0721 | 2021-11-10 04:21:38 | Capital District, Colombia | |||
90965 | 90965 | 2022-07-23 | Colombia | Capital District | 1820163 | 29562 | 0 | 4.711 | -74.0721 | 2022-07-24 04:20:47 | Capital District, Colombia | |||
98147 | 98147 | 2020-08-04 | Colombia | Capital District | 113548 | 3169 | 55013 | 55366 | 4.711 | -74.0721 | 2020-08-05 04:34:43 | Capital District, Colombia | ||
99149 | 99149 | 2022-01-14 | Colombia | Capital District | 1555037 | 27789 | 0 | 4.711 | -74.0721 | 2022-01-15 04:21:07 | Capital District, Colombia | |||
103165 | 103165 | 2021-08-15 | Colombia | Capital District | 1431941 | 27078 | 0 | 4.711 | -74.0721 | 2021-08-16 04:21:31 | Capital District, Colombia | |||
107290 | 107290 | 2021-06-19 | Colombia | Capital District | 1147845 | 21720 | 1045932 | 80193 | 4.711 | -74.0721 | 2021-06-20 04:21:48 | Capital District, Colombia | ||
114575 | 114575 | 2022-09-06 | Colombia | Capital District | 1851673 | 29795 | 0 | 4.711 | -74.0721 | 2022-09-07 04:20:59 | Capital District, Colombia | |||
121740 | 121740 | 2020-07-19 | Colombia | Capital District | 63265 | 1555 | 24447 | 37263 | 4.711 | -74.0721 | 2020-07-20 05:34:40 | Capital District, Colombia | ||
122544 | 122544 | 2020-11-18 | Colombia | Capital District | 351876 | 8175 | 325176 | 18525 | 4.711 | -74.0721 | 2020-11-19 05:25:23 | Capital District, Colombia | ||
126556 | 126556 | 2022-01-09 | Colombia | Capital District | 1521045 | 27752 | 0 | 4.711 | -74.0721 | 2022-01-10 04:22:07 | Capital District, Colombia | |||
130573 | 130573 | 2022-10-04 | Colombia | Capital District | 1852960 | 29826 | 0 | 4.711 | -74.0721 | 2022-10-05 04:23:06 | Capital District, Colombia | |||
137794 | 137794 | 2021-12-04 | Colombia | Capital District | 1463971 | 27639 | 0 | 4.711 | -74.0721 | 2021-12-05 04:22:25 | Capital District, Colombia | |||
141811 | 141811 | 2022-07-09 | Colombia | Capital District | 1812958 | 29479 | 0 | 4.711 | -74.0721 | 2022-07-10 04:20:54 | Capital District, Colombia | |||
145813 | 145813 | 2020-08-15 | Colombia | Capital District | 158674 | 4269 | 87444 | 66961 | 4.711 | -74.0721 | 2020-08-16 04:27:42 | Capital District, Colombia | ||
149807 | 149807 | 2021-11-29 | Colombia | Capital District | 1462574 | 27616 | 0 | 4.711 | -74.0721 | 2021-11-30 04:22:53 | Capital District, Colombia | |||
153822 | 153822 | 2021-01-08 | Colombia | Capital District | 507768 | 10387 | 453954 | 43427 | 4.711 | -74.0721 | 2021-01-09 05:22:18 | Capital District, Colombia | ||
157836 | 157836 | 2022-03-29 | Colombia | Capital District | 1765739 | 29331 | 0 | 4.711 | -74.0721 | 2022-03-30 04:20:45 | Capital District, Colombia | |||
161851 | 161851 | 2021-11-19 | Colombia | Capital District | 1459654 | 27599 | 0 | 4.711 | -74.0721 | 2021-11-20 04:22:17 | Capital District, Colombia | |||
165868 | 165868 | 2022-06-21 | Colombia | Capital District | 1786328 | 29392 | 0 | 4.711 | -74.0721 | 2022-06-22 04:20:54 | Capital District, Colombia | |||
169883 | 169883 | 2021-04-16 | Colombia | Capital District | 729061 | 14820 | 681408 | 32833 | 4.711 | -74.0721 | 2021-04-17 04:20:40 | Capital District, Colombia | ||
177058 | 177058 | 2020-07-27 | Colombia | Capital District | 86857 | 2307 | 37916 | 46634 | 4.711 | -74.0721 | 2020-07-28 04:58:43 | Capital District, Colombia | ||
177865 | 177865 | 2021-09-02 | Colombia | Capital District | 1441891 | 27341 | 0 | 4.711 | -74.0721 | 2021-09-03 04:21:20 | Capital District, Colombia | |||
181879 | 181879 | 2021-02-21 | Colombia | Capital District | 650932 | 13643 | 621069 | 16220 | 4.711 | -74.0721 | 2021-02-22 05:24:21 | Capital District, Colombia | ||
185894 | 185894 | 2022-02-13 | Colombia | Capital District | 1738131 | 28762 | 0 | 4.711 | -74.0721 | 2022-02-14 04:20:51 | Capital District, Colombia | |||
189908 | 189908 | 2021-01-11 | Colombia | Capital District | 522621 | 10650 | 461805 | 50166 | 4.711 | -74.0721 | 2021-01-12 05:22:15 | Capital District, Colombia | ||
193908 | 193908 | 2020-08-31 | Colombia | Capital District | 211300 | 5437 | 151131 | 54732 | 4.711 | -74.0721 | 2020-09-01 04:28:31 | Capital District, Colombia | ||
198082 | 198082 | 2022-10-19 | Colombia | Capital District | 1853764 | 29831 | 0 | 4.711 | -74.0721 | 2022-10-20 04:22:59 | Capital District, Colombia | |||
202096 | 202096 | 2020-12-25 | Colombia | Capital District | 447821 | 9437 | 401986 | 36398 | 4.711 | -74.0721 | 2020-12-26 05:22:28 | Capital District, Colombia | ||
206095 | 206095 | 2020-08-19 | Colombia | Capital District | 176336 | 4587 | 106822 | 64927 | 4.711 | -74.0721 | 2020-08-20 04:27:43 | Capital District, Colombia | ||
210080 | 210080 | 2020-10-29 | Colombia | Capital District | 314687 | 7567 | 286402 | 20718 | 4.711 | -74.0721 | 2020-10-30 04:24:49 | Capital District, Colombia | ||
217046 | 217046 | 2020-06-08 | Colombia | Capital District | 13329 | 335 | 5682 | 7312 | 4.711 | -74.0721 | 2020-06-09 03:33:03 | Capital District, Colombia | ||
217803 | 217803 | 2022-12-26 | Colombia | Capital District | 1862342 | 29902 | 0 | 4.711 | -74.0721 | 2022-12-27 04:21:07 | Capital District, Colombia | |||
221819 | 221819 | 2022-05-09 | Colombia | Capital District | 1769503 | 29368 | 0 | 4.711 | -74.0721 | 2022-05-10 04:20:50 | Capital District, Colombia | |||
229050 | 229050 | 2022-05-31 | Colombia | Capital District | 1773819 | 29376 | 0 | 4.711 | -74.0721 | 2022-06-01 04:20:55 | Capital District, Colombia | |||
233066 | 233066 | 2022-02-11 | Colombia | Capital District | 1732976 | 28657 | 0 | 4.711 | -74.0721 | 2022-02-12 04:21:06 | Capital District, Colombia | |||
237080 | 237080 | 2021-01-18 | Colombia | Capital District | 560284 | 11347 | 503530 | 45407 | 4.711 | -74.0721 | 2021-01-19 05:22:15 | Capital District, Colombia | ||
241094 | 241094 | 2021-04-02 | Colombia | Capital District | 690844 | 14445 | 661802 | 14597 | 4.711 | -74.0721 | 2021-04-03 04:20:44 | Capital District, Colombia | ||
245108 | 245108 | 2021-08-17 | Colombia | Capital District | 1434287 | 27135 | 0 | 4.711 | -74.0721 | 2021-08-18 04:21:35 | Capital District, Colombia | |||
249122 | 249122 | 2021-09-04 | Colombia | Capital District | 1442868 | 27355 | 0 | 4.711 | -74.0721 | 2021-09-05 04:21:33 | Capital District, Colombia | |||
253137 | 253137 | 2022-09-08 | Colombia | Capital District | 1852256 | 29795 | 0 | 4.711 | -74.0721 | 2022-09-09 04:21:11 | Capital District, Colombia | |||
257153 | 257153 | 2022-12-10 | Colombia | Capital District | 1857342 | 29868 | 0 | 4.711 | -74.0721 | 2022-12-11 04:20:50 | Capital District, Colombia | |||
261356 | 261356 | 2022-03-15 | Colombia | Capital District | 1762994 | 29255 | 0 | 4.711 | -74.0721 | 2022-03-16 04:20:50 | Capital District, Colombia | |||
271995 | 271995 | 2020-11-10 | Colombia | Capital District | 338196 | 7956 | 311652 | 18588 | 4.711 | -74.0721 | 2020-11-11 05:25:30 | Capital District, Colombia | ||
276006 | 276006 | 2021-11-03 | Colombia | Capital District | 1455552 | 27558 | 0 | 4.711 | -74.0721 | 2021-11-04 04:22:20 | Capital District, Colombia | |||
280022 | 280022 | 2021-02-24 | Colombia | Capital District | 654204 | 13734 | 625619 | 14851 | 4.711 | -74.0721 | 2021-02-25 05:24:57 | Capital District, Colombia | ||
287029 | 287029 | 2020-06-15 | Colombia | Capital District | 16404 | 416 | 6885 | 9103 | 4.711 | -74.0721 | 2020-06-16 04:33:09 | Capital District, Colombia | ||
287819 | 287819 | 2021-10-31 | Colombia | Capital District | 1455114 | 27550 | 0 | 4.711 | -74.0721 | 2021-11-01 04:22:01 | Capital District, Colombia | |||
291836 | 291836 | 2022-11-15 | Colombia | Capital District | 1855114 | 29845 | 0 | 4.711 | -74.0721 | 2022-11-16 04:21:09 | Capital District, Colombia | |||
295851 | 295851 | 2021-07-15 | Colombia | Capital District | 1358292 | 25468 | 1281867 | 50957 | 4.711 | -74.0721 | 2021-07-16 04:21:22 | Capital District, Colombia | ||
302901 | 302901 | 2020-07-01 | Colombia | Capital District | 30017 | 713 | 12756 | 16548 | 4.711 | -74.0721 | 2020-07-02 04:33:46 | Capital District, Colombia | ||
303692 | 303692 | 2022-04-16 | Colombia | Capital District | 1767928 | 29358 | 0 | 4.711 | -74.0721 | 2022-04-17 04:20:59 | Capital District, Colombia | |||
307708 | 307708 | 2022-12-13 | Colombia | Capital District | 1857342 | 29868 | 0 | 4.711 | -74.0721 | 2022-12-14 04:21:04 | Capital District, Colombia | |||
311724 | 311724 | 2022-11-13 | Colombia | Capital District | 1855114 | 29845 | 0 | 4.711 | -74.0721 | 2022-11-14 04:21:09 | Capital District, Colombia | |||
315740 | 315740 | 2022-02-12 | Colombia | Capital District | 1735693 | 28684 | 0 | 4.711 | -74.0721 | 2022-02-13 04:21:00 | Capital District, Colombia | |||
319756 | 319756 | 2022-10-30 | Colombia | Capital District | 1854344 | 29839 | 0 | 4.711 | -74.0721 | 2022-10-31 04:21:36 | Capital District, Colombia | |||
326835 | 326835 | 2020-07-20 | Colombia | Capital District | 65594 | 1627 | 25614 | 38353 | 4.711 | -74.0721 | 2020-07-21 04:38:46 | Capital District, Colombia | ||
327730 | 327730 | 2022-12-27 | Colombia | Capital District | 1862342 | 29902 | 0 | 4.711 | -74.0721 | 2022-12-28 04:21:04 | Capital District, Colombia | |||
331745 | 331745 | 2021-08-04 | Colombia | Capital District | 1420779 | 26797 | 1369593 | 24389 | 4.711 | -74.0721 | 2021-08-05 04:21:51 | Capital District, Colombia | ||
335760 | 335760 | 2022-03-18 | Colombia | Capital District | 1763889 | 29283 | 0 | 4.711 | -74.0721 | 2022-03-19 04:20:47 | Capital District, Colombia | |||
340114 | 340114 | 2021-02-03 | Colombia | Capital District | 622916 | 12841 | 577566 | 32509 | 4.711 | -74.0721 | 2021-02-04 05:22:26 | Capital District, Colombia | ||
344116 | 344116 | 2020-09-14 | Colombia | Capital District | 242007 | 6229 | 197710 | 38068 | 4.711 | -74.0721 | 2020-09-15 03:22:50 | Capital District, Colombia | ||
348120 | 348120 | 2022-12-14 | Colombia | Capital District | 1857342 | 29868 | 0 | 4.711 | -74.0721 | 2022-12-15 04:20:58 | Capital District, Colombia | |||
352135 | 352135 | 2021-03-11 | Colombia | Capital District | 666431 | 14028 | 641525 | 10878 | 4.711 | -74.0721 | 2021-03-12 05:26:50 | Capital District, Colombia | ||
356150 | 356150 | 2022-03-11 | Colombia | Capital District | 1762123 | 29233 | 0 | 4.711 | -74.0721 | 2022-03-12 04:20:50 | Capital District, Colombia | |||
360166 | 360166 | 2022-05-07 | Colombia | Capital District | 1769503 | 29368 | 0 | 4.711 | -74.0721 | 2022-05-08 04:20:49 | Capital District, Colombia | |||
367250 | 367250 | 2020-07-16 | Colombia | Capital District | 55056 | 1376 | 19668 | 34012 | 4.711 | -74.0721 | 2020-07-17 04:34:50 | Capital District, Colombia | ||
371212 | 371212 | 2020-08-08 | Colombia | Capital District | 129975 | 3578 | 61188 | 65209 | 4.711 | -74.0721 | 2020-08-09 04:34:54 | Capital District, Colombia | ||
372020 | 372020 | 2022-09-13 | Colombia | Capital District | 1852256 | 29808 | 0 | 4.711 | -74.0721 | 2022-09-14 04:20:44 | Capital District, Colombia | |||
376022 | 376022 | 2020-11-06 | Colombia | Capital District | 332118 | 7820 | 302972 | 21326 | 4.711 | -74.0721 | 2020-11-07 05:24:52 | Capital District, Colombia | ||
380032 | 380032 | 2021-04-30 | Colombia | Capital District | 788109 | 15692 | 728143 | 44274 | 4.711 | -74.0721 | 2021-05-01 04:20:47 | Capital District, Colombia | ||
384047 | 384047 | 2022-09-23 | Colombia | Capital District | 1852960 | 29819 | 0 | 4.711 | -74.0721 | 2022-09-24 04:21:40 | Capital District, Colombia | |||
388062 | 388062 | 2021-04-04 | Colombia | Capital District | 693578 | 14481 | 664404 | 14693 | 4.711 | -74.0721 | 2021-04-05 04:20:35 | Capital District, Colombia | ||
392075 | 392075 | 2020-11-27 | Colombia | Capital District | 369722 | 8449 | 342957 | 18316 | 4.711 | -74.0721 | 2020-11-28 05:25:50 | Capital District, Colombia | ||
396088 | 396088 | 2022-10-07 | Colombia | Capital District | 1853689 | 29827 | 0 | 4.711 | -74.0721 | 2022-10-08 04:22:56 | Capital District, Colombia | |||
400103 | 400103 | 2021-06-29 | Colombia | Capital District | 1244585 | 23566 | 1134791 | 86228 | 4.711 | -74.0721 | 2021-06-30 04:21:41 | Capital District, Colombia | ||
404117 | 404117 | 2021-12-07 | Colombia | Capital District | 1464617 | 27649 | 0 | 4.711 | -74.0721 | 2021-12-08 04:22:46 | Capital District, Colombia | |||
408133 | 408133 | 2021-07-28 | Colombia | Capital District | 1405585 | 26459 | 1346804 | 32322 | 4.711 | -74.0721 | 2021-07-29 04:21:33 | Capital District, Colombia | ||
415193 | 415193 | 2020-07-05 | Colombia | Capital District | 35266 | 842 | 13771 | 20653 | 4.711 | -74.0721 | 2020-07-06 04:33:57 | Capital District, Colombia | ||
419159 | 419159 | 2022-09-18 | Colombia | Capital District | 1852577 | 29817 | 0 | 4.711 | -74.0721 | 2022-09-19 04:21:49 | Capital District, Colombia | |||
423174 | 423174 | 2021-10-10 | Colombia | Capital District | 1451440 | 27506 | 0 | 4.711 | -74.0721 | 2021-10-11 04:21:31 | Capital District, 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]);