johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Magdalena" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
165 | 165 | 2021-12-02 | Colombia | Magdalena | 100146 | 3439 | 0 | 10.4113 | -74.4057 | 2021-12-03 04:23:05 | Magdalena, Colombia | |||
4181 | 4181 | 2021-10-28 | Colombia | Magdalena | 96274 | 3364 | 0 | 10.4113 | -74.4057 | 2021-10-29 04:22:03 | Magdalena, Colombia | |||
8184 | 8184 | 2020-10-25 | Colombia | Magdalena | 16859 | 887 | 15293 | 679 | 10.4113 | -74.4057 | 2020-10-26 04:25:02 | Magdalena, Colombia | ||
12191 | 12191 | 2021-01-26 | Colombia | Magdalena | 28892 | 1158 | 26594 | 1140 | 10.4113 | -74.4057 | 2021-01-27 05:23:41 | Magdalena, Colombia | ||
16206 | 16206 | 2021-09-18 | Colombia | Magdalena | 93166 | 3303 | 0 | 10.4113 | -74.4057 | 2021-09-19 04:21:34 | Magdalena, Colombia | |||
20221 | 20221 | 2021-05-28 | Colombia | Magdalena | 69495 | 2637 | 65226 | 1632 | 10.4113 | -74.4057 | 2021-05-29 04:20:41 | Magdalena, Colombia | ||
24236 | 24236 | 2022-03-20 | Colombia | Magdalena | 114743 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-21 04:20:50 | Magdalena, Colombia | |||
28251 | 28251 | 2021-11-11 | Colombia | Magdalena | 97846 | 3394 | 0 | 10.4113 | -74.4057 | 2021-11-12 04:22:01 | Magdalena, Colombia | |||
32267 | 32267 | 2021-08-25 | Colombia | Magdalena | 91581 | 3273 | 0 | 10.4113 | -74.4057 | 2021-08-26 04:21:28 | Magdalena, Colombia | |||
36281 | 36281 | 2021-04-12 | Colombia | Magdalena | 49367 | 1829 | 45631 | 1907 | 10.4113 | -74.4057 | 2021-04-13 04:20:37 | Magdalena, Colombia | ||
43543 | 43543 | 2021-11-02 | Colombia | Magdalena | 96758 | 3375 | 0 | 10.4113 | -74.4057 | 2021-11-03 06:22:09 | Magdalena, Colombia | |||
50642 | 50642 | 2021-05-29 | Colombia | Magdalena | 69705 | 2646 | 65549 | 1510 | 10.4113 | -74.4057 | 2021-05-30 04:20:55 | Magdalena, Colombia | ||
54656 | 54656 | 2021-03-07 | Colombia | Magdalena | 35733 | 1344 | 33138 | 1251 | 10.4113 | -74.4057 | 2021-03-08 05:24:48 | Magdalena, Colombia | ||
61988 | 61988 | 2020-07-23 | Colombia | Magdalena | 4771 | 293 | 2154 | 2324 | 10.4113 | -74.4057 | 2020-07-24 05:30:40 | Magdalena, Colombia | ||
62897 | 62897 | 2022-11-12 | Colombia | Magdalena | 117491 | 3647 | 0 | 10.4113 | -74.4057 | 2022-11-13 04:21:14 | Magdalena, Colombia | |||
66912 | 66912 | 2021-09-01 | Colombia | Magdalena | 92123 | 3281 | 0 | 10.4113 | -74.4057 | 2021-09-02 04:21:15 | Magdalena, Colombia | |||
70926 | 70926 | 2022-02-07 | Colombia | Magdalena | 113339 | 3557 | 0 | 10.4113 | -74.4057 | 2022-02-08 04:21:15 | Magdalena, Colombia | |||
74941 | 74941 | 2020-12-03 | Colombia | Magdalena | 20683 | 986 | 18674 | 1023 | 10.4113 | -74.4057 | 2020-12-04 05:27:27 | Magdalena, Colombia | ||
78940 | 78940 | 2020-10-14 | Colombia | Magdalena | 16220 | 865 | 14487 | 868 | 10.4113 | -74.4057 | 2020-10-15 04:24:28 | Magdalena, Colombia | ||
82946 | 82946 | 2021-05-25 | Colombia | Magdalena | 68326 | 2591 | 63966 | 1769 | 10.4113 | -74.4057 | 2021-05-26 04:20:35 | Magdalena, Colombia | ||
86960 | 86960 | 2021-11-09 | Colombia | Magdalena | 97624 | 3387 | 0 | 10.4113 | -74.4057 | 2021-11-10 04:21:38 | Magdalena, Colombia | |||
90977 | 90977 | 2022-07-23 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-24 04:20:47 | Magdalena, Colombia | |||
98333 | 98333 | 2020-08-04 | Colombia | Magdalena | 7200 | 391 | 3946 | 2863 | 10.4113 | -74.4057 | 2020-08-05 04:34:43 | Magdalena, Colombia | ||
99161 | 99161 | 2022-01-14 | Colombia | Magdalena | 104711 | 3496 | 0 | 10.4113 | -74.4057 | 2022-01-15 04:21:07 | Magdalena, Colombia | |||
103177 | 103177 | 2021-08-15 | Colombia | Magdalena | 90477 | 3244 | 0 | 10.4113 | -74.4057 | 2021-08-16 04:21:31 | Magdalena, Colombia | |||
107302 | 107302 | 2021-06-19 | Colombia | Magdalena | 76432 | 2856 | 72026 | 1550 | 10.4113 | -74.4057 | 2021-06-20 04:21:48 | Magdalena, Colombia | ||
114587 | 114587 | 2022-09-06 | Colombia | Magdalena | 117353 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-07 04:20:59 | Magdalena, Colombia | |||
121925 | 121925 | 2020-07-19 | Colombia | Magdalena | 4179 | 259 | 1680 | 2240 | 10.4113 | -74.4057 | 2020-07-20 05:34:40 | Magdalena, Colombia | ||
122556 | 122556 | 2020-11-18 | Colombia | Magdalena | 18740 | 948 | 17132 | 660 | 10.4113 | -74.4057 | 2020-11-19 05:25:23 | Magdalena, Colombia | ||
126568 | 126568 | 2022-01-09 | Colombia | Magdalena | 102865 | 3493 | 0 | 10.4113 | -74.4057 | 2022-01-10 04:22:07 | Magdalena, Colombia | |||
130585 | 130585 | 2022-10-04 | Colombia | Magdalena | 117397 | 3643 | 0 | 10.4113 | -74.4057 | 2022-10-05 04:23:06 | Magdalena, Colombia | |||
137806 | 137806 | 2021-12-04 | Colombia | Magdalena | 100330 | 3443 | 0 | 10.4113 | -74.4057 | 2021-12-05 04:22:25 | Magdalena, Colombia | |||
141823 | 141823 | 2022-07-09 | Colombia | Magdalena | 116470 | 3635 | 0 | 10.4113 | -74.4057 | 2022-07-10 04:20:54 | Magdalena, Colombia | |||
145825 | 145825 | 2020-08-15 | Colombia | Magdalena | 9915 | 498 | 6037 | 3380 | 10.4113 | -74.4057 | 2020-08-16 04:27:42 | Magdalena, Colombia | ||
149819 | 149819 | 2021-11-29 | Colombia | Magdalena | 99874 | 3435 | 0 | 10.4113 | -74.4057 | 2021-11-30 04:22:53 | Magdalena, Colombia | |||
153834 | 153834 | 2021-01-08 | Colombia | Magdalena | 25754 | 1101 | 23703 | 950 | 10.4113 | -74.4057 | 2021-01-09 05:22:18 | Magdalena, Colombia | ||
157848 | 157848 | 2022-03-29 | Colombia | Magdalena | 114793 | 3621 | 0 | 10.4113 | -74.4057 | 2022-03-30 04:20:45 | Magdalena, Colombia | |||
161863 | 161863 | 2021-11-19 | Colombia | Magdalena | 98771 | 3411 | 0 | 10.4113 | -74.4057 | 2021-11-20 04:22:17 | Magdalena, Colombia | |||
165880 | 165880 | 2022-06-21 | Colombia | Magdalena | 115798 | 3625 | 0 | 10.4113 | -74.4057 | 2022-06-22 04:20:54 | Magdalena, Colombia | |||
169895 | 169895 | 2021-04-16 | Colombia | Magdalena | 51433 | 1904 | 47268 | 2261 | 10.4113 | -74.4057 | 2021-04-17 04:20:40 | Magdalena, Colombia | ||
177243 | 177243 | 2020-07-27 | Colombia | Magdalena | 5397 | 320 | 2746 | 2331 | 10.4113 | -74.4057 | 2020-07-28 04:58:43 | Magdalena, Colombia | ||
177877 | 177877 | 2021-09-02 | Colombia | Magdalena | 92203 | 3286 | 0 | 10.4113 | -74.4057 | 2021-09-03 04:21:20 | Magdalena, Colombia | |||
181891 | 181891 | 2021-02-21 | Colombia | Magdalena | 32710 | 1251 | 30562 | 897 | 10.4113 | -74.4057 | 2021-02-22 05:24:21 | Magdalena, Colombia | ||
185906 | 185906 | 2022-02-13 | Colombia | Magdalena | 114003 | 3584 | 0 | 10.4113 | -74.4057 | 2022-02-14 04:20:51 | Magdalena, Colombia | |||
189920 | 189920 | 2021-01-11 | Colombia | Magdalena | 26291 | 1113 | 24081 | 1097 | 10.4113 | -74.4057 | 2021-01-12 05:22:15 | Magdalena, Colombia | ||
193920 | 193920 | 2020-08-31 | Colombia | Magdalena | 12460 | 682 | 9643 | 2135 | 10.4113 | -74.4057 | 2020-09-01 04:28:31 | Magdalena, Colombia | ||
198094 | 198094 | 2022-10-19 | Colombia | Magdalena | 117421 | 3643 | 0 | 10.4113 | -74.4057 | 2022-10-20 04:22:59 | Magdalena, Colombia | |||
202108 | 202108 | 2020-12-25 | Colombia | Magdalena | 24057 | 1045 | 21792 | 1220 | 10.4113 | -74.4057 | 2020-12-26 05:22:28 | Magdalena, Colombia | ||
206107 | 206107 | 2020-08-19 | Colombia | Magdalena | 10666 | 554 | 7021 | 3091 | 10.4113 | -74.4057 | 2020-08-20 04:27:43 | Magdalena, Colombia | ||
210092 | 210092 | 2020-10-29 | Colombia | Magdalena | 17071 | 896 | 15479 | 696 | 10.4113 | -74.4057 | 2020-10-30 04:24:49 | Magdalena, Colombia | ||
217207 | 217207 | 2020-06-08 | Colombia | Magdalena | 780 | 48 | 380 | 352 | 10.4113 | -74.4057 | 2020-06-09 03:33:03 | Magdalena, Colombia | ||
217815 | 217815 | 2022-12-26 | Colombia | Magdalena | 117660 | 3653 | 0 | 10.4113 | -74.4057 | 2022-12-27 04:21:07 | Magdalena, Colombia | |||
221831 | 221831 | 2022-05-09 | Colombia | Magdalena | 114982 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-10 04:20:50 | Magdalena, Colombia | |||
229062 | 229062 | 2022-05-31 | Colombia | Magdalena | 115176 | 3624 | 0 | 10.4113 | -74.4057 | 2022-06-01 04:20:55 | Magdalena, Colombia | |||
233078 | 233078 | 2022-02-11 | Colombia | Magdalena | 113877 | 3576 | 0 | 10.4113 | -74.4057 | 2022-02-12 04:21:06 | Magdalena, Colombia | |||
237092 | 237092 | 2021-01-18 | Colombia | Magdalena | 27721 | 1140 | 25399 | 1182 | 10.4113 | -74.4057 | 2021-01-19 05:22:15 | Magdalena, Colombia | ||
241106 | 241106 | 2021-04-02 | Colombia | Magdalena | 45009 | 1639 | 41687 | 1683 | 10.4113 | -74.4057 | 2021-04-03 04:20:44 | Magdalena, Colombia | ||
245120 | 245120 | 2021-08-17 | Colombia | Magdalena | 90613 | 3249 | 0 | 10.4113 | -74.4057 | 2021-08-18 04:21:35 | Magdalena, Colombia | |||
249134 | 249134 | 2021-09-04 | Colombia | Magdalena | 92351 | 3286 | 0 | 10.4113 | -74.4057 | 2021-09-05 04:21:33 | Magdalena, Colombia | |||
253149 | 253149 | 2022-09-08 | Colombia | Magdalena | 117366 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-09 04:21:11 | Magdalena, Colombia | |||
257165 | 257165 | 2022-12-10 | Colombia | Magdalena | 117580 | 3652 | 0 | 10.4113 | -74.4057 | 2022-12-11 04:20:50 | Magdalena, Colombia | |||
261368 | 261368 | 2022-03-15 | Colombia | Magdalena | 114726 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-16 04:20:50 | Magdalena, Colombia | |||
272007 | 272007 | 2020-11-10 | Colombia | Magdalena | 18011 | 928 | 16334 | 749 | 10.4113 | -74.4057 | 2020-11-11 05:25:30 | Magdalena, Colombia | ||
276018 | 276018 | 2021-11-03 | Colombia | Magdalena | 96894 | 3376 | 0 | 10.4113 | -74.4057 | 2021-11-04 04:22:20 | Magdalena, Colombia | |||
280034 | 280034 | 2021-02-24 | Colombia | Magdalena | 32968 | 1266 | 30817 | 885 | 10.4113 | -74.4057 | 2021-02-25 05:24:57 | Magdalena, Colombia | ||
287208 | 287208 | 2020-06-15 | Colombia | Magdalena | 973 | 65 | 445 | 463 | 10.4113 | -74.4057 | 2020-06-16 04:33:09 | Magdalena, Colombia | ||
287831 | 287831 | 2021-10-31 | Colombia | Magdalena | 96498 | 3372 | 0 | 10.4113 | -74.4057 | 2021-11-01 04:22:01 | Magdalena, Colombia | |||
291848 | 291848 | 2022-11-15 | Colombia | Magdalena | 117491 | 3647 | 0 | 10.4113 | -74.4057 | 2022-11-16 04:21:09 | Magdalena, Colombia | |||
295863 | 295863 | 2021-07-15 | Colombia | Magdalena | 85123 | 3077 | 80497 | 1549 | 10.4113 | -74.4057 | 2021-07-16 04:21:22 | Magdalena, Colombia | ||
303080 | 303080 | 2020-07-01 | Colombia | Magdalena | 1854 | 121 | 778 | 955 | 10.4113 | -74.4057 | 2020-07-02 04:33:46 | Magdalena, Colombia | ||
303704 | 303704 | 2022-04-16 | Colombia | Magdalena | 114909 | 3621 | 0 | 10.4113 | -74.4057 | 2022-04-17 04:20:59 | Magdalena, Colombia | |||
307720 | 307720 | 2022-12-13 | Colombia | Magdalena | 117580 | 3652 | 0 | 10.4113 | -74.4057 | 2022-12-14 04:21:04 | Magdalena, Colombia | |||
311736 | 311736 | 2022-11-13 | Colombia | Magdalena | 117491 | 3647 | 0 | 10.4113 | -74.4057 | 2022-11-14 04:21:09 | Magdalena, Colombia | |||
315752 | 315752 | 2022-02-12 | Colombia | Magdalena | 113916 | 3581 | 0 | 10.4113 | -74.4057 | 2022-02-13 04:21:00 | Magdalena, Colombia | |||
319768 | 319768 | 2022-10-30 | Colombia | Magdalena | 117440 | 3644 | 0 | 10.4113 | -74.4057 | 2022-10-31 04:21:36 | Magdalena, Colombia | |||
327020 | 327020 | 2020-07-20 | Colombia | Magdalena | 4348 | 271 | 1821 | 2256 | 10.4113 | -74.4057 | 2020-07-21 04:38:46 | Magdalena, Colombia | ||
327742 | 327742 | 2022-12-27 | Colombia | Magdalena | 117660 | 3653 | 0 | 10.4113 | -74.4057 | 2022-12-28 04:21:04 | Magdalena, Colombia | |||
331757 | 331757 | 2021-08-04 | Colombia | Magdalena | 89055 | 3198 | 84764 | 1093 | 10.4113 | -74.4057 | 2021-08-05 04:21:51 | Magdalena, Colombia | ||
335772 | 335772 | 2022-03-18 | Colombia | Magdalena | 114738 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-19 04:20:47 | Magdalena, Colombia | |||
340126 | 340126 | 2021-02-03 | Colombia | Magdalena | 30309 | 1189 | 28136 | 984 | 10.4113 | -74.4057 | 2021-02-04 05:22:26 | Magdalena, Colombia | ||
344128 | 344128 | 2020-09-14 | Colombia | Magdalena | 13871 | 762 | 11874 | 1235 | 10.4113 | -74.4057 | 2020-09-15 03:22:50 | Magdalena, Colombia | ||
348132 | 348132 | 2022-12-14 | Colombia | Magdalena | 117580 | 3652 | 0 | 10.4113 | -74.4057 | 2022-12-15 04:20:58 | Magdalena, Colombia | |||
352147 | 352147 | 2021-03-11 | Colombia | Magdalena | 36763 | 1368 | 34093 | 1302 | 10.4113 | -74.4057 | 2021-03-12 05:26:50 | Magdalena, Colombia | ||
356162 | 356162 | 2022-03-11 | Colombia | Magdalena | 114686 | 3620 | 0 | 10.4113 | -74.4057 | 2022-03-12 04:20:50 | Magdalena, Colombia | |||
360178 | 360178 | 2022-05-07 | Colombia | Magdalena | 114982 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-08 04:20:49 | Magdalena, Colombia | |||
367428 | 367428 | 2020-07-16 | Colombia | Magdalena | 3043 | 221 | 1224 | 1598 | 10.4113 | -74.4057 | 2020-07-17 04:34:50 | Magdalena, Colombia | ||
371398 | 371398 | 2020-08-08 | Colombia | Magdalena | 8144 | 427 | 4639 | 3078 | 10.4113 | -74.4057 | 2020-08-09 04:34:54 | Magdalena, Colombia | ||
372032 | 372032 | 2022-09-13 | Colombia | Magdalena | 117366 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-14 04:20:44 | Magdalena, Colombia | |||
376034 | 376034 | 2020-11-06 | Colombia | Magdalena | 17700 | 916 | 16042 | 742 | 10.4113 | -74.4057 | 2020-11-07 05:24:52 | Magdalena, Colombia | ||
380044 | 380044 | 2021-04-30 | Colombia | Magdalena | 59442 | 2241 | 54873 | 2328 | 10.4113 | -74.4057 | 2021-05-01 04:20:47 | Magdalena, Colombia | ||
384059 | 384059 | 2022-09-23 | Colombia | Magdalena | 117397 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-24 04:21:40 | Magdalena, Colombia | |||
388074 | 388074 | 2021-04-04 | Colombia | Magdalena | 45859 | 1671 | 42434 | 1754 | 10.4113 | -74.4057 | 2021-04-05 04:20:35 | Magdalena, Colombia | ||
392087 | 392087 | 2020-11-27 | Colombia | Magdalena | 19760 | 964 | 17907 | 889 | 10.4113 | -74.4057 | 2020-11-28 05:25:50 | Magdalena, Colombia | ||
396100 | 396100 | 2022-10-07 | Colombia | Magdalena | 117408 | 3643 | 0 | 10.4113 | -74.4057 | 2022-10-08 04:22:56 | Magdalena, Colombia | |||
400115 | 400115 | 2021-06-29 | Colombia | Magdalena | 80335 | 2971 | 75216 | 2148 | 10.4113 | -74.4057 | 2021-06-30 04:21:41 | Magdalena, Colombia | ||
404129 | 404129 | 2021-12-07 | Colombia | Magdalena | 100421 | 3447 | 0 | 10.4113 | -74.4057 | 2021-12-08 04:22:46 | Magdalena, Colombia | |||
408145 | 408145 | 2021-07-28 | Colombia | Magdalena | 88039 | 3166 | 83663 | 1210 | 10.4113 | -74.4057 | 2021-07-29 04:21:33 | Magdalena, Colombia | ||
415372 | 415372 | 2020-07-05 | Colombia | Magdalena | 2081 | 156 | 827 | 1098 | 10.4113 | -74.4057 | 2020-07-06 04:33:57 | Magdalena, Colombia | ||
419171 | 419171 | 2022-09-18 | Colombia | Magdalena | 117386 | 3643 | 0 | 10.4113 | -74.4057 | 2022-09-19 04:21:49 | Magdalena, Colombia | |||
423186 | 423186 | 2021-10-10 | Colombia | Magdalena | 94911 | 3337 | 0 | 10.4113 | -74.4057 | 2021-10-11 04:21:31 | Magdalena, 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]);