johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where active = 35 and country_or_region = "Colombia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, last_update (date)
province_or_state 9
- Guaviare 7
- Vaupes 7
- San Andres y Providencia 5
- Amazonas 3
- La Guajira 3
- Risaralda 3
- Caldas 2
- Guainia 2
- Vichada 2
country_or_region 1
- Colombia · 34 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331764 | 331764 | 2021-08-04 | Colombia | San Andres y Providencia | 6758 | 133 | 6590 | 35 | 12.5567 | -81.7185 | 2021-08-05 04:21:51 | San Andres y Providencia, Colombia | ||
2947203 | 2947203 | 2021-07-16 | Colombia | Guainia | 2172 | 28 | 2109 | 35 | 2.5854 | -68.5247 | 2021-07-17 04:22:22 | Guainia, Colombia | ||
107298 | 107298 | 2021-06-19 | Colombia | Guainia | 1991 | 23 | 1933 | 35 | 2.5854 | -68.5247 | 2021-06-20 04:21:48 | Guainia, Colombia | ||
2339244 | 2339244 | 2021-06-15 | Colombia | Guaviare | 3546 | 60 | 3451 | 35 | 1.0654 | -73.2603 | 2021-06-16 04:22:32 | Guaviare, Colombia | ||
1563940 | 1563940 | 2021-06-14 | Colombia | Guaviare | 3546 | 60 | 3451 | 35 | 1.0654 | -73.2603 | 2021-06-15 04:22:22 | Guaviare, Colombia | ||
1771207 | 1771207 | 2021-05-23 | Colombia | Vaupes | 1484 | 14 | 1435 | 35 | 0.8554 | -70.812 | 2021-05-24 04:20:53 | Vaupes, Colombia | ||
2255597 | 2255597 | 2021-05-19 | Colombia | Vaupes | 1415 | 14 | 1366 | 35 | 0.8554 | -70.812 | 2021-05-20 04:21:05 | Vaupes, Colombia | ||
2939190 | 2939190 | 2021-05-16 | Colombia | Vaupes | 1401 | 14 | 1352 | 35 | 0.8554 | -70.812 | 2021-05-17 04:20:34 | Vaupes, Colombia | ||
1872820 | 1872820 | 2021-05-15 | Colombia | Vaupes | 1391 | 13 | 1343 | 35 | 0.8554 | -70.812 | 2021-05-16 04:20:49 | Vaupes, Colombia | ||
1093936 | 1093936 | 2021-01-20 | Colombia | Guaviare | 2104 | 38 | 2031 | 35 | 1.0654 | -73.2603 | 2021-01-21 05:22:01 | Guaviare, Colombia | ||
3879434 | 3879434 | 2021-01-14 | Colombia | San Andres y Providencia | 2525 | 42 | 2448 | 35 | 12.5567 | -81.7185 | 2021-01-15 05:22:24 | San Andres y Providencia, Colombia | ||
3308051 | 3308051 | 2021-01-13 | Colombia | Guaviare | 2054 | 37 | 1982 | 35 | 1.0654 | -73.2603 | 2021-01-14 05:22:32 | Guaviare, Colombia | ||
2864548 | 2864548 | 2021-01-06 | Colombia | Amazonas | 3288 | 126 | 3127 | 35 | -1.4429 | -71.5724 | 2021-01-07 05:22:03 | Amazonas, Colombia | ||
1061706 | 1061706 | 2021-01-04 | Colombia | San Andres y Providencia | 2477 | 40 | 2402 | 35 | 12.5567 | -81.7185 | 2021-01-05 05:21:49 | San Andres y Providencia, Colombia | ||
766179 | 766179 | 2020-12-29 | Colombia | San Andres y Providencia | 2445 | 38 | 2372 | 35 | 12.5567 | -81.7185 | 2020-12-30 05:22:34 | San Andres y Providencia, Colombia | ||
3761443 | 3761443 | 2020-12-28 | Colombia | San Andres y Providencia | 2439 | 38 | 2366 | 35 | 12.5567 | -81.7185 | 2020-12-29 05:22:37 | San Andres y Providencia, Colombia | ||
2406697 | 2406697 | 2020-12-23 | Colombia | Vichada | 1133 | 14 | 1084 | 35 | 4.4234 | -69.2878 | 2020-12-24 05:23:04 | Vichada, Colombia | ||
927542 | 927542 | 2020-12-21 | Colombia | Guaviare | 1923 | 36 | 1852 | 35 | 1.0654 | -73.2603 | 2020-12-22 05:22:33 | Guaviare, Colombia | ||
1350167 | 1350167 | 2020-11-24 | Colombia | Guaviare | 1773 | 27 | 1711 | 35 | 1.0654 | -73.2603 | 2020-11-25 05:27:20 | Guaviare, Colombia | ||
3338425 | 3338425 | 2020-11-17 | Colombia | Amazonas | 3016 | 122 | 2859 | 35 | -1.4429 | -71.5724 | 2020-11-18 05:40:31 | Amazonas, Colombia | ||
2784838 | 2784838 | 2020-11-13 | Colombia | Amazonas | 2982 | 120 | 2827 | 35 | -1.4429 | -71.5724 | 2020-11-14 05:25:37 | Amazonas, Colombia | ||
1794496 | 1794496 | 2020-10-19 | Colombia | Vichada | 739 | 7 | 697 | 35 | 4.4234 | -69.2878 | 2020-10-20 04:24:22 | Vichada, Colombia | ||
786242 | 786242 | 2020-10-15 | Colombia | Vaupes | 958 | 12 | 911 | 35 | 0.8554 | -70.812 | 2020-10-16 04:24:01 | Vaupes, Colombia | ||
3117350 | 3117350 | 2020-10-06 | Colombia | Vaupes | 863 | 12 | 816 | 35 | 0.8554 | -70.812 | 2020-10-07 04:23:40 | Vaupes, Colombia | ||
1045681 | 1045681 | 2020-09-30 | Colombia | Vaupes | 769 | 10 | 724 | 35 | 0.8554 | -70.812 | 2020-10-01 04:23:42 | Vaupes, Colombia | ||
609538 | 609538 | 2020-08-29 | Colombia | Guaviare | 241 | 1 | 205 | 35 | 1.0654 | -73.2603 | 2020-08-30 04:28:22 | Guaviare, Colombia | ||
1210886 | 1210886 | 2020-06-09 | Colombia | Risaralda | 278 | 10 | 233 | 35 | 5.3158 | -75.9928 | 2020-06-10 04:07:00 | Risaralda, Colombia | ||
217313 | 217313 | 2020-06-08 | Colombia | Risaralda | 278 | 10 | 233 | 35 | 5.3158 | -75.9928 | 2020-06-09 03:33:03 | Risaralda, Colombia | ||
2555668 | 2555668 | 2020-06-02 | Colombia | Caldas | 138 | 6 | 97 | 35 | 5.2983 | -75.2479 | 2020-06-03 02:33:13 | Caldas, Colombia | ||
805204 | 805204 | 2020-06-01 | Colombia | Caldas | 135 | 6 | 94 | 35 | 5.2983 | -75.2479 | 2020-06-02 02:33:08 | Caldas, Colombia | ||
805341 | 805341 | 2020-06-01 | Colombia | La Guajira | 62 | 4 | 23 | 35 | 11.3548 | -72.5205 | 2020-06-02 02:33:08 | La Guajira, Colombia | ||
1793936 | 1793936 | 2020-05-31 | Colombia | La Guajira | 58 | 4 | 19 | 35 | 11.3548 | -72.5205 | 2020-06-01 02:32:46 | La Guajira, Colombia | ||
3638829 | 3638829 | 2020-05-30 | Colombia | La Guajira | 57 | 4 | 18 | 35 | 11.3548 | -72.5205 | 2020-05-31 02:32:45 | La Guajira, Colombia | ||
1790469 | 1790469 | 2020-05-29 | Colombia | Risaralda | 249 | 8 | 206 | 35 | 5.3158 | -75.9928 | 2020-05-30 02:32:48 | Risaralda, 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]);