johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where confirmed = 349 and province_or_state = "Hebei" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3923134 | 3923134 | 2020-08-09 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-10 04:34:55 | Hebei, China | ||
371302 | 371302 | 2020-08-08 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-09 04:34:54 | Hebei, China | ||
458486 | 458486 | 2020-08-07 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-08 04:34:53 | Hebei, China | ||
3612171 | 3612171 | 2020-08-06 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-07 04:35:11 | Hebei, China | ||
3793001 | 3793001 | 2020-08-05 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-06 04:35:02 | Hebei, China | ||
98237 | 98237 | 2020-08-04 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-05 04:34:43 | Hebei, China | ||
2740120 | 2740120 | 2020-08-03 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-04 04:41:59 | Hebei, China | ||
2807872 | 2807872 | 2020-08-02 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-03 04:34:35 | Hebei, China | ||
753440 | 753440 | 2020-08-01 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-02 04:34:47 | Hebei, China | ||
3264605 | 3264605 | 2020-07-31 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-08-01 04:36:27 | Hebei, China | ||
1928312 | 1928312 | 2020-07-30 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-07-31 04:35:18 | Hebei, China | ||
2958480 | 2958480 | 2020-07-29 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-07-30 04:35:05 | Hebei, China | ||
3185096 | 3185096 | 2020-07-28 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-07-29 04:35:11 | Hebei, China | ||
177148 | 177148 | 2020-07-27 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-07-28 04:58:43 | Hebei, China | ||
442461 | 442461 | 2020-07-26 | China | Hebei | 349 | 6 | 343 | 0 | 37.8957 | 114.9042 | 2020-07-27 04:35:02 | Hebei, China | ||
1502705 | 1502705 | 2020-07-25 | China | Hebei | 349 | 6 | 342 | 1 | 37.8957 | 114.9042 | 2020-07-26 04:35:00 | Hebei, China | ||
2563675 | 2563675 | 2020-07-24 | China | Hebei | 349 | 6 | 342 | 1 | 37.8957 | 114.9042 | 2020-07-25 04:47:39 | Hebei, China | ||
61895 | 61895 | 2020-07-23 | China | Hebei | 349 | 6 | 342 | 1 | 37.8957 | 114.9042 | 2020-07-24 05:30:40 | Hebei, China | ||
844695 | 844695 | 2020-07-22 | China | Hebei | 349 | 6 | 342 | 1 | 37.8957 | 114.9042 | 2020-07-23 05:15:04 | Hebei, China | ||
1707434 | 1707434 | 2020-07-21 | China | Hebei | 349 | 6 | 340 | 3 | 37.8957 | 114.9042 | 2020-07-22 04:34:42 | Hebei, China | ||
326925 | 326925 | 2020-07-20 | China | Hebei | 349 | 6 | 340 | 3 | 37.8957 | 114.9042 | 2020-07-21 04:38:46 | Hebei, China | ||
121830 | 121830 | 2020-07-19 | China | Hebei | 349 | 6 | 340 | 3 | 37.8957 | 114.9042 | 2020-07-20 05:34:40 | Hebei, China | ||
3205219 | 3205219 | 2020-07-18 | China | Hebei | 349 | 6 | 340 | 3 | 37.8957 | 114.9042 | 2020-07-19 04:34:58 | Hebei, China | ||
2708521 | 2708521 | 2020-07-17 | China | Hebei | 349 | 6 | 340 | 3 | 37.8957 | 114.9042 | 2020-07-18 04:34:45 | Hebei, China | ||
367335 | 367335 | 2020-07-16 | China | Hebei | 349 | 6 | 340 | 3 | 37.8957 | 114.9042 | 2020-07-17 04:34:50 | Hebei, China | ||
2748003 | 2748003 | 2020-07-15 | China | Hebei | 349 | 6 | 340 | 3 | 37.8957 | 114.9042 | 2020-07-16 04:44:59 | Hebei, China | ||
2158647 | 2158647 | 2020-07-14 | China | Hebei | 349 | 6 | 340 | 3 | 37.8957 | 114.9042 | 2020-07-15 04:34:39 | Hebei, China | ||
3491288 | 3491288 | 2020-07-13 | China | Hebei | 349 | 6 | 339 | 4 | 37.8957 | 114.9042 | 2020-07-14 04:34:46 | Hebei, China | ||
3737551 | 3737551 | 2020-07-12 | China | Hebei | 349 | 6 | 339 | 4 | 37.8957 | 114.9042 | 2020-07-13 04:43:04 | Hebei, China | ||
3435946 | 3435946 | 2020-07-11 | China | Hebei | 349 | 6 | 339 | 4 | 37.8957 | 114.9042 | 2020-07-12 04:34:30 | Hebei, China | ||
3237444 | 3237444 | 2020-07-10 | China | Hebei | 349 | 6 | 339 | 4 | 37.8957 | 114.9042 | 2020-07-11 04:34:26 | Hebei, China | ||
1005429 | 1005429 | 2020-07-09 | China | Hebei | 349 | 6 | 339 | 4 | 37.8957 | 114.9042 | 2020-07-10 04:34:24 | Hebei, China | ||
2222645 | 2222645 | 2020-07-08 | China | Hebei | 349 | 6 | 339 | 4 | 37.8957 | 114.9042 | 2020-07-09 04:34:23 | Hebei, China | ||
887254 | 887254 | 2020-07-07 | China | Hebei | 349 | 6 | 337 | 6 | 37.8957 | 114.9042 | 2020-07-08 05:33:48 | Hebei, China | ||
2684814 | 2684814 | 2020-07-06 | China | Hebei | 349 | 6 | 337 | 6 | 37.8957 | 114.9042 | 2020-07-07 04:34:00 | Hebei, China | ||
415279 | 415279 | 2020-07-05 | China | Hebei | 349 | 6 | 337 | 6 | 37.8957 | 114.9042 | 2020-07-06 04:33:57 | Hebei, China | ||
529841 | 529841 | 2020-07-04 | China | Hebei | 349 | 6 | 337 | 6 | 37.8957 | 114.9042 | 2020-07-05 04:33:46 | Hebei, China | ||
2234502 | 2234502 | 2020-07-03 | China | Hebei | 349 | 6 | 336 | 7 | 37.8957 | 114.9042 | 2020-07-04 04:33:51 | Hebei, China | ||
3045296 | 3045296 | 2020-07-02 | China | Hebei | 349 | 6 | 334 | 9 | 37.8957 | 114.9042 | 2020-07-03 04:33:54 | Hebei, China | ||
302987 | 302987 | 2020-07-01 | China | Hebei | 349 | 6 | 334 | 9 | 37.8957 | 114.9042 | 2020-07-02 04:33:46 | Hebei, China | ||
2974365 | 2974365 | 2020-06-30 | China | Hebei | 349 | 6 | 334 | 9 | 37.8957 | 114.9042 | 2020-07-01 04:33:52 | Hebei, China | ||
2632842 | 2632842 | 2020-06-29 | China | Hebei | 349 | 6 | 334 | 9 | 37.8957 | 114.9042 | 2020-06-30 04:33:48 | Hebei, China | ||
2306405 | 2306405 | 2020-06-28 | China | Hebei | 349 | 6 | 333 | 10 | 37.8957 | 114.9042 | 2020-06-29 04:33:44 | Hebei, China | ||
2039740 | 2039740 | 2020-06-27 | China | Hebei | 349 | 6 | 331 | 12 | 37.8957 | 114.9042 | 2020-06-28 04:34:04 | Hebei, China | ||
1136021 | 1136021 | 2020-06-26 | China | Hebei | 349 | 6 | 326 | 17 | 37.8957 | 114.9042 | 2020-06-27 04:33:35 | Hebei, China | ||
2625008 | 2625008 | 2020-06-25 | China | Hebei | 349 | 6 | 324 | 19 | 37.8957 | 114.9042 | 2020-06-26 04:33:43 | Hebei, China | ||
2700648 | 2700648 | 2020-06-24 | China | Hebei | 349 | 6 | 323 | 20 | 37.8957 | 114.9042 | 2020-06-25 05:26:54 | Hebei, 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]);