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 = "Piemonte" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005611 | 1005611 | 2020-07-09 | Italy | Piemonte | 31475 | 4108 | 26243 | 1124 | 45.0732745 | 7.680687483 | 2020-07-10 04:34:24 | Piemonte, Italy | ||
2222827 | 2222827 | 2020-07-08 | Italy | Piemonte | 31459 | 4107 | 26212 | 1140 | 45.0732745 | 7.680687483 | 2020-07-09 04:34:23 | Piemonte, Italy | ||
887436 | 887436 | 2020-07-07 | Italy | Piemonte | 31434 | 4107 | 26154 | 1173 | 45.0732745 | 7.680687483 | 2020-07-08 05:33:48 | Piemonte, Italy | ||
2684996 | 2684996 | 2020-07-06 | Italy | Piemonte | 31429 | 4104 | 26117 | 1208 | 45.0732745 | 7.680687483 | 2020-07-07 04:34:00 | Piemonte, Italy | ||
415461 | 415461 | 2020-07-05 | Italy | Piemonte | 31423 | 4102 | 26104 | 1217 | 45.0732745 | 7.680687483 | 2020-07-06 04:33:57 | Piemonte, Italy | ||
530023 | 530023 | 2020-07-04 | Italy | Piemonte | 31405 | 4102 | 26086 | 1217 | 45.0732745 | 7.680687483 | 2020-07-05 04:33:46 | Piemonte, Italy | ||
2234684 | 2234684 | 2020-07-03 | Italy | Piemonte | 31394 | 4100 | 26019 | 1275 | 45.0732745 | 7.680687483 | 2020-07-04 04:33:51 | Piemonte, Italy | ||
3045478 | 3045478 | 2020-07-02 | Italy | Piemonte | 31378 | 4096 | 25983 | 1299 | 45.0732745 | 7.680687483 | 2020-07-03 04:33:54 | Piemonte, Italy | ||
303169 | 303169 | 2020-07-01 | Italy | Piemonte | 31365 | 4091 | 25921 | 1353 | 45.0732745 | 7.680687483 | 2020-07-02 04:33:46 | Piemonte, Italy | ||
2974547 | 2974547 | 2020-06-30 | Italy | Piemonte | 31349 | 4090 | 25836 | 1423 | 45.0732745 | 7.680687483 | 2020-07-01 04:33:52 | Piemonte, Italy | ||
2633024 | 2633024 | 2020-06-29 | Italy | Piemonte | 31338 | 4087 | 25761 | 1490 | 45.0732745 | 7.680687483 | 2020-06-30 04:33:48 | Piemonte, Italy | ||
2306587 | 2306587 | 2020-06-28 | Italy | Piemonte | 31336 | 4085 | 25756 | 1495 | 45.0732745 | 7.680687483 | 2020-06-29 04:33:44 | Piemonte, Italy | ||
2039922 | 2039922 | 2020-06-27 | Italy | Piemonte | 31322 | 4080 | 25739 | 1503 | 45.0732745 | 7.680687483 | 2020-06-28 04:34:04 | Piemonte, Italy | ||
1136203 | 1136203 | 2020-06-26 | Italy | Piemonte | 31311 | 4077 | 25649 | 1585 | 45.0732745 | 7.680687483 | 2020-06-27 04:33:35 | Piemonte, Italy | ||
2625190 | 2625190 | 2020-06-25 | Italy | Piemonte | 31296 | 4071 | 25544 | 1681 | 45.0732745 | 7.680687483 | 2020-06-26 04:33:43 | Piemonte, Italy | ||
2700830 | 2700830 | 2020-06-24 | Italy | Piemonte | 31276 | 4066 | 25480 | 1730 | 45.0732745 | 7.680687483 | 2020-06-25 05:26:54 | Piemonte, Italy | ||
1522515 | 1522515 | 2020-06-23 | Italy | Piemonte | 31254 | 4059 | 25325 | 1870 | 45.0732745 | 7.680687483 | 2020-06-24 04:33:28 | Piemonte, Italy | ||
1510709 | 1510709 | 2020-06-22 | Italy | Piemonte | 31248 | 4055 | 25223 | 1970 | 45.0732745 | 7.680687483 | 2020-06-23 04:33:22 | Piemonte, Italy | ||
3249448 | 3249448 | 2020-06-21 | Italy | Piemonte | 31241 | 4051 | 25177 | 2013 | 45.0732745 | 7.680687483 | 2020-06-22 04:33:20 | Piemonte, Italy | ||
2438041 | 2438041 | 2020-06-20 | Italy | Piemonte | 31215 | 4045 | 25082 | 2088 | 45.0732745 | 7.680687483 | 2020-06-21 04:33:19 | Piemonte, Italy | ||
1691619 | 1691619 | 2020-06-19 | Italy | Piemonte | 31188 | 4039 | 24971 | 2178 | 45.0732745 | 7.680687483 | 2020-06-20 04:33:19 | Piemonte, Italy | ||
3682768 | 3682768 | 2020-06-18 | Italy | Piemonte | 31162 | 4032 | 24840 | 2290 | 45.0732745 | 7.680687483 | 2020-06-19 04:33:17 | Piemonte, Italy | ||
1195971 | 1195971 | 2020-06-17 | Italy | Piemonte | 31131 | 4026 | 24720 | 2385 | 45.0732745 | 7.680687483 | 2020-06-18 04:33:18 | Piemonte, Italy | ||
2386734 | 2386734 | 2020-06-16 | Italy | Piemonte | 31090 | 4018 | 24622 | 2450 | 45.0732745 | 7.680687483 | 2020-06-17 04:33:21 | Piemonte, Italy | ||
287297 | 287297 | 2020-06-15 | Italy | Piemonte | 31061 | 4012 | 24445 | 2604 | 45.0732745 | 7.680687483 | 2020-06-16 04:33:09 | Piemonte, Italy | ||
1837248 | 1837248 | 2020-06-14 | Italy | Piemonte | 31059 | 4012 | 24399 | 2648 | 45.0732745 | 7.680687483 | 2020-06-15 03:33:14 | Piemonte, Italy | ||
3061300 | 3061300 | 2020-06-13 | Italy | Piemonte | 31029 | 4006 | 24203 | 2820 | 45.0732745 | 7.680687483 | 2020-06-14 03:33:15 | Piemonte, Italy | ||
737620 | 737620 | 2020-06-12 | Italy | Piemonte | 30989 | 3996 | 24096 | 2897 | 45.0732745 | 7.680687483 | 2020-06-13 03:33:14 | Piemonte, Italy | ||
1273590 | 1273590 | 2020-06-11 | Italy | Piemonte | 30958 | 3988 | 23787 | 3183 | 45.0732745 | 7.680687483 | 2020-06-12 05:09:52 | Piemonte, Italy | ||
2864032 | 2864032 | 2020-06-10 | Italy | Piemonte | 30916 | 3976 | 23568 | 3372 | 45.0732745 | 7.680687483 | 2020-06-11 03:33:41 | Piemonte, Italy | ||
1210862 | 1210862 | 2020-06-09 | Italy | Piemonte | 30890 | 3961 | 23258 | 3671 | 45.0732745 | 7.680687483 | 2020-06-10 04:07:00 | Piemonte, Italy | ||
217289 | 217289 | 2020-06-08 | Italy | Piemonte | 30869 | 3954 | 23049 | 3866 | 45.0732745 | 7.680687483 | 2020-06-09 03:33:03 | Piemonte, Italy | ||
2800085 | 2800085 | 2020-06-07 | Italy | Piemonte | 30855 | 3941 | 22952 | 3962 | 45.0732745 | 7.680687483 | 2020-06-08 03:33:22 | Piemonte, Italy | ||
574141 | 574141 | 2020-06-06 | Italy | Piemonte | 30845 | 3934 | 22744 | 4167 | 45.0732745 | 7.680687483 | 2020-06-07 03:53:30 | Piemonte, Italy | ||
1269838 | 1269838 | 2020-06-05 | Italy | Piemonte | 30807 | 3927 | 22511 | 4369 | 45.0732745 | 7.680687483 | 2020-06-06 02:33:00 | Piemonte, Italy | ||
1281307 | 1281307 | 2020-06-04 | Italy | Piemonte | 30758 | 3910 | 22292 | 4556 | 45.0732745 | 7.680687483 | 2020-06-05 02:33:06 | Piemonte, Italy | ||
3866862 | 3866862 | 2020-06-03 | Italy | Piemonte | 30734 | 3898 | 22150 | 4686 | 45.0732745 | 7.680687483 | 2020-06-04 02:33:14 | Piemonte, Italy | ||
2555904 | 2555904 | 2020-06-02 | Italy | Piemonte | 30715 | 3884 | 22003 | 4828 | 45.0732745 | 7.680687483 | 2020-06-03 02:33:13 | Piemonte, Italy | ||
805441 | 805441 | 2020-06-01 | Italy | Piemonte | 30658 | 3876 | 21720 | 5062 | 45.0732745 | 7.680687483 | 2020-06-02 02:33:08 | Piemonte, Italy | ||
1794014 | 1794014 | 2020-05-31 | Italy | Piemonte | 30637 | 3867 | 21609 | 5161 | 45.0732745 | 7.680687483 | 2020-06-01 02:32:46 | Piemonte, Italy | ||
3638907 | 3638907 | 2020-05-30 | Italy | Piemonte | 30583 | 3858 | 21435 | 5290 | 45.0732745 | 7.680687483 | 2020-05-31 02:32:45 | Piemonte, Italy | ||
1790448 | 1790448 | 2020-05-29 | Italy | Piemonte | 30501 | 3851 | 20992 | 5658 | 45.0732745 | 7.680687483 | 2020-05-30 02:32:48 | Piemonte, Italy | ||
2712327 | 2712327 | 2020-05-28 | Italy | Piemonte | 30445 | 3838 | 20535 | 6072 | 45.0732745 | 7.680687483 | 2020-05-29 02:32:50 | Piemonte, Italy | ||
2548275 | 2548275 | 2020-05-27 | Italy | Piemonte | 30387 | 3828 | 20095 | 6464 | 45.0732745 | 7.680687483 | 2020-05-28 02:32:31 | Piemonte, Italy | ||
1041238 | 1041238 | 2020-05-26 | Italy | Piemonte | 30314 | 3812 | 19561 | 6941 | 45.0732745 | 7.680687483 | 2020-05-27 02:32:31 | Piemonte, Italy | ||
1104968 | 1104968 | 2020-05-25 | Italy | Piemonte | 30228 | 3798 | 18934 | 7496 | 45.0732745 | 7.680687483 | 2020-05-26 02:32:35 | Piemonte, Italy | ||
875648 | 875648 | 2020-05-24 | Italy | Piemonte | 30180 | 3783 | 18694 | 7703 | 45.0732745 | 7.680687483 | 2020-05-25 02:32:44 | Piemonte, Italy | ||
997839 | 997839 | 2020-05-23 | Italy | Piemonte | 30137 | 3771 | 18341 | 8025 | 45.0732745 | 7.680687483 | 2020-05-24 02:32:43 | Piemonte, Italy | ||
1864862 | 1864862 | 2020-05-22 | Italy | Piemonte | 30077 | 3757 | 17868 | 8452 | 45.0732745 | 7.680687483 | 2020-05-23 02:32:42 | Piemonte, Italy | ||
268368 | 268368 | 2020-05-21 | Italy | Piemonte | 29990 | 3742 | 17538 | 8710 | 45.0732745 | 7.680687483 | 2020-05-22 02:36:51 | Piemonte, Italy | ||
1431951 | 1431951 | 2020-05-20 | Italy | Piemonte | 29885 | 3718 | 17016 | 9151 | 45.0732745 | 7.680687483 | 2020-05-21 02:32:48 | Piemonte, Italy | ||
2390194 | 2390194 | 2020-05-19 | Italy | Piemonte | 29727 | 3679 | 16413 | 9635 | 45.0732745 | 7.680687483 | 2020-05-20 02:32:19 | Piemonte, Italy | ||
3260932 | 3260932 | 2020-05-18 | Italy | Piemonte | 29619 | 3632 | 16113 | 9874 | 45.0732745 | 7.680687483 | 2020-05-19 02:32:18 | Piemonte, Italy | ||
3416326 | 3416326 | 2020-05-17 | Italy | Piemonte | 29547 | 3612 | 15696 | 10239 | 45.0732745 | 7.680687483 | 2020-05-18 02:32:21 | Piemonte, Italy | ||
1829560 | 1829560 | 2020-05-16 | Italy | Piemonte | 29483 | 3594 | 15187 | 10702 | 45.0732745 | 7.680687483 | 2020-05-17 02:32:32 | Piemonte, Italy | ||
3276276 | 3276276 | 2020-05-15 | Italy | Piemonte | 29346 | 3557 | 14676 | 11113 | 45.0732745 | 7.680687483 | 2020-05-16 02:32:19 | Piemonte, Italy | ||
1404450 | 1404450 | 2020-05-14 | Italy | Piemonte | 29209 | 3493 | 13825 | 11891 | 45.0732745 | 7.680687483 | 2020-05-15 02:33:02 | Piemonte, 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]);