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 = "P.A. Bolzano" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005600 | 1005600 | 2020-07-09 | Italy | P.A. Bolzano | 2653 | 292 | 2277 | 84 | 46.49933453 | 11.35662422 | 2020-07-10 04:34:24 | P.A. Bolzano, Italy | ||
2222816 | 2222816 | 2020-07-08 | Italy | P.A. Bolzano | 2650 | 292 | 2275 | 83 | 46.49933453 | 11.35662422 | 2020-07-09 04:34:23 | P.A. Bolzano, Italy | ||
887425 | 887425 | 2020-07-07 | Italy | P.A. Bolzano | 2648 | 292 | 2273 | 83 | 46.49933453 | 11.35662422 | 2020-07-08 05:33:48 | P.A. Bolzano, Italy | ||
2684985 | 2684985 | 2020-07-06 | Italy | P.A. Bolzano | 2647 | 292 | 2272 | 83 | 46.49933453 | 11.35662422 | 2020-07-07 04:34:00 | P.A. Bolzano, Italy | ||
415450 | 415450 | 2020-07-05 | Italy | P.A. Bolzano | 2647 | 292 | 2270 | 85 | 46.49933453 | 11.35662422 | 2020-07-06 04:33:57 | P.A. Bolzano, Italy | ||
530012 | 530012 | 2020-07-04 | Italy | P.A. Bolzano | 2645 | 292 | 2268 | 85 | 46.49933453 | 11.35662422 | 2020-07-05 04:33:46 | P.A. Bolzano, Italy | ||
2234673 | 2234673 | 2020-07-03 | Italy | P.A. Bolzano | 2642 | 292 | 2267 | 83 | 46.49933453 | 11.35662422 | 2020-07-04 04:33:51 | P.A. Bolzano, Italy | ||
3045467 | 3045467 | 2020-07-02 | Italy | P.A. Bolzano | 2642 | 292 | 2266 | 84 | 46.49933453 | 11.35662422 | 2020-07-03 04:33:54 | P.A. Bolzano, Italy | ||
303158 | 303158 | 2020-07-01 | Italy | P.A. Bolzano | 2642 | 292 | 2266 | 84 | 46.49933453 | 11.35662422 | 2020-07-02 04:33:46 | P.A. Bolzano, Italy | ||
2974536 | 2974536 | 2020-06-30 | Italy | P.A. Bolzano | 2639 | 292 | 2263 | 84 | 46.49933453 | 11.35662422 | 2020-07-01 04:33:52 | P.A. Bolzano, Italy | ||
2633013 | 2633013 | 2020-06-29 | Italy | P.A. Bolzano | 2639 | 292 | 2262 | 85 | 46.49933453 | 11.35662422 | 2020-06-30 04:33:48 | P.A. Bolzano, Italy | ||
2306576 | 2306576 | 2020-06-28 | Italy | P.A. Bolzano | 2637 | 292 | 2260 | 85 | 46.49933453 | 11.35662422 | 2020-06-29 04:33:44 | P.A. Bolzano, Italy | ||
2039911 | 2039911 | 2020-06-27 | Italy | P.A. Bolzano | 2636 | 292 | 2257 | 87 | 46.49933453 | 11.35662422 | 2020-06-28 04:34:04 | P.A. Bolzano, Italy | ||
1136192 | 1136192 | 2020-06-26 | Italy | P.A. Bolzano | 2634 | 292 | 2257 | 85 | 46.49933453 | 11.35662422 | 2020-06-27 04:33:35 | P.A. Bolzano, Italy | ||
2625179 | 2625179 | 2020-06-25 | Italy | P.A. Bolzano | 2634 | 292 | 2255 | 87 | 46.49933453 | 11.35662422 | 2020-06-26 04:33:43 | P.A. Bolzano, Italy | ||
2700819 | 2700819 | 2020-06-24 | Italy | P.A. Bolzano | 2634 | 292 | 2252 | 90 | 46.49933453 | 11.35662422 | 2020-06-25 05:26:54 | P.A. Bolzano, Italy | ||
1522504 | 1522504 | 2020-06-23 | Italy | P.A. Bolzano | 2633 | 292 | 2252 | 89 | 46.49933453 | 11.35662422 | 2020-06-24 04:33:28 | P.A. Bolzano, Italy | ||
1510698 | 1510698 | 2020-06-22 | Italy | P.A. Bolzano | 2633 | 292 | 2252 | 89 | 46.49933453 | 11.35662422 | 2020-06-23 04:33:22 | P.A. Bolzano, Italy | ||
3249437 | 3249437 | 2020-06-21 | Italy | P.A. Bolzano | 2622 | 292 | 2255 | 75 | 46.49933453 | 11.35662422 | 2020-06-22 04:33:20 | P.A. Bolzano, Italy | ||
2438030 | 2438030 | 2020-06-20 | Italy | P.A. Bolzano | 2618 | 292 | 2250 | 76 | 46.49933453 | 11.35662422 | 2020-06-21 04:33:19 | P.A. Bolzano, Italy | ||
1691608 | 1691608 | 2020-06-19 | Italy | P.A. Bolzano | 2615 | 292 | 2248 | 75 | 46.49933453 | 11.35662422 | 2020-06-20 04:33:19 | P.A. Bolzano, Italy | ||
3682757 | 3682757 | 2020-06-18 | Italy | P.A. Bolzano | 2613 | 292 | 2236 | 85 | 46.49933453 | 11.35662422 | 2020-06-19 04:33:17 | P.A. Bolzano, Italy | ||
1195960 | 1195960 | 2020-06-17 | Italy | P.A. Bolzano | 2611 | 292 | 2232 | 87 | 46.49933453 | 11.35662422 | 2020-06-18 04:33:18 | P.A. Bolzano, Italy | ||
2386723 | 2386723 | 2020-06-16 | Italy | P.A. Bolzano | 2611 | 292 | 2226 | 93 | 46.49933453 | 11.35662422 | 2020-06-17 04:33:21 | P.A. Bolzano, Italy | ||
287286 | 287286 | 2020-06-15 | Italy | P.A. Bolzano | 2611 | 292 | 2225 | 94 | 46.49933453 | 11.35662422 | 2020-06-16 04:33:09 | P.A. Bolzano, Italy | ||
1837237 | 1837237 | 2020-06-14 | Italy | P.A. Bolzano | 2613 | 291 | 2227 | 95 | 46.49933453 | 11.35662422 | 2020-06-15 03:33:14 | P.A. Bolzano, Italy | ||
3061289 | 3061289 | 2020-06-13 | Italy | P.A. Bolzano | 2610 | 291 | 2224 | 95 | 46.49933453 | 11.35662422 | 2020-06-14 03:33:15 | P.A. Bolzano, Italy | ||
737609 | 737609 | 2020-06-12 | Italy | P.A. Bolzano | 2608 | 291 | 2216 | 101 | 46.49933453 | 11.35662422 | 2020-06-13 03:33:14 | P.A. Bolzano, Italy | ||
1273579 | 1273579 | 2020-06-11 | Italy | P.A. Bolzano | 2606 | 292 | 2215 | 99 | 46.49933453 | 11.35662422 | 2020-06-12 05:09:52 | P.A. Bolzano, Italy | ||
2864021 | 2864021 | 2020-06-10 | Italy | P.A. Bolzano | 2604 | 292 | 2218 | 94 | 46.49933453 | 11.35662422 | 2020-06-11 03:33:41 | P.A. Bolzano, Italy | ||
1210851 | 1210851 | 2020-06-09 | Italy | P.A. Bolzano | 2604 | 292 | 2217 | 95 | 46.49933453 | 11.35662422 | 2020-06-10 04:07:00 | P.A. Bolzano, Italy | ||
217278 | 217278 | 2020-06-08 | Italy | P.A. Bolzano | 2604 | 292 | 2215 | 97 | 46.49933453 | 11.35662422 | 2020-06-09 03:33:03 | P.A. Bolzano, Italy | ||
2800074 | 2800074 | 2020-06-07 | Italy | P.A. Bolzano | 2603 | 292 | 2214 | 97 | 46.49933453 | 11.35662422 | 2020-06-08 03:33:22 | P.A. Bolzano, Italy | ||
574130 | 574130 | 2020-06-06 | Italy | P.A. Bolzano | 2600 | 292 | 2208 | 100 | 46.49933453 | 11.35662422 | 2020-06-07 03:53:30 | P.A. Bolzano, Italy | ||
1269827 | 1269827 | 2020-06-05 | Italy | P.A. Bolzano | 2599 | 292 | 2206 | 101 | 46.49933453 | 11.35662422 | 2020-06-06 02:33:00 | P.A. Bolzano, Italy | ||
1281296 | 1281296 | 2020-06-04 | Italy | P.A. Bolzano | 2598 | 292 | 2194 | 112 | 46.49933453 | 11.35662422 | 2020-06-05 02:33:06 | P.A. Bolzano, Italy | ||
3866851 | 3866851 | 2020-06-03 | Italy | P.A. Bolzano | 2598 | 291 | 2187 | 120 | 46.49933453 | 11.35662422 | 2020-06-04 02:33:14 | P.A. Bolzano, Italy | ||
2555893 | 2555893 | 2020-06-02 | Italy | P.A. Bolzano | 2598 | 291 | 2187 | 120 | 46.49933453 | 11.35662422 | 2020-06-03 02:33:13 | P.A. Bolzano, Italy | ||
805430 | 805430 | 2020-06-01 | Italy | P.A. Bolzano | 2598 | 291 | 2184 | 123 | 46.49933453 | 11.35662422 | 2020-06-02 02:33:08 | P.A. Bolzano, Italy | ||
1794005 | 1794005 | 2020-05-31 | Italy | P.A. Bolzano | 2597 | 291 | 2179 | 127 | 46.49933453 | 11.35662422 | 2020-06-01 02:32:46 | P.A. Bolzano, Italy | ||
3638898 | 3638898 | 2020-05-30 | Italy | P.A. Bolzano | 2596 | 291 | 2168 | 137 | 46.49933453 | 11.35662422 | 2020-05-31 02:32:45 | P.A. Bolzano, Italy | ||
1790439 | 1790439 | 2020-05-29 | Italy | P.A. Bolzano | 2595 | 291 | 2150 | 154 | 46.49933453 | 11.35662422 | 2020-05-30 02:32:48 | P.A. Bolzano, Italy | ||
2712318 | 2712318 | 2020-05-28 | Italy | P.A. Bolzano | 2595 | 291 | 2147 | 157 | 46.49933453 | 11.35662422 | 2020-05-29 02:32:50 | P.A. Bolzano, Italy | ||
2548267 | 2548267 | 2020-05-27 | Italy | P.A. Bolzano | 2593 | 291 | 2131 | 171 | 46.49933453 | 11.35662422 | 2020-05-28 02:32:31 | P.A. Bolzano, Italy | ||
1041230 | 1041230 | 2020-05-26 | Italy | P.A. Bolzano | 2593 | 291 | 2123 | 179 | 46.49933453 | 11.35662422 | 2020-05-27 02:32:31 | P.A. Bolzano, Italy | ||
1104960 | 1104960 | 2020-05-25 | Italy | P.A. Bolzano | 2593 | 291 | 2118 | 184 | 46.49933453 | 11.35662422 | 2020-05-26 02:32:35 | P.A. Bolzano, Italy | ||
875640 | 875640 | 2020-05-24 | Italy | P.A. Bolzano | 2593 | 291 | 2107 | 195 | 46.49933453 | 11.35662422 | 2020-05-25 02:32:44 | P.A. Bolzano, Italy | ||
997831 | 997831 | 2020-05-23 | Italy | P.A. Bolzano | 2590 | 291 | 2085 | 214 | 46.49933453 | 11.35662422 | 2020-05-24 02:32:43 | P.A. Bolzano, Italy | ||
1864854 | 1864854 | 2020-05-22 | Italy | P.A. Bolzano | 2590 | 291 | 2075 | 224 | 46.49933453 | 11.35662422 | 2020-05-23 02:32:42 | P.A. Bolzano, Italy | ||
268360 | 268360 | 2020-05-21 | Italy | P.A. Bolzano | 2587 | 291 | 2046 | 250 | 46.49933453 | 11.35662422 | 2020-05-22 02:36:51 | P.A. Bolzano, Italy | ||
1431943 | 1431943 | 2020-05-20 | Italy | P.A. Bolzano | 2587 | 291 | 2024 | 272 | 46.49933453 | 11.35662422 | 2020-05-21 02:32:48 | P.A. Bolzano, Italy | ||
2390191 | 2390191 | 2020-05-19 | Italy | P.A. Bolzano | 2587 | 291 | 1988 | 308 | 46.49933453 | 11.35662422 | 2020-05-20 02:32:19 | P.A. Bolzano, Italy | ||
3260929 | 3260929 | 2020-05-18 | Italy | P.A. Bolzano | 2582 | 291 | 1984 | 307 | 46.49933453 | 11.35662422 | 2020-05-19 02:32:18 | P.A. Bolzano, Italy | ||
3416323 | 3416323 | 2020-05-17 | Italy | P.A. Bolzano | 2581 | 290 | 1977 | 314 | 46.49933453 | 11.35662422 | 2020-05-18 02:32:21 | P.A. Bolzano, Italy | ||
1829557 | 1829557 | 2020-05-16 | Italy | P.A. Bolzano | 2578 | 290 | 1945 | 343 | 46.49933453 | 11.35662422 | 2020-05-17 02:32:32 | P.A. Bolzano, Italy | ||
3276273 | 3276273 | 2020-05-15 | Italy | P.A. Bolzano | 2578 | 290 | 1929 | 359 | 46.49933453 | 11.35662422 | 2020-05-16 02:32:19 | P.A. Bolzano, Italy | ||
1404447 | 1404447 | 2020-05-14 | Italy | P.A. Bolzano | 2578 | 290 | 1908 | 380 | 46.49933453 | 11.35662422 | 2020-05-15 02:33:02 | P.A. Bolzano, 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]);