johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

860 rows where country_or_region = "Chile" sorted by day descending

View and edit SQL

country_or_region

  • Chile · 860
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
311649 2020-07-04 Chile Antofagasta     9823 174 7861 1788 -23.6509 -70.3975 2020-07-05 04:33:46 Antofagasta, Chile
311654 2020-07-04 Chile Araucania     3369 44 3037 288 -38.9489 -72.3311 2020-07-05 04:33:46 Araucania, Chile
311656 2020-07-04 Chile Arica y Parinacota     1949 22 1497 430 -18.594 -69.4785 2020-07-05 04:33:46 Arica y Parinacota, Chile
311663 2020-07-04 Chile Atacama     1208 5 879 324 -27.5661 -70.0503 2020-07-05 04:33:46 Atacama, Chile
311667 2020-07-04 Chile Aysen     46 0 32 14 -45.9864 -73.7669 2020-07-05 04:33:46 Aysen, Chile
311683 2020-07-04 Chile Biobio     7262 61 5603 1598 -37.4464 -72.1416 2020-07-05 04:33:46 Biobio, Chile
311732 2020-07-04 Chile Coquimbo     3333 26 2656 651 -29.959 -71.3389 2020-07-05 04:33:46 Coquimbo, Chile
311872 2020-07-04 Chile Los Lagos     1856 21 1496 339 -41.9198 -72.1416 2020-07-05 04:33:46 Los Lagos, Chile
311873 2020-07-04 Chile Los Rios     720 10 633 77 -40.231 -72.3311 2020-07-05 04:33:46 Los Rios, Chile
311881 2020-07-04 Chile Magallanes     1479 15 1355 109 -52.368 -70.9863 2020-07-05 04:33:46 Magallanes, Chile
311892 2020-07-04 Chile Maule     6144 65 4817 1262 -35.5183 -71.6885 2020-07-05 04:33:46 Maule, Chile
311898 2020-07-04 Chile Metropolitana     226128 5251 204387 16490 -33.4376 -70.6505 2020-07-05 04:33:46 Metropolitana, Chile
311943 2020-07-04 Chile Nuble     2533 33 2200 300 -36.7226 -71.7622 2020-07-05 04:33:46 Nuble, Chile
311945 2020-07-04 Chile OHiggins     6859 89 4921 1849 -34.5755 -71.0022 2020-07-05 04:33:46 OHiggins, Chile
312057 2020-07-04 Chile Tarapaca     6372 98 5565 709 -19.9232 -69.5132 2020-07-05 04:33:46 Tarapaca, Chile
312098 2020-07-04 Chile Valparaiso     12766 278 10403 2085 -33.0472 -71.6127 2020-07-05 04:33:46 Valparaiso, Chile
312304 2020-07-04 Chile Unknown     0 0 109 -109     2020-07-03 15:33:50 Unknown, Chile
252083 2020-07-03 Chile Antofagasta     9570 171 7629 1770 -23.6509 -70.3975 2020-07-04 04:33:51 Antofagasta, Chile
252088 2020-07-03 Chile Araucania     3324 44 3010 270 -38.9489 -72.3311 2020-07-04 04:33:51 Araucania, Chile
252090 2020-07-03 Chile Arica y Parinacota     1889 22 1447 420 -18.594 -69.4785 2020-07-04 04:33:51 Arica y Parinacota, Chile
252097 2020-07-03 Chile Atacama     1166 3 822 341 -27.5661 -70.0503 2020-07-04 04:33:51 Atacama, Chile
252101 2020-07-03 Chile Aysen     46 0 30 16 -45.9864 -73.7669 2020-07-04 04:33:51 Aysen, Chile
252117 2020-07-03 Chile Biobio     7131 59 5395 1677 -37.4464 -72.1416 2020-07-04 04:33:51 Biobio, Chile
252166 2020-07-03 Chile Coquimbo     3224 24 2568 632 -29.959 -71.3389 2020-07-04 04:33:51 Coquimbo, Chile
252306 2020-07-03 Chile Los Lagos     1806 21 1463 322 -41.9198 -72.1416 2020-07-04 04:33:51 Los Lagos, Chile
252307 2020-07-03 Chile Los Rios     713 10 618 85 -40.231 -72.3311 2020-07-04 04:33:51 Los Rios, Chile
252315 2020-07-03 Chile Magallanes     1476 15 1340 121 -52.368 -70.9863 2020-07-04 04:33:51 Magallanes, Chile
252326 2020-07-03 Chile Maule     5974 59 4658 1257 -35.5183 -71.6885 2020-07-04 04:33:51 Maule, Chile
252332 2020-07-03 Chile Metropolitana     223892 5145 201801 16946 -33.4376 -70.6505 2020-07-04 04:33:51 Metropolitana, Chile
252377 2020-07-03 Chile Nuble     2490 33 2165 292 -36.7226 -71.7622 2020-07-04 04:33:51 Nuble, Chile
252379 2020-07-03 Chile OHiggins     6625 83 4675 1867 -34.5755 -71.0022 2020-07-04 04:33:51 OHiggins, Chile
252491 2020-07-03 Chile Tarapaca     6298 96 5479 723 -19.9232 -69.5132 2020-07-04 04:33:51 Tarapaca, Chile
252532 2020-07-03 Chile Valparaiso     12465 266 10134 2065 -33.0472 -71.6127 2020-07-04 04:33:51 Valparaiso, Chile
252738 2020-07-03 Chile Unknown     0 0 109 -109     2020-07-03 15:33:50 Unknown, Chile
203464 2020-07-02 Chile Antofagasta     9285 163 7375 1747 -23.6509 -70.3975 2020-07-03 04:33:54 Antofagasta, Chile
203469 2020-07-02 Chile Araucania     3267 41 2983 243 -38.9489 -72.3311 2020-07-03 04:33:54 Araucania, Chile
203471 2020-07-02 Chile Arica y Parinacota     1832 21 1408 403 -18.594 -69.4785 2020-07-03 04:33:54 Arica y Parinacota, Chile
203478 2020-07-02 Chile Atacama     1135 2 790 343 -27.5661 -70.0503 2020-07-03 04:33:54 Atacama, Chile
203482 2020-07-02 Chile Aysen     46 0 29 17 -45.9864 -73.7669 2020-07-03 04:33:54 Aysen, Chile
203498 2020-07-02 Chile Biobio     6951 58 5196 1697 -37.4464 -72.1416 2020-07-03 04:33:54 Biobio, Chile
203547 2020-07-02 Chile Coquimbo     3170 24 2507 639 -29.959 -71.3389 2020-07-03 04:33:54 Coquimbo, Chile
203687 2020-07-02 Chile Los Lagos     1734 21 1415 298 -41.9198 -72.1416 2020-07-03 04:33:54 Los Lagos, Chile
203688 2020-07-02 Chile Los Rios     708 10 614 84 -40.231 -72.3311 2020-07-03 04:33:54 Los Rios, Chile
203696 2020-07-02 Chile Magallanes     1465 15 1326 124 -52.368 -70.9863 2020-07-03 04:33:54 Magallanes, Chile
203707 2020-07-02 Chile Maule     5820 53 4504 1263 -35.5183 -71.6885 2020-07-03 04:33:54 Maule, Chile
203713 2020-07-02 Chile Metropolitana     221820 5055 199125 17640 -33.4376 -70.6505 2020-07-03 04:33:54 Metropolitana, Chile
203758 2020-07-02 Chile Nuble     2447 33 2136 278 -36.7226 -71.7622 2020-07-03 04:33:54 Nuble, Chile
203760 2020-07-02 Chile OHiggins     6445 77 4447 1921 -34.5755 -71.0022 2020-07-03 04:33:54 OHiggins, Chile
203872 2020-07-02 Chile Tarapaca     6215 95 5380 740 -19.9232 -69.5132 2020-07-03 04:33:54 Tarapaca, Chile
203901 2020-07-02 Chile Unknown     0 0 109 -109     2020-07-03 04:33:54 Unknown, Chile
203914 2020-07-02 Chile Valparaiso     12201 252 9903 2046 -33.0472 -71.6127 2020-07-03 04:33:54 Valparaiso, Chile
159705 2020-07-01 Chile Antofagasta     9083 147 7176 1760 -23.6509 -70.3975 2020-07-02 04:33:46 Antofagasta, Chile
159710 2020-07-01 Chile Araucania     3246 41 2955 250 -38.9489 -72.3311 2020-07-02 04:33:46 Araucania, Chile
159712 2020-07-01 Chile Arica y Parinacota     1776 20 1377 379 -18.594 -69.4785 2020-07-02 04:33:46 Arica y Parinacota, Chile
159719 2020-07-01 Chile Atacama     1114 2 768 344 -27.5661 -70.0503 2020-07-02 04:33:46 Atacama, Chile
159723 2020-07-01 Chile Aysen     42 0 28 14 -45.9864 -73.7669 2020-07-02 04:33:46 Aysen, Chile
159739 2020-07-01 Chile Biobio     6845 50 4976 1819 -37.4464 -72.1416 2020-07-02 04:33:46 Biobio, Chile
159788 2020-07-01 Chile Coquimbo     3119 23 2441 655 -29.959 -71.3389 2020-07-02 04:33:46 Coquimbo, Chile
159928 2020-07-01 Chile Los Lagos     1684 21 1373 290 -41.9198 -72.1416 2020-07-02 04:33:46 Los Lagos, Chile
159929 2020-07-01 Chile Los Rios     706 10 606 90 -40.231 -72.3311 2020-07-02 04:33:46 Los Rios, Chile
159937 2020-07-01 Chile Magallanes     1461 15 1307 139 -52.368 -70.9863 2020-07-02 04:33:46 Magallanes, Chile
159948 2020-07-01 Chile Maule     5717 48 4362 1307 -35.5183 -71.6885 2020-07-02 04:33:46 Maule, Chile
159954 2020-07-01 Chile Metropolitana     220467 4954 196729 18784 -33.4376 -70.6505 2020-07-02 04:33:46 Metropolitana, Chile
159999 2020-07-01 Chile Nuble     2414 32 2078 304 -36.7226 -71.7622 2020-07-02 04:33:46 Nuble, Chile
160001 2020-07-01 Chile OHiggins     6245 69 4197 1979 -34.5755 -71.0022 2020-07-02 04:33:46 OHiggins, Chile
160113 2020-07-01 Chile Tarapaca     6116 91 5285 740 -19.9232 -69.5132 2020-07-02 04:33:46 Tarapaca, Chile
160142 2020-07-01 Chile Unknown     0 0 108 -108     2020-07-02 04:33:46 Unknown, Chile
160155 2020-07-01 Chile Valparaiso     12008 230 9677 2101 -33.0472 -71.6127 2020-07-02 04:33:46 Valparaiso, Chile
325700 2020-06-30 Chile Antofagasta     8829 147 6907 1775 -23.6509 -70.3975 2020-07-01 04:33:52 Antofagasta, Chile
325705 2020-06-30 Chile Araucania     3231 41 2922 268 -38.9489 -72.3311 2020-07-01 04:33:52 Araucania, Chile
325707 2020-06-30 Chile Arica y Parinacota     1713 20 1340 353 -18.594 -69.4785 2020-07-01 04:33:52 Arica y Parinacota, Chile
325714 2020-06-30 Chile Atacama     1043 2 732 309 -27.5661 -70.0503 2020-07-01 04:33:52 Atacama, Chile
325718 2020-06-30 Chile Aysen     42 0 29 13 -45.9864 -73.7669 2020-07-01 04:33:52 Aysen, Chile
325734 2020-06-30 Chile Biobio     6697 50 4760 1887 -37.4464 -72.1416 2020-07-01 04:33:52 Biobio, Chile
325783 2020-06-30 Chile Coquimbo     3050 23 2343 684 -29.959 -71.3389 2020-07-01 04:33:52 Coquimbo, Chile
325923 2020-06-30 Chile Los Lagos     1656 21 1338 297 -41.9198 -72.1416 2020-07-01 04:33:52 Los Lagos, Chile
325924 2020-06-30 Chile Los Rios     701 10 594 97 -40.231 -72.3311 2020-07-01 04:33:52 Los Rios, Chile
325932 2020-06-30 Chile Magallanes     1452 15 1294 143 -52.368 -70.9863 2020-07-01 04:33:52 Magallanes, Chile
325943 2020-06-30 Chile Maule     5549 48 4182 1319 -35.5183 -71.6885 2020-07-01 04:33:52 Maule, Chile
325949 2020-06-30 Chile Metropolitana     219151 4889 194094 20168 -33.4376 -70.6505 2020-07-01 04:33:52 Metropolitana, Chile
325994 2020-06-30 Chile Nuble     2397 32 2021 344 -36.7226 -71.7622 2020-07-01 04:33:52 Nuble, Chile
325996 2020-06-30 Chile OHiggins     6081 69 3973 2039 -34.5755 -71.0022 2020-07-01 04:33:52 OHiggins, Chile
326108 2020-06-30 Chile Tarapaca     6049 91 5193 765 -19.9232 -69.5132 2020-07-01 04:33:52 Tarapaca, Chile
326137 2020-06-30 Chile Unknown     0 0 98 -98     2020-07-01 04:33:52 Unknown, Chile
326150 2020-06-30 Chile Valparaiso     11752 230 9409 2113 -33.0472 -71.6127 2020-07-01 04:33:52 Valparaiso, Chile
49504 2020-06-29 Chile Antofagasta     8625 147 6616 1862 -23.6509 -70.3975 2020-06-30 04:33:48 Antofagasta, Chile
49509 2020-06-29 Chile Araucania     3212 41 2880 291 -38.9489 -72.3311 2020-06-30 04:33:48 Araucania, Chile
49511 2020-06-29 Chile Arica y Parinacota     1685 20 1299 366 -18.594 -69.4785 2020-06-30 04:33:48 Arica y Parinacota, Chile
49518 2020-06-29 Chile Atacama     1006 2 689 315 -27.5661 -70.0503 2020-06-30 04:33:48 Atacama, Chile
49522 2020-06-29 Chile Aysen     42 0 28 14 -45.9864 -73.7669 2020-06-30 04:33:48 Aysen, Chile
49538 2020-06-29 Chile Biobio     6595 50 4523 2022 -37.4464 -72.1416 2020-06-30 04:33:48 Biobio, Chile
49587 2020-06-29 Chile Coquimbo     2961 23 2263 675 -29.959 -71.3389 2020-06-30 04:33:48 Coquimbo, Chile
49727 2020-06-29 Chile Los Lagos     1642 21 1311 310 -41.9198 -72.1416 2020-06-30 04:33:48 Los Lagos, Chile
49728 2020-06-29 Chile Los Rios     689 10 585 94 -40.231 -72.3311 2020-06-30 04:33:48 Los Rios, Chile
49736 2020-06-29 Chile Magallanes     1440 15 1290 135 -52.368 -70.9863 2020-06-30 04:33:48 Magallanes, Chile
49747 2020-06-29 Chile Maule     5463 48 4005 1410 -35.5183 -71.6885 2020-06-30 04:33:48 Maule, Chile
49753 2020-06-29 Chile Metropolitana     216896 4777 190688 21431 -33.4376 -70.6505 2020-06-30 04:33:48 Metropolitana, Chile
49798 2020-06-29 Chile Nuble     2384 32 1970 382 -36.7226 -71.7622 2020-06-30 04:33:48 Nuble, Chile
49803 2020-06-29 Chile OHiggins     5844 69 3716 2059 -34.5755 -71.0022 2020-06-30 04:33:48 OHiggins, Chile
49912 2020-06-29 Chile Tarapaca     5974 91 5068 815 -19.9232 -69.5132 2020-06-30 04:33:48 Tarapaca, Chile

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2536.672ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette