johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
309 rows where active = 0, country_or_region = "China" and province_or_state = "Gansu" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3705927 | 3705927 | 2021-07-17 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-18 04:22:07 | Gansu, China | ||
2947158 | 2947158 | 2021-07-16 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-17 04:22:22 | Gansu, China | ||
295814 | 295814 | 2021-07-15 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-16 04:21:22 | Gansu, China | ||
3631759 | 3631759 | 2021-07-14 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-15 04:21:48 | Gansu, China | ||
578634 | 578634 | 2021-07-13 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-14 04:21:35 | Gansu, China | ||
3740883 | 3740883 | 2021-07-12 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-13 04:21:18 | Gansu, China | ||
3659396 | 3659396 | 2021-07-11 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-12 04:21:34 | Gansu, China | ||
625680 | 625680 | 2021-07-10 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-11 04:21:43 | Gansu, China | ||
829399 | 829399 | 2021-07-09 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-10 04:21:25 | Gansu, China | ||
778163 | 778163 | 2021-07-08 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-09 04:21:21 | Gansu, China | ||
1440385 | 1440385 | 2021-07-07 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-08 04:21:26 | Gansu, China | ||
2693490 | 2693490 | 2021-07-06 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-07 04:21:20 | Gansu, China | ||
1932239 | 1932239 | 2021-07-05 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-06 04:21:32 | Gansu, China | ||
1164970 | 1164970 | 2021-07-04 | China | Gansu | 195 | 2 | 193 | 0 | 35.7518 | 104.2861 | 2021-07-05 04:21:28 | Gansu, China | ||
2422692 | 2422692 | 2021-06-23 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-24 04:21:55 | Gansu, China | ||
562769 | 562769 | 2021-06-22 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-23 04:21:46 | Gansu, China | ||
3358471 | 3358471 | 2021-06-21 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-22 04:21:34 | Gansu, China | ||
2884170 | 2884170 | 2021-06-20 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-21 04:21:41 | Gansu, China | ||
107253 | 107253 | 2021-06-19 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-20 04:21:48 | Gansu, China | ||
1125396 | 1125396 | 2021-06-18 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-19 04:22:33 | Gansu, China | ||
2910974 | 2910974 | 2021-06-17 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-18 04:22:16 | Gansu, China | ||
3030092 | 3030092 | 2021-06-16 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-17 04:22:36 | Gansu, China | ||
2339198 | 2339198 | 2021-06-15 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-16 04:22:32 | Gansu, China | ||
1563894 | 1563894 | 2021-06-14 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-15 04:22:22 | Gansu, China | ||
3381177 | 3381177 | 2021-06-13 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-14 04:22:46 | Gansu, China | ||
1736311 | 1736311 | 2021-06-12 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-13 04:22:44 | Gansu, China | ||
3970352 | 3970352 | 2021-06-11 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-12 04:22:22 | Gansu, China | ||
2716774 | 2716774 | 2021-06-10 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-11 04:23:20 | Gansu, China | ||
522659 | 522659 | 2021-06-09 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-10 04:23:17 | Gansu, China | ||
3472099 | 3472099 | 2021-06-08 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-09 04:23:31 | Gansu, China | ||
3145383 | 3145383 | 2021-06-07 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-08 04:22:35 | Gansu, China | ||
825385 | 825385 | 2021-06-06 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-07 04:22:51 | Gansu, China | ||
2585790 | 2585790 | 2021-06-05 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-06 04:24:03 | Gansu, China | ||
2315104 | 2315104 | 2021-06-04 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-05 04:23:03 | Gansu, China | ||
1448389 | 1448389 | 2021-06-03 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-04 04:23:37 | Gansu, China | ||
1708113 | 1708113 | 2021-06-02 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-03 04:23:32 | Gansu, China | ||
2103931 | 2103931 | 2021-06-01 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-02 04:24:34 | Gansu, China | ||
1188547 | 1188547 | 2021-05-31 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-06-01 04:23:09 | Gansu, China | ||
3089224 | 3089224 | 2021-05-30 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-05-31 03:08:59 | Gansu, China | ||
50593 | 50593 | 2021-05-29 | China | Gansu | 194 | 2 | 192 | 0 | 35.7518 | 104.2861 | 2021-05-30 04:20:55 | Gansu, China | ||
726300 | 726300 | 2021-05-22 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-23 04:20:51 | Gansu, China | ||
1952315 | 1952315 | 2021-05-21 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-22 04:20:45 | Gansu, China | ||
1913014 | 1913014 | 2021-05-20 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-21 04:20:43 | Gansu, China | ||
2255535 | 2255535 | 2021-05-19 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-20 04:21:05 | Gansu, China | ||
2390573 | 2390573 | 2021-05-18 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-19 04:20:42 | Gansu, China | ||
3574398 | 3574398 | 2021-05-17 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-18 04:20:33 | Gansu, China | ||
2939128 | 2939128 | 2021-05-16 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-17 04:20:34 | Gansu, China | ||
1872758 | 1872758 | 2021-05-15 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-16 04:20:49 | Gansu, China | ||
1081727 | 1081727 | 2021-05-14 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-15 04:20:58 | Gansu, China | ||
3053993 | 3053993 | 2021-05-13 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-14 04:20:41 | Gansu, China | ||
2004463 | 2004463 | 2021-05-12 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-13 04:20:51 | Gansu, China | ||
3954294 | 3954294 | 2021-05-11 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-12 04:21:29 | Gansu, China | ||
2820573 | 2820573 | 2021-05-10 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-11 04:20:41 | Gansu, China | ||
1424905 | 1424905 | 2021-05-09 | China | Gansu | 193 | 2 | 191 | 0 | 35.7518 | 104.2861 | 2021-05-10 04:20:38 | Gansu, China | ||
3420721 | 3420721 | 2021-03-19 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-20 05:25:46 | Gansu, China | ||
3452659 | 3452659 | 2021-03-18 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-19 05:26:09 | Gansu, China | ||
3620883 | 3620883 | 2021-03-17 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-18 05:26:22 | Gansu, China | ||
702207 | 702207 | 2021-03-16 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-17 05:25:07 | Gansu, China | ||
2055685 | 2055685 | 2021-03-15 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-16 05:25:13 | Gansu, China | ||
1732297 | 1732297 | 2021-03-14 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-15 05:25:51 | Gansu, China | ||
1579954 | 1579954 | 2021-03-13 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-14 05:25:37 | Gansu, China | ||
1837733 | 1837733 | 2021-03-12 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-13 05:25:15 | Gansu, China | ||
352098 | 352098 | 2021-03-11 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-12 05:26:50 | Gansu, China | ||
3962322 | 3962322 | 2021-03-10 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-11 05:25:48 | Gansu, China | ||
3663410 | 3663410 | 2021-03-09 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-10 05:24:35 | Gansu, China | ||
2359269 | 2359269 | 2021-03-08 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-09 05:28:19 | Gansu, China | ||
54607 | 54607 | 2021-03-07 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-08 05:24:48 | Gansu, China | ||
3667424 | 3667424 | 2021-03-06 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-07 05:21:54 | Gansu, China | ||
1616045 | 1616045 | 2021-03-05 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-06 04:23:41 | Gansu, China | ||
2207456 | 2207456 | 2021-03-04 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-05 05:26:29 | Gansu, China | ||
1089877 | 1089877 | 2021-03-03 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-04 05:24:24 | Gansu, China | ||
3253949 | 3253949 | 2021-03-02 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-03 05:23:28 | Gansu, China | ||
998241 | 998241 | 2021-03-01 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-02 05:23:30 | Gansu, China | ||
2367299 | 2367299 | 2021-02-28 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-03-01 05:23:01 | Gansu, China | ||
3065801 | 3065801 | 2021-02-27 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-28 05:22:20 | Gansu, China | ||
2183385 | 2183385 | 2021-02-26 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-27 05:22:28 | Gansu, China | ||
1857807 | 1857807 | 2021-02-25 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-26 05:22:40 | Gansu, China | ||
279985 | 279985 | 2021-02-24 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-25 05:24:57 | Gansu, China | ||
1936253 | 1936253 | 2021-02-23 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-24 05:29:16 | Gansu, China | ||
530508 | 530508 | 2021-02-22 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-23 05:23:41 | Gansu, China | ||
181842 | 181842 | 2021-02-21 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-22 05:24:21 | Gansu, China | ||
742116 | 742116 | 2021-02-20 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-21 05:24:33 | Gansu, China | ||
471214 | 471214 | 2021-02-19 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-20 05:22:51 | Gansu, China | ||
1152924 | 1152924 | 2021-02-18 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-19 05:24:16 | Gansu, China | ||
3600844 | 3600844 | 2021-02-17 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-18 05:22:58 | Gansu, China | ||
3049979 | 3049979 | 2021-02-16 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-17 05:23:10 | Gansu, China | ||
1338078 | 1338078 | 2021-02-15 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-16 05:24:38 | Gansu, China | ||
2283229 | 2283229 | 2021-02-14 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-15 05:24:49 | Gansu, China | ||
2677629 | 2677629 | 2021-02-13 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-14 05:23:43 | Gansu, China | ||
3539262 | 3539262 | 2021-02-12 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-13 05:22:12 | Gansu, China | ||
2637525 | 2637525 | 2021-02-11 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-12 05:23:29 | Gansu, China | ||
3978380 | 3978380 | 2021-02-10 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-11 05:23:55 | Gansu, China | ||
1527700 | 1527700 | 2021-02-09 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-10 05:22:41 | Gansu, China | ||
613491 | 613491 | 2021-02-08 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-09 05:23:30 | Gansu, China | ||
1672260 | 1672260 | 2021-02-07 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-08 05:22:39 | Gansu, China | ||
974721 | 974721 | 2021-02-06 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-07 05:23:00 | Gansu, China | ||
1587979 | 1587979 | 2021-02-05 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-06 05:23:55 | Gansu, China | ||
790186 | 790186 | 2021-02-04 | China | Gansu | 187 | 2 | 185 | 0 | 35.7518 | 104.2861 | 2021-02-05 05:22:38 | Gansu, China | ||
2466608 | 2466608 | 2021-01-22 | China | Gansu | 182 | 2 | 180 | 0 | 35.7518 | 104.2861 | 2021-01-23 05:22:03 | Gansu, China | ||
435159 | 435159 | 2021-01-21 | China | Gansu | 182 | 2 | 180 | 0 | 35.7518 | 104.2861 | 2021-01-22 05:22:10 | 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]);