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 = "Qinghai" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016528 | 2016528 | 2022-09-20 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-21 04:23:22 | Qinghai, China | |||
3570401 | 3570401 | 2022-09-19 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-20 04:22:48 | Qinghai, China | |||
419140 | 419140 | 2022-09-18 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-19 04:21:49 | Qinghai, China | |||
3373164 | 3373164 | 2022-09-17 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-18 04:22:50 | Qinghai, China | |||
2355272 | 2355272 | 2022-09-16 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-17 04:20:19 | Qinghai, China | |||
3986429 | 3986429 | 2022-09-15 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-16 04:21:19 | Qinghai, China | |||
1888946 | 1888946 | 2022-09-14 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-15 04:21:02 | Qinghai, China | |||
372001 | 372001 | 2022-09-13 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-14 04:20:44 | Qinghai, China | |||
2394606 | 2394606 | 2022-09-12 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-13 04:20:57 | Qinghai, China | |||
3765684 | 3765684 | 2022-09-11 | China | Qinghai | 233 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-12 04:20:58 | Qinghai, China | |||
3824259 | 3824259 | 2022-09-10 | China | Qinghai | 231 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-11 04:20:50 | Qinghai, China | |||
962716 | 962716 | 2022-09-09 | China | Qinghai | 230 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-10 04:21:10 | Qinghai, China | |||
253118 | 253118 | 2022-09-08 | China | Qinghai | 227 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-09 04:21:11 | Qinghai, China | |||
3744916 | 3744916 | 2022-09-07 | China | Qinghai | 220 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-08 04:21:02 | Qinghai, China | |||
114556 | 114556 | 2022-09-06 | China | Qinghai | 219 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-07 04:20:59 | Qinghai, China | |||
2633528 | 2633528 | 2022-09-05 | China | Qinghai | 218 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-06 04:21:02 | Qinghai, China | |||
2987092 | 2987092 | 2022-09-04 | China | Qinghai | 216 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-05 04:21:01 | Qinghai, China | |||
2712777 | 2712777 | 2022-09-03 | China | Qinghai | 212 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-04 04:21:22 | Qinghai, China | |||
1393482 | 1393482 | 2022-09-02 | China | Qinghai | 204 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-03 04:21:04 | Qinghai, China | |||
3547311 | 3547311 | 2022-09-01 | China | Qinghai | 199 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-02 04:21:07 | Qinghai, China | |||
2343231 | 2343231 | 2022-08-31 | China | Qinghai | 194 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-01 04:21:03 | Qinghai, China | |||
3773711 | 3773711 | 2022-08-30 | China | Qinghai | 190 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-31 04:20:57 | Qinghai, China | |||
1680307 | 1680307 | 2022-08-29 | China | Qinghai | 181 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-30 04:21:03 | Qinghai, China | |||
1876791 | 1876791 | 2022-08-28 | China | Qinghai | 179 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-29 04:21:06 | Qinghai, China | |||
2095918 | 2095918 | 2022-08-27 | China | Qinghai | 179 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-28 04:21:02 | Qinghai, China | |||
1531733 | 1531733 | 2022-08-26 | China | Qinghai | 179 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-27 04:20:57 | Qinghai, China | |||
2828620 | 2828620 | 2022-08-25 | China | Qinghai | 177 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-26 04:21:02 | Qinghai, China | |||
2323153 | 2323153 | 2022-08-24 | China | Qinghai | 174 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-25 04:21:13 | Qinghai, China | |||
1250562 | 1250562 | 2022-08-23 | China | Qinghai | 171 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-24 04:20:46 | Qinghai, China | |||
2852666 | 2852666 | 2022-08-22 | China | Qinghai | 168 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-23 04:20:56 | Qinghai, China | |||
2402638 | 2402638 | 2022-08-21 | China | Qinghai | 166 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-22 04:20:38 | Qinghai, China | |||
3797716 | 3797716 | 2022-08-20 | China | Qinghai | 166 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-21 04:20:44 | Qinghai, China | |||
2363302 | 2363302 | 2022-08-19 | China | Qinghai | 162 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-20 04:21:01 | Qinghai, China | |||
1160973 | 1160973 | 2022-08-18 | China | Qinghai | 162 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-19 04:20:54 | Qinghai, China | |||
3950297 | 3950297 | 2022-08-17 | China | Qinghai | 161 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-18 04:21:11 | Qinghai, China | |||
990799 | 990799 | 2022-08-16 | China | Qinghai | 158 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-17 04:20:59 | Qinghai, China | |||
2493838 | 2493838 | 2022-08-15 | China | Qinghai | 156 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-16 04:20:58 | Qinghai, China | |||
3647388 | 3647388 | 2022-08-14 | China | Qinghai | 154 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-15 04:20:59 | Qinghai, China | |||
1968394 | 1968394 | 2022-08-13 | China | Qinghai | 151 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-14 04:20:55 | Qinghai, China | |||
2888203 | 2888203 | 2022-08-12 | China | Qinghai | 150 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-13 04:20:52 | Qinghai, China | |||
3907808 | 3907808 | 2022-08-11 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-12 04:20:54 | Qinghai, China | |||
1346125 | 1346125 | 2022-08-10 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-11 04:20:49 | Qinghai, China | |||
1085880 | 1085880 | 2022-08-09 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-10 04:20:57 | Qinghai, China | |||
3543295 | 3543295 | 2022-08-08 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-09 04:20:34 | Qinghai, China | |||
1069698 | 1069698 | 2022-08-07 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-08 04:21:08 | Qinghai, China | |||
1940286 | 1940286 | 2022-08-06 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-07 04:20:54 | Qinghai, China | |||
880085 | 880085 | 2022-08-05 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-06 04:20:56 | Qinghai, China | |||
2008496 | 2008496 | 2022-08-04 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-05 04:20:52 | Qinghai, China | |||
1097923 | 1097923 | 2022-08-03 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-04 04:20:58 | Qinghai, China | |||
1404848 | 1404848 | 2022-08-02 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-03 04:20:59 | Qinghai, China | |||
3616886 | 3616886 | 2022-08-01 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-02 04:20:53 | Qinghai, China | |||
3871366 | 3871366 | 2022-07-31 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-01 04:21:03 | Qinghai, China | |||
674120 | 674120 | 2022-07-30 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-31 04:21:02 | Qinghai, China | |||
1783319 | 1783319 | 2022-07-29 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-30 04:20:42 | Qinghai, China | |||
1065682 | 1065682 | 2022-07-28 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-29 04:20:45 | Qinghai, China | |||
2335201 | 2335201 | 2022-07-27 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-28 04:20:56 | Qinghai, China | |||
1487391 | 1487391 | 2022-07-26 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-27 04:21:04 | Qinghai, China | |||
2593837 | 2593837 | 2022-07-25 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-26 04:20:58 | Qinghai, China | |||
895952 | 895952 | 2022-07-24 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-25 04:20:51 | Qinghai, China | |||
90946 | 90946 | 2022-07-23 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-24 04:20:47 | Qinghai, China | |||
899968 | 899968 | 2022-07-22 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-23 04:20:53 | Qinghai, China | |||
670104 | 670104 | 2022-07-21 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-22 04:21:15 | Qinghai, China | |||
1608067 | 1608067 | 2022-07-20 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-21 04:21:10 | Qinghai, China | |||
958700 | 958700 | 2022-07-19 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-20 04:20:59 | Qinghai, China | |||
3210087 | 3210087 | 2022-07-18 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-19 04:20:58 | Qinghai, China | |||
3405262 | 3405262 | 2022-07-17 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-18 04:20:59 | Qinghai, China | |||
2151462 | 2151462 | 2022-07-16 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-17 04:21:15 | Qinghai, China | |||
2418695 | 2418695 | 2022-07-15 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-16 04:21:05 | Qinghai, China | |||
3428770 | 3428770 | 2022-07-14 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-15 04:20:53 | Qinghai, China | |||
3109290 | 3109290 | 2022-07-13 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-14 04:20:57 | Qinghai, China | |||
629713 | 629713 | 2022-07-12 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-13 04:20:58 | Qinghai, China | |||
1211357 | 1211357 | 2022-07-11 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-12 04:20:51 | Qinghai, China | |||
2788839 | 2788839 | 2022-07-10 | China | Qinghai | 148 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-11 04:20:46 | Qinghai, China | |||
141792 | 141792 | 2022-07-09 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-10 04:20:54 | Qinghai, China | |||
1416892 | 1416892 | 2022-07-08 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-09 04:20:59 | Qinghai, China | |||
2740817 | 2740817 | 2022-07-07 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-08 04:20:56 | Qinghai, China | |||
1199612 | 1199612 | 2022-07-06 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-07 04:20:55 | Qinghai, China | |||
3966355 | 3966355 | 2022-07-05 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-06 04:20:58 | Qinghai, China | |||
3077866 | 3077866 | 2022-07-04 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-05 04:20:45 | Qinghai, China | |||
1767148 | 1767148 | 2022-07-03 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-04 04:20:54 | Qinghai, China | |||
3365134 | 3365134 | 2022-07-02 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-03 04:20:59 | Qinghai, China | |||
593463 | 593463 | 2022-07-01 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-02 04:21:16 | Qinghai, China | |||
3939864 | 3939864 | 2022-06-30 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-07-01 04:21:10 | Qinghai, China | |||
2489822 | 2489822 | 2022-06-29 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-30 04:21:01 | Qinghai, China | |||
2239204 | 2239204 | 2022-06-28 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-29 04:20:59 | Qinghai, China | |||
2147446 | 2147446 | 2022-06-27 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-28 04:20:58 | Qinghai, China | |||
475247 | 475247 | 2022-06-26 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-27 04:21:00 | Qinghai, China | |||
938622 | 938622 | 2022-06-25 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-26 04:21:02 | Qinghai, China | |||
3346442 | 3346442 | 2022-06-24 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-25 04:20:57 | Qinghai, China | |||
1648183 | 1648183 | 2022-06-23 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-24 04:20:58 | Qinghai, China | |||
2187418 | 2187418 | 2022-06-22 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-23 04:20:55 | Qinghai, China | |||
165849 | 165849 | 2022-06-21 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-22 04:20:54 | Qinghai, China | |||
1763132 | 1763132 | 2022-06-20 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-21 04:20:56 | Qinghai, China | |||
3269318 | 3269318 | 2022-06-19 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-20 04:21:01 | Qinghai, China | |||
3397230 | 3397230 | 2022-06-18 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-19 04:20:51 | Qinghai, China | |||
2311107 | 2311107 | 2022-06-17 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-18 04:21:10 | Qinghai, China | |||
558611 | 558611 | 2022-06-16 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-17 04:20:56 | Qinghai, China | |||
3982413 | 3982413 | 2022-06-15 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-16 04:20:55 | Qinghai, China | |||
946654 | 946654 | 2022-06-14 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-15 04:20:54 | Qinghai, China | |||
2979062 | 2979062 | 2022-06-13 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-06-14 04:20:52 | Qinghai, 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]);