johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Spain" and province_or_state = "La Rioja" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2235685 | 2235685 | 2022-06-12 | Spain | La Rioja | 100780 | 926 | 0 | 42.2871 | -2.5396 | 2022-06-13 04:21:14 | La Rioja, Spain | |||
3141883 | 3141883 | 2022-06-11 | Spain | La Rioja | 100780 | 926 | 0 | 42.2871 | -2.5396 | 2022-06-12 04:20:53 | La Rioja, Spain | |||
1944799 | 1944799 | 2022-06-10 | Spain | La Rioja | 100780 | 926 | 0 | 42.2871 | -2.5396 | 2022-06-11 04:21:01 | La Rioja, Spain | |||
3157938 | 3157938 | 2022-06-09 | Spain | La Rioja | 100521 | 925 | 0 | 42.2871 | -2.5396 | 2022-06-10 04:20:55 | La Rioja, Spain | |||
1421405 | 1421405 | 2022-06-08 | Spain | La Rioja | 100521 | 925 | 0 | 42.2871 | -2.5396 | 2022-06-09 04:20:54 | La Rioja, Spain | |||
3726519 | 3726519 | 2022-06-07 | Spain | La Rioja | 100521 | 925 | 0 | 42.2871 | -2.5396 | 2022-06-08 04:20:55 | La Rioja, Spain | |||
3887921 | 3887921 | 2022-06-06 | Spain | La Rioja | 100332 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-07 04:21:08 | La Rioja, Spain | |||
3507690 | 3507690 | 2022-06-05 | Spain | La Rioja | 100332 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-06 04:20:57 | La Rioja, Spain | |||
3527767 | 3527767 | 2022-06-04 | Spain | La Rioja | 100332 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-05 04:20:55 | La Rioja, Spain | |||
3133853 | 3133853 | 2022-06-03 | Spain | La Rioja | 100332 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-04 04:20:58 | La Rioja, Spain | |||
3578928 | 3578928 | 2022-06-02 | Spain | La Rioja | 100041 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-03 04:20:58 | La Rioja, Spain | |||
971221 | 971221 | 2022-06-01 | Spain | La Rioja | 100041 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-02 05:20:39 | La Rioja, Spain | |||
229528 | 229528 | 2022-05-31 | Spain | La Rioja | 99738 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-01 04:20:55 | La Rioja, Spain | |||
3186293 | 3186293 | 2022-05-30 | Spain | La Rioja | 99738 | 924 | 0 | 42.2871 | -2.5396 | 2022-05-31 04:20:51 | La Rioja, Spain | |||
3198442 | 3198442 | 2022-05-29 | Spain | La Rioja | 99738 | 924 | 0 | 42.2871 | -2.5396 | 2022-05-30 04:20:50 | La Rioja, Spain | |||
2725320 | 2725320 | 2022-05-28 | Spain | La Rioja | 99738 | 924 | 0 | 42.2871 | -2.5396 | 2022-05-29 04:20:53 | La Rioja, Spain | |||
1314501 | 1314501 | 2022-05-27 | Spain | La Rioja | 99738 | 924 | 0 | 42.2871 | -2.5396 | 2022-05-28 04:21:07 | La Rioja, Spain | |||
1850293 | 1850293 | 2022-05-26 | Spain | La Rioja | 99469 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-27 04:20:56 | La Rioja, Spain | |||
2048169 | 2048169 | 2022-05-25 | Spain | La Rioja | 99119 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-26 04:20:50 | La Rioja, Spain | |||
2999607 | 2999607 | 2022-05-24 | Spain | La Rioja | 99119 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-25 04:20:56 | La Rioja, Spain | |||
3593328 | 3593328 | 2022-05-23 | Spain | La Rioja | 99119 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-24 04:20:57 | La Rioja, Spain | |||
622180 | 622180 | 2022-05-22 | Spain | La Rioja | 99119 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-26 04:20:50 | La Rioja, Spain | |||
1109876 | 1109876 | 2022-05-21 | Spain | La Rioja | 99119 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-22 04:20:52 | La Rioja, Spain | |||
1169500 | 1169500 | 2022-05-20 | Spain | La Rioja | 98637 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-21 04:20:58 | La Rioja, Spain | |||
3896263 | 3896263 | 2022-05-19 | Spain | La Rioja | 98637 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-20 04:20:57 | La Rioja, Spain | |||
1185047 | 1185047 | 2022-05-18 | Spain | La Rioja | 98637 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-19 04:20:54 | La Rioja, Spain | |||
3582944 | 3582944 | 2022-05-17 | Spain | La Rioja | 98637 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-18 04:20:50 | La Rioja, Spain | |||
1503901 | 1503901 | 2022-05-16 | Spain | La Rioja | 98175 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-17 04:20:59 | La Rioja, Spain | |||
2084260 | 2084260 | 2022-05-15 | Spain | La Rioja | 98175 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-16 04:20:47 | La Rioja, Spain | |||
3354970 | 3354970 | 2022-05-14 | Spain | La Rioja | 98175 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-15 04:20:53 | La Rioja, Spain | |||
658615 | 658615 | 2022-05-13 | Spain | La Rioja | 98175 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-14 04:20:48 | La Rioja, Spain | |||
2533698 | 2533698 | 2022-05-12 | Spain | La Rioja | 97607 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-13 04:20:51 | La Rioja, Spain | |||
3445144 | 3445144 | 2022-05-11 | Spain | La Rioja | 97607 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-12 04:20:54 | La Rioja, Spain | |||
3535761 | 3535761 | 2022-05-10 | Spain | La Rioja | 97607 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-11 04:20:48 | La Rioja, Spain | |||
222296 | 222296 | 2022-05-09 | Spain | La Rioja | 97607 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-10 04:20:50 | La Rioja, Spain | |||
2331681 | 2331681 | 2022-05-08 | Spain | La Rioja | 97089 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-09 04:20:54 | La Rioja, Spain | |||
360643 | 360643 | 2022-05-07 | Spain | La Rioja | 97089 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-08 04:20:49 | La Rioja, Spain | |||
1397994 | 1397994 | 2022-05-06 | Spain | La Rioja | 97089 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-07 04:21:09 | La Rioja, Spain | |||
2598349 | 2598349 | 2022-05-05 | Spain | La Rioja | 96391 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-06 04:21:00 | La Rioja, Spain | |||
3265798 | 3265798 | 2022-05-04 | Spain | La Rioja | 96391 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-05 04:20:55 | La Rioja, Spain | |||
1572437 | 1572437 | 2022-05-03 | Spain | La Rioja | 96391 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-04 04:20:59 | La Rioja, Spain | |||
463697 | 463697 | 2022-05-02 | Spain | La Rioja | 95906 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-03 04:21:00 | La Rioja, Spain | |||
3916336 | 3916336 | 2022-05-01 | Spain | La Rioja | 95906 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-02 04:21:10 | La Rioja, Spain | |||
2841140 | 2841140 | 2022-04-30 | Spain | La Rioja | 95906 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-01 04:20:57 | La Rioja, Spain | |||
1157453 | 1157453 | 2022-04-29 | Spain | La Rioja | 95906 | 920 | 0 | 42.2871 | -2.5396 | 2022-04-30 04:21:05 | La Rioja, Spain | |||
1696635 | 1696635 | 2022-04-28 | Spain | La Rioja | 95335 | 920 | 0 | 42.2871 | -2.5396 | 2022-04-29 04:20:59 | La Rioja, Spain | |||
3852118 | 3852118 | 2022-04-27 | Spain | La Rioja | 95335 | 920 | 0 | 42.2871 | -2.5396 | 2022-04-28 04:20:47 | La Rioja, Spain | |||
1326548 | 1326548 | 2022-04-26 | Spain | La Rioja | 95335 | 920 | 0 | 42.2871 | -2.5396 | 2022-04-27 04:20:52 | La Rioja, Spain | |||
3722502 | 3722502 | 2022-04-25 | Spain | La Rioja | 94922 | 917 | 0 | 42.2871 | -2.5396 | 2022-04-26 04:20:51 | La Rioja, Spain | |||
2029070 | 2029070 | 2022-04-24 | Spain | La Rioja | 94922 | 917 | 0 | 42.2871 | -2.5396 | 2022-04-25 04:20:56 | La Rioja, Spain | |||
746645 | 746645 | 2022-04-23 | Spain | La Rioja | 94922 | 917 | 0 | 42.2871 | -2.5396 | 2022-04-24 04:20:56 | La Rioja, Spain | |||
3437130 | 3437130 | 2022-04-22 | Spain | La Rioja | 94922 | 917 | 0 | 42.2871 | -2.5396 | 2022-04-23 04:20:50 | La Rioja, Spain | |||
2892715 | 2892715 | 2022-04-21 | Spain | La Rioja | 94360 | 915 | 0 | 42.2871 | -2.5396 | 2022-04-22 04:20:45 | La Rioja, Spain | |||
2307587 | 2307587 | 2022-04-20 | Spain | La Rioja | 94360 | 915 | 0 | 42.2871 | -2.5396 | 2022-04-21 04:20:46 | La Rioja, Spain | |||
2251726 | 2251726 | 2022-04-19 | Spain | La Rioja | 94360 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-20 04:20:45 | La Rioja, Spain | |||
1846276 | 1846276 | 2022-04-18 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-19 04:21:00 | La Rioja, Spain | |||
3417220 | 3417220 | 2022-04-17 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-18 04:21:12 | La Rioja, Spain | |||
304169 | 304169 | 2022-04-16 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-17 04:20:59 | La Rioja, Spain | |||
2670114 | 2670114 | 2022-04-15 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-16 04:20:48 | La Rioja, Spain | |||
1223899 | 1223899 | 2022-04-14 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-15 04:20:57 | La Rioja, Spain | |||
2443057 | 2443057 | 2022-04-13 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-13 23:21:06 | La Rioja, Spain | |||
1948814 | 1948814 | 2022-04-12 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-13 04:21:03 | La Rioja, Spain | |||
3206567 | 3206567 | 2022-04-11 | Spain | La Rioja | 93719 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-12 04:20:49 | La Rioja, Spain | |||
1576453 | 1576453 | 2022-04-10 | Spain | La Rioja | 93719 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-11 04:21:02 | La Rioja, Spain | |||
1652695 | 1652695 | 2022-04-09 | Spain | La Rioja | 93719 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-10 04:20:52 | La Rioja, Spain | |||
2116017 | 2116017 | 2022-04-08 | Spain | La Rioja | 93719 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-09 04:20:42 | La Rioja, Spain | |||
3320541 | 3320541 | 2022-04-07 | Spain | La Rioja | 93437 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-08 04:20:48 | La Rioja, Spain | |||
2801077 | 2801077 | 2022-04-06 | Spain | La Rioja | 93437 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-07 04:20:53 | La Rioja, Spain | |||
3867846 | 3867846 | 2022-04-05 | Spain | La Rioja | 93437 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-06 04:20:49 | La Rioja, Spain | |||
2749188 | 2749188 | 2022-04-04 | Spain | La Rioja | 93187 | 911 | 0 | 42.2871 | -2.5396 | 2022-04-05 04:20:48 | La Rioja, Spain | |||
3730534 | 3730534 | 2022-04-03 | Spain | La Rioja | 93187 | 911 | 0 | 42.2871 | -2.5396 | 2022-04-04 04:20:51 | La Rioja, Spain | |||
499969 | 499969 | 2022-04-02 | Spain | La Rioja | 93187 | 911 | 0 | 42.2871 | -2.5396 | 2022-04-03 04:20:48 | La Rioja, Spain | |||
3350954 | 3350954 | 2022-04-01 | Spain | La Rioja | 93187 | 911 | 0 | 42.2871 | -2.5396 | 2022-04-02 04:20:47 | La Rioja, Spain | |||
1540259 | 1540259 | 2022-03-31 | Spain | La Rioja | 92896 | 911 | 0 | 42.2871 | -2.5396 | 2022-04-01 04:20:28 | La Rioja, Spain | |||
2478272 | 2478272 | 2022-03-30 | Spain | La Rioja | 92896 | 911 | 0 | 42.2871 | -2.5396 | 2022-03-31 04:20:56 | La Rioja, Spain | |||
158313 | 158313 | 2022-03-29 | Spain | La Rioja | 92896 | 911 | 0 | 42.2871 | -2.5396 | 2022-03-30 04:20:45 | La Rioja, Spain | |||
1436884 | 1436884 | 2022-03-28 | Spain | La Rioja | 92418 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-29 04:20:46 | La Rioja, Spain | |||
876565 | 876565 | 2022-03-27 | Spain | La Rioja | 92418 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-28 04:20:33 | La Rioja, Spain | |||
2163848 | 2163848 | 2022-03-26 | Spain | La Rioja | 92418 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-27 04:20:47 | La Rioja, Spain | |||
1720784 | 1720784 | 2022-03-25 | Spain | La Rioja | 92418 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-26 04:20:23 | La Rioja, Spain | |||
1468401 | 1468401 | 2022-03-24 | Spain | La Rioja | 91927 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-25 04:20:46 | La Rioja, Spain | |||
3022575 | 3022575 | 2022-03-23 | Spain | La Rioja | 91927 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-24 04:20:43 | La Rioja, Spain | |||
1905497 | 1905497 | 2022-03-22 | Spain | La Rioja | 91927 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-23 04:20:48 | La Rioja, Spain | |||
3238628 | 3238628 | 2022-03-21 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-22 04:20:54 | La Rioja, Spain | |||
24701 | 24701 | 2022-03-20 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-21 04:20:50 | La Rioja, Spain | |||
1656711 | 1656711 | 2022-03-19 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-20 04:20:45 | La Rioja, Spain | |||
336237 | 336237 | 2022-03-18 | Spain | La Rioja | 91371 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-19 04:20:47 | La Rioja, Spain | |||
694690 | 694690 | 2022-03-17 | Spain | La Rioja | 90785 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-18 04:20:55 | La Rioja, Spain | |||
2319633 | 2319633 | 2022-03-16 | Spain | La Rioja | 90785 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-17 04:20:56 | La Rioja, Spain | |||
261833 | 261833 | 2022-03-15 | Spain | La Rioja | 90785 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-16 04:20:50 | La Rioja, Spain | |||
2264192 | 2264192 | 2022-03-14 | Spain | La Rioja | 90461 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-15 04:20:47 | La Rioja, Spain | |||
3628258 | 3628258 | 2022-03-13 | Spain | La Rioja | 90461 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-14 04:20:46 | La Rioja, Spain | |||
951166 | 951166 | 2022-03-12 | Spain | La Rioja | 90461 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-13 04:20:49 | La Rioja, Spain | |||
356627 | 356627 | 2022-03-11 | Spain | La Rioja | 90461 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-12 04:20:50 | La Rioja, Spain | |||
1865779 | 1865779 | 2022-03-10 | Spain | La Rioja | 90241 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-11 04:20:50 | La Rioja, Spain | |||
2140474 | 2140474 | 2022-03-09 | Spain | La Rioja | 90108 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-10 04:20:48 | La Rioja, Spain | |||
919985 | 919985 | 2022-03-08 | Spain | La Rioja | 90011 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-09 04:20:59 | La Rioja, Spain | |||
1548272 | 1548272 | 2022-03-07 | Spain | La Rioja | 89852 | 908 | 0 | 42.2871 | -2.5396 | 2022-03-08 04:20:54 | La Rioja, Spain | |||
2199941 | 2199941 | 2022-03-06 | Spain | La Rioja | 89603 | 907 | 0 | 42.2871 | -2.5396 | 2022-03-07 04:20:47 | La Rioja, Spain | |||
2092398 | 2092398 | 2022-03-05 | Spain | La Rioja | 89603 | 907 | 0 | 42.2871 | -2.5396 | 2022-03-06 04:20:49 | La Rioja, 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]);