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 = "Arauca" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
443173 | 443173 | 2021-10-20 | Colombia | Arauca | 13486 | 461 | 0 | 7.0762 | -70.7105 | 2021-10-21 04:21:18 | Arauca, Colombia | |||
597492 | 597492 | 2021-10-19 | Colombia | Arauca | 13482 | 461 | 0 | 7.0762 | -70.7105 | 2021-10-20 04:21:00 | Arauca, Colombia | |||
2043669 | 2043669 | 2021-10-18 | Colombia | Arauca | 13481 | 461 | 0 | 7.0762 | -70.7105 | 2021-10-19 04:20:54 | Arauca, Colombia | |||
1909030 | 1909030 | 2021-10-17 | Colombia | Arauca | 13473 | 461 | 0 | 7.0762 | -70.7105 | 2021-10-18 04:21:10 | Arauca, Colombia | |||
934619 | 934619 | 2021-10-16 | Colombia | Arauca | 13467 | 461 | 0 | 7.0762 | -70.7105 | 2021-10-17 04:21:29 | Arauca, Colombia | |||
2943174 | 2943174 | 2021-10-15 | Colombia | Arauca | 13449 | 461 | 0 | 7.0762 | -70.7105 | 2021-10-16 04:21:15 | Arauca, Colombia | |||
491454 | 491454 | 2021-10-14 | Colombia | Arauca | 13436 | 460 | 0 | 7.0762 | -70.7105 | 2021-10-15 04:21:26 | Arauca, Colombia | |||
633742 | 633742 | 2021-10-13 | Colombia | Arauca | 13409 | 460 | 0 | 7.0762 | -70.7105 | 2021-10-14 04:21:29 | Arauca, Colombia | |||
1491420 | 1491420 | 2021-10-12 | Colombia | Arauca | 13409 | 460 | 0 | 7.0762 | -70.7105 | 2021-10-13 04:20:51 | Arauca, Colombia | |||
3007153 | 3007153 | 2021-10-11 | Colombia | Arauca | 13403 | 460 | 0 | 7.0762 | -70.7105 | 2021-10-12 04:21:09 | Arauca, Colombia | |||
423169 | 423169 | 2021-10-10 | Colombia | Arauca | 13397 | 460 | 0 | 7.0762 | -70.7105 | 2021-10-11 04:21:31 | Arauca, Colombia | |||
2876026 | 2876026 | 2021-10-09 | Colombia | Arauca | 13394 | 460 | 0 | 7.0762 | -70.7105 | 2021-10-10 04:21:38 | Arauca, Colombia | |||
2959192 | 2959192 | 2021-10-08 | Colombia | Arauca | 13331 | 460 | 0 | 7.0762 | -70.7105 | 2021-10-09 04:21:34 | Arauca, Colombia | |||
467230 | 467230 | 2021-10-07 | Colombia | Arauca | 13329 | 458 | 0 | 7.0762 | -70.7105 | 2021-10-08 04:21:25 | Arauca, Colombia | |||
2458610 | 2458610 | 2021-10-06 | Colombia | Arauca | 13327 | 458 | 0 | 7.0762 | -70.7105 | 2021-10-07 04:21:36 | Arauca, Colombia | |||
3832304 | 3832304 | 2021-10-05 | Colombia | Arauca | 13326 | 458 | 0 | 7.0762 | -70.7105 | 2021-10-06 04:21:33 | Arauca, Colombia | |||
986797 | 986797 | 2021-10-04 | Colombia | Arauca | 13325 | 457 | 0 | 7.0762 | -70.7105 | 2021-10-05 04:21:27 | Arauca, Colombia | |||
1274107 | 1274107 | 2021-10-03 | Colombia | Arauca | 13322 | 456 | 0 | 7.0762 | -70.7105 | 2021-10-04 04:21:31 | Arauca, Colombia | |||
3927860 | 3927860 | 2021-10-02 | Colombia | Arauca | 13321 | 456 | 0 | 7.0762 | -70.7105 | 2021-10-03 04:21:24 | Arauca, Colombia | |||
2131840 | 2131840 | 2021-10-01 | Colombia | Arauca | 13316 | 455 | 0 | 7.0762 | -70.7105 | 2021-10-02 04:21:25 | Arauca, Colombia | |||
2772797 | 2772797 | 2021-09-30 | Colombia | Arauca | 13303 | 455 | 0 | 7.0762 | -70.7105 | 2021-10-01 04:21:35 | Arauca, Colombia | |||
706253 | 706253 | 2021-09-29 | Colombia | Arauca | 13301 | 455 | 0 | 7.0762 | -70.7105 | 2021-09-30 04:21:20 | Arauca, Colombia | |||
1334095 | 1334095 | 2021-09-28 | Colombia | Arauca | 13295 | 455 | 0 | 7.0762 | -70.7105 | 2021-09-29 04:21:45 | Arauca, Colombia | |||
1235464 | 1235464 | 2021-09-27 | Colombia | Arauca | 13293 | 455 | 0 | 7.0762 | -70.7105 | 2021-09-28 04:21:28 | Arauca, Colombia | |||
2075765 | 2075765 | 2021-09-26 | Colombia | Arauca | 13293 | 455 | 0 | 7.0762 | -70.7105 | 2021-09-27 04:21:16 | Arauca, Colombia | |||
1724317 | 1724317 | 2021-09-25 | Colombia | Arauca | 13289 | 454 | 0 | 7.0762 | -70.7105 | 2021-09-26 04:21:29 | Arauca, Colombia | |||
1921037 | 1921037 | 2021-09-24 | Colombia | Arauca | 13284 | 454 | 0 | 7.0762 | -70.7105 | 2021-09-25 04:21:31 | Arauca, Colombia | |||
601508 | 601508 | 2021-09-23 | Colombia | Arauca | 13280 | 454 | 0 | 7.0762 | -70.7105 | 2021-09-24 04:21:44 | Arauca, Colombia | |||
3011169 | 3011169 | 2021-09-22 | Colombia | Arauca | 13279 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-23 04:21:43 | Arauca, Colombia | |||
3757307 | 3757307 | 2021-09-21 | Colombia | Arauca | 13264 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-22 04:21:45 | Arauca, Colombia | |||
809410 | 809410 | 2021-09-20 | Colombia | Arauca | 13258 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-21 04:21:26 | Arauca, Colombia | |||
1814609 | 1814609 | 2021-09-19 | Colombia | Arauca | 13252 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-20 04:21:22 | Arauca, Colombia | |||
16189 | 16189 | 2021-09-18 | Colombia | Arauca | 13245 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-19 04:21:34 | Arauca, Colombia | |||
2617874 | 2617874 | 2021-09-17 | Colombia | Arauca | 13211 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-18 04:21:24 | Arauca, Colombia | |||
2808582 | 2808582 | 2021-09-16 | Colombia | Arauca | 13205 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-17 04:21:46 | Arauca, Colombia | |||
1374327 | 1374327 | 2021-09-15 | Colombia | Arauca | 13194 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-16 04:22:19 | Arauca, Colombia | |||
2462626 | 2462626 | 2021-09-14 | Colombia | Arauca | 13194 | 452 | 0 | 7.0762 | -70.7105 | 2021-09-15 03:22:37 | Arauca, Colombia | |||
1385465 | 1385465 | 2021-09-13 | Colombia | Arauca | 13192 | 451 | 0 | 7.0762 | -70.7105 | 2021-09-14 04:21:41 | Arauca, Colombia | |||
1884834 | 1884834 | 2021-09-12 | Colombia | Arauca | 13191 | 451 | 0 | 7.0762 | -70.7105 | 2021-09-13 04:21:15 | Arauca, Colombia | |||
3805737 | 3805737 | 2021-09-11 | Colombia | Arauca | 13191 | 451 | 0 | 7.0762 | -70.7105 | 2021-09-12 04:21:13 | Arauca, Colombia | |||
3448677 | 3448677 | 2021-09-10 | Colombia | Arauca | 13187 | 451 | 0 | 7.0762 | -70.7105 | 2021-09-11 04:21:30 | Arauca, Colombia | |||
1262623 | 1262623 | 2021-09-09 | Colombia | Arauca | 13184 | 450 | 0 | 7.0762 | -70.7105 | 2021-09-10 04:21:20 | Arauca, Colombia | |||
2278993 | 2278993 | 2021-09-08 | Colombia | Arauca | 13181 | 450 | 0 | 7.0762 | -70.7105 | 2021-09-09 04:21:27 | Arauca, Colombia | |||
641772 | 641772 | 2021-09-07 | Colombia | Arauca | 13173 | 450 | 0 | 7.0762 | -70.7105 | 2021-09-08 04:21:31 | Arauca, Colombia | |||
3193835 | 3193835 | 2021-09-06 | Colombia | Arauca | 13167 | 450 | 0 | 7.0762 | -70.7105 | 2021-09-07 04:21:35 | Arauca, Colombia | |||
3280703 | 3280703 | 2021-09-05 | Colombia | Arauca | 13164 | 449 | 0 | 7.0762 | -70.7105 | 2021-09-06 04:21:22 | Arauca, Colombia | |||
249117 | 249117 | 2021-09-04 | Colombia | Arauca | 13158 | 448 | 0 | 7.0762 | -70.7105 | 2021-09-05 04:21:33 | Arauca, Colombia | |||
3974398 | 3974398 | 2021-09-03 | Colombia | Arauca | 13147 | 446 | 0 | 7.0762 | -70.7105 | 2021-09-04 04:21:28 | Arauca, Colombia | |||
177860 | 177860 | 2021-09-02 | Colombia | Arauca | 13142 | 446 | 0 | 7.0762 | -70.7105 | 2021-09-03 04:21:20 | Arauca, Colombia | |||
66895 | 66895 | 2021-09-01 | Colombia | Arauca | 13129 | 445 | 0 | 7.0762 | -70.7105 | 2021-09-02 04:21:15 | Arauca, Colombia | |||
2067737 | 2067737 | 2021-08-31 | Colombia | Arauca | 13110 | 444 | 0 | 7.0762 | -70.7105 | 2021-09-01 04:21:38 | Arauca, Colombia | |||
1775191 | 1775191 | 2021-08-30 | Colombia | Arauca | 13107 | 443 | 0 | 7.0762 | -70.7105 | 2021-08-31 04:21:46 | Arauca, Colombia | |||
3891765 | 3891765 | 2021-08-29 | Colombia | Arauca | 13104 | 441 | 0 | 7.0762 | -70.7105 | 2021-08-30 04:21:23 | Arauca, Colombia | |||
2792868 | 2792868 | 2021-08-28 | Colombia | Arauca | 13100 | 441 | 0 | 7.0762 | -70.7105 | 2021-08-29 04:21:14 | Arauca, Colombia | |||
2923027 | 2923027 | 2021-08-27 | Colombia | Arauca | 13089 | 441 | 0 | 7.0762 | -70.7105 | 2021-08-28 04:21:28 | Arauca, Colombia | |||
1596041 | 1596041 | 2021-08-26 | Colombia | Arauca | 13076 | 440 | 0 | 7.0762 | -70.7105 | 2021-08-27 04:21:37 | Arauca, Colombia | |||
32250 | 32250 | 2021-08-25 | Colombia | Arauca | 13060 | 440 | 0 | 7.0762 | -70.7105 | 2021-08-26 04:21:28 | Arauca, Colombia | |||
3105289 | 3105289 | 2021-08-24 | Colombia | Arauca | 13060 | 440 | 0 | 7.0762 | -70.7105 | 2021-08-25 04:21:41 | Arauca, Colombia | |||
3165460 | 3165460 | 2021-08-23 | Colombia | Arauca | 13054 | 440 | 0 | 7.0762 | -70.7105 | 2021-08-24 04:21:19 | Arauca, Colombia | |||
2175387 | 2175387 | 2021-08-22 | Colombia | Arauca | 13051 | 438 | 0 | 7.0762 | -70.7105 | 2021-08-23 04:21:27 | Arauca, Colombia | |||
3555483 | 3555483 | 2021-08-21 | Colombia | Arauca | 13048 | 437 | 0 | 7.0762 | -70.7105 | 2021-08-22 04:21:29 | Arauca, Colombia | |||
1853825 | 1853825 | 2021-08-20 | Colombia | Arauca | 13036 | 437 | 0 | 7.0762 | -70.7105 | 2021-08-21 04:21:38 | Arauca, Colombia | |||
511532 | 511532 | 2021-08-19 | Colombia | Arauca | 13020 | 436 | 0 | 7.0762 | -70.7105 | 2021-08-20 04:21:33 | Arauca, Colombia | |||
2518011 | 2518011 | 2021-08-18 | Colombia | Arauca | 13003 | 435 | 0 | 7.0762 | -70.7105 | 2021-08-19 04:21:15 | Arauca, Colombia | |||
245103 | 245103 | 2021-08-17 | Colombia | Arauca | 12986 | 435 | 0 | 7.0762 | -70.7105 | 2021-08-18 04:21:35 | Arauca, Colombia | |||
1604066 | 1604066 | 2021-08-16 | Colombia | Arauca | 12986 | 435 | 0 | 7.0762 | -70.7105 | 2021-08-17 04:21:49 | Arauca, Colombia | |||
103160 | 103160 | 2021-08-15 | Colombia | Arauca | 12975 | 434 | 0 | 7.0762 | -70.7105 | 2021-08-16 04:21:31 | Arauca, Colombia | |||
507518 | 507518 | 2021-08-14 | Colombia | Arauca | 12975 | 433 | 0 | 7.0762 | -70.7105 | 2021-08-15 04:21:41 | Arauca, Colombia | |||
1483390 | 1483390 | 2021-08-13 | Colombia | Arauca | 12963 | 433 | 0 | 7.0762 | -70.7105 | 2021-08-14 04:21:25 | Arauca, Colombia | |||
2899520 | 2899520 | 2021-08-12 | Colombia | Arauca | 12950 | 431 | 0 | 7.0762 | -70.7105 | 2021-08-13 04:21:24 | Arauca, Colombia | |||
1342124 | 1342124 | 2021-08-11 | Colombia | Arauca | 12936 | 430 | 0 | 7.0762 | -70.7105 | 2021-08-12 04:21:25 | Arauca, Colombia | |||
2351271 | 2351271 | 2021-08-10 | Colombia | Arauca | 12920 | 426 | 0 | 7.0762 | -70.7105 | 2021-08-11 04:21:58 | Arauca, Colombia | |||
649800 | 649800 | 2021-08-09 | Colombia | Arauca | 12910 | 426 | 0 | 7.0762 | -70.7105 | 2021-08-10 04:21:27 | Arauca, Colombia | |||
589462 | 589462 | 2021-08-08 | Colombia | Arauca | 12908 | 424 | 0 | 7.0762 | -70.7105 | 2021-08-09 04:21:24 | Arauca, Colombia | |||
2203474 | 2203474 | 2021-08-07 | Colombia | Arauca | 12904 | 422 | 0 | 7.0762 | -70.7105 | 2021-08-08 04:21:33 | Arauca, Colombia | |||
1117424 | 1117424 | 2021-08-06 | Colombia | Arauca | 12877 | 421 | 0 | 7.0762 | -70.7105 | 2021-08-07 04:21:30 | Arauca, Colombia | |||
1956361 | 1956361 | 2021-08-05 | Colombia | Arauca | 12856 | 419 | 0 | 7.0762 | -70.7105 | 2021-08-06 04:21:18 | Arauca, Colombia | |||
331740 | 331740 | 2021-08-04 | Colombia | Arauca | 12825 | 418 | 12122 | 285 | 7.0762 | -70.7105 | 2021-08-05 04:21:51 | Arauca, Colombia | ||
3468011 | 3468011 | 2021-08-03 | Colombia | Arauca | 12814 | 415 | 12101 | 298 | 7.0762 | -70.7105 | 2021-08-04 04:21:25 | Arauca, Colombia | ||
3683285 | 3683285 | 2021-08-02 | Colombia | Arauca | 12786 | 415 | 12071 | 300 | 7.0762 | -70.7105 | 2021-08-03 04:21:39 | Arauca, Colombia | ||
3015184 | 3015184 | 2021-08-01 | Colombia | Arauca | 12771 | 415 | 12052 | 304 | 7.0762 | -70.7105 | 2021-08-02 04:21:36 | Arauca, Colombia | ||
3903807 | 3903807 | 2021-07-31 | Colombia | Arauca | 12747 | 413 | 12019 | 315 | 7.0762 | -70.7105 | 2021-08-01 04:21:50 | Arauca, Colombia | ||
3296012 | 3296012 | 2021-07-30 | Colombia | Arauca | 12707 | 412 | 11991 | 304 | 7.0762 | -70.7105 | 2021-07-31 04:21:35 | Arauca, Colombia | ||
3385223 | 3385223 | 2021-07-29 | Colombia | Arauca | 12668 | 406 | 11951 | 311 | 7.0762 | -70.7105 | 2021-07-30 04:21:34 | Arauca, Colombia | ||
408128 | 408128 | 2021-07-28 | Colombia | Arauca | 12618 | 405 | 11900 | 313 | 7.0762 | -70.7105 | 2021-07-29 04:21:33 | Arauca, Colombia | ||
1305989 | 1305989 | 2021-07-27 | Colombia | Arauca | 12566 | 399 | 11856 | 311 | 7.0762 | -70.7105 | 2021-07-28 04:21:39 | Arauca, Colombia | ||
3218132 | 3218132 | 2021-07-26 | Colombia | Arauca | 12525 | 397 | 11805 | 323 | 7.0762 | -70.7105 | 2021-07-27 04:21:18 | Arauca, Colombia | ||
1378341 | 1378341 | 2021-07-25 | Colombia | Arauca | 12498 | 390 | 11658 | 450 | 7.0762 | -70.7105 | 2021-07-26 04:21:28 | Arauca, Colombia | ||
1330081 | 1330081 | 2021-07-24 | Colombia | Arauca | 12370 | 390 | 11614 | 366 | 7.0762 | -70.7105 | 2021-07-25 04:22:12 | Arauca, Colombia | ||
3137385 | 3137385 | 2021-07-23 | Colombia | Arauca | 12287 | 388 | 11508 | 391 | 7.0762 | -70.7105 | 2021-07-24 00:21:36 | Arauca, Colombia | ||
3476145 | 3476145 | 2021-07-22 | Colombia | Arauca | 12287 | 388 | 11508 | 391 | 7.0762 | -70.7105 | 2021-07-23 04:21:29 | Arauca, Colombia | ||
3331364 | 3331364 | 2021-07-21 | Colombia | Arauca | 12241 | 386 | 11475 | 380 | 7.0762 | -70.7105 | 2021-07-22 04:21:19 | Arauca, Colombia | ||
2371345 | 2371345 | 2021-07-20 | Colombia | Arauca | 12051 | 381 | 11426 | 244 | 7.0762 | -70.7105 | 2021-07-21 04:21:40 | Arauca, Colombia | ||
483424 | 483424 | 2021-07-19 | Colombia | Arauca | 12051 | 377 | 11379 | 295 | 7.0762 | -70.7105 | 2021-07-20 04:21:48 | Arauca, Colombia | ||
2673647 | 2673647 | 2021-07-18 | Colombia | Arauca | 12051 | 375 | 11326 | 350 | 7.0762 | -70.7105 | 2021-07-19 04:21:24 | Arauca, Colombia | ||
3705959 | 3705959 | 2021-07-17 | Colombia | Arauca | 12051 | 368 | 11286 | 397 | 7.0762 | -70.7105 | 2021-07-18 04:22:07 | Arauca, Colombia | ||
2947190 | 2947190 | 2021-07-16 | Colombia | Arauca | 11981 | 368 | 11246 | 367 | 7.0762 | -70.7105 | 2021-07-17 04:22:22 | Arauca, Colombia | ||
295846 | 295846 | 2021-07-15 | Colombia | Arauca | 11908 | 363 | 11210 | 335 | 7.0762 | -70.7105 | 2021-07-16 04:21:22 | Arauca, Colombia | ||
3631791 | 3631791 | 2021-07-14 | Colombia | Arauca | 11872 | 360 | 11159 | 353 | 7.0762 | -70.7105 | 2021-07-15 04:21:48 | Arauca, Colombia | ||
578666 | 578666 | 2021-07-13 | Colombia | Arauca | 11788 | 357 | 11108 | 323 | 7.0762 | -70.7105 | 2021-07-14 04:21:35 | Arauca, 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]);