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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 2
- China 924
- Mainland China 51
province_or_state 1
- Gansu · 975 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016510 | 2016510 | 2022-09-20 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-21 04:23:22 | Gansu, China | |||
3570383 | 3570383 | 2022-09-19 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-20 04:22:48 | Gansu, China | |||
419122 | 419122 | 2022-09-18 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-19 04:21:49 | Gansu, China | |||
3373146 | 3373146 | 2022-09-17 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-18 04:22:50 | Gansu, China | |||
2355254 | 2355254 | 2022-09-16 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-17 04:20:19 | Gansu, China | |||
3986411 | 3986411 | 2022-09-15 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-16 04:21:19 | Gansu, China | |||
1888928 | 1888928 | 2022-09-14 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-15 04:21:02 | Gansu, China | |||
371983 | 371983 | 2022-09-13 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-14 04:20:44 | Gansu, China | |||
2394588 | 2394588 | 2022-09-12 | China | Gansu | 1350 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-13 04:20:57 | Gansu, China | |||
3765666 | 3765666 | 2022-09-11 | China | Gansu | 1348 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-12 04:20:58 | Gansu, China | |||
3824241 | 3824241 | 2022-09-10 | China | Gansu | 1348 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-11 04:20:50 | Gansu, China | |||
962698 | 962698 | 2022-09-09 | China | Gansu | 1348 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-10 04:21:10 | Gansu, China | |||
253100 | 253100 | 2022-09-08 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-09 04:21:11 | Gansu, China | |||
3744898 | 3744898 | 2022-09-07 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-08 04:21:02 | Gansu, China | |||
114538 | 114538 | 2022-09-06 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-07 04:20:59 | Gansu, China | |||
2633510 | 2633510 | 2022-09-05 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-06 04:21:02 | Gansu, China | |||
2987074 | 2987074 | 2022-09-04 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-05 04:21:01 | Gansu, China | |||
2712759 | 2712759 | 2022-09-03 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-04 04:21:22 | Gansu, China | |||
1393464 | 1393464 | 2022-09-02 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-03 04:21:04 | Gansu, China | |||
3547293 | 3547293 | 2022-09-01 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-02 04:21:07 | Gansu, China | |||
2343213 | 2343213 | 2022-08-31 | China | Gansu | 1347 | 2 | 0 | 35.7518 | 104.2861 | 2022-09-01 04:21:03 | Gansu, China | |||
3773693 | 3773693 | 2022-08-30 | China | Gansu | 1346 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-31 04:20:57 | Gansu, China | |||
1680289 | 1680289 | 2022-08-29 | China | Gansu | 1345 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-30 04:21:03 | Gansu, China | |||
1876773 | 1876773 | 2022-08-28 | China | Gansu | 1345 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-29 04:21:06 | Gansu, China | |||
2095900 | 2095900 | 2022-08-27 | China | Gansu | 1343 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-28 04:21:02 | Gansu, China | |||
1531715 | 1531715 | 2022-08-26 | China | Gansu | 1343 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-27 04:20:57 | Gansu, China | |||
2828602 | 2828602 | 2022-08-25 | China | Gansu | 1342 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-26 04:21:02 | Gansu, China | |||
2323135 | 2323135 | 2022-08-24 | China | Gansu | 1342 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-25 04:21:13 | Gansu, China | |||
1250544 | 1250544 | 2022-08-23 | China | Gansu | 1342 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-24 04:20:46 | Gansu, China | |||
2852648 | 2852648 | 2022-08-22 | China | Gansu | 1339 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-23 04:20:56 | Gansu, China | |||
2402620 | 2402620 | 2022-08-21 | China | Gansu | 1339 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-22 04:20:38 | Gansu, China | |||
3797698 | 3797698 | 2022-08-20 | China | Gansu | 1336 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-21 04:20:44 | Gansu, China | |||
2363284 | 2363284 | 2022-08-19 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-20 04:21:01 | Gansu, China | |||
1160955 | 1160955 | 2022-08-18 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-19 04:20:54 | Gansu, China | |||
3950279 | 3950279 | 2022-08-17 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-18 04:21:11 | Gansu, China | |||
990781 | 990781 | 2022-08-16 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-17 04:20:59 | Gansu, China | |||
2493820 | 2493820 | 2022-08-15 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-16 04:20:58 | Gansu, China | |||
3647370 | 3647370 | 2022-08-14 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-15 04:20:59 | Gansu, China | |||
1968376 | 1968376 | 2022-08-13 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-14 04:20:55 | Gansu, China | |||
2888185 | 2888185 | 2022-08-12 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-13 04:20:52 | Gansu, China | |||
3907790 | 3907790 | 2022-08-11 | China | Gansu | 1335 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-12 04:20:54 | Gansu, China | |||
1346107 | 1346107 | 2022-08-10 | China | Gansu | 1334 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-11 04:20:49 | Gansu, China | |||
1085862 | 1085862 | 2022-08-09 | China | Gansu | 1333 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-10 04:20:57 | Gansu, China | |||
3543277 | 3543277 | 2022-08-08 | China | Gansu | 1333 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-09 04:20:34 | Gansu, China | |||
1069680 | 1069680 | 2022-08-07 | China | Gansu | 1333 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-08 04:21:08 | Gansu, China | |||
1940268 | 1940268 | 2022-08-06 | China | Gansu | 1333 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-07 04:20:54 | Gansu, China | |||
880067 | 880067 | 2022-08-05 | China | Gansu | 1333 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-06 04:20:56 | Gansu, China | |||
2008478 | 2008478 | 2022-08-04 | China | Gansu | 1333 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-05 04:20:52 | Gansu, China | |||
1097905 | 1097905 | 2022-08-03 | China | Gansu | 1333 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-04 04:20:58 | Gansu, China | |||
1404830 | 1404830 | 2022-08-02 | China | Gansu | 1333 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-03 04:20:59 | Gansu, China | |||
3616868 | 3616868 | 2022-08-01 | China | Gansu | 1323 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-02 04:20:53 | Gansu, China | |||
3871348 | 3871348 | 2022-07-31 | China | Gansu | 1313 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-01 04:21:03 | Gansu, China | |||
674102 | 674102 | 2022-07-30 | China | Gansu | 1298 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-31 04:21:02 | Gansu, China | |||
1783301 | 1783301 | 2022-07-29 | China | Gansu | 1267 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-30 04:20:42 | Gansu, China | |||
1065664 | 1065664 | 2022-07-28 | China | Gansu | 1248 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-29 04:20:45 | Gansu, China | |||
2335183 | 2335183 | 2022-07-27 | China | Gansu | 1227 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-28 04:20:56 | Gansu, China | |||
1487373 | 1487373 | 2022-07-26 | China | Gansu | 1204 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-27 04:21:04 | Gansu, China | |||
2593819 | 2593819 | 2022-07-25 | China | Gansu | 1189 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-26 04:20:58 | Gansu, China | |||
895934 | 895934 | 2022-07-24 | China | Gansu | 1152 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-25 04:20:51 | Gansu, China | |||
90928 | 90928 | 2022-07-23 | China | Gansu | 1128 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-24 04:20:47 | Gansu, China | |||
899950 | 899950 | 2022-07-22 | China | Gansu | 1102 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-23 04:20:53 | Gansu, China | |||
670086 | 670086 | 2022-07-21 | China | Gansu | 1060 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-22 04:21:15 | Gansu, China | |||
1608049 | 1608049 | 2022-07-20 | China | Gansu | 1008 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-21 04:21:10 | Gansu, China | |||
958682 | 958682 | 2022-07-19 | China | Gansu | 959 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-20 04:20:59 | Gansu, China | |||
3210069 | 3210069 | 2022-07-18 | China | Gansu | 912 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-19 04:20:58 | Gansu, China | |||
3405244 | 3405244 | 2022-07-17 | China | Gansu | 880 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-18 04:20:59 | Gansu, China | |||
2151444 | 2151444 | 2022-07-16 | China | Gansu | 851 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-17 04:21:15 | Gansu, China | |||
2418677 | 2418677 | 2022-07-15 | China | Gansu | 798 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-16 04:21:05 | Gansu, China | |||
3428752 | 3428752 | 2022-07-14 | China | Gansu | 767 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-15 04:20:53 | Gansu, China | |||
3109272 | 3109272 | 2022-07-13 | China | Gansu | 737 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-14 04:20:57 | Gansu, China | |||
629695 | 629695 | 2022-07-12 | China | Gansu | 701 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-13 04:20:58 | Gansu, China | |||
1211339 | 1211339 | 2022-07-11 | China | Gansu | 693 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-12 04:20:51 | Gansu, China | |||
2788821 | 2788821 | 2022-07-10 | China | Gansu | 693 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-11 04:20:46 | Gansu, China | |||
141774 | 141774 | 2022-07-09 | China | Gansu | 691 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-10 04:20:54 | Gansu, China | |||
1416874 | 1416874 | 2022-07-08 | China | Gansu | 686 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-09 04:20:59 | Gansu, China | |||
2740799 | 2740799 | 2022-07-07 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-08 04:20:56 | Gansu, China | |||
1199594 | 1199594 | 2022-07-06 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-07 04:20:55 | Gansu, China | |||
3966337 | 3966337 | 2022-07-05 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-06 04:20:58 | Gansu, China | |||
3077848 | 3077848 | 2022-07-04 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-05 04:20:45 | Gansu, China | |||
1767130 | 1767130 | 2022-07-03 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-04 04:20:54 | Gansu, China | |||
3365116 | 3365116 | 2022-07-02 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-03 04:20:59 | Gansu, China | |||
593445 | 593445 | 2022-07-01 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-02 04:21:16 | Gansu, China | |||
3939846 | 3939846 | 2022-06-30 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-01 04:21:10 | Gansu, China | |||
2489804 | 2489804 | 2022-06-29 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-30 04:21:01 | Gansu, China | |||
2239186 | 2239186 | 2022-06-28 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-29 04:20:59 | Gansu, China | |||
2147428 | 2147428 | 2022-06-27 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-28 04:20:58 | Gansu, China | |||
475229 | 475229 | 2022-06-26 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-27 04:21:00 | Gansu, China | |||
938604 | 938604 | 2022-06-25 | China | Gansu | 682 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-26 04:21:02 | Gansu, China | |||
3346424 | 3346424 | 2022-06-24 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-25 04:20:57 | Gansu, China | |||
1648165 | 1648165 | 2022-06-23 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-24 04:20:58 | Gansu, China | |||
2187400 | 2187400 | 2022-06-22 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-23 04:20:55 | Gansu, China | |||
165831 | 165831 | 2022-06-21 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-22 04:20:54 | Gansu, China | |||
1763114 | 1763114 | 2022-06-20 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-21 04:20:56 | Gansu, China | |||
3269300 | 3269300 | 2022-06-19 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-20 04:21:01 | Gansu, China | |||
3397212 | 3397212 | 2022-06-18 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-19 04:20:51 | Gansu, China | |||
2311089 | 2311089 | 2022-06-17 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-18 04:21:10 | Gansu, China | |||
558593 | 558593 | 2022-06-16 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-17 04:20:56 | Gansu, China | |||
3982395 | 3982395 | 2022-06-15 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-16 04:20:55 | Gansu, China | |||
946636 | 946636 | 2022-06-14 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-15 04:20:54 | Gansu, China | |||
2979044 | 2979044 | 2022-06-13 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-06-14 04:20:52 | 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]);