daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Santander" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-07 | Colombia | Santander | 21755 | 923 | 14377 | 6455 | 6.6437 | -73.6536 | 2020-09-08 04:28:25 | Santander, Colombia | ||
2022-11-03 | Colombia | Santander | 293422 | 8303 | 0 | 6.6437 | -73.6536 | 2022-11-04 04:22:11 | Santander, Colombia | |||
2021-01-21 | Colombia | Santander | 79328 | 2741 | 72399 | 4188 | 6.6437 | -73.6536 | 2021-01-22 05:22:10 | Santander, Colombia | ||
2020-07-26 | Colombia | Santander | 2564 | 64 | 901 | 1599 | 6.6437 | -73.6536 | 2020-07-27 04:35:02 | Santander, Colombia | ||
2021-10-20 | Colombia | Santander | 225850 | 7303 | 0 | 6.6437 | -73.6536 | 2021-10-21 04:21:18 | Santander, Colombia | |||
2021-11-17 | Colombia | Santander | 228141 | 7343 | 0 | 6.6437 | -73.6536 | 2021-11-18 04:21:33 | Santander, Colombia | |||
2022-12-21 | Colombia | Santander | 293974 | 8316 | 0 | 6.6437 | -73.6536 | 2022-12-22 04:20:56 | Santander, Colombia | |||
2020-08-07 | Colombia | Santander | 5942 | 200 | 1916 | 3826 | 6.6437 | -73.6536 | 2020-08-08 04:34:53 | Santander, Colombia | ||
2022-02-02 | Colombia | Santander | 273049 | 7811 | 0 | 6.6437 | -73.6536 | 2022-02-03 04:21:21 | Santander, Colombia | |||
2022-05-02 | Colombia | Santander | 283686 | 8175 | 0 | 6.6437 | -73.6536 | 2022-05-03 04:21:00 | Santander, Colombia | |||
2021-10-07 | Colombia | Santander | 225475 | 7292 | 0 | 6.6437 | -73.6536 | 2021-10-08 04:21:25 | Santander, Colombia | |||
2021-02-19 | Colombia | Santander | 89269 | 3228 | 83573 | 2468 | 6.6437 | -73.6536 | 2021-02-20 05:22:51 | Santander, Colombia | ||
2022-06-26 | Colombia | Santander | 286053 | 8188 | 0 | 6.6437 | -73.6536 | 2022-06-27 04:21:00 | Santander, Colombia | |||
2022-11-08 | Colombia | Santander | 293422 | 8304 | 0 | 6.6437 | -73.6536 | 2022-11-09 04:21:22 | Santander, Colombia | |||
2021-07-19 | Colombia | Santander | 212380 | 6770 | 201821 | 3789 | 6.6437 | -73.6536 | 2021-07-20 04:21:48 | Santander, Colombia | ||
2022-11-25 | Colombia | Santander | 293509 | 8306 | 0 | 6.6437 | -73.6536 | 2022-11-26 04:21:11 | Santander, Colombia | |||
2021-10-14 | Colombia | Santander | 225671 | 7296 | 0 | 6.6437 | -73.6536 | 2021-10-15 04:21:26 | Santander, Colombia | |||
2021-11-06 | Colombia | Santander | 226858 | 7321 | 0 | 6.6437 | -73.6536 | 2021-11-07 04:21:53 | Santander, Colombia | |||
2022-04-02 | Colombia | Santander | 283226 | 8161 | 0 | 6.6437 | -73.6536 | 2022-04-03 04:20:48 | Santander, Colombia | |||
2022-12-17 | Colombia | Santander | 293974 | 8316 | 0 | 6.6437 | -73.6536 | 2022-12-18 04:21:03 | Santander, Colombia | |||
2021-08-14 | Colombia | Santander | 222229 | 7150 | 0 | 6.6437 | -73.6536 | 2021-08-15 04:21:41 | Santander, Colombia | |||
2021-08-19 | Colombia | Santander | 222742 | 7180 | 0 | 6.6437 | -73.6536 | 2021-08-20 04:21:33 | Santander, Colombia | |||
2022-10-15 | Colombia | Santander | 293371 | 8303 | 0 | 6.6437 | -73.6536 | 2022-10-16 04:22:39 | Santander, Colombia | |||
2021-06-09 | Colombia | Santander | 151905 | 4953 | 137322 | 9630 | 6.6437 | -73.6536 | 2021-06-10 04:23:17 | Santander, Colombia | ||
2020-07-04 | Colombia | Santander | 846 | 15 | 216 | 615 | 6.6437 | -73.6536 | 2020-07-05 04:33:46 | Santander, Colombia | ||
2021-02-22 | Colombia | Santander | 89889 | 3254 | 84180 | 2455 | 6.6437 | -73.6536 | 2021-02-23 05:23:41 | Santander, Colombia | ||
2021-10-27 | Colombia | Santander | 226166 | 7310 | 0 | 6.6437 | -73.6536 | 2021-10-28 04:22:08 | Santander, Colombia | |||
2022-10-26 | Colombia | Santander | 293383 | 8303 | 0 | 6.6437 | -73.6536 | 2022-10-27 04:22:01 | Santander, Colombia | |||
2022-12-15 | Colombia | Santander | 293974 | 8316 | 0 | 6.6437 | -73.6536 | 2022-12-16 04:21:01 | Santander, Colombia | |||
2020-09-12 | Colombia | Santander | 24215 | 1047 | 18470 | 4698 | 6.6437 | -73.6536 | 2020-09-13 04:30:52 | Santander, Colombia | ||
2021-12-08 | Colombia | Santander | 232344 | 7418 | 0 | 6.6437 | -73.6536 | 2021-12-09 04:22:49 | Santander, Colombia | |||
2022-01-16 | Colombia | Santander | 248089 | 7586 | 0 | 6.6437 | -73.6536 | 2022-01-17 04:21:08 | Santander, Colombia | |||
2022-06-16 | Colombia | Santander | 285498 | 8185 | 0 | 6.6437 | -73.6536 | 2022-06-17 04:20:56 | Santander, Colombia | |||
2021-06-22 | Colombia | Santander | 175717 | 5592 | 161687 | 8438 | 6.6437 | -73.6536 | 2021-06-23 04:21:46 | Santander, Colombia | ||
2021-10-29 | Colombia | Santander | 226310 | 7312 | 0 | 6.6437 | -73.6536 | 2021-10-30 04:22:03 | Santander, Colombia | |||
2020-06-06 | Colombia | Santander | 131 | 4 | 50 | 77 | 6.6437 | -73.6536 | 2020-06-07 03:53:30 | Santander, Colombia | ||
2022-02-25 | Colombia | Santander | 281356 | 8094 | 0 | 6.6437 | -73.6536 | 2022-02-26 04:21:12 | Santander, Colombia | |||
2021-07-13 | Colombia | Santander | 208904 | 6564 | 196216 | 6124 | 6.6437 | -73.6536 | 2021-07-14 04:21:35 | Santander, Colombia | ||
2020-08-13 | Colombia | Santander | 8578 | 329 | 2812 | 5437 | 6.6437 | -73.6536 | 2020-08-14 04:51:19 | Santander, Colombia | ||
2021-08-08 | Colombia | Santander | 221168 | 7103 | 0 | 6.6437 | -73.6536 | 2021-08-09 04:21:24 | Santander, Colombia | |||
2022-07-01 | Colombia | Santander | 286942 | 8194 | 0 | 6.6437 | -73.6536 | 2022-07-02 04:21:16 | Santander, Colombia | |||
2021-10-19 | Colombia | Santander | 225825 | 7302 | 0 | 6.6437 | -73.6536 | 2021-10-20 04:21:00 | Santander, Colombia | |||
2021-09-23 | Colombia | Santander | 225114 | 7271 | 0 | 6.6437 | -73.6536 | 2021-09-24 04:21:44 | Santander, Colombia | |||
2021-04-09 | Colombia | Santander | 95621 | 3519 | 90237 | 1865 | 6.6437 | -73.6536 | 2021-04-10 04:20:59 | Santander, Colombia | ||
2020-08-29 | Colombia | Santander | 17310 | 723 | 10038 | 6549 | 6.6437 | -73.6536 | 2020-08-30 04:28:22 | Santander, Colombia | ||
2021-02-08 | Colombia | Santander | 86131 | 3072 | 79837 | 3222 | 6.6437 | -73.6536 | 2021-02-09 05:23:30 | Santander, Colombia | ||
2022-11-05 | Colombia | Santander | 293422 | 8303 | 0 | 6.6437 | -73.6536 | 2022-11-06 04:21:24 | Santander, Colombia | |||
2022-05-22 | Colombia | Santander | 284056 | 8177 | 0 | 6.6437 | -73.6536 | 2022-05-26 04:20:50 | Santander, Colombia | |||
2021-07-10 | Colombia | Santander | 206349 | 6417 | 191264 | 8668 | 6.6437 | -73.6536 | 2021-07-11 04:21:43 | Santander, Colombia | ||
2022-07-12 | Colombia | Santander | 287715 | 8204 | 0 | 6.6437 | -73.6536 | 2022-07-13 04:20:58 | Santander, Colombia | |||
2021-10-13 | Colombia | Santander | 225640 | 7295 | 0 | 6.6437 | -73.6536 | 2021-10-14 04:21:29 | Santander, Colombia | |||
2021-03-31 | Colombia | Santander | 94452 | 3490 | 89317 | 1645 | 6.6437 | -73.6536 | 2021-04-01 04:27:05 | Santander, Colombia | ||
2021-09-07 | Colombia | Santander | 224425 | 7247 | 0 | 6.6437 | -73.6536 | 2021-09-08 04:21:31 | Santander, Colombia | |||
2021-05-05 | Colombia | Santander | 107688 | 3784 | 100337 | 3567 | 6.6437 | -73.6536 | 2021-05-06 04:20:38 | Santander, Colombia | ||
2021-08-09 | Colombia | Santander | 221419 | 7109 | 0 | 6.6437 | -73.6536 | 2021-08-10 04:21:27 | Santander, Colombia | |||
2021-10-22 | Colombia | Santander | 225930 | 7304 | 0 | 6.6437 | -73.6536 | 2021-10-23 04:21:32 | Santander, Colombia | |||
2022-05-13 | Colombia | Santander | 283922 | 8176 | 0 | 6.6437 | -73.6536 | 2022-05-14 04:20:48 | Santander, Colombia | |||
2020-08-11 | Colombia | Santander | 7678 | 289 | 2563 | 4826 | 6.6437 | -73.6536 | 2020-08-12 04:27:29 | Santander, Colombia | ||
2020-09-16 | Colombia | Santander | 25854 | 1105 | 19579 | 5170 | 6.6437 | -73.6536 | 2020-09-17 04:22:00 | Santander, Colombia | ||
2022-07-21 | Colombia | Santander | 287715 | 8213 | 0 | 6.6437 | -73.6536 | 2022-07-22 04:21:15 | Santander, Colombia | |||
2022-07-30 | Colombia | Santander | 290867 | 8233 | 0 | 6.6437 | -73.6536 | 2022-07-31 04:21:02 | Santander, Colombia | |||
2020-11-23 | Colombia | Santander | 50419 | 1938 | 45537 | 2944 | 6.6437 | -73.6536 | 2020-11-24 05:27:31 | Santander, Colombia | ||
2021-10-24 | Colombia | Santander | 226010 | 7305 | 0 | 6.6437 | -73.6536 | 2021-10-25 04:22:31 | Santander, Colombia | |||
2021-11-13 | Colombia | Santander | 227591 | 7335 | 0 | 6.6437 | -73.6536 | 2021-11-14 04:21:31 | Santander, Colombia | |||
2022-12-23 | Colombia | Santander | 294368 | 8326 | 0 | 6.6437 | -73.6536 | 2022-12-24 04:21:02 | Santander, Colombia | |||
2022-03-17 | Colombia | Santander | 282773 | 8146 | 0 | 6.6437 | -73.6536 | 2022-03-18 04:20:55 | Santander, Colombia | |||
2021-11-04 | Colombia | Santander | 226710 | 7320 | 0 | 6.6437 | -73.6536 | 2021-11-05 04:21:54 | Santander, Colombia | |||
2021-03-16 | Colombia | Santander | 93013 | 3431 | 87803 | 1779 | 6.6437 | -73.6536 | 2021-03-17 05:25:07 | Santander, Colombia | ||
2021-09-29 | Colombia | Santander | 225277 | 7283 | 0 | 6.6437 | -73.6536 | 2021-09-30 04:21:20 | Santander, Colombia | |||
2022-11-01 | Colombia | Santander | 293395 | 8303 | 0 | 6.6437 | -73.6536 | 2022-11-02 04:22:09 | Santander, Colombia | |||
2021-11-12 | Colombia | Santander | 227490 | 7331 | 0 | 6.6437 | -73.6536 | 2021-11-13 04:21:38 | Santander, Colombia | |||
2022-12-04 | Colombia | Santander | 293509 | 8308 | 0 | 6.6437 | -73.6536 | 2022-12-05 04:20:58 | Santander, Colombia | |||
2021-11-20 | Colombia | Santander | 228698 | 7348 | 0 | 6.6437 | -73.6536 | 2021-11-21 04:22:13 | Santander, Colombia | |||
2021-05-22 | Colombia | Santander | 123172 | 4218 | 113370 | 5584 | 6.6437 | -73.6536 | 2021-05-23 04:20:51 | Santander, Colombia | ||
2021-12-27 | Colombia | Santander | 234852 | 7515 | 0 | 6.6437 | -73.6536 | 2021-12-28 04:21:47 | Santander, Colombia | |||
2020-06-12 | Colombia | Santander | 208 | 8 | 52 | 148 | 6.6437 | -73.6536 | 2020-06-13 03:33:14 | Santander, Colombia | ||
2020-12-02 | Colombia | Santander | 54160 | 2038 | 48412 | 3710 | 6.6437 | -73.6536 | 2020-12-03 05:28:22 | Santander, Colombia | ||
2021-02-20 | Colombia | Santander | 89501 | 3231 | 83755 | 2515 | 6.6437 | -73.6536 | 2021-02-21 05:24:33 | Santander, Colombia | ||
2022-04-23 | Colombia | Santander | 283540 | 8174 | 0 | 6.6437 | -73.6536 | 2022-04-24 04:20:56 | Santander, Colombia | |||
2020-08-01 | Colombia | Santander | 3993 | 110 | 1335 | 2548 | 6.6437 | -73.6536 | 2020-08-02 04:34:47 | Santander, Colombia | ||
2020-10-28 | Colombia | Santander | 41024 | 1658 | 36071 | 3295 | 6.6437 | -73.6536 | 2020-10-29 04:24:49 | Santander, Colombia | ||
2021-11-26 | Colombia | Santander | 230072 | 7376 | 0 | 6.6437 | -73.6536 | 2021-11-27 04:22:45 | Santander, Colombia | |||
2020-10-18 | Colombia | Santander | 37439 | 1527 | 32343 | 3569 | 6.6437 | -73.6536 | 2020-10-19 04:24:16 | Santander, Colombia | ||
2020-12-29 | Colombia | Santander | 66233 | 2359 | 59695 | 4179 | 6.6437 | -73.6536 | 2020-12-30 05:22:34 | Santander, Colombia | ||
2021-10-23 | Colombia | Santander | 225975 | 7304 | 0 | 6.6437 | -73.6536 | 2021-10-24 04:21:22 | Santander, Colombia | |||
2021-01-12 | Colombia | Santander | 73824 | 2575 | 66358 | 4891 | 6.6437 | -73.6536 | 2021-01-13 05:22:15 | Santander, Colombia | ||
2021-07-08 | Colombia | Santander | 203867 | 6373 | 190309 | 7185 | 6.6437 | -73.6536 | 2021-07-09 04:21:21 | Santander, Colombia | ||
2021-12-13 | Colombia | Santander | 233159 | 7445 | 0 | 6.6437 | -73.6536 | 2021-12-14 04:22:38 | Santander, Colombia | |||
2020-10-15 | Colombia | Santander | 36441 | 1501 | 30697 | 4243 | 6.6437 | -73.6536 | 2020-10-16 04:24:01 | Santander, Colombia | ||
2021-02-04 | Colombia | Santander | 85156 | 2999 | 78467 | 3690 | 6.6437 | -73.6536 | 2021-02-05 05:22:38 | Santander, Colombia | ||
2022-10-24 | Colombia | Santander | 293383 | 8303 | 0 | 6.6437 | -73.6536 | 2022-10-25 04:21:53 | Santander, Colombia | |||
2021-12-22 | Colombia | Santander | 234317 | 7505 | 0 | 6.6437 | -73.6536 | 2021-12-23 04:21:21 | Santander, Colombia | |||
2020-06-01 | Colombia | Santander | 69 | 3 | 42 | 24 | 6.6437 | -73.6536 | 2020-06-02 02:33:08 | Santander, Colombia | ||
2021-09-20 | Colombia | Santander | 225001 | 7269 | 0 | 6.6437 | -73.6536 | 2021-09-21 04:21:26 | Santander, Colombia | |||
2020-09-05 | Colombia | Santander | 20822 | 865 | 13375 | 6582 | 6.6437 | -73.6536 | 2020-09-06 04:28:33 | Santander, Colombia | ||
2020-10-09 | Colombia | Santander | 34574 | 1412 | 28312 | 4850 | 6.6437 | -73.6536 | 2020-10-10 04:23:57 | Santander, Colombia | ||
2020-11-19 | Colombia | Santander | 49204 | 1900 | 44318 | 2986 | 6.6437 | -73.6536 | 2020-11-20 05:26:28 | Santander, Colombia | ||
2021-06-06 | Colombia | Santander | 143240 | 4822 | 130186 | 8232 | 6.6437 | -73.6536 | 2021-06-07 04:22:51 | Santander, Colombia | ||
2021-07-09 | Colombia | Santander | 205097 | 6417 | 190309 | 8371 | 6.6437 | -73.6536 | 2021-07-10 04:21:25 | Santander, Colombia | ||
2022-12-02 | Colombia | Santander | 293509 | 8308 | 0 | 6.6437 | -73.6536 | 2022-12-03 04:21:02 | Santander, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;