home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for johns_hopkins_csse_daily_reports
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

27,667 rows where country_or_region = "Colombia" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state >30

  • Amazonas 813
  • Antioquia 813
  • Arauca 813
  • Atlantico 813
  • Bolivar 813
  • Boyaca 813
  • Caldas 813
  • Capital District 813
  • Caqueta 813
  • Casanare 813
  • Cauca 813
  • Cesar 813
  • Choco 813
  • Cordoba 813
  • Cundinamarca 813
  • Huila 813
  • La Guajira 813
  • Magdalena 813
  • Meta 813
  • Narino 813
  • Norte de Santander 813
  • Putumayo 813
  • Quindio 813
  • Risaralda 813
  • San Andres y Providencia 813
  • Santander 813
  • Sucre 813
  • Tolima 813
  • Valle del Cauca 813
  • Vaupes 813
  • …

country_or_region 1

  • Colombia · 27,667 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
647394 647394 2022-08-18 Colombia Amazonas     7753 265 0   -1.4429 -71.5724 2022-08-19 04:20:54 Amazonas, Colombia
647395 647395 2022-08-18 Colombia Antioquia     941893 18451 0   7.1986 -75.3412 2022-08-19 04:20:54 Antioquia, Colombia
647396 647396 2022-08-18 Colombia Arauca     16772 549 0   7.0762 -70.7105 2022-08-19 04:20:54 Arauca, Colombia
647397 647397 2022-08-18 Colombia Atlantico     415403 10192 0   10.6966 -74.8741 2022-08-19 04:20:54 Atlantico, Colombia
647398 647398 2022-08-18 Colombia Bolivar     202601 3262 0   8.6704 -74.03 2022-08-19 04:20:54 Bolivar, Colombia
647399 647399 2022-08-18 Colombia Boyaca     128831 2845 0   5.4545 -73.362 2022-08-19 04:20:54 Boyaca, Colombia
647400 647400 2022-08-18 Colombia Caldas     119110 2556 0   5.2983 -75.2479 2022-08-19 04:20:54 Caldas, Colombia
647401 647401 2022-08-18 Colombia Capital District     1848809 29742 0   4.711 -74.0721 2022-08-19 04:20:54 Capital District, Colombia
647402 647402 2022-08-18 Colombia Caqueta     25540 1036 0   0.8699 -73.8419 2022-08-19 04:20:54 Caqueta, Colombia
647403 647403 2022-08-18 Colombia Casanare     42670 1018 0   5.7589 -71.5724 2022-08-19 04:20:54 Casanare, Colombia
647404 647404 2022-08-18 Colombia Cauca     75795 1827 0   2.705 -76.826 2022-08-19 04:20:54 Cauca, Colombia
647405 647405 2022-08-18 Colombia Cesar     108498 2679 0   9.3373 -73.6536 2022-08-19 04:20:54 Cesar, Colombia
647406 647406 2022-08-18 Colombia Choco     18798 429 0   5.2528 -76.826 2022-08-19 04:20:54 Choco, Colombia
647407 647407 2022-08-18 Colombia Cordoba     121804 3948 0   8.0493 -75.574 2022-08-19 04:20:54 Cordoba, Colombia
647408 647408 2022-08-18 Colombia Cundinamarca     326776 7351 0   5.026 -74.03 2022-08-19 04:20:54 Cundinamarca, Colombia
647409 647409 2022-08-18 Colombia Guainia     2784 37 0   2.5854 -68.5247 2022-08-19 04:20:54 Guainia, Colombia
647410 647410 2022-08-18 Colombia Guaviare     5638 105 0   1.0654 -73.2603 2022-08-19 04:20:54 Guaviare, Colombia
647411 647411 2022-08-18 Colombia Huila     102873 3564 0   2.5359 -75.5277 2022-08-19 04:20:54 Huila, Colombia
647412 647412 2022-08-18 Colombia La Guajira     57724 1543 0   11.3548 -72.5205 2022-08-19 04:20:54 La Guajira, Colombia
647413 647413 2022-08-18 Colombia Magdalena     117231 3643 0   10.4113 -74.4057 2022-08-19 04:20:54 Magdalena, Colombia
647414 647414 2022-08-18 Colombia Meta     107044 2576 0   3.272 -73.0877 2022-08-19 04:20:54 Meta, Colombia
647415 647415 2022-08-18 Colombia Narino     107206 3371 0   1.2892 -77.3579 2022-08-19 04:20:54 Narino, Colombia
647416 647416 2022-08-18 Colombia Norte de Santander     123728 5153 0   7.9463 -72.8988 2022-08-19 04:20:54 Norte de Santander, Colombia
647417 647417 2022-08-18 Colombia Putumayo     21558 782 0   0.436 -75.5277 2022-08-19 04:20:54 Putumayo, Colombia
647418 647418 2022-08-18 Colombia Quindio     72491 2073 0   4.461 -75.6674 2022-08-19 04:20:54 Quindio, Colombia
647419 647419 2022-08-18 Colombia Risaralda     109189 2493 0   5.3158 -75.9928 2022-08-19 04:20:54 Risaralda, Colombia
647420 647420 2022-08-18 Colombia San Andres y Providencia     10327 156 0   12.5567 -81.7185 2022-08-19 04:20:54 San Andres y Providencia, Colombia
647421 647421 2022-08-18 Colombia Santander     292622 8276 0   6.6437 -73.6536 2022-08-19 04:20:54 Santander, Colombia
647422 647422 2022-08-18 Colombia Sucre     66854 1738 0   8.814 -74.7233 2022-08-19 04:20:54 Sucre, Colombia
647423 647423 2022-08-18 Colombia Tolima     126648 4057 0   4.0925 -75.1545 2022-08-19 04:20:54 Tolima, Colombia
647424 647424 2022-08-18 Colombia Unknown     0 300 0       2022-08-19 04:20:54 Unknown, Colombia
647425 647425 2022-08-18 Colombia Valle del Cauca     562768 15304 0   3.8009 -76.6413 2022-08-19 04:20:54 Valle del Cauca, Colombia
647426 647426 2022-08-18 Colombia Vaupes     1943 22 0   0.8554 -70.812 2022-08-19 04:20:54 Vaupes, Colombia
647427 647427 2022-08-18 Colombia Vichada     3449 63 0   4.4234 -69.2878 2022-08-19 04:20:54 Vichada, Colombia
2706166 2706166 2022-08-17 Colombia Amazonas     7725 265 0   -1.4429 -71.5724 2022-08-18 04:21:11 Amazonas, Colombia
2706167 2706167 2022-08-17 Colombia Antioquia     941089 18442 0   7.1986 -75.3412 2022-08-18 04:21:11 Antioquia, Colombia
2706168 2706168 2022-08-17 Colombia Arauca     16753 549 0   7.0762 -70.7105 2022-08-18 04:21:11 Arauca, Colombia
2706169 2706169 2022-08-17 Colombia Atlantico     415236 10187 0   10.6966 -74.8741 2022-08-18 04:21:11 Atlantico, Colombia
2706170 2706170 2022-08-17 Colombia Bolivar     202566 3261 0   8.6704 -74.03 2022-08-18 04:21:11 Bolivar, Colombia
2706171 2706171 2022-08-17 Colombia Boyaca     128725 2840 0   5.4545 -73.362 2022-08-18 04:21:11 Boyaca, Colombia
2706172 2706172 2022-08-17 Colombia Caldas     119053 2554 0   5.2983 -75.2479 2022-08-18 04:21:11 Caldas, Colombia
2706173 2706173 2022-08-17 Colombia Capital District     1845235 29692 0   4.711 -74.0721 2022-08-18 04:21:11 Capital District, Colombia
2706174 2706174 2022-08-17 Colombia Caqueta     25503 1036 0   0.8699 -73.8419 2022-08-18 04:21:11 Caqueta, Colombia
2706175 2706175 2022-08-17 Colombia Casanare     42624 1017 0   5.7589 -71.5724 2022-08-18 04:21:11 Casanare, Colombia
2706176 2706176 2022-08-17 Colombia Cauca     75711 1827 0   2.705 -76.826 2022-08-18 04:21:11 Cauca, Colombia
2706177 2706177 2022-08-17 Colombia Cesar     108418 2679 0   9.3373 -73.6536 2022-08-18 04:21:11 Cesar, Colombia
2706178 2706178 2022-08-17 Colombia Choco     18796 429 0   5.2528 -76.826 2022-08-18 04:21:11 Choco, Colombia
2706179 2706179 2022-08-17 Colombia Cordoba     121765 3948 0   8.0493 -75.574 2022-08-18 04:21:11 Cordoba, Colombia
2706180 2706180 2022-08-17 Colombia Cundinamarca     326602 7345 0   5.026 -74.03 2022-08-18 04:21:11 Cundinamarca, Colombia
2706181 2706181 2022-08-17 Colombia Guainia     2784 37 0   2.5854 -68.5247 2022-08-18 04:21:11 Guainia, Colombia
2706182 2706182 2022-08-17 Colombia Guaviare     5632 105 0   1.0654 -73.2603 2022-08-18 04:21:11 Guaviare, Colombia
2706183 2706183 2022-08-17 Colombia Huila     102839 3561 0   2.5359 -75.5277 2022-08-18 04:21:11 Huila, Colombia
2706184 2706184 2022-08-17 Colombia La Guajira     57696 1543 0   11.3548 -72.5205 2022-08-18 04:21:11 La Guajira, Colombia
2706185 2706185 2022-08-17 Colombia Magdalena     117133 3643 0   10.4113 -74.4057 2022-08-18 04:21:11 Magdalena, Colombia
2706186 2706186 2022-08-17 Colombia Meta     106994 2573 0   3.272 -73.0877 2022-08-18 04:21:11 Meta, Colombia
2706187 2706187 2022-08-17 Colombia Narino     107135 3367 0   1.2892 -77.3579 2022-08-18 04:21:11 Narino, Colombia
2706188 2706188 2022-08-17 Colombia Norte de Santander     123612 5148 0   7.9463 -72.8988 2022-08-18 04:21:11 Norte de Santander, Colombia
2706189 2706189 2022-08-17 Colombia Putumayo     21512 782 0   0.436 -75.5277 2022-08-18 04:21:11 Putumayo, Colombia
2706190 2706190 2022-08-17 Colombia Quindio     72409 2073 0   4.461 -75.6674 2022-08-18 04:21:11 Quindio, Colombia
2706191 2706191 2022-08-17 Colombia Risaralda     109136 2491 0   5.3158 -75.9928 2022-08-18 04:21:11 Risaralda, Colombia
2706192 2706192 2022-08-17 Colombia San Andres y Providencia     10323 156 0   12.5567 -81.7185 2022-08-18 04:21:11 San Andres y Providencia, Colombia
2706193 2706193 2022-08-17 Colombia Santander     292179 8268 0   6.6437 -73.6536 2022-08-18 04:21:11 Santander, Colombia
2706194 2706194 2022-08-17 Colombia Sucre     66841 1738 0   8.814 -74.7233 2022-08-18 04:21:11 Sucre, Colombia
2706195 2706195 2022-08-17 Colombia Tolima     126592 4056 0   4.0925 -75.1545 2022-08-18 04:21:11 Tolima, Colombia
2706196 2706196 2022-08-17 Colombia Unknown     0 300 0       2022-08-18 04:21:11 Unknown, Colombia
2706197 2706197 2022-08-17 Colombia Valle del Cauca     562393 15290 0   3.8009 -76.6413 2022-08-18 04:21:11 Valle del Cauca, Colombia
2706198 2706198 2022-08-17 Colombia Vaupes     1940 22 0   0.8554 -70.812 2022-08-18 04:21:11 Vaupes, Colombia
2706199 2706199 2022-08-17 Colombia Vichada     3441 63 0   4.4234 -69.2878 2022-08-18 04:21:11 Vichada, Colombia
2395833 2395833 2022-08-16 Colombia Amazonas     7725 265 0   -1.4429 -71.5724 2022-08-17 04:20:59 Amazonas, Colombia
2395834 2395834 2022-08-16 Colombia Antioquia     941089 18442 0   7.1986 -75.3412 2022-08-17 04:20:59 Antioquia, Colombia
2395835 2395835 2022-08-16 Colombia Arauca     16753 549 0   7.0762 -70.7105 2022-08-17 04:20:59 Arauca, Colombia
2395836 2395836 2022-08-16 Colombia Atlantico     415236 10187 0   10.6966 -74.8741 2022-08-17 04:20:59 Atlantico, Colombia
2395837 2395837 2022-08-16 Colombia Bolivar     202566 3261 0   8.6704 -74.03 2022-08-17 04:20:59 Bolivar, Colombia
2395838 2395838 2022-08-16 Colombia Boyaca     128725 2840 0   5.4545 -73.362 2022-08-17 04:20:59 Boyaca, Colombia
2395839 2395839 2022-08-16 Colombia Caldas     119053 2554 0   5.2983 -75.2479 2022-08-17 04:20:59 Caldas, Colombia
2395840 2395840 2022-08-16 Colombia Capital District     1845235 29692 0   4.711 -74.0721 2022-08-17 04:20:59 Capital District, Colombia
2395841 2395841 2022-08-16 Colombia Caqueta     25503 1036 0   0.8699 -73.8419 2022-08-17 04:20:59 Caqueta, Colombia
2395842 2395842 2022-08-16 Colombia Casanare     42624 1017 0   5.7589 -71.5724 2022-08-17 04:20:59 Casanare, Colombia
2395843 2395843 2022-08-16 Colombia Cauca     75711 1827 0   2.705 -76.826 2022-08-17 04:20:59 Cauca, Colombia
2395844 2395844 2022-08-16 Colombia Cesar     108418 2679 0   9.3373 -73.6536 2022-08-17 04:20:59 Cesar, Colombia
2395845 2395845 2022-08-16 Colombia Choco     18796 429 0   5.2528 -76.826 2022-08-17 04:20:59 Choco, Colombia
2395846 2395846 2022-08-16 Colombia Cordoba     121765 3948 0   8.0493 -75.574 2022-08-17 04:20:59 Cordoba, Colombia
2395847 2395847 2022-08-16 Colombia Cundinamarca     326602 7345 0   5.026 -74.03 2022-08-17 04:20:59 Cundinamarca, Colombia
2395848 2395848 2022-08-16 Colombia Guainia     2784 37 0   2.5854 -68.5247 2022-08-17 04:20:59 Guainia, Colombia
2395849 2395849 2022-08-16 Colombia Guaviare     5632 105 0   1.0654 -73.2603 2022-08-17 04:20:59 Guaviare, Colombia
2395850 2395850 2022-08-16 Colombia Huila     102839 3561 0   2.5359 -75.5277 2022-08-17 04:20:59 Huila, Colombia
2395851 2395851 2022-08-16 Colombia La Guajira     57696 1543 0   11.3548 -72.5205 2022-08-17 04:20:59 La Guajira, Colombia
2395852 2395852 2022-08-16 Colombia Magdalena     117133 3643 0   10.4113 -74.4057 2022-08-17 04:20:59 Magdalena, Colombia
2395853 2395853 2022-08-16 Colombia Meta     106994 2573 0   3.272 -73.0877 2022-08-17 04:20:59 Meta, Colombia
2395854 2395854 2022-08-16 Colombia Narino     107135 3367 0   1.2892 -77.3579 2022-08-17 04:20:59 Narino, Colombia
2395855 2395855 2022-08-16 Colombia Norte de Santander     123612 5148 0   7.9463 -72.8988 2022-08-17 04:20:59 Norte de Santander, Colombia
2395856 2395856 2022-08-16 Colombia Putumayo     21512 782 0   0.436 -75.5277 2022-08-17 04:20:59 Putumayo, Colombia
2395857 2395857 2022-08-16 Colombia Quindio     72409 2073 0   4.461 -75.6674 2022-08-17 04:20:59 Quindio, Colombia
2395858 2395858 2022-08-16 Colombia Risaralda     109136 2491 0   5.3158 -75.9928 2022-08-17 04:20:59 Risaralda, Colombia
2395859 2395859 2022-08-16 Colombia San Andres y Providencia     10323 156 0   12.5567 -81.7185 2022-08-17 04:20:59 San Andres y Providencia, Colombia
2395860 2395860 2022-08-16 Colombia Santander     292179 8268 0   6.6437 -73.6536 2022-08-17 04:20:59 Santander, Colombia
2395861 2395861 2022-08-16 Colombia Sucre     66841 1738 0   8.814 -74.7233 2022-08-17 04:20:59 Sucre, Colombia
2395862 2395862 2022-08-16 Colombia Tolima     126592 4056 0   4.0925 -75.1545 2022-08-17 04:20:59 Tolima, Colombia
2395863 2395863 2022-08-16 Colombia Unknown     0 300 0       2022-08-17 04:20:59 Unknown, Colombia
2395864 2395864 2022-08-16 Colombia Valle del Cauca     562393 15290 0   3.8009 -76.6413 2022-08-17 04:20:59 Valle del Cauca, Colombia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);
Powered by Datasette · Queries took 611.448ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette