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 = "Cesar" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
157 | 157 | 2021-12-02 | Colombia | Cesar | 91946 | 2528 | 0 | 9.3373 | -73.6536 | 2021-12-03 04:23:05 | Cesar, Colombia | |||
4173 | 4173 | 2021-10-28 | Colombia | Cesar | 89782 | 2503 | 0 | 9.3373 | -73.6536 | 2021-10-29 04:22:03 | Cesar, Colombia | |||
8176 | 8176 | 2020-10-25 | Colombia | Cesar | 24774 | 774 | 22049 | 1951 | 9.3373 | -73.6536 | 2020-10-26 04:25:02 | Cesar, Colombia | ||
12183 | 12183 | 2021-01-26 | Colombia | Cesar | 37519 | 1070 | 34919 | 1530 | 9.3373 | -73.6536 | 2021-01-27 05:23:41 | Cesar, Colombia | ||
16198 | 16198 | 2021-09-18 | Colombia | Cesar | 88703 | 2476 | 0 | 9.3373 | -73.6536 | 2021-09-19 04:21:34 | Cesar, Colombia | |||
20213 | 20213 | 2021-05-28 | Colombia | Cesar | 66814 | 1816 | 63633 | 1365 | 9.3373 | -73.6536 | 2021-05-29 04:20:41 | Cesar, Colombia | ||
24228 | 24228 | 2022-03-20 | Colombia | Cesar | 106345 | 2667 | 0 | 9.3373 | -73.6536 | 2022-03-21 04:20:50 | Cesar, Colombia | |||
28243 | 28243 | 2021-11-11 | Colombia | Cesar | 90574 | 2507 | 0 | 9.3373 | -73.6536 | 2021-11-12 04:22:01 | Cesar, Colombia | |||
32259 | 32259 | 2021-08-25 | Colombia | Cesar | 87914 | 2453 | 0 | 9.3373 | -73.6536 | 2021-08-26 04:21:28 | Cesar, Colombia | |||
36273 | 36273 | 2021-04-12 | Colombia | Cesar | 45942 | 1289 | 43336 | 1317 | 9.3373 | -73.6536 | 2021-04-13 04:20:37 | Cesar, Colombia | ||
43535 | 43535 | 2021-11-02 | Colombia | Cesar | 89959 | 2505 | 0 | 9.3373 | -73.6536 | 2021-11-03 06:22:09 | Cesar, Colombia | |||
50634 | 50634 | 2021-05-29 | Colombia | Cesar | 67073 | 1829 | 63922 | 1322 | 9.3373 | -73.6536 | 2021-05-30 04:20:55 | Cesar, Colombia | ||
54648 | 54648 | 2021-03-07 | Colombia | Cesar | 40820 | 1192 | 38957 | 671 | 9.3373 | -73.6536 | 2021-03-08 05:24:48 | Cesar, Colombia | ||
61822 | 61822 | 2020-07-23 | Colombia | Cesar | 2309 | 44 | 1221 | 1044 | 9.3373 | -73.6536 | 2020-07-24 05:30:40 | Cesar, Colombia | ||
62889 | 62889 | 2022-11-12 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-13 04:21:14 | Cesar, Colombia | |||
66904 | 66904 | 2021-09-01 | Colombia | Cesar | 88159 | 2465 | 0 | 9.3373 | -73.6536 | 2021-09-02 04:21:15 | Cesar, Colombia | |||
70918 | 70918 | 2022-02-07 | Colombia | Cesar | 104385 | 2626 | 0 | 9.3373 | -73.6536 | 2022-02-08 04:21:15 | Cesar, Colombia | |||
74933 | 74933 | 2020-12-03 | Colombia | Cesar | 30177 | 918 | 27517 | 1742 | 9.3373 | -73.6536 | 2020-12-04 05:27:27 | Cesar, Colombia | ||
78932 | 78932 | 2020-10-14 | Colombia | Cesar | 22877 | 705 | 19720 | 2452 | 9.3373 | -73.6536 | 2020-10-15 04:24:28 | Cesar, Colombia | ||
82938 | 82938 | 2021-05-25 | Colombia | Cesar | 65522 | 1770 | 61711 | 2041 | 9.3373 | -73.6536 | 2021-05-26 04:20:35 | Cesar, Colombia | ||
86952 | 86952 | 2021-11-09 | Colombia | Cesar | 90483 | 2506 | 0 | 9.3373 | -73.6536 | 2021-11-10 04:21:38 | Cesar, Colombia | |||
90969 | 90969 | 2022-07-23 | Colombia | Cesar | 107777 | 2676 | 0 | 9.3373 | -73.6536 | 2022-07-24 04:20:47 | Cesar, Colombia | |||
98156 | 98156 | 2020-08-04 | Colombia | Cesar | 3735 | 75 | 1754 | 1906 | 9.3373 | -73.6536 | 2020-08-05 04:34:43 | Cesar, Colombia | ||
99153 | 99153 | 2022-01-14 | Colombia | Cesar | 95867 | 2573 | 0 | 9.3373 | -73.6536 | 2022-01-15 04:21:07 | Cesar, Colombia | |||
103169 | 103169 | 2021-08-15 | Colombia | Cesar | 87480 | 2439 | 0 | 9.3373 | -73.6536 | 2021-08-16 04:21:31 | Cesar, Colombia | |||
107294 | 107294 | 2021-06-19 | Colombia | Cesar | 76326 | 2062 | 71883 | 2381 | 9.3373 | -73.6536 | 2021-06-20 04:21:48 | Cesar, Colombia | ||
114579 | 114579 | 2022-09-06 | Colombia | Cesar | 108650 | 2681 | 0 | 9.3373 | -73.6536 | 2022-09-07 04:20:59 | Cesar, Colombia | |||
121749 | 121749 | 2020-07-19 | Colombia | Cesar | 1997 | 38 | 1114 | 845 | 9.3373 | -73.6536 | 2020-07-20 05:34:40 | Cesar, Colombia | ||
122548 | 122548 | 2020-11-18 | Colombia | Cesar | 28146 | 868 | 25782 | 1496 | 9.3373 | -73.6536 | 2020-11-19 05:25:23 | Cesar, Colombia | ||
126560 | 126560 | 2022-01-09 | Colombia | Cesar | 94292 | 2568 | 0 | 9.3373 | -73.6536 | 2022-01-10 04:22:07 | Cesar, Colombia | |||
130577 | 130577 | 2022-10-04 | Colombia | Cesar | 108822 | 2682 | 0 | 9.3373 | -73.6536 | 2022-10-05 04:23:06 | Cesar, Colombia | |||
137798 | 137798 | 2021-12-04 | Colombia | Cesar | 92087 | 2530 | 0 | 9.3373 | -73.6536 | 2021-12-05 04:22:25 | Cesar, Colombia | |||
141815 | 141815 | 2022-07-09 | Colombia | Cesar | 107613 | 2675 | 0 | 9.3373 | -73.6536 | 2022-07-10 04:20:54 | Cesar, Colombia | |||
145817 | 145817 | 2020-08-15 | Colombia | Cesar | 5452 | 117 | 2748 | 2587 | 9.3373 | -73.6536 | 2020-08-16 04:27:42 | Cesar, Colombia | ||
149811 | 149811 | 2021-11-29 | Colombia | Cesar | 91744 | 2526 | 0 | 9.3373 | -73.6536 | 2021-11-30 04:22:53 | Cesar, Colombia | |||
153826 | 153826 | 2021-01-08 | Colombia | Cesar | 34584 | 1012 | 31715 | 1857 | 9.3373 | -73.6536 | 2021-01-09 05:22:18 | Cesar, Colombia | ||
157840 | 157840 | 2022-03-29 | Colombia | Cesar | 106382 | 2668 | 0 | 9.3373 | -73.6536 | 2022-03-30 04:20:45 | Cesar, Colombia | |||
161855 | 161855 | 2021-11-19 | Colombia | Cesar | 91090 | 2517 | 0 | 9.3373 | -73.6536 | 2021-11-20 04:22:17 | Cesar, Colombia | |||
165872 | 165872 | 2022-06-21 | Colombia | Cesar | 107030 | 2672 | 0 | 9.3373 | -73.6536 | 2022-06-22 04:20:54 | Cesar, Colombia | |||
169887 | 169887 | 2021-04-16 | Colombia | Cesar | 47082 | 1308 | 44442 | 1332 | 9.3373 | -73.6536 | 2021-04-17 04:20:40 | Cesar, Colombia | ||
177067 | 177067 | 2020-07-27 | Colombia | Cesar | 2636 | 52 | 1398 | 1186 | 9.3373 | -73.6536 | 2020-07-28 04:58:43 | Cesar, Colombia | ||
177869 | 177869 | 2021-09-02 | Colombia | Cesar | 88201 | 2466 | 0 | 9.3373 | -73.6536 | 2021-09-03 04:21:20 | Cesar, Colombia | |||
181883 | 181883 | 2021-02-21 | Colombia | Cesar | 40059 | 1169 | 38136 | 754 | 9.3373 | -73.6536 | 2021-02-22 05:24:21 | Cesar, Colombia | ||
185898 | 185898 | 2022-02-13 | Colombia | Cesar | 105369 | 2645 | 0 | 9.3373 | -73.6536 | 2022-02-14 04:20:51 | Cesar, Colombia | |||
189912 | 189912 | 2021-01-11 | Colombia | Cesar | 35018 | 1020 | 32026 | 1972 | 9.3373 | -73.6536 | 2021-01-12 05:22:15 | Cesar, Colombia | ||
193912 | 193912 | 2020-08-31 | Colombia | Cesar | 10815 | 296 | 6242 | 4277 | 9.3373 | -73.6536 | 2020-09-01 04:28:31 | Cesar, Colombia | ||
198086 | 198086 | 2022-10-19 | Colombia | Cesar | 108905 | 2682 | 0 | 9.3373 | -73.6536 | 2022-10-20 04:22:59 | Cesar, Colombia | |||
202100 | 202100 | 2020-12-25 | Colombia | Cesar | 32946 | 975 | 30089 | 1882 | 9.3373 | -73.6536 | 2020-12-26 05:22:28 | Cesar, Colombia | ||
206099 | 206099 | 2020-08-19 | Colombia | Cesar | 6439 | 139 | 3526 | 2774 | 9.3373 | -73.6536 | 2020-08-20 04:27:43 | Cesar, Colombia | ||
210084 | 210084 | 2020-10-29 | Colombia | Cesar | 25537 | 801 | 22618 | 2118 | 9.3373 | -73.6536 | 2020-10-30 04:24:49 | Cesar, Colombia | ||
217055 | 217055 | 2020-06-08 | Colombia | Cesar | 449 | 12 | 71 | 366 | 9.3373 | -73.6536 | 2020-06-09 03:33:03 | Cesar, Colombia | ||
217807 | 217807 | 2022-12-26 | Colombia | Cesar | 109144 | 2689 | 0 | 9.3373 | -73.6536 | 2022-12-27 04:21:07 | Cesar, Colombia | |||
221823 | 221823 | 2022-05-09 | Colombia | Cesar | 106546 | 2672 | 0 | 9.3373 | -73.6536 | 2022-05-10 04:20:50 | Cesar, Colombia | |||
229054 | 229054 | 2022-05-31 | Colombia | Cesar | 106653 | 2672 | 0 | 9.3373 | -73.6536 | 2022-06-01 04:20:55 | Cesar, Colombia | |||
233070 | 233070 | 2022-02-11 | Colombia | Cesar | 105095 | 2637 | 0 | 9.3373 | -73.6536 | 2022-02-12 04:21:06 | Cesar, Colombia | |||
237084 | 237084 | 2021-01-18 | Colombia | Cesar | 36511 | 1043 | 33804 | 1664 | 9.3373 | -73.6536 | 2021-01-19 05:22:15 | Cesar, Colombia | ||
241098 | 241098 | 2021-04-02 | Colombia | Cesar | 43667 | 1250 | 41593 | 824 | 9.3373 | -73.6536 | 2021-04-03 04:20:44 | Cesar, Colombia | ||
245112 | 245112 | 2021-08-17 | Colombia | Cesar | 87570 | 2441 | 0 | 9.3373 | -73.6536 | 2021-08-18 04:21:35 | Cesar, Colombia | |||
249126 | 249126 | 2021-09-04 | Colombia | Cesar | 88267 | 2466 | 0 | 9.3373 | -73.6536 | 2021-09-05 04:21:33 | Cesar, Colombia | |||
253141 | 253141 | 2022-09-08 | Colombia | Cesar | 108666 | 2681 | 0 | 9.3373 | -73.6536 | 2022-09-09 04:21:11 | Cesar, Colombia | |||
257157 | 257157 | 2022-12-10 | Colombia | Cesar | 109027 | 2687 | 0 | 9.3373 | -73.6536 | 2022-12-11 04:20:50 | Cesar, Colombia | |||
261360 | 261360 | 2022-03-15 | Colombia | Cesar | 106306 | 2667 | 0 | 9.3373 | -73.6536 | 2022-03-16 04:20:50 | Cesar, Colombia | |||
271999 | 271999 | 2020-11-10 | Colombia | Cesar | 27452 | 850 | 25100 | 1502 | 9.3373 | -73.6536 | 2020-11-11 05:25:30 | Cesar, Colombia | ||
276010 | 276010 | 2021-11-03 | Colombia | Cesar | 89995 | 2505 | 0 | 9.3373 | -73.6536 | 2021-11-04 04:22:20 | Cesar, Colombia | |||
280026 | 280026 | 2021-02-24 | Colombia | Cesar | 40195 | 1176 | 38336 | 683 | 9.3373 | -73.6536 | 2021-02-25 05:24:57 | Cesar, Colombia | ||
287038 | 287038 | 2020-06-15 | Colombia | Cesar | 554 | 17 | 86 | 451 | 9.3373 | -73.6536 | 2020-06-16 04:33:09 | Cesar, Colombia | ||
287823 | 287823 | 2021-10-31 | Colombia | Cesar | 89870 | 2505 | 0 | 9.3373 | -73.6536 | 2021-11-01 04:22:01 | Cesar, Colombia | |||
291840 | 291840 | 2022-11-15 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-16 04:21:09 | Cesar, Colombia | |||
295855 | 295855 | 2021-07-15 | Colombia | Cesar | 83531 | 2310 | 79552 | 1669 | 9.3373 | -73.6536 | 2021-07-16 04:21:22 | Cesar, Colombia | ||
302910 | 302910 | 2020-07-01 | Colombia | Cesar | 1027 | 25 | 458 | 544 | 9.3373 | -73.6536 | 2020-07-02 04:33:46 | Cesar, Colombia | ||
303696 | 303696 | 2022-04-16 | Colombia | Cesar | 106506 | 2672 | 0 | 9.3373 | -73.6536 | 2022-04-17 04:20:59 | Cesar, Colombia | |||
307712 | 307712 | 2022-12-13 | Colombia | Cesar | 109027 | 2687 | 0 | 9.3373 | -73.6536 | 2022-12-14 04:21:04 | Cesar, Colombia | |||
311728 | 311728 | 2022-11-13 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-14 04:21:09 | Cesar, Colombia | |||
315744 | 315744 | 2022-02-12 | Colombia | Cesar | 105279 | 2641 | 0 | 9.3373 | -73.6536 | 2022-02-13 04:21:00 | Cesar, Colombia | |||
319760 | 319760 | 2022-10-30 | Colombia | Cesar | 108912 | 2684 | 0 | 9.3373 | -73.6536 | 2022-10-31 04:21:36 | Cesar, Colombia | |||
326844 | 326844 | 2020-07-20 | Colombia | Cesar | 2115 | 39 | 1137 | 939 | 9.3373 | -73.6536 | 2020-07-21 04:38:46 | Cesar, Colombia | ||
327734 | 327734 | 2022-12-27 | Colombia | Cesar | 109144 | 2689 | 0 | 9.3373 | -73.6536 | 2022-12-28 04:21:04 | Cesar, Colombia | |||
331749 | 331749 | 2021-08-04 | Colombia | Cesar | 86831 | 2410 | 83130 | 1291 | 9.3373 | -73.6536 | 2021-08-05 04:21:51 | Cesar, Colombia | ||
335764 | 335764 | 2022-03-18 | Colombia | Cesar | 106336 | 2667 | 0 | 9.3373 | -73.6536 | 2022-03-19 04:20:47 | Cesar, Colombia | |||
340118 | 340118 | 2021-02-03 | Colombia | Cesar | 38718 | 1102 | 36308 | 1308 | 9.3373 | -73.6536 | 2021-02-04 05:22:26 | Cesar, Colombia | ||
344120 | 344120 | 2020-09-14 | Colombia | Cesar | 15758 | 447 | 11924 | 3387 | 9.3373 | -73.6536 | 2020-09-15 03:22:50 | Cesar, Colombia | ||
348124 | 348124 | 2022-12-14 | Colombia | Cesar | 109027 | 2687 | 0 | 9.3373 | -73.6536 | 2022-12-15 04:20:58 | Cesar, Colombia | |||
352139 | 352139 | 2021-03-11 | Colombia | Cesar | 41057 | 1201 | 39268 | 588 | 9.3373 | -73.6536 | 2021-03-12 05:26:50 | Cesar, Colombia | ||
356154 | 356154 | 2022-03-11 | Colombia | Cesar | 106269 | 2667 | 0 | 9.3373 | -73.6536 | 2022-03-12 04:20:50 | Cesar, Colombia | |||
360170 | 360170 | 2022-05-07 | Colombia | Cesar | 106546 | 2672 | 0 | 9.3373 | -73.6536 | 2022-05-08 04:20:49 | Cesar, Colombia | |||
367259 | 367259 | 2020-07-16 | Colombia | Cesar | 1665 | 41 | 924 | 700 | 9.3373 | -73.6536 | 2020-07-17 04:34:50 | Cesar, Colombia | ||
371221 | 371221 | 2020-08-08 | Colombia | Cesar | 4382 | 90 | 2002 | 2290 | 9.3373 | -73.6536 | 2020-08-09 04:34:54 | Cesar, Colombia | ||
372024 | 372024 | 2022-09-13 | Colombia | Cesar | 108666 | 2681 | 0 | 9.3373 | -73.6536 | 2022-09-14 04:20:44 | Cesar, Colombia | |||
376026 | 376026 | 2020-11-06 | Colombia | Cesar | 26992 | 832 | 24280 | 1880 | 9.3373 | -73.6536 | 2020-11-07 05:24:52 | Cesar, Colombia | ||
380036 | 380036 | 2021-04-30 | Colombia | Cesar | 53090 | 1424 | 49850 | 1816 | 9.3373 | -73.6536 | 2021-05-01 04:20:47 | Cesar, Colombia | ||
384051 | 384051 | 2022-09-23 | Colombia | Cesar | 108822 | 2681 | 0 | 9.3373 | -73.6536 | 2022-09-24 04:21:40 | Cesar, Colombia | |||
388066 | 388066 | 2021-04-04 | Colombia | Cesar | 43964 | 1257 | 41917 | 790 | 9.3373 | -73.6536 | 2021-04-05 04:20:35 | Cesar, Colombia | ||
392079 | 392079 | 2020-11-27 | Colombia | Cesar | 29261 | 894 | 26618 | 1749 | 9.3373 | -73.6536 | 2020-11-28 05:25:50 | Cesar, Colombia | ||
396092 | 396092 | 2022-10-07 | Colombia | Cesar | 108839 | 2682 | 0 | 9.3373 | -73.6536 | 2022-10-08 04:22:56 | Cesar, Colombia | |||
400107 | 400107 | 2021-06-29 | Colombia | Cesar | 79736 | 2173 | 75375 | 2188 | 9.3373 | -73.6536 | 2021-06-30 04:21:41 | Cesar, Colombia | ||
404121 | 404121 | 2021-12-07 | Colombia | Cesar | 92180 | 2534 | 0 | 9.3373 | -73.6536 | 2021-12-08 04:22:46 | Cesar, Colombia | |||
408137 | 408137 | 2021-07-28 | Colombia | Cesar | 86234 | 2386 | 82418 | 1430 | 9.3373 | -73.6536 | 2021-07-29 04:21:33 | Cesar, Colombia | ||
415202 | 415202 | 2020-07-05 | Colombia | Cesar | 1272 | 32 | 515 | 725 | 9.3373 | -73.6536 | 2020-07-06 04:33:57 | Cesar, Colombia | ||
419163 | 419163 | 2022-09-18 | Colombia | Cesar | 108674 | 2681 | 0 | 9.3373 | -73.6536 | 2022-09-19 04:21:49 | Cesar, Colombia | |||
423178 | 423178 | 2021-10-10 | Colombia | Cesar | 89294 | 2493 | 0 | 9.3373 | -73.6536 | 2021-10-11 04:21:31 | Cesar, 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]);