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 = "Shandong" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2728828 | 2728828 | 2020-09-15 | China | Shandong | 831 | 7 | 813 | 11 | 36.3427 | 118.1498 | 2020-09-16 04:22:53 | Shandong, China | ||
344100 | 344100 | 2020-09-14 | China | Shandong | 831 | 7 | 813 | 11 | 36.3427 | 118.1498 | 2020-09-15 03:22:50 | Shandong, China | ||
2868539 | 2868539 | 2020-09-13 | China | Shandong | 831 | 7 | 813 | 11 | 36.3427 | 118.1498 | 2020-09-14 04:26:00 | Shandong, China | ||
546578 | 546578 | 2020-09-12 | China | Shandong | 831 | 7 | 813 | 11 | 36.3427 | 118.1498 | 2020-09-13 04:30:52 | Shandong, China | ||
1444407 | 1444407 | 2020-09-11 | China | Shandong | 831 | 7 | 813 | 11 | 36.3427 | 118.1498 | 2020-09-12 04:25:05 | Shandong, China | ||
1173008 | 1173008 | 2020-09-10 | China | Shandong | 831 | 7 | 812 | 12 | 36.3427 | 118.1498 | 2020-09-11 04:46:23 | Shandong, China | ||
2171373 | 2171373 | 2020-09-09 | China | Shandong | 831 | 7 | 811 | 13 | 36.3427 | 118.1498 | 2020-09-10 04:29:01 | Shandong, China | ||
1243582 | 1243582 | 2020-09-08 | China | Shandong | 831 | 7 | 811 | 13 | 36.3427 | 118.1498 | 2020-09-09 04:28:48 | Shandong, China | ||
427161 | 427161 | 2020-09-07 | China | Shandong | 831 | 7 | 811 | 13 | 36.3427 | 118.1498 | 2020-09-08 04:28:25 | Shandong, China | ||
3161446 | 3161446 | 2020-09-06 | China | Shandong | 831 | 7 | 811 | 13 | 36.3427 | 118.1498 | 2020-09-07 04:28:30 | Shandong, China | ||
813401 | 813401 | 2020-09-05 | China | Shandong | 831 | 7 | 810 | 14 | 36.3427 | 118.1498 | 2020-09-06 04:28:33 | Shandong, China | ||
2661601 | 2661601 | 2020-09-04 | China | Shandong | 831 | 7 | 809 | 15 | 36.3427 | 118.1498 | 2020-09-05 04:28:19 | Shandong, China | ||
1354141 | 1354141 | 2020-09-03 | China | Shandong | 831 | 7 | 809 | 15 | 36.3427 | 118.1498 | 2020-09-04 04:28:26 | Shandong, China | ||
1105378 | 1105378 | 2020-09-02 | China | Shandong | 831 | 7 | 809 | 15 | 36.3427 | 118.1498 | 2020-09-03 04:28:22 | Shandong, China | ||
2059707 | 2059707 | 2020-09-01 | China | Shandong | 831 | 7 | 809 | 15 | 36.3427 | 118.1498 | 2020-09-02 04:28:25 | Shandong, China | ||
193892 | 193892 | 2020-08-31 | China | Shandong | 831 | 7 | 808 | 16 | 36.3427 | 118.1498 | 2020-09-01 04:28:31 | Shandong, China | ||
3931851 | 3931851 | 2020-08-30 | China | Shandong | 831 | 7 | 807 | 17 | 36.3427 | 118.1498 | 2020-08-31 04:28:27 | Shandong, China | ||
609513 | 609513 | 2020-08-29 | China | Shandong | 831 | 7 | 807 | 17 | 36.3427 | 118.1498 | 2020-08-30 04:28:22 | Shandong, China | ||
1523008 | 1523008 | 2020-08-28 | China | Shandong | 831 | 7 | 806 | 18 | 36.3427 | 118.1498 | 2020-08-29 04:28:19 | Shandong, China | ||
2510009 | 2510009 | 2020-08-27 | China | Shandong | 831 | 7 | 802 | 22 | 36.3427 | 118.1498 | 2020-08-28 04:28:11 | Shandong, China | ||
1996469 | 1996469 | 2020-08-26 | China | Shandong | 831 | 7 | 801 | 23 | 36.3427 | 118.1498 | 2020-08-27 04:28:15 | Shandong, China | ||
3562393 | 3562393 | 2020-08-25 | China | Shandong | 831 | 7 | 801 | 23 | 36.3427 | 118.1498 | 2020-08-26 04:28:11 | Shandong, China | ||
2991097 | 2991097 | 2020-08-24 | China | Shandong | 831 | 7 | 798 | 26 | 36.3427 | 118.1498 | 2020-08-25 04:28:02 | Shandong, China | ||
2215492 | 2215492 | 2020-08-23 | China | Shandong | 831 | 7 | 798 | 26 | 36.3427 | 118.1498 | 2020-08-24 04:27:56 | Shandong, China | ||
2299274 | 2299274 | 2020-08-22 | China | Shandong | 830 | 7 | 797 | 26 | 36.3427 | 118.1498 | 2020-08-23 04:27:48 | Shandong, China | ||
1479381 | 1479381 | 2020-08-21 | China | Shandong | 830 | 7 | 795 | 28 | 36.3427 | 118.1498 | 2020-08-22 04:27:49 | Shandong, China | ||
3484130 | 3484130 | 2020-08-20 | China | Shandong | 827 | 7 | 794 | 26 | 36.3427 | 118.1498 | 2020-08-21 04:27:41 | Shandong, China | ||
206079 | 206079 | 2020-08-19 | China | Shandong | 824 | 7 | 793 | 24 | 36.3427 | 118.1498 | 2020-08-20 04:27:43 | Shandong, China | ||
3177833 | 3177833 | 2020-08-18 | China | Shandong | 823 | 7 | 793 | 23 | 36.3427 | 118.1498 | 2020-08-19 04:27:00 | Shandong, China | ||
837437 | 837437 | 2020-08-17 | China | Shandong | 822 | 7 | 793 | 22 | 36.3427 | 118.1498 | 2020-08-18 04:27:56 | Shandong, China | ||
1555795 | 1555795 | 2020-08-16 | China | Shandong | 822 | 7 | 790 | 25 | 36.3427 | 118.1498 | 2020-08-17 04:27:20 | Shandong, China | ||
145797 | 145797 | 2020-08-15 | China | Shandong | 821 | 7 | 790 | 24 | 36.3427 | 118.1498 | 2020-08-16 04:27:42 | Shandong, China | ||
1612072 | 1612072 | 2020-08-14 | China | Shandong | 821 | 7 | 790 | 24 | 36.3427 | 118.1498 | 2020-08-15 04:27:31 | Shandong, China | ||
582656 | 582656 | 2020-08-13 | China | Shandong | 821 | 7 | 789 | 25 | 36.3427 | 118.1498 | 2020-08-14 04:51:19 | Shandong, China | ||
3531275 | 3531275 | 2020-08-12 | China | Shandong | 821 | 7 | 789 | 25 | 36.3427 | 118.1498 | 2020-08-13 04:29:15 | Shandong, China | ||
662124 | 662124 | 2020-08-11 | China | Shandong | 817 | 7 | 788 | 22 | 36.3427 | 118.1498 | 2020-08-12 04:27:29 | Shandong, China | ||
1920572 | 1920572 | 2020-08-10 | China | Shandong | 816 | 7 | 788 | 21 | 36.3427 | 118.1498 | 2020-08-11 04:35:08 | Shandong, China | ||
3923381 | 3923381 | 2020-08-09 | China | Shandong | 810 | 7 | 788 | 15 | 36.3427 | 118.1498 | 2020-08-10 04:34:55 | Shandong, China | ||
371549 | 371549 | 2020-08-08 | China | Shandong | 806 | 7 | 788 | 11 | 36.3427 | 118.1498 | 2020-08-09 04:34:54 | Shandong, China | ||
458733 | 458733 | 2020-08-07 | China | Shandong | 806 | 7 | 788 | 11 | 36.3427 | 118.1498 | 2020-08-08 04:34:53 | Shandong, China | ||
3612418 | 3612418 | 2020-08-06 | China | Shandong | 805 | 7 | 787 | 11 | 36.3427 | 118.1498 | 2020-08-07 04:35:11 | Shandong, China | ||
3793248 | 3793248 | 2020-08-05 | China | Shandong | 805 | 7 | 786 | 12 | 36.3427 | 118.1498 | 2020-08-06 04:35:02 | Shandong, China | ||
98484 | 98484 | 2020-08-04 | China | Shandong | 804 | 7 | 786 | 11 | 36.3427 | 118.1498 | 2020-08-05 04:34:43 | Shandong, China | ||
2740367 | 2740367 | 2020-08-03 | China | Shandong | 804 | 7 | 786 | 11 | 36.3427 | 118.1498 | 2020-08-04 04:41:59 | Shandong, China | ||
2808119 | 2808119 | 2020-08-02 | China | Shandong | 804 | 7 | 786 | 11 | 36.3427 | 118.1498 | 2020-08-03 04:34:35 | Shandong, China | ||
753687 | 753687 | 2020-08-01 | China | Shandong | 802 | 7 | 786 | 9 | 36.3427 | 118.1498 | 2020-08-02 04:34:47 | Shandong, China | ||
3264852 | 3264852 | 2020-07-31 | China | Shandong | 799 | 7 | 785 | 7 | 36.3427 | 118.1498 | 2020-08-01 04:36:27 | Shandong, China | ||
1928559 | 1928559 | 2020-07-30 | China | Shandong | 799 | 7 | 785 | 7 | 36.3427 | 118.1498 | 2020-07-31 04:35:18 | Shandong, China | ||
2958727 | 2958727 | 2020-07-29 | China | Shandong | 799 | 7 | 785 | 7 | 36.3427 | 118.1498 | 2020-07-30 04:35:05 | Shandong, China | ||
3185343 | 3185343 | 2020-07-28 | China | Shandong | 799 | 7 | 785 | 7 | 36.3427 | 118.1498 | 2020-07-29 04:35:11 | Shandong, China | ||
177394 | 177394 | 2020-07-27 | China | Shandong | 799 | 7 | 785 | 7 | 36.3427 | 118.1498 | 2020-07-28 04:58:43 | Shandong, China | ||
442707 | 442707 | 2020-07-26 | China | Shandong | 799 | 7 | 785 | 7 | 36.3427 | 118.1498 | 2020-07-27 04:35:02 | Shandong, China | ||
1502951 | 1502951 | 2020-07-25 | China | Shandong | 799 | 7 | 785 | 7 | 36.3427 | 118.1498 | 2020-07-26 04:35:00 | Shandong, China | ||
2563921 | 2563921 | 2020-07-24 | China | Shandong | 798 | 7 | 785 | 6 | 36.3427 | 118.1498 | 2020-07-25 04:47:39 | Shandong, China | ||
62129 | 62129 | 2020-07-23 | China | Shandong | 798 | 7 | 785 | 6 | 36.3427 | 118.1498 | 2020-07-24 05:30:40 | Shandong, China | ||
844941 | 844941 | 2020-07-22 | China | Shandong | 798 | 7 | 785 | 6 | 36.3427 | 118.1498 | 2020-07-23 05:15:04 | Shandong, China | ||
1707680 | 1707680 | 2020-07-21 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-22 04:34:42 | Shandong, China | ||
327171 | 327171 | 2020-07-20 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-21 04:38:46 | Shandong, China | ||
122076 | 122076 | 2020-07-19 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-20 05:34:40 | Shandong, China | ||
3205465 | 3205465 | 2020-07-18 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-19 04:34:58 | Shandong, China | ||
2708767 | 2708767 | 2020-07-17 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-18 04:34:45 | Shandong, China | ||
367577 | 367577 | 2020-07-16 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-17 04:34:50 | Shandong, China | ||
2748245 | 2748245 | 2020-07-15 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-16 04:44:59 | Shandong, China | ||
2158889 | 2158889 | 2020-07-14 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-15 04:34:39 | Shandong, China | ||
3491530 | 3491530 | 2020-07-13 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-14 04:34:46 | Shandong, China | ||
3737793 | 3737793 | 2020-07-12 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-13 04:43:04 | Shandong, China | ||
3436188 | 3436188 | 2020-07-11 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-12 04:34:30 | Shandong, China | ||
3237686 | 3237686 | 2020-07-10 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-11 04:34:26 | Shandong, China | ||
1005671 | 1005671 | 2020-07-09 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-10 04:34:24 | Shandong, China | ||
2222887 | 2222887 | 2020-07-08 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-09 04:34:23 | Shandong, China | ||
887496 | 887496 | 2020-07-07 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-08 05:33:48 | Shandong, China | ||
2685056 | 2685056 | 2020-07-06 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-07 04:34:00 | Shandong, China | ||
415521 | 415521 | 2020-07-05 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-06 04:33:57 | Shandong, China | ||
530083 | 530083 | 2020-07-04 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-05 04:33:46 | Shandong, China | ||
2234744 | 2234744 | 2020-07-03 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-04 04:33:51 | Shandong, China | ||
3045538 | 3045538 | 2020-07-02 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-03 04:33:54 | Shandong, China | ||
303229 | 303229 | 2020-07-01 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-02 04:33:46 | Shandong, China | ||
2974607 | 2974607 | 2020-06-30 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-07-01 04:33:52 | Shandong, China | ||
2633084 | 2633084 | 2020-06-29 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-30 04:33:48 | Shandong, China | ||
2306647 | 2306647 | 2020-06-28 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-29 04:33:44 | Shandong, China | ||
2039982 | 2039982 | 2020-06-27 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-28 04:34:04 | Shandong, China | ||
1136263 | 1136263 | 2020-06-26 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-27 04:33:35 | Shandong, China | ||
2625250 | 2625250 | 2020-06-25 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-26 04:33:43 | Shandong, China | ||
2700890 | 2700890 | 2020-06-24 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-25 05:26:54 | Shandong, China | ||
1522575 | 1522575 | 2020-06-23 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-24 04:33:28 | Shandong, China | ||
1510769 | 1510769 | 2020-06-22 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-23 04:33:22 | Shandong, China | ||
3249508 | 3249508 | 2020-06-21 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-22 04:33:20 | Shandong, China | ||
2438101 | 2438101 | 2020-06-20 | China | Shandong | 792 | 7 | 785 | 0 | 36.3427 | 118.1498 | 2020-06-21 04:33:19 | Shandong, China | ||
1691679 | 1691679 | 2020-06-19 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-20 04:33:19 | Shandong, China | ||
3682828 | 3682828 | 2020-06-18 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-19 04:33:17 | Shandong, China | ||
1196031 | 1196031 | 2020-06-17 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-18 04:33:18 | Shandong, China | ||
2386794 | 2386794 | 2020-06-16 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-17 04:33:21 | Shandong, China | ||
287357 | 287357 | 2020-06-15 | China | Shandong | 792 | 7 | 783 | 2 | 36.3427 | 118.1498 | 2020-06-16 04:33:09 | Shandong, China | ||
1837308 | 1837308 | 2020-06-14 | China | Shandong | 792 | 7 | 782 | 3 | 36.3427 | 118.1498 | 2020-06-15 03:33:14 | Shandong, China | ||
3061360 | 3061360 | 2020-06-13 | China | Shandong | 792 | 7 | 782 | 3 | 36.3427 | 118.1498 | 2020-06-14 03:33:15 | Shandong, China | ||
737680 | 737680 | 2020-06-12 | China | Shandong | 792 | 7 | 781 | 4 | 36.3427 | 118.1498 | 2020-06-13 03:33:14 | Shandong, China | ||
1273650 | 1273650 | 2020-06-11 | China | Shandong | 792 | 7 | 781 | 4 | 36.3427 | 118.1498 | 2020-06-12 05:09:52 | Shandong, China | ||
2864091 | 2864091 | 2020-06-10 | China | Shandong | 792 | 7 | 781 | 4 | 36.3427 | 118.1498 | 2020-06-11 03:33:41 | Shandong, China | ||
1210917 | 1210917 | 2020-06-09 | China | Shandong | 792 | 7 | 781 | 4 | 36.3427 | 118.1498 | 2020-06-10 04:07:00 | Shandong, China | ||
217344 | 217344 | 2020-06-08 | China | Shandong | 792 | 7 | 781 | 4 | 36.3427 | 118.1498 | 2020-06-09 03:33:03 | Shandong, 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]);