johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Shanghai" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
303230 | 303230 | 2020-07-01 | China | Shanghai | 713 | 7 | 677 | 29 | 31.201999999999998 | 121.4491 | 2020-07-02 04:33:46 | Shanghai, China | ||
2974608 | 2974608 | 2020-06-30 | China | Shanghai | 712 | 7 | 675 | 30 | 31.202 | 121.4491 | 2020-07-01 04:33:52 | Shanghai, China | ||
2633085 | 2633085 | 2020-06-29 | China | Shanghai | 712 | 7 | 675 | 30 | 31.202 | 121.4491 | 2020-06-30 04:33:48 | Shanghai, China | ||
2306648 | 2306648 | 2020-06-28 | China | Shanghai | 708 | 7 | 675 | 26 | 31.202 | 121.4491 | 2020-06-29 04:33:44 | Shanghai, China | ||
2039983 | 2039983 | 2020-06-27 | China | Shanghai | 707 | 7 | 675 | 25 | 31.201999999999998 | 121.4491 | 2020-06-28 04:34:04 | Shanghai, China | ||
1136264 | 1136264 | 2020-06-26 | China | Shanghai | 706 | 7 | 674 | 25 | 31.202 | 121.4491 | 2020-06-27 04:33:35 | Shanghai, China | ||
2625251 | 2625251 | 2020-06-25 | China | Shanghai | 705 | 7 | 672 | 26 | 31.201999999999998 | 121.4491 | 2020-06-26 04:33:43 | Shanghai, China | ||
2700891 | 2700891 | 2020-06-24 | China | Shanghai | 703 | 7 | 670 | 26 | 31.201999999999998 | 121.4491 | 2020-06-25 05:26:54 | Shanghai, China | ||
1522576 | 1522576 | 2020-06-23 | China | Shanghai | 703 | 7 | 669 | 27 | 31.202 | 121.4491 | 2020-06-24 04:33:28 | Shanghai, China | ||
1510770 | 1510770 | 2020-06-22 | China | Shanghai | 701 | 7 | 669 | 25 | 31.201999999999998 | 121.4491 | 2020-06-23 04:33:22 | Shanghai, China | ||
3249509 | 3249509 | 2020-06-21 | China | Shanghai | 701 | 7 | 668 | 26 | 31.202 | 121.4491 | 2020-06-22 04:33:20 | Shanghai, China | ||
2438102 | 2438102 | 2020-06-20 | China | Shanghai | 698 | 7 | 668 | 23 | 31.201999999999998 | 121.4491 | 2020-06-21 04:33:19 | Shanghai, China | ||
1691680 | 1691680 | 2020-06-19 | China | Shanghai | 697 | 7 | 668 | 22 | 31.202 | 121.4491 | 2020-06-20 04:33:19 | Shanghai, China | ||
3682829 | 3682829 | 2020-06-18 | China | Shanghai | 697 | 7 | 668 | 22 | 31.201999999999998 | 121.4491 | 2020-06-19 04:33:17 | Shanghai, China | ||
1196032 | 1196032 | 2020-06-17 | China | Shanghai | 697 | 7 | 668 | 22 | 31.202 | 121.4491 | 2020-06-18 04:33:18 | Shanghai, China | ||
2386795 | 2386795 | 2020-06-16 | China | Shanghai | 695 | 7 | 667 | 21 | 31.201999999999998 | 121.4491 | 2020-06-17 04:33:21 | Shanghai, China | ||
287358 | 287358 | 2020-06-15 | China | Shanghai | 695 | 7 | 667 | 21 | 31.202 | 121.4491 | 2020-06-16 04:33:09 | Shanghai, China | ||
1837309 | 1837309 | 2020-06-14 | China | Shanghai | 692 | 7 | 667 | 18 | 31.201999999999998 | 121.4491 | 2020-06-15 03:33:14 | Shanghai, China | ||
3061361 | 3061361 | 2020-06-13 | China | Shanghai | 691 | 7 | 666 | 18 | 31.202 | 121.4491 | 2020-06-14 03:33:15 | Shanghai, China | ||
737681 | 737681 | 2020-06-12 | China | Shanghai | 690 | 7 | 666 | 17 | 31.201999999999998 | 121.4491 | 2020-06-13 03:33:14 | Shanghai, China | ||
1273651 | 1273651 | 2020-06-11 | China | Shanghai | 689 | 7 | 666 | 16 | 31.201999999999998 | 121.4491 | 2020-06-12 05:09:52 | Shanghai, China | ||
2864092 | 2864092 | 2020-06-10 | China | Shanghai | 684 | 7 | 665 | 12 | 31.202 | 121.4491 | 2020-06-11 03:33:41 | Shanghai, China | ||
1210918 | 1210918 | 2020-06-09 | China | Shanghai | 678 | 7 | 665 | 6 | 31.201999999999998 | 121.4491 | 2020-06-10 04:07:00 | Shanghai, China | ||
217345 | 217345 | 2020-06-08 | China | Shanghai | 678 | 7 | 664 | 7 | 31.202 | 121.4491 | 2020-06-09 03:33:03 | Shanghai, China | ||
2800141 | 2800141 | 2020-06-07 | China | Shanghai | 678 | 7 | 664 | 7 | 31.201999999999998 | 121.4491 | 2020-06-08 03:33:22 | Shanghai, China | ||
574197 | 574197 | 2020-06-06 | China | Shanghai | 677 | 7 | 664 | 6 | 31.202 | 121.4491 | 2020-06-07 03:53:30 | Shanghai, China | ||
1269894 | 1269894 | 2020-06-05 | China | Shanghai | 677 | 7 | 663 | 7 | 31.201999999999998 | 121.4491 | 2020-06-06 02:33:00 | Shanghai, China | ||
1281363 | 1281363 | 2020-06-04 | China | Shanghai | 677 | 7 | 662 | 8 | 31.202 | 121.4491 | 2020-06-05 02:33:06 | Shanghai, China | ||
3866918 | 3866918 | 2020-06-03 | China | Shanghai | 673 | 7 | 661 | 5 | 31.201999999999998 | 121.4491 | 2020-06-04 02:33:14 | Shanghai, China | ||
2555960 | 2555960 | 2020-06-02 | China | Shanghai | 673 | 7 | 661 | 5 | 31.202 | 121.4491 | 2020-06-03 02:33:13 | Shanghai, China | ||
805497 | 805497 | 2020-06-01 | China | Shanghai | 673 | 7 | 660 | 6 | 31.201999999999998 | 121.4491 | 2020-06-02 02:33:08 | Shanghai, China | ||
1794058 | 1794058 | 2020-05-31 | China | Shanghai | 672 | 7 | 657 | 8 | 31.202 | 121.4491 | 2020-06-01 02:32:46 | Shanghai, China | ||
3638951 | 3638951 | 2020-05-30 | China | Shanghai | 672 | 7 | 657 | 8 | 31.201999999999998 | 121.4491 | 2020-05-31 02:32:45 | Shanghai, China | ||
1790492 | 1790492 | 2020-05-29 | China | Shanghai | 672 | 7 | 657 | 8 | 31.202 | 121.4491 | 2020-05-30 02:32:48 | Shanghai, China | ||
2712371 | 2712371 | 2020-05-28 | China | Shanghai | 671 | 7 | 655 | 9 | 31.201999999999998 | 121.4491 | 2020-05-29 02:32:50 | Shanghai, China | ||
2548308 | 2548308 | 2020-05-27 | China | Shanghai | 671 | 7 | 655 | 9 | 31.202 | 121.4491 | 2020-05-28 02:32:31 | Shanghai, China | ||
1041271 | 1041271 | 2020-05-26 | China | Shanghai | 670 | 7 | 653 | 10 | 31.201999999999998 | 121.4491 | 2020-05-27 02:32:31 | Shanghai, China | ||
1105001 | 1105001 | 2020-05-25 | China | Shanghai | 669 | 7 | 652 | 10 | 31.202 | 121.4491 | 2020-05-26 02:32:35 | Shanghai, China | ||
875681 | 875681 | 2020-05-24 | China | Shanghai | 668 | 7 | 648 | 13 | 31.201999999999998 | 121.4491 | 2020-05-25 02:32:44 | Shanghai, China | ||
997872 | 997872 | 2020-05-23 | China | Shanghai | 668 | 7 | 647 | 14 | 31.202 | 121.4491 | 2020-05-24 02:32:43 | Shanghai, China | ||
1864895 | 1864895 | 2020-05-22 | China | Shanghai | 667 | 7 | 647 | 13 | 31.201999999999998 | 121.4491 | 2020-05-23 02:32:42 | Shanghai, China | ||
268401 | 268401 | 2020-05-21 | China | Shanghai | 666 | 7 | 641 | 18 | 31.202 | 121.4491 | 2020-05-22 02:36:51 | Shanghai, China | ||
1431984 | 1431984 | 2020-05-20 | China | Shanghai | 666 | 7 | 641 | 18 | 31.201999999999998 | 121.4491 | 2020-05-21 02:32:48 | Shanghai, China | ||
2390215 | 2390215 | 2020-05-19 | China | Shanghai | 666 | 7 | 641 | 18 | 31.201999999999998 | 121.4491 | 2020-05-20 02:32:19 | Shanghai, China | ||
3260953 | 3260953 | 2020-05-18 | China | Shanghai | 666 | 7 | 641 | 18 | 31.202 | 121.4491 | 2020-05-19 02:32:18 | Shanghai, China | ||
3416347 | 3416347 | 2020-05-17 | China | Shanghai | 666 | 7 | 641 | 18 | 31.201999999999998 | 121.4491 | 2020-05-18 02:32:21 | Shanghai, China | ||
1829581 | 1829581 | 2020-05-16 | China | Shanghai | 665 | 7 | 641 | 17 | 31.202 | 121.4491 | 2020-05-17 02:32:32 | Shanghai, China | ||
3276297 | 3276297 | 2020-05-15 | China | Shanghai | 665 | 7 | 640 | 18 | 31.201999999999998 | 121.4491 | 2020-05-16 02:32:19 | Shanghai, China | ||
1404471 | 1404471 | 2020-05-14 | China | Shanghai | 660 | 7 | 638 | 15 | 31.202 | 121.4491 | 2020-05-15 02:33:02 | Shanghai, China | ||
3847238 | 3847238 | 2020-05-13 | China | Shanghai | 660 | 7 | 633 | 20 | 31.201999999999998 | 121.4491 | 2020-05-14 03:32:28 | Shanghai, China | ||
2581445 | 2581445 | 2020-05-12 | China | Shanghai | 660 | 7 | 631 | 22 | 31.202 | 121.4491 | 2020-05-13 03:32:26 | Shanghai, China | ||
3330979 | 3330979 | 2020-05-11 | China | Shanghai | 659 | 7 | 627 | 25 | 31.201999999999998 | 121.4491 | 2020-05-12 03:32:27 | Shanghai, China | ||
3459594 | 3459594 | 2020-05-10 | China | Shanghai | 659 | 7 | 627 | 25 | 31.202 | 121.4491 | 2020-05-11 02:32:30 | Shanghai, China | ||
2899135 | 2899135 | 2020-05-09 | China | Shanghai | 659 | 7 | 626 | 26 | 31.201999999999998 | 121.4491 | 2020-05-10 02:32:30 | Shanghai, China | ||
114184 | 114184 | 2020-05-08 | China | Shanghai | 657 | 7 | 623 | 27 | 31.202 | 121.4491 | 2020-05-09 02:32:35 | Shanghai, China | ||
3295627 | 3295627 | 2020-05-07 | China | Shanghai | 657 | 7 | 623 | 27 | 31.201999999999998 | 121.4491 | 2020-05-08 02:32:32 | Shanghai, China | ||
2110848 | 2110848 | 2020-05-06 | China | Shanghai | 657 | 7 | 620 | 30 | 31.201999999999998 | 121.4491 | 2020-05-07 02:32:28 | Shanghai, China | ||
1931888 | 1931888 | 2020-05-05 | China | Shanghai | 656 | 7 | 620 | 29 | 31.202 | 121.4491 | 2020-05-06 02:32:31 | Shanghai, China | ||
3084751 | 3084751 | 2020-05-04 | China | Shanghai | 656 | 7 | 619 | 30 | 31.201999999999998 | 121.4491 | 2020-05-05 02:32:34 | Shanghai, China | ||
2278610 | 2278610 | 2020-05-03 | China | Shanghai | 655 | 7 | 615 | 33 | 31.202 | 121.4491 | 2020-05-04 02:32:28 | Shanghai, China | ||
2043286 | 2043286 | 2020-05-02 | China | Shanghai | 652 | 7 | 612 | 33 | 31.201999999999998 | 121.4491 | 2020-05-03 02:32:28 | Shanghai, China | ||
1184180 | 1184180 | 2020-05-01 | China | Shanghai | 652 | 7 | 612 | 33 | 31.202 | 121.4491 | 2020-05-02 02:32:27 | Shanghai, China | ||
228661 | 228661 | 2020-04-30 | China | Shanghai | 652 | 7 | 599 | 46 | 31.201999999999998 | 121.4491 | 2020-05-01 02:32:28 | Shanghai, China | ||
137408 | 137408 | 2020-04-29 | China | Shanghai | 647 | 7 | 597 | 43 | 31.202 | 121.4491 | 2020-04-30 02:32:27 | Shanghai, China | ||
271622 | 271622 | 2020-04-28 | China | Shanghai | 645 | 7 | 584 | 54 | 31.201999999999998 | 121.4491 | 2020-04-29 02:32:29 | Shanghai, China | ||
3589281 | 3589281 | 2020-04-27 | China | Shanghai | 644 | 7 | 581 | 56 | 31.202 | 121.4491 | 2020-04-28 01:32:57 | Shanghai, China | ||
3592459 | 3592459 | 2020-04-26 | China | Shanghai | 642 | 7 | 568 | 67 | 31.201999999999998 | 121.4491 | 2020-04-26 06:29:18 | Shanghai, China | ||
3502808 | 3502808 | 2020-04-25 | China | Shanghai | 642 | 7 | 558 | 77 | 31.202 | 121.4491 | 2020-04-26 00:08:58 | Shanghai, China | ||
1459209 | 1459209 | 2020-04-24 | China | Shanghai | 641 | 7 | 558 | 76 | 31.201999999999998 | 121.4491 | 2020-04-25 03:45:48 | Shanghai, China | ||
2524798 | 2524798 | 2020-04-23 | China | Shanghai | 641 | 7 | 533 | 101 | 31.202 | 121.4491 | 2020-04-24 00:43:27 | Shanghai, China | ||
1199244 | 1199244 | 2020-04-22 | China | Shanghai | 639 | 7 | 534 | 98 | 31.201999999999998 | 121.4491 | 2020-04-22 07:14:57 | Shanghai, China | ||
522310 | 522310 | 2020-04-21 | China | Shanghai | 638 | 7 | 530 | 101 | 31.201999999999998 | 121.4491 | 2020-04-20 07:50:28 | Shanghai, China | ||
2473392 | 2473392 | 2020-04-20 | China | Shanghai | 638 | 7 | 530 | 101 | 31.202 | 121.4491 | 2020-04-20 07:50:28 | Shanghai, China | ||
1385084 | 1385084 | 2020-04-19 | China | Shanghai | 635 | 7 | 521 | 107 | 31.202 | 121.4491 | 2020-04-19 12:30:51 | Shanghai, China | ||
418772 | 418772 | 2020-04-18 | China | Shanghai | 628 | 7 | 512 | 109 | 31.202 | 121.4491 | 2020-04-17 06:07:47 | Shanghai, China | ||
50244 | 50244 | 2020-04-17 | China | Shanghai | 628 | 7 | 512 | 109 | 31.201999999999998 | 121.4491 | 2020-04-17 06:07:47 | Shanghai, China | ||
934238 | 934238 | 2020-04-16 | China | Shanghai | 628 | 7 | 489 | 132 | 31.202 | 121.4491 | 2020-04-16 06:35:57 | Shanghai, China | ||
860132 | 860132 | 2020-04-15 | China | Shanghai | 622 | 7 | 485 | 130 | 31.201999999999998 | 121.4491 | 2020-04-15 06:12:32 | Shanghai, China | ||
3338048 | 3338048 | 2020-04-14 | China | Shanghai | 618 | 7 | 468 | 143 | 31.202 | 121.4491 | 2020-04-14 10:39:48 | Shanghai, China | ||
43145 | 43145 | 2020-04-13 | China | Shanghai | 618 | 7 | 446 | 165 | 31.201999999999998 | 121.4491 | 2020-04-13 09:36:31 | Shanghai, China | ||
2578171 | 2578171 | 2020-04-12 | China | Shanghai | 607 | 7 | 446 | 154 | 31.202 | 121.4491 | 2020-04-12 05:28:00 | Shanghai, China | ||
2567008 | 2567008 | 2020-04-11 | China | Shanghai | 555 | 7 | 438 | 110 | 31.201999999999998 | 121.4491 | 2020-04-11 08:35:43 | Shanghai, China | ||
1250193 | 1250193 | 2020-04-10 | China | Shanghai | 555 | 7 | 435 | 113 | 31.202 | 121.4491 | 2020-04-10 08:48:52 | Shanghai, China | ||
3949930 | 3949930 | 2020-04-09 | China | Shanghai | 552 | 7 | 422 | 123 | 31.201999999999998 | 121.4491 | 2020-04-09 07:01:54 | Shanghai, China | ||
3562037 | 3562037 | 2020-04-08 | China | Shanghai | 543 | 7 | 418 | 118 | 31.202 | 121.4491 | 2020-04-08 05:20:24 | Shanghai, China | ||
3021712 | 3021712 | 2020-04-07 | China | Shanghai | 538 | 6 | 406 | 126 | 31.201999999999998 | 121.4491 | 2020-04-07 06:21:55 | Shanghai, China | ||
3627394 | 3627394 | 2020-04-06 | China | Shanghai | 536 | 6 | 389 | 141 | 31.202 | 121.4491 | 4/6/20 5:30 | Shanghai, China | ||
589082 | 589082 | 2020-04-05 | China | Shanghai | 531 | 6 | 383 | 142 | 31.201999999999998 | 121.4491 | 2020-04-05 06:22:56 | Shanghai, China | ||
1750725 | 1750725 | 2020-04-04 | China | Shanghai | 529 | 6 | 356 | 167 | 31.202 | 121.4491 | 4/4/20 8:37 | Shanghai, China | ||
3740536 | 3740536 | 2020-04-03 | China | Shanghai | 526 | 6 | 348 | 172 | 31.201999999999998 | 121.4491 | 2020-04-03 06:56:51 | Shanghai, China | ||
3701566 | 3701566 | 2020-04-02 | China | Shanghai | 522 | 6 | 343 | 173 | 31.202 | 121.4491 | 4/2/20 0:34 | Shanghai, China | ||
3364770 | 3364770 | 2020-04-01 | China | Shanghai | 516 | 6 | 341 | 169 | 31.201999999999998 | 121.4491 | 2020-04-01 00:04:18 | Shanghai, China | ||
3815863 | 3815863 | 2020-03-31 | China | Shanghai | 509 | 5 | 341 | 163 | 31.202 | 121.4491 | 2020-03-31 07:43:11 | Shanghai, China | ||
1872415 | 1872415 | 2020-03-30 | China | Shanghai | 498 | 5 | 338 | 155 | 31.202 | 121.4491 | 3/30/20 5:05 | Shanghai, China | ||
2875652 | 2875652 | 2020-03-29 | China | Shanghai | 492 | 5 | 334 | 153 | 31.202 | 121.4491 | 3/29/20 2:09 | Shanghai, China | ||
3946988 | 3946988 | 2020-03-28 | China | Shanghai | 485 | 5 | 334 | 146 | 31.202 | 121.4491 | 3/28/20 2:01 | Shanghai, China | ||
809038 | 809038 | 2020-03-27 | China | Shanghai | 468 | 5 | 334 | 129 | 31.202 | 121.4491 | 2020-03-27 04:44:03 | Shanghai, China | ||
919131 | 919131 | 2020-03-26 | China | Shanghai | 451 | 5 | 331 | 115 | 31.201999999999998 | 121.4491 | 2020-03-26 07:31:30 | Shanghai, China | ||
1132533 | 1132533 | 2020-03-25 | China | Shanghai | 433 | 5 | 330 | 98 | 31.202 | 121.4491 | 2020-03-25 06:43:02 | Shanghai, China | ||
1479041 | 1479041 | 2020-03-24 | China | Shanghai | 414 | 4 | 330 | 80 | 31.202 | 121.4491 | 2020-03-24 08:05:18 | Shanghai, China |
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]);