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 = "Marche" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005527 | 1005527 | 2020-07-09 | Italy | Marche | 6798 | 987 | 5638 | 173 | 43.61675973 | 13.5188753 | 2020-07-10 04:34:24 | Marche, Italy | ||
2222743 | 2222743 | 2020-07-08 | Italy | Marche | 6794 | 987 | 5623 | 184 | 43.61675973 | 13.5188753 | 2020-07-09 04:34:23 | Marche, Italy | ||
887352 | 887352 | 2020-07-07 | Italy | Marche | 6791 | 987 | 5619 | 185 | 43.61675973 | 13.5188753 | 2020-07-08 05:33:48 | Marche, Italy | ||
2684912 | 2684912 | 2020-07-06 | Italy | Marche | 6790 | 987 | 5614 | 189 | 43.61675973 | 13.5188753 | 2020-07-07 04:34:00 | Marche, Italy | ||
415377 | 415377 | 2020-07-05 | Italy | Marche | 6790 | 987 | 5609 | 194 | 43.61675973 | 13.5188753 | 2020-07-06 04:33:57 | Marche, Italy | ||
529939 | 529939 | 2020-07-04 | Italy | Marche | 6789 | 987 | 5599 | 203 | 43.61675973 | 13.5188753 | 2020-07-05 04:33:46 | Marche, Italy | ||
2234600 | 2234600 | 2020-07-03 | Italy | Marche | 6789 | 987 | 5575 | 227 | 43.61675973 | 13.5188753 | 2020-07-04 04:33:51 | Marche, Italy | ||
3045394 | 3045394 | 2020-07-02 | Italy | Marche | 6789 | 987 | 5564 | 238 | 43.61675973 | 13.5188753 | 2020-07-03 04:33:54 | Marche, Italy | ||
303085 | 303085 | 2020-07-01 | Italy | Marche | 6786 | 987 | 5551 | 248 | 43.61675973 | 13.5188753 | 2020-07-02 04:33:46 | Marche, Italy | ||
2974463 | 2974463 | 2020-06-30 | Italy | Marche | 6785 | 991 | 5528 | 266 | 43.61675973 | 13.5188753 | 2020-07-01 04:33:52 | Marche, Italy | ||
2632940 | 2632940 | 2020-06-29 | Italy | Marche | 6785 | 991 | 5520 | 274 | 43.61675973 | 13.5188753 | 2020-06-30 04:33:48 | Marche, Italy | ||
2306503 | 2306503 | 2020-06-28 | Italy | Marche | 6785 | 991 | 5474 | 320 | 43.61675973 | 13.5188753 | 2020-06-29 04:33:44 | Marche, Italy | ||
2039838 | 2039838 | 2020-06-27 | Italy | Marche | 6785 | 991 | 5437 | 357 | 43.61675973 | 13.5188753 | 2020-06-28 04:34:04 | Marche, Italy | ||
1136119 | 1136119 | 2020-06-26 | Italy | Marche | 6783 | 991 | 5385 | 407 | 43.61675973 | 13.5188753 | 2020-06-27 04:33:35 | Marche, Italy | ||
2625106 | 2625106 | 2020-06-25 | Italy | Marche | 6781 | 991 | 5330 | 460 | 43.61675973 | 13.5188753 | 2020-06-26 04:33:43 | Marche, Italy | ||
2700746 | 2700746 | 2020-06-24 | Italy | Marche | 6779 | 994 | 5314 | 471 | 43.61675973 | 13.5188753 | 2020-06-25 05:26:54 | Marche, Italy | ||
1522431 | 1522431 | 2020-06-23 | Italy | Marche | 6775 | 994 | 5288 | 493 | 43.61675973 | 13.5188753 | 2020-06-24 04:33:28 | Marche, Italy | ||
1510625 | 1510625 | 2020-06-22 | Italy | Marche | 6774 | 994 | 5275 | 505 | 43.61675973 | 13.5188753 | 2020-06-23 04:33:22 | Marche, Italy | ||
3249364 | 3249364 | 2020-06-21 | Italy | Marche | 6768 | 994 | 5247 | 527 | 43.61675973 | 13.5188753 | 2020-06-22 04:33:20 | Marche, Italy | ||
2437957 | 2437957 | 2020-06-20 | Italy | Marche | 6768 | 994 | 5235 | 539 | 43.61675973 | 13.5188753 | 2020-06-21 04:33:19 | Marche, Italy | ||
1691535 | 1691535 | 2020-06-19 | Italy | Marche | 6768 | 994 | 5214 | 560 | 43.61675973 | 13.5188753 | 2020-06-20 04:33:19 | Marche, Italy | ||
3682684 | 3682684 | 2020-06-18 | Italy | Marche | 6768 | 994 | 5197 | 577 | 43.61675973 | 13.5188753 | 2020-06-19 04:33:17 | Marche, Italy | ||
1195887 | 1195887 | 2020-06-17 | Italy | Marche | 6764 | 994 | 5185 | 585 | 43.61675973 | 13.5188753 | 2020-06-18 04:33:18 | Marche, Italy | ||
2386650 | 2386650 | 2020-06-16 | Italy | Marche | 6763 | 994 | 5168 | 601 | 43.61675973 | 13.5188753 | 2020-06-17 04:33:21 | Marche, Italy | ||
287213 | 287213 | 2020-06-15 | Italy | Marche | 6762 | 993 | 5152 | 617 | 43.61675973 | 13.5188753 | 2020-06-16 04:33:09 | Marche, Italy | ||
1837164 | 1837164 | 2020-06-14 | Italy | Marche | 6758 | 993 | 5139 | 626 | 43.61675973 | 13.5188753 | 2020-06-15 03:33:14 | Marche, Italy | ||
3061216 | 3061216 | 2020-06-13 | Italy | Marche | 6754 | 993 | 5084 | 677 | 43.61675973 | 13.5188753 | 2020-06-14 03:33:15 | Marche, Italy | ||
737536 | 737536 | 2020-06-12 | Italy | Marche | 6752 | 993 | 5009 | 750 | 43.61675973 | 13.5188753 | 2020-06-13 03:33:14 | Marche, Italy | ||
1273506 | 1273506 | 2020-06-11 | Italy | Marche | 6751 | 992 | 4857 | 902 | 43.61675973 | 13.5188753 | 2020-06-12 05:09:52 | Marche, Italy | ||
2863949 | 2863949 | 2020-06-10 | Italy | Marche | 6750 | 992 | 4811 | 947 | 43.61675973 | 13.5188753 | 2020-06-11 03:33:41 | Marche, Italy | ||
1210783 | 1210783 | 2020-06-09 | Italy | Marche | 6747 | 992 | 4763 | 992 | 43.61675973 | 13.5188753 | 2020-06-10 04:07:00 | Marche, Italy | ||
217210 | 217210 | 2020-06-08 | Italy | Marche | 6747 | 991 | 4681 | 1075 | 43.61675973 | 13.5188753 | 2020-06-09 03:33:03 | Marche, Italy | ||
2800006 | 2800006 | 2020-06-07 | Italy | Marche | 6745 | 991 | 4595 | 1159 | 43.61675973 | 13.5188753 | 2020-06-08 03:33:22 | Marche, Italy | ||
574062 | 574062 | 2020-06-06 | Italy | Marche | 6742 | 991 | 4556 | 1195 | 43.61675973 | 13.5188753 | 2020-06-07 03:53:30 | Marche, Italy | ||
1269759 | 1269759 | 2020-06-05 | Italy | Marche | 6740 | 989 | 4458 | 1293 | 43.61675973 | 13.5188753 | 2020-06-06 02:33:00 | Marche, Italy | ||
1281231 | 1281231 | 2020-06-04 | Italy | Marche | 6738 | 988 | 4447 | 1303 | 43.61675973 | 13.5188753 | 2020-06-05 02:33:06 | Marche, Italy | ||
3866786 | 3866786 | 2020-06-03 | Italy | Marche | 6735 | 987 | 4438 | 1310 | 43.61675973 | 13.5188753 | 2020-06-04 02:33:14 | Marche, Italy | ||
2555828 | 2555828 | 2020-06-02 | Italy | Marche | 6734 | 987 | 4421 | 1326 | 43.61675973 | 13.5188753 | 2020-06-03 02:33:13 | Marche, Italy | ||
805365 | 805365 | 2020-06-01 | Italy | Marche | 6730 | 987 | 4416 | 1327 | 43.61675973 | 13.5188753 | 2020-06-02 02:33:08 | Marche, Italy | ||
1793955 | 1793955 | 2020-05-31 | Italy | Marche | 6730 | 987 | 4405 | 1338 | 43.61675973 | 13.5188753 | 2020-06-01 02:32:46 | Marche, Italy | ||
3638848 | 3638848 | 2020-05-30 | Italy | Marche | 6727 | 987 | 4393 | 1347 | 43.61675973 | 13.5188753 | 2020-05-31 02:32:45 | Marche, Italy | ||
1790389 | 1790389 | 2020-05-29 | Italy | Marche | 6723 | 986 | 4385 | 1352 | 43.61675973 | 13.5188753 | 2020-05-30 02:32:48 | Marche, Italy | ||
2712268 | 2712268 | 2020-05-28 | Italy | Marche | 6719 | 997 | 4376 | 1346 | 43.61675973 | 13.5188753 | 2020-05-29 02:32:50 | Marche, Italy | ||
2548232 | 2548232 | 2020-05-27 | Italy | Marche | 6718 | 996 | 4272 | 1450 | 43.61675973 | 13.5188753 | 2020-05-28 02:32:31 | Marche, Italy | ||
1041195 | 1041195 | 2020-05-26 | Italy | Marche | 6718 | 996 | 4147 | 1575 | 43.61675973 | 13.5188753 | 2020-05-27 02:32:31 | Marche, Italy | ||
1104925 | 1104925 | 2020-05-25 | Italy | Marche | 6716 | 995 | 4059 | 1662 | 43.61675973 | 13.5188753 | 2020-05-26 02:32:35 | Marche, Italy | ||
875605 | 875605 | 2020-05-24 | Italy | Marche | 6714 | 994 | 4028 | 1692 | 43.61675973 | 13.5188753 | 2020-05-25 02:32:44 | Marche, Italy | ||
997796 | 997796 | 2020-05-23 | Italy | Marche | 6701 | 993 | 3995 | 1713 | 43.61675973 | 13.5188753 | 2020-05-24 02:32:43 | Marche, Italy | ||
1864819 | 1864819 | 2020-05-22 | Italy | Marche | 6697 | 990 | 3939 | 1768 | 43.61675973 | 13.5188753 | 2020-05-23 02:32:42 | Marche, Italy | ||
268325 | 268325 | 2020-05-21 | Italy | Marche | 6689 | 990 | 3867 | 1832 | 43.61675973 | 13.5188753 | 2020-05-22 02:36:51 | Marche, Italy | ||
1431908 | 1431908 | 2020-05-20 | Italy | Marche | 6677 | 987 | 3716 | 1974 | 43.61675973 | 13.5188753 | 2020-05-21 02:32:48 | Marche, Italy | ||
2390169 | 2390169 | 2020-05-19 | Italy | Marche | 6675 | 986 | 3561 | 2128 | 43.61675973 | 13.5188753 | 2020-05-20 02:32:19 | Marche, Italy | ||
3260907 | 3260907 | 2020-05-18 | Italy | Marche | 6678 | 984 | 3379 | 2315 | 43.61675973 | 13.5188753 | 2020-05-19 02:32:18 | Marche, Italy | ||
3416301 | 3416301 | 2020-05-17 | Italy | Marche | 6667 | 984 | 3118 | 2565 | 43.61675973 | 13.5188753 | 2020-05-18 02:32:21 | Marche, Italy | ||
1829535 | 1829535 | 2020-05-16 | Italy | Marche | 6642 | 982 | 3003 | 2657 | 43.61675973 | 13.5188753 | 2020-05-17 02:32:32 | Marche, Italy | ||
3276251 | 3276251 | 2020-05-15 | Italy | Marche | 6619 | 977 | 2847 | 2795 | 43.61675973 | 13.5188753 | 2020-05-16 02:32:19 | Marche, Italy | ||
1404425 | 1404425 | 2020-05-14 | Italy | Marche | 6603 | 974 | 2725 | 2904 | 43.61675973 | 13.5188753 | 2020-05-15 02:33:02 | Marche, 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]);