johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Henan" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, latitude, longitude, day (date), last_update (date)
country_or_region 2
- China 1,024
- Mainland China 49
province_or_state 1
- Henan · 1,073 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123 | 123 | 2021-12-02 | China | Henan | 1637 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-12-03 04:23:05 | Henan, China | |||
4139 | 4139 | 2021-10-28 | China | Henan | 1558 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-10-29 04:22:03 | Henan, China | |||
8143 | 8143 | 2020-10-25 | China | Henan | 1283 | 22 | 1257 | 4 | 33.882 | 113.614 | 2020-10-26 04:25:02 | Henan, China | ||
12150 | 12150 | 2021-01-26 | China | Henan | 1303 | 22 | 1278 | 3 | 33.882 | 113.614 | 2021-01-27 05:23:41 | Henan, China | ||
16164 | 16164 | 2021-09-18 | China | Henan | 1539 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-09-19 04:21:34 | Henan, China | |||
20179 | 20179 | 2021-05-28 | China | Henan | 1314 | 22 | 1290 | 2 | 33.882 | 113.614 | 2021-05-29 04:20:41 | Henan, China | ||
24194 | 24194 | 2022-03-20 | China | Henan | 2719 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-03-21 04:20:50 | Henan, China | |||
28209 | 28209 | 2021-11-11 | China | Henan | 1628 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-11-12 04:22:01 | Henan, China | |||
32225 | 32225 | 2021-08-25 | China | Henan | 1525 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-08-26 04:21:28 | Henan, China | |||
36239 | 36239 | 2021-04-12 | China | Henan | 1311 | 22 | 1284 | 5 | 33.882 | 113.614 | 2021-04-13 04:20:37 | Henan, China | ||
40136 | 40136 | 2020-03-05 | Mainland China | Henan | 1272 | 22 | 1239 | 33.882 | 113.614 | 2020-03-05T01:48:26 | ||||
43105 | 43105 | 2020-04-13 | China | Henan | 1276 | 22 | 1253 | 1 | 33.882 | 113.61399999999999 | 2020-04-12 02:25:30 | Henan, China | ||
43501 | 43501 | 2021-11-02 | China | Henan | 1560 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-11-03 06:22:09 | Henan, China | |||
50204 | 50204 | 2020-04-17 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.61399999999999 | 2020-04-14 00:43:57 | Henan, China | ||
50600 | 50600 | 2021-05-29 | China | Henan | 1314 | 22 | 1290 | 2 | 33.882 | 113.614 | 2021-05-30 04:20:55 | Henan, China | ||
54614 | 54614 | 2021-03-07 | China | Henan | 1307 | 22 | 1281 | 4 | 33.882 | 113.614 | 2021-03-08 05:24:48 | Henan, China | ||
61897 | 61897 | 2020-07-23 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.61399999999999 | 2020-07-24 05:30:40 | Henan, China | ||
62476 | 62476 | 2020-03-07 | Mainland China | Henan | 1272 | 22 | 1244 | 33.882 | 113.614 | 2020-03-07T11:23:10 | ||||
62855 | 62855 | 2022-11-12 | China | Henan | 4621 | 22 | 0 | 33.882 | 113.614 | 2022-11-13 04:21:14 | Henan, China | |||
66870 | 66870 | 2021-09-01 | China | Henan | 1528 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-09-02 04:21:15 | Henan, China | |||
70884 | 70884 | 2022-02-07 | China | Henan | 2662 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-02-08 04:21:15 | Henan, China | |||
74900 | 74900 | 2020-12-03 | China | Henan | 1292 | 22 | 1265 | 5 | 33.882 | 113.614 | 2020-12-04 05:27:27 | Henan, China | ||
78899 | 78899 | 2020-10-14 | China | Henan | 1281 | 22 | 1256 | 3 | 33.882 | 113.614 | 2020-10-15 04:24:28 | Henan, China | ||
82904 | 82904 | 2021-05-25 | China | Henan | 1314 | 22 | 1290 | 2 | 33.882 | 113.614 | 2021-05-26 04:20:35 | Henan, China | ||
86918 | 86918 | 2021-11-09 | China | Henan | 1603 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-11-10 04:21:38 | Henan, China | |||
90935 | 90935 | 2022-07-23 | China | Henan | 3205 | 22 | 0 | 33.882 | 113.614 | 2022-07-24 04:20:47 | Henan, China | |||
98239 | 98239 | 2020-08-04 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.61399999999999 | 2020-08-05 04:34:43 | Henan, China | ||
98806 | 98806 | 2020-03-04 | Mainland China | Henan | 1272 | 22 | 1234 | 33.882 | 113.614 | 2020-03-04T00:33:05 | ||||
99119 | 99119 | 2022-01-14 | China | Henan | 2373 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-01-15 04:21:07 | Henan, China | |||
103135 | 103135 | 2021-08-15 | China | Henan | 1518 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-08-16 04:21:31 | Henan, China | |||
107029 | 107029 | 2020-02-15 | Mainland China | Henan | 1212 | 13 | 391 | 33.882 | 113.614 | 2020-02-15T12:13:08 | ||||
107260 | 107260 | 2021-06-19 | China | Henan | 1316 | 22 | 1291 | 3 | 33.882 | 113.614 | 2021-06-20 04:21:48 | Henan, China | ||
114144 | 114144 | 2020-05-08 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-05-09 02:32:35 | Henan, China | ||
114545 | 114545 | 2022-09-06 | China | Henan | 3305 | 22 | 0 | 33.882 | 113.614 | 2022-09-07 04:20:59 | Henan, China | |||
122515 | 122515 | 2020-11-18 | China | Henan | 1288 | 22 | 1261 | 5 | 33.882 | 113.614 | 2020-11-19 05:25:23 | Henan, China | ||
126526 | 126526 | 2022-01-09 | China | Henan | 1941 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-01-10 04:22:07 | Henan, China | |||
130543 | 130543 | 2022-10-04 | China | Henan | 3333 | 22 | 0 | 33.882 | 113.614 | 2022-10-05 04:23:06 | Henan, China | |||
137368 | 137368 | 2020-04-29 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-04-30 02:32:27 | Henan, China | ||
137764 | 137764 | 2021-12-04 | China | Henan | 1637 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-12-05 04:22:25 | Henan, China | |||
141781 | 141781 | 2022-07-09 | China | Henan | 3185 | 22 | 0 | 33.882 | 113.614 | 2022-07-10 04:20:54 | Henan, China | |||
145784 | 145784 | 2020-08-15 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-08-16 04:27:42 | Henan, China | ||
149777 | 149777 | 2021-11-29 | China | Henan | 1637 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-11-30 04:22:53 | Henan, China | |||
153793 | 153793 | 2021-01-08 | China | Henan | 1301 | 22 | 1273 | 6 | 33.882 | 113.614 | 2021-01-09 05:22:18 | Henan, China | ||
157806 | 157806 | 2022-03-29 | China | Henan | 2814 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-03-30 04:20:45 | Henan, China | |||
161821 | 161821 | 2021-11-19 | China | Henan | 1634 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-11-20 04:22:17 | Henan, China | |||
165838 | 165838 | 2022-06-21 | China | Henan | 3183 | 22 | 0 | 33.882 | 113.614 | 2022-06-22 04:20:54 | Henan, China | |||
169853 | 169853 | 2021-04-16 | China | Henan | 1311 | 22 | 1285 | 4 | 33.882 | 113.614 | 2021-04-17 04:20:40 | Henan, China | ||
177150 | 177150 | 2020-07-27 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.61399999999999 | 2020-07-28 04:58:43 | Henan, China | ||
177835 | 177835 | 2021-09-02 | China | Henan | 1530 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-09-03 04:21:20 | Henan, China | |||
181849 | 181849 | 2021-02-21 | China | Henan | 1304 | 22 | 1281 | 1 | 33.882 | 113.614 | 2021-02-22 05:24:21 | Henan, China | ||
185864 | 185864 | 2022-02-13 | China | Henan | 2663 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-02-14 04:20:51 | Henan, China | |||
189879 | 189879 | 2021-01-11 | China | Henan | 1302 | 22 | 1273 | 7 | 33.882 | 113.614 | 2021-01-12 05:22:15 | Henan, China | ||
193879 | 193879 | 2020-08-31 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-09-01 04:28:31 | Henan, China | ||
197772 | 197772 | 2020-01-24 | Mainland China | Henan | 9 | 0 | 0 | 33.882 | 113.614 | 1/24/20 17:00 | ||||
197842 | 197842 | 2020-01-29 | Mainland China | Henan | 206 | 2 | 1 | 33.882 | 113.614 | 1/29/20 19:30 | ||||
198052 | 198052 | 2022-10-19 | China | Henan | 3453 | 22 | 0 | 33.882 | 113.614 | 2022-10-20 04:22:59 | Henan, China | |||
202067 | 202067 | 2020-12-25 | China | Henan | 1298 | 22 | 1270 | 6 | 33.882 | 113.614 | 2020-12-26 05:22:28 | Henan, China | ||
206066 | 206066 | 2020-08-19 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-08-20 04:27:43 | Henan, China | ||
210051 | 210051 | 2020-10-29 | China | Henan | 1284 | 22 | 1258 | 4 | 33.882 | 113.614 | 2020-10-30 04:24:49 | Henan, China | ||
217125 | 217125 | 2020-06-08 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-06-09 03:33:03 | Henan, China | ||
217773 | 217773 | 2022-12-26 | China | Henan | 9089 | 23 | 0 | 33.882 | 113.614 | 2022-12-27 04:21:07 | Henan, China | |||
221789 | 221789 | 2022-05-09 | China | Henan | 3052 | 22 | 0 | 33.882 | 113.614 | 2022-05-10 04:20:50 | Henan, China | |||
228621 | 228621 | 2020-04-30 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.61399999999999 | 2020-05-01 02:32:28 | Henan, China | ||
229020 | 229020 | 2022-05-31 | China | Henan | 3182 | 22 | 0 | 33.882 | 113.614 | 2022-06-01 04:20:55 | Henan, China | |||
233036 | 233036 | 2022-02-11 | China | Henan | 2662 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-02-12 04:21:06 | Henan, China | |||
237051 | 237051 | 2021-01-18 | China | Henan | 1303 | 22 | 1275 | 6 | 33.882 | 113.614 | 2021-01-19 05:22:15 | Henan, China | ||
241064 | 241064 | 2021-04-02 | China | Henan | 1311 | 22 | 1283 | 6 | 33.882 | 113.614 | 2021-04-03 04:20:44 | Henan, China | ||
245078 | 245078 | 2021-08-17 | China | Henan | 1518 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-08-18 04:21:35 | Henan, China | |||
249092 | 249092 | 2021-09-04 | China | Henan | 1531 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-09-05 04:21:33 | Henan, China | |||
253107 | 253107 | 2022-09-08 | China | Henan | 3307 | 22 | 0 | 33.882 | 113.614 | 2022-09-09 04:21:11 | Henan, China | |||
257123 | 257123 | 2022-12-10 | China | Henan | 8538 | 23 | 0 | 33.882 | 113.614 | 2022-12-11 04:20:50 | Henan, China | |||
261021 | 261021 | 2020-03-03 | Mainland China | Henan | 1272 | 22 | 1231 | 33.882 | 113.614 | 2020-03-03T09:43:02 | ||||
261326 | 261326 | 2022-03-15 | China | Henan | 2711 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-03-16 04:20:50 | Henan, China | |||
268301 | 268301 | 2020-05-21 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-05-22 02:36:51 | Henan, China | ||
271582 | 271582 | 2020-04-28 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.61399999999999 | 2020-04-29 02:32:29 | Henan, China | ||
271966 | 271966 | 2020-11-10 | China | Henan | 1286 | 22 | 1258 | 6 | 33.882 | 113.614 | 2020-11-11 05:25:30 | Henan, China | ||
275976 | 275976 | 2021-11-03 | China | Henan | 1562 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-11-04 04:22:20 | Henan, China | |||
279992 | 279992 | 2021-02-24 | China | Henan | 1304 | 22 | 1281 | 1 | 33.882 | 113.614 | 2021-02-25 05:24:57 | Henan, China | ||
287117 | 287117 | 2020-06-15 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.614 | 2020-06-16 04:33:09 | Henan, China | ||
287789 | 287789 | 2021-10-31 | China | Henan | 1559 | 22 | 0 | 33.882 | 113.61399999999999 | 2021-11-01 04:22:01 | Henan, China | |||
291806 | 291806 | 2022-11-15 | China | Henan | 5195 | 22 | 0 | 33.882 | 113.614 | 2022-11-16 04:21:09 | Henan, China | |||
295821 | 295821 | 2021-07-15 | China | Henan | 1325 | 22 | 1291 | 12 | 33.882 | 113.614 | 2021-07-16 04:21:22 | Henan, China | ||
302989 | 302989 | 2020-07-01 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.61399999999999 | 2020-07-02 04:33:46 | Henan, China | ||
303662 | 303662 | 2022-04-16 | China | Henan | 2854 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-04-17 04:20:59 | Henan, China | |||
307678 | 307678 | 2022-12-13 | China | Henan | 8692 | 23 | 0 | 33.882 | 113.614 | 2022-12-14 04:21:04 | Henan, China | |||
311694 | 311694 | 2022-11-13 | China | Henan | 4846 | 22 | 0 | 33.882 | 113.614 | 2022-11-14 04:21:09 | Henan, China | |||
315710 | 315710 | 2022-02-12 | China | Henan | 2662 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-02-13 04:21:00 | Henan, China | |||
319726 | 319726 | 2022-10-30 | China | Henan | 3517 | 22 | 0 | 33.882 | 113.614 | 2022-10-31 04:21:36 | Henan, China | |||
327700 | 327700 | 2022-12-27 | China | Henan | 9089 | 23 | 0 | 33.882 | 113.614 | 2022-12-28 04:21:04 | Henan, China | |||
331715 | 331715 | 2021-08-04 | China | Henan | 1355 | 22 | 1295 | 38 | 33.882 | 113.614 | 2021-08-05 04:21:51 | Henan, China | ||
335730 | 335730 | 2022-03-18 | China | Henan | 2715 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-03-19 04:20:47 | Henan, China | |||
339644 | 339644 | 2020-03-21 | China | Henan | 1273 | 22 | 1250 | 33.882 | 113.614 | 2020-03-14T09:53:08 | ||||
340085 | 340085 | 2021-02-03 | China | Henan | 1303 | 22 | 1280 | 1 | 33.882 | 113.614 | 2021-02-04 05:22:26 | Henan, China | ||
344087 | 344087 | 2020-09-14 | China | Henan | 1277 | 22 | 1254 | 1 | 33.882 | 113.614 | 2020-09-15 03:22:50 | Henan, China | ||
348090 | 348090 | 2022-12-14 | China | Henan | 8692 | 23 | 0 | 33.882 | 113.614 | 2022-12-15 04:20:58 | Henan, China | |||
352105 | 352105 | 2021-03-11 | China | Henan | 1309 | 22 | 1281 | 6 | 33.882 | 113.614 | 2021-03-12 05:26:50 | Henan, China | ||
356120 | 356120 | 2022-03-11 | China | Henan | 2708 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-03-12 04:20:50 | Henan, China | |||
360136 | 360136 | 2022-05-07 | China | Henan | 3013 | 22 | 0 | 33.882 | 113.614 | 2022-05-08 04:20:49 | Henan, China | |||
371304 | 371304 | 2020-08-08 | China | Henan | 1276 | 22 | 1254 | 0 | 33.882 | 113.61399999999999 | 2020-08-09 04:34:54 | Henan, China | ||
371990 | 371990 | 2022-09-13 | China | Henan | 3317 | 22 | 0 | 33.882 | 113.614 | 2022-09-14 04:20:44 | Henan, 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]);