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 = "Valparaiso" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2633154 | 2633154 | 2020-06-29 | Chile | Valparaiso | 11541 | 229 | 9085 | 2227 | -33.0472 | -71.6127 | 2020-06-30 04:33:48 | Valparaiso, Chile | ||
2306717 | 2306717 | 2020-06-28 | Chile | Valparaiso | 11307 | 229 | 0 | 11078 | -33.0472 | -71.6127 | 2020-06-29 04:33:44 | Valparaiso, Chile | ||
2040052 | 2040052 | 2020-06-27 | Chile | Valparaiso | 11054 | 217 | 0 | 10837 | -33.0472 | -71.6127 | 2020-06-28 04:34:04 | Valparaiso, Chile | ||
1136333 | 1136333 | 2020-06-26 | Chile | Valparaiso | 10797 | 204 | 0 | 10593 | -33.0472 | -71.6127 | 2020-06-27 04:33:35 | Valparaiso, Chile | ||
2625320 | 2625320 | 2020-06-25 | Chile | Valparaiso | 10482 | 195 | 0 | 10287 | -33.0472 | -71.6127 | 2020-06-26 04:33:43 | Valparaiso, Chile | ||
2700960 | 2700960 | 2020-06-24 | Chile | Valparaiso | 10187 | 187 | 0 | 10000 | -33.0472 | -71.6127 | 2020-06-25 05:26:54 | Valparaiso, Chile | ||
1522645 | 1522645 | 2020-06-23 | Chile | Valparaiso | 9901 | 170 | 0 | 9731 | -33.0472 | -71.6127 | 2020-06-24 04:33:28 | Valparaiso, Chile | ||
1510839 | 1510839 | 2020-06-22 | Chile | Valparaiso | 9615 | 170 | 0 | 9445 | -33.0472 | -71.6127 | 2020-06-23 04:33:22 | Valparaiso, Chile | ||
3249578 | 3249578 | 2020-06-21 | Chile | Valparaiso | 9298 | 170 | 0 | 9128 | -33.0472 | -71.6127 | 2020-06-22 04:33:20 | Valparaiso, Chile | ||
2438171 | 2438171 | 2020-06-20 | Chile | Valparaiso | 9014 | 158 | 0 | 8856 | -33.0472 | -71.6127 | 2020-06-21 04:33:19 | Valparaiso, Chile | ||
1691749 | 1691749 | 2020-06-19 | Chile | Valparaiso | 8758 | 150 | 0 | 8608 | -33.0472 | -71.6127 | 2020-06-20 04:33:19 | Valparaiso, Chile | ||
3682898 | 3682898 | 2020-06-18 | Chile | Valparaiso | 8473 | 143 | 0 | 8330 | -33.0472 | -71.6127 | 2020-06-19 04:33:17 | Valparaiso, Chile | ||
1196101 | 1196101 | 2020-06-17 | Chile | Valparaiso | 8253 | 141 | 0 | 8112 | -33.0472 | -71.6127 | 2020-06-18 04:33:18 | Valparaiso, Chile | ||
2386864 | 2386864 | 2020-06-16 | Chile | Valparaiso | 7262 | 126 | 0 | 7136 | -33.0472 | -71.6127 | 2020-06-17 04:33:21 | Valparaiso, Chile | ||
287427 | 287427 | 2020-06-15 | Chile | Valparaiso | 7012 | 126 | 0 | 6886 | -33.0472 | -71.6127 | 2020-06-16 04:33:09 | Valparaiso, Chile | ||
1837378 | 1837378 | 2020-06-14 | Chile | Valparaiso | 6758 | 125 | 0 | 6633 | -33.0472 | -71.6127 | 2020-06-15 03:33:14 | Valparaiso, Chile | ||
3061430 | 3061430 | 2020-06-13 | Chile | Valparaiso | 6527 | 120 | 0 | 6407 | -33.0472 | -71.6127 | 2020-06-14 03:33:15 | Valparaiso, Chile | ||
737750 | 737750 | 2020-06-12 | Chile | Valparaiso | 6171 | 118 | 0 | 6053 | -33.0472 | -71.6127 | 2020-06-13 03:33:14 | Valparaiso, Chile | ||
1273720 | 1273720 | 2020-06-11 | Chile | Valparaiso | 5865 | 107 | 0 | 5758 | -33.0472 | -71.6127 | 2020-06-12 05:09:52 | Valparaiso, Chile | ||
2864160 | 2864160 | 2020-06-10 | Chile | Valparaiso | 5614 | 99 | 0 | 5515 | -33.0472 | -71.6127 | 2020-06-11 03:33:41 | Valparaiso, Chile | ||
1210978 | 1210978 | 2020-06-09 | Chile | Valparaiso | 5391 | 85 | 0 | 5306 | -33.0472 | -71.6127 | 2020-06-10 04:07:00 | Valparaiso, Chile | ||
217405 | 217405 | 2020-06-08 | Chile | Valparaiso | 5149 | 85 | 0 | 5064 | -33.0472 | -71.6127 | 2020-06-09 03:33:03 | Valparaiso, Chile | ||
2800202 | 2800202 | 2020-06-07 | Chile | Valparaiso | 4862 | 93 | 0 | 4769 | -33.0472 | -71.6127 | 2020-06-08 03:33:22 | Valparaiso, Chile | ||
574258 | 574258 | 2020-06-06 | Chile | Valparaiso | 4580 | 91 | 0 | 4489 | -33.0472 | -71.6127 | 2020-06-07 03:53:30 | Valparaiso, Chile | ||
1269955 | 1269955 | 2020-06-05 | Chile | Valparaiso | 4266 | 88 | 0 | 4178 | -33.0472 | -71.6127 | 2020-06-06 02:33:00 | Valparaiso, Chile | ||
1281420 | 1281420 | 2020-06-04 | Chile | Valparaiso | 4017 | 78 | 0 | 3939 | -33.0472 | -71.6127 | 2020-06-05 02:33:06 | Valparaiso, Chile | ||
3866975 | 3866975 | 2020-06-03 | Chile | Valparaiso | 3769 | 0 | 0 | 3769 | -33.0472 | -71.6127 | 2020-06-04 02:33:14 | Valparaiso, Chile | ||
2556017 | 2556017 | 2020-06-02 | Chile | Valparaiso | 3595 | 0 | 0 | 3595 | -33.0472 | -71.6127 | 2020-06-03 02:33:13 | Valparaiso, Chile | ||
805554 | 805554 | 2020-06-01 | Chile | Valparaiso | 3348 | 70 | 0 | 3278 | -33.0472 | -71.6127 | 2020-06-02 02:33:08 | Valparaiso, Chile | ||
1794100 | 1794100 | 2020-05-31 | Chile | Valparaiso | 3167 | 66 | 0 | 3101 | -33.0472 | -71.6127 | 2020-06-01 02:32:46 | Valparaiso, Chile | ||
3638993 | 3638993 | 2020-05-30 | Chile | Valparaiso | 3037 | 63 | 0 | 2974 | -33.0472 | -71.6127 | 2020-05-31 02:32:45 | Valparaiso, Chile | ||
1790534 | 1790534 | 2020-05-29 | Chile | Valparaiso | 2842 | 61 | 0 | 2781 | -33.0472 | -71.6127 | 2020-05-30 02:32:48 | Valparaiso, Chile | ||
2712413 | 2712413 | 2020-05-28 | Chile | Valparaiso | 2730 | 60 | 0 | 2670 | -33.0472 | -71.6127 | 2020-05-29 02:32:50 | Valparaiso, Chile | ||
2548334 | 2548334 | 2020-05-27 | Chile | Valparaiso | 2576 | 58 | 0 | 2518 | -33.0472 | -71.6127 | 2020-05-28 02:32:31 | Valparaiso, Chile | ||
1041297 | 1041297 | 2020-05-26 | Chile | Valparaiso | 2455 | 57 | 0 | 2398 | -33.0472 | -71.6127 | 2020-05-27 02:32:31 | Valparaiso, Chile | ||
1105027 | 1105027 | 2020-05-25 | Chile | Valparaiso | 2305 | 53 | 0 | 2252 | -33.0472 | -71.6127 | 2020-05-26 02:32:35 | Valparaiso, Chile | ||
875707 | 875707 | 2020-05-24 | Chile | Valparaiso | 2230 | 48 | 0 | 2182 | -33.0472 | -71.6127 | 2020-05-25 02:32:44 | Valparaiso, Chile | ||
997898 | 997898 | 2020-05-23 | Chile | Valparaiso | 2116 | 44 | 0 | 2072 | -33.0472 | -71.6127 | 2020-05-24 02:32:43 | Valparaiso, Chile | ||
1864921 | 1864921 | 2020-05-22 | Chile | Valparaiso | 2020 | 40 | 0 | 1980 | -33.0472 | -71.6127 | 2020-05-23 02:32:42 | Valparaiso, Chile | ||
268427 | 268427 | 2020-05-21 | Chile | Valparaiso | 1887 | 38 | 0 | 1849 | -33.0472 | -71.6127 | 2020-05-22 02:36:51 | Valparaiso, Chile | ||
1432010 | 1432010 | 2020-05-20 | Chile | Valparaiso | 1770 | 35 | 0 | 1735 | -33.0472 | -71.6127 | 2020-05-21 02:32:48 | Valparaiso, 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]);