johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
945 rows where province_or_state = "Guainia" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, active, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
161 | 161 | 2021-12-02 | Colombia | Guainia | 2506 | 30 | 0 | 2.5854 | -68.5247 | 2021-12-03 04:23:05 | Guainia, Colombia | |||
4177 | 4177 | 2021-10-28 | Colombia | Guainia | 2309 | 29 | 0 | 2.5854 | -68.5247 | 2021-10-29 04:22:03 | 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 | ||
12187 | 12187 | 2021-01-26 | Colombia | Guainia | 1267 | 20 | 1229 | 18 | 2.5854 | -68.5247 | 2021-01-27 05:23:41 | Guainia, Colombia | ||
16202 | 16202 | 2021-09-18 | Colombia | Guainia | 2271 | 29 | 0 | 2.5854 | -68.5247 | 2021-09-19 04:21:34 | Guainia, Colombia | |||
20217 | 20217 | 2021-05-28 | Colombia | Guainia | 1745 | 22 | 1628 | 95 | 2.5854 | -68.5247 | 2021-05-29 04:20:41 | Guainia, Colombia | ||
24232 | 24232 | 2022-03-20 | Colombia | Guainia | 2756 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-21 04:20:50 | Guainia, Colombia | |||
28247 | 28247 | 2021-11-11 | Colombia | Guainia | 2342 | 30 | 0 | 2.5854 | -68.5247 | 2021-11-12 04:22:01 | Guainia, Colombia | |||
32263 | 32263 | 2021-08-25 | Colombia | Guainia | 2264 | 29 | 0 | 2.5854 | -68.5247 | 2021-08-26 04:21:28 | Guainia, Colombia | |||
36277 | 36277 | 2021-04-12 | Colombia | Guainia | 1348 | 22 | 1314 | 12 | 2.5854 | -68.5247 | 2021-04-13 04:20:37 | Guainia, Colombia | ||
43539 | 43539 | 2021-11-02 | Colombia | Guainia | 2321 | 29 | 0 | 2.5854 | -68.5247 | 2021-11-03 06:22:09 | Guainia, Colombia | |||
50638 | 50638 | 2021-05-29 | Colombia | Guainia | 1753 | 22 | 1655 | 76 | 2.5854 | -68.5247 | 2021-05-30 04:20:55 | Guainia, Colombia | ||
54652 | 54652 | 2021-03-07 | Colombia | Guainia | 1310 | 22 | 1280 | 8 | 2.5854 | -68.5247 | 2021-03-08 05:24:48 | Guainia, Colombia | ||
61883 | 61883 | 2020-07-23 | Colombia | Guainia | 14 | 1 | 13 | 0 | 2.5854 | -68.5247 | 2020-07-24 05:30:40 | Guainia, Colombia | ||
62893 | 62893 | 2022-11-12 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-11-13 04:21:14 | Guainia, Colombia | |||
66908 | 66908 | 2021-09-01 | Colombia | Guainia | 2266 | 29 | 0 | 2.5854 | -68.5247 | 2021-09-02 04:21:15 | Guainia, Colombia | |||
70922 | 70922 | 2022-02-07 | Colombia | Guainia | 2737 | 36 | 0 | 2.5854 | -68.5247 | 2022-02-08 04:21:15 | Guainia, Colombia | |||
74937 | 74937 | 2020-12-03 | Colombia | Guainia | 1209 | 19 | 1175 | 15 | 2.5854 | -68.5247 | 2020-12-04 05:27:27 | Guainia, Colombia | ||
78936 | 78936 | 2020-10-14 | Colombia | Guainia | 1028 | 17 | 960 | 51 | 2.5854 | -68.5247 | 2020-10-15 04:24:28 | Guainia, Colombia | ||
82942 | 82942 | 2021-05-25 | Colombia | Guainia | 1679 | 22 | 1583 | 74 | 2.5854 | -68.5247 | 2021-05-26 04:20:35 | Guainia, Colombia | ||
86956 | 86956 | 2021-11-09 | Colombia | Guainia | 2332 | 30 | 0 | 2.5854 | -68.5247 | 2021-11-10 04:21:38 | Guainia, Colombia | |||
90973 | 90973 | 2022-07-23 | Colombia | Guainia | 2768 | 37 | 0 | 2.5854 | -68.5247 | 2022-07-24 04:20:47 | Guainia, Colombia | |||
98223 | 98223 | 2020-08-04 | Colombia | Guainia | 14 | 1 | 13 | 0 | 2.5854 | -68.5247 | 2020-08-05 04:34:43 | Guainia, Colombia | ||
99157 | 99157 | 2022-01-14 | Colombia | Guainia | 2603 | 35 | 0 | 2.5854 | -68.5247 | 2022-01-15 04:21:07 | Guainia, Colombia | |||
103173 | 103173 | 2021-08-15 | Colombia | Guainia | 2254 | 29 | 0 | 2.5854 | -68.5247 | 2021-08-16 04:21:31 | 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 | ||
114583 | 114583 | 2022-09-06 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-09-07 04:20:59 | Guainia, Colombia | |||
121816 | 121816 | 2020-07-19 | Colombia | Guainia | 14 | 1 | 13 | 0 | 2.5854 | -68.5247 | 2020-07-20 05:34:40 | Guainia, Colombia | ||
122552 | 122552 | 2020-11-18 | Colombia | Guainia | 1171 | 19 | 1143 | 9 | 2.5854 | -68.5247 | 2020-11-19 05:25:23 | Guainia, Colombia | ||
126564 | 126564 | 2022-01-09 | Colombia | Guainia | 2586 | 35 | 0 | 2.5854 | -68.5247 | 2022-01-10 04:22:07 | Guainia, Colombia | |||
130581 | 130581 | 2022-10-04 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-10-05 04:23:06 | Guainia, Colombia | |||
137802 | 137802 | 2021-12-04 | Colombia | Guainia | 2518 | 30 | 0 | 2.5854 | -68.5247 | 2021-12-05 04:22:25 | Guainia, Colombia | |||
141819 | 141819 | 2022-07-09 | Colombia | Guainia | 2768 | 37 | 0 | 2.5854 | -68.5247 | 2022-07-10 04:20:54 | Guainia, Colombia | |||
145821 | 145821 | 2020-08-15 | Colombia | Guainia | 14 | 1 | 13 | 0 | 2.5854 | -68.5247 | 2020-08-16 04:27:42 | Guainia, Colombia | ||
149815 | 149815 | 2021-11-29 | Colombia | Guainia | 2493 | 30 | 0 | 2.5854 | -68.5247 | 2021-11-30 04:22:53 | Guainia, Colombia | |||
153830 | 153830 | 2021-01-08 | Colombia | Guainia | 1238 | 20 | 1209 | 9 | 2.5854 | -68.5247 | 2021-01-09 05:22:18 | Guainia, Colombia | ||
157844 | 157844 | 2022-03-29 | Colombia | Guainia | 2764 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-30 04:20:45 | Guainia, Colombia | |||
161859 | 161859 | 2021-11-19 | Colombia | Guainia | 2387 | 30 | 0 | 2.5854 | -68.5247 | 2021-11-20 04:22:17 | Guainia, Colombia | |||
165876 | 165876 | 2022-06-21 | Colombia | Guainia | 2767 | 37 | 0 | 2.5854 | -68.5247 | 2022-06-22 04:20:54 | Guainia, Colombia | |||
169891 | 169891 | 2021-04-16 | Colombia | Guainia | 1370 | 22 | 1332 | 16 | 2.5854 | -68.5247 | 2021-04-17 04:20:40 | Guainia, Colombia | ||
177134 | 177134 | 2020-07-27 | Colombia | Guainia | 14 | 1 | 13 | 0 | 2.5854 | -68.5247 | 2020-07-28 04:58:43 | Guainia, Colombia | ||
177873 | 177873 | 2021-09-02 | Colombia | Guainia | 2267 | 29 | 0 | 2.5854 | -68.5247 | 2021-09-03 04:21:20 | Guainia, Colombia | |||
181887 | 181887 | 2021-02-21 | Colombia | Guainia | 1301 | 22 | 1272 | 7 | 2.5854 | -68.5247 | 2021-02-22 05:24:21 | Guainia, Colombia | ||
185902 | 185902 | 2022-02-13 | Colombia | Guainia | 2746 | 36 | 0 | 2.5854 | -68.5247 | 2022-02-14 04:20:51 | Guainia, Colombia | |||
189916 | 189916 | 2021-01-11 | Colombia | Guainia | 1241 | 20 | 1212 | 9 | 2.5854 | -68.5247 | 2021-01-12 05:22:15 | Guainia, Colombia | ||
193916 | 193916 | 2020-08-31 | Colombia | Guainia | 140 | 2 | 17 | 121 | 2.5854 | -68.5247 | 2020-09-01 04:28:31 | Guainia, Colombia | ||
198090 | 198090 | 2022-10-19 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-10-20 04:22:59 | Guainia, Colombia | |||
202104 | 202104 | 2020-12-25 | Colombia | Guainia | 1229 | 19 | 1204 | 6 | 2.5854 | -68.5247 | 2020-12-26 05:22:28 | Guainia, Colombia | ||
206103 | 206103 | 2020-08-19 | Colombia | Guainia | 20 | 2 | 13 | 5 | 2.5854 | -68.5247 | 2020-08-20 04:27:43 | 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 | ||
217111 | 217111 | 2020-06-08 | Colombia | Guainia | 6 | 0 | 0 | 6 | 2.5854 | -68.5247 | 2020-06-09 03:33:03 | Guainia, Colombia | ||
217811 | 217811 | 2022-12-26 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-12-27 04:21:07 | Guainia, Colombia | |||
221827 | 221827 | 2022-05-09 | Colombia | Guainia | 2765 | 37 | 0 | 2.5854 | -68.5247 | 2022-05-10 04:20:50 | Guainia, Colombia | |||
229058 | 229058 | 2022-05-31 | Colombia | Guainia | 2767 | 37 | 0 | 2.5854 | -68.5247 | 2022-06-01 04:20:55 | Guainia, Colombia | |||
233074 | 233074 | 2022-02-11 | Colombia | Guainia | 2745 | 36 | 0 | 2.5854 | -68.5247 | 2022-02-12 04:21:06 | Guainia, Colombia | |||
237088 | 237088 | 2021-01-18 | Colombia | Guainia | 1246 | 20 | 1217 | 9 | 2.5854 | -68.5247 | 2021-01-19 05:22:15 | Guainia, Colombia | ||
241102 | 241102 | 2021-04-02 | Colombia | Guainia | 1338 | 22 | 1309 | 7 | 2.5854 | -68.5247 | 2021-04-03 04:20:44 | Guainia, Colombia | ||
245116 | 245116 | 2021-08-17 | Colombia | Guainia | 2255 | 29 | 0 | 2.5854 | -68.5247 | 2021-08-18 04:21:35 | Guainia, Colombia | |||
249130 | 249130 | 2021-09-04 | Colombia | Guainia | 2267 | 29 | 0 | 2.5854 | -68.5247 | 2021-09-05 04:21:33 | Guainia, Colombia | |||
253145 | 253145 | 2022-09-08 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-09-09 04:21:11 | Guainia, Colombia | |||
257161 | 257161 | 2022-12-10 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-12-11 04:20:50 | Guainia, Colombia | |||
261364 | 261364 | 2022-03-15 | Colombia | Guainia | 2754 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-16 04:20:50 | Guainia, Colombia | |||
272003 | 272003 | 2020-11-10 | Colombia | Guainia | 1164 | 19 | 1137 | 8 | 2.5854 | -68.5247 | 2020-11-11 05:25:30 | Guainia, Colombia | ||
276014 | 276014 | 2021-11-03 | Colombia | Guainia | 2321 | 29 | 0 | 2.5854 | -68.5247 | 2021-11-04 04:22:20 | Guainia, Colombia | |||
280030 | 280030 | 2021-02-24 | Colombia | Guainia | 1301 | 22 | 1272 | 7 | 2.5854 | -68.5247 | 2021-02-25 05:24:57 | Guainia, Colombia | ||
287101 | 287101 | 2020-06-15 | Colombia | Guainia | 7 | 1 | 0 | 6 | 2.5854 | -68.5247 | 2020-06-16 04:33:09 | Guainia, Colombia | ||
287827 | 287827 | 2021-10-31 | Colombia | Guainia | 2312 | 29 | 0 | 2.5854 | -68.5247 | 2021-11-01 04:22:01 | Guainia, Colombia | |||
291844 | 291844 | 2022-11-15 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-11-16 04:21:09 | Guainia, Colombia | |||
295859 | 295859 | 2021-07-15 | Colombia | Guainia | 2147 | 28 | 2108 | 11 | 2.5854 | -68.5247 | 2021-07-16 04:21:22 | Guainia, Colombia | ||
302973 | 302973 | 2020-07-01 | Colombia | Guainia | 15 | 1 | 2 | 12 | 2.5854 | -68.5247 | 2020-07-02 04:33:46 | Guainia, Colombia | ||
303700 | 303700 | 2022-04-16 | Colombia | Guainia | 2765 | 37 | 0 | 2.5854 | -68.5247 | 2022-04-17 04:20:59 | Guainia, Colombia | |||
307716 | 307716 | 2022-12-13 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-12-14 04:21:04 | Guainia, Colombia | |||
311732 | 311732 | 2022-11-13 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-11-14 04:21:09 | Guainia, Colombia | |||
315748 | 315748 | 2022-02-12 | Colombia | Guainia | 2746 | 36 | 0 | 2.5854 | -68.5247 | 2022-02-13 04:21:00 | Guainia, Colombia | |||
319764 | 319764 | 2022-10-30 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-10-31 04:21:36 | Guainia, Colombia | |||
326911 | 326911 | 2020-07-20 | Colombia | Guainia | 14 | 1 | 13 | 0 | 2.5854 | -68.5247 | 2020-07-21 04:38:46 | Guainia, Colombia | ||
327738 | 327738 | 2022-12-27 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-12-28 04:21:04 | Guainia, Colombia | |||
331753 | 331753 | 2021-08-04 | Colombia | Guainia | 2214 | 29 | 2175 | 10 | 2.5854 | -68.5247 | 2021-08-05 04:21:51 | Guainia, Colombia | ||
335768 | 335768 | 2022-03-18 | Colombia | Guainia | 2754 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-19 04:20:47 | Guainia, Colombia | |||
340122 | 340122 | 2021-02-03 | Colombia | Guainia | 1280 | 22 | 1251 | 7 | 2.5854 | -68.5247 | 2021-02-04 05:22:26 | Guainia, Colombia | ||
344124 | 344124 | 2020-09-14 | Colombia | Guainia | 349 | 9 | 216 | 124 | 2.5854 | -68.5247 | 2020-09-15 03:22:50 | Guainia, Colombia | ||
348128 | 348128 | 2022-12-14 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-12-15 04:20:58 | Guainia, Colombia | |||
352143 | 352143 | 2021-03-11 | Colombia | Guainia | 1327 | 22 | 1285 | 20 | 2.5854 | -68.5247 | 2021-03-12 05:26:50 | Guainia, Colombia | ||
356158 | 356158 | 2022-03-11 | Colombia | Guainia | 2755 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-12 04:20:50 | Guainia, Colombia | |||
360174 | 360174 | 2022-05-07 | Colombia | Guainia | 2765 | 37 | 0 | 2.5854 | -68.5247 | 2022-05-08 04:20:49 | Guainia, Colombia | |||
367321 | 367321 | 2020-07-16 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-17 04:34:50 | Guainia, Colombia | ||
371288 | 371288 | 2020-08-08 | Colombia | Guainia | 14 | 1 | 13 | 0 | 2.5854 | -68.5247 | 2020-08-09 04:34:54 | Guainia, Colombia | ||
372028 | 372028 | 2022-09-13 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-09-14 04:20:44 | 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 | ||
380040 | 380040 | 2021-04-30 | Colombia | Guainia | 1427 | 22 | 1388 | 17 | 2.5854 | -68.5247 | 2021-05-01 04:20:47 | Guainia, Colombia | ||
384055 | 384055 | 2022-09-23 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-09-24 04:21:40 | Guainia, Colombia | |||
388070 | 388070 | 2021-04-04 | Colombia | Guainia | 1338 | 22 | 1310 | 6 | 2.5854 | -68.5247 | 2021-04-05 04:20:35 | Guainia, Colombia | ||
392083 | 392083 | 2020-11-27 | Colombia | Guainia | 1200 | 19 | 1163 | 18 | 2.5854 | -68.5247 | 2020-11-28 05:25:50 | Guainia, Colombia | ||
396096 | 396096 | 2022-10-07 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-10-08 04:22:56 | Guainia, Colombia | |||
400111 | 400111 | 2021-06-29 | Colombia | Guainia | 2042 | 23 | 1994 | 25 | 2.5854 | -68.5247 | 2021-06-30 04:21:41 | Guainia, Colombia | ||
404125 | 404125 | 2021-12-07 | Colombia | Guainia | 2522 | 30 | 0 | 2.5854 | -68.5247 | 2021-12-08 04:22:46 | Guainia, Colombia | |||
408141 | 408141 | 2021-07-28 | Colombia | Guainia | 2213 | 29 | 2170 | 14 | 2.5854 | -68.5247 | 2021-07-29 04:21:33 | Guainia, Colombia | ||
415265 | 415265 | 2020-07-05 | Colombia | Guainia | 14 | 1 | 2 | 11 | 2.5854 | -68.5247 | 2020-07-06 04:33:57 | Guainia, Colombia | ||
419167 | 419167 | 2022-09-18 | Colombia | Guainia | 2792 | 37 | 0 | 2.5854 | -68.5247 | 2022-09-19 04:21:49 | Guainia, Colombia | |||
423182 | 423182 | 2021-10-10 | Colombia | Guainia | 2295 | 29 | 0 | 2.5854 | -68.5247 | 2021-10-11 04:21:31 | Guainia, 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]);