johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
519 rows where country_or_region = "Spain", province_or_state = "Catalonia" and recovered = 0 sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2390119 | 2390119 | 2020-05-19 | Spain | Catalonia | 55825 | 5981 | 0 | 49844 | 41.5912 | 1.5209 | 2020-05-20 02:32:19 | Catalonia, Spain | ||
1431840 | 1431840 | 2020-05-20 | Spain | Catalonia | 55888 | 6021 | 0 | 49867 | 41.5912 | 1.5209 | 2020-05-21 02:32:48 | Catalonia, Spain | ||
268257 | 268257 | 2020-05-21 | Spain | Catalonia | 55888 | 6021 | 0 | 49867 | 41.5912 | 1.5209 | 2020-05-22 02:36:51 | Catalonia, Spain | ||
1864751 | 1864751 | 2020-05-22 | Spain | Catalonia | 57036 | 6656 | 0 | 50380 | 41.5912 | 1.5209 | 2020-05-23 02:32:42 | Catalonia, Spain | ||
997728 | 997728 | 2020-05-23 | Spain | Catalonia | 57114 | 6663 | 0 | 50451 | 41.5912 | 1.5209 | 2020-05-24 02:32:43 | Catalonia, Spain | ||
875537 | 875537 | 2020-05-24 | Spain | Catalonia | 57148 | 6701 | 0 | 50447 | 41.5912 | 1.5209 | 2020-05-25 02:32:44 | Catalonia, Spain | ||
1104857 | 1104857 | 2020-05-25 | Spain | Catalonia | 57320 | 5575 | 0 | 51745 | 41.5912 | 1.5209 | 2020-05-26 02:32:35 | Catalonia, Spain | ||
1956822 | 1956822 | 2021-08-05 | Spain | Catalonia | 850299 | 14907 | 0 | 41.5912 | 1.5209 | 2021-08-06 04:21:18 | Catalonia, Spain | |||
1117885 | 1117885 | 2021-08-06 | Spain | Catalonia | 853123 | 14914 | 0 | 41.5912 | 1.5209 | 2021-08-07 04:21:30 | Catalonia, Spain | |||
2203935 | 2203935 | 2021-08-07 | Spain | Catalonia | 853123 | 14914 | 0 | 41.5912 | 1.5209 | 2021-08-08 04:21:33 | Catalonia, Spain | |||
589923 | 589923 | 2021-08-08 | Spain | Catalonia | 853123 | 14914 | 0 | 41.5912 | 1.5209 | 2021-08-09 04:21:24 | Catalonia, Spain | |||
650261 | 650261 | 2021-08-09 | Spain | Catalonia | 858718 | 14920 | 0 | 41.5912 | 1.5209 | 2021-08-10 04:21:27 | Catalonia, Spain | |||
2351732 | 2351732 | 2021-08-10 | Spain | Catalonia | 861241 | 14937 | 0 | 41.5912 | 1.5209 | 2021-08-11 04:21:58 | Catalonia, Spain | |||
1342585 | 1342585 | 2021-08-11 | Spain | Catalonia | 864089 | 14943 | 0 | 41.5912 | 1.5209 | 2021-08-12 04:21:25 | Catalonia, Spain | |||
2899981 | 2899981 | 2021-08-12 | Spain | Catalonia | 866622 | 14954 | 0 | 41.5912 | 1.5209 | 2021-08-13 04:21:24 | Catalonia, Spain | |||
1483851 | 1483851 | 2021-08-13 | Spain | Catalonia | 868586 | 14958 | 0 | 41.5912 | 1.5209 | 2021-08-14 04:21:25 | Catalonia, Spain | |||
507979 | 507979 | 2021-08-14 | Spain | Catalonia | 868586 | 14958 | 0 | 41.5912 | 1.5209 | 2021-08-15 04:21:41 | Catalonia, Spain | |||
103621 | 103621 | 2021-08-15 | Spain | Catalonia | 868586 | 14958 | 0 | 41.5912 | 1.5209 | 2021-08-16 04:21:31 | Catalonia, Spain | |||
1604527 | 1604527 | 2021-08-16 | Spain | Catalonia | 872755 | 14975 | 0 | 41.5912 | 1.5209 | 2021-08-17 04:21:49 | Catalonia, Spain | |||
245564 | 245564 | 2021-08-17 | Spain | Catalonia | 874604 | 14985 | 0 | 41.5912 | 1.5209 | 2021-08-18 04:21:35 | Catalonia, Spain | |||
2518472 | 2518472 | 2021-08-18 | Spain | Catalonia | 876675 | 14994 | 0 | 41.5912 | 1.5209 | 2021-08-19 04:21:15 | Catalonia, Spain | |||
511993 | 511993 | 2021-08-19 | Spain | Catalonia | 878858 | 15012 | 0 | 41.5912 | 1.5209 | 2021-08-20 04:21:33 | Catalonia, Spain | |||
1854286 | 1854286 | 2021-08-20 | Spain | Catalonia | 880728 | 15062 | 0 | 41.5912 | 1.5209 | 2021-08-21 04:21:38 | Catalonia, Spain | |||
3555944 | 3555944 | 2021-08-21 | Spain | Catalonia | 880728 | 15062 | 0 | 41.5912 | 1.5209 | 2021-08-22 04:21:29 | Catalonia, Spain | |||
2175848 | 2175848 | 2021-08-22 | Spain | Catalonia | 880728 | 15062 | 0 | 41.5912 | 1.5209 | 2021-08-23 04:21:27 | Catalonia, Spain | |||
3165921 | 3165921 | 2021-08-23 | Spain | Catalonia | 884226 | 15080 | 0 | 41.5912 | 1.5209 | 2021-08-24 04:21:19 | Catalonia, Spain | |||
3105750 | 3105750 | 2021-08-24 | Spain | Catalonia | 886082 | 15101 | 0 | 41.5912 | 1.5209 | 2021-08-25 04:21:41 | Catalonia, Spain | |||
32711 | 32711 | 2021-08-25 | Spain | Catalonia | 887757 | 15129 | 0 | 41.5912 | 1.5209 | 2021-08-26 04:21:28 | Catalonia, Spain | |||
1596502 | 1596502 | 2021-08-26 | Spain | Catalonia | 887826 | 15132 | 0 | 41.5912 | 1.5209 | 2021-08-27 04:21:37 | Catalonia, Spain | |||
2923488 | 2923488 | 2021-08-27 | Spain | Catalonia | 889270 | 15173 | 0 | 41.5912 | 1.5209 | 2021-08-28 04:21:28 | Catalonia, Spain | |||
2793329 | 2793329 | 2021-08-28 | Spain | Catalonia | 889270 | 15173 | 0 | 41.5912 | 1.5209 | 2021-08-29 04:21:14 | Catalonia, Spain | |||
3892226 | 3892226 | 2021-08-29 | Spain | Catalonia | 889270 | 15173 | 0 | 41.5912 | 1.5209 | 2021-08-30 04:21:23 | Catalonia, Spain | |||
1775652 | 1775652 | 2021-08-30 | Spain | Catalonia | 891922 | 15213 | 0 | 41.5912 | 1.5209 | 2021-08-31 04:21:46 | Catalonia, Spain | |||
2068198 | 2068198 | 2021-08-31 | Spain | Catalonia | 893045 | 15236 | 0 | 41.5912 | 1.5209 | 2021-09-01 04:21:38 | Catalonia, Spain | |||
67356 | 67356 | 2021-09-01 | Spain | Catalonia | 893681 | 15256 | 0 | 41.5912 | 1.5209 | 2021-09-02 04:21:15 | Catalonia, Spain | |||
178321 | 178321 | 2021-09-02 | Spain | Catalonia | 897205 | 15322 | 0 | 41.5912 | 1.5209 | 2021-09-03 04:21:20 | Catalonia, Spain | |||
3974859 | 3974859 | 2021-09-03 | Spain | Catalonia | 898290 | 15353 | 0 | 41.5912 | 1.5209 | 2021-09-04 04:21:28 | Catalonia, Spain | |||
249578 | 249578 | 2021-09-04 | Spain | Catalonia | 898290 | 15353 | 0 | 41.5912 | 1.5209 | 2021-09-05 04:21:33 | Catalonia, Spain | |||
3281164 | 3281164 | 2021-09-05 | Spain | Catalonia | 898290 | 15353 | 0 | 41.5912 | 1.5209 | 2021-09-06 04:21:22 | Catalonia, Spain | |||
3194296 | 3194296 | 2021-09-06 | Spain | Catalonia | 898290 | 15366 | 0 | 41.5912 | 1.5209 | 2021-09-07 04:21:35 | Catalonia, Spain | |||
642233 | 642233 | 2021-09-07 | Spain | Catalonia | 900596 | 15391 | 0 | 41.5912 | 1.5209 | 2021-09-08 04:21:31 | Catalonia, Spain | |||
2279454 | 2279454 | 2021-09-08 | Spain | Catalonia | 902243 | 15414 | 0 | 41.5912 | 1.5209 | 2021-09-09 04:21:27 | Catalonia, Spain | |||
1263084 | 1263084 | 2021-09-09 | Spain | Catalonia | 903454 | 15429 | 0 | 41.5912 | 1.5209 | 2021-09-10 04:21:20 | Catalonia, Spain | |||
3449138 | 3449138 | 2021-09-10 | Spain | Catalonia | 904560 | 15437 | 0 | 41.5912 | 1.5209 | 2021-09-11 04:21:30 | Catalonia, Spain | |||
3806198 | 3806198 | 2021-09-11 | Spain | Catalonia | 904560 | 15437 | 0 | 41.5912 | 1.5209 | 2021-09-12 04:21:13 | Catalonia, Spain | |||
1885295 | 1885295 | 2021-09-12 | Spain | Catalonia | 904560 | 15437 | 0 | 41.5912 | 1.5209 | 2021-09-13 04:21:15 | Catalonia, Spain | |||
1385926 | 1385926 | 2021-09-13 | Spain | Catalonia | 906168 | 15455 | 0 | 41.5912 | 1.5209 | 2021-09-14 04:21:41 | Catalonia, Spain | |||
2463087 | 2463087 | 2021-09-14 | Spain | Catalonia | 906798 | 15475 | 0 | 41.5912 | 1.5209 | 2021-09-15 03:22:37 | Catalonia, Spain | |||
1374788 | 1374788 | 2021-09-15 | Spain | Catalonia | 907754 | 15515 | 0 | 41.5912 | 1.5209 | 2021-09-16 04:22:19 | Catalonia, Spain | |||
2809043 | 2809043 | 2021-09-16 | Spain | Catalonia | 908716 | 15545 | 0 | 41.5912 | 1.5209 | 2021-09-17 04:21:46 | Catalonia, Spain | |||
2618335 | 2618335 | 2021-09-17 | Spain | Catalonia | 909294 | 15546 | 0 | 41.5912 | 1.5209 | 2021-09-18 04:21:24 | Catalonia, Spain | |||
16650 | 16650 | 2021-09-18 | Spain | Catalonia | 909294 | 15546 | 0 | 41.5912 | 1.5209 | 2021-09-19 04:21:34 | Catalonia, Spain | |||
1815070 | 1815070 | 2021-09-19 | Spain | Catalonia | 909294 | 15546 | 0 | 41.5912 | 1.5209 | 2021-09-20 04:21:22 | Catalonia, Spain | |||
809871 | 809871 | 2021-09-20 | Spain | Catalonia | 910484 | 15565 | 0 | 41.5912 | 1.5209 | 2021-09-21 04:21:26 | Catalonia, Spain | |||
3757768 | 3757768 | 2021-09-21 | Spain | Catalonia | 911039 | 15574 | 0 | 41.5912 | 1.5209 | 2021-09-22 04:21:45 | Catalonia, Spain | |||
3011630 | 3011630 | 2021-09-22 | Spain | Catalonia | 911627 | 15596 | 0 | 41.5912 | 1.5209 | 2021-09-23 04:21:43 | Catalonia, Spain | |||
601986 | 601986 | 2021-09-23 | Spain | Catalonia | 912477 | 15641 | 0 | 41.5912 | 1.5209 | 2021-09-24 04:21:44 | Catalonia, Spain | |||
1921515 | 1921515 | 2021-09-24 | Spain | Catalonia | 913160 | 15643 | 0 | 41.5912 | 1.5209 | 2021-09-25 04:21:31 | Catalonia, Spain | |||
1724795 | 1724795 | 2021-09-25 | Spain | Catalonia | 913160 | 15643 | 0 | 41.5912 | 1.5209 | 2021-09-26 04:21:29 | Catalonia, Spain | |||
2076243 | 2076243 | 2021-09-26 | Spain | Catalonia | 913160 | 15643 | 0 | 41.5912 | 1.5209 | 2021-09-27 04:21:16 | Catalonia, Spain | |||
1235942 | 1235942 | 2021-09-27 | Spain | Catalonia | 914387 | 15646 | 0 | 41.5912 | 1.5209 | 2021-09-28 04:21:28 | Catalonia, Spain | |||
1334573 | 1334573 | 2021-09-28 | Spain | Catalonia | 914880 | 15651 | 0 | 41.5912 | 1.5209 | 2021-09-29 04:21:45 | Catalonia, Spain | |||
706731 | 706731 | 2021-09-29 | Spain | Catalonia | 915835 | 15664 | 0 | 41.5912 | 1.5209 | 2021-09-30 04:21:20 | Catalonia, Spain | |||
2773275 | 2773275 | 2021-09-30 | Spain | Catalonia | 916409 | 15669 | 0 | 41.5912 | 1.5209 | 2021-10-01 04:21:35 | Catalonia, Spain | |||
2132318 | 2132318 | 2021-10-01 | Spain | Catalonia | 917188 | 15673 | 0 | 41.5912 | 1.5209 | 2021-10-02 04:21:25 | Catalonia, Spain | |||
3928338 | 3928338 | 2021-10-02 | Spain | Catalonia | 917188 | 15673 | 0 | 41.5912 | 1.5209 | 2021-10-03 04:21:24 | Catalonia, Spain | |||
1274585 | 1274585 | 2021-10-03 | Spain | Catalonia | 917188 | 15673 | 0 | 41.5912 | 1.5209 | 2021-10-04 04:21:31 | Catalonia, Spain | |||
987275 | 987275 | 2021-10-04 | Spain | Catalonia | 918296 | 15679 | 0 | 41.5912 | 1.5209 | 2021-10-05 04:21:27 | Catalonia, Spain | |||
3832782 | 3832782 | 2021-10-05 | Spain | Catalonia | 918735 | 15685 | 0 | 41.5912 | 1.5209 | 2021-10-06 04:21:33 | Catalonia, Spain | |||
2459088 | 2459088 | 2021-10-06 | Spain | Catalonia | 919548 | 15703 | 0 | 41.5912 | 1.5209 | 2021-10-07 04:21:36 | Catalonia, Spain | |||
467708 | 467708 | 2021-10-07 | Spain | Catalonia | 919883 | 15709 | 0 | 41.5912 | 1.5209 | 2021-10-08 04:21:25 | Catalonia, Spain | |||
2959670 | 2959670 | 2021-10-08 | Spain | Catalonia | 920721 | 15751 | 0 | 41.5912 | 1.5209 | 2021-10-09 04:21:34 | Catalonia, Spain | |||
2876504 | 2876504 | 2021-10-09 | Spain | Catalonia | 920721 | 15751 | 0 | 41.5912 | 1.5209 | 2021-10-10 04:21:38 | Catalonia, Spain | |||
423647 | 423647 | 2021-10-10 | Spain | Catalonia | 920721 | 15751 | 0 | 41.5912 | 1.5209 | 2021-10-11 04:21:31 | Catalonia, Spain | |||
3007631 | 3007631 | 2021-10-11 | Spain | Catalonia | 921841 | 15758 | 0 | 41.5912 | 1.5209 | 2021-10-12 04:21:09 | Catalonia, Spain | |||
1491898 | 1491898 | 2021-10-12 | Spain | Catalonia | 921841 | 15758 | 0 | 41.5912 | 1.5209 | 2021-10-13 04:20:51 | Catalonia, Spain | |||
634220 | 634220 | 2021-10-13 | Spain | Catalonia | 922582 | 15765 | 0 | 41.5912 | 1.5209 | 2021-10-14 04:21:29 | Catalonia, Spain | |||
491932 | 491932 | 2021-10-14 | Spain | Catalonia | 923046 | 15768 | 0 | 41.5912 | 1.5209 | 2021-10-15 04:21:26 | Catalonia, Spain | |||
2943652 | 2943652 | 2021-10-15 | Spain | Catalonia | 923748 | 15797 | 0 | 41.5912 | 1.5209 | 2021-10-16 04:21:15 | Catalonia, Spain | |||
935097 | 935097 | 2021-10-16 | Spain | Catalonia | 923748 | 15797 | 0 | 41.5912 | 1.5209 | 2021-10-17 04:21:29 | Catalonia, Spain | |||
1909508 | 1909508 | 2021-10-17 | Spain | Catalonia | 923748 | 15797 | 0 | 41.5912 | 1.5209 | 2021-10-18 04:21:10 | Catalonia, Spain | |||
2044147 | 2044147 | 2021-10-18 | Spain | Catalonia | 924927 | 15818 | 0 | 41.5912 | 1.5209 | 2021-10-19 04:20:54 | Catalonia, Spain | |||
597970 | 597970 | 2021-10-19 | Spain | Catalonia | 925371 | 15825 | 0 | 41.5912 | 1.5209 | 2021-10-20 04:21:00 | Catalonia, Spain | |||
443651 | 443651 | 2021-10-20 | Spain | Catalonia | 926093 | 15832 | 0 | 41.5912 | 1.5209 | 2021-10-21 04:21:18 | Catalonia, Spain | |||
2124039 | 2124039 | 2021-10-21 | Spain | Catalonia | 926235 | 15842 | 0 | 41.5912 | 1.5209 | 2021-10-22 04:21:14 | Catalonia, Spain | |||
654292 | 654292 | 2021-10-22 | Spain | Catalonia | 926815 | 15865 | 0 | 41.5912 | 1.5209 | 2021-10-23 04:21:32 | Catalonia, Spain | |||
770645 | 770645 | 2021-10-23 | Spain | Catalonia | 926815 | 15865 | 0 | 41.5912 | 1.5209 | 2021-10-24 04:21:22 | Catalonia, Spain | |||
682637 | 682637 | 2021-10-24 | Spain | Catalonia | 926815 | 15865 | 0 | 41.5912 | 1.5209 | 2021-10-25 04:22:31 | Catalonia, Spain | |||
3794191 | 3794191 | 2021-10-25 | Spain | Catalonia | 927729 | 15870 | 0 | 41.5912 | 1.5209 | 2021-10-26 04:22:09 | Catalonia, Spain | |||
3492469 | 3492469 | 2021-10-26 | Spain | Catalonia | 928122 | 15877 | 0 | 41.5912 | 1.5209 | 2021-10-27 04:22:32 | Catalonia, Spain | |||
535032 | 535032 | 2021-10-27 | Spain | Catalonia | 928860 | 15907 | 0 | 41.5912 | 1.5209 | 2021-10-28 04:22:08 | Catalonia, Spain | |||
4642 | 4642 | 2021-10-28 | Spain | Catalonia | 929265 | 15930 | 0 | 41.5912 | 1.5209 | 2021-10-29 04:22:03 | Catalonia, Spain | |||
567400 | 567400 | 2021-10-29 | Spain | Catalonia | 929712 | 15953 | 0 | 41.5912 | 1.5209 | 2021-10-30 04:22:03 | Catalonia, Spain | |||
2721298 | 2721298 | 2021-10-30 | Spain | Catalonia | 929712 | 15953 | 0 | 41.5912 | 1.5209 | 2021-10-31 04:22:08 | Catalonia, Spain | |||
288292 | 288292 | 2021-10-31 | Spain | Catalonia | 929712 | 15953 | 0 | 41.5912 | 1.5209 | 2021-11-01 04:22:01 | Catalonia, Spain | |||
3511700 | 3511700 | 2021-11-01 | Spain | Catalonia | 929712 | 15953 | 0 | 41.5912 | 1.5209 | 2021-11-02 04:22:03 | Catalonia, Spain | |||
44004 | 44004 | 2021-11-02 | Spain | Catalonia | 930918 | 15970 | 0 | 41.5912 | 1.5209 | 2021-11-03 06:22:09 | Catalonia, Spain | |||
276479 | 276479 | 2021-11-03 | Spain | Catalonia | 931345 | 15976 | 0 | 41.5912 | 1.5209 | 2021-11-04 04:22:20 | Catalonia, Spain | |||
698701 | 698701 | 2021-11-04 | Spain | Catalonia | 932210 | 15978 | 0 | 41.5912 | 1.5209 | 2021-11-05 04:21:54 | Catalonia, Spain | |||
3121803 | 3121803 | 2021-11-05 | Spain | Catalonia | 932744 | 15981 | 0 | 41.5912 | 1.5209 | 2021-11-06 04:21:51 | Catalonia, 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]);