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 = "Abruzzo" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005267 | 1005267 | 2020-07-09 | Italy | Abruzzo | 3318 | 464 | 2707 | 147 | 42.35122196 | 13.39843823 | 2020-07-10 04:34:24 | Abruzzo, Italy | ||
2222483 | 2222483 | 2020-07-08 | Italy | Abruzzo | 3310 | 464 | 2701 | 145 | 42.35122196 | 13.39843823 | 2020-07-09 04:34:23 | Abruzzo, Italy | ||
887092 | 887092 | 2020-07-07 | Italy | Abruzzo | 3309 | 464 | 2692 | 153 | 42.35122196 | 13.39843823 | 2020-07-08 05:33:48 | Abruzzo, Italy | ||
2684652 | 2684652 | 2020-07-06 | Italy | Abruzzo | 3309 | 464 | 2689 | 156 | 42.35122196 | 13.39843823 | 2020-07-07 04:34:00 | Abruzzo, Italy | ||
415117 | 415117 | 2020-07-05 | Italy | Abruzzo | 3309 | 464 | 2682 | 163 | 42.35122196 | 13.39843823 | 2020-07-06 04:33:57 | Abruzzo, Italy | ||
529679 | 529679 | 2020-07-04 | Italy | Abruzzo | 3305 | 464 | 2682 | 159 | 42.35122196 | 13.39843823 | 2020-07-05 04:33:46 | Abruzzo, Italy | ||
2234340 | 2234340 | 2020-07-03 | Italy | Abruzzo | 3298 | 464 | 2678 | 156 | 42.35122196 | 13.39843823 | 2020-07-04 04:33:51 | Abruzzo, Italy | ||
3045134 | 3045134 | 2020-07-02 | Italy | Abruzzo | 3292 | 464 | 2668 | 160 | 42.35122196 | 13.39843823 | 2020-07-03 04:33:54 | Abruzzo, Italy | ||
302825 | 302825 | 2020-07-01 | Italy | Abruzzo | 3289 | 464 | 2655 | 170 | 42.35122196 | 13.39843823 | 2020-07-02 04:33:46 | Abruzzo, Italy | ||
2974203 | 2974203 | 2020-06-30 | Italy | Abruzzo | 3287 | 464 | 2626 | 197 | 42.35122196 | 13.39843823 | 2020-07-01 04:33:52 | Abruzzo, Italy | ||
2632680 | 2632680 | 2020-06-29 | Italy | Abruzzo | 3287 | 462 | 2543 | 282 | 42.35122196 | 13.39843823 | 2020-06-30 04:33:48 | Abruzzo, Italy | ||
2306243 | 2306243 | 2020-06-28 | Italy | Abruzzo | 3286 | 462 | 2540 | 284 | 42.35122196 | 13.39843823 | 2020-06-29 04:33:44 | Abruzzo, Italy | ||
2039578 | 2039578 | 2020-06-27 | Italy | Abruzzo | 3285 | 461 | 2487 | 337 | 42.35122196 | 13.39843823 | 2020-06-28 04:34:04 | Abruzzo, Italy | ||
1135859 | 1135859 | 2020-06-26 | Italy | Abruzzo | 3285 | 461 | 2466 | 358 | 42.35122196 | 13.39843823 | 2020-06-27 04:33:35 | Abruzzo, Italy | ||
2624846 | 2624846 | 2020-06-25 | Italy | Abruzzo | 3284 | 461 | 2452 | 371 | 42.35122196 | 13.39843823 | 2020-06-26 04:33:43 | Abruzzo, Italy | ||
2700486 | 2700486 | 2020-06-24 | Italy | Abruzzo | 3283 | 461 | 2444 | 378 | 42.35122196 | 13.39843823 | 2020-06-25 05:26:54 | Abruzzo, Italy | ||
1522171 | 1522171 | 2020-06-23 | Italy | Abruzzo | 3282 | 460 | 2431 | 391 | 42.35122196 | 13.39843823 | 2020-06-24 04:33:28 | Abruzzo, Italy | ||
1510365 | 1510365 | 2020-06-22 | Italy | Abruzzo | 3282 | 460 | 2428 | 394 | 42.35122196 | 13.39843823 | 2020-06-23 04:33:22 | Abruzzo, Italy | ||
3249104 | 3249104 | 2020-06-21 | Italy | Abruzzo | 3281 | 459 | 2419 | 403 | 42.35122196 | 13.39843823 | 2020-06-22 04:33:20 | Abruzzo, Italy | ||
2437697 | 2437697 | 2020-06-20 | Italy | Abruzzo | 3281 | 459 | 2418 | 404 | 42.35122196 | 13.39843823 | 2020-06-21 04:33:19 | Abruzzo, Italy | ||
1691275 | 1691275 | 2020-06-19 | Italy | Abruzzo | 3280 | 459 | 2414 | 407 | 42.35122196 | 13.39843823 | 2020-06-20 04:33:19 | Abruzzo, Italy | ||
3682424 | 3682424 | 2020-06-18 | Italy | Abruzzo | 3281 | 458 | 2389 | 434 | 42.35122196 | 13.39843823 | 2020-06-19 04:33:17 | Abruzzo, Italy | ||
1195627 | 1195627 | 2020-06-17 | Italy | Abruzzo | 3281 | 457 | 2386 | 438 | 42.35122196 | 13.39843823 | 2020-06-18 04:33:18 | Abruzzo, Italy | ||
2386390 | 2386390 | 2020-06-16 | Italy | Abruzzo | 3280 | 457 | 2355 | 468 | 42.35122196 | 13.39843823 | 2020-06-17 04:33:21 | Abruzzo, Italy | ||
286953 | 286953 | 2020-06-15 | Italy | Abruzzo | 3279 | 456 | 2337 | 486 | 42.35122196 | 13.39843823 | 2020-06-16 04:33:09 | Abruzzo, Italy | ||
1836904 | 1836904 | 2020-06-14 | Italy | Abruzzo | 3279 | 456 | 2312 | 511 | 42.35122196 | 13.39843823 | 2020-06-15 03:33:14 | Abruzzo, Italy | ||
3060956 | 3060956 | 2020-06-13 | Italy | Abruzzo | 3275 | 454 | 2312 | 509 | 42.35122196 | 13.39843823 | 2020-06-14 03:33:15 | Abruzzo, Italy | ||
737276 | 737276 | 2020-06-12 | Italy | Abruzzo | 3271 | 453 | 2290 | 528 | 42.35122196 | 13.39843823 | 2020-06-13 03:33:14 | Abruzzo, Italy | ||
1273246 | 1273246 | 2020-06-11 | Italy | Abruzzo | 3267 | 453 | 2275 | 539 | 42.35122196 | 13.39843823 | 2020-06-12 05:09:52 | Abruzzo, Italy | ||
2863690 | 2863690 | 2020-06-10 | Italy | Abruzzo | 3266 | 453 | 2263 | 550 | 42.35122196 | 13.39843823 | 2020-06-11 03:33:41 | Abruzzo, Italy | ||
1210550 | 1210550 | 2020-06-09 | Italy | Abruzzo | 3266 | 451 | 2248 | 567 | 42.35122196 | 13.39843823 | 2020-06-10 04:07:00 | Abruzzo, Italy | ||
216977 | 216977 | 2020-06-08 | Italy | Abruzzo | 3265 | 418 | 2215 | 632 | 42.35122196 | 13.39843823 | 2020-06-09 03:33:03 | Abruzzo, Italy | ||
2799774 | 2799774 | 2020-06-07 | Italy | Abruzzo | 3265 | 418 | 2194 | 653 | 42.35122196 | 13.39843823 | 2020-06-08 03:33:22 | Abruzzo, Italy | ||
573830 | 573830 | 2020-06-06 | Italy | Abruzzo | 3258 | 418 | 2187 | 653 | 42.35122196 | 13.39843823 | 2020-06-07 03:53:30 | Abruzzo, Italy | ||
1269527 | 1269527 | 2020-06-05 | Italy | Abruzzo | 3257 | 415 | 2172 | 670 | 42.35122196 | 13.39843823 | 2020-06-06 02:33:00 | Abruzzo, Italy | ||
1281008 | 1281008 | 2020-06-04 | Italy | Abruzzo | 3255 | 415 | 2136 | 704 | 42.35122196 | 13.39843823 | 2020-06-05 02:33:06 | Abruzzo, Italy | ||
3866563 | 3866563 | 2020-06-03 | Italy | Abruzzo | 3252 | 414 | 2102 | 736 | 42.35122196 | 13.39843823 | 2020-06-04 02:33:14 | Abruzzo, Italy | ||
2555606 | 2555606 | 2020-06-02 | Italy | Abruzzo | 3249 | 413 | 2093 | 743 | 42.35122196 | 13.39843823 | 2020-06-03 02:33:13 | Abruzzo, Italy | ||
805142 | 805142 | 2020-06-01 | Italy | Abruzzo | 3245 | 408 | 2093 | 744 | 42.35122196 | 13.39843823 | 2020-06-02 02:33:08 | Abruzzo, Italy | ||
1793787 | 1793787 | 2020-05-31 | Italy | Abruzzo | 3222 | 405 | 2064 | 753 | 42.35122196 | 13.39843823 | 2020-06-01 02:32:46 | Abruzzo, Italy | ||
3638680 | 3638680 | 2020-05-30 | Italy | Abruzzo | 3237 | 404 | 2063 | 770 | 42.35122196 | 13.39843823 | 2020-05-31 02:32:45 | Abruzzo, Italy | ||
1790221 | 1790221 | 2020-05-29 | Italy | Abruzzo | 3237 | 404 | 2063 | 770 | 42.35122196 | 13.39843823 | 2020-05-30 02:32:48 | Abruzzo, Italy | ||
2712101 | 2712101 | 2020-05-28 | Italy | Abruzzo | 3237 | 402 | 2011 | 824 | 42.35122196 | 13.39843823 | 2020-05-29 02:32:50 | Abruzzo, Italy | ||
2548121 | 2548121 | 2020-05-27 | Italy | Abruzzo | 3235 | 400 | 1969 | 866 | 42.35122196 | 13.39843823 | 2020-05-28 02:32:31 | Abruzzo, Italy | ||
1041084 | 1041084 | 2020-05-26 | Italy | Abruzzo | 3230 | 400 | 1921 | 909 | 42.35122196 | 13.39843823 | 2020-05-27 02:32:31 | Abruzzo, Italy | ||
1104814 | 1104814 | 2020-05-25 | Italy | Abruzzo | 3227 | 400 | 1781 | 1046 | 42.35122196 | 13.39843823 | 2020-05-26 02:32:35 | Abruzzo, Italy | ||
875494 | 875494 | 2020-05-24 | Italy | Abruzzo | 3226 | 398 | 1736 | 1092 | 42.35122196 | 13.39843823 | 2020-05-25 02:32:44 | Abruzzo, Italy | ||
997685 | 997685 | 2020-05-23 | Italy | Abruzzo | 3221 | 394 | 1659 | 1168 | 42.35122196 | 13.39843823 | 2020-05-24 02:32:43 | Abruzzo, Italy | ||
1864708 | 1864708 | 2020-05-22 | Italy | Abruzzo | 3220 | 394 | 1647 | 1179 | 42.35122196 | 13.39843823 | 2020-05-23 02:32:42 | Abruzzo, Italy | ||
268214 | 268214 | 2020-05-21 | Italy | Abruzzo | 3212 | 391 | 1549 | 1272 | 42.35122196 | 13.39843823 | 2020-05-22 02:36:51 | Abruzzo, Italy | ||
1431797 | 1431797 | 2020-05-20 | Italy | Abruzzo | 3205 | 389 | 1499 | 1317 | 42.35122196 | 13.39843823 | 2020-05-21 02:32:48 | Abruzzo, Italy | ||
2390091 | 2390091 | 2020-05-19 | Italy | Abruzzo | 3197 | 389 | 1419 | 1389 | 42.35122196 | 13.39843823 | 2020-05-20 02:32:19 | Abruzzo, Italy | ||
3260830 | 3260830 | 2020-05-18 | Italy | Abruzzo | 3193 | 388 | 1392 | 1413 | 42.35122196 | 13.39843823 | 2020-05-19 02:32:18 | Abruzzo, Italy | ||
3416224 | 3416224 | 2020-05-17 | Italy | Abruzzo | 3186 | 385 | 1379 | 1422 | 42.35122196 | 13.39843823 | 2020-05-18 02:32:21 | Abruzzo, Italy | ||
1829458 | 1829458 | 2020-05-16 | Italy | Abruzzo | 3178 | 383 | 1372 | 1423 | 42.35122196 | 13.39843823 | 2020-05-17 02:32:32 | Abruzzo, Italy | ||
3276174 | 3276174 | 2020-05-15 | Italy | Abruzzo | 3148 | 381 | 1313 | 1454 | 42.35122196 | 13.39843823 | 2020-05-16 02:32:19 | Abruzzo, Italy | ||
1404348 | 1404348 | 2020-05-14 | Italy | Abruzzo | 3136 | 379 | 1275 | 1482 | 42.35122196 | 13.39843823 | 2020-05-15 02:33:02 | Abruzzo, 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]);