johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
85 rows where country_or_region = "Spain" and deaths = 148 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, latitude, last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2331678 | 2331678 | 2022-05-08 | Spain | Ceuta | 21001 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-09 04:20:54 | Ceuta, Spain | |||
360640 | 360640 | 2022-05-07 | Spain | Ceuta | 21001 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-08 04:20:49 | Ceuta, Spain | |||
1397991 | 1397991 | 2022-05-06 | Spain | Ceuta | 21001 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-07 04:21:09 | Ceuta, Spain | |||
2598346 | 2598346 | 2022-05-05 | Spain | Ceuta | 20776 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-06 04:21:00 | Ceuta, Spain | |||
3265795 | 3265795 | 2022-05-04 | Spain | Ceuta | 20776 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-05 04:20:55 | Ceuta, Spain | |||
1572434 | 1572434 | 2022-05-03 | Spain | Ceuta | 20776 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-04 04:20:59 | Ceuta, Spain | |||
463694 | 463694 | 2022-05-02 | Spain | Ceuta | 20595 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-03 04:21:00 | Ceuta, Spain | |||
3916333 | 3916333 | 2022-05-01 | Spain | Ceuta | 20595 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-02 04:21:10 | Ceuta, Spain | |||
2841137 | 2841137 | 2022-04-30 | Spain | Ceuta | 20595 | 148 | 0 | 35.8894 | -5.3213 | 2022-05-01 04:20:57 | Ceuta, Spain | |||
1157450 | 1157450 | 2022-04-29 | Spain | Ceuta | 20595 | 148 | 0 | 35.8894 | -5.3213 | 2022-04-30 04:21:05 | Ceuta, Spain | |||
1696632 | 1696632 | 2022-04-28 | Spain | Ceuta | 20413 | 148 | 0 | 35.8894 | -5.3213 | 2022-04-29 04:20:59 | Ceuta, Spain | |||
3852115 | 3852115 | 2022-04-27 | Spain | Ceuta | 20413 | 148 | 0 | 35.8894 | -5.3213 | 2022-04-28 04:20:47 | Ceuta, Spain | |||
1326545 | 1326545 | 2022-04-26 | Spain | Ceuta | 20413 | 148 | 0 | 35.8894 | -5.3213 | 2022-04-27 04:20:52 | Ceuta, Spain | |||
3722499 | 3722499 | 2022-04-25 | Spain | Ceuta | 20298 | 148 | 0 | 35.8894 | -5.3213 | 2022-04-26 04:20:51 | Ceuta, Spain | |||
2029067 | 2029067 | 2022-04-24 | Spain | Ceuta | 20298 | 148 | 0 | 35.8894 | -5.3213 | 2022-04-25 04:20:56 | Ceuta, Spain | |||
746642 | 746642 | 2022-04-23 | Spain | Ceuta | 20298 | 148 | 0 | 35.8894 | -5.3213 | 2022-04-24 04:20:56 | Ceuta, Spain | |||
3437127 | 3437127 | 2022-04-22 | Spain | Ceuta | 20298 | 148 | 0 | 35.8894 | -5.3213 | 2022-04-23 04:20:50 | Ceuta, Spain | |||
2525668 | 2525668 | 2022-03-02 | Spain | Melilla | 20257 | 148 | 0 | 35.2923 | -2.9381 | 2022-03-03 04:21:01 | Melilla, Spain | |||
1992962 | 1992962 | 2022-03-01 | Spain | Melilla | 20234 | 148 | 0 | 35.2923 | -2.9381 | 2022-03-02 04:21:07 | Melilla, Spain | |||
662594 | 662594 | 2020-08-11 | Spain | Murcia | 3039 | 148 | 2180 | 711 | 37.9922 | -1.1307 | 2020-08-12 04:27:29 | Murcia, Spain | ||
1920452 | 1920452 | 2020-08-10 | Spain | Murcia | 2964 | 148 | 2180 | 636 | 37.9922 | -1.1307 | 2020-08-11 04:35:08 | Murcia, Spain | ||
3923261 | 3923261 | 2020-08-09 | Spain | Murcia | 2831 | 148 | 2180 | 503 | 37.9922 | -1.1307 | 2020-08-10 04:34:55 | Murcia, Spain | ||
371429 | 371429 | 2020-08-08 | Spain | Murcia | 2831 | 148 | 2180 | 503 | 37.9922 | -1.1307 | 2020-08-09 04:34:54 | Murcia, Spain | ||
458613 | 458613 | 2020-08-07 | Spain | Murcia | 2831 | 148 | 2180 | 503 | 37.9922 | -1.1307 | 2020-08-08 04:34:53 | Murcia, Spain | ||
3612298 | 3612298 | 2020-08-06 | Spain | Murcia | 2700 | 148 | 2180 | 372 | 37.9922 | -1.1307 | 2020-08-07 04:35:11 | Murcia, Spain | ||
3793128 | 3793128 | 2020-08-05 | Spain | Murcia | 2603 | 148 | 2180 | 275 | 37.9922 | -1.1307 | 2020-08-06 04:35:02 | Murcia, Spain | ||
98364 | 98364 | 2020-08-04 | Spain | Murcia | 2504 | 148 | 2180 | 176 | 37.9922 | -1.1307 | 2020-08-05 04:34:43 | Murcia, Spain | ||
2740247 | 2740247 | 2020-08-03 | Spain | Murcia | 2460 | 148 | 2180 | 132 | 37.9922 | -1.1307 | 2020-08-04 04:41:59 | Murcia, Spain | ||
2807999 | 2807999 | 2020-08-02 | Spain | Murcia | 2326 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-08-03 04:34:35 | Murcia, Spain | ||
753567 | 753567 | 2020-08-01 | Spain | Murcia | 2326 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-08-02 04:34:47 | Murcia, Spain | ||
3264732 | 3264732 | 2020-07-31 | Spain | Murcia | 2326 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-08-01 04:36:27 | Murcia, Spain | ||
1928439 | 1928439 | 2020-07-30 | Spain | Murcia | 2265 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-31 04:35:18 | Murcia, Spain | ||
2958607 | 2958607 | 2020-07-29 | Spain | Murcia | 2199 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-30 04:35:05 | Murcia, Spain | ||
3185223 | 3185223 | 2020-07-28 | Spain | Murcia | 2150 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-29 04:35:11 | Murcia, Spain | ||
177274 | 177274 | 2020-07-27 | Spain | Murcia | 2091 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-28 04:58:43 | Murcia, Spain | ||
442587 | 442587 | 2020-07-26 | Spain | Murcia | 1988 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-27 04:35:02 | Murcia, Spain | ||
1502831 | 1502831 | 2020-07-25 | Spain | Murcia | 1988 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-26 04:35:00 | Murcia, Spain | ||
2563801 | 2563801 | 2020-07-24 | Spain | Murcia | 1988 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-25 04:47:39 | Murcia, Spain | ||
62016 | 62016 | 2020-07-23 | Spain | Murcia | 1881 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-24 05:30:40 | Murcia, Spain | ||
844821 | 844821 | 2020-07-22 | Spain | Murcia | 1880 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-23 05:15:04 | Murcia, Spain | ||
1707560 | 1707560 | 2020-07-21 | Spain | Murcia | 1852 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-22 04:34:42 | Murcia, Spain | ||
327051 | 327051 | 2020-07-20 | Spain | Murcia | 1840 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-21 04:38:46 | Murcia, Spain | ||
121956 | 121956 | 2020-07-19 | Spain | Murcia | 1786 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-20 05:34:40 | Murcia, Spain | ||
3205345 | 3205345 | 2020-07-18 | Spain | Murcia | 1786 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-19 04:34:58 | Murcia, Spain | ||
2708646 | 2708646 | 2020-07-17 | Spain | Murcia | 1786 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-18 04:34:45 | Murcia, Spain | ||
367459 | 367459 | 2020-07-16 | Spain | Murcia | 1771 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-17 04:34:50 | Murcia, Spain | ||
2748127 | 2748127 | 2020-07-15 | Spain | Murcia | 1766 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-16 04:44:59 | Murcia, Spain | ||
2158771 | 2158771 | 2020-07-14 | Spain | Murcia | 1760 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-15 04:34:39 | Murcia, Spain | ||
3491412 | 3491412 | 2020-07-13 | Spain | Murcia | 1753 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-14 04:34:46 | Murcia, Spain | ||
3737675 | 3737675 | 2020-07-12 | Spain | Murcia | 1726 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-13 04:43:04 | Murcia, Spain | ||
3436070 | 3436070 | 2020-07-11 | Spain | Murcia | 1726 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-12 04:34:30 | Murcia, Spain | ||
3237568 | 3237568 | 2020-07-10 | Spain | Murcia | 1726 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-11 04:34:26 | Murcia, Spain | ||
1005553 | 1005553 | 2020-07-09 | Spain | Murcia | 1721 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-10 04:34:24 | Murcia, Spain | ||
2222769 | 2222769 | 2020-07-08 | Spain | Murcia | 1717 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-09 04:34:23 | Murcia, Spain | ||
887378 | 887378 | 2020-07-07 | Spain | Murcia | 1709 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-08 05:33:48 | Murcia, Spain | ||
2684938 | 2684938 | 2020-07-06 | Spain | Murcia | 1706 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-07 04:34:00 | Murcia, Spain | ||
415403 | 415403 | 2020-07-05 | Spain | Murcia | 1697 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-06 04:33:57 | Murcia, Spain | ||
529965 | 529965 | 2020-07-04 | Spain | Murcia | 1697 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-05 04:33:46 | Murcia, Spain | ||
2234626 | 2234626 | 2020-07-03 | Spain | Murcia | 1697 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-04 04:33:51 | Murcia, Spain | ||
3045420 | 3045420 | 2020-07-02 | Spain | Murcia | 1693 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-03 04:33:54 | Murcia, Spain | ||
3682710 | 3682710 | 2020-06-18 | Spain | Murcia | 1631 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-19 04:33:17 | Murcia, Spain | ||
1195913 | 1195913 | 2020-06-17 | Spain | Murcia | 1631 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-18 04:33:18 | Murcia, Spain | ||
2386676 | 2386676 | 2020-06-16 | Spain | Murcia | 1629 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-17 04:33:21 | Murcia, Spain | ||
287239 | 287239 | 2020-06-15 | Spain | Murcia | 1629 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-16 04:33:09 | Murcia, Spain | ||
1837190 | 1837190 | 2020-06-14 | Spain | Murcia | 1629 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-15 03:33:14 | Murcia, Spain | ||
3061242 | 3061242 | 2020-06-13 | Spain | Murcia | 1628 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-14 03:33:15 | Murcia, Spain | ||
737562 | 737562 | 2020-06-12 | Spain | Murcia | 1628 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-13 03:33:14 | Murcia, Spain | ||
1273532 | 1273532 | 2020-06-11 | Spain | Murcia | 1626 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-12 05:09:52 | Murcia, Spain | ||
2863975 | 2863975 | 2020-06-10 | Spain | Murcia | 1624 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-11 03:33:41 | Murcia, Spain | ||
1210807 | 1210807 | 2020-06-09 | Spain | Murcia | 1619 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-10 04:07:00 | Murcia, Spain | ||
217234 | 217234 | 2020-06-08 | Spain | Murcia | 1619 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-09 03:33:03 | Murcia, Spain | ||
2800030 | 2800030 | 2020-06-07 | Spain | Murcia | 1616 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-08 03:33:22 | Murcia, Spain | ||
574086 | 574086 | 2020-06-06 | Spain | Murcia | 1616 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-07 03:53:30 | Murcia, Spain | ||
1269783 | 1269783 | 2020-06-05 | Spain | Murcia | 1616 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-06 02:33:00 | Murcia, Spain | ||
1281255 | 1281255 | 2020-06-04 | Spain | Murcia | 1613 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-05 02:33:06 | Murcia, Spain | ||
3866810 | 3866810 | 2020-06-03 | Spain | Murcia | 1605 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-04 02:33:14 | Murcia, Spain | ||
2555852 | 2555852 | 2020-06-02 | Spain | Murcia | 1603 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-03 02:33:13 | Murcia, Spain | ||
805389 | 805389 | 2020-06-01 | Spain | Murcia | 1599 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-02 02:33:08 | Murcia, Spain | ||
1793975 | 1793975 | 2020-05-31 | Spain | Murcia | 1597 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-01 02:32:46 | Murcia, Spain | ||
3638868 | 3638868 | 2020-05-30 | Spain | Murcia | 1597 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-05-31 02:32:45 | Murcia, Spain | ||
1790409 | 1790409 | 2020-05-29 | Spain | Murcia | 1595 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-05-30 02:32:48 | Murcia, Spain | ||
2712288 | 2712288 | 2020-05-28 | Spain | Murcia | 1593 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-05-29 02:32:50 | Murcia, Spain | ||
2548247 | 2548247 | 2020-05-27 | Spain | Murcia | 1587 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-05-28 02:32:31 | Murcia, Spain | ||
1041210 | 1041210 | 2020-05-26 | Spain | Murcia | 1587 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-05-27 02:32:31 | Murcia, Spain | ||
1431923 | 1431923 | 2020-05-20 | Spain | Murcia | 1560 | 148 | 0 | 1412 | 37.9922 | -1.1307 | 2020-05-21 02:32:48 | Murcia, 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]);