daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Capital District" sorted by latitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, last_update, day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▲ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Colombia | Capital District | 1463367 | 27635 | 0 | 4.711 | -74.0721 | 2021-12-03 04:23:05 | Capital District, Colombia | |||
2021-10-28 | Colombia | Capital District | 1454485 | 27547 | 0 | 4.711 | -74.0721 | 2021-10-29 04:22:03 | Capital District, Colombia | |||
2020-10-25 | Colombia | Capital District | 309903 | 7490 | 277868 | 24545 | 4.711 | -74.0721 | 2020-10-26 04:25:02 | Capital District, Colombia | ||
2021-01-26 | Colombia | Capital District | 595731 | 12095 | 536064 | 47572 | 4.711 | -74.0721 | 2021-01-27 05:23:41 | Capital District, Colombia | ||
2021-09-18 | Colombia | Capital District | 1447491 | 27441 | 0 | 4.711 | -74.0721 | 2021-09-19 04:21:34 | Capital District, Colombia | |||
2021-05-28 | Colombia | Capital District | 942368 | 18553 | 862145 | 61670 | 4.711 | -74.0721 | 2021-05-29 04:20:41 | Capital District, Colombia | ||
2022-03-20 | Colombia | Capital District | 1764497 | 29304 | 0 | 4.711 | -74.0721 | 2022-03-21 04:20:50 | Capital District, Colombia | |||
2021-11-11 | Colombia | Capital District | 1457399 | 27574 | 0 | 4.711 | -74.0721 | 2021-11-12 04:22:01 | Capital District, Colombia | |||
2021-08-25 | Colombia | Capital District | 1438030 | 27242 | 0 | 4.711 | -74.0721 | 2021-08-26 04:21:28 | Capital District, Colombia | |||
2021-04-12 | Colombia | Capital District | 713559 | 14706 | 675448 | 23405 | 4.711 | -74.0721 | 2021-04-13 04:20:37 | Capital District, Colombia | ||
2021-11-02 | Colombia | Capital District | 1455372 | 27555 | 0 | 4.711 | -74.0721 | 2021-11-03 06:22:09 | Capital District, Colombia | |||
2021-05-29 | Colombia | Capital District | 951083 | 18683 | 869117 | 63283 | 4.711 | -74.0721 | 2021-05-30 04:20:55 | Capital District, Colombia | ||
2021-03-07 | Colombia | Capital District | 663603 | 13980 | 638247 | 11376 | 4.711 | -74.0721 | 2021-03-08 05:24:48 | Capital District, Colombia | ||
2020-07-23 | Colombia | Capital District | 74599 | 1905 | 29333 | 43361 | 4.711 | -74.0721 | 2020-07-24 05:30:40 | Capital District, Colombia | ||
2022-11-12 | Colombia | Capital District | 1855114 | 29845 | 0 | 4.711 | -74.0721 | 2022-11-13 04:21:14 | Capital District, Colombia | |||
2021-09-01 | Colombia | Capital District | 1441483 | 27321 | 0 | 4.711 | -74.0721 | 2021-09-02 04:21:15 | Capital District, Colombia | |||
2022-02-07 | Colombia | Capital District | 1720356 | 28509 | 0 | 4.711 | -74.0721 | 2022-02-08 04:21:15 | Capital District, Colombia | |||
2020-12-03 | Colombia | Capital District | 382704 | 8634 | 351110 | 22960 | 4.711 | -74.0721 | 2020-12-04 05:27:27 | Capital District, Colombia | ||
2020-10-14 | Colombia | Capital District | 291544 | 7186 | 258316 | 26042 | 4.711 | -74.0721 | 2020-10-15 04:24:28 | Capital District, Colombia | ||
2021-05-25 | Colombia | Capital District | 916103 | 18221 | 845333 | 52549 | 4.711 | -74.0721 | 2021-05-26 04:20:35 | Capital District, Colombia | ||
2021-11-09 | Colombia | Capital District | 1456819 | 27571 | 0 | 4.711 | -74.0721 | 2021-11-10 04:21:38 | Capital District, Colombia | |||
2022-07-23 | Colombia | Capital District | 1820163 | 29562 | 0 | 4.711 | -74.0721 | 2022-07-24 04:20:47 | Capital District, Colombia | |||
2020-08-04 | Colombia | Capital District | 113548 | 3169 | 55013 | 55366 | 4.711 | -74.0721 | 2020-08-05 04:34:43 | Capital District, Colombia | ||
2022-01-14 | Colombia | Capital District | 1555037 | 27789 | 0 | 4.711 | -74.0721 | 2022-01-15 04:21:07 | Capital District, Colombia | |||
2021-08-15 | Colombia | Capital District | 1431941 | 27078 | 0 | 4.711 | -74.0721 | 2021-08-16 04:21:31 | Capital District, Colombia | |||
2021-06-19 | Colombia | Capital District | 1147845 | 21720 | 1045932 | 80193 | 4.711 | -74.0721 | 2021-06-20 04:21:48 | Capital District, Colombia | ||
2022-09-06 | Colombia | Capital District | 1851673 | 29795 | 0 | 4.711 | -74.0721 | 2022-09-07 04:20:59 | Capital District, Colombia | |||
2020-07-19 | Colombia | Capital District | 63265 | 1555 | 24447 | 37263 | 4.711 | -74.0721 | 2020-07-20 05:34:40 | Capital District, Colombia | ||
2020-11-18 | Colombia | Capital District | 351876 | 8175 | 325176 | 18525 | 4.711 | -74.0721 | 2020-11-19 05:25:23 | Capital District, Colombia | ||
2022-01-09 | Colombia | Capital District | 1521045 | 27752 | 0 | 4.711 | -74.0721 | 2022-01-10 04:22:07 | Capital District, Colombia | |||
2022-10-04 | Colombia | Capital District | 1852960 | 29826 | 0 | 4.711 | -74.0721 | 2022-10-05 04:23:06 | Capital District, Colombia | |||
2021-12-04 | Colombia | Capital District | 1463971 | 27639 | 0 | 4.711 | -74.0721 | 2021-12-05 04:22:25 | Capital District, Colombia | |||
2022-07-09 | Colombia | Capital District | 1812958 | 29479 | 0 | 4.711 | -74.0721 | 2022-07-10 04:20:54 | Capital District, Colombia | |||
2020-08-15 | Colombia | Capital District | 158674 | 4269 | 87444 | 66961 | 4.711 | -74.0721 | 2020-08-16 04:27:42 | Capital District, Colombia | ||
2021-11-29 | Colombia | Capital District | 1462574 | 27616 | 0 | 4.711 | -74.0721 | 2021-11-30 04:22:53 | Capital District, Colombia | |||
2021-01-08 | Colombia | Capital District | 507768 | 10387 | 453954 | 43427 | 4.711 | -74.0721 | 2021-01-09 05:22:18 | Capital District, Colombia | ||
2022-03-29 | Colombia | Capital District | 1765739 | 29331 | 0 | 4.711 | -74.0721 | 2022-03-30 04:20:45 | Capital District, Colombia | |||
2021-11-19 | Colombia | Capital District | 1459654 | 27599 | 0 | 4.711 | -74.0721 | 2021-11-20 04:22:17 | Capital District, Colombia | |||
2022-06-21 | Colombia | Capital District | 1786328 | 29392 | 0 | 4.711 | -74.0721 | 2022-06-22 04:20:54 | Capital District, Colombia | |||
2021-04-16 | Colombia | Capital District | 729061 | 14820 | 681408 | 32833 | 4.711 | -74.0721 | 2021-04-17 04:20:40 | Capital District, Colombia | ||
2020-07-27 | Colombia | Capital District | 86857 | 2307 | 37916 | 46634 | 4.711 | -74.0721 | 2020-07-28 04:58:43 | Capital District, Colombia | ||
2021-09-02 | Colombia | Capital District | 1441891 | 27341 | 0 | 4.711 | -74.0721 | 2021-09-03 04:21:20 | Capital District, Colombia | |||
2021-02-21 | Colombia | Capital District | 650932 | 13643 | 621069 | 16220 | 4.711 | -74.0721 | 2021-02-22 05:24:21 | Capital District, Colombia | ||
2022-02-13 | Colombia | Capital District | 1738131 | 28762 | 0 | 4.711 | -74.0721 | 2022-02-14 04:20:51 | Capital District, Colombia | |||
2021-01-11 | Colombia | Capital District | 522621 | 10650 | 461805 | 50166 | 4.711 | -74.0721 | 2021-01-12 05:22:15 | Capital District, Colombia | ||
2020-08-31 | Colombia | Capital District | 211300 | 5437 | 151131 | 54732 | 4.711 | -74.0721 | 2020-09-01 04:28:31 | Capital District, Colombia | ||
2022-10-19 | Colombia | Capital District | 1853764 | 29831 | 0 | 4.711 | -74.0721 | 2022-10-20 04:22:59 | Capital District, Colombia | |||
2020-12-25 | Colombia | Capital District | 447821 | 9437 | 401986 | 36398 | 4.711 | -74.0721 | 2020-12-26 05:22:28 | Capital District, Colombia | ||
2020-08-19 | Colombia | Capital District | 176336 | 4587 | 106822 | 64927 | 4.711 | -74.0721 | 2020-08-20 04:27:43 | Capital District, Colombia | ||
2020-10-29 | Colombia | Capital District | 314687 | 7567 | 286402 | 20718 | 4.711 | -74.0721 | 2020-10-30 04:24:49 | Capital District, Colombia | ||
2020-06-08 | Colombia | Capital District | 13329 | 335 | 5682 | 7312 | 4.711 | -74.0721 | 2020-06-09 03:33:03 | Capital District, Colombia | ||
2022-12-26 | Colombia | Capital District | 1862342 | 29902 | 0 | 4.711 | -74.0721 | 2022-12-27 04:21:07 | Capital District, Colombia | |||
2022-05-09 | Colombia | Capital District | 1769503 | 29368 | 0 | 4.711 | -74.0721 | 2022-05-10 04:20:50 | Capital District, Colombia | |||
2022-05-31 | Colombia | Capital District | 1773819 | 29376 | 0 | 4.711 | -74.0721 | 2022-06-01 04:20:55 | Capital District, Colombia | |||
2022-02-11 | Colombia | Capital District | 1732976 | 28657 | 0 | 4.711 | -74.0721 | 2022-02-12 04:21:06 | Capital District, Colombia | |||
2021-01-18 | Colombia | Capital District | 560284 | 11347 | 503530 | 45407 | 4.711 | -74.0721 | 2021-01-19 05:22:15 | Capital District, Colombia | ||
2021-04-02 | Colombia | Capital District | 690844 | 14445 | 661802 | 14597 | 4.711 | -74.0721 | 2021-04-03 04:20:44 | Capital District, Colombia | ||
2021-08-17 | Colombia | Capital District | 1434287 | 27135 | 0 | 4.711 | -74.0721 | 2021-08-18 04:21:35 | Capital District, Colombia | |||
2021-09-04 | Colombia | Capital District | 1442868 | 27355 | 0 | 4.711 | -74.0721 | 2021-09-05 04:21:33 | Capital District, Colombia | |||
2022-09-08 | Colombia | Capital District | 1852256 | 29795 | 0 | 4.711 | -74.0721 | 2022-09-09 04:21:11 | Capital District, Colombia | |||
2022-12-10 | Colombia | Capital District | 1857342 | 29868 | 0 | 4.711 | -74.0721 | 2022-12-11 04:20:50 | Capital District, Colombia | |||
2022-03-15 | Colombia | Capital District | 1762994 | 29255 | 0 | 4.711 | -74.0721 | 2022-03-16 04:20:50 | Capital District, Colombia | |||
2020-11-10 | Colombia | Capital District | 338196 | 7956 | 311652 | 18588 | 4.711 | -74.0721 | 2020-11-11 05:25:30 | Capital District, Colombia | ||
2021-11-03 | Colombia | Capital District | 1455552 | 27558 | 0 | 4.711 | -74.0721 | 2021-11-04 04:22:20 | Capital District, Colombia | |||
2021-02-24 | Colombia | Capital District | 654204 | 13734 | 625619 | 14851 | 4.711 | -74.0721 | 2021-02-25 05:24:57 | Capital District, Colombia | ||
2020-06-15 | Colombia | Capital District | 16404 | 416 | 6885 | 9103 | 4.711 | -74.0721 | 2020-06-16 04:33:09 | Capital District, Colombia | ||
2021-10-31 | Colombia | Capital District | 1455114 | 27550 | 0 | 4.711 | -74.0721 | 2021-11-01 04:22:01 | Capital District, Colombia | |||
2022-11-15 | Colombia | Capital District | 1855114 | 29845 | 0 | 4.711 | -74.0721 | 2022-11-16 04:21:09 | Capital District, Colombia | |||
2021-07-15 | Colombia | Capital District | 1358292 | 25468 | 1281867 | 50957 | 4.711 | -74.0721 | 2021-07-16 04:21:22 | Capital District, Colombia | ||
2020-07-01 | Colombia | Capital District | 30017 | 713 | 12756 | 16548 | 4.711 | -74.0721 | 2020-07-02 04:33:46 | Capital District, Colombia | ||
2022-04-16 | Colombia | Capital District | 1767928 | 29358 | 0 | 4.711 | -74.0721 | 2022-04-17 04:20:59 | Capital District, Colombia | |||
2022-12-13 | Colombia | Capital District | 1857342 | 29868 | 0 | 4.711 | -74.0721 | 2022-12-14 04:21:04 | Capital District, Colombia | |||
2022-11-13 | Colombia | Capital District | 1855114 | 29845 | 0 | 4.711 | -74.0721 | 2022-11-14 04:21:09 | Capital District, Colombia | |||
2022-02-12 | Colombia | Capital District | 1735693 | 28684 | 0 | 4.711 | -74.0721 | 2022-02-13 04:21:00 | Capital District, Colombia | |||
2022-10-30 | Colombia | Capital District | 1854344 | 29839 | 0 | 4.711 | -74.0721 | 2022-10-31 04:21:36 | Capital District, Colombia | |||
2020-07-20 | Colombia | Capital District | 65594 | 1627 | 25614 | 38353 | 4.711 | -74.0721 | 2020-07-21 04:38:46 | Capital District, Colombia | ||
2022-12-27 | Colombia | Capital District | 1862342 | 29902 | 0 | 4.711 | -74.0721 | 2022-12-28 04:21:04 | Capital District, Colombia | |||
2021-08-04 | Colombia | Capital District | 1420779 | 26797 | 1369593 | 24389 | 4.711 | -74.0721 | 2021-08-05 04:21:51 | Capital District, Colombia | ||
2022-03-18 | Colombia | Capital District | 1763889 | 29283 | 0 | 4.711 | -74.0721 | 2022-03-19 04:20:47 | Capital District, Colombia | |||
2021-02-03 | Colombia | Capital District | 622916 | 12841 | 577566 | 32509 | 4.711 | -74.0721 | 2021-02-04 05:22:26 | Capital District, Colombia | ||
2020-09-14 | Colombia | Capital District | 242007 | 6229 | 197710 | 38068 | 4.711 | -74.0721 | 2020-09-15 03:22:50 | Capital District, Colombia | ||
2022-12-14 | Colombia | Capital District | 1857342 | 29868 | 0 | 4.711 | -74.0721 | 2022-12-15 04:20:58 | Capital District, Colombia | |||
2021-03-11 | Colombia | Capital District | 666431 | 14028 | 641525 | 10878 | 4.711 | -74.0721 | 2021-03-12 05:26:50 | Capital District, Colombia | ||
2022-03-11 | Colombia | Capital District | 1762123 | 29233 | 0 | 4.711 | -74.0721 | 2022-03-12 04:20:50 | Capital District, Colombia | |||
2022-05-07 | Colombia | Capital District | 1769503 | 29368 | 0 | 4.711 | -74.0721 | 2022-05-08 04:20:49 | Capital District, Colombia | |||
2020-07-16 | Colombia | Capital District | 55056 | 1376 | 19668 | 34012 | 4.711 | -74.0721 | 2020-07-17 04:34:50 | Capital District, Colombia | ||
2020-08-08 | Colombia | Capital District | 129975 | 3578 | 61188 | 65209 | 4.711 | -74.0721 | 2020-08-09 04:34:54 | Capital District, Colombia | ||
2022-09-13 | Colombia | Capital District | 1852256 | 29808 | 0 | 4.711 | -74.0721 | 2022-09-14 04:20:44 | Capital District, Colombia | |||
2020-11-06 | Colombia | Capital District | 332118 | 7820 | 302972 | 21326 | 4.711 | -74.0721 | 2020-11-07 05:24:52 | Capital District, Colombia | ||
2021-04-30 | Colombia | Capital District | 788109 | 15692 | 728143 | 44274 | 4.711 | -74.0721 | 2021-05-01 04:20:47 | Capital District, Colombia | ||
2022-09-23 | Colombia | Capital District | 1852960 | 29819 | 0 | 4.711 | -74.0721 | 2022-09-24 04:21:40 | Capital District, Colombia | |||
2021-04-04 | Colombia | Capital District | 693578 | 14481 | 664404 | 14693 | 4.711 | -74.0721 | 2021-04-05 04:20:35 | Capital District, Colombia | ||
2020-11-27 | Colombia | Capital District | 369722 | 8449 | 342957 | 18316 | 4.711 | -74.0721 | 2020-11-28 05:25:50 | Capital District, Colombia | ||
2022-10-07 | Colombia | Capital District | 1853689 | 29827 | 0 | 4.711 | -74.0721 | 2022-10-08 04:22:56 | Capital District, Colombia | |||
2021-06-29 | Colombia | Capital District | 1244585 | 23566 | 1134791 | 86228 | 4.711 | -74.0721 | 2021-06-30 04:21:41 | Capital District, Colombia | ||
2021-12-07 | Colombia | Capital District | 1464617 | 27649 | 0 | 4.711 | -74.0721 | 2021-12-08 04:22:46 | Capital District, Colombia | |||
2021-07-28 | Colombia | Capital District | 1405585 | 26459 | 1346804 | 32322 | 4.711 | -74.0721 | 2021-07-29 04:21:33 | Capital District, Colombia | ||
2020-07-05 | Colombia | Capital District | 35266 | 842 | 13771 | 20653 | 4.711 | -74.0721 | 2020-07-06 04:33:57 | Capital District, Colombia | ||
2022-09-18 | Colombia | Capital District | 1852577 | 29817 | 0 | 4.711 | -74.0721 | 2022-09-19 04:21:49 | Capital District, Colombia | |||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;