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 = "Liaoning" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016525 | 2016525 | 2022-09-20 | China | Liaoning | 1883 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-21 04:23:22 | Liaoning, China | |||
3570398 | 3570398 | 2022-09-19 | China | Liaoning | 1883 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-20 04:22:48 | Liaoning, China | |||
419137 | 419137 | 2022-09-18 | China | Liaoning | 1883 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-19 04:21:49 | Liaoning, China | |||
3373161 | 3373161 | 2022-09-17 | China | Liaoning | 1882 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-18 04:22:50 | Liaoning, China | |||
2355269 | 2355269 | 2022-09-16 | China | Liaoning | 1882 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-17 04:20:19 | Liaoning, China | |||
3986426 | 3986426 | 2022-09-15 | China | Liaoning | 1880 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-16 04:21:19 | Liaoning, China | |||
1888943 | 1888943 | 2022-09-14 | China | Liaoning | 1879 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-15 04:21:02 | Liaoning, China | |||
371998 | 371998 | 2022-09-13 | China | Liaoning | 1876 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-14 04:20:44 | Liaoning, China | |||
2394603 | 2394603 | 2022-09-12 | China | Liaoning | 1876 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-13 04:20:57 | Liaoning, China | |||
3765681 | 3765681 | 2022-09-11 | China | Liaoning | 1871 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-12 04:20:58 | Liaoning, China | |||
3824256 | 3824256 | 2022-09-10 | China | Liaoning | 1867 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-11 04:20:50 | Liaoning, China | |||
962713 | 962713 | 2022-09-09 | China | Liaoning | 1867 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-10 04:21:10 | Liaoning, China | |||
253115 | 253115 | 2022-09-08 | China | Liaoning | 1864 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-09 04:21:11 | Liaoning, China | |||
3744913 | 3744913 | 2022-09-07 | China | Liaoning | 1860 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-08 04:21:02 | Liaoning, China | |||
114553 | 114553 | 2022-09-06 | China | Liaoning | 1857 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-07 04:20:59 | Liaoning, China | |||
2633525 | 2633525 | 2022-09-05 | China | Liaoning | 1855 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-06 04:21:02 | Liaoning, China | |||
2987089 | 2987089 | 2022-09-04 | China | Liaoning | 1852 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-05 04:21:01 | Liaoning, China | |||
2712774 | 2712774 | 2022-09-03 | China | Liaoning | 1839 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-04 04:21:22 | Liaoning, China | |||
1393479 | 1393479 | 2022-09-02 | China | Liaoning | 1827 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-03 04:21:04 | Liaoning, China | |||
3547308 | 3547308 | 2022-09-01 | China | Liaoning | 1818 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-02 04:21:07 | Liaoning, China | |||
2343228 | 2343228 | 2022-08-31 | China | Liaoning | 1813 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-01 04:21:03 | Liaoning, China | |||
3773708 | 3773708 | 2022-08-30 | China | Liaoning | 1804 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-31 04:20:57 | Liaoning, China | |||
1680304 | 1680304 | 2022-08-29 | China | Liaoning | 1799 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-30 04:21:03 | Liaoning, China | |||
1876788 | 1876788 | 2022-08-28 | China | Liaoning | 1797 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-29 04:21:06 | Liaoning, China | |||
2095915 | 2095915 | 2022-08-27 | China | Liaoning | 1793 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-28 04:21:02 | Liaoning, China | |||
1531730 | 1531730 | 2022-08-26 | China | Liaoning | 1787 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-27 04:20:57 | Liaoning, China | |||
2828617 | 2828617 | 2022-08-25 | China | Liaoning | 1784 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-26 04:21:02 | Liaoning, China | |||
2323150 | 2323150 | 2022-08-24 | China | Liaoning | 1780 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-25 04:21:13 | Liaoning, China | |||
1250559 | 1250559 | 2022-08-23 | China | Liaoning | 1778 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-24 04:20:46 | Liaoning, China | |||
2852663 | 2852663 | 2022-08-22 | China | Liaoning | 1777 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-23 04:20:56 | Liaoning, China | |||
2402635 | 2402635 | 2022-08-21 | China | Liaoning | 1775 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-22 04:20:38 | Liaoning, China | |||
3797713 | 3797713 | 2022-08-20 | China | Liaoning | 1772 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-21 04:20:44 | Liaoning, China | |||
2363299 | 2363299 | 2022-08-19 | China | Liaoning | 1766 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-20 04:21:01 | Liaoning, China | |||
1160970 | 1160970 | 2022-08-18 | China | Liaoning | 1761 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-19 04:20:54 | Liaoning, China | |||
3950294 | 3950294 | 2022-08-17 | China | Liaoning | 1761 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-18 04:21:11 | Liaoning, China | |||
990796 | 990796 | 2022-08-16 | China | Liaoning | 1761 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-17 04:20:59 | Liaoning, China | |||
2493835 | 2493835 | 2022-08-15 | China | Liaoning | 1753 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-16 04:20:58 | Liaoning, China | |||
3647385 | 3647385 | 2022-08-14 | China | Liaoning | 1752 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-15 04:20:59 | Liaoning, China | |||
1968391 | 1968391 | 2022-08-13 | China | Liaoning | 1750 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-14 04:20:55 | Liaoning, China | |||
2888200 | 2888200 | 2022-08-12 | China | Liaoning | 1750 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-13 04:20:52 | Liaoning, China | |||
3907805 | 3907805 | 2022-08-11 | China | Liaoning | 1749 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-12 04:20:54 | Liaoning, China | |||
1346122 | 1346122 | 2022-08-10 | China | Liaoning | 1748 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-11 04:20:49 | Liaoning, China | |||
1085877 | 1085877 | 2022-08-09 | China | Liaoning | 1746 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-10 04:20:57 | Liaoning, China | |||
3543292 | 3543292 | 2022-08-08 | China | Liaoning | 1745 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-09 04:20:34 | Liaoning, China | |||
1069695 | 1069695 | 2022-08-07 | China | Liaoning | 1744 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-08 04:21:08 | Liaoning, China | |||
1940283 | 1940283 | 2022-08-06 | China | Liaoning | 1744 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-07 04:20:54 | Liaoning, China | |||
880082 | 880082 | 2022-08-05 | China | Liaoning | 1744 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-06 04:20:56 | Liaoning, China | |||
2008493 | 2008493 | 2022-08-04 | China | Liaoning | 1743 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-05 04:20:52 | Liaoning, China | |||
1097920 | 1097920 | 2022-08-03 | China | Liaoning | 1743 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-04 04:20:58 | Liaoning, China | |||
1404845 | 1404845 | 2022-08-02 | China | Liaoning | 1741 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-03 04:20:59 | Liaoning, China | |||
3616883 | 3616883 | 2022-08-01 | China | Liaoning | 1740 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-02 04:20:53 | Liaoning, China | |||
3871363 | 3871363 | 2022-07-31 | China | Liaoning | 1740 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-01 04:21:03 | Liaoning, China | |||
674117 | 674117 | 2022-07-30 | China | Liaoning | 1739 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-31 04:21:02 | Liaoning, China | |||
1783316 | 1783316 | 2022-07-29 | China | Liaoning | 1738 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-30 04:20:42 | Liaoning, China | |||
1065679 | 1065679 | 2022-07-28 | China | Liaoning | 1736 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-29 04:20:45 | Liaoning, China | |||
2335198 | 2335198 | 2022-07-27 | China | Liaoning | 1736 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-28 04:20:56 | Liaoning, China | |||
1487388 | 1487388 | 2022-07-26 | China | Liaoning | 1735 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-27 04:21:04 | Liaoning, China | |||
2593834 | 2593834 | 2022-07-25 | China | Liaoning | 1734 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-26 04:20:58 | Liaoning, China | |||
895949 | 895949 | 2022-07-24 | China | Liaoning | 1733 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-25 04:20:51 | Liaoning, China | |||
90943 | 90943 | 2022-07-23 | China | Liaoning | 1731 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-24 04:20:47 | Liaoning, China | |||
899965 | 899965 | 2022-07-22 | China | Liaoning | 1731 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-23 04:20:53 | Liaoning, China | |||
670101 | 670101 | 2022-07-21 | China | Liaoning | 1731 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-22 04:21:15 | Liaoning, China | |||
1608064 | 1608064 | 2022-07-20 | China | Liaoning | 1731 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-21 04:21:10 | Liaoning, China | |||
958697 | 958697 | 2022-07-19 | China | Liaoning | 1731 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-20 04:20:59 | Liaoning, China | |||
3210084 | 3210084 | 2022-07-18 | China | Liaoning | 1730 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-19 04:20:58 | Liaoning, China | |||
3405259 | 3405259 | 2022-07-17 | China | Liaoning | 1730 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-18 04:20:59 | Liaoning, China | |||
2151459 | 2151459 | 2022-07-16 | China | Liaoning | 1728 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-17 04:21:15 | Liaoning, China | |||
2418692 | 2418692 | 2022-07-15 | China | Liaoning | 1726 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-16 04:21:05 | Liaoning, China | |||
3428767 | 3428767 | 2022-07-14 | China | Liaoning | 1725 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-15 04:20:53 | Liaoning, China | |||
3109287 | 3109287 | 2022-07-13 | China | Liaoning | 1723 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-14 04:20:57 | Liaoning, China | |||
629710 | 629710 | 2022-07-12 | China | Liaoning | 1723 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-13 04:20:58 | Liaoning, China | |||
1211354 | 1211354 | 2022-07-11 | China | Liaoning | 1723 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-12 04:20:51 | Liaoning, China | |||
2788836 | 2788836 | 2022-07-10 | China | Liaoning | 1723 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-11 04:20:46 | Liaoning, China | |||
141789 | 141789 | 2022-07-09 | China | Liaoning | 1721 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-10 04:20:54 | Liaoning, China | |||
1416889 | 1416889 | 2022-07-08 | China | Liaoning | 1720 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-09 04:20:59 | Liaoning, China | |||
2740814 | 2740814 | 2022-07-07 | China | Liaoning | 1719 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-08 04:20:56 | Liaoning, China | |||
1199609 | 1199609 | 2022-07-06 | China | Liaoning | 1719 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-07 04:20:55 | Liaoning, China | |||
3966352 | 3966352 | 2022-07-05 | China | Liaoning | 1719 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-06 04:20:58 | Liaoning, China | |||
3077863 | 3077863 | 2022-07-04 | China | Liaoning | 1719 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-05 04:20:45 | Liaoning, China | |||
1767145 | 1767145 | 2022-07-03 | China | Liaoning | 1719 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-04 04:20:54 | Liaoning, China | |||
3365131 | 3365131 | 2022-07-02 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-03 04:20:59 | Liaoning, China | |||
593460 | 593460 | 2022-07-01 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-02 04:21:16 | Liaoning, China | |||
3939861 | 3939861 | 2022-06-30 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-01 04:21:10 | Liaoning, China | |||
2489819 | 2489819 | 2022-06-29 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-30 04:21:01 | Liaoning, China | |||
2239201 | 2239201 | 2022-06-28 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-29 04:20:59 | Liaoning, China | |||
2147443 | 2147443 | 2022-06-27 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-28 04:20:58 | Liaoning, China | |||
475244 | 475244 | 2022-06-26 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-27 04:21:00 | Liaoning, China | |||
938619 | 938619 | 2022-06-25 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-26 04:21:02 | Liaoning, China | |||
3346439 | 3346439 | 2022-06-24 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-25 04:20:57 | Liaoning, China | |||
1648180 | 1648180 | 2022-06-23 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-24 04:20:58 | Liaoning, China | |||
2187415 | 2187415 | 2022-06-22 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-23 04:20:55 | Liaoning, China | |||
165846 | 165846 | 2022-06-21 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-22 04:20:54 | Liaoning, China | |||
1763129 | 1763129 | 2022-06-20 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-21 04:20:56 | Liaoning, China | |||
3269315 | 3269315 | 2022-06-19 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-20 04:21:01 | Liaoning, China | |||
3397227 | 3397227 | 2022-06-18 | China | Liaoning | 1718 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-19 04:20:51 | Liaoning, China | |||
2311104 | 2311104 | 2022-06-17 | China | Liaoning | 1717 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-18 04:21:10 | Liaoning, China | |||
558608 | 558608 | 2022-06-16 | China | Liaoning | 1713 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-17 04:20:56 | Liaoning, China | |||
3982410 | 3982410 | 2022-06-15 | China | Liaoning | 1709 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-16 04:20:55 | Liaoning, China | |||
946651 | 946651 | 2022-06-14 | China | Liaoning | 1706 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-15 04:20:54 | Liaoning, China | |||
2979059 | 2979059 | 2022-06-13 | China | Liaoning | 1704 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-14 04:20:52 | Liaoning, 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]);