johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Capital District" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2712159 | 2712159 | 2020-05-28 | Colombia | Capital District | 8045 | 235 | 2552 | 5258 | 4.711 | -74.0721 | 2020-05-29 02:32:50 | Capital District, Colombia | ||
1790279 | 1790279 | 2020-05-29 | Colombia | Capital District | 8536 | 238 | 2837 | 5461 | 4.711 | -74.0721 | 2020-05-30 02:32:48 | Capital District, Colombia | ||
3638738 | 3638738 | 2020-05-30 | Colombia | Capital District | 9162 | 250 | 2918 | 5994 | 4.711 | -74.0721 | 2020-05-31 02:32:45 | Capital District, Colombia | ||
1793845 | 1793845 | 2020-05-31 | Colombia | Capital District | 9637 | 261 | 2986 | 6390 | 4.711 | -74.0721 | 2020-06-01 02:32:46 | Capital District, Colombia | ||
805210 | 805210 | 2020-06-01 | Colombia | Capital District | 9989 | 268 | 3396 | 6325 | 4.711 | -74.0721 | 2020-06-02 02:33:08 | Capital District, Colombia | ||
2555674 | 2555674 | 2020-06-02 | Colombia | Capital District | 10370 | 273 | 3715 | 6382 | 4.711 | -74.0721 | 2020-06-03 02:33:13 | Capital District, Colombia | ||
3866631 | 3866631 | 2020-06-03 | Colombia | Capital District | 10743 | 282 | 4115 | 6346 | 4.711 | -74.0721 | 2020-06-04 02:33:14 | Capital District, Colombia | ||
1281076 | 1281076 | 2020-06-04 | Colombia | Capital District | 11250 | 288 | 4494 | 6468 | 4.711 | -74.0721 | 2020-06-05 02:33:06 | Capital District, Colombia | ||
573899 | 573899 | 2020-06-06 | Colombia | Capital District | 12185 | 311 | 4895 | 6979 | 4.711 | -74.0721 | 2020-06-07 03:53:30 | Capital District, Colombia | ||
1269596 | 1269596 | 2020-06-05 | Colombia | Capital District | 12185 | 311 | 4895 | 6979 | 4.711 | -74.0721 | 2020-06-06 02:33:00 | Capital District, Colombia | ||
2799843 | 2799843 | 2020-06-07 | Colombia | Capital District | 12531 | 320 | 5109 | 7102 | 4.711 | -74.0721 | 2020-06-08 03:33:22 | Capital District, Colombia | ||
217046 | 217046 | 2020-06-08 | Colombia | Capital District | 13329 | 335 | 5682 | 7312 | 4.711 | -74.0721 | 2020-06-09 03:33:03 | Capital District, Colombia | ||
1210619 | 1210619 | 2020-06-09 | Colombia | Capital District | 13329 | 335 | 5682 | 7312 | 4.711 | -74.0721 | 2020-06-10 04:07:00 | Capital District, Colombia | ||
2863766 | 2863766 | 2020-06-10 | Colombia | Capital District | 13709 | 344 | 5720 | 7645 | 4.711 | -74.0721 | 2020-06-11 03:33:41 | Capital District, Colombia | ||
1273322 | 1273322 | 2020-06-11 | Colombia | Capital District | 14132 | 358 | 6060 | 7714 | 4.711 | -74.0721 | 2020-06-12 05:09:52 | Capital District, Colombia | ||
737352 | 737352 | 2020-06-12 | Colombia | Capital District | 14537 | 362 | 6155 | 8020 | 4.711 | -74.0721 | 2020-06-13 03:33:14 | Capital District, Colombia | ||
3061032 | 3061032 | 2020-06-13 | Colombia | Capital District | 14940 | 382 | 6429 | 8129 | 4.711 | -74.0721 | 2020-06-14 03:33:15 | Capital District, Colombia | ||
1836980 | 1836980 | 2020-06-14 | Colombia | Capital District | 15458 | 388 | 6742 | 8328 | 4.711 | -74.0721 | 2020-06-15 03:33:14 | Capital District, Colombia | ||
287029 | 287029 | 2020-06-15 | Colombia | Capital District | 16404 | 416 | 6885 | 9103 | 4.711 | -74.0721 | 2020-06-16 04:33:09 | Capital District, Colombia | ||
2386466 | 2386466 | 2020-06-16 | Colombia | Capital District | 16404 | 416 | 6885 | 9103 | 4.711 | -74.0721 | 2020-06-17 04:33:21 | Capital District, Colombia | ||
1195703 | 1195703 | 2020-06-17 | Colombia | Capital District | 16839 | 439 | 6953 | 9447 | 4.711 | -74.0721 | 2020-06-18 04:33:18 | Capital District, Colombia | ||
3682500 | 3682500 | 2020-06-18 | Colombia | Capital District | 17392 | 448 | 7206 | 9738 | 4.711 | -74.0721 | 2020-06-19 04:33:17 | Capital District, Colombia | ||
1691351 | 1691351 | 2020-06-19 | Colombia | Capital District | 18179 | 463 | 7617 | 10099 | 4.711 | -74.0721 | 2020-06-20 04:33:19 | Capital District, Colombia | ||
2437773 | 2437773 | 2020-06-20 | Colombia | Capital District | 19241 | 475 | 8105 | 10661 | 4.711 | -74.0721 | 2020-06-21 04:33:19 | Capital District, Colombia | ||
3249180 | 3249180 | 2020-06-21 | Colombia | Capital District | 20709 | 510 | 9100 | 11099 | 4.711 | -74.0721 | 2020-06-22 04:33:20 | Capital District, Colombia | ||
1510441 | 1510441 | 2020-06-22 | Colombia | Capital District | 21541 | 518 | 9671 | 11352 | 4.711 | -74.0721 | 2020-06-23 04:33:22 | Capital District, Colombia | ||
1522247 | 1522247 | 2020-06-23 | Colombia | Capital District | 22409 | 540 | 10044 | 11825 | 4.711 | -74.0721 | 2020-06-24 04:33:28 | Capital District, Colombia | ||
2700562 | 2700562 | 2020-06-24 | Colombia | Capital District | 22409 | 540 | 10044 | 11825 | 4.711 | -74.0721 | 2020-06-25 05:26:54 | Capital District, Colombia | ||
2624922 | 2624922 | 2020-06-25 | Colombia | Capital District | 23367 | 558 | 10317 | 12492 | 4.711 | -74.0721 | 2020-06-26 04:33:43 | Capital District, Colombia | ||
1135935 | 1135935 | 2020-06-26 | Colombia | Capital District | 24636 | 575 | 10714 | 13347 | 4.711 | -74.0721 | 2020-06-27 04:33:35 | Capital District, Colombia | ||
2039654 | 2039654 | 2020-06-27 | Colombia | Capital District | 25540 | 602 | 10999 | 13939 | 4.711 | -74.0721 | 2020-06-28 04:34:04 | Capital District, Colombia | ||
2306319 | 2306319 | 2020-06-28 | Colombia | Capital District | 27927 | 665 | 11955 | 15307 | 4.711 | -74.0721 | 2020-06-29 04:33:44 | Capital District, Colombia | ||
2632756 | 2632756 | 2020-06-29 | Colombia | Capital District | 27927 | 665 | 11955 | 15307 | 4.711 | -74.0721 | 2020-06-30 04:33:48 | Capital District, Colombia | ||
2974279 | 2974279 | 2020-06-30 | Colombia | Capital District | 29320 | 691 | 12255 | 16374 | 4.711 | -74.0721 | 2020-07-01 04:33:52 | Capital District, Colombia | ||
302901 | 302901 | 2020-07-01 | Colombia | Capital District | 30017 | 713 | 12756 | 16548 | 4.711 | -74.0721 | 2020-07-02 04:33:46 | Capital District, Colombia | ||
3045210 | 3045210 | 2020-07-02 | Colombia | Capital District | 31417 | 735 | 13065 | 17617 | 4.711 | -74.0721 | 2020-07-03 04:33:54 | Capital District, Colombia | ||
2234416 | 2234416 | 2020-07-03 | Colombia | Capital District | 32726 | 774 | 13299 | 18653 | 4.711 | -74.0721 | 2020-07-04 04:33:51 | Capital District, Colombia | ||
529755 | 529755 | 2020-07-04 | Colombia | Capital District | 34131 | 806 | 13484 | 19841 | 4.711 | -74.0721 | 2020-07-05 04:33:46 | Capital District, Colombia | ||
415193 | 415193 | 2020-07-05 | Colombia | Capital District | 35266 | 842 | 13771 | 20653 | 4.711 | -74.0721 | 2020-07-06 04:33:57 | Capital District, Colombia | ||
2684728 | 2684728 | 2020-07-06 | Colombia | Capital District | 36554 | 871 | 14099 | 21584 | 4.711 | -74.0721 | 2020-07-07 04:34:00 | Capital District, Colombia | ||
887168 | 887168 | 2020-07-07 | Colombia | Capital District | 37641 | 907 | 14930 | 21804 | 4.711 | -74.0721 | 2020-07-08 05:33:48 | Capital District, Colombia | ||
2222559 | 2222559 | 2020-07-08 | Colombia | Capital District | 39248 | 931 | 15228 | 23089 | 4.711 | -74.0721 | 2020-07-09 04:34:23 | Capital District, Colombia | ||
1005343 | 1005343 | 2020-07-09 | Colombia | Capital District | 40737 | 984 | 15566 | 24187 | 4.711 | -74.0721 | 2020-07-10 04:34:24 | Capital District, Colombia | ||
3237358 | 3237358 | 2020-07-10 | Colombia | Capital District | 42347 | 1026 | 16217 | 25104 | 4.711 | -74.0721 | 2020-07-11 04:34:26 | Capital District, Colombia | ||
3435860 | 3435860 | 2020-07-11 | Colombia | Capital District | 45039 | 1076 | 16755 | 27208 | 4.711 | -74.0721 | 2020-07-12 04:34:30 | Capital District, Colombia | ||
3737465 | 3737465 | 2020-07-12 | Colombia | Capital District | 47524 | 1138 | 17323 | 29063 | 4.711 | -74.0721 | 2020-07-13 04:43:04 | Capital District, Colombia | ||
3491203 | 3491203 | 2020-07-13 | Colombia | Capital District | 49644 | 1201 | 17866 | 30577 | 4.711 | -74.0721 | 2020-07-14 04:34:46 | Capital District, Colombia | ||
2158562 | 2158562 | 2020-07-14 | Colombia | Capital District | 51281 | 1248 | 18421 | 31612 | 4.711 | -74.0721 | 2020-07-15 04:34:39 | Capital District, Colombia | ||
2747918 | 2747918 | 2020-07-15 | Colombia | Capital District | 53131 | 1299 | 19075 | 32757 | 4.711 | -74.0721 | 2020-07-16 04:44:59 | Capital District, Colombia | ||
367250 | 367250 | 2020-07-16 | Colombia | Capital District | 55056 | 1376 | 19668 | 34012 | 4.711 | -74.0721 | 2020-07-17 04:34:50 | Capital District, Colombia | ||
2708431 | 2708431 | 2020-07-17 | Colombia | Capital District | 58917 | 1402 | 22047 | 35468 | 4.711 | -74.0721 | 2020-07-18 04:34:45 | Capital District, Colombia | ||
3205129 | 3205129 | 2020-07-18 | Colombia | Capital District | 60394 | 1486 | 23318 | 35590 | 4.711 | -74.0721 | 2020-07-19 04:34:58 | Capital District, Colombia | ||
121740 | 121740 | 2020-07-19 | Colombia | Capital District | 63265 | 1555 | 24447 | 37263 | 4.711 | -74.0721 | 2020-07-20 05:34:40 | Capital District, Colombia | ||
326835 | 326835 | 2020-07-20 | Colombia | Capital District | 65594 | 1627 | 25614 | 38353 | 4.711 | -74.0721 | 2020-07-21 04:38:46 | Capital District, Colombia | ||
1707344 | 1707344 | 2020-07-21 | Colombia | Capital District | 67843 | 1713 | 26411 | 39719 | 4.711 | -74.0721 | 2020-07-22 04:34:42 | Capital District, Colombia | ||
844605 | 844605 | 2020-07-22 | Colombia | Capital District | 70849 | 1794 | 27281 | 41774 | 4.711 | -74.0721 | 2020-07-23 05:15:04 | Capital District, Colombia | ||
61813 | 61813 | 2020-07-23 | Colombia | Capital District | 74599 | 1905 | 29333 | 43361 | 4.711 | -74.0721 | 2020-07-24 05:30:40 | Capital District, Colombia | ||
2563585 | 2563585 | 2020-07-24 | Colombia | Capital District | 77889 | 2000 | 32222 | 43667 | 4.711 | -74.0721 | 2020-07-25 04:47:39 | Capital District, Colombia | ||
442371 | 442371 | 2020-07-26 | Colombia | Capital District | 81180 | 2115 | 33753 | 45312 | 4.711 | -74.0721 | 2020-07-27 04:35:02 | Capital District, Colombia | ||
1502615 | 1502615 | 2020-07-25 | Colombia | Capital District | 81180 | 2115 | 33753 | 45312 | 4.711 | -74.0721 | 2020-07-26 04:35:00 | Capital District, Colombia | ||
177058 | 177058 | 2020-07-27 | Colombia | Capital District | 86857 | 2307 | 37916 | 46634 | 4.711 | -74.0721 | 2020-07-28 04:58:43 | Capital District, Colombia | ||
3185006 | 3185006 | 2020-07-28 | Colombia | Capital District | 91408 | 2392 | 40090 | 48926 | 4.711 | -74.0721 | 2020-07-29 04:35:11 | Capital District, Colombia | ||
2958390 | 2958390 | 2020-07-29 | Colombia | Capital District | 95199 | 2517 | 42179 | 50503 | 4.711 | -74.0721 | 2020-07-30 04:35:05 | Capital District, Colombia | ||
1928222 | 1928222 | 2020-07-30 | Colombia | Capital District | 98209 | 2658 | 44015 | 51536 | 4.711 | -74.0721 | 2020-07-31 04:35:18 | Capital District, Colombia | ||
3264515 | 3264515 | 2020-07-31 | Colombia | Capital District | 101955 | 2748 | 46107 | 53100 | 4.711 | -74.0721 | 2020-08-01 04:36:27 | Capital District, Colombia | ||
753350 | 753350 | 2020-08-01 | Colombia | Capital District | 104656 | 2828 | 48624 | 53204 | 4.711 | -74.0721 | 2020-08-02 04:34:47 | Capital District, Colombia | ||
2807782 | 2807782 | 2020-08-02 | Colombia | Capital District | 109153 | 2910 | 51123 | 55120 | 4.711 | -74.0721 | 2020-08-03 04:34:35 | Capital District, Colombia | ||
2740030 | 2740030 | 2020-08-03 | Colombia | Capital District | 111294 | 3052 | 53395 | 54847 | 4.711 | -74.0721 | 2020-08-04 04:41:59 | Capital District, Colombia | ||
98147 | 98147 | 2020-08-04 | Colombia | Capital District | 113548 | 3169 | 55013 | 55366 | 4.711 | -74.0721 | 2020-08-05 04:34:43 | Capital District, Colombia | ||
3792911 | 3792911 | 2020-08-05 | Colombia | Capital District | 117793 | 3261 | 56602 | 57930 | 4.711 | -74.0721 | 2020-08-06 04:35:02 | Capital District, Colombia | ||
3612081 | 3612081 | 2020-08-06 | Colombia | Capital District | 123875 | 3375 | 57838 | 62662 | 4.711 | -74.0721 | 2020-08-07 04:35:11 | Capital District, Colombia | ||
458396 | 458396 | 2020-08-07 | Colombia | Capital District | 126488 | 3481 | 59566 | 63441 | 4.711 | -74.0721 | 2020-08-08 04:34:53 | Capital District, Colombia | ||
371212 | 371212 | 2020-08-08 | Colombia | Capital District | 129975 | 3578 | 61188 | 65209 | 4.711 | -74.0721 | 2020-08-09 04:34:54 | Capital District, Colombia | ||
3923044 | 3923044 | 2020-08-09 | Colombia | Capital District | 133423 | 3668 | 62758 | 66997 | 4.711 | -74.0721 | 2020-08-10 04:34:55 | Capital District, Colombia | ||
1920235 | 1920235 | 2020-08-10 | Colombia | Capital District | 136764 | 3778 | 65361 | 67625 | 4.711 | -74.0721 | 2020-08-11 04:35:08 | Capital District, Colombia | ||
662140 | 662140 | 2020-08-11 | Colombia | Capital District | 141994 | 3883 | 70225 | 67886 | 4.711 | -74.0721 | 2020-08-12 04:27:29 | Capital District, Colombia | ||
3531291 | 3531291 | 2020-08-12 | Colombia | Capital District | 146109 | 3998 | 75551 | 66560 | 4.711 | -74.0721 | 2020-08-13 04:29:15 | Capital District, Colombia | ||
582672 | 582672 | 2020-08-13 | Colombia | Capital District | 149944 | 4096 | 80857 | 64991 | 4.711 | -74.0721 | 2020-08-14 04:51:19 | Capital District, Colombia | ||
1612088 | 1612088 | 2020-08-14 | Colombia | Capital District | 154452 | 4172 | 84153 | 66127 | 4.711 | -74.0721 | 2020-08-15 04:27:31 | Capital District, Colombia | ||
145813 | 145813 | 2020-08-15 | Colombia | Capital District | 158674 | 4269 | 87444 | 66961 | 4.711 | -74.0721 | 2020-08-16 04:27:42 | Capital District, Colombia | ||
1555811 | 1555811 | 2020-08-16 | Colombia | Capital District | 163295 | 4358 | 92318 | 66619 | 4.711 | -74.0721 | 2020-08-17 04:27:20 | Capital District, Colombia | ||
837453 | 837453 | 2020-08-17 | Colombia | Capital District | 166685 | 4424 | 97193 | 65068 | 4.711 | -74.0721 | 2020-08-18 04:27:56 | Capital District, Colombia | ||
3177849 | 3177849 | 2020-08-18 | Colombia | Capital District | 171312 | 4494 | 101852 | 64966 | 4.711 | -74.0721 | 2020-08-19 04:27:00 | Capital District, Colombia | ||
206095 | 206095 | 2020-08-19 | Colombia | Capital District | 176336 | 4587 | 106822 | 64927 | 4.711 | -74.0721 | 2020-08-20 04:27:43 | Capital District, Colombia | ||
3484146 | 3484146 | 2020-08-20 | Colombia | Capital District | 179540 | 4647 | 109655 | 65238 | 4.711 | -74.0721 | 2020-08-21 04:27:41 | Capital District, Colombia | ||
1479397 | 1479397 | 2020-08-21 | Colombia | Capital District | 181775 | 4754 | 112187 | 64834 | 4.711 | -74.0721 | 2020-08-22 04:27:49 | Capital District, Colombia | ||
2299290 | 2299290 | 2020-08-22 | Colombia | Capital District | 181775 | 4754 | 112187 | 64834 | 4.711 | -74.0721 | 2020-08-23 04:27:48 | Capital District, Colombia | ||
2215508 | 2215508 | 2020-08-23 | Colombia | Capital District | 188220 | 4951 | 122221 | 61048 | 4.711 | -74.0721 | 2020-08-24 04:27:56 | Capital District, Colombia | ||
2991113 | 2991113 | 2020-08-24 | Colombia | Capital District | 192654 | 5008 | 125529 | 62117 | 4.711 | -74.0721 | 2020-08-25 04:28:02 | Capital District, Colombia | ||
3562409 | 3562409 | 2020-08-25 | Colombia | Capital District | 195137 | 5084 | 128820 | 61233 | 4.711 | -74.0721 | 2020-08-26 04:28:11 | Capital District, Colombia | ||
1996485 | 1996485 | 2020-08-26 | Colombia | Capital District | 199324 | 5160 | 132641 | 61523 | 4.711 | -74.0721 | 2020-08-27 04:28:15 | Capital District, Colombia | ||
2510025 | 2510025 | 2020-08-27 | Colombia | Capital District | 201880 | 5230 | 135948 | 60702 | 4.711 | -74.0721 | 2020-08-28 04:28:11 | Capital District, Colombia | ||
1523024 | 1523024 | 2020-08-28 | Colombia | Capital District | 204065 | 5276 | 141204 | 57585 | 4.711 | -74.0721 | 2020-08-29 04:28:19 | Capital District, Colombia | ||
609529 | 609529 | 2020-08-29 | Colombia | Capital District | 207403 | 5310 | 145433 | 56660 | 4.711 | -74.0721 | 2020-08-30 04:28:22 | Capital District, Colombia | ||
3931867 | 3931867 | 2020-08-30 | Colombia | Capital District | 209250 | 5375 | 148540 | 55335 | 4.711 | -74.0721 | 2020-08-31 04:28:27 | Capital District, Colombia | ||
193908 | 193908 | 2020-08-31 | Colombia | Capital District | 211300 | 5437 | 151131 | 54732 | 4.711 | -74.0721 | 2020-09-01 04:28:31 | Capital District, Colombia | ||
2059723 | 2059723 | 2020-09-01 | Colombia | Capital District | 213631 | 5548 | 155509 | 52574 | 4.711 | -74.0721 | 2020-09-02 04:28:25 | Capital District, Colombia | ||
1105394 | 1105394 | 2020-09-02 | Colombia | Capital District | 216654 | 5593 | 159074 | 51987 | 4.711 | -74.0721 | 2020-09-03 04:28:22 | Capital District, Colombia | ||
1354157 | 1354157 | 2020-09-03 | Colombia | Capital District | 219584 | 5652 | 160976 | 52956 | 4.711 | -74.0721 | 2020-09-04 04:28:26 | Capital District, Colombia | ||
2661617 | 2661617 | 2020-09-04 | Colombia | Capital District | 219584 | 5652 | 160976 | 52956 | 4.711 | -74.0721 | 2020-09-05 04:28:19 | Capital District, 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]);