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 = "Campania" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005339 | 1005339 | 2020-07-09 | Italy | Campania | 4755 | 432 | 4091 | 232 | 40.83956555 | 14.25084984 | 2020-07-10 04:34:24 | Campania, Italy | ||
2222555 | 2222555 | 2020-07-08 | Italy | Campania | 4750 | 432 | 4090 | 228 | 40.83956555 | 14.25084984 | 2020-07-09 04:34:23 | Campania, Italy | ||
887164 | 887164 | 2020-07-07 | Italy | Campania | 4747 | 432 | 4089 | 226 | 40.83956555 | 14.25084984 | 2020-07-08 05:33:48 | Campania, Italy | ||
2684724 | 2684724 | 2020-07-06 | Italy | Campania | 4746 | 432 | 4087 | 227 | 40.83956555 | 14.25084984 | 2020-07-07 04:34:00 | Campania, Italy | ||
415189 | 415189 | 2020-07-05 | Italy | Campania | 4719 | 432 | 4086 | 201 | 40.83956555 | 14.25084984 | 2020-07-06 04:33:57 | Campania, Italy | ||
529751 | 529751 | 2020-07-04 | Italy | Campania | 4714 | 432 | 4084 | 198 | 40.83956555 | 14.25084984 | 2020-07-05 04:33:46 | Campania, Italy | ||
2234412 | 2234412 | 2020-07-03 | Italy | Campania | 4712 | 432 | 4083 | 197 | 40.83956555 | 14.25084984 | 2020-07-04 04:33:51 | Campania, Italy | ||
3045206 | 3045206 | 2020-07-02 | Italy | Campania | 4702 | 432 | 4080 | 190 | 40.83956555 | 14.25084984 | 2020-07-03 04:33:54 | Campania, Italy | ||
302897 | 302897 | 2020-07-01 | Italy | Campania | 4699 | 432 | 4078 | 189 | 40.83956555 | 14.25084984 | 2020-07-02 04:33:46 | Campania, Italy | ||
2974275 | 2974275 | 2020-06-30 | Italy | Campania | 4690 | 432 | 4077 | 181 | 40.83956555 | 14.25084984 | 2020-07-01 04:33:52 | Campania, Italy | ||
2632752 | 2632752 | 2020-06-29 | Italy | Campania | 4666 | 431 | 4073 | 162 | 40.83956555 | 14.25084984 | 2020-06-30 04:33:48 | Campania, Italy | ||
2306315 | 2306315 | 2020-06-28 | Italy | Campania | 4665 | 431 | 4071 | 163 | 40.83956555 | 14.25084984 | 2020-06-29 04:33:44 | Campania, Italy | ||
2039650 | 2039650 | 2020-06-27 | Italy | Campania | 4665 | 431 | 4071 | 163 | 40.83956555 | 14.25084984 | 2020-06-28 04:34:04 | Campania, Italy | ||
1135931 | 1135931 | 2020-06-26 | Italy | Campania | 4665 | 431 | 4070 | 164 | 40.83956555 | 14.25084984 | 2020-06-27 04:33:35 | Campania, Italy | ||
2624918 | 2624918 | 2020-06-25 | Italy | Campania | 4662 | 431 | 4067 | 164 | 40.83956555 | 14.25084984 | 2020-06-26 04:33:43 | Campania, Italy | ||
2700558 | 2700558 | 2020-06-24 | Italy | Campania | 4645 | 431 | 4066 | 148 | 40.83956555 | 14.25084984 | 2020-06-25 05:26:54 | Campania, Italy | ||
1522243 | 1522243 | 2020-06-23 | Italy | Campania | 4634 | 431 | 4062 | 141 | 40.83956555 | 14.25084984 | 2020-06-24 04:33:28 | Campania, Italy | ||
1510437 | 1510437 | 2020-06-22 | Italy | Campania | 4624 | 431 | 4060 | 133 | 40.83956555 | 14.25084984 | 2020-06-23 04:33:22 | Campania, Italy | ||
3249176 | 3249176 | 2020-06-21 | Italy | Campania | 4617 | 431 | 4060 | 126 | 40.83956555 | 14.25084984 | 2020-06-22 04:33:20 | Campania, Italy | ||
2437769 | 2437769 | 2020-06-20 | Italy | Campania | 4615 | 431 | 4059 | 125 | 40.83956555 | 14.25084984 | 2020-06-21 04:33:19 | Campania, Italy | ||
1691347 | 1691347 | 2020-06-19 | Italy | Campania | 4615 | 431 | 4059 | 125 | 40.83956555 | 14.25084984 | 2020-06-20 04:33:19 | Campania, Italy | ||
3682496 | 3682496 | 2020-06-18 | Italy | Campania | 4615 | 431 | 3942 | 242 | 40.83956555 | 14.25084984 | 2020-06-19 04:33:17 | Campania, Italy | ||
1195699 | 1195699 | 2020-06-17 | Italy | Campania | 4614 | 431 | 3925 | 258 | 40.83956555 | 14.25084984 | 2020-06-18 04:33:18 | Campania, Italy | ||
2386462 | 2386462 | 2020-06-16 | Italy | Campania | 4613 | 430 | 3910 | 273 | 40.83956555 | 14.25084984 | 2020-06-17 04:33:21 | Campania, Italy | ||
287025 | 287025 | 2020-06-15 | Italy | Campania | 4613 | 430 | 3894 | 289 | 40.83956555 | 14.25084984 | 2020-06-16 04:33:09 | Campania, Italy | ||
1836976 | 1836976 | 2020-06-14 | Italy | Campania | 4609 | 430 | 3860 | 319 | 40.83956555 | 14.25084984 | 2020-06-15 03:33:14 | Campania, Italy | ||
3061028 | 3061028 | 2020-06-13 | Italy | Campania | 4608 | 430 | 3841 | 337 | 40.83956555 | 14.25084984 | 2020-06-14 03:33:15 | Campania, Italy | ||
737348 | 737348 | 2020-06-12 | Italy | Campania | 4608 | 430 | 3832 | 346 | 40.83956555 | 14.25084984 | 2020-06-13 03:33:14 | Campania, Italy | ||
1273318 | 1273318 | 2020-06-11 | Italy | Campania | 4837 | 430 | 3797 | 610 | 40.83956555 | 14.25084984 | 2020-06-12 05:09:52 | Campania, Italy | ||
2863762 | 2863762 | 2020-06-10 | Italy | Campania | 4834 | 428 | 3764 | 642 | 40.83956555 | 14.25084984 | 2020-06-11 03:33:41 | Campania, Italy | ||
1210615 | 1210615 | 2020-06-09 | Italy | Campania | 4833 | 426 | 3732 | 675 | 40.83956555 | 14.25084984 | 2020-06-10 04:07:00 | Campania, Italy | ||
217042 | 217042 | 2020-06-08 | Italy | Campania | 4828 | 426 | 3685 | 717 | 40.83956555 | 14.25084984 | 2020-06-09 03:33:03 | Campania, Italy | ||
2799839 | 2799839 | 2020-06-07 | Italy | Campania | 4826 | 426 | 3675 | 725 | 40.83956555 | 14.25084984 | 2020-06-08 03:33:22 | Campania, Italy | ||
573895 | 573895 | 2020-06-06 | Italy | Campania | 4822 | 426 | 3658 | 738 | 40.83956555 | 14.25084984 | 2020-06-07 03:53:30 | Campania, Italy | ||
1269592 | 1269592 | 2020-06-05 | Italy | Campania | 4822 | 425 | 3623 | 774 | 40.83956555 | 14.25084984 | 2020-06-06 02:33:00 | Campania, Italy | ||
1281072 | 1281072 | 2020-06-04 | Italy | Campania | 4822 | 420 | 3572 | 830 | 40.83956555 | 14.25084984 | 2020-06-05 02:33:06 | Campania, Italy | ||
3866627 | 3866627 | 2020-06-03 | Italy | Campania | 4821 | 415 | 3537 | 869 | 40.83956555 | 14.25084984 | 2020-06-04 02:33:14 | Campania, Italy | ||
2555670 | 2555670 | 2020-06-02 | Italy | Campania | 4809 | 415 | 3504 | 890 | 40.83956555 | 14.25084984 | 2020-06-03 02:33:13 | Campania, Italy | ||
805206 | 805206 | 2020-06-01 | Italy | Campania | 4806 | 413 | 3454 | 939 | 40.83956555 | 14.25084984 | 2020-06-02 02:33:08 | Campania, Italy | ||
1793841 | 1793841 | 2020-05-31 | Italy | Campania | 4802 | 412 | 3410 | 980 | 40.83956555 | 14.25084984 | 2020-06-01 02:32:46 | Campania, Italy | ||
3638734 | 3638734 | 2020-05-30 | Italy | Campania | 4797 | 411 | 3405 | 981 | 40.83956555 | 14.25084984 | 2020-05-31 02:32:45 | Campania, Italy | ||
1790275 | 1790275 | 2020-05-29 | Italy | Campania | 4787 | 411 | 3390 | 986 | 40.83956555 | 14.25084984 | 2020-05-30 02:32:48 | Campania, Italy | ||
2712155 | 2712155 | 2020-05-28 | Italy | Campania | 4777 | 410 | 3355 | 1012 | 40.83956555 | 14.25084984 | 2020-05-29 02:32:50 | Campania, Italy | ||
2548158 | 2548158 | 2020-05-27 | Italy | Campania | 4773 | 406 | 3221 | 1146 | 40.83956555 | 14.25084984 | 2020-05-28 02:32:31 | Campania, Italy | ||
1041121 | 1041121 | 2020-05-26 | Italy | Campania | 4767 | 405 | 3178 | 1184 | 40.83956555 | 14.25084984 | 2020-05-27 02:32:31 | Campania, Italy | ||
1104851 | 1104851 | 2020-05-25 | Italy | Campania | 4755 | 405 | 3137 | 1213 | 40.83956555 | 14.25084984 | 2020-05-26 02:32:35 | Campania, Italy | ||
875531 | 875531 | 2020-05-24 | Italy | Campania | 4749 | 405 | 3076 | 1268 | 40.83956555 | 14.25084984 | 2020-05-25 02:32:44 | Campania, Italy | ||
997722 | 997722 | 2020-05-23 | Italy | Campania | 4744 | 404 | 3067 | 1273 | 40.83956555 | 14.25084984 | 2020-05-24 02:32:43 | Campania, Italy | ||
1864745 | 1864745 | 2020-05-22 | Italy | Campania | 4733 | 404 | 3037 | 1292 | 40.83956555 | 14.25084984 | 2020-05-23 02:32:42 | Campania, Italy | ||
268251 | 268251 | 2020-05-21 | Italy | Campania | 4723 | 403 | 2947 | 1373 | 40.83956555 | 14.25084984 | 2020-05-22 02:36:51 | Campania, Italy | ||
1431834 | 1431834 | 2020-05-20 | Italy | Campania | 4714 | 401 | 2871 | 1442 | 40.83956555 | 14.25084984 | 2020-05-21 02:32:48 | Campania, Italy | ||
2390114 | 2390114 | 2020-05-19 | Italy | Campania | 4707 | 399 | 2790 | 1518 | 40.83956555 | 14.25084984 | 2020-05-20 02:32:19 | Campania, Italy | ||
3260853 | 3260853 | 2020-05-18 | Italy | Campania | 4695 | 399 | 2623 | 1673 | 40.83956555 | 14.25084984 | 2020-05-19 02:32:18 | Campania, Italy | ||
3416247 | 3416247 | 2020-05-17 | Italy | Campania | 4684 | 396 | 2592 | 1696 | 40.83956555 | 14.25084984 | 2020-05-18 02:32:21 | Campania, Italy | ||
1829481 | 1829481 | 2020-05-16 | Italy | Campania | 4668 | 396 | 2562 | 1710 | 40.83956555 | 14.25084984 | 2020-05-17 02:32:32 | Campania, Italy | ||
3276197 | 3276197 | 2020-05-15 | Italy | Campania | 4654 | 396 | 2522 | 1736 | 40.83956555 | 14.25084984 | 2020-05-16 02:32:19 | Campania, Italy | ||
1404371 | 1404371 | 2020-05-14 | Italy | Campania | 4639 | 394 | 2480 | 1765 | 40.83956555 | 14.25084984 | 2020-05-15 02:33:02 | Campania, 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]);