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 = "Meta" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462644 | 2462644 | 2021-09-14 | Colombia | Meta | 87662 | 2223 | 0 | 3.272 | -73.0877 | 2021-09-15 03:22:37 | Meta, Colombia | |||
1385483 | 1385483 | 2021-09-13 | Colombia | Meta | 87652 | 2222 | 0 | 3.272 | -73.0877 | 2021-09-14 04:21:41 | Meta, Colombia | |||
1884852 | 1884852 | 2021-09-12 | Colombia | Meta | 87645 | 2220 | 0 | 3.272 | -73.0877 | 2021-09-13 04:21:15 | Meta, Colombia | |||
3805755 | 3805755 | 2021-09-11 | Colombia | Meta | 87626 | 2217 | 0 | 3.272 | -73.0877 | 2021-09-12 04:21:13 | Meta, Colombia | |||
3448695 | 3448695 | 2021-09-10 | Colombia | Meta | 87613 | 2212 | 0 | 3.272 | -73.0877 | 2021-09-11 04:21:30 | Meta, Colombia | |||
1262641 | 1262641 | 2021-09-09 | Colombia | Meta | 87556 | 2212 | 0 | 3.272 | -73.0877 | 2021-09-10 04:21:20 | Meta, Colombia | |||
2279011 | 2279011 | 2021-09-08 | Colombia | Meta | 87532 | 2212 | 0 | 3.272 | -73.0877 | 2021-09-09 04:21:27 | Meta, Colombia | |||
641790 | 641790 | 2021-09-07 | Colombia | Meta | 87516 | 2212 | 0 | 3.272 | -73.0877 | 2021-09-08 04:21:31 | Meta, Colombia | |||
3193853 | 3193853 | 2021-09-06 | Colombia | Meta | 87512 | 2211 | 0 | 3.272 | -73.0877 | 2021-09-07 04:21:35 | Meta, Colombia | |||
3280721 | 3280721 | 2021-09-05 | Colombia | Meta | 87495 | 2211 | 0 | 3.272 | -73.0877 | 2021-09-06 04:21:22 | Meta, Colombia | |||
249135 | 249135 | 2021-09-04 | Colombia | Meta | 87482 | 2211 | 0 | 3.272 | -73.0877 | 2021-09-05 04:21:33 | Meta, Colombia | |||
3974416 | 3974416 | 2021-09-03 | Colombia | Meta | 87470 | 2208 | 0 | 3.272 | -73.0877 | 2021-09-04 04:21:28 | Meta, Colombia | |||
177878 | 177878 | 2021-09-02 | Colombia | Meta | 87452 | 2208 | 0 | 3.272 | -73.0877 | 2021-09-03 04:21:20 | Meta, Colombia | |||
66913 | 66913 | 2021-09-01 | Colombia | Meta | 87432 | 2208 | 0 | 3.272 | -73.0877 | 2021-09-02 04:21:15 | Meta, Colombia | |||
2067755 | 2067755 | 2021-08-31 | Colombia | Meta | 87413 | 2206 | 0 | 3.272 | -73.0877 | 2021-09-01 04:21:38 | Meta, Colombia | |||
1775209 | 1775209 | 2021-08-30 | Colombia | Meta | 87380 | 2206 | 0 | 3.272 | -73.0877 | 2021-08-31 04:21:46 | Meta, Colombia | |||
3891783 | 3891783 | 2021-08-29 | Colombia | Meta | 87321 | 2206 | 0 | 3.272 | -73.0877 | 2021-08-30 04:21:23 | Meta, Colombia | |||
2792886 | 2792886 | 2021-08-28 | Colombia | Meta | 87303 | 2206 | 0 | 3.272 | -73.0877 | 2021-08-29 04:21:14 | Meta, Colombia | |||
2923045 | 2923045 | 2021-08-27 | Colombia | Meta | 87271 | 2206 | 0 | 3.272 | -73.0877 | 2021-08-28 04:21:28 | Meta, Colombia | |||
1596059 | 1596059 | 2021-08-26 | Colombia | Meta | 87242 | 2206 | 0 | 3.272 | -73.0877 | 2021-08-27 04:21:37 | Meta, Colombia | |||
32268 | 32268 | 2021-08-25 | Colombia | Meta | 87202 | 2203 | 0 | 3.272 | -73.0877 | 2021-08-26 04:21:28 | Meta, Colombia | |||
3105307 | 3105307 | 2021-08-24 | Colombia | Meta | 87202 | 2202 | 0 | 3.272 | -73.0877 | 2021-08-25 04:21:41 | Meta, Colombia | |||
3165478 | 3165478 | 2021-08-23 | Colombia | Meta | 87178 | 2202 | 0 | 3.272 | -73.0877 | 2021-08-24 04:21:19 | Meta, Colombia | |||
2175405 | 2175405 | 2021-08-22 | Colombia | Meta | 87105 | 2200 | 0 | 3.272 | -73.0877 | 2021-08-23 04:21:27 | Meta, Colombia | |||
3555501 | 3555501 | 2021-08-21 | Colombia | Meta | 87082 | 2192 | 0 | 3.272 | -73.0877 | 2021-08-22 04:21:29 | Meta, Colombia | |||
1853843 | 1853843 | 2021-08-20 | Colombia | Meta | 87038 | 2192 | 0 | 3.272 | -73.0877 | 2021-08-21 04:21:38 | Meta, Colombia | |||
511550 | 511550 | 2021-08-19 | Colombia | Meta | 86994 | 2191 | 0 | 3.272 | -73.0877 | 2021-08-20 04:21:33 | Meta, Colombia | |||
2518029 | 2518029 | 2021-08-18 | Colombia | Meta | 86951 | 2185 | 0 | 3.272 | -73.0877 | 2021-08-19 04:21:15 | Meta, Colombia | |||
245121 | 245121 | 2021-08-17 | Colombia | Meta | 86886 | 2184 | 0 | 3.272 | -73.0877 | 2021-08-18 04:21:35 | Meta, Colombia | |||
1604084 | 1604084 | 2021-08-16 | Colombia | Meta | 86865 | 2183 | 0 | 3.272 | -73.0877 | 2021-08-17 04:21:49 | Meta, Colombia | |||
103178 | 103178 | 2021-08-15 | Colombia | Meta | 86750 | 2180 | 0 | 3.272 | -73.0877 | 2021-08-16 04:21:31 | Meta, Colombia | |||
507536 | 507536 | 2021-08-14 | Colombia | Meta | 86750 | 2180 | 0 | 3.272 | -73.0877 | 2021-08-15 04:21:41 | Meta, Colombia | |||
1483408 | 1483408 | 2021-08-13 | Colombia | Meta | 86700 | 2177 | 0 | 3.272 | -73.0877 | 2021-08-14 04:21:25 | Meta, Colombia | |||
2899538 | 2899538 | 2021-08-12 | Colombia | Meta | 86642 | 2173 | 0 | 3.272 | -73.0877 | 2021-08-13 04:21:24 | Meta, Colombia | |||
1342142 | 1342142 | 2021-08-11 | Colombia | Meta | 86557 | 2171 | 0 | 3.272 | -73.0877 | 2021-08-12 04:21:25 | Meta, Colombia | |||
2351289 | 2351289 | 2021-08-10 | Colombia | Meta | 86476 | 2170 | 0 | 3.272 | -73.0877 | 2021-08-11 04:21:58 | Meta, Colombia | |||
649818 | 649818 | 2021-08-09 | Colombia | Meta | 86414 | 2169 | 0 | 3.272 | -73.0877 | 2021-08-10 04:21:27 | Meta, Colombia | |||
589480 | 589480 | 2021-08-08 | Colombia | Meta | 86349 | 2166 | 0 | 3.272 | -73.0877 | 2021-08-09 04:21:24 | Meta, Colombia | |||
2203492 | 2203492 | 2021-08-07 | Colombia | Meta | 86294 | 2157 | 0 | 3.272 | -73.0877 | 2021-08-08 04:21:33 | Meta, Colombia | |||
1117442 | 1117442 | 2021-08-06 | Colombia | Meta | 86176 | 2156 | 0 | 3.272 | -73.0877 | 2021-08-07 04:21:30 | Meta, Colombia | |||
1956379 | 1956379 | 2021-08-05 | Colombia | Meta | 86087 | 2148 | 0 | 3.272 | -73.0877 | 2021-08-06 04:21:18 | Meta, Colombia | |||
331758 | 331758 | 2021-08-04 | Colombia | Meta | 85865 | 2139 | 82668 | 1058 | 3.272 | -73.0877 | 2021-08-05 04:21:51 | Meta, Colombia | ||
3468029 | 3468029 | 2021-08-03 | Colombia | Meta | 85744 | 2134 | 82507 | 1103 | 3.272 | -73.0877 | 2021-08-04 04:21:25 | Meta, Colombia | ||
3683303 | 3683303 | 2021-08-02 | Colombia | Meta | 85638 | 2125 | 82403 | 1110 | 3.272 | -73.0877 | 2021-08-03 04:21:39 | Meta, Colombia | ||
3015202 | 3015202 | 2021-08-01 | Colombia | Meta | 85524 | 2118 | 82247 | 1159 | 3.272 | -73.0877 | 2021-08-02 04:21:36 | Meta, Colombia | ||
3903825 | 3903825 | 2021-07-31 | Colombia | Meta | 85365 | 2105 | 82147 | 1113 | 3.272 | -73.0877 | 2021-08-01 04:21:50 | Meta, Colombia | ||
3296030 | 3296030 | 2021-07-30 | Colombia | Meta | 85227 | 2098 | 82038 | 1091 | 3.272 | -73.0877 | 2021-07-31 04:21:35 | Meta, Colombia | ||
3385241 | 3385241 | 2021-07-29 | Colombia | Meta | 85086 | 2086 | 81895 | 1105 | 3.272 | -73.0877 | 2021-07-30 04:21:34 | Meta, Colombia | ||
408146 | 408146 | 2021-07-28 | Colombia | Meta | 84920 | 2081 | 81664 | 1175 | 3.272 | -73.0877 | 2021-07-29 04:21:33 | Meta, Colombia | ||
1306007 | 1306007 | 2021-07-27 | Colombia | Meta | 84721 | 2074 | 81401 | 1246 | 3.272 | -73.0877 | 2021-07-28 04:21:39 | Meta, Colombia | ||
3218150 | 3218150 | 2021-07-26 | Colombia | Meta | 84571 | 2066 | 81159 | 1346 | 3.272 | -73.0877 | 2021-07-27 04:21:18 | Meta, Colombia | ||
1378359 | 1378359 | 2021-07-25 | Colombia | Meta | 84363 | 2053 | 80894 | 1416 | 3.272 | -73.0877 | 2021-07-26 04:21:28 | Meta, Colombia | ||
1330099 | 1330099 | 2021-07-24 | Colombia | Meta | 84147 | 2043 | 80565 | 1539 | 3.272 | -73.0877 | 2021-07-25 04:22:12 | Meta, Colombia | ||
3137403 | 3137403 | 2021-07-23 | Colombia | Meta | 83547 | 2026 | 79978 | 1543 | 3.272 | -73.0877 | 2021-07-24 00:21:36 | Meta, Colombia | ||
3476163 | 3476163 | 2021-07-22 | Colombia | Meta | 83547 | 2026 | 79978 | 1543 | 3.272 | -73.0877 | 2021-07-23 04:21:29 | Meta, Colombia | ||
3331382 | 3331382 | 2021-07-21 | Colombia | Meta | 83345 | 2017 | 79645 | 1683 | 3.272 | -73.0877 | 2021-07-22 04:21:19 | Meta, Colombia | ||
2371363 | 2371363 | 2021-07-20 | Colombia | Meta | 81565 | 2000 | 79295 | 270 | 3.272 | -73.0877 | 2021-07-21 04:21:40 | Meta, Colombia | ||
483442 | 483442 | 2021-07-19 | Colombia | Meta | 81254 | 1988 | 78416 | 850 | 3.272 | -73.0877 | 2021-07-20 04:21:48 | Meta, Colombia | ||
2673665 | 2673665 | 2021-07-18 | Colombia | Meta | 81254 | 1974 | 77841 | 1439 | 3.272 | -73.0877 | 2021-07-19 04:21:24 | Meta, Colombia | ||
3705977 | 3705977 | 2021-07-17 | Colombia | Meta | 81254 | 1962 | 77703 | 1589 | 3.272 | -73.0877 | 2021-07-18 04:22:07 | Meta, Colombia | ||
2947208 | 2947208 | 2021-07-16 | Colombia | Meta | 81097 | 1951 | 77387 | 1759 | 3.272 | -73.0877 | 2021-07-17 04:22:22 | Meta, Colombia | ||
295864 | 295864 | 2021-07-15 | Colombia | Meta | 80629 | 1933 | 77169 | 1527 | 3.272 | -73.0877 | 2021-07-16 04:21:22 | Meta, Colombia | ||
3631809 | 3631809 | 2021-07-14 | Colombia | Meta | 80310 | 1921 | 76756 | 1633 | 3.272 | -73.0877 | 2021-07-15 04:21:48 | Meta, Colombia | ||
578684 | 578684 | 2021-07-13 | Colombia | Meta | 79882 | 1902 | 76525 | 1455 | 3.272 | -73.0877 | 2021-07-14 04:21:35 | Meta, Colombia | ||
3740933 | 3740933 | 2021-07-12 | Colombia | Meta | 78977 | 1891 | 75875 | 1211 | 3.272 | -73.0877 | 2021-07-13 04:21:18 | Meta, Colombia | ||
3659446 | 3659446 | 2021-07-11 | Colombia | Meta | 78985 | 1852 | 74848 | 2285 | 3.272 | -73.0877 | 2021-07-12 04:21:34 | Meta, Colombia | ||
625730 | 625730 | 2021-07-10 | Colombia | Meta | 78771 | 1852 | 74848 | 2071 | 3.272 | -73.0877 | 2021-07-11 04:21:43 | Meta, Colombia | ||
829449 | 829449 | 2021-07-09 | Colombia | Meta | 78343 | 1852 | 73946 | 2545 | 3.272 | -73.0877 | 2021-07-10 04:21:25 | Meta, Colombia | ||
778213 | 778213 | 2021-07-08 | Colombia | Meta | 78015 | 1838 | 73946 | 2231 | 3.272 | -73.0877 | 2021-07-09 04:21:21 | Meta, Colombia | ||
1440435 | 1440435 | 2021-07-07 | Colombia | Meta | 77400 | 1824 | 73306 | 2270 | 3.272 | -73.0877 | 2021-07-08 04:21:26 | Meta, Colombia | ||
2693540 | 2693540 | 2021-07-06 | Colombia | Meta | 76865 | 1811 | 72984 | 2070 | 3.272 | -73.0877 | 2021-07-07 04:21:20 | Meta, Colombia | ||
1932289 | 1932289 | 2021-07-05 | Colombia | Meta | 76060 | 1786 | 71683 | 2591 | 3.272 | -73.0877 | 2021-07-06 04:21:32 | Meta, Colombia | ||
1165020 | 1165020 | 2021-07-04 | Colombia | Meta | 75006 | 1762 | 70614 | 2630 | 3.272 | -73.0877 | 2021-07-05 04:21:28 | Meta, Colombia | ||
1495454 | 1495454 | 2021-07-03 | Colombia | Meta | 73936 | 1745 | 69848 | 2343 | 3.272 | -73.0877 | 2021-07-04 04:21:38 | Meta, Colombia | ||
2071769 | 2071769 | 2021-07-02 | Colombia | Meta | 73118 | 1732 | 69401 | 1985 | 3.272 | -73.0877 | 2021-07-03 04:21:37 | Meta, Colombia | ||
2764785 | 2764785 | 2021-07-01 | Colombia | Meta | 72763 | 1723 | 69022 | 2018 | 3.272 | -73.0877 | 2021-07-02 04:21:47 | Meta, Colombia | ||
1892993 | 1892993 | 2021-06-30 | Colombia | Meta | 72402 | 1709 | 68576 | 2117 | 3.272 | -73.0877 | 2021-07-01 04:21:19 | Meta, Colombia | ||
400116 | 400116 | 2021-06-29 | Colombia | Meta | 72156 | 1687 | 67418 | 3051 | 3.272 | -73.0877 | 2021-06-30 04:21:41 | Meta, Colombia | ||
3125359 | 3125359 | 2021-06-28 | Colombia | Meta | 70878 | 1668 | 65833 | 3377 | 3.272 | -73.0877 | 2021-06-29 04:21:28 | Meta, Colombia | ||
2589854 | 2589854 | 2021-06-27 | Colombia | Meta | 69295 | 1649 | 65091 | 2555 | 3.272 | -73.0877 | 2021-06-28 04:21:29 | Meta, Colombia | ||
3958358 | 3958358 | 2021-06-26 | Colombia | Meta | 68398 | 1629 | 64606 | 2163 | 3.272 | -73.0877 | 2021-06-27 04:21:39 | Meta, Colombia | ||
1712177 | 1712177 | 2021-06-25 | Colombia | Meta | 67667 | 1616 | 63918 | 2133 | 3.272 | -73.0877 | 2021-06-26 04:21:43 | Meta, Colombia | ||
2295302 | 2295302 | 2021-06-24 | Colombia | Meta | 67025 | 1597 | 63509 | 1919 | 3.272 | -73.0877 | 2021-06-25 04:21:33 | Meta, Colombia | ||
2422742 | 2422742 | 2021-06-23 | Colombia | Meta | 66493 | 1581 | 63039 | 1873 | 3.272 | -73.0877 | 2021-06-24 04:21:55 | Meta, Colombia | ||
562819 | 562819 | 2021-06-22 | Colombia | Meta | 66017 | 1561 | 62287 | 2169 | 3.272 | -73.0877 | 2021-06-23 04:21:46 | Meta, Colombia | ||
3358521 | 3358521 | 2021-06-21 | Colombia | Meta | 65207 | 1538 | 61485 | 2184 | 3.272 | -73.0877 | 2021-06-22 04:21:34 | Meta, Colombia | ||
2884220 | 2884220 | 2021-06-20 | Colombia | Meta | 64504 | 1507 | 60801 | 2196 | 3.272 | -73.0877 | 2021-06-21 04:21:41 | Meta, Colombia | ||
107303 | 107303 | 2021-06-19 | Colombia | Meta | 63700 | 1492 | 60108 | 2100 | 3.272 | -73.0877 | 2021-06-20 04:21:48 | Meta, Colombia | ||
1125446 | 1125446 | 2021-06-18 | Colombia | Meta | 63115 | 1470 | 59696 | 1949 | 3.272 | -73.0877 | 2021-06-19 04:22:33 | Meta, Colombia | ||
2911024 | 2911024 | 2021-06-17 | Colombia | Meta | 62592 | 1454 | 59088 | 2050 | 3.272 | -73.0877 | 2021-06-18 04:22:16 | Meta, Colombia | ||
3030142 | 3030142 | 2021-06-16 | Colombia | Meta | 61555 | 1421 | 58137 | 1997 | 3.272 | -73.0877 | 2021-06-17 04:22:36 | Meta, Colombia | ||
2339248 | 2339248 | 2021-06-15 | Colombia | Meta | 59565 | 1406 | 57235 | 924 | 3.272 | -73.0877 | 2021-06-16 04:22:32 | Meta, Colombia | ||
1563944 | 1563944 | 2021-06-14 | Colombia | Meta | 59565 | 1406 | 57235 | 924 | 3.272 | -73.0877 | 2021-06-15 04:22:22 | Meta, Colombia | ||
3381227 | 3381227 | 2021-06-13 | Colombia | Meta | 59565 | 1390 | 56461 | 1714 | 3.272 | -73.0877 | 2021-06-14 04:22:46 | Meta, Colombia | ||
1736361 | 1736361 | 2021-06-12 | Colombia | Meta | 59565 | 1381 | 55999 | 2185 | 3.272 | -73.0877 | 2021-06-13 04:22:44 | Meta, Colombia | ||
3970402 | 3970402 | 2021-06-11 | Colombia | Meta | 58820 | 1365 | 55566 | 1889 | 3.272 | -73.0877 | 2021-06-12 04:22:22 | Meta, Colombia | ||
2716824 | 2716824 | 2021-06-10 | Colombia | Meta | 57975 | 1347 | 54981 | 1647 | 3.272 | -73.0877 | 2021-06-11 04:23:20 | Meta, Colombia | ||
522709 | 522709 | 2021-06-09 | Colombia | Meta | 57430 | 1332 | 54451 | 1647 | 3.272 | -73.0877 | 2021-06-10 04:23:17 | Meta, Colombia | ||
3472149 | 3472149 | 2021-06-08 | Colombia | Meta | 56581 | 1311 | 53927 | 1343 | 3.272 | -73.0877 | 2021-06-09 04:23:31 | Meta, Colombia | ||
3145433 | 3145433 | 2021-06-07 | Colombia | Meta | 56581 | 1311 | 53927 | 1343 | 3.272 | -73.0877 | 2021-06-08 04:22:35 | Meta, 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]);