johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Chile" and province_or_state = "Los Lagos" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2632925 | 2632925 | 2020-06-29 | Chile | Los Lagos | 1642 | 21 | 1311 | 310 | -41.9198 | -72.1416 | 2020-06-30 04:33:48 | Los Lagos, Chile | ||
2306488 | 2306488 | 2020-06-28 | Chile | Los Lagos | 1609 | 21 | 0 | 1588 | -41.9198 | -72.1416 | 2020-06-29 04:33:44 | Los Lagos, Chile | ||
2039823 | 2039823 | 2020-06-27 | Chile | Los Lagos | 1573 | 20 | 0 | 1553 | -41.9198 | -72.1416 | 2020-06-28 04:34:04 | Los Lagos, Chile | ||
1136104 | 1136104 | 2020-06-26 | Chile | Los Lagos | 1541 | 20 | 0 | 1521 | -41.9198 | -72.1416 | 2020-06-27 04:33:35 | Los Lagos, Chile | ||
2625091 | 2625091 | 2020-06-25 | Chile | Los Lagos | 1505 | 19 | 0 | 1486 | -41.9198 | -72.1416 | 2020-06-26 04:33:43 | Los Lagos, Chile | ||
2700731 | 2700731 | 2020-06-24 | Chile | Los Lagos | 1483 | 18 | 0 | 1465 | -41.9198 | -72.1416 | 2020-06-25 05:26:54 | Los Lagos, Chile | ||
1522416 | 1522416 | 2020-06-23 | Chile | Los Lagos | 1466 | 17 | 0 | 1449 | -41.9198 | -72.1416 | 2020-06-24 04:33:28 | Los Lagos, Chile | ||
1510610 | 1510610 | 2020-06-22 | Chile | Los Lagos | 1437 | 17 | 0 | 1420 | -41.9198 | -72.1416 | 2020-06-23 04:33:22 | Los Lagos, Chile | ||
3249349 | 3249349 | 2020-06-21 | Chile | Los Lagos | 1385 | 17 | 0 | 1368 | -41.9198 | -72.1416 | 2020-06-22 04:33:20 | Los Lagos, Chile | ||
2437942 | 2437942 | 2020-06-20 | Chile | Los Lagos | 1335 | 15 | 0 | 1320 | -41.9198 | -72.1416 | 2020-06-21 04:33:19 | Los Lagos, Chile | ||
1691520 | 1691520 | 2020-06-19 | Chile | Los Lagos | 1298 | 14 | 0 | 1284 | -41.9198 | -72.1416 | 2020-06-20 04:33:19 | Los Lagos, Chile | ||
3682669 | 3682669 | 2020-06-18 | Chile | Los Lagos | 1263 | 14 | 0 | 1249 | -41.9198 | -72.1416 | 2020-06-19 04:33:17 | Los Lagos, Chile | ||
1195872 | 1195872 | 2020-06-17 | Chile | Los Lagos | 1249 | 14 | 0 | 1235 | -41.9198 | -72.1416 | 2020-06-18 04:33:18 | Los Lagos, Chile | ||
2386635 | 2386635 | 2020-06-16 | Chile | Los Lagos | 1178 | 13 | 0 | 1165 | -41.9198 | -72.1416 | 2020-06-17 04:33:21 | Los Lagos, Chile | ||
287198 | 287198 | 2020-06-15 | Chile | Los Lagos | 1168 | 13 | 0 | 1155 | -41.9198 | -72.1416 | 2020-06-16 04:33:09 | Los Lagos, Chile | ||
1837149 | 1837149 | 2020-06-14 | Chile | Los Lagos | 1141 | 13 | 0 | 1128 | -41.9198 | -72.1416 | 2020-06-15 03:33:14 | Los Lagos, Chile | ||
3061201 | 3061201 | 2020-06-13 | Chile | Los Lagos | 1108 | 13 | 0 | 1095 | -41.9198 | -72.1416 | 2020-06-14 03:33:15 | Los Lagos, Chile | ||
737521 | 737521 | 2020-06-12 | Chile | Los Lagos | 1083 | 12 | 0 | 1071 | -41.9198 | -72.1416 | 2020-06-13 03:33:14 | Los Lagos, Chile | ||
1273491 | 1273491 | 2020-06-11 | Chile | Los Lagos | 1062 | 12 | 0 | 1050 | -41.9198 | -72.1416 | 2020-06-12 05:09:52 | Los Lagos, Chile | ||
2863934 | 2863934 | 2020-06-10 | Chile | Los Lagos | 1041 | 12 | 0 | 1029 | -41.9198 | -72.1416 | 2020-06-11 03:33:41 | Los Lagos, Chile | ||
1210771 | 1210771 | 2020-06-09 | Chile | Los Lagos | 1028 | 12 | 0 | 1016 | -41.9198 | -72.1416 | 2020-06-10 04:07:00 | Los Lagos, Chile | ||
217198 | 217198 | 2020-06-08 | Chile | Los Lagos | 1010 | 12 | 0 | 998 | -41.9198 | -72.1416 | 2020-06-09 03:33:03 | Los Lagos, Chile | ||
2799994 | 2799994 | 2020-06-07 | Chile | Los Lagos | 1003 | 13 | 0 | 990 | -41.9198 | -72.1416 | 2020-06-08 03:33:22 | Los Lagos, Chile | ||
574050 | 574050 | 2020-06-06 | Chile | Los Lagos | 985 | 13 | 0 | 972 | -41.9198 | -72.1416 | 2020-06-07 03:53:30 | Los Lagos, Chile | ||
1269747 | 1269747 | 2020-06-05 | Chile | Los Lagos | 968 | 13 | 0 | 955 | -41.9198 | -72.1416 | 2020-06-06 02:33:00 | Los Lagos, Chile | ||
1281219 | 1281219 | 2020-06-04 | Chile | Los Lagos | 926 | 13 | 0 | 913 | -41.9198 | -72.1416 | 2020-06-05 02:33:06 | Los Lagos, Chile | ||
3866774 | 3866774 | 2020-06-03 | Chile | Los Lagos | 913 | 0 | 0 | 913 | -41.9198 | -72.1416 | 2020-06-04 02:33:14 | Los Lagos, Chile | ||
2555816 | 2555816 | 2020-06-02 | Chile | Los Lagos | 894 | 0 | 0 | 894 | -41.9198 | -72.1416 | 2020-06-03 02:33:13 | Los Lagos, Chile | ||
805353 | 805353 | 2020-06-01 | Chile | Los Lagos | 863 | 13 | 0 | 850 | -41.9198 | -72.1416 | 2020-06-02 02:33:08 | Los Lagos, Chile | ||
1793946 | 1793946 | 2020-05-31 | Chile | Los Lagos | 863 | 13 | 0 | 850 | -41.9198 | -72.1416 | 2020-06-01 02:32:46 | Los Lagos, Chile | ||
3638839 | 3638839 | 2020-05-30 | Chile | Los Lagos | 860 | 13 | 0 | 847 | -41.9198 | -72.1416 | 2020-05-31 02:32:45 | Los Lagos, Chile | ||
1790380 | 1790380 | 2020-05-29 | Chile | Los Lagos | 822 | 13 | 0 | 809 | -41.9198 | -72.1416 | 2020-05-30 02:32:48 | Los Lagos, Chile | ||
2712259 | 2712259 | 2020-05-28 | Chile | Los Lagos | 814 | 13 | 0 | 801 | -41.9198 | -72.1416 | 2020-05-29 02:32:50 | Los Lagos, Chile | ||
2548225 | 2548225 | 2020-05-27 | Chile | Los Lagos | 791 | 13 | 0 | 778 | -41.9198 | -72.1416 | 2020-05-28 02:32:31 | Los Lagos, Chile | ||
1041188 | 1041188 | 2020-05-26 | Chile | Los Lagos | 781 | 13 | 0 | 768 | -41.9198 | -72.1416 | 2020-05-27 02:32:31 | Los Lagos, Chile | ||
1104918 | 1104918 | 2020-05-25 | Chile | Los Lagos | 763 | 13 | 0 | 750 | -41.9198 | -72.1416 | 2020-05-26 02:32:35 | Los Lagos, Chile | ||
875598 | 875598 | 2020-05-24 | Chile | Los Lagos | 736 | 13 | 0 | 723 | -41.9198 | -72.1416 | 2020-05-25 02:32:44 | Los Lagos, Chile | ||
997789 | 997789 | 2020-05-23 | Chile | Los Lagos | 727 | 13 | 0 | 714 | -41.9198 | -72.1416 | 2020-05-24 02:32:43 | Los Lagos, Chile | ||
1864812 | 1864812 | 2020-05-22 | Chile | Los Lagos | 717 | 13 | 0 | 704 | -41.9198 | -72.1416 | 2020-05-23 02:32:42 | Los Lagos, Chile | ||
268318 | 268318 | 2020-05-21 | Chile | Los Lagos | 693 | 13 | 0 | 680 | -41.9198 | -72.1416 | 2020-05-22 02:36:51 | Los Lagos, Chile | ||
1431901 | 1431901 | 2020-05-20 | Chile | Los Lagos | 666 | 12 | 0 | 654 | -41.9198 | -72.1416 | 2020-05-21 02:32:48 | Los Lagos, Chile |
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]);