johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,075 rows where province_or_state = "Gansu" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, latitude, day (date), last_update (date)
country_or_region 2
- China 1,024
- Mainland China 51
province_or_state 1
- Gansu · 1,075 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116 | 116 | 2021-12-02 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-12-03 04:23:05 | Gansu, China | |||
4132 | 4132 | 2021-10-28 | China | Gansu | 275 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-29 04:22:03 | Gansu, China | |||
16157 | 16157 | 2021-09-18 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-09-19 04:21:34 | Gansu, China | |||
24187 | 24187 | 2022-03-20 | China | Gansu | 652 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-21 04:20:50 | Gansu, China | |||
28202 | 28202 | 2021-11-11 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-12 04:22:01 | Gansu, China | |||
32218 | 32218 | 2021-08-25 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-08-26 04:21:28 | Gansu, China | |||
43494 | 43494 | 2021-11-02 | China | Gansu | 327 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-03 06:22:09 | Gansu, China | |||
62848 | 62848 | 2022-11-12 | China | Gansu | 1442 | 2 | 0 | 35.7518 | 104.2861 | 2022-11-13 04:21:14 | Gansu, China | |||
66863 | 66863 | 2021-09-01 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-09-02 04:21:15 | Gansu, China | |||
70877 | 70877 | 2022-02-07 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-08 04:21:15 | Gansu, China | |||
86911 | 86911 | 2021-11-09 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-10 04:21:38 | Gansu, China | |||
90928 | 90928 | 2022-07-23 | China | Gansu | 1128 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-24 04:20:47 | Gansu, China | |||
99112 | 99112 | 2022-01-14 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-01-15 04:21:07 | Gansu, China | |||
103128 | 103128 | 2021-08-15 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-08-16 04:21:31 | Gansu, China | |||
114538 | 114538 | 2022-09-06 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-07 04:20:59 | Gansu, China | |||
126519 | 126519 | 2022-01-09 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-01-10 04:22:07 | Gansu, China | |||
130536 | 130536 | 2022-10-04 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-10-05 04:23:06 | Gansu, China | |||
137757 | 137757 | 2021-12-04 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-12-05 04:22:25 | Gansu, China | |||
141774 | 141774 | 2022-07-09 | China | Gansu | 691 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-10 04:20:54 | Gansu, China | |||
149770 | 149770 | 2021-11-29 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-30 04:22:53 | Gansu, China | |||
157799 | 157799 | 2022-03-29 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-30 04:20:45 | Gansu, China | |||
161814 | 161814 | 2021-11-19 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-20 04:22:17 | Gansu, China | |||
165831 | 165831 | 2022-06-21 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-22 04:20:54 | Gansu, China | |||
177828 | 177828 | 2021-09-02 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-09-03 04:21:20 | Gansu, China | |||
185857 | 185857 | 2022-02-13 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-14 04:20:51 | Gansu, China | |||
197787 | 197787 | 2020-01-24 | Mainland China | Gansu | 2 | 0 | 0 | 36.0611 | 103.8343 | 1/24/20 17:00 | ||||
197861 | 197861 | 2020-01-29 | Mainland China | Gansu | 24 | 0 | 0 | 36.0611 | 103.8343 | 1/29/20 19:30 | ||||
198045 | 198045 | 2022-10-19 | China | Gansu | 1351 | 2 | 0 | 35.7518 | 104.2861 | 2022-10-20 04:22:59 | Gansu, China | |||
217766 | 217766 | 2022-12-26 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-27 04:21:07 | Gansu, China | |||
221782 | 221782 | 2022-05-09 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-05-10 04:20:50 | Gansu, China | |||
229013 | 229013 | 2022-05-31 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-01 04:20:55 | Gansu, China | |||
233029 | 233029 | 2022-02-11 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-12 04:21:06 | Gansu, China | |||
245071 | 245071 | 2021-08-17 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-08-18 04:21:35 | Gansu, China | |||
249085 | 249085 | 2021-09-04 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-09-05 04:21:33 | Gansu, China | |||
253100 | 253100 | 2022-09-08 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-09 04:21:11 | Gansu, China | |||
257116 | 257116 | 2022-12-10 | China | Gansu | 1561 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-11 04:20:50 | Gansu, China | |||
261319 | 261319 | 2022-03-15 | China | Gansu | 560 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-16 04:20:50 | Gansu, China | |||
275969 | 275969 | 2021-11-03 | China | Gansu | 329 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-04 04:22:20 | Gansu, China | |||
287782 | 287782 | 2021-10-31 | China | Gansu | 305 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-01 04:22:01 | Gansu, China | |||
291799 | 291799 | 2022-11-15 | China | Gansu | 1468 | 2 | 0 | 35.7518 | 104.2861 | 2022-11-16 04:21:09 | Gansu, China | |||
303655 | 303655 | 2022-04-16 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-04-17 04:20:59 | Gansu, China | |||
307671 | 307671 | 2022-12-13 | China | Gansu | 1561 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-14 04:21:04 | Gansu, China | |||
311687 | 311687 | 2022-11-13 | China | Gansu | 1442 | 2 | 0 | 35.7518 | 104.2861 | 2022-11-14 04:21:09 | Gansu, China | |||
315703 | 315703 | 2022-02-12 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-13 04:21:00 | Gansu, China | |||
319719 | 319719 | 2022-10-30 | China | Gansu | 1359 | 2 | 0 | 35.7518 | 104.2861 | 2022-10-31 04:21:36 | Gansu, China | |||
327693 | 327693 | 2022-12-27 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-28 04:21:04 | Gansu, China | |||
335723 | 335723 | 2022-03-18 | China | Gansu | 617 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-19 04:20:47 | Gansu, China | |||
348083 | 348083 | 2022-12-14 | China | Gansu | 1561 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-15 04:20:58 | Gansu, China | |||
356113 | 356113 | 2022-03-11 | China | Gansu | 535 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-12 04:20:50 | Gansu, China | |||
360129 | 360129 | 2022-05-07 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-05-08 04:20:49 | Gansu, China | |||
371983 | 371983 | 2022-09-13 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-14 04:20:44 | Gansu, China | |||
384010 | 384010 | 2022-09-23 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-24 04:21:40 | Gansu, China | |||
396051 | 396051 | 2022-10-07 | China | Gansu | 1351 | 2 | 0 | 35.7518 | 104.2861 | 2022-10-08 04:22:56 | Gansu, China | |||
404080 | 404080 | 2021-12-07 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-12-08 04:22:46 | Gansu, China | |||
415856 | 415856 | 2020-01-26 | Mainland China | Gansu | 7 | 0 | 0 | 36.0611 | 103.8343 | 1/26/20 16:00 | ||||
419122 | 419122 | 2022-09-18 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-19 04:21:49 | Gansu, China | |||
423137 | 423137 | 2021-10-10 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-11 04:21:31 | Gansu, China | |||
431144 | 431144 | 2022-11-03 | China | Gansu | 1373 | 2 | 0 | 35.7518 | 104.2861 | 2022-11-04 04:22:11 | Gansu, China | |||
443141 | 443141 | 2021-10-20 | China | Gansu | 209 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-21 04:21:18 | Gansu, China | |||
447157 | 447157 | 2021-11-17 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-18 04:21:33 | Gansu, China | |||
451174 | 451174 | 2022-12-21 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-22 04:20:56 | Gansu, China | |||
459166 | 459166 | 2022-02-02 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-03 04:21:21 | Gansu, China | |||
463183 | 463183 | 2022-05-02 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-05-03 04:21:00 | Gansu, China | |||
467198 | 467198 | 2021-10-07 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-08 04:21:25 | Gansu, China | |||
475229 | 475229 | 2022-06-26 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-27 04:21:00 | Gansu, China | |||
479377 | 479377 | 2022-11-08 | China | Gansu | 1401 | 2 | 0 | 35.7518 | 104.2861 | 2022-11-09 04:21:22 | Gansu, China | |||
487407 | 487407 | 2022-11-25 | China | Gansu | 1534 | 2 | 0 | 35.7518 | 104.2861 | 2022-11-26 04:21:11 | Gansu, China | |||
491422 | 491422 | 2021-10-14 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-15 04:21:26 | Gansu, China | |||
495438 | 495438 | 2021-11-06 | China | Gansu | 338 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-07 04:21:53 | Gansu, China | |||
499455 | 499455 | 2022-04-02 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-04-03 04:20:48 | Gansu, China | |||
503471 | 503471 | 2022-12-17 | China | Gansu | 1561 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-18 04:21:03 | Gansu, China | |||
507486 | 507486 | 2021-08-14 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-08-15 04:21:41 | Gansu, China | |||
511500 | 511500 | 2021-08-19 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-08-20 04:21:33 | Gansu, China | |||
515515 | 515515 | 2022-10-15 | China | Gansu | 1351 | 2 | 0 | 35.7518 | 104.2861 | 2022-10-16 04:22:39 | Gansu, China | |||
534522 | 534522 | 2021-10-27 | China | Gansu | 263 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-28 04:22:08 | Gansu, China | |||
538539 | 538539 | 2022-10-26 | China | Gansu | 1351 | 2 | 0 | 35.7518 | 104.2861 | 2022-10-27 04:22:01 | Gansu, China | |||
542555 | 542555 | 2022-12-15 | China | Gansu | 1561 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-16 04:21:01 | Gansu, China | |||
550560 | 550560 | 2021-12-08 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-12-09 04:22:49 | Gansu, China | |||
554576 | 554576 | 2022-01-16 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-01-17 04:21:08 | Gansu, China | |||
558593 | 558593 | 2022-06-16 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-17 04:20:56 | Gansu, China | |||
566890 | 566890 | 2021-10-29 | China | Gansu | 286 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-30 04:22:03 | Gansu, China | |||
574619 | 574619 | 2022-02-25 | China | Gansu | 368 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-26 04:21:12 | Gansu, China | |||
589430 | 589430 | 2021-08-08 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-08-09 04:21:24 | Gansu, China | |||
593445 | 593445 | 2022-07-01 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-02 04:21:16 | Gansu, China | |||
597460 | 597460 | 2021-10-19 | China | Gansu | 204 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-20 04:21:00 | Gansu, China | |||
601476 | 601476 | 2021-09-23 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-09-24 04:21:44 | Gansu, China | |||
617649 | 617649 | 2022-11-05 | China | Gansu | 1379 | 2 | 0 | 35.7518 | 104.2861 | 2022-11-06 04:21:24 | Gansu, China | |||
621665 | 621665 | 2022-05-22 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-05-26 04:20:50 | Gansu, China | |||
629695 | 629695 | 2022-07-12 | China | Gansu | 701 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-13 04:20:58 | Gansu, China | |||
633710 | 633710 | 2021-10-13 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-14 04:21:29 | Gansu, China | |||
641740 | 641740 | 2021-09-07 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-09-08 04:21:31 | Gansu, China | |||
649768 | 649768 | 2021-08-09 | China | Gansu | 199 | 2 | 0 | 35.7518 | 104.2861 | 2021-08-10 04:21:27 | Gansu, China | |||
653782 | 653782 | 2021-10-22 | China | Gansu | 235 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-23 04:21:32 | Gansu, China | |||
658101 | 658101 | 2022-05-13 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-05-14 04:20:48 | Gansu, China | |||
670086 | 670086 | 2022-07-21 | China | Gansu | 1060 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-22 04:21:15 | Gansu, China | |||
674102 | 674102 | 2022-07-30 | China | Gansu | 1298 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-31 04:21:02 | Gansu, China | |||
682127 | 682127 | 2021-10-24 | China | Gansu | 245 | 2 | 0 | 35.7518 | 104.2861 | 2021-10-25 04:22:31 | Gansu, China | |||
686143 | 686143 | 2021-11-13 | China | Gansu | 344 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-14 04:21:31 | Gansu, China | |||
690160 | 690160 | 2022-12-23 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-24 04:21:02 | Gansu, China | |||
694176 | 694176 | 2022-03-17 | China | Gansu | 594 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-18 04:20:55 | Gansu, 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]);