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 = "Puglia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005621 | 1005621 | 2020-07-09 | Italy | Puglia | 4536 | 546 | 3916 | 74 | 41.12559576 | 16.86736689 | 2020-07-10 04:34:24 | Puglia, Italy | ||
2222837 | 2222837 | 2020-07-08 | Italy | Puglia | 4536 | 546 | 3912 | 78 | 41.12559576 | 16.86736689 | 2020-07-09 04:34:23 | Puglia, Italy | ||
887446 | 887446 | 2020-07-07 | Italy | Puglia | 4535 | 546 | 3910 | 79 | 41.12559576 | 16.86736689 | 2020-07-08 05:33:48 | Puglia, Italy | ||
2685006 | 2685006 | 2020-07-06 | Italy | Puglia | 4536 | 545 | 3898 | 93 | 41.12559576 | 16.86736689 | 2020-07-07 04:34:00 | Puglia, Italy | ||
415471 | 415471 | 2020-07-05 | Italy | Puglia | 4536 | 545 | 3881 | 110 | 41.12559576 | 16.86736689 | 2020-07-06 04:33:57 | Puglia, Italy | ||
530033 | 530033 | 2020-07-04 | Italy | Puglia | 4536 | 545 | 3880 | 111 | 41.12559576 | 16.86736689 | 2020-07-05 04:33:46 | Puglia, Italy | ||
2234694 | 2234694 | 2020-07-03 | Italy | Puglia | 4533 | 545 | 3879 | 109 | 41.12559576 | 16.86736689 | 2020-07-04 04:33:51 | Puglia, Italy | ||
3045488 | 3045488 | 2020-07-02 | Italy | Puglia | 4530 | 545 | 3876 | 109 | 41.12559576 | 16.86736689 | 2020-07-03 04:33:54 | Puglia, Italy | ||
303179 | 303179 | 2020-07-01 | Italy | Puglia | 4530 | 545 | 3873 | 112 | 41.12559576 | 16.86736689 | 2020-07-02 04:33:46 | Puglia, Italy | ||
2974557 | 2974557 | 2020-06-30 | Italy | Puglia | 4531 | 545 | 3857 | 129 | 41.12559576 | 16.86736689 | 2020-07-01 04:33:52 | Puglia, Italy | ||
2633034 | 2633034 | 2020-06-29 | Italy | Puglia | 4531 | 543 | 3843 | 145 | 41.12559576 | 16.86736689 | 2020-06-30 04:33:48 | Puglia, Italy | ||
2306597 | 2306597 | 2020-06-28 | Italy | Puglia | 4531 | 543 | 3842 | 146 | 41.12559576 | 16.86736689 | 2020-06-29 04:33:44 | Puglia, Italy | ||
2039932 | 2039932 | 2020-06-27 | Italy | Puglia | 4531 | 543 | 3841 | 147 | 41.12559576 | 16.86736689 | 2020-06-28 04:34:04 | Puglia, Italy | ||
1136213 | 1136213 | 2020-06-26 | Italy | Puglia | 4531 | 543 | 3835 | 153 | 41.12559576 | 16.86736689 | 2020-06-27 04:33:35 | Puglia, Italy | ||
2625200 | 2625200 | 2020-06-25 | Italy | Puglia | 4530 | 543 | 3814 | 173 | 41.12559576 | 16.86736689 | 2020-06-26 04:33:43 | Puglia, Italy | ||
2700840 | 2700840 | 2020-06-24 | Italy | Puglia | 4529 | 543 | 3809 | 177 | 41.12559576 | 16.86736689 | 2020-06-25 05:26:54 | Puglia, Italy | ||
1522525 | 1522525 | 2020-06-23 | Italy | Puglia | 4529 | 542 | 3797 | 190 | 41.12559576 | 16.86736689 | 2020-06-24 04:33:28 | Puglia, Italy | ||
1510719 | 1510719 | 2020-06-22 | Italy | Puglia | 4527 | 540 | 3769 | 218 | 41.12559576 | 16.86736689 | 2020-06-23 04:33:22 | Puglia, Italy | ||
3249458 | 3249458 | 2020-06-21 | Italy | Puglia | 4527 | 540 | 3765 | 222 | 41.12559576 | 16.86736689 | 2020-06-22 04:33:20 | Puglia, Italy | ||
2438051 | 2438051 | 2020-06-20 | Italy | Puglia | 4525 | 540 | 3765 | 220 | 41.12559576 | 16.86736689 | 2020-06-21 04:33:19 | Puglia, Italy | ||
1691629 | 1691629 | 2020-06-19 | Italy | Puglia | 4520 | 538 | 3727 | 255 | 41.12559576 | 16.86736689 | 2020-06-20 04:33:19 | Puglia, Italy | ||
3682778 | 3682778 | 2020-06-18 | Italy | Puglia | 4519 | 538 | 3675 | 306 | 41.12559576 | 16.86736689 | 2020-06-19 04:33:17 | Puglia, Italy | ||
1195981 | 1195981 | 2020-06-17 | Italy | Puglia | 4516 | 536 | 3656 | 324 | 41.12559576 | 16.86736689 | 2020-06-18 04:33:18 | Puglia, Italy | ||
2386744 | 2386744 | 2020-06-16 | Italy | Puglia | 4516 | 535 | 3628 | 353 | 41.12559576 | 16.86736689 | 2020-06-17 04:33:21 | Puglia, Italy | ||
287307 | 287307 | 2020-06-15 | Italy | Puglia | 4516 | 534 | 3572 | 410 | 41.12559576 | 16.86736689 | 2020-06-16 04:33:09 | Puglia, Italy | ||
1837258 | 1837258 | 2020-06-14 | Italy | Puglia | 4515 | 532 | 3565 | 418 | 41.12559576 | 16.86736689 | 2020-06-15 03:33:14 | Puglia, Italy | ||
3061310 | 3061310 | 2020-06-13 | Italy | Puglia | 4515 | 532 | 3561 | 422 | 41.12559576 | 16.86736689 | 2020-06-14 03:33:15 | Puglia, Italy | ||
737630 | 737630 | 2020-06-12 | Italy | Puglia | 4515 | 532 | 3544 | 439 | 41.12559576 | 16.86736689 | 2020-06-13 03:33:14 | Puglia, Italy | ||
1273600 | 1273600 | 2020-06-11 | Italy | Puglia | 4513 | 530 | 3516 | 467 | 41.12559576 | 16.86736689 | 2020-06-12 05:09:52 | Puglia, Italy | ||
2864042 | 2864042 | 2020-06-10 | Italy | Puglia | 4512 | 529 | 3426 | 557 | 41.12559576 | 16.86736689 | 2020-06-11 03:33:41 | Puglia, Italy | ||
1210871 | 1210871 | 2020-06-09 | Italy | Puglia | 4512 | 526 | 3373 | 613 | 41.12559576 | 16.86736689 | 2020-06-10 04:07:00 | Puglia, Italy | ||
217298 | 217298 | 2020-06-08 | Italy | Puglia | 4512 | 525 | 3289 | 698 | 41.12559576 | 16.86736689 | 2020-06-09 03:33:03 | Puglia, Italy | ||
2800094 | 2800094 | 2020-06-07 | Italy | Puglia | 4511 | 525 | 3253 | 733 | 41.12559576 | 16.86736689 | 2020-06-08 03:33:22 | Puglia, Italy | ||
574150 | 574150 | 2020-06-06 | Italy | Puglia | 4511 | 522 | 3231 | 758 | 41.12559576 | 16.86736689 | 2020-06-07 03:53:30 | Puglia, Italy | ||
1269847 | 1269847 | 2020-06-05 | Italy | Puglia | 4507 | 521 | 3140 | 846 | 41.12559576 | 16.86736689 | 2020-06-06 02:33:00 | Puglia, Italy | ||
1281316 | 1281316 | 2020-06-04 | Italy | Puglia | 4503 | 514 | 3022 | 967 | 41.12559576 | 16.86736689 | 2020-06-05 02:33:06 | Puglia, Italy | ||
3866871 | 3866871 | 2020-06-03 | Italy | Puglia | 4499 | 511 | 2952 | 1036 | 41.12559576 | 16.86736689 | 2020-06-04 02:33:14 | Puglia, Italy | ||
2555913 | 2555913 | 2020-06-02 | Italy | Puglia | 4498 | 508 | 2939 | 1051 | 41.12559576 | 16.86736689 | 2020-06-03 02:33:13 | Puglia, Italy | ||
805450 | 805450 | 2020-06-01 | Italy | Puglia | 4498 | 506 | 2837 | 1155 | 41.12559576 | 16.86736689 | 2020-06-02 02:33:08 | Puglia, Italy | ||
1794020 | 1794020 | 2020-05-31 | Italy | Puglia | 4494 | 504 | 2813 | 1177 | 41.12559576 | 16.86736689 | 2020-06-01 02:32:46 | Puglia, Italy | ||
3638913 | 3638913 | 2020-05-30 | Italy | Puglia | 4490 | 500 | 2768 | 1222 | 41.12559576 | 16.86736689 | 2020-05-31 02:32:45 | Puglia, Italy | ||
1790454 | 1790454 | 2020-05-29 | Italy | Puglia | 4482 | 500 | 2699 | 1283 | 41.12559576 | 16.86736689 | 2020-05-30 02:32:48 | Puglia, Italy | ||
2712333 | 2712333 | 2020-05-28 | Italy | Puglia | 4481 | 496 | 2590 | 1395 | 41.12559576 | 16.86736689 | 2020-05-29 02:32:50 | Puglia, Italy | ||
2548279 | 2548279 | 2020-05-27 | Italy | Puglia | 4479 | 495 | 2471 | 1513 | 41.12559576 | 16.86736689 | 2020-05-28 02:32:31 | Puglia, Italy | ||
1041242 | 1041242 | 2020-05-26 | Italy | Puglia | 4469 | 494 | 2436 | 1539 | 41.12559576 | 16.86736689 | 2020-05-27 02:32:31 | Puglia, Italy | ||
1104972 | 1104972 | 2020-05-25 | Italy | Puglia | 4467 | 491 | 2298 | 1678 | 41.12559576 | 16.86736689 | 2020-05-26 02:32:35 | Puglia, Italy | ||
875652 | 875652 | 2020-05-24 | Italy | Puglia | 4458 | 487 | 2178 | 1793 | 41.12559576 | 16.86736689 | 2020-05-25 02:32:44 | Puglia, Italy | ||
997843 | 997843 | 2020-05-23 | Italy | Puglia | 4448 | 486 | 2157 | 1805 | 41.12559576 | 16.86736689 | 2020-05-24 02:32:43 | Puglia, Italy | ||
1864866 | 1864866 | 2020-05-22 | Italy | Puglia | 4440 | 482 | 2120 | 1838 | 41.12559576 | 16.86736689 | 2020-05-23 02:32:42 | Puglia, Italy | ||
268372 | 268372 | 2020-05-21 | Italy | Puglia | 4413 | 478 | 2096 | 1839 | 41.12559576 | 16.86736689 | 2020-05-22 02:36:51 | Puglia, Italy | ||
1431955 | 1431955 | 2020-05-20 | Italy | Puglia | 4407 | 478 | 2027 | 1902 | 41.12559576 | 16.86736689 | 2020-05-21 02:32:48 | Puglia, Italy | ||
2390197 | 2390197 | 2020-05-19 | Italy | Puglia | 4396 | 473 | 1982 | 1941 | 41.12559576 | 16.86736689 | 2020-05-20 02:32:19 | Puglia, Italy | ||
3260935 | 3260935 | 2020-05-18 | Italy | Puglia | 4386 | 471 | 1920 | 1995 | 41.12559576 | 16.86736689 | 2020-05-19 02:32:18 | Puglia, Italy | ||
3416329 | 3416329 | 2020-05-17 | Italy | Puglia | 4379 | 470 | 1892 | 2017 | 41.12559576 | 16.86736689 | 2020-05-18 02:32:21 | Puglia, Italy | ||
1829563 | 1829563 | 2020-05-16 | Italy | Puglia | 4374 | 463 | 1807 | 2104 | 41.12559576 | 16.86736689 | 2020-05-17 02:32:32 | Puglia, Italy | ||
3276279 | 3276279 | 2020-05-15 | Italy | Puglia | 4366 | 461 | 1724 | 2181 | 41.12559576 | 16.86736689 | 2020-05-16 02:32:19 | Puglia, Italy | ||
1404453 | 1404453 | 2020-05-14 | Italy | Puglia | 4357 | 461 | 1643 | 2253 | 41.12559576 | 16.86736689 | 2020-05-15 02:33:02 | Puglia, 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]);