johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Spain", longitude = "-8.1339" and province_or_state = "Galicia" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
629 | 629 | 2021-12-02 | Spain | Galicia | 195765 | 2671 | 0 | 42.5751 | -8.1339 | 2021-12-03 04:23:05 | Galicia, Spain | |||
4645 | 4645 | 2021-10-28 | Spain | Galicia | 187450 | 2648 | 0 | 42.5751 | -8.1339 | 2021-10-29 04:22:03 | Galicia, Spain | |||
8624 | 8624 | 2020-10-25 | Spain | Galicia | 28711 | 859 | 9204 | 18648 | 42.5751 | -8.1339 | 2020-10-26 04:25:02 | Galicia, Spain | ||
12635 | 12635 | 2021-01-26 | Spain | Galicia | 88329 | 1635 | 9204 | 77490 | 42.5751 | -8.1339 | 2021-01-27 05:23:41 | Galicia, Spain | ||
16653 | 16653 | 2021-09-18 | Spain | Galicia | 185749 | 2611 | 0 | 42.5751 | -8.1339 | 2021-09-19 04:21:34 | Galicia, Spain | |||
20666 | 20666 | 2021-05-28 | Spain | Galicia | 126622 | 2402 | 9204 | 115016 | 42.5751 | -8.1339 | 2021-05-29 04:20:41 | Galicia, Spain | ||
24700 | 24700 | 2022-03-20 | Spain | Galicia | 557817 | 3157 | 0 | 42.5751 | -8.1339 | 2022-03-21 04:20:50 | Galicia, Spain | |||
28715 | 28715 | 2021-11-11 | Spain | Galicia | 188401 | 2652 | 0 | 42.5751 | -8.1339 | 2021-11-12 04:22:01 | Galicia, Spain | |||
32714 | 32714 | 2021-08-25 | Spain | Galicia | 179884 | 2537 | 0 | 42.5751 | -8.1339 | 2021-08-26 04:21:28 | Galicia, Spain | |||
36725 | 36725 | 2021-04-12 | Spain | Galicia | 118376 | 2356 | 9204 | 106816 | 42.5751 | -8.1339 | 2021-04-13 04:20:37 | Galicia, Spain | ||
44007 | 44007 | 2021-11-02 | Spain | Galicia | 187647 | 2649 | 0 | 42.5751 | -8.1339 | 2021-11-03 06:22:09 | Galicia, Spain | |||
51087 | 51087 | 2021-05-29 | Spain | Galicia | 126622 | 2402 | 9204 | 115016 | 42.5751 | -8.1339 | 2021-05-30 04:20:55 | Galicia, Spain | ||
55100 | 55100 | 2021-03-07 | Spain | Galicia | 112751 | 2239 | 9204 | 101308 | 42.5751 | -8.1339 | 2021-03-08 05:24:48 | Galicia, Spain | ||
61869 | 61869 | 2020-07-23 | Spain | Galicia | 9554 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-24 05:30:40 | Galicia, Spain | ||
63364 | 63364 | 2022-11-12 | Spain | Galicia | 737034 | 3942 | 0 | 42.5751 | -8.1339 | 2022-11-13 04:21:14 | Galicia, Spain | |||
67359 | 67359 | 2021-09-01 | Spain | Galicia | 182907 | 2567 | 0 | 42.5751 | -8.1339 | 2021-09-02 04:21:15 | Galicia, Spain | |||
71390 | 71390 | 2022-02-07 | Spain | Galicia | 480394 | 2969 | 0 | 42.5751 | -8.1339 | 2022-02-08 04:21:15 | Galicia, Spain | |||
75383 | 75383 | 2020-12-03 | Spain | Galicia | 51205 | 1232 | 9204 | 40769 | 42.5751 | -8.1339 | 2020-12-04 05:27:27 | Galicia, Spain | ||
79380 | 79380 | 2020-10-14 | Spain | Galicia | 25011 | 800 | 9204 | 15007 | 42.5751 | -8.1339 | 2020-10-15 04:24:28 | Galicia, Spain | ||
83390 | 83390 | 2021-05-25 | Spain | Galicia | 126181 | 2400 | 9204 | 114577 | 42.5751 | -8.1339 | 2021-05-26 04:20:35 | Galicia, Spain | ||
87424 | 87424 | 2021-11-09 | Spain | Galicia | 188088 | 2650 | 0 | 42.5751 | -8.1339 | 2021-11-10 04:21:38 | Galicia, Spain | |||
91442 | 91442 | 2022-07-23 | Spain | Galicia | 716013 | 3763 | 0 | 42.5751 | -8.1339 | 2022-07-24 04:20:47 | Galicia, Spain | |||
98209 | 98209 | 2020-08-04 | Spain | Galicia | 9845 | 619 | 9204 | 22 | 42.5751 | -8.1339 | 2020-08-05 04:34:43 | Galicia, Spain | ||
99625 | 99625 | 2022-01-14 | Spain | Galicia | 346321 | 2829 | 0 | 42.5751 | -8.1339 | 2022-01-15 04:21:07 | Galicia, Spain | |||
103624 | 103624 | 2021-08-15 | Spain | Galicia | 172612 | 2495 | 0 | 42.5751 | -8.1339 | 2021-08-16 04:21:31 | Galicia, Spain | |||
107749 | 107749 | 2021-06-19 | Spain | Galicia | 128511 | 2418 | 9204 | 116889 | 42.5751 | -8.1339 | 2021-06-20 04:21:48 | Galicia, Spain | ||
115052 | 115052 | 2022-09-06 | Spain | Galicia | 725572 | 3877 | 0 | 42.5751 | -8.1339 | 2022-09-07 04:20:59 | Galicia, Spain | |||
121802 | 121802 | 2020-07-19 | Spain | Galicia | 9494 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-20 05:34:40 | Galicia, Spain | ||
122998 | 122998 | 2020-11-18 | Spain | Galicia | 44755 | 1108 | 9204 | 34443 | 42.5751 | -8.1339 | 2020-11-19 05:25:23 | Galicia, Spain | ||
127032 | 127032 | 2022-01-09 | Spain | Galicia | 293755 | 2798 | 0 | 42.5751 | -8.1339 | 2022-01-10 04:22:07 | Galicia, Spain | |||
131052 | 131052 | 2022-10-04 | Spain | Galicia | 729459 | 3900 | 0 | 42.5751 | -8.1339 | 2022-10-05 04:23:06 | Galicia, Spain | |||
138270 | 138270 | 2021-12-04 | Spain | Galicia | 196638 | 2674 | 0 | 42.5751 | -8.1339 | 2021-12-05 04:22:25 | Galicia, Spain | |||
142288 | 142288 | 2022-07-09 | Spain | Galicia | 702908 | 3635 | 0 | 42.5751 | -8.1339 | 2022-07-10 04:20:54 | Galicia, Spain | |||
146263 | 146263 | 2020-08-15 | Spain | Galicia | 10741 | 623 | 9204 | 914 | 42.5751 | -8.1339 | 2020-08-16 04:27:42 | Galicia, Spain | ||
150283 | 150283 | 2021-11-29 | Spain | Galicia | 193599 | 2665 | 0 | 42.5751 | -8.1339 | 2021-11-30 04:22:53 | Galicia, Spain | |||
154277 | 154277 | 2021-01-08 | Spain | Galicia | 65479 | 1420 | 9204 | 54855 | 42.5751 | -8.1339 | 2021-01-09 05:22:18 | Galicia, Spain | ||
158312 | 158312 | 2022-03-29 | Spain | Galicia | 580041 | 3192 | 0 | 42.5751 | -8.1339 | 2022-03-30 04:20:45 | Galicia, Spain | |||
162327 | 162327 | 2021-11-19 | Spain | Galicia | 189397 | 2659 | 0 | 42.5751 | -8.1339 | 2021-11-20 04:22:17 | Galicia, Spain | |||
166345 | 166345 | 2022-06-21 | Spain | Galicia | 677443 | 3550 | 0 | 42.5751 | -8.1339 | 2022-06-22 04:20:54 | Galicia, Spain | |||
170339 | 170339 | 2021-04-16 | Spain | Galicia | 119178 | 2358 | 9204 | 107616 | 42.5751 | -8.1339 | 2021-04-17 04:20:40 | Galicia, Spain | ||
177120 | 177120 | 2020-07-27 | Spain | Galicia | 9635 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-28 04:58:43 | Galicia, Spain | ||
178324 | 178324 | 2021-09-02 | Spain | Galicia | 183247 | 2571 | 0 | 42.5751 | -8.1339 | 2021-09-03 04:21:20 | Galicia, Spain | |||
182335 | 182335 | 2021-02-21 | Spain | Galicia | 109544 | 2133 | 9204 | 98207 | 42.5751 | -8.1339 | 2021-02-22 05:24:21 | Galicia, Spain | ||
186370 | 186370 | 2022-02-13 | Spain | Galicia | 495632 | 3013 | 0 | 42.5751 | -8.1339 | 2022-02-14 04:20:51 | Galicia, Spain | |||
190363 | 190363 | 2021-01-11 | Spain | Galicia | 67842 | 1443 | 9204 | 57195 | 42.5751 | -8.1339 | 2021-01-12 05:22:15 | Galicia, Spain | ||
194358 | 194358 | 2020-08-31 | Spain | Galicia | 14513 | 641 | 9204 | 4668 | 42.5751 | -8.1339 | 2020-09-01 04:28:31 | Galicia, Spain | ||
198561 | 198561 | 2022-10-19 | Spain | Galicia | 731356 | 3915 | 0 | 42.5751 | -8.1339 | 2022-10-20 04:22:59 | Galicia, Spain | |||
202550 | 202550 | 2020-12-25 | Spain | Galicia | 58470 | 1335 | 9204 | 47931 | 42.5751 | -8.1339 | 2020-12-26 05:22:28 | Galicia, Spain | ||
206545 | 206545 | 2020-08-19 | Spain | Galicia | 11441 | 625 | 9204 | 1612 | 42.5751 | -8.1339 | 2020-08-20 04:27:43 | Galicia, Spain | ||
210533 | 210533 | 2020-10-29 | Spain | Galicia | 32560 | 895 | 9204 | 22461 | 42.5751 | -8.1339 | 2020-10-30 04:24:49 | Galicia, Spain | ||
217100 | 217100 | 2020-06-08 | Spain | Galicia | 9141 | 609 | 9204 | 0 | 42.5751 | -8.1339 | 2020-06-09 03:33:03 | Galicia, Spain | ||
218282 | 218282 | 2022-12-26 | Spain | Galicia | 744496 | 3992 | 0 | 42.5751 | -8.1339 | 2022-12-27 04:21:07 | Galicia, Spain | |||
222295 | 222295 | 2022-05-09 | Spain | Galicia | 636425 | 3378 | 0 | 42.5751 | -8.1339 | 2022-05-10 04:20:50 | Galicia, Spain | |||
229527 | 229527 | 2022-05-31 | Spain | Galicia | 653365 | 3473 | 0 | 42.5751 | -8.1339 | 2022-06-01 04:20:55 | Galicia, Spain | |||
233542 | 233542 | 2022-02-11 | Spain | Galicia | 495632 | 3013 | 0 | 42.5751 | -8.1339 | 2022-02-12 04:21:06 | Galicia, Spain | |||
237535 | 237535 | 2021-01-18 | Spain | Galicia | 75936 | 1505 | 9204 | 65227 | 42.5751 | -8.1339 | 2021-01-19 05:22:15 | Galicia, Spain | ||
241550 | 241550 | 2021-04-02 | Spain | Galicia | 116684 | 2327 | 9204 | 105153 | 42.5751 | -8.1339 | 2021-04-03 04:20:44 | Galicia, Spain | ||
245567 | 245567 | 2021-08-17 | Spain | Galicia | 175072 | 2505 | 0 | 42.5751 | -8.1339 | 2021-08-18 04:21:35 | Galicia, Spain | |||
249581 | 249581 | 2021-09-04 | Spain | Galicia | 183498 | 2574 | 0 | 42.5751 | -8.1339 | 2021-09-05 04:21:33 | Galicia, Spain | |||
253614 | 253614 | 2022-09-08 | Spain | Galicia | 725572 | 3877 | 0 | 42.5751 | -8.1339 | 2022-09-09 04:21:11 | Galicia, Spain | |||
257632 | 257632 | 2022-12-10 | Spain | Galicia | 741452 | 3973 | 0 | 42.5751 | -8.1339 | 2022-12-11 04:20:50 | Galicia, Spain | |||
261832 | 261832 | 2022-03-15 | Spain | Galicia | 553035 | 3149 | 0 | 42.5751 | -8.1339 | 2022-03-16 04:20:50 | Galicia, Spain | |||
268283 | 268283 | 2020-05-21 | Spain | Galicia | 9077 | 608 | 0 | 8469 | 42.5751 | -8.1339 | 2020-05-22 02:36:51 | Galicia, Spain | ||
272448 | 272448 | 2020-11-10 | Spain | Galicia | 39740 | 997 | 9204 | 29539 | 42.5751 | -8.1339 | 2020-11-11 05:25:30 | Galicia, Spain | ||
276482 | 276482 | 2021-11-03 | Spain | Galicia | 187696 | 2650 | 0 | 42.5751 | -8.1339 | 2021-11-04 04:22:20 | Galicia, Spain | |||
280478 | 280478 | 2021-02-24 | Spain | Galicia | 110899 | 2176 | 9204 | 99519 | 42.5751 | -8.1339 | 2021-02-25 05:24:57 | Galicia, Spain | ||
287088 | 287088 | 2020-06-15 | Spain | Galicia | 9160 | 609 | 9204 | 0 | 42.5751 | -8.1339 | 2020-06-16 04:33:09 | Galicia, Spain | ||
288295 | 288295 | 2021-10-31 | Spain | Galicia | 187512 | 2649 | 0 | 42.5751 | -8.1339 | 2021-11-01 04:22:01 | Galicia, Spain | |||
292315 | 292315 | 2022-11-15 | Spain | Galicia | 737034 | 3942 | 0 | 42.5751 | -8.1339 | 2022-11-16 04:21:09 | Galicia, Spain | |||
296310 | 296310 | 2021-07-15 | Spain | Galicia | 138214 | 2428 | 9204 | 126582 | 42.5751 | -8.1339 | 2021-07-16 04:21:22 | Galicia, Spain | ||
302960 | 302960 | 2020-07-01 | Spain | Galicia | 9222 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-02 04:33:46 | Galicia, Spain | ||
304168 | 304168 | 2022-04-16 | Spain | Galicia | 594525 | 3225 | 0 | 42.5751 | -8.1339 | 2022-04-17 04:20:59 | Galicia, Spain | |||
308187 | 308187 | 2022-12-13 | Spain | Galicia | 741452 | 3973 | 0 | 42.5751 | -8.1339 | 2022-12-14 04:21:04 | Galicia, Spain | |||
312203 | 312203 | 2022-11-13 | Spain | Galicia | 737034 | 3942 | 0 | 42.5751 | -8.1339 | 2022-11-14 04:21:09 | Galicia, Spain | |||
316216 | 316216 | 2022-02-12 | Spain | Galicia | 495632 | 3013 | 0 | 42.5751 | -8.1339 | 2022-02-13 04:21:00 | Galicia, Spain | |||
320235 | 320235 | 2022-10-30 | Spain | Galicia | 734556 | 3925 | 0 | 42.5751 | -8.1339 | 2022-10-31 04:21:36 | Galicia, Spain | |||
326897 | 326897 | 2020-07-20 | Spain | Galicia | 9510 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-21 04:38:46 | Galicia, Spain | ||
328209 | 328209 | 2022-12-27 | Spain | Galicia | 744496 | 3992 | 0 | 42.5751 | -8.1339 | 2022-12-28 04:21:04 | Galicia, Spain | |||
332204 | 332204 | 2021-08-04 | Spain | Galicia | 164131 | 2465 | 9204 | 152462 | 42.5751 | -8.1339 | 2021-08-05 04:21:51 | Galicia, Spain | ||
336236 | 336236 | 2022-03-18 | Spain | Galicia | 557817 | 3157 | 0 | 42.5751 | -8.1339 | 2022-03-19 04:20:47 | Galicia, Spain | |||
340570 | 340570 | 2021-02-03 | Spain | Galicia | 99399 | 1824 | 9204 | 88371 | 42.5751 | -8.1339 | 2021-02-04 05:22:26 | Galicia, Spain | ||
344566 | 344566 | 2020-09-14 | Spain | Galicia | 17877 | 687 | 9204 | 7986 | 42.5751 | -8.1339 | 2020-09-15 03:22:50 | Galicia, Spain | ||
348599 | 348599 | 2022-12-14 | Spain | Galicia | 741452 | 3973 | 0 | 42.5751 | -8.1339 | 2022-12-15 04:20:58 | Galicia, Spain | |||
352591 | 352591 | 2021-03-11 | Spain | Galicia | 113616 | 2261 | 9204 | 102151 | 42.5751 | -8.1339 | 2021-03-12 05:26:50 | Galicia, Spain | ||
356626 | 356626 | 2022-03-11 | Spain | Galicia | 547545 | 3136 | 0 | 42.5751 | -8.1339 | 2022-03-12 04:20:50 | Galicia, Spain | |||
360642 | 360642 | 2022-05-07 | Spain | Galicia | 631196 | 3355 | 0 | 42.5751 | -8.1339 | 2022-05-08 04:20:49 | Galicia, Spain | |||
367309 | 367309 | 2020-07-16 | Spain | Galicia | 9479 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-17 04:34:50 | Galicia, Spain | ||
371274 | 371274 | 2020-08-08 | Spain | Galicia | 10011 | 619 | 9204 | 188 | 42.5751 | -8.1339 | 2020-08-09 04:34:54 | Galicia, Spain | ||
372499 | 372499 | 2022-09-13 | Spain | Galicia | 726471 | 3886 | 0 | 42.5751 | -8.1339 | 2022-09-14 04:20:44 | Galicia, Spain | |||
376475 | 376475 | 2020-11-06 | Spain | Galicia | 38062 | 977 | 9204 | 27881 | 42.5751 | -8.1339 | 2020-11-07 05:24:52 | Galicia, Spain | ||
380488 | 380488 | 2021-04-30 | Spain | Galicia | 122010 | 2377 | 9204 | 110429 | 42.5751 | -8.1339 | 2021-05-01 04:20:47 | Galicia, Spain | ||
384526 | 384526 | 2022-09-23 | Spain | Galicia | 727958 | 3895 | 0 | 42.5751 | -8.1339 | 2022-09-24 04:21:40 | Galicia, Spain | |||
388518 | 388518 | 2021-04-04 | Spain | Galicia | 116967 | 2332 | 9204 | 105431 | 42.5751 | -8.1339 | 2021-04-05 04:20:35 | Galicia, Spain | ||
392529 | 392529 | 2020-11-27 | Spain | Galicia | 49183 | 1184 | 9204 | 38795 | 42.5751 | -8.1339 | 2020-11-28 05:25:50 | Galicia, Spain | ||
396567 | 396567 | 2022-10-07 | Spain | Galicia | 730080 | 3908 | 0 | 42.5751 | -8.1339 | 2022-10-08 04:22:56 | Galicia, Spain | |||
400562 | 400562 | 2021-06-29 | Spain | Galicia | 129735 | 2423 | 9204 | 118108 | 42.5751 | -8.1339 | 2021-06-30 04:21:41 | Galicia, Spain | ||
404593 | 404593 | 2021-12-07 | Spain | Galicia | 199745 | 2680 | 0 | 42.5751 | -8.1339 | 2021-12-08 04:22:46 | Galicia, Spain | |||
408592 | 408592 | 2021-07-28 | Spain | Galicia | 156041 | 2440 | 9204 | 144397 | 42.5751 | -8.1339 | 2021-07-29 04:21:33 | Galicia, Spain | ||
415252 | 415252 | 2020-07-05 | Spain | Galicia | 9251 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-06 04:33:57 | Galicia, Spain | ||
419638 | 419638 | 2022-09-18 | Spain | Galicia | 726962 | 3892 | 0 | 42.5751 | -8.1339 | 2022-09-19 04:21:49 | Galicia, 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]);