johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
57 rows where country_or_region = "Colombia" and deaths = 18 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 18
country_or_region 1
- Colombia · 57 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2051731 | 2051731 | 2022-01-25 | Colombia | Vaupes | 1833 | 18 | 0 | 0.8554 | -70.812 | 2022-01-26 04:21:07 | Vaupes, Colombia | |||
1227462 | 1227462 | 2022-01-24 | Colombia | Vaupes | 1833 | 18 | 0 | 0.8554 | -70.812 | 2022-01-25 04:21:05 | Vaupes, Colombia | |||
1140761 | 1140761 | 2022-01-23 | Colombia | Vaupes | 1833 | 18 | 0 | 0.8554 | -70.812 | 2022-01-24 04:21:12 | Vaupes, Colombia | |||
3503223 | 3503223 | 2021-01-17 | Colombia | Vichada | 1184 | 18 | 1147 | 19 | 4.4234 | -69.2878 | 2021-01-18 05:22:34 | Vichada, Colombia | ||
1543792 | 1543792 | 2020-11-07 | Colombia | Guainia | 1155 | 18 | 1130 | 7 | 2.5854 | -68.5247 | 2020-11-08 05:24:56 | Guainia, Colombia | ||
376030 | 376030 | 2020-11-06 | Colombia | Guainia | 1152 | 18 | 1130 | 4 | 2.5854 | -68.5247 | 2020-11-07 05:24:52 | Guainia, Colombia | ||
891968 | 891968 | 2020-11-05 | Colombia | Guainia | 1152 | 18 | 1124 | 10 | 2.5854 | -68.5247 | 2020-11-06 05:24:55 | Guainia, Colombia | ||
2919030 | 2919030 | 2020-11-04 | Colombia | Guainia | 1152 | 18 | 1122 | 12 | 2.5854 | -68.5247 | 2020-11-05 06:05:03 | Guainia, Colombia | ||
2497867 | 2497867 | 2020-11-03 | Colombia | Guainia | 1152 | 18 | 1119 | 15 | 2.5854 | -68.5247 | 2020-11-04 05:25:09 | Guainia, Colombia | ||
3304042 | 3304042 | 2020-11-02 | Colombia | Guainia | 1516 | 18 | 1103 | 395 | 2.5854 | -68.5247 | 2020-11-03 06:00:16 | Guainia, Colombia | ||
3409291 | 3409291 | 2020-11-01 | Colombia | Guainia | 1147 | 18 | 1102 | 27 | 2.5854 | -68.5247 | 2020-11-02 05:25:04 | Guainia, Colombia | ||
2079780 | 2079780 | 2020-10-31 | Colombia | Guainia | 1132 | 18 | 1098 | 16 | 2.5854 | -68.5247 | 2020-11-01 04:36:19 | Guainia, Colombia | ||
2243233 | 2243233 | 2020-10-30 | Colombia | Guainia | 1127 | 18 | 1092 | 17 | 2.5854 | -68.5247 | 2020-10-31 04:24:44 | Guainia, Colombia | ||
210088 | 210088 | 2020-10-29 | Colombia | Guainia | 1119 | 18 | 1089 | 12 | 2.5854 | -68.5247 | 2020-10-30 04:24:49 | Guainia, Colombia | ||
754150 | 754150 | 2020-10-28 | Colombia | Guainia | 1119 | 18 | 1089 | 12 | 2.5854 | -68.5247 | 2020-10-29 04:24:49 | Guainia, Colombia | ||
1452435 | 1452435 | 2020-10-27 | Colombia | Guainia | 1116 | 18 | 1083 | 15 | 2.5854 | -68.5247 | 2020-10-28 04:24:39 | Guainia, Colombia | ||
3480159 | 3480159 | 2020-10-26 | Colombia | Guainia | 1116 | 18 | 1070 | 28 | 2.5854 | -68.5247 | 2020-10-27 04:24:45 | Guainia, Colombia | ||
8180 | 8180 | 2020-10-25 | Colombia | Guainia | 1108 | 18 | 1069 | 21 | 2.5854 | -68.5247 | 2020-10-26 04:25:02 | Guainia, Colombia | ||
3651417 | 3651417 | 2020-10-24 | Colombia | Guainia | 1107 | 18 | 1066 | 23 | 2.5854 | -68.5247 | 2020-10-25 04:24:36 | Guainia, Colombia | ||
1053672 | 1053672 | 2020-10-23 | Colombia | Guainia | 1103 | 18 | 1061 | 24 | 2.5854 | -68.5247 | 2020-10-24 04:24:46 | Guainia, Colombia | ||
1177342 | 1177342 | 2020-10-22 | Colombia | Guainia | 1097 | 18 | 1047 | 32 | 2.5854 | -68.5247 | 2020-10-23 04:24:46 | Guainia, Colombia | ||
2191447 | 2191447 | 2020-10-21 | Colombia | Guainia | 1094 | 18 | 1029 | 47 | 2.5854 | -68.5247 | 2020-10-22 04:24:27 | Guainia, Colombia | ||
3990458 | 3990458 | 2020-10-20 | Colombia | Guainia | 1094 | 18 | 1022 | 54 | 2.5854 | -68.5247 | 2020-10-21 04:24:14 | Guainia, Colombia | ||
1794478 | 1794478 | 2020-10-19 | Colombia | Guainia | 1093 | 18 | 1010 | 65 | 2.5854 | -68.5247 | 2020-10-20 04:24:22 | Guainia, Colombia | ||
762162 | 762162 | 2020-10-18 | Colombia | Guainia | 1083 | 18 | 999 | 66 | 2.5854 | -68.5247 | 2020-10-19 04:24:16 | Guainia, Colombia | ||
3801746 | 3801746 | 2020-10-05 | Colombia | Guaviare | 979 | 18 | 783 | 178 | 1.0654 | -73.2603 | 2020-10-06 04:23:33 | Guaviare, Colombia | ||
1822636 | 1822636 | 2020-10-04 | Colombia | Guaviare | 943 | 18 | 783 | 142 | 1.0654 | -73.2603 | 2020-10-05 04:23:33 | Guaviare, Colombia | ||
2514020 | 2514020 | 2020-10-03 | Colombia | Guaviare | 887 | 18 | 748 | 121 | 1.0654 | -73.2603 | 2020-10-04 04:23:44 | Guaviare, Colombia | ||
1105389 | 1105389 | 2020-09-02 | Colombia | Arauca | 985 | 18 | 743 | 224 | 7.0762 | -70.7105 | 2020-09-03 04:28:22 | Arauca, Colombia | ||
2059718 | 2059718 | 2020-09-01 | Colombia | Arauca | 970 | 18 | 704 | 248 | 7.0762 | -70.7105 | 2020-09-02 04:28:25 | Arauca, Colombia | ||
2991115 | 2991115 | 2020-08-24 | Colombia | Casanare | 888 | 18 | 517 | 353 | 5.7589 | -71.5724 | 2020-08-25 04:28:02 | Casanare, Colombia | ||
2215510 | 2215510 | 2020-08-23 | Colombia | Casanare | 856 | 18 | 499 | 339 | 5.7589 | -71.5724 | 2020-08-24 04:27:56 | Casanare, Colombia | ||
3177866 | 3177866 | 2020-08-18 | Colombia | Quindio | 697 | 18 | 368 | 311 | 4.461 | -75.6674 | 2020-08-19 04:27:00 | Quindio, Colombia | ||
837470 | 837470 | 2020-08-17 | Colombia | Quindio | 677 | 18 | 346 | 313 | 4.461 | -75.6674 | 2020-08-18 04:27:56 | Quindio, Colombia | ||
1555828 | 1555828 | 2020-08-16 | Colombia | Quindio | 670 | 18 | 325 | 327 | 4.461 | -75.6674 | 2020-08-17 04:27:20 | Quindio, Colombia | ||
145830 | 145830 | 2020-08-15 | Colombia | Quindio | 649 | 18 | 310 | 321 | 4.461 | -75.6674 | 2020-08-16 04:27:42 | Quindio, Colombia | ||
1920229 | 1920229 | 2020-08-10 | Colombia | Caldas | 1383 | 18 | 463 | 902 | 5.2983 | -75.2479 | 2020-08-11 04:35:08 | Caldas, Colombia | ||
1928223 | 1928223 | 2020-07-30 | Colombia | Caqueta | 884 | 18 | 155 | 711 | 0.8699 | -73.8419 | 2020-07-31 04:35:18 | Caqueta, Colombia | ||
3185108 | 3185108 | 2020-07-28 | Colombia | Huila | 746 | 18 | 395 | 333 | 2.5359 | -75.5277 | 2020-07-29 04:35:11 | Huila, Colombia | ||
177160 | 177160 | 2020-07-27 | Colombia | Huila | 721 | 18 | 391 | 312 | 2.5359 | -75.5277 | 2020-07-28 04:58:43 | Huila, Colombia | ||
442473 | 442473 | 2020-07-26 | Colombia | Huila | 673 | 18 | 367 | 288 | 2.5359 | -75.5277 | 2020-07-27 04:35:02 | Huila, Colombia | ||
1502717 | 1502717 | 2020-07-25 | Colombia | Huila | 673 | 18 | 367 | 288 | 2.5359 | -75.5277 | 2020-07-26 04:35:00 | Huila, Colombia | ||
2563687 | 2563687 | 2020-07-24 | Colombia | Huila | 646 | 18 | 365 | 263 | 2.5359 | -75.5277 | 2020-07-25 04:47:39 | Huila, Colombia | ||
61906 | 61906 | 2020-07-23 | Colombia | Huila | 625 | 18 | 362 | 245 | 2.5359 | -75.5277 | 2020-07-24 05:30:40 | Huila, Colombia | ||
844895 | 844895 | 2020-07-22 | Colombia | Putumayo | 386 | 18 | 18 | 350 | 0.436 | -75.5277 | 2020-07-23 05:15:04 | Putumayo, Colombia | ||
367347 | 367347 | 2020-07-16 | Colombia | Huila | 458 | 18 | 333 | 107 | 2.5359 | -75.5277 | 2020-07-17 04:34:50 | Huila, Colombia | ||
3237342 | 3237342 | 2020-07-10 | Colombia | Boyaca | 460 | 18 | 259 | 183 | 5.4545 | -73.362 | 2020-07-11 04:34:26 | Boyaca, Colombia | ||
1005327 | 1005327 | 2020-07-09 | Colombia | Boyaca | 446 | 18 | 252 | 176 | 5.4545 | -73.362 | 2020-07-10 04:34:24 | Boyaca, Colombia | ||
2222543 | 2222543 | 2020-07-08 | Colombia | Boyaca | 444 | 18 | 247 | 179 | 5.4545 | -73.362 | 2020-07-09 04:34:23 | Boyaca, Colombia | ||
887152 | 887152 | 2020-07-07 | Colombia | Boyaca | 434 | 18 | 244 | 172 | 5.4545 | -73.362 | 2020-07-08 05:33:48 | Boyaca, Colombia | ||
887464 | 887464 | 2020-07-07 | Colombia | Risaralda | 619 | 18 | 320 | 281 | 5.3158 | -75.9928 | 2020-07-08 05:33:48 | Risaralda, Colombia | ||
2684922 | 2684922 | 2020-07-06 | Colombia | Meta | 1349 | 18 | 1002 | 329 | 3.272 | -73.0877 | 2020-07-07 04:34:00 | Meta, Colombia | ||
3045216 | 3045216 | 2020-07-02 | Colombia | Cauca | 405 | 18 | 161 | 226 | 2.705 | -76.82600000000002 | 2020-07-03 04:33:54 | Cauca, Colombia | ||
2700507 | 2700507 | 2020-06-24 | Colombia | Antioquia | 3098 | 18 | 1187 | 1893 | 7.1986 | -75.3412 | 2020-06-25 05:26:54 | Antioquia, Colombia | ||
1522192 | 1522192 | 2020-06-23 | Colombia | Antioquia | 3098 | 18 | 1187 | 1893 | 7.1986 | -75.3412 | 2020-06-24 04:33:28 | Antioquia, Colombia | ||
1837002 | 1837002 | 2020-06-14 | Colombia | Choco | 680 | 18 | 137 | 525 | 5.2528 | -76.82600000000002 | 2020-06-15 03:33:14 | Choco, Colombia | ||
805240 | 805240 | 2020-06-01 | Colombia | Cundinamarca | 897 | 18 | 281 | 598 | 5.026 | -74.03 | 2020-06-02 02:33:08 | Cundinamarca, 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]);