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 = "Santander" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462651 | 2462651 | 2021-09-14 | Colombia | Santander | 224780 | 7260 | 0 | 6.6437 | -73.6536 | 2021-09-15 03:22:37 | Santander, Colombia | |||
1385490 | 1385490 | 2021-09-13 | Colombia | Santander | 224706 | 7258 | 0 | 6.6437 | -73.6536 | 2021-09-14 04:21:41 | Santander, Colombia | |||
1884859 | 1884859 | 2021-09-12 | Colombia | Santander | 224635 | 7255 | 0 | 6.6437 | -73.6536 | 2021-09-13 04:21:15 | Santander, Colombia | |||
3805762 | 3805762 | 2021-09-11 | Colombia | Santander | 224584 | 7254 | 0 | 6.6437 | -73.6536 | 2021-09-12 04:21:13 | Santander, Colombia | |||
3448702 | 3448702 | 2021-09-10 | Colombia | Santander | 224549 | 7253 | 0 | 6.6437 | -73.6536 | 2021-09-11 04:21:30 | Santander, Colombia | |||
1262648 | 1262648 | 2021-09-09 | Colombia | Santander | 224518 | 7250 | 0 | 6.6437 | -73.6536 | 2021-09-10 04:21:20 | Santander, Colombia | |||
2279018 | 2279018 | 2021-09-08 | Colombia | Santander | 224483 | 7249 | 0 | 6.6437 | -73.6536 | 2021-09-09 04:21:27 | Santander, Colombia | |||
641797 | 641797 | 2021-09-07 | Colombia | Santander | 224425 | 7247 | 0 | 6.6437 | -73.6536 | 2021-09-08 04:21:31 | Santander, Colombia | |||
3193860 | 3193860 | 2021-09-06 | Colombia | Santander | 224382 | 7244 | 0 | 6.6437 | -73.6536 | 2021-09-07 04:21:35 | Santander, Colombia | |||
3280728 | 3280728 | 2021-09-05 | Colombia | Santander | 224332 | 7240 | 0 | 6.6437 | -73.6536 | 2021-09-06 04:21:22 | Santander, Colombia | |||
249142 | 249142 | 2021-09-04 | Colombia | Santander | 224280 | 7239 | 0 | 6.6437 | -73.6536 | 2021-09-05 04:21:33 | Santander, Colombia | |||
3974423 | 3974423 | 2021-09-03 | Colombia | Santander | 224220 | 7234 | 0 | 6.6437 | -73.6536 | 2021-09-04 04:21:28 | Santander, Colombia | |||
177885 | 177885 | 2021-09-02 | Colombia | Santander | 224141 | 7224 | 0 | 6.6437 | -73.6536 | 2021-09-03 04:21:20 | Santander, Colombia | |||
66920 | 66920 | 2021-09-01 | Colombia | Santander | 224044 | 7220 | 0 | 6.6437 | -73.6536 | 2021-09-02 04:21:15 | Santander, Colombia | |||
2067762 | 2067762 | 2021-08-31 | Colombia | Santander | 223886 | 7218 | 0 | 6.6437 | -73.6536 | 2021-09-01 04:21:38 | Santander, Colombia | |||
1775216 | 1775216 | 2021-08-30 | Colombia | Santander | 223732 | 7216 | 0 | 6.6437 | -73.6536 | 2021-08-31 04:21:46 | Santander, Colombia | |||
3891790 | 3891790 | 2021-08-29 | Colombia | Santander | 223586 | 7214 | 0 | 6.6437 | -73.6536 | 2021-08-30 04:21:23 | Santander, Colombia | |||
2792893 | 2792893 | 2021-08-28 | Colombia | Santander | 223497 | 7212 | 0 | 6.6437 | -73.6536 | 2021-08-29 04:21:14 | Santander, Colombia | |||
2923052 | 2923052 | 2021-08-27 | Colombia | Santander | 223397 | 7206 | 0 | 6.6437 | -73.6536 | 2021-08-28 04:21:28 | Santander, Colombia | |||
1596066 | 1596066 | 2021-08-26 | Colombia | Santander | 223248 | 7202 | 0 | 6.6437 | -73.6536 | 2021-08-27 04:21:37 | Santander, Colombia | |||
32275 | 32275 | 2021-08-25 | Colombia | Santander | 223097 | 7198 | 0 | 6.6437 | -73.6536 | 2021-08-26 04:21:28 | Santander, Colombia | |||
3105314 | 3105314 | 2021-08-24 | Colombia | Santander | 223097 | 7198 | 0 | 6.6437 | -73.6536 | 2021-08-25 04:21:41 | Santander, Colombia | |||
3165485 | 3165485 | 2021-08-23 | Colombia | Santander | 223033 | 7195 | 0 | 6.6437 | -73.6536 | 2021-08-24 04:21:19 | Santander, Colombia | |||
2175412 | 2175412 | 2021-08-22 | Colombia | Santander | 222970 | 7194 | 0 | 6.6437 | -73.6536 | 2021-08-23 04:21:27 | Santander, Colombia | |||
3555508 | 3555508 | 2021-08-21 | Colombia | Santander | 222882 | 7185 | 0 | 6.6437 | -73.6536 | 2021-08-22 04:21:29 | Santander, Colombia | |||
1853850 | 1853850 | 2021-08-20 | Colombia | Santander | 222811 | 7185 | 0 | 6.6437 | -73.6536 | 2021-08-21 04:21:38 | Santander, Colombia | |||
511557 | 511557 | 2021-08-19 | Colombia | Santander | 222742 | 7180 | 0 | 6.6437 | -73.6536 | 2021-08-20 04:21:33 | Santander, Colombia | |||
2518036 | 2518036 | 2021-08-18 | Colombia | Santander | 222665 | 7172 | 0 | 6.6437 | -73.6536 | 2021-08-19 04:21:15 | Santander, Colombia | |||
245128 | 245128 | 2021-08-17 | Colombia | Santander | 222561 | 7165 | 0 | 6.6437 | -73.6536 | 2021-08-18 04:21:35 | Santander, Colombia | |||
1604091 | 1604091 | 2021-08-16 | Colombia | Santander | 222488 | 7158 | 0 | 6.6437 | -73.6536 | 2021-08-17 04:21:49 | Santander, Colombia | |||
103185 | 103185 | 2021-08-15 | Colombia | Santander | 222229 | 7154 | 0 | 6.6437 | -73.6536 | 2021-08-16 04:21:31 | Santander, Colombia | |||
507543 | 507543 | 2021-08-14 | Colombia | Santander | 222229 | 7150 | 0 | 6.6437 | -73.6536 | 2021-08-15 04:21:41 | Santander, Colombia | |||
1483415 | 1483415 | 2021-08-13 | Colombia | Santander | 222083 | 7143 | 0 | 6.6437 | -73.6536 | 2021-08-14 04:21:25 | Santander, Colombia | |||
2899545 | 2899545 | 2021-08-12 | Colombia | Santander | 221998 | 7135 | 0 | 6.6437 | -73.6536 | 2021-08-13 04:21:24 | Santander, Colombia | |||
1342149 | 1342149 | 2021-08-11 | Colombia | Santander | 221838 | 7129 | 0 | 6.6437 | -73.6536 | 2021-08-12 04:21:25 | Santander, Colombia | |||
2351296 | 2351296 | 2021-08-10 | Colombia | Santander | 221685 | 7117 | 0 | 6.6437 | -73.6536 | 2021-08-11 04:21:58 | Santander, Colombia | |||
649825 | 649825 | 2021-08-09 | Colombia | Santander | 221419 | 7109 | 0 | 6.6437 | -73.6536 | 2021-08-10 04:21:27 | Santander, Colombia | |||
589487 | 589487 | 2021-08-08 | Colombia | Santander | 221168 | 7103 | 0 | 6.6437 | -73.6536 | 2021-08-09 04:21:24 | Santander, Colombia | |||
2203499 | 2203499 | 2021-08-07 | Colombia | Santander | 220894 | 7095 | 0 | 6.6437 | -73.6536 | 2021-08-08 04:21:33 | Santander, Colombia | |||
1117449 | 1117449 | 2021-08-06 | Colombia | Santander | 220652 | 7083 | 0 | 6.6437 | -73.6536 | 2021-08-07 04:21:30 | Santander, Colombia | |||
1956386 | 1956386 | 2021-08-05 | Colombia | Santander | 220381 | 7070 | 0 | 6.6437 | -73.6536 | 2021-08-06 04:21:18 | Santander, Colombia | |||
331765 | 331765 | 2021-08-04 | Colombia | Santander | 220136 | 7061 | 209273 | 3802 | 6.6437 | -73.6536 | 2021-08-05 04:21:51 | Santander, Colombia | ||
3468036 | 3468036 | 2021-08-03 | Colombia | Santander | 219896 | 7046 | 208848 | 4002 | 6.6437 | -73.6536 | 2021-08-04 04:21:25 | Santander, Colombia | ||
3683310 | 3683310 | 2021-08-02 | Colombia | Santander | 219629 | 7025 | 208484 | 4120 | 6.6437 | -73.6536 | 2021-08-03 04:21:39 | Santander, Colombia | ||
3015209 | 3015209 | 2021-08-01 | Colombia | Santander | 219257 | 7016 | 207943 | 4298 | 6.6437 | -73.6536 | 2021-08-02 04:21:36 | Santander, Colombia | ||
3903832 | 3903832 | 2021-07-31 | Colombia | Santander | 218800 | 7002 | 207634 | 4164 | 6.6437 | -73.6536 | 2021-08-01 04:21:50 | Santander, Colombia | ||
3296037 | 3296037 | 2021-07-30 | Colombia | Santander | 218499 | 6988 | 207246 | 4265 | 6.6437 | -73.6536 | 2021-07-31 04:21:35 | Santander, Colombia | ||
3385248 | 3385248 | 2021-07-29 | Colombia | Santander | 218182 | 6965 | 206669 | 4548 | 6.6437 | -73.6536 | 2021-07-30 04:21:34 | Santander, Colombia | ||
408153 | 408153 | 2021-07-28 | Colombia | Santander | 217608 | 6941 | 206062 | 4605 | 6.6437 | -73.6536 | 2021-07-29 04:21:33 | Santander, Colombia | ||
1306014 | 1306014 | 2021-07-27 | Colombia | Santander | 216937 | 6926 | 205204 | 4807 | 6.6437 | -73.6536 | 2021-07-28 04:21:39 | Santander, Colombia | ||
3218157 | 3218157 | 2021-07-26 | Colombia | Santander | 216263 | 6907 | 204560 | 4796 | 6.6437 | -73.6536 | 2021-07-27 04:21:18 | Santander, Colombia | ||
1378366 | 1378366 | 2021-07-25 | Colombia | Santander | 215666 | 6887 | 203770 | 5009 | 6.6437 | -73.6536 | 2021-07-26 04:21:28 | Santander, Colombia | ||
1330106 | 1330106 | 2021-07-24 | Colombia | Santander | 215127 | 6875 | 203442 | 4810 | 6.6437 | -73.6536 | 2021-07-25 04:22:12 | Santander, Colombia | ||
3137410 | 3137410 | 2021-07-23 | Colombia | Santander | 214442 | 6826 | 202907 | 4709 | 6.6437 | -73.6536 | 2021-07-24 00:21:36 | Santander, Colombia | ||
3476170 | 3476170 | 2021-07-22 | Colombia | Santander | 214442 | 6826 | 202907 | 4709 | 6.6437 | -73.6536 | 2021-07-23 04:21:29 | Santander, Colombia | ||
3331389 | 3331389 | 2021-07-21 | Colombia | Santander | 214108 | 6809 | 202349 | 4950 | 6.6437 | -73.6536 | 2021-07-22 04:21:19 | Santander, Colombia | ||
2371370 | 2371370 | 2021-07-20 | Colombia | Santander | 212380 | 6794 | 202057 | 3529 | 6.6437 | -73.6536 | 2021-07-21 04:21:40 | Santander, Colombia | ||
483449 | 483449 | 2021-07-19 | Colombia | Santander | 212380 | 6770 | 201821 | 3789 | 6.6437 | -73.6536 | 2021-07-20 04:21:48 | Santander, Colombia | ||
2673672 | 2673672 | 2021-07-18 | Colombia | Santander | 212380 | 6745 | 200934 | 4701 | 6.6437 | -73.6536 | 2021-07-19 04:21:24 | Santander, Colombia | ||
3705984 | 3705984 | 2021-07-17 | Colombia | Santander | 212380 | 6707 | 199998 | 5675 | 6.6437 | -73.6536 | 2021-07-18 04:22:07 | Santander, Colombia | ||
2947215 | 2947215 | 2021-07-16 | Colombia | Santander | 211479 | 6670 | 199126 | 5683 | 6.6437 | -73.6536 | 2021-07-17 04:22:22 | Santander, Colombia | ||
295871 | 295871 | 2021-07-15 | Colombia | Santander | 210601 | 6628 | 198092 | 5881 | 6.6437 | -73.6536 | 2021-07-16 04:21:22 | Santander, Colombia | ||
3631816 | 3631816 | 2021-07-14 | Colombia | Santander | 209693 | 6596 | 197062 | 6035 | 6.6437 | -73.6536 | 2021-07-15 04:21:48 | Santander, Colombia | ||
578691 | 578691 | 2021-07-13 | Colombia | Santander | 208904 | 6564 | 196216 | 6124 | 6.6437 | -73.6536 | 2021-07-14 04:21:35 | Santander, Colombia | ||
3740940 | 3740940 | 2021-07-12 | Colombia | Santander | 207347 | 6534 | 195264 | 5549 | 6.6437 | -73.6536 | 2021-07-13 04:21:18 | Santander, Colombia | ||
3659453 | 3659453 | 2021-07-11 | Colombia | Santander | 207379 | 6417 | 191264 | 9698 | 6.6437 | -73.6536 | 2021-07-12 04:21:34 | Santander, Colombia | ||
625737 | 625737 | 2021-07-10 | Colombia | Santander | 206349 | 6417 | 191264 | 8668 | 6.6437 | -73.6536 | 2021-07-11 04:21:43 | Santander, Colombia | ||
829456 | 829456 | 2021-07-09 | Colombia | Santander | 205097 | 6417 | 190309 | 8371 | 6.6437 | -73.6536 | 2021-07-10 04:21:25 | Santander, Colombia | ||
778220 | 778220 | 2021-07-08 | Colombia | Santander | 203867 | 6373 | 190309 | 7185 | 6.6437 | -73.6536 | 2021-07-09 04:21:21 | Santander, Colombia | ||
1440442 | 1440442 | 2021-07-07 | Colombia | Santander | 202776 | 6338 | 188420 | 8018 | 6.6437 | -73.6536 | 2021-07-08 04:21:26 | Santander, Colombia | ||
2693547 | 2693547 | 2021-07-06 | Colombia | Santander | 201493 | 6285 | 187441 | 7767 | 6.6437 | -73.6536 | 2021-07-07 04:21:20 | Santander, Colombia | ||
1932296 | 1932296 | 2021-07-05 | Colombia | Santander | 200178 | 6254 | 184997 | 8927 | 6.6437 | -73.6536 | 2021-07-06 04:21:32 | Santander, Colombia | ||
1165027 | 1165027 | 2021-07-04 | Colombia | Santander | 198957 | 6215 | 183873 | 8869 | 6.6437 | -73.6536 | 2021-07-05 04:21:28 | Santander, Colombia | ||
1495461 | 1495461 | 2021-07-03 | Colombia | Santander | 197756 | 6169 | 182528 | 9059 | 6.6437 | -73.6536 | 2021-07-04 04:21:38 | Santander, Colombia | ||
2071776 | 2071776 | 2021-07-02 | Colombia | Santander | 196379 | 6117 | 180754 | 9508 | 6.6437 | -73.6536 | 2021-07-03 04:21:37 | Santander, Colombia | ||
2764792 | 2764792 | 2021-07-01 | Colombia | Santander | 194615 | 6073 | 178495 | 10047 | 6.6437 | -73.6536 | 2021-07-02 04:21:47 | Santander, Colombia | ||
1893000 | 1893000 | 2021-06-30 | Colombia | Santander | 192656 | 6018 | 176600 | 10038 | 6.6437 | -73.6536 | 2021-07-01 04:21:19 | Santander, Colombia | ||
400123 | 400123 | 2021-06-29 | Colombia | Santander | 190614 | 5952 | 174648 | 10014 | 6.6437 | -73.6536 | 2021-06-30 04:21:41 | Santander, Colombia | ||
3125366 | 3125366 | 2021-06-28 | Colombia | Santander | 188588 | 5900 | 172929 | 9759 | 6.6437 | -73.6536 | 2021-06-29 04:21:28 | Santander, Colombia | ||
2589861 | 2589861 | 2021-06-27 | Colombia | Santander | 186345 | 5847 | 171234 | 9264 | 6.6437 | -73.6536 | 2021-06-28 04:21:29 | Santander, Colombia | ||
3958365 | 3958365 | 2021-06-26 | Colombia | Santander | 184199 | 5793 | 169248 | 9158 | 6.6437 | -73.6536 | 2021-06-27 04:21:39 | Santander, Colombia | ||
1712184 | 1712184 | 2021-06-25 | Colombia | Santander | 182151 | 5738 | 167163 | 9250 | 6.6437 | -73.6536 | 2021-06-26 04:21:43 | Santander, Colombia | ||
2295309 | 2295309 | 2021-06-24 | Colombia | Santander | 179956 | 5693 | 164717 | 9546 | 6.6437 | -73.6536 | 2021-06-25 04:21:33 | Santander, Colombia | ||
2422749 | 2422749 | 2021-06-23 | Colombia | Santander | 177724 | 5635 | 163156 | 8933 | 6.6437 | -73.6536 | 2021-06-24 04:21:55 | Santander, Colombia | ||
562826 | 562826 | 2021-06-22 | Colombia | Santander | 175717 | 5592 | 161687 | 8438 | 6.6437 | -73.6536 | 2021-06-23 04:21:46 | Santander, Colombia | ||
3358528 | 3358528 | 2021-06-21 | Colombia | Santander | 174145 | 5540 | 160180 | 8425 | 6.6437 | -73.6536 | 2021-06-22 04:21:34 | Santander, Colombia | ||
2884227 | 2884227 | 2021-06-20 | Colombia | Santander | 172678 | 5468 | 158900 | 8310 | 6.6437 | -73.6536 | 2021-06-21 04:21:41 | Santander, Colombia | ||
107310 | 107310 | 2021-06-19 | Colombia | Santander | 170548 | 5433 | 156584 | 8531 | 6.6437 | -73.6536 | 2021-06-20 04:21:48 | Santander, Colombia | ||
1125453 | 1125453 | 2021-06-18 | Colombia | Santander | 168447 | 5374 | 154382 | 8691 | 6.6437 | -73.6536 | 2021-06-19 04:22:33 | Santander, Colombia | ||
2911031 | 2911031 | 2021-06-17 | Colombia | Santander | 166211 | 5313 | 152402 | 8496 | 6.6437 | -73.6536 | 2021-06-18 04:22:16 | Santander, Colombia | ||
3030149 | 3030149 | 2021-06-16 | Colombia | Santander | 162297 | 5217 | 148732 | 8348 | 6.6437 | -73.6536 | 2021-06-17 04:22:36 | Santander, Colombia | ||
2339255 | 2339255 | 2021-06-15 | Colombia | Santander | 157266 | 5174 | 147376 | 4716 | 6.6437 | -73.6536 | 2021-06-16 04:22:32 | Santander, Colombia | ||
1563951 | 1563951 | 2021-06-14 | Colombia | Santander | 157266 | 5174 | 147376 | 4716 | 6.6437 | -73.6536 | 2021-06-15 04:22:22 | Santander, Colombia | ||
3381234 | 3381234 | 2021-06-13 | Colombia | Santander | 157266 | 5132 | 145230 | 6904 | 6.6437 | -73.6536 | 2021-06-14 04:22:46 | Santander, Colombia | ||
1736368 | 1736368 | 2021-06-12 | Colombia | Santander | 157266 | 5088 | 143699 | 8479 | 6.6437 | -73.6536 | 2021-06-13 04:22:44 | Santander, Colombia | ||
3970409 | 3970409 | 2021-06-11 | Colombia | Santander | 155599 | 5046 | 142321 | 8232 | 6.6437 | -73.6536 | 2021-06-12 04:22:22 | Santander, Colombia | ||
2716831 | 2716831 | 2021-06-10 | Colombia | Santander | 153932 | 5001 | 140290 | 8641 | 6.6437 | -73.6536 | 2021-06-11 04:23:20 | Santander, Colombia | ||
522716 | 522716 | 2021-06-09 | Colombia | Santander | 151905 | 4953 | 137322 | 9630 | 6.6437 | -73.6536 | 2021-06-10 04:23:17 | Santander, Colombia | ||
3472156 | 3472156 | 2021-06-08 | Colombia | Santander | 146276 | 4865 | 131651 | 9760 | 6.6437 | -73.6536 | 2021-06-09 04:23:31 | Santander, Colombia | ||
3145440 | 3145440 | 2021-06-07 | Colombia | Santander | 146276 | 4865 | 131651 | 9760 | 6.6437 | -73.6536 | 2021-06-08 04:22:35 | Santander, 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]);