johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where country_or_region = "Colombia" and recovered = 11 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, latitude, last_update (date)
province_or_state 5
- Vaupes 22
- Guainia 9
- San Andres y Providencia 5
- Putumayo 2
- Guaviare 1
country_or_region 1
- Colombia · 39 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
367321 | 367321 | 2020-07-16 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-17 04:34:50 | Guainia, Colombia | ||
2747989 | 2747989 | 2020-07-15 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-16 04:44:59 | Guainia, Colombia | ||
2158633 | 2158633 | 2020-07-14 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-15 04:34:39 | Guainia, Colombia | ||
3491274 | 3491274 | 2020-07-13 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-14 04:34:46 | Guainia, Colombia | ||
3491484 | 3491484 | 2020-07-13 | Colombia | Putumayo | 95 | 9 | 11 | 75 | 0.436 | -75.5277 | 2020-07-14 04:34:46 | Putumayo, Colombia | ||
3737537 | 3737537 | 2020-07-12 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-13 04:43:04 | Guainia, Colombia | ||
3737747 | 3737747 | 2020-07-12 | Colombia | Putumayo | 88 | 8 | 11 | 69 | 0.436 | -75.5277 | 2020-07-13 04:43:04 | Putumayo, Colombia | ||
3435932 | 3435932 | 2020-07-11 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-12 04:34:30 | Guainia, Colombia | ||
3237430 | 3237430 | 2020-07-10 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-11 04:34:26 | Guainia, Colombia | ||
1005415 | 1005415 | 2020-07-09 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-10 04:34:24 | Guainia, Colombia | ||
1005420 | 1005420 | 2020-07-09 | Colombia | Guaviare | 39 | 0 | 11 | 28 | 1.0654 | -73.2603 | 2020-07-10 04:34:24 | Guaviare, Colombia | ||
2222631 | 2222631 | 2020-07-08 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-09 04:34:23 | Guainia, Colombia | ||
1136339 | 1136339 | 2020-06-26 | Colombia | Vaupes | 28 | 0 | 11 | 17 | 0.8554 | -70.812 | 2020-06-27 04:33:35 | Vaupes, Colombia | ||
2625326 | 2625326 | 2020-06-25 | Colombia | Vaupes | 28 | 0 | 11 | 17 | 0.8554 | -70.812 | 2020-06-26 04:33:43 | Vaupes, Colombia | ||
2700966 | 2700966 | 2020-06-24 | Colombia | Vaupes | 28 | 0 | 11 | 17 | 0.8554 | -70.812 | 2020-06-25 05:26:54 | Vaupes, Colombia | ||
1522651 | 1522651 | 2020-06-23 | Colombia | Vaupes | 28 | 0 | 11 | 17 | 0.8554 | -70.812 | 2020-06-24 04:33:28 | Vaupes, Colombia | ||
1510845 | 1510845 | 2020-06-22 | Colombia | Vaupes | 28 | 0 | 11 | 17 | 0.8554 | -70.812 | 2020-06-23 04:33:22 | Vaupes, Colombia | ||
3249584 | 3249584 | 2020-06-21 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-22 04:33:20 | Vaupes, Colombia | ||
2438177 | 2438177 | 2020-06-20 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-21 04:33:19 | Vaupes, Colombia | ||
1691755 | 1691755 | 2020-06-19 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-20 04:33:19 | Vaupes, Colombia | ||
3682904 | 3682904 | 2020-06-18 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-19 04:33:17 | Vaupes, Colombia | ||
1196107 | 1196107 | 2020-06-17 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-18 04:33:18 | Vaupes, Colombia | ||
2386870 | 2386870 | 2020-06-16 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-17 04:33:21 | Vaupes, Colombia | ||
287433 | 287433 | 2020-06-15 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-16 04:33:09 | Vaupes, Colombia | ||
1837384 | 1837384 | 2020-06-14 | Colombia | Vaupes | 27 | 0 | 11 | 16 | 0.8554 | -70.812 | 2020-06-15 03:33:14 | Vaupes, Colombia | ||
3061436 | 3061436 | 2020-06-13 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-14 03:33:15 | Vaupes, Colombia | ||
737756 | 737756 | 2020-06-12 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-13 03:33:14 | Vaupes, Colombia | ||
1273726 | 1273726 | 2020-06-11 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-12 05:09:52 | Vaupes, Colombia | ||
2864166 | 2864166 | 2020-06-10 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-11 03:33:41 | Vaupes, Colombia | ||
1210984 | 1210984 | 2020-06-09 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-10 04:07:00 | Vaupes, Colombia | ||
217411 | 217411 | 2020-06-08 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-09 03:33:03 | Vaupes, Colombia | ||
2800208 | 2800208 | 2020-06-07 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-08 03:33:22 | Vaupes, Colombia | ||
574264 | 574264 | 2020-06-06 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-07 03:53:30 | Vaupes, Colombia | ||
1269961 | 1269961 | 2020-06-05 | Colombia | Vaupes | 11 | 0 | 11 | 0 | 0.8554 | -70.812 | 2020-06-06 02:33:00 | Vaupes, Colombia | ||
805483 | 805483 | 2020-06-01 | Colombia | San Andres y Providencia | 17 | 0 | 11 | 6 | 12.5567 | -81.7185 | 2020-06-02 02:33:08 | San Andres y Providencia, Colombia | ||
1794046 | 1794046 | 2020-05-31 | Colombia | San Andres y Providencia | 17 | 0 | 11 | 6 | 12.5567 | -81.7185 | 2020-06-01 02:32:46 | San Andres y Providencia, Colombia | ||
3638939 | 3638939 | 2020-05-30 | Colombia | San Andres y Providencia | 17 | 0 | 11 | 6 | 12.5567 | -81.7185 | 2020-05-31 02:32:45 | San Andres y Providencia, Colombia | ||
1790480 | 1790480 | 2020-05-29 | Colombia | San Andres y Providencia | 17 | 0 | 11 | 6 | 12.5567 | -81.7185 | 2020-05-30 02:32:48 | San Andres y Providencia, Colombia | ||
2712359 | 2712359 | 2020-05-28 | Colombia | San Andres y Providencia | 17 | 0 | 11 | 6 | 12.5567 | -81.7185 | 2020-05-29 02:32:50 | San Andres y Providencia, 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]);