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

32,189 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 946
  • Antioquia 946
  • Arauca 946
  • Atlantico 946
  • Bolivar 946
  • Boyaca 946
  • Caldas 946
  • Capital District 946
  • Caqueta 946
  • Casanare 946
  • Cauca 946
  • Cesar 946
  • Choco 946
  • Cordoba 946
  • Cundinamarca 946
  • Huila 946
  • La Guajira 946
  • Magdalena 946
  • Meta 946
  • Narino 946
  • Norte de Santander 946
  • Putumayo 946
  • Quindio 946
  • Risaralda 946
  • San Andres y Providencia 946
  • Santander 946
  • Sucre 946
  • Tolima 946
  • Valle del Cauca 946
  • Vaupes 946
  • …

country_or_region 1

  • Colombia · 32,189 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752720 2752720 2022-12-29 Colombia Amazonas     7835 265 0   -1.4429 -71.5724 2022-12-30 04:21:04 Amazonas, Colombia
2752721 2752721 2022-12-29 Colombia Antioquia     947893 18551 0   7.1986 -75.3412 2022-12-30 04:21:04 Antioquia, Colombia
2752722 2752722 2022-12-29 Colombia Arauca     17051 565 0   7.0762 -70.7105 2022-12-30 04:21:04 Arauca, Colombia
2752723 2752723 2022-12-29 Colombia Atlantico     417510 10225 0   10.6966 -74.8741 2022-12-30 04:21:04 Atlantico, Colombia
2752724 2752724 2022-12-29 Colombia Bolivar     203303 3275 0   8.6704 -74.03 2022-12-30 04:21:04 Bolivar, Colombia
2752725 2752725 2022-12-29 Colombia Boyaca     129670 2882 0   5.4545 -73.362 2022-12-30 04:21:04 Boyaca, Colombia
2752726 2752726 2022-12-29 Colombia Caldas     119464 2565 0   5.2983 -75.2479 2022-12-30 04:21:04 Caldas, Colombia
2752727 2752727 2022-12-29 Colombia Capital District     1865441 29932 0   4.711 -74.0721 2022-12-30 04:21:04 Capital District, Colombia
2752728 2752728 2022-12-29 Colombia Caqueta     25617 1041 0   0.8699 -73.8419 2022-12-30 04:21:04 Caqueta, Colombia
2752729 2752729 2022-12-29 Colombia Casanare     42966 1025 0   5.7589 -71.5724 2022-12-30 04:21:04 Casanare, Colombia
2752730 2752730 2022-12-29 Colombia Cauca     76382 1849 0   2.705 -76.826 2022-12-30 04:21:04 Cauca, Colombia
2752731 2752731 2022-12-29 Colombia Cesar     109197 2689 0   9.3373 -73.6536 2022-12-30 04:21:04 Cesar, Colombia
2752732 2752732 2022-12-29 Colombia Choco     18858 429 0   5.2528 -76.826 2022-12-30 04:21:04 Choco, Colombia
2752733 2752733 2022-12-29 Colombia Cordoba     122351 3957 0   8.0493 -75.574 2022-12-30 04:21:04 Cordoba, Colombia
2752734 2752734 2022-12-29 Colombia Cundinamarca     328889 7377 0   5.026 -74.03 2022-12-30 04:21:04 Cundinamarca, Colombia
2752735 2752735 2022-12-29 Colombia Guainia     2793 37 0   2.5854 -68.5247 2022-12-30 04:21:04 Guainia, Colombia
2752736 2752736 2022-12-29 Colombia Guaviare     5671 105 0   1.0654 -73.2603 2022-12-30 04:21:04 Guaviare, Colombia
2752737 2752737 2022-12-29 Colombia Huila     103120 3583 0   2.5359 -75.5277 2022-12-30 04:21:04 Huila, Colombia
2752738 2752738 2022-12-29 Colombia La Guajira     58036 1545 0   11.3548 -72.5205 2022-12-30 04:21:04 La Guajira, Colombia
2752739 2752739 2022-12-29 Colombia Magdalena     117678 3654 0   10.4113 -74.4057 2022-12-30 04:21:04 Magdalena, Colombia
2752740 2752740 2022-12-29 Colombia Meta     107583 2601 0   3.272 -73.0877 2022-12-30 04:21:04 Meta, Colombia
2752741 2752741 2022-12-29 Colombia Narino     107970 3391 0   1.2892 -77.3579 2022-12-30 04:21:04 Narino, Colombia
2752742 2752742 2022-12-29 Colombia Norte de Santander     124934 5182 0   7.9463 -72.8988 2022-12-30 04:21:04 Norte de Santander, Colombia
2752743 2752743 2022-12-29 Colombia Putumayo     21853 789 0   0.436 -75.5277 2022-12-30 04:21:04 Putumayo, Colombia
2752744 2752744 2022-12-29 Colombia Quindio     72879 2079 0   4.461 -75.6674 2022-12-30 04:21:04 Quindio, Colombia
2752745 2752745 2022-12-29 Colombia Risaralda     109727 2502 0   5.3158 -75.9928 2022-12-30 04:21:04 Risaralda, Colombia
2752746 2752746 2022-12-29 Colombia San Andres y Providencia     10345 156 0   12.5567 -81.7185 2022-12-30 04:21:04 San Andres y Providencia, Colombia
2752747 2752747 2022-12-29 Colombia Santander     294839 8340 0   6.6437 -73.6536 2022-12-30 04:21:04 Santander, Colombia
2752748 2752748 2022-12-29 Colombia Sucre     67085 1745 0   8.814 -74.7233 2022-12-30 04:21:04 Sucre, Colombia
2752749 2752749 2022-12-29 Colombia Tolima     127031 4079 0   4.0925 -75.1545 2022-12-30 04:21:04 Tolima, Colombia
2752750 2752750 2022-12-29 Colombia Unknown     0 2 0       2022-12-30 04:21:04 Unknown, Colombia
2752751 2752751 2022-12-29 Colombia Valle del Cauca     567260 15378 0   3.8009 -76.6413 2022-12-30 04:21:04 Valle del Cauca, Colombia
2752752 2752752 2022-12-29 Colombia Vaupes     1960 22 0   0.8554 -70.812 2022-12-30 04:21:04 Vaupes, Colombia
2752753 2752753 2022-12-29 Colombia Vichada     3469 64 0   4.4234 -69.2878 2022-12-30 04:21:04 Vichada, Colombia
1073726 1073726 2022-12-28 Colombia Amazonas     7830 265 0   -1.4429 -71.5724 2022-12-29 04:21:01 Amazonas, Colombia
1073727 1073727 2022-12-28 Colombia Antioquia     946562 18535 0   7.1986 -75.3412 2022-12-29 04:21:01 Antioquia, Colombia
1073728 1073728 2022-12-28 Colombia Arauca     17043 564 0   7.0762 -70.7105 2022-12-29 04:21:01 Arauca, Colombia
1073729 1073729 2022-12-28 Colombia Atlantico     417468 10223 0   10.6966 -74.8741 2022-12-29 04:21:01 Atlantico, Colombia
1073730 1073730 2022-12-28 Colombia Bolivar     203277 3272 0   8.6704 -74.03 2022-12-29 04:21:01 Bolivar, Colombia
1073731 1073731 2022-12-28 Colombia Boyaca     129514 2878 0   5.4545 -73.362 2022-12-29 04:21:01 Boyaca, Colombia
1073732 1073732 2022-12-28 Colombia Caldas     119403 2565 0   5.2983 -75.2479 2022-12-29 04:21:01 Caldas, Colombia
1073733 1073733 2022-12-28 Colombia Capital District     1862342 29902 0   4.711 -74.0721 2022-12-29 04:21:01 Capital District, Colombia
1073734 1073734 2022-12-28 Colombia Caqueta     25597 1041 0   0.8699 -73.8419 2022-12-29 04:21:01 Caqueta, Colombia
1073735 1073735 2022-12-28 Colombia Casanare     42920 1025 0   5.7589 -71.5724 2022-12-29 04:21:01 Casanare, Colombia
1073736 1073736 2022-12-28 Colombia Cauca     76288 1848 0   2.705 -76.826 2022-12-29 04:21:01 Cauca, Colombia
1073737 1073737 2022-12-28 Colombia Cesar     109144 2689 0   9.3373 -73.6536 2022-12-29 04:21:01 Cesar, Colombia
1073738 1073738 2022-12-28 Colombia Choco     18837 429 0   5.2528 -76.826 2022-12-29 04:21:01 Choco, Colombia
1073739 1073739 2022-12-28 Colombia Cordoba     122306 3956 0   8.0493 -75.574 2022-12-29 04:21:01 Cordoba, Colombia
1073740 1073740 2022-12-28 Colombia Cundinamarca     328283 7373 0   5.026 -74.03 2022-12-29 04:21:01 Cundinamarca, Colombia
1073741 1073741 2022-12-28 Colombia Guainia     2792 37 0   2.5854 -68.5247 2022-12-29 04:21:01 Guainia, Colombia
1073742 1073742 2022-12-28 Colombia Guaviare     5668 105 0   1.0654 -73.2603 2022-12-29 04:21:01 Guaviare, Colombia
1073743 1073743 2022-12-28 Colombia Huila     103075 3582 0   2.5359 -75.5277 2022-12-29 04:21:01 Huila, Colombia
1073744 1073744 2022-12-28 Colombia La Guajira     58001 1543 0   11.3548 -72.5205 2022-12-29 04:21:01 La Guajira, Colombia
1073745 1073745 2022-12-28 Colombia Magdalena     117660 3653 0   10.4113 -74.4057 2022-12-29 04:21:01 Magdalena, Colombia
1073746 1073746 2022-12-28 Colombia Meta     107505 2600 0   3.272 -73.0877 2022-12-29 04:21:01 Meta, Colombia
1073747 1073747 2022-12-28 Colombia Narino     107812 3391 0   1.2892 -77.3579 2022-12-29 04:21:01 Narino, Colombia
1073748 1073748 2022-12-28 Colombia Norte de Santander     124732 5179 0   7.9463 -72.8988 2022-12-29 04:21:01 Norte de Santander, Colombia
1073749 1073749 2022-12-28 Colombia Putumayo     21825 789 0   0.436 -75.5277 2022-12-29 04:21:01 Putumayo, Colombia
1073750 1073750 2022-12-28 Colombia Quindio     72744 2076 0   4.461 -75.6674 2022-12-29 04:21:01 Quindio, Colombia
1073751 1073751 2022-12-28 Colombia Risaralda     109604 2502 0   5.3158 -75.9928 2022-12-29 04:21:01 Risaralda, Colombia
1073752 1073752 2022-12-28 Colombia San Andres y Providencia     10340 156 0   12.5567 -81.7185 2022-12-29 04:21:01 San Andres y Providencia, Colombia
1073753 1073753 2022-12-28 Colombia Santander     294368 8326 0   6.6437 -73.6536 2022-12-29 04:21:01 Santander, Colombia
1073754 1073754 2022-12-28 Colombia Sucre     67067 1744 0   8.814 -74.7233 2022-12-29 04:21:01 Sucre, Colombia
1073755 1073755 2022-12-28 Colombia Tolima     126973 4079 0   4.0925 -75.1545 2022-12-29 04:21:01 Tolima, Colombia
1073756 1073756 2022-12-28 Colombia Unknown     0 105 0       2022-12-29 04:21:01 Unknown, Colombia
1073757 1073757 2022-12-28 Colombia Valle del Cauca     566582 15363 0   3.8009 -76.6413 2022-12-29 04:21:01 Valle del Cauca, Colombia
1073758 1073758 2022-12-28 Colombia Vaupes     1958 22 0   0.8554 -70.812 2022-12-29 04:21:01 Vaupes, Colombia
1073759 1073759 2022-12-28 Colombia Vichada     3469 64 0   4.4234 -69.2878 2022-12-29 04:21:01 Vichada, Colombia
327723 327723 2022-12-27 Colombia Amazonas     7830 265 0   -1.4429 -71.5724 2022-12-28 04:21:04 Amazonas, Colombia
327724 327724 2022-12-27 Colombia Antioquia     946562 18535 0   7.1986 -75.3412 2022-12-28 04:21:04 Antioquia, Colombia
327725 327725 2022-12-27 Colombia Arauca     17043 564 0   7.0762 -70.7105 2022-12-28 04:21:04 Arauca, Colombia
327726 327726 2022-12-27 Colombia Atlantico     417468 10223 0   10.6966 -74.8741 2022-12-28 04:21:04 Atlantico, Colombia
327727 327727 2022-12-27 Colombia Bolivar     203277 3272 0   8.6704 -74.03 2022-12-28 04:21:04 Bolivar, Colombia
327728 327728 2022-12-27 Colombia Boyaca     129514 2878 0   5.4545 -73.362 2022-12-28 04:21:04 Boyaca, Colombia
327729 327729 2022-12-27 Colombia Caldas     119403 2565 0   5.2983 -75.2479 2022-12-28 04:21:04 Caldas, 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
327731 327731 2022-12-27 Colombia Caqueta     25597 1041 0   0.8699 -73.8419 2022-12-28 04:21:04 Caqueta, Colombia
327732 327732 2022-12-27 Colombia Casanare     42920 1025 0   5.7589 -71.5724 2022-12-28 04:21:04 Casanare, Colombia
327733 327733 2022-12-27 Colombia Cauca     76288 1848 0   2.705 -76.826 2022-12-28 04:21:04 Cauca, Colombia
327734 327734 2022-12-27 Colombia Cesar     109144 2689 0   9.3373 -73.6536 2022-12-28 04:21:04 Cesar, Colombia
327735 327735 2022-12-27 Colombia Choco     18837 429 0   5.2528 -76.826 2022-12-28 04:21:04 Choco, Colombia
327736 327736 2022-12-27 Colombia Cordoba     122306 3956 0   8.0493 -75.574 2022-12-28 04:21:04 Cordoba, Colombia
327737 327737 2022-12-27 Colombia Cundinamarca     328283 7373 0   5.026 -74.03 2022-12-28 04:21:04 Cundinamarca, Colombia
327738 327738 2022-12-27 Colombia Guainia     2792 37 0   2.5854 -68.5247 2022-12-28 04:21:04 Guainia, Colombia
327739 327739 2022-12-27 Colombia Guaviare     5668 105 0   1.0654 -73.2603 2022-12-28 04:21:04 Guaviare, Colombia
327740 327740 2022-12-27 Colombia Huila     103075 3582 0   2.5359 -75.5277 2022-12-28 04:21:04 Huila, Colombia
327741 327741 2022-12-27 Colombia La Guajira     58001 1543 0   11.3548 -72.5205 2022-12-28 04:21:04 La Guajira, Colombia
327742 327742 2022-12-27 Colombia Magdalena     117660 3653 0   10.4113 -74.4057 2022-12-28 04:21:04 Magdalena, Colombia
327743 327743 2022-12-27 Colombia Meta     107505 2600 0   3.272 -73.0877 2022-12-28 04:21:04 Meta, Colombia
327744 327744 2022-12-27 Colombia Narino     107812 3391 0   1.2892 -77.3579 2022-12-28 04:21:04 Narino, Colombia
327745 327745 2022-12-27 Colombia Norte de Santander     124732 5179 0   7.9463 -72.8988 2022-12-28 04:21:04 Norte de Santander, Colombia
327746 327746 2022-12-27 Colombia Putumayo     21825 789 0   0.436 -75.5277 2022-12-28 04:21:04 Putumayo, Colombia
327747 327747 2022-12-27 Colombia Quindio     72744 2076 0   4.461 -75.6674 2022-12-28 04:21:04 Quindio, Colombia
327748 327748 2022-12-27 Colombia Risaralda     109604 2502 0   5.3158 -75.9928 2022-12-28 04:21:04 Risaralda, Colombia
327749 327749 2022-12-27 Colombia San Andres y Providencia     10340 156 0   12.5567 -81.7185 2022-12-28 04:21:04 San Andres y Providencia, Colombia
327750 327750 2022-12-27 Colombia Santander     294368 8326 0   6.6437 -73.6536 2022-12-28 04:21:04 Santander, Colombia
327751 327751 2022-12-27 Colombia Sucre     67067 1744 0   8.814 -74.7233 2022-12-28 04:21:04 Sucre, Colombia
327752 327752 2022-12-27 Colombia Tolima     126973 4079 0   4.0925 -75.1545 2022-12-28 04:21:04 Tolima, Colombia
327753 327753 2022-12-27 Colombia Unknown     0 105 0       2022-12-28 04:21:04 Unknown, Colombia
327754 327754 2022-12-27 Colombia Valle del Cauca     566582 15363 0   3.8009 -76.6413 2022-12-28 04:21:04 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] 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]);
Powered by Datasette · Queries took 761.16ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette