johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Lombardia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005510 | 1005510 | 2020-07-09 | Italy | Lombardia | 94770 | 16730 | 69683 | 8357 | 45.46679409 | 9.190347404 | 2020-07-10 04:34:24 | Lombardia, Italy | ||
2222726 | 2222726 | 2020-07-08 | Italy | Lombardia | 94651 | 16725 | 69466 | 8460 | 45.46679409 | 9.190347404 | 2020-07-09 04:34:23 | Lombardia, Italy | ||
887335 | 887335 | 2020-07-07 | Italy | Lombardia | 94580 | 16713 | 68793 | 9074 | 45.46679409 | 9.190347404 | 2020-07-08 05:33:48 | Lombardia, Italy | ||
2684895 | 2684895 | 2020-07-06 | Italy | Lombardia | 94527 | 16700 | 68335 | 9492 | 45.46679409 | 9.190347404 | 2020-07-07 04:34:00 | Lombardia, Italy | ||
415360 | 415360 | 2020-07-05 | Italy | Lombardia | 94416 | 16697 | 68274 | 9445 | 45.46679409 | 9.190347404 | 2020-07-06 04:33:57 | Lombardia, Italy | ||
529922 | 529922 | 2020-07-04 | Italy | Lombardia | 94318 | 16691 | 68201 | 9426 | 45.46679409 | 9.190347404 | 2020-07-05 04:33:46 | Lombardia, Italy | ||
2234583 | 2234583 | 2020-07-03 | Italy | Lombardia | 94223 | 16675 | 67871 | 9677 | 45.46679409 | 9.190347404 | 2020-07-04 04:33:51 | Lombardia, Italy | ||
3045377 | 3045377 | 2020-07-02 | Italy | Lombardia | 94108 | 16671 | 67610 | 9827 | 45.46679409 | 9.190347404 | 2020-07-03 04:33:54 | Lombardia, Italy | ||
303068 | 303068 | 2020-07-01 | Italy | Lombardia | 94010 | 16650 | 67422 | 9938 | 45.46679409 | 9.190347404 | 2020-07-02 04:33:46 | Lombardia, Italy | ||
2974446 | 2974446 | 2020-06-30 | Italy | Lombardia | 93901 | 16644 | 67197 | 10060 | 45.46679409 | 9.190347404 | 2020-07-01 04:33:52 | Lombardia, Italy | ||
2632923 | 2632923 | 2020-06-29 | Italy | Lombardia | 93839 | 16640 | 66376 | 10823 | 45.46679409 | 9.190347404 | 2020-06-30 04:33:48 | Lombardia, Italy | ||
2306486 | 2306486 | 2020-06-28 | Italy | Lombardia | 93761 | 16639 | 66175 | 10947 | 45.46679409 | 9.190347404 | 2020-06-29 04:33:44 | Lombardia, Italy | ||
2039821 | 2039821 | 2020-06-27 | Italy | Lombardia | 93664 | 16626 | 66046 | 10992 | 45.46679409 | 9.190347404 | 2020-06-28 04:34:04 | Lombardia, Italy | ||
1136102 | 1136102 | 2020-06-26 | Italy | Lombardia | 93587 | 16624 | 65323 | 11640 | 45.46679409 | 9.190347404 | 2020-06-27 04:33:35 | Lombardia, Italy | ||
2625089 | 2625089 | 2020-06-25 | Italy | Lombardia | 93431 | 16608 | 64831 | 11992 | 45.46679409 | 9.190347404 | 2020-06-26 04:33:43 | Lombardia, Italy | ||
2700729 | 2700729 | 2020-06-24 | Italy | Lombardia | 93261 | 16586 | 64448 | 12227 | 45.46679409 | 9.190347404 | 2020-06-25 05:26:54 | Lombardia, Italy | ||
1522414 | 1522414 | 2020-06-23 | Italy | Lombardia | 93173 | 16579 | 63691 | 12903 | 45.46679409 | 9.190347404 | 2020-06-24 04:33:28 | Lombardia, Italy | ||
1510608 | 1510608 | 2020-06-22 | Italy | Lombardia | 93111 | 16573 | 62900 | 13638 | 45.46679409 | 9.190347404 | 2020-06-23 04:33:22 | Lombardia, Italy | ||
3249347 | 3249347 | 2020-06-21 | Italy | Lombardia | 92968 | 16570 | 62555 | 13843 | 45.46679409 | 9.190347404 | 2020-06-22 04:33:20 | Lombardia, Italy | ||
2437940 | 2437940 | 2020-06-20 | Italy | Lombardia | 92840 | 16557 | 62372 | 13911 | 45.46679409 | 9.190347404 | 2020-06-21 04:33:19 | Lombardia, Italy | ||
1691518 | 1691518 | 2020-06-19 | Italy | Lombardia | 92675 | 16534 | 62096 | 14045 | 45.46679409 | 9.190347404 | 2020-06-20 04:33:19 | Lombardia, Italy | ||
3682667 | 3682667 | 2020-06-18 | Italy | Lombardia | 92518 | 16516 | 61355 | 14647 | 45.46679409 | 9.190347404 | 2020-06-19 04:33:17 | Lombardia, Italy | ||
1195870 | 1195870 | 2020-06-17 | Italy | Lombardia | 92302 | 16480 | 60850 | 14972 | 45.46679409 | 9.190347404 | 2020-06-18 04:33:18 | Lombardia, Italy | ||
2386633 | 2386633 | 2020-06-16 | Italy | Lombardia | 92060 | 16466 | 60361 | 15233 | 45.46679409 | 9.190347404 | 2020-06-17 04:33:21 | Lombardia, Italy | ||
287196 | 287196 | 2020-06-15 | Italy | Lombardia | 91917 | 16457 | 59484 | 15976 | 45.46679409 | 9.190347404 | 2020-06-16 04:33:09 | Lombardia, Italy | ||
1837147 | 1837147 | 2020-06-14 | Italy | Lombardia | 91658 | 16449 | 59220 | 15989 | 45.46679409 | 9.190347404 | 2020-06-15 03:33:14 | Lombardia, Italy | ||
3061199 | 3061199 | 2020-06-13 | Italy | Lombardia | 91414 | 16428 | 58201 | 16785 | 45.46679409 | 9.190347404 | 2020-06-14 03:33:15 | Lombardia, Italy | ||
737519 | 737519 | 2020-06-12 | Italy | Lombardia | 91204 | 16405 | 57775 | 17024 | 45.46679409 | 9.190347404 | 2020-06-13 03:33:14 | Lombardia, Italy | ||
1273489 | 1273489 | 2020-06-11 | Italy | Lombardia | 90932 | 16374 | 57218 | 17340 | 45.46679409 | 9.190347404 | 2020-06-12 05:09:52 | Lombardia, Italy | ||
2863932 | 2863932 | 2020-06-10 | Italy | Lombardia | 90680 | 16349 | 56474 | 17857 | 45.46679409 | 9.190347404 | 2020-06-11 03:33:41 | Lombardia, Italy | ||
1210769 | 1210769 | 2020-06-09 | Italy | Lombardia | 90581 | 16317 | 55967 | 18297 | 45.46679409 | 9.190347404 | 2020-06-10 04:07:00 | Lombardia, Italy | ||
217196 | 217196 | 2020-06-08 | Italy | Lombardia | 90389 | 16302 | 54768 | 19319 | 45.46679409 | 9.190347404 | 2020-06-09 03:33:03 | Lombardia, Italy | ||
2799992 | 2799992 | 2020-06-07 | Italy | Lombardia | 90195 | 16270 | 54505 | 19420 | 45.46679409 | 9.190347404 | 2020-06-08 03:33:22 | Lombardia, Italy | ||
574048 | 574048 | 2020-06-06 | Italy | Lombardia | 90070 | 16249 | 54322 | 19499 | 45.46679409 | 9.190347404 | 2020-06-07 03:53:30 | Lombardia, Italy | ||
1269745 | 1269745 | 2020-06-05 | Italy | Lombardia | 89928 | 16222 | 53853 | 19853 | 45.46679409 | 9.190347404 | 2020-06-06 02:33:00 | Lombardia, Italy | ||
1281217 | 1281217 | 2020-06-04 | Italy | Lombardia | 89526 | 16201 | 53101 | 20224 | 45.46679409 | 9.190347404 | 2020-06-05 02:33:06 | Lombardia, Italy | ||
3866772 | 3866772 | 2020-06-03 | Italy | Lombardia | 89442 | 16172 | 53046 | 20224 | 45.46679409 | 9.190347404 | 2020-06-04 02:33:14 | Lombardia, Italy | ||
2555814 | 2555814 | 2020-06-02 | Italy | Lombardia | 89205 | 16143 | 52807 | 20255 | 45.46679409 | 9.190347404 | 2020-06-03 02:33:13 | Lombardia, Italy | ||
805351 | 805351 | 2020-06-01 | Italy | Lombardia | 89018 | 16131 | 52026 | 20861 | 45.46679409 | 9.190347404 | 2020-06-02 02:33:08 | Lombardia, Italy | ||
1793944 | 1793944 | 2020-05-31 | Italy | Lombardia | 88968 | 16112 | 51860 | 20996 | 45.46679409 | 9.190347404 | 2020-06-01 02:32:46 | Lombardia, Italy | ||
3638837 | 3638837 | 2020-05-30 | Italy | Lombardia | 88758 | 16079 | 50870 | 21809 | 45.46679409 | 9.190347404 | 2020-05-31 02:32:45 | Lombardia, Italy | ||
1790378 | 1790378 | 2020-05-29 | Italy | Lombardia | 88537 | 16012 | 49842 | 22683 | 45.46679409 | 9.190347404 | 2020-05-30 02:32:48 | Lombardia, Italy | ||
2712257 | 2712257 | 2020-05-28 | Italy | Lombardia | 88183 | 15974 | 49296 | 22913 | 45.46679409 | 9.190347404 | 2020-05-29 02:32:50 | Lombardia, Italy | ||
2548224 | 2548224 | 2020-05-27 | Italy | Lombardia | 87801 | 15954 | 47810 | 24037 | 45.46679409 | 9.190347404 | 2020-05-28 02:32:31 | Lombardia, Italy | ||
1041187 | 1041187 | 2020-05-26 | Italy | Lombardia | 87417 | 15896 | 47044 | 24477 | 45.46679409 | 9.190347404 | 2020-05-27 02:32:31 | Lombardia, Italy | ||
1104917 | 1104917 | 2020-05-25 | Italy | Lombardia | 87258 | 15874 | 46169 | 25215 | 45.46679409 | 9.190347404 | 2020-05-26 02:32:35 | Lombardia, Italy | ||
875597 | 875597 | 2020-05-24 | Italy | Lombardia | 87110 | 15840 | 45656 | 25614 | 45.46679409 | 9.190347404 | 2020-05-25 02:32:44 | Lombardia, Italy | ||
997788 | 997788 | 2020-05-23 | Italy | Lombardia | 86825 | 15840 | 45355 | 25630 | 45.46679409 | 9.190347404 | 2020-05-24 02:32:43 | Lombardia, Italy | ||
1864811 | 1864811 | 2020-05-22 | Italy | Lombardia | 86384 | 15784 | 44667 | 25933 | 45.46679409 | 9.190347404 | 2020-05-23 02:32:42 | Lombardia, Italy | ||
268317 | 268317 | 2020-05-21 | Italy | Lombardia | 86091 | 15727 | 43649 | 26715 | 45.46679409 | 9.190347404 | 2020-05-22 02:36:51 | Lombardia, Italy | ||
1431900 | 1431900 | 2020-05-20 | Italy | Lombardia | 85775 | 15662 | 43442 | 26671 | 45.46679409 | 9.190347404 | 2020-05-21 02:32:48 | Lombardia, Italy | ||
2390165 | 2390165 | 2020-05-19 | Italy | Lombardia | 85481 | 15597 | 42593 | 27291 | 45.46679409 | 9.190347404 | 2020-05-20 02:32:19 | Lombardia, Italy | ||
3260903 | 3260903 | 2020-05-18 | Italy | Lombardia | 85019 | 15543 | 42403 | 27073 | 45.46679409 | 9.190347404 | 2020-05-19 02:32:18 | Lombardia, Italy | ||
3416297 | 3416297 | 2020-05-17 | Italy | Lombardia | 84844 | 15519 | 41895 | 27430 | 45.46679409 | 9.190347404 | 2020-05-18 02:32:21 | Lombardia, Italy | ||
1829531 | 1829531 | 2020-05-16 | Italy | Lombardia | 84518 | 15450 | 41389 | 27679 | 45.46679409 | 9.190347404 | 2020-05-17 02:32:32 | Lombardia, Italy | ||
3276247 | 3276247 | 2020-05-15 | Italy | Lombardia | 84119 | 15411 | 40962 | 27746 | 45.46679409 | 9.190347404 | 2020-05-16 02:32:19 | Lombardia, Italy | ||
1404421 | 1404421 | 2020-05-14 | Italy | Lombardia | 83820 | 15296 | 38568 | 29956 | 45.46679409 | 9.190347404 | 2020-05-15 02:33:02 | Lombardia, Italy |
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]);