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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
722333 | 722333 | 2021-11-20 | Colombia | Magdalena | 98931 | 3411 | 0 | 10.4113 | -74.4057 | 2021-11-21 04:22:13 | Magdalena, Colombia | |||
161863 | 161863 | 2021-11-19 | Colombia | Magdalena | 98771 | 3411 | 0 | 10.4113 | -74.4057 | 2021-11-20 04:22:17 | Magdalena, Colombia | |||
3288750 | 3288750 | 2021-11-18 | Colombia | Magdalena | 98683 | 3408 | 0 | 10.4113 | -74.4057 | 2021-11-19 04:21:40 | Magdalena, Colombia | |||
447206 | 447206 | 2021-11-17 | Colombia | Magdalena | 98647 | 3408 | 0 | 10.4113 | -74.4057 | 2021-11-18 04:21:33 | Magdalena, Colombia | |||
3342456 | 3342456 | 2021-11-16 | Colombia | Magdalena | 98501 | 3405 | 0 | 10.4113 | -74.4057 | 2021-11-17 04:21:48 | Magdalena, Colombia | |||
2287292 | 2287292 | 2021-11-15 | Colombia | Magdalena | 98405 | 3402 | 0 | 10.4113 | -74.4057 | 2021-11-16 04:21:10 | Magdalena, Colombia | |||
1322066 | 1322066 | 2021-11-14 | Colombia | Magdalena | 98242 | 3401 | 0 | 10.4113 | -74.4057 | 2021-11-15 04:21:36 | Magdalena, Colombia | |||
686192 | 686192 | 2021-11-13 | Colombia | Magdalena | 98071 | 3398 | 0 | 10.4113 | -74.4057 | 2021-11-14 04:21:31 | Magdalena, Colombia | |||
714301 | 714301 | 2021-11-12 | Colombia | Magdalena | 97957 | 3396 | 0 | 10.4113 | -74.4057 | 2021-11-13 04:21:38 | Magdalena, Colombia | |||
28251 | 28251 | 2021-11-11 | Colombia | Magdalena | 97846 | 3394 | 0 | 10.4113 | -74.4057 | 2021-11-12 04:22:01 | Magdalena, Colombia | |||
2844690 | 2844690 | 2021-11-10 | Colombia | Magdalena | 97753 | 3393 | 0 | 10.4113 | -74.4057 | 2021-11-11 04:21:45 | Magdalena, Colombia | |||
86960 | 86960 | 2021-11-09 | Colombia | Magdalena | 97624 | 3387 | 0 | 10.4113 | -74.4057 | 2021-11-10 04:21:38 | Magdalena, Colombia | |||
3639388 | 3639388 | 2021-11-08 | Colombia | Magdalena | 97536 | 3385 | 0 | 10.4113 | -74.4057 | 2021-11-09 04:21:36 | Magdalena, Colombia | |||
2000496 | 2000496 | 2021-11-07 | Colombia | Magdalena | 97408 | 3380 | 0 | 10.4113 | -74.4057 | 2021-11-08 04:21:43 | Magdalena, Colombia | |||
495487 | 495487 | 2021-11-06 | Colombia | Magdalena | 97294 | 3377 | 0 | 10.4113 | -74.4057 | 2021-11-07 04:21:53 | Magdalena, Colombia | |||
3121342 | 3121342 | 2021-11-05 | Colombia | Magdalena | 97144 | 3376 | 0 | 10.4113 | -74.4057 | 2021-11-06 04:21:51 | Magdalena, Colombia | |||
698240 | 698240 | 2021-11-04 | Colombia | Magdalena | 97026 | 3376 | 0 | 10.4113 | -74.4057 | 2021-11-05 04:21:54 | Magdalena, Colombia | |||
276018 | 276018 | 2021-11-03 | Colombia | Magdalena | 96894 | 3376 | 0 | 10.4113 | -74.4057 | 2021-11-04 04:22:20 | Magdalena, Colombia | |||
43543 | 43543 | 2021-11-02 | Colombia | Magdalena | 96758 | 3375 | 0 | 10.4113 | -74.4057 | 2021-11-03 06:22:09 | Magdalena, Colombia | |||
3511239 | 3511239 | 2021-11-01 | Colombia | Magdalena | 96617 | 3373 | 0 | 10.4113 | -74.4057 | 2021-11-02 04:22:03 | Magdalena, Colombia | |||
287831 | 287831 | 2021-10-31 | Colombia | Magdalena | 96498 | 3372 | 0 | 10.4113 | -74.4057 | 2021-11-01 04:22:01 | Magdalena, Colombia | |||
2720837 | 2720837 | 2021-10-30 | Colombia | Magdalena | 96421 | 3372 | 0 | 10.4113 | -74.4057 | 2021-10-31 04:22:08 | Magdalena, Colombia | |||
566939 | 566939 | 2021-10-29 | Colombia | Magdalena | 96354 | 3366 | 0 | 10.4113 | -74.4057 | 2021-10-30 04:22:03 | Magdalena, Colombia | |||
4181 | 4181 | 2021-10-28 | Colombia | Magdalena | 96274 | 3364 | 0 | 10.4113 | -74.4057 | 2021-10-29 04:22:03 | Magdalena, Colombia | |||
534571 | 534571 | 2021-10-27 | Colombia | Magdalena | 96156 | 3361 | 0 | 10.4113 | -74.4057 | 2021-10-28 04:22:08 | Magdalena, Colombia | |||
3492008 | 3492008 | 2021-10-26 | Colombia | Magdalena | 96047 | 3356 | 0 | 10.4113 | -74.4057 | 2021-10-27 04:22:32 | Magdalena, Colombia | |||
3793730 | 3793730 | 2021-10-25 | Colombia | Magdalena | 95969 | 3353 | 0 | 10.4113 | -74.4057 | 2021-10-26 04:22:09 | Magdalena, Colombia | |||
682176 | 682176 | 2021-10-24 | Colombia | Magdalena | 95846 | 3351 | 0 | 10.4113 | -74.4057 | 2021-10-25 04:22:31 | Magdalena, Colombia | |||
770184 | 770184 | 2021-10-23 | Colombia | Magdalena | 95797 | 3347 | 0 | 10.4113 | -74.4057 | 2021-10-24 04:21:22 | Magdalena, Colombia | |||
653831 | 653831 | 2021-10-22 | Colombia | Magdalena | 95729 | 3345 | 0 | 10.4113 | -74.4057 | 2021-10-23 04:21:32 | Magdalena, Colombia | |||
2123578 | 2123578 | 2021-10-21 | Colombia | Magdalena | 95672 | 3344 | 0 | 10.4113 | -74.4057 | 2021-10-22 04:21:14 | Magdalena, Colombia | |||
443190 | 443190 | 2021-10-20 | Colombia | Magdalena | 95600 | 3344 | 0 | 10.4113 | -74.4057 | 2021-10-21 04:21:18 | Magdalena, Colombia | |||
597509 | 597509 | 2021-10-19 | Colombia | Magdalena | 95548 | 3343 | 0 | 10.4113 | -74.4057 | 2021-10-20 04:21:00 | Magdalena, Colombia | |||
2043686 | 2043686 | 2021-10-18 | Colombia | Magdalena | 95484 | 3343 | 0 | 10.4113 | -74.4057 | 2021-10-19 04:20:54 | Magdalena, Colombia | |||
1909047 | 1909047 | 2021-10-17 | Colombia | Magdalena | 95426 | 3342 | 0 | 10.4113 | -74.4057 | 2021-10-18 04:21:10 | Magdalena, Colombia | |||
934636 | 934636 | 2021-10-16 | Colombia | Magdalena | 95378 | 3342 | 0 | 10.4113 | -74.4057 | 2021-10-17 04:21:29 | Magdalena, Colombia | |||
2943191 | 2943191 | 2021-10-15 | Colombia | Magdalena | 95275 | 3339 | 0 | 10.4113 | -74.4057 | 2021-10-16 04:21:15 | Magdalena, Colombia | |||
491471 | 491471 | 2021-10-14 | Colombia | Magdalena | 95166 | 3339 | 0 | 10.4113 | -74.4057 | 2021-10-15 04:21:26 | Magdalena, Colombia | |||
633759 | 633759 | 2021-10-13 | Colombia | Magdalena | 95069 | 3339 | 0 | 10.4113 | -74.4057 | 2021-10-14 04:21:29 | Magdalena, Colombia | |||
1491437 | 1491437 | 2021-10-12 | Colombia | Magdalena | 95034 | 3338 | 0 | 10.4113 | -74.4057 | 2021-10-13 04:20:51 | Magdalena, Colombia | |||
3007170 | 3007170 | 2021-10-11 | Colombia | Magdalena | 94983 | 3338 | 0 | 10.4113 | -74.4057 | 2021-10-12 04:21:09 | Magdalena, Colombia | |||
423186 | 423186 | 2021-10-10 | Colombia | Magdalena | 94911 | 3337 | 0 | 10.4113 | -74.4057 | 2021-10-11 04:21:31 | Magdalena, Colombia | |||
2876043 | 2876043 | 2021-10-09 | Colombia | Magdalena | 94852 | 3337 | 0 | 10.4113 | -74.4057 | 2021-10-10 04:21:38 | Magdalena, Colombia | |||
2959209 | 2959209 | 2021-10-08 | Colombia | Magdalena | 94773 | 3335 | 0 | 10.4113 | -74.4057 | 2021-10-09 04:21:34 | Magdalena, Colombia | |||
467247 | 467247 | 2021-10-07 | Colombia | Magdalena | 94678 | 3335 | 0 | 10.4113 | -74.4057 | 2021-10-08 04:21:25 | Magdalena, Colombia | |||
2458627 | 2458627 | 2021-10-06 | Colombia | Magdalena | 94534 | 3331 | 0 | 10.4113 | -74.4057 | 2021-10-07 04:21:36 | Magdalena, Colombia | |||
3832321 | 3832321 | 2021-10-05 | Colombia | Magdalena | 94454 | 3329 | 0 | 10.4113 | -74.4057 | 2021-10-06 04:21:33 | Magdalena, Colombia | |||
986814 | 986814 | 2021-10-04 | Colombia | Magdalena | 94366 | 3328 | 0 | 10.4113 | -74.4057 | 2021-10-05 04:21:27 | Magdalena, Colombia | |||
1274124 | 1274124 | 2021-10-03 | Colombia | Magdalena | 94344 | 3327 | 0 | 10.4113 | -74.4057 | 2021-10-04 04:21:31 | Magdalena, Colombia | |||
3927877 | 3927877 | 2021-10-02 | Colombia | Magdalena | 94271 | 3327 | 0 | 10.4113 | -74.4057 | 2021-10-03 04:21:24 | Magdalena, Colombia | |||
2131857 | 2131857 | 2021-10-01 | Colombia | Magdalena | 94193 | 3322 | 0 | 10.4113 | -74.4057 | 2021-10-02 04:21:25 | Magdalena, Colombia | |||
2772814 | 2772814 | 2021-09-30 | Colombia | Magdalena | 94051 | 3321 | 0 | 10.4113 | -74.4057 | 2021-10-01 04:21:35 | Magdalena, Colombia | |||
706270 | 706270 | 2021-09-29 | Colombia | Magdalena | 94000 | 3320 | 0 | 10.4113 | -74.4057 | 2021-09-30 04:21:20 | Magdalena, Colombia | |||
1334112 | 1334112 | 2021-09-28 | Colombia | Magdalena | 93931 | 3316 | 0 | 10.4113 | -74.4057 | 2021-09-29 04:21:45 | Magdalena, Colombia | |||
1235481 | 1235481 | 2021-09-27 | Colombia | Magdalena | 93761 | 3314 | 0 | 10.4113 | -74.4057 | 2021-09-28 04:21:28 | Magdalena, Colombia | |||
2075782 | 2075782 | 2021-09-26 | Colombia | Magdalena | 93761 | 3313 | 0 | 10.4113 | -74.4057 | 2021-09-27 04:21:16 | Magdalena, Colombia | |||
1724334 | 1724334 | 2021-09-25 | Colombia | Magdalena | 93719 | 3312 | 0 | 10.4113 | -74.4057 | 2021-09-26 04:21:29 | Magdalena, Colombia | |||
1921054 | 1921054 | 2021-09-24 | Colombia | Magdalena | 93642 | 3309 | 0 | 10.4113 | -74.4057 | 2021-09-25 04:21:31 | Magdalena, Colombia | |||
601525 | 601525 | 2021-09-23 | Colombia | Magdalena | 93576 | 3309 | 0 | 10.4113 | -74.4057 | 2021-09-24 04:21:44 | Magdalena, Colombia | |||
3011186 | 3011186 | 2021-09-22 | Colombia | Magdalena | 93485 | 3309 | 0 | 10.4113 | -74.4057 | 2021-09-23 04:21:43 | Magdalena, Colombia | |||
3757324 | 3757324 | 2021-09-21 | Colombia | Magdalena | 93377 | 3308 | 0 | 10.4113 | -74.4057 | 2021-09-22 04:21:45 | Magdalena, Colombia | |||
809427 | 809427 | 2021-09-20 | Colombia | Magdalena | 93310 | 3305 | 0 | 10.4113 | -74.4057 | 2021-09-21 04:21:26 | Magdalena, Colombia | |||
1814626 | 1814626 | 2021-09-19 | Colombia | Magdalena | 93285 | 3305 | 0 | 10.4113 | -74.4057 | 2021-09-20 04:21:22 | Magdalena, Colombia | |||
16206 | 16206 | 2021-09-18 | Colombia | Magdalena | 93166 | 3303 | 0 | 10.4113 | -74.4057 | 2021-09-19 04:21:34 | Magdalena, Colombia | |||
2617891 | 2617891 | 2021-09-17 | Colombia | Magdalena | 93105 | 3302 | 0 | 10.4113 | -74.4057 | 2021-09-18 04:21:24 | Magdalena, Colombia | |||
2808599 | 2808599 | 2021-09-16 | Colombia | Magdalena | 93050 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-17 04:21:46 | Magdalena, Colombia | |||
1374344 | 1374344 | 2021-09-15 | Colombia | Magdalena | 92963 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-16 04:22:19 | Magdalena, Colombia | |||
2462643 | 2462643 | 2021-09-14 | Colombia | Magdalena | 92963 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-15 03:22:37 | Magdalena, Colombia | |||
1385482 | 1385482 | 2021-09-13 | Colombia | Magdalena | 92892 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-14 04:21:41 | Magdalena, Colombia | |||
1884851 | 1884851 | 2021-09-12 | Colombia | Magdalena | 92868 | 3297 | 0 | 10.4113 | -74.4057 | 2021-09-13 04:21:15 | Magdalena, Colombia | |||
3805754 | 3805754 | 2021-09-11 | Colombia | Magdalena | 92799 | 3296 | 0 | 10.4113 | -74.4057 | 2021-09-12 04:21:13 | Magdalena, Colombia | |||
3448694 | 3448694 | 2021-09-10 | Colombia | Magdalena | 92766 | 3295 | 0 | 10.4113 | -74.4057 | 2021-09-11 04:21:30 | Magdalena, Colombia | |||
1262640 | 1262640 | 2021-09-09 | Colombia | Magdalena | 92697 | 3293 | 0 | 10.4113 | -74.4057 | 2021-09-10 04:21:20 | Magdalena, Colombia | |||
2279010 | 2279010 | 2021-09-08 | Colombia | Magdalena | 92633 | 3291 | 0 | 10.4113 | -74.4057 | 2021-09-09 04:21:27 | Magdalena, Colombia | |||
641789 | 641789 | 2021-09-07 | Colombia | Magdalena | 92541 | 3290 | 0 | 10.4113 | -74.4057 | 2021-09-08 04:21:31 | Magdalena, Colombia | |||
3193852 | 3193852 | 2021-09-06 | Colombia | Magdalena | 92496 | 3289 | 0 | 10.4113 | -74.4057 | 2021-09-07 04:21:35 | Magdalena, Colombia | |||
3280720 | 3280720 | 2021-09-05 | Colombia | Magdalena | 92449 | 3288 | 0 | 10.4113 | -74.4057 | 2021-09-06 04:21:22 | Magdalena, Colombia | |||
249134 | 249134 | 2021-09-04 | Colombia | Magdalena | 92351 | 3286 | 0 | 10.4113 | -74.4057 | 2021-09-05 04:21:33 | Magdalena, Colombia | |||
3974415 | 3974415 | 2021-09-03 | Colombia | Magdalena | 92265 | 3286 | 0 | 10.4113 | -74.4057 | 2021-09-04 04:21:28 | Magdalena, Colombia | |||
177877 | 177877 | 2021-09-02 | Colombia | Magdalena | 92203 | 3286 | 0 | 10.4113 | -74.4057 | 2021-09-03 04:21:20 | Magdalena, Colombia | |||
66912 | 66912 | 2021-09-01 | Colombia | Magdalena | 92123 | 3281 | 0 | 10.4113 | -74.4057 | 2021-09-02 04:21:15 | Magdalena, Colombia | |||
2067754 | 2067754 | 2021-08-31 | Colombia | Magdalena | 92047 | 3280 | 0 | 10.4113 | -74.4057 | 2021-09-01 04:21:38 | Magdalena, Colombia | |||
1775208 | 1775208 | 2021-08-30 | Colombia | Magdalena | 91982 | 3280 | 0 | 10.4113 | -74.4057 | 2021-08-31 04:21:46 | Magdalena, Colombia | |||
3891782 | 3891782 | 2021-08-29 | Colombia | Magdalena | 91900 | 3279 | 0 | 10.4113 | -74.4057 | 2021-08-30 04:21:23 | Magdalena, Colombia | |||
2792885 | 2792885 | 2021-08-28 | Colombia | Magdalena | 91826 | 3278 | 0 | 10.4113 | -74.4057 | 2021-08-29 04:21:14 | Magdalena, Colombia | |||
2923044 | 2923044 | 2021-08-27 | Colombia | Magdalena | 91737 | 3277 | 0 | 10.4113 | -74.4057 | 2021-08-28 04:21:28 | Magdalena, Colombia | |||
1596058 | 1596058 | 2021-08-26 | Colombia | Magdalena | 91686 | 3275 | 0 | 10.4113 | -74.4057 | 2021-08-27 04:21:37 | Magdalena, Colombia | |||
32267 | 32267 | 2021-08-25 | Colombia | Magdalena | 91581 | 3273 | 0 | 10.4113 | -74.4057 | 2021-08-26 04:21:28 | Magdalena, Colombia | |||
3105306 | 3105306 | 2021-08-24 | Colombia | Magdalena | 91581 | 3269 | 0 | 10.4113 | -74.4057 | 2021-08-25 04:21:41 | Magdalena, Colombia | |||
3165477 | 3165477 | 2021-08-23 | Colombia | Magdalena | 91424 | 3268 | 0 | 10.4113 | -74.4057 | 2021-08-24 04:21:19 | Magdalena, Colombia | |||
2175404 | 2175404 | 2021-08-22 | Colombia | Magdalena | 91251 | 3264 | 0 | 10.4113 | -74.4057 | 2021-08-23 04:21:27 | Magdalena, Colombia | |||
3555500 | 3555500 | 2021-08-21 | Colombia | Magdalena | 91120 | 3258 | 0 | 10.4113 | -74.4057 | 2021-08-22 04:21:29 | Magdalena, Colombia | |||
1853842 | 1853842 | 2021-08-20 | Colombia | Magdalena | 91057 | 3258 | 0 | 10.4113 | -74.4057 | 2021-08-21 04:21:38 | Magdalena, Colombia | |||
511549 | 511549 | 2021-08-19 | Colombia | Magdalena | 90924 | 3256 | 0 | 10.4113 | -74.4057 | 2021-08-20 04:21:33 | Magdalena, Colombia | |||
2518028 | 2518028 | 2021-08-18 | Colombia | Magdalena | 90765 | 3252 | 0 | 10.4113 | -74.4057 | 2021-08-19 04:21:15 | Magdalena, Colombia | |||
245120 | 245120 | 2021-08-17 | Colombia | Magdalena | 90613 | 3249 | 0 | 10.4113 | -74.4057 | 2021-08-18 04:21:35 | Magdalena, Colombia | |||
1604083 | 1604083 | 2021-08-16 | Colombia | Magdalena | 90572 | 3246 | 0 | 10.4113 | -74.4057 | 2021-08-17 04:21:49 | Magdalena, Colombia | |||
103177 | 103177 | 2021-08-15 | Colombia | Magdalena | 90477 | 3244 | 0 | 10.4113 | -74.4057 | 2021-08-16 04:21:31 | Magdalena, Colombia | |||
507535 | 507535 | 2021-08-14 | Colombia | Magdalena | 90477 | 3241 | 0 | 10.4113 | -74.4057 | 2021-08-15 04:21:41 | Magdalena, Colombia | |||
1483407 | 1483407 | 2021-08-13 | Colombia | Magdalena | 90332 | 3235 | 0 | 10.4113 | -74.4057 | 2021-08-14 04:21:25 | 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]);