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 = "Tianjin" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016534 | 2016534 | 2022-09-20 | China | Tianjin | 2305 | 3 | 0 | 39.3054 | 117.323 | 2022-09-21 04:23:22 | Tianjin, China | |||
3570407 | 3570407 | 2022-09-19 | China | Tianjin | 2302 | 3 | 0 | 39.3054 | 117.323 | 2022-09-20 04:22:48 | Tianjin, China | |||
419146 | 419146 | 2022-09-18 | China | Tianjin | 2298 | 3 | 0 | 39.3054 | 117.323 | 2022-09-19 04:21:49 | Tianjin, China | |||
3373170 | 3373170 | 2022-09-17 | China | Tianjin | 2290 | 3 | 0 | 39.3054 | 117.323 | 2022-09-18 04:22:50 | Tianjin, China | |||
2355278 | 2355278 | 2022-09-16 | China | Tianjin | 2287 | 3 | 0 | 39.3054 | 117.323 | 2022-09-17 04:20:19 | Tianjin, China | |||
3986435 | 3986435 | 2022-09-15 | China | Tianjin | 2280 | 3 | 0 | 39.3054 | 117.323 | 2022-09-16 04:21:19 | Tianjin, China | |||
1888952 | 1888952 | 2022-09-14 | China | Tianjin | 2269 | 3 | 0 | 39.3054 | 117.323 | 2022-09-15 04:21:02 | Tianjin, China | |||
372007 | 372007 | 2022-09-13 | China | Tianjin | 2268 | 3 | 0 | 39.3054 | 117.323 | 2022-09-14 04:20:44 | Tianjin, China | |||
2394612 | 2394612 | 2022-09-12 | China | Tianjin | 2267 | 3 | 0 | 39.3054 | 117.323 | 2022-09-13 04:20:57 | Tianjin, China | |||
3765690 | 3765690 | 2022-09-11 | China | Tianjin | 2259 | 3 | 0 | 39.3054 | 117.323 | 2022-09-12 04:20:58 | Tianjin, China | |||
3824265 | 3824265 | 2022-09-10 | China | Tianjin | 2244 | 3 | 0 | 39.3054 | 117.323 | 2022-09-11 04:20:50 | Tianjin, China | |||
962722 | 962722 | 2022-09-09 | China | Tianjin | 2242 | 3 | 0 | 39.3054 | 117.323 | 2022-09-10 04:21:10 | Tianjin, China | |||
253124 | 253124 | 2022-09-08 | China | Tianjin | 2237 | 3 | 0 | 39.3054 | 117.323 | 2022-09-09 04:21:11 | Tianjin, China | |||
3744922 | 3744922 | 2022-09-07 | China | Tianjin | 2235 | 3 | 0 | 39.3054 | 117.323 | 2022-09-08 04:21:02 | Tianjin, China | |||
114562 | 114562 | 2022-09-06 | China | Tianjin | 2233 | 3 | 0 | 39.3054 | 117.323 | 2022-09-07 04:20:59 | Tianjin, China | |||
2633534 | 2633534 | 2022-09-05 | China | Tianjin | 2229 | 3 | 0 | 39.3054 | 117.323 | 2022-09-06 04:21:02 | Tianjin, China | |||
2987098 | 2987098 | 2022-09-04 | China | Tianjin | 2228 | 3 | 0 | 39.3054 | 117.323 | 2022-09-05 04:21:01 | Tianjin, China | |||
2712783 | 2712783 | 2022-09-03 | China | Tianjin | 2225 | 3 | 0 | 39.3054 | 117.323 | 2022-09-04 04:21:22 | Tianjin, China | |||
1393488 | 1393488 | 2022-09-02 | China | Tianjin | 2219 | 3 | 0 | 39.3054 | 117.323 | 2022-09-03 04:21:04 | Tianjin, China | |||
3547317 | 3547317 | 2022-09-01 | China | Tianjin | 2214 | 3 | 0 | 39.3054 | 117.323 | 2022-09-02 04:21:07 | Tianjin, China | |||
2343237 | 2343237 | 2022-08-31 | China | Tianjin | 2213 | 3 | 0 | 39.3054 | 117.323 | 2022-09-01 04:21:03 | Tianjin, China | |||
3773717 | 3773717 | 2022-08-30 | China | Tianjin | 2201 | 3 | 0 | 39.3054 | 117.323 | 2022-08-31 04:20:57 | Tianjin, China | |||
1680313 | 1680313 | 2022-08-29 | China | Tianjin | 2180 | 3 | 0 | 39.3054 | 117.323 | 2022-08-30 04:21:03 | Tianjin, China | |||
1876797 | 1876797 | 2022-08-28 | China | Tianjin | 2171 | 3 | 0 | 39.3054 | 117.323 | 2022-08-29 04:21:06 | Tianjin, China | |||
2095924 | 2095924 | 2022-08-27 | China | Tianjin | 2162 | 3 | 0 | 39.3054 | 117.323 | 2022-08-28 04:21:02 | Tianjin, China | |||
1531739 | 1531739 | 2022-08-26 | China | Tianjin | 2158 | 3 | 0 | 39.3054 | 117.323 | 2022-08-27 04:20:57 | Tianjin, China | |||
2828626 | 2828626 | 2022-08-25 | China | Tianjin | 2155 | 3 | 0 | 39.3054 | 117.323 | 2022-08-26 04:21:02 | Tianjin, China | |||
2323159 | 2323159 | 2022-08-24 | China | Tianjin | 2155 | 3 | 0 | 39.3054 | 117.323 | 2022-08-25 04:21:13 | Tianjin, China | |||
1250568 | 1250568 | 2022-08-23 | China | Tianjin | 2149 | 3 | 0 | 39.3054 | 117.323 | 2022-08-24 04:20:46 | Tianjin, China | |||
2852672 | 2852672 | 2022-08-22 | China | Tianjin | 2149 | 3 | 0 | 39.3054 | 117.323 | 2022-08-23 04:20:56 | Tianjin, China | |||
2402644 | 2402644 | 2022-08-21 | China | Tianjin | 2128 | 3 | 0 | 39.3054 | 117.323 | 2022-08-22 04:20:38 | Tianjin, China | |||
3797722 | 3797722 | 2022-08-20 | China | Tianjin | 2115 | 3 | 0 | 39.3054 | 117.323 | 2022-08-21 04:20:44 | Tianjin, China | |||
2363308 | 2363308 | 2022-08-19 | China | Tianjin | 2112 | 3 | 0 | 39.3054 | 117.323 | 2022-08-20 04:21:01 | Tianjin, China | |||
1160979 | 1160979 | 2022-08-18 | China | Tianjin | 2108 | 3 | 0 | 39.3054 | 117.323 | 2022-08-19 04:20:54 | Tianjin, China | |||
3950303 | 3950303 | 2022-08-17 | China | Tianjin | 2107 | 3 | 0 | 39.3054 | 117.323 | 2022-08-18 04:21:11 | Tianjin, China | |||
990805 | 990805 | 2022-08-16 | China | Tianjin | 2096 | 3 | 0 | 39.3054 | 117.323 | 2022-08-17 04:20:59 | Tianjin, China | |||
2493844 | 2493844 | 2022-08-15 | China | Tianjin | 2096 | 3 | 0 | 39.3054 | 117.323 | 2022-08-16 04:20:58 | Tianjin, China | |||
3647394 | 3647394 | 2022-08-14 | China | Tianjin | 2095 | 3 | 0 | 39.3054 | 117.323 | 2022-08-15 04:20:59 | Tianjin, China | |||
1968400 | 1968400 | 2022-08-13 | China | Tianjin | 2095 | 3 | 0 | 39.3054 | 117.323 | 2022-08-14 04:20:55 | Tianjin, China | |||
2888209 | 2888209 | 2022-08-12 | China | Tianjin | 2095 | 3 | 0 | 39.3054 | 117.323 | 2022-08-13 04:20:52 | Tianjin, China | |||
3907814 | 3907814 | 2022-08-11 | China | Tianjin | 2093 | 3 | 0 | 39.3054 | 117.323 | 2022-08-12 04:20:54 | Tianjin, China | |||
1346131 | 1346131 | 2022-08-10 | China | Tianjin | 2091 | 3 | 0 | 39.3054 | 117.323 | 2022-08-11 04:20:49 | Tianjin, China | |||
1085886 | 1085886 | 2022-08-09 | China | Tianjin | 2088 | 3 | 0 | 39.3054 | 117.323 | 2022-08-10 04:20:57 | Tianjin, China | |||
3543301 | 3543301 | 2022-08-08 | China | Tianjin | 2088 | 3 | 0 | 39.3054 | 117.323 | 2022-08-09 04:20:34 | Tianjin, China | |||
1069704 | 1069704 | 2022-08-07 | China | Tianjin | 2087 | 3 | 0 | 39.3054 | 117.323 | 2022-08-08 04:21:08 | Tianjin, China | |||
1940292 | 1940292 | 2022-08-06 | China | Tianjin | 2086 | 3 | 0 | 39.3054 | 117.323 | 2022-08-07 04:20:54 | Tianjin, China | |||
880091 | 880091 | 2022-08-05 | China | Tianjin | 2086 | 3 | 0 | 39.3054 | 117.323 | 2022-08-06 04:20:56 | Tianjin, China | |||
2008502 | 2008502 | 2022-08-04 | China | Tianjin | 2085 | 3 | 0 | 39.3054 | 117.323 | 2022-08-05 04:20:52 | Tianjin, China | |||
1097929 | 1097929 | 2022-08-03 | China | Tianjin | 2085 | 3 | 0 | 39.3054 | 117.323 | 2022-08-04 04:20:58 | Tianjin, China | |||
1404854 | 1404854 | 2022-08-02 | China | Tianjin | 2085 | 3 | 0 | 39.3054 | 117.323 | 2022-08-03 04:20:59 | Tianjin, China | |||
3616892 | 3616892 | 2022-08-01 | China | Tianjin | 2083 | 3 | 0 | 39.3054 | 117.323 | 2022-08-02 04:20:53 | Tianjin, China | |||
3871372 | 3871372 | 2022-07-31 | China | Tianjin | 2083 | 3 | 0 | 39.3054 | 117.323 | 2022-08-01 04:21:03 | Tianjin, China | |||
674126 | 674126 | 2022-07-30 | China | Tianjin | 2081 | 3 | 0 | 39.3054 | 117.323 | 2022-07-31 04:21:02 | Tianjin, China | |||
1783325 | 1783325 | 2022-07-29 | China | Tianjin | 2080 | 3 | 0 | 39.3054 | 117.323 | 2022-07-30 04:20:42 | Tianjin, China | |||
1065688 | 1065688 | 2022-07-28 | China | Tianjin | 2080 | 3 | 0 | 39.3054 | 117.323 | 2022-07-29 04:20:45 | Tianjin, China | |||
2335207 | 2335207 | 2022-07-27 | China | Tianjin | 2079 | 3 | 0 | 39.3054 | 117.323 | 2022-07-28 04:20:56 | Tianjin, China | |||
1487397 | 1487397 | 2022-07-26 | China | Tianjin | 2079 | 3 | 0 | 39.3054 | 117.323 | 2022-07-27 04:21:04 | Tianjin, China | |||
2593843 | 2593843 | 2022-07-25 | China | Tianjin | 2078 | 3 | 0 | 39.3054 | 117.323 | 2022-07-26 04:20:58 | Tianjin, China | |||
895958 | 895958 | 2022-07-24 | China | Tianjin | 2077 | 3 | 0 | 39.3054 | 117.323 | 2022-07-25 04:20:51 | Tianjin, China | |||
90952 | 90952 | 2022-07-23 | China | Tianjin | 2075 | 3 | 0 | 39.3054 | 117.323 | 2022-07-24 04:20:47 | Tianjin, China | |||
899974 | 899974 | 2022-07-22 | China | Tianjin | 2073 | 3 | 0 | 39.3054 | 117.323 | 2022-07-23 04:20:53 | Tianjin, China | |||
670110 | 670110 | 2022-07-21 | China | Tianjin | 2068 | 3 | 0 | 39.3054 | 117.323 | 2022-07-22 04:21:15 | Tianjin, China | |||
1608073 | 1608073 | 2022-07-20 | China | Tianjin | 2066 | 3 | 0 | 39.3054 | 117.323 | 2022-07-21 04:21:10 | Tianjin, China | |||
958706 | 958706 | 2022-07-19 | China | Tianjin | 2065 | 3 | 0 | 39.3054 | 117.323 | 2022-07-20 04:20:59 | Tianjin, China | |||
3210093 | 3210093 | 2022-07-18 | China | Tianjin | 2060 | 3 | 0 | 39.3054 | 117.323 | 2022-07-19 04:20:58 | Tianjin, China | |||
3405268 | 3405268 | 2022-07-17 | China | Tianjin | 2052 | 3 | 0 | 39.3054 | 117.323 | 2022-07-18 04:20:59 | Tianjin, China | |||
2151468 | 2151468 | 2022-07-16 | China | Tianjin | 2050 | 3 | 0 | 39.3054 | 117.323 | 2022-07-17 04:21:15 | Tianjin, China | |||
2418701 | 2418701 | 2022-07-15 | China | Tianjin | 2046 | 3 | 0 | 39.3054 | 117.323 | 2022-07-16 04:21:05 | Tianjin, China | |||
3428776 | 3428776 | 2022-07-14 | China | Tianjin | 2038 | 3 | 0 | 39.3054 | 117.323 | 2022-07-15 04:20:53 | Tianjin, China | |||
3109296 | 3109296 | 2022-07-13 | China | Tianjin | 2036 | 3 | 0 | 39.3054 | 117.323 | 2022-07-14 04:20:57 | Tianjin, China | |||
629719 | 629719 | 2022-07-12 | China | Tianjin | 2035 | 3 | 0 | 39.3054 | 117.323 | 2022-07-13 04:20:58 | Tianjin, China | |||
1211363 | 1211363 | 2022-07-11 | China | Tianjin | 2033 | 3 | 0 | 39.3054 | 117.323 | 2022-07-12 04:20:51 | Tianjin, China | |||
2788845 | 2788845 | 2022-07-10 | China | Tianjin | 2029 | 3 | 0 | 39.3054 | 117.323 | 2022-07-11 04:20:46 | Tianjin, China | |||
141798 | 141798 | 2022-07-09 | China | Tianjin | 2027 | 3 | 0 | 39.3054 | 117.323 | 2022-07-10 04:20:54 | Tianjin, China | |||
1416898 | 1416898 | 2022-07-08 | China | Tianjin | 2026 | 3 | 0 | 39.3054 | 117.323 | 2022-07-09 04:20:59 | Tianjin, China | |||
2740823 | 2740823 | 2022-07-07 | China | Tianjin | 2023 | 3 | 0 | 39.3054 | 117.323 | 2022-07-08 04:20:56 | Tianjin, China | |||
1199618 | 1199618 | 2022-07-06 | China | Tianjin | 2018 | 3 | 0 | 39.3054 | 117.323 | 2022-07-07 04:20:55 | Tianjin, China | |||
3966361 | 3966361 | 2022-07-05 | China | Tianjin | 2017 | 3 | 0 | 39.3054 | 117.323 | 2022-07-06 04:20:58 | Tianjin, China | |||
3077872 | 3077872 | 2022-07-04 | China | Tianjin | 2016 | 3 | 0 | 39.3054 | 117.323 | 2022-07-05 04:20:45 | Tianjin, China | |||
1767154 | 1767154 | 2022-07-03 | China | Tianjin | 2012 | 3 | 0 | 39.3054 | 117.323 | 2022-07-04 04:20:54 | Tianjin, China | |||
3365140 | 3365140 | 2022-07-02 | China | Tianjin | 2011 | 3 | 0 | 39.3054 | 117.323 | 2022-07-03 04:20:59 | Tianjin, China | |||
593469 | 593469 | 2022-07-01 | China | Tianjin | 2011 | 3 | 0 | 39.3054 | 117.323 | 2022-07-02 04:21:16 | Tianjin, China | |||
3939870 | 3939870 | 2022-06-30 | China | Tianjin | 2010 | 3 | 0 | 39.3054 | 117.323 | 2022-07-01 04:21:10 | Tianjin, China | |||
2489828 | 2489828 | 2022-06-29 | China | Tianjin | 2008 | 3 | 0 | 39.3054 | 117.323 | 2022-06-30 04:21:01 | Tianjin, China | |||
2239210 | 2239210 | 2022-06-28 | China | Tianjin | 2008 | 3 | 0 | 39.3054 | 117.323 | 2022-06-29 04:20:59 | Tianjin, China | |||
2147452 | 2147452 | 2022-06-27 | China | Tianjin | 2008 | 3 | 0 | 39.3054 | 117.323 | 2022-06-28 04:20:58 | Tianjin, China | |||
475253 | 475253 | 2022-06-26 | China | Tianjin | 2008 | 3 | 0 | 39.3054 | 117.323 | 2022-06-27 04:21:00 | Tianjin, China | |||
938628 | 938628 | 2022-06-25 | China | Tianjin | 2003 | 3 | 0 | 39.3054 | 117.323 | 2022-06-26 04:21:02 | Tianjin, China | |||
3346448 | 3346448 | 2022-06-24 | China | Tianjin | 1995 | 3 | 0 | 39.3054 | 117.323 | 2022-06-25 04:20:57 | Tianjin, China | |||
1648189 | 1648189 | 2022-06-23 | China | Tianjin | 1994 | 3 | 0 | 39.3054 | 117.323 | 2022-06-24 04:20:58 | Tianjin, China | |||
2187424 | 2187424 | 2022-06-22 | China | Tianjin | 1993 | 3 | 0 | 39.3054 | 117.323 | 2022-06-23 04:20:55 | Tianjin, China | |||
165855 | 165855 | 2022-06-21 | China | Tianjin | 1993 | 3 | 0 | 39.3054 | 117.323 | 2022-06-22 04:20:54 | Tianjin, China | |||
1763138 | 1763138 | 2022-06-20 | China | Tianjin | 1989 | 3 | 0 | 39.3054 | 117.323 | 2022-06-21 04:20:56 | Tianjin, China | |||
3269324 | 3269324 | 2022-06-19 | China | Tianjin | 1988 | 3 | 0 | 39.3054 | 117.323 | 2022-06-20 04:21:01 | Tianjin, China | |||
3397236 | 3397236 | 2022-06-18 | China | Tianjin | 1985 | 3 | 0 | 39.3054 | 117.323 | 2022-06-19 04:20:51 | Tianjin, China | |||
2311113 | 2311113 | 2022-06-17 | China | Tianjin | 1985 | 3 | 0 | 39.3054 | 117.323 | 2022-06-18 04:21:10 | Tianjin, China | |||
558617 | 558617 | 2022-06-16 | China | Tianjin | 1985 | 3 | 0 | 39.3054 | 117.323 | 2022-06-17 04:20:56 | Tianjin, China | |||
3982419 | 3982419 | 2022-06-15 | China | Tianjin | 1985 | 3 | 0 | 39.3054 | 117.323 | 2022-06-16 04:20:55 | Tianjin, China | |||
946660 | 946660 | 2022-06-14 | China | Tianjin | 1985 | 3 | 0 | 39.3054 | 117.323 | 2022-06-15 04:20:54 | Tianjin, China | |||
2979068 | 2979068 | 2022-06-13 | China | Tianjin | 1984 | 3 | 0 | 39.3054 | 117.323 | 2022-06-14 04:20:52 | Tianjin, 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]);