johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where combined_key = "Spain" and longitude = "-3.7492199999999998" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date), last_update (date)
country_or_region 1
- Spain 29
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137578 | 137578 | 2020-04-29 | Spain | 236899 | 24275 | 132929 | 79695 | 40.463667 | -3.7492199999999998 | 2020-04-30 02:32:27 | Spain | |||
271792 | 271792 | 2020-04-28 | Spain | 232128 | 23822 | 123903 | 84403 | 40.463667 | -3.7492199999999998 | 2020-04-29 02:32:29 | Spain | |||
3589447 | 3589447 | 2020-04-27 | Spain | 229422 | 23521 | 120832 | 85069 | 40.463667 | -3.7492199999999998 | 2020-04-28 02:30:32 | Spain | |||
3592625 | 3592625 | 2020-04-26 | Spain | 226629 | 23190 | 117727 | 85712 | 40.463667 | -3.7492199999999998 | 2020-04-27 02:30:33 | Spain | |||
3502974 | 3502974 | 2020-04-25 | Spain | 223759 | 22902 | 95708 | 105149 | 40.463667 | -3.7492199999999998 | 2020-04-26 02:30:31 | Spain | |||
1459375 | 1459375 | 2020-04-24 | Spain | 219764 | 22524 | 92355 | 104885 | 40.463667 | -3.7492199999999998 | 2020-04-25 06:30:33 | Spain | |||
2524964 | 2524964 | 2020-04-23 | Spain | 213024 | 22157 | 89250 | 101617 | 40.463667 | -3.7492199999999998 | 2020-04-24 03:30:31 | Spain | |||
1199414 | 1199414 | 2020-04-22 | Spain | 208389 | 21717 | 85915 | 100757 | 40.463667 | -3.7492199999999998 | 2020-04-22 23:30:32 | Spain | |||
522480 | 522480 | 2020-04-21 | Spain | 204178 | 21282 | 82514 | 100382 | 40.463667 | -3.7492199999999998 | 2020-04-21 23:30:30 | Spain | |||
2473562 | 2473562 | 2020-04-20 | Spain | 200210 | 20852 | 80587 | 98771 | 40.463667 | -3.7492199999999998 | 2020-04-20 23:36:27 | Spain | |||
50414 | 50414 | 2020-04-17 | Spain | 190839 | 20002 | 74797 | 96040 | 40.463667 | -3.7492199999999998 | 2020-04-17 23:30:32 | Spain | |||
934408 | 934408 | 2020-04-16 | Spain | 184948 | 19315 | 74797 | 90836 | 40.463667 | -3.7492199999999998 | 2020-04-16 23:30:31 | Spain | |||
860302 | 860302 | 2020-04-15 | Spain | 177644 | 18708 | 70853 | 88083 | 40.463667 | -3.7492199999999998 | 2020-04-15 22:56:32 | Spain | |||
3338218 | 3338218 | 2020-04-14 | Spain | 172541 | 18056 | 67504 | 86981 | 40.463667 | -3.7492199999999998 | 2020-04-14 23:33:12 | Spain | |||
43315 | 43315 | 2020-04-13 | Spain | 170099 | 17756 | 64727 | 87616 | 40.463667 | -3.7492199999999998 | 2020-04-13 23:07:34 | Spain | |||
2567178 | 2567178 | 2020-04-11 | Spain | 163027 | 16606 | 59109 | 87312 | 40.463667 | -3.7492199999999998 | 2020-04-11 22:45:13 | Spain | |||
1250363 | 1250363 | 2020-04-10 | Spain | 158273 | 16081 | 55668 | 86524 | 40.463667 | -3.7492199999999998 | 2020-04-10 22:53:48 | Spain | |||
3950100 | 3950100 | 2020-04-09 | Spain | 153222 | 15447 | 52165 | 85610 | 40.463667 | -3.7492199999999998 | 2020-04-09 23:02:19 | Spain | |||
3562207 | 3562207 | 2020-04-08 | Spain | 148220 | 14792 | 48021 | 85407 | 40.463667 | -3.7492199999999998 | 2020-04-08 22:51:39 | Spain | |||
3021882 | 3021882 | 2020-04-07 | Spain | 141942 | 14045 | 43208 | 84689 | 40.463667 | -3.7492199999999998 | 2020-04-07 23:04:29 | Spain | |||
589251 | 589251 | 2020-04-05 | Spain | 131646 | 12641 | 38080 | 80925 | 40.463667 | -3.7492199999999998 | 2020-04-05 23:06:26 | Spain | |||
3740704 | 3740704 | 2020-04-03 | Spain | 119199 | 11198 | 30513 | 77488 | 40.463667 | -3.7492199999999998 | 2020-04-03 22:46:20 | Spain | |||
3364937 | 3364937 | 2020-04-01 | Spain | 104118 | 9387 | 22647 | 72084 | 40.463667 | -3.7492199999999998 | 2020-04-01 21:58:34 | Spain | |||
3816030 | 3816030 | 2020-03-31 | Spain | 95923 | 8464 | 19259 | 68200 | 40.463667 | -3.7492199999999998 | 2020-03-31 23:43:43 | Spain | |||
809200 | 809200 | 2020-03-27 | Spain | 65719 | 5138 | 9357 | 51224 | 40.463667 | -3.7492199999999998 | 2020-03-27 23:23:03 | Spain | |||
919292 | 919292 | 2020-03-26 | Spain | 57786 | 4365 | 7015 | 46406 | 40.463667 | -3.7492199999999998 | 2020-03-26 23:48:18 | Spain | |||
1132692 | 1132692 | 2020-03-25 | Spain | 49515 | 3647 | 5367 | 40501 | 40.463667 | -3.7492199999999998 | 2020-03-25 23:33:04 | Spain | |||
1479196 | 1479196 | 2020-03-24 | Spain | 39885 | 2808 | 3794 | 33283 | 40.463667 | -3.7492199999999998 | 2020-03-24 23:37:15 | Spain | |||
2147250 | 2147250 | 2020-03-23 | Spain | 35136 | 2311 | 3355 | 29470 | 40.463667 | -3.7492199999999998 | 2020-03-23 23:19:21 | Spain |
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]);