johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Capital District" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, active, last_update, 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 | |||
16194 | 16194 | 2021-09-18 | Colombia | Capital District | 1447491 | 27441 | 0 | 4.711 | -74.0721 | 2021-09-19 04:21:34 | 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 | |||
43531 | 43531 | 2021-11-02 | Colombia | Capital District | 1455372 | 27555 | 0 | 4.711 | -74.0721 | 2021-11-03 06:22:09 | 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 | |||
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 | |||
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 | |||
114575 | 114575 | 2022-09-06 | Colombia | Capital District | 1851673 | 29795 | 0 | 4.711 | -74.0721 | 2022-09-07 04:20:59 | 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 | |||
149807 | 149807 | 2021-11-29 | Colombia | Capital District | 1462574 | 27616 | 0 | 4.711 | -74.0721 | 2021-11-30 04:22:53 | 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 | |||
177865 | 177865 | 2021-09-02 | Colombia | Capital District | 1441891 | 27341 | 0 | 4.711 | -74.0721 | 2021-09-03 04:21:20 | 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 | |||
198082 | 198082 | 2022-10-19 | Colombia | Capital District | 1853764 | 29831 | 0 | 4.711 | -74.0721 | 2022-10-20 04:22:59 | 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 | |||
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 | |||
276006 | 276006 | 2021-11-03 | Colombia | Capital District | 1455552 | 27558 | 0 | 4.711 | -74.0721 | 2021-11-04 04:22:20 | 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 | |||
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 | |||
327730 | 327730 | 2022-12-27 | Colombia | Capital District | 1862342 | 29902 | 0 | 4.711 | -74.0721 | 2022-12-28 04:21:04 | 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 | |||
348120 | 348120 | 2022-12-14 | Colombia | Capital District | 1857342 | 29868 | 0 | 4.711 | -74.0721 | 2022-12-15 04:20:58 | 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 | |||
372020 | 372020 | 2022-09-13 | Colombia | Capital District | 1852256 | 29808 | 0 | 4.711 | -74.0721 | 2022-09-14 04:20:44 | 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 | |||
396088 | 396088 | 2022-10-07 | Colombia | Capital District | 1853689 | 29827 | 0 | 4.711 | -74.0721 | 2022-10-08 04:22:56 | 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 | |||
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 | |||
431181 | 431181 | 2022-11-03 | Colombia | Capital District | 1854713 | 29839 | 0 | 4.711 | -74.0721 | 2022-11-04 04:22:11 | Capital District, Colombia | |||
443178 | 443178 | 2021-10-20 | Colombia | Capital District | 1452930 | 27530 | 0 | 4.711 | -74.0721 | 2021-10-21 04:21:18 | Capital District, Colombia | |||
447194 | 447194 | 2021-11-17 | Colombia | Capital District | 1459032 | 27590 | 0 | 4.711 | -74.0721 | 2021-11-18 04:21:33 | Capital District, Colombia | |||
451211 | 451211 | 2022-12-21 | Colombia | Capital District | 1859479 | 29881 | 0 | 4.711 | -74.0721 | 2022-12-22 04:20:56 | Capital District, Colombia | |||
459203 | 459203 | 2022-02-02 | Colombia | Capital District | 1696337 | 28329 | 0 | 4.711 | -74.0721 | 2022-02-03 04:21:21 | Capital District, Colombia | |||
463220 | 463220 | 2022-05-02 | Colombia | Capital District | 1769216 | 29367 | 0 | 4.711 | -74.0721 | 2022-05-03 04:21:00 | Capital District, Colombia | |||
467235 | 467235 | 2021-10-07 | Colombia | Capital District | 1450852 | 27497 | 0 | 4.711 | -74.0721 | 2021-10-08 04:21:25 | Capital District, Colombia | |||
475266 | 475266 | 2022-06-26 | Colombia | Capital District | 1795232 | 29409 | 0 | 4.711 | -74.0721 | 2022-06-27 04:21:00 | Capital District, Colombia | |||
479414 | 479414 | 2022-11-08 | Colombia | Capital District | 1854713 | 29843 | 0 | 4.711 | -74.0721 | 2022-11-09 04:21:22 | Capital District, Colombia | |||
487444 | 487444 | 2022-11-25 | Colombia | Capital District | 1855445 | 29857 | 0 | 4.711 | -74.0721 | 2022-11-26 04:21:11 | Capital District, Colombia | |||
491459 | 491459 | 2021-10-14 | Colombia | Capital District | 1451991 | 27516 | 0 | 4.711 | -74.0721 | 2021-10-15 04:21:26 | Capital District, Colombia | |||
495475 | 495475 | 2021-11-06 | Colombia | Capital District | 1456130 | 27562 | 0 | 4.711 | -74.0721 | 2021-11-07 04:21:53 | Capital District, Colombia | |||
499492 | 499492 | 2022-04-02 | Colombia | Capital District | 1766333 | 29344 | 0 | 4.711 | -74.0721 | 2022-04-03 04:20:48 | Capital District, Colombia | |||
503508 | 503508 | 2022-12-17 | Colombia | Capital District | 1859479 | 29881 | 0 | 4.711 | -74.0721 | 2022-12-18 04:21:03 | Capital District, Colombia | |||
507523 | 507523 | 2021-08-14 | Colombia | Capital District | 1431941 | 27067 | 0 | 4.711 | -74.0721 | 2021-08-15 04:21:41 | Capital District, Colombia | |||
511537 | 511537 | 2021-08-19 | Colombia | Capital District | 1435462 | 27164 | 0 | 4.711 | -74.0721 | 2021-08-20 04:21:33 | Capital District, Colombia | |||
515552 | 515552 | 2022-10-15 | Colombia | Capital District | 1853764 | 29831 | 0 | 4.711 | -74.0721 | 2022-10-16 04:22:39 | Capital District, Colombia | |||
534559 | 534559 | 2021-10-27 | Colombia | Capital District | 1454273 | 27545 | 0 | 4.711 | -74.0721 | 2021-10-28 04:22:08 | Capital District, Colombia | |||
538576 | 538576 | 2022-10-26 | Colombia | Capital District | 1854155 | 29832 | 0 | 4.711 | -74.0721 | 2022-10-27 04:22:01 | Capital District, Colombia | |||
542592 | 542592 | 2022-12-15 | Colombia | Capital District | 1859479 | 29881 | 0 | 4.711 | -74.0721 | 2022-12-16 04:21:01 | Capital District, Colombia | |||
550597 | 550597 | 2021-12-08 | Colombia | Capital District | 1465449 | 27649 | 0 | 4.711 | -74.0721 | 2021-12-09 04:22:49 | Capital District, Colombia | |||
554613 | 554613 | 2022-01-16 | Colombia | Capital District | 1572383 | 27814 | 0 | 4.711 | -74.0721 | 2022-01-17 04:21:08 | Capital District, Colombia | |||
558630 | 558630 | 2022-06-16 | Colombia | Capital District | 1786328 | 29392 | 0 | 4.711 | -74.0721 | 2022-06-17 04:20:56 | Capital District, Colombia | |||
566927 | 566927 | 2021-10-29 | Colombia | Capital District | 1454669 | 27549 | 0 | 4.711 | -74.0721 | 2021-10-30 04:22:03 | Capital District, Colombia | |||
574656 | 574656 | 2022-02-25 | Colombia | Capital District | 1754910 | 29053 | 0 | 4.711 | -74.0721 | 2022-02-26 04:21:12 | Capital District, Colombia | |||
589467 | 589467 | 2021-08-08 | Colombia | Capital District | 1426815 | 26934 | 0 | 4.711 | -74.0721 | 2021-08-09 04:21:24 | Capital District, Colombia | |||
593482 | 593482 | 2022-07-01 | Colombia | Capital District | 1804112 | 29443 | 0 | 4.711 | -74.0721 | 2022-07-02 04:21:16 | Capital District, Colombia | |||
597497 | 597497 | 2021-10-19 | Colombia | Capital District | 1452753 | 27525 | 0 | 4.711 | -74.0721 | 2021-10-20 04:21:00 | Capital District, Colombia | |||
601513 | 601513 | 2021-09-23 | Colombia | Capital District | 1448564 | 27458 | 0 | 4.711 | -74.0721 | 2021-09-24 04:21:44 | Capital District, Colombia | |||
617686 | 617686 | 2022-11-05 | Colombia | Capital District | 1854713 | 29839 | 0 | 4.711 | -74.0721 | 2022-11-06 04:21:24 | Capital District, Colombia | |||
621702 | 621702 | 2022-05-22 | Colombia | Capital District | 1771946 | 29374 | 0 | 4.711 | -74.0721 | 2022-05-26 04:20:50 | Capital District, Colombia | |||
629732 | 629732 | 2022-07-12 | Colombia | Capital District | 1812958 | 29479 | 0 | 4.711 | -74.0721 | 2022-07-13 04:20:58 | Capital District, Colombia | |||
633747 | 633747 | 2021-10-13 | Colombia | Capital District | 1451840 | 27513 | 0 | 4.711 | -74.0721 | 2021-10-14 04:21:29 | Capital District, Colombia | |||
641777 | 641777 | 2021-09-07 | Colombia | Capital District | 1444105 | 27379 | 0 | 4.711 | -74.0721 | 2021-09-08 04:21:31 | Capital District, Colombia | |||
649805 | 649805 | 2021-08-09 | Colombia | Capital District | 1427741 | 26964 | 0 | 4.711 | -74.0721 | 2021-08-10 04:21:27 | Capital District, Colombia | |||
653819 | 653819 | 2021-10-22 | Colombia | Capital District | 1453423 | 27536 | 0 | 4.711 | -74.0721 | 2021-10-23 04:21:32 | Capital District, Colombia | |||
658138 | 658138 | 2022-05-13 | Colombia | Capital District | 1770337 | 29373 | 0 | 4.711 | -74.0721 | 2022-05-14 04:20:48 | Capital District, Colombia | |||
670123 | 670123 | 2022-07-21 | Colombia | Capital District | 1812958 | 29515 | 0 | 4.711 | -74.0721 | 2022-07-22 04:21:15 | Capital District, Colombia | |||
674139 | 674139 | 2022-07-30 | Colombia | Capital District | 1836197 | 29612 | 0 | 4.711 | -74.0721 | 2022-07-31 04:21:02 | Capital District, Colombia | |||
682164 | 682164 | 2021-10-24 | Colombia | Capital District | 1453783 | 27540 | 0 | 4.711 | -74.0721 | 2021-10-25 04:22:31 | Capital District, Colombia | |||
686180 | 686180 | 2021-11-13 | Colombia | Capital District | 1458048 | 27580 | 0 | 4.711 | -74.0721 | 2021-11-14 04:21:31 | Capital District, Colombia | |||
690197 | 690197 | 2022-12-23 | Colombia | Capital District | 1862342 | 29902 | 0 | 4.711 | -74.0721 | 2022-12-24 04:21:02 | Capital District, Colombia | |||
694213 | 694213 | 2022-03-17 | Colombia | Capital District | 1763515 | 29266 | 0 | 4.711 | -74.0721 | 2022-03-18 04:20:55 | Capital District, Colombia | |||
698228 | 698228 | 2021-11-04 | Colombia | Capital District | 1455736 | 27560 | 0 | 4.711 | -74.0721 | 2021-11-05 04:21:54 | Capital District, Colombia | |||
706258 | 706258 | 2021-09-29 | Colombia | Capital District | 1449562 | 27476 | 0 | 4.711 | -74.0721 | 2021-09-30 04:21:20 | Capital District, Colombia | |||
710274 | 710274 | 2022-11-01 | Colombia | Capital District | 1854344 | 29839 | 0 | 4.711 | -74.0721 | 2022-11-02 04:22:09 | 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]);