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 = "Basilicata" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005316 | 1005316 | 2020-07-09 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-10 04:34:24 | Basilicata, Italy | ||
2222532 | 2222532 | 2020-07-08 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-09 04:34:23 | Basilicata, Italy | ||
887141 | 887141 | 2020-07-07 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-08 05:33:48 | Basilicata, Italy | ||
2684701 | 2684701 | 2020-07-06 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-07 04:34:00 | Basilicata, Italy | ||
415166 | 415166 | 2020-07-05 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-06 04:33:57 | Basilicata, Italy | ||
529728 | 529728 | 2020-07-04 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-05 04:33:46 | Basilicata, Italy | ||
2234389 | 2234389 | 2020-07-03 | Italy | Basilicata | 404 | 27 | 373 | 4 | 40.63947052 | 15.80514834 | 2020-07-04 04:33:51 | Basilicata, Italy | ||
3045183 | 3045183 | 2020-07-02 | Italy | Basilicata | 402 | 27 | 373 | 2 | 40.63947052 | 15.80514834 | 2020-07-03 04:33:54 | Basilicata, Italy | ||
302874 | 302874 | 2020-07-01 | Italy | Basilicata | 402 | 27 | 373 | 2 | 40.63947052 | 15.80514834 | 2020-07-02 04:33:46 | Basilicata, Italy | ||
2974252 | 2974252 | 2020-06-30 | Italy | Basilicata | 402 | 27 | 372 | 3 | 40.63947052 | 15.80514834 | 2020-07-01 04:33:52 | Basilicata, Italy | ||
2632729 | 2632729 | 2020-06-29 | Italy | Basilicata | 402 | 27 | 372 | 3 | 40.63947052 | 15.80514834 | 2020-06-30 04:33:48 | Basilicata, Italy | ||
2306292 | 2306292 | 2020-06-28 | Italy | Basilicata | 401 | 27 | 372 | 2 | 40.63947052 | 15.80514834 | 2020-06-29 04:33:44 | Basilicata, Italy | ||
2039627 | 2039627 | 2020-06-27 | Italy | Basilicata | 401 | 27 | 367 | 7 | 40.63947052 | 15.80514834 | 2020-06-28 04:34:04 | Basilicata, Italy | ||
1135908 | 1135908 | 2020-06-26 | Italy | Basilicata | 401 | 27 | 367 | 7 | 40.63947052 | 15.80514834 | 2020-06-27 04:33:35 | Basilicata, Italy | ||
2624895 | 2624895 | 2020-06-25 | Italy | Basilicata | 401 | 27 | 367 | 7 | 40.63947052 | 15.80514834 | 2020-06-26 04:33:43 | Basilicata, Italy | ||
2700535 | 2700535 | 2020-06-24 | Italy | Basilicata | 401 | 27 | 367 | 7 | 40.63947052 | 15.80514834 | 2020-06-25 05:26:54 | Basilicata, Italy | ||
1522220 | 1522220 | 2020-06-23 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-24 04:33:28 | Basilicata, Italy | ||
1510414 | 1510414 | 2020-06-22 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-23 04:33:22 | Basilicata, Italy | ||
3249153 | 3249153 | 2020-06-21 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-22 04:33:20 | Basilicata, Italy | ||
2437746 | 2437746 | 2020-06-20 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-21 04:33:19 | Basilicata, Italy | ||
1691324 | 1691324 | 2020-06-19 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-20 04:33:19 | Basilicata, Italy | ||
3682473 | 3682473 | 2020-06-18 | Italy | Basilicata | 401 | 27 | 364 | 10 | 40.63947052 | 15.80514834 | 2020-06-19 04:33:17 | Basilicata, Italy | ||
1195676 | 1195676 | 2020-06-17 | Italy | Basilicata | 401 | 27 | 364 | 10 | 40.63947052 | 15.80514834 | 2020-06-18 04:33:18 | Basilicata, Italy | ||
2386439 | 2386439 | 2020-06-16 | Italy | Basilicata | 401 | 27 | 364 | 10 | 40.63947052 | 15.80514834 | 2020-06-17 04:33:21 | Basilicata, Italy | ||
287002 | 287002 | 2020-06-15 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-16 04:33:09 | Basilicata, Italy | ||
1836953 | 1836953 | 2020-06-14 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-15 03:33:14 | Basilicata, Italy | ||
3061005 | 3061005 | 2020-06-13 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-14 03:33:15 | Basilicata, Italy | ||
737325 | 737325 | 2020-06-12 | Italy | Basilicata | 401 | 27 | 362 | 12 | 40.63947052 | 15.80514834 | 2020-06-13 03:33:14 | Basilicata, Italy | ||
1273295 | 1273295 | 2020-06-11 | Italy | Basilicata | 401 | 27 | 362 | 12 | 40.63947052 | 15.80514834 | 2020-06-12 05:09:52 | Basilicata, Italy | ||
2863739 | 2863739 | 2020-06-10 | Italy | Basilicata | 400 | 27 | 362 | 11 | 40.63947052 | 15.80514834 | 2020-06-11 03:33:41 | Basilicata, Italy | ||
1210593 | 1210593 | 2020-06-09 | Italy | Basilicata | 400 | 27 | 359 | 14 | 40.63947052 | 15.80514834 | 2020-06-10 04:07:00 | Basilicata, Italy | ||
217020 | 217020 | 2020-06-08 | Italy | Basilicata | 399 | 27 | 359 | 13 | 40.63947052 | 15.80514834 | 2020-06-09 03:33:03 | Basilicata, Italy | ||
2799817 | 2799817 | 2020-06-07 | Italy | Basilicata | 399 | 27 | 358 | 14 | 40.63947052 | 15.80514834 | 2020-06-08 03:33:22 | Basilicata, Italy | ||
573873 | 573873 | 2020-06-06 | Italy | Basilicata | 399 | 27 | 355 | 17 | 40.63947052 | 15.80514834 | 2020-06-07 03:53:30 | Basilicata, Italy | ||
1269570 | 1269570 | 2020-06-05 | Italy | Basilicata | 399 | 27 | 354 | 18 | 40.63947052 | 15.80514834 | 2020-06-06 02:33:00 | Basilicata, Italy | ||
1281051 | 1281051 | 2020-06-04 | Italy | Basilicata | 399 | 27 | 352 | 20 | 40.63947052 | 15.80514834 | 2020-06-05 02:33:06 | Basilicata, Italy | ||
3866606 | 3866606 | 2020-06-03 | Italy | Basilicata | 399 | 27 | 349 | 23 | 40.63947052 | 15.80514834 | 2020-06-04 02:33:14 | Basilicata, Italy | ||
2555649 | 2555649 | 2020-06-02 | Italy | Basilicata | 399 | 27 | 348 | 24 | 40.63947052 | 15.80514834 | 2020-06-03 02:33:13 | Basilicata, Italy | ||
805185 | 805185 | 2020-06-01 | Italy | Basilicata | 399 | 27 | 344 | 28 | 40.63947052 | 15.80514834 | 2020-06-02 02:33:08 | Basilicata, Italy | ||
1793823 | 1793823 | 2020-05-31 | Italy | Basilicata | 399 | 27 | 343 | 29 | 40.63947052 | 15.80514834 | 2020-06-01 02:32:46 | Basilicata, Italy | ||
3638716 | 3638716 | 2020-05-30 | Italy | Basilicata | 399 | 27 | 341 | 31 | 40.63947052 | 15.80514834 | 2020-05-31 02:32:45 | Basilicata, Italy | ||
1790257 | 1790257 | 2020-05-29 | Italy | Basilicata | 399 | 27 | 339 | 33 | 40.63947052 | 15.80514834 | 2020-05-30 02:32:48 | Basilicata, Italy | ||
2712137 | 2712137 | 2020-05-28 | Italy | Basilicata | 399 | 27 | 338 | 34 | 40.63947052 | 15.80514834 | 2020-05-29 02:32:50 | Basilicata, Italy | ||
2548145 | 2548145 | 2020-05-27 | Italy | Basilicata | 399 | 27 | 336 | 36 | 40.63947052 | 15.80514834 | 2020-05-28 02:32:31 | Basilicata, Italy | ||
1041108 | 1041108 | 2020-05-26 | Italy | Basilicata | 399 | 27 | 336 | 36 | 40.63947052 | 15.80514834 | 2020-05-27 02:32:31 | Basilicata, Italy | ||
1104838 | 1104838 | 2020-05-25 | Italy | Basilicata | 399 | 27 | 336 | 36 | 40.63947052 | 15.80514834 | 2020-05-26 02:32:35 | Basilicata, Italy | ||
875518 | 875518 | 2020-05-24 | Italy | Basilicata | 399 | 27 | 333 | 39 | 40.63947052 | 15.80514834 | 2020-05-25 02:32:44 | Basilicata, Italy | ||
997709 | 997709 | 2020-05-23 | Italy | Basilicata | 398 | 27 | 330 | 41 | 40.63947052 | 15.80514834 | 2020-05-24 02:32:43 | Basilicata, Italy | ||
1864732 | 1864732 | 2020-05-22 | Italy | Basilicata | 394 | 27 | 318 | 49 | 40.63947052 | 15.80514834 | 2020-05-23 02:32:42 | Basilicata, Italy | ||
268238 | 268238 | 2020-05-21 | Italy | Basilicata | 394 | 27 | 307 | 60 | 40.63947052 | 15.80514834 | 2020-05-22 02:36:51 | Basilicata, Italy | ||
1431821 | 1431821 | 2020-05-20 | Italy | Basilicata | 393 | 27 | 293 | 73 | 40.63947052 | 15.80514834 | 2020-05-21 02:32:48 | Basilicata, Italy | ||
2390102 | 2390102 | 2020-05-19 | Italy | Basilicata | 393 | 27 | 282 | 84 | 40.63947052 | 15.80514834 | 2020-05-20 02:32:19 | Basilicata, Italy | ||
3260841 | 3260841 | 2020-05-18 | Italy | Basilicata | 392 | 27 | 272 | 93 | 40.63947052 | 15.80514834 | 2020-05-19 02:32:18 | Basilicata, Italy | ||
3416235 | 3416235 | 2020-05-17 | Italy | Basilicata | 392 | 27 | 261 | 104 | 40.63947052 | 15.80514834 | 2020-05-18 02:32:21 | Basilicata, Italy | ||
1829469 | 1829469 | 2020-05-16 | Italy | Basilicata | 390 | 27 | 250 | 113 | 40.63947052 | 15.80514834 | 2020-05-17 02:32:32 | Basilicata, Italy | ||
3276185 | 3276185 | 2020-05-15 | Italy | Basilicata | 389 | 27 | 242 | 120 | 40.63947052 | 15.80514834 | 2020-05-16 02:32:19 | Basilicata, Italy | ||
1404359 | 1404359 | 2020-05-14 | Italy | Basilicata | 389 | 27 | 235 | 127 | 40.63947052 | 15.80514834 | 2020-05-15 02:33:02 | Basilicata, 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]);