johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,074 rows where province_or_state = "Hubei" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, day (date), last_update (date)
country_or_region 2
- China 1,024
- Mainland China 50
province_or_state 1
- Hubei · 1,074 ✖
Link | rowid | day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1802353 | 1802353 | 2020-01-22 | Mainland China | Hubei | 444 | 17 | 28 | 30.9756 | 112.2707 | 1/22/2020 17:00 | ||||
864386 | 864386 | 2020-01-23 | Mainland China | Hubei | 444 | 17 | 28 | 30.9756 | 112.2707 | 1/23/20 17:00 | ||||
864390 | 864390 | 2020-01-23 | Mainland China | Hubei | 444 | 17 | 28 | 30.9756 | 112.2707 | 1/23/20 17:00 | ||||
197759 | 197759 | 2020-01-24 | Mainland China | Hubei | 549 | 24 | 31 | 30.9756 | 112.2707 | 1/24/20 17:00 | ||||
2938932 | 2938932 | 2020-01-25 | Mainland China | Hubei | 761 | 40 | 32 | 30.9756 | 112.2707 | 1/25/20 17:00 | ||||
415831 | 415831 | 2020-01-26 | Mainland China | Hubei | 1058 | 52 | 42 | 30.9756 | 112.2707 | 1/26/20 16:00 | ||||
3753056 | 3753056 | 2020-01-27 | Mainland China | Hubei | 1423 | 76 | 45 | 30.9756 | 112.2707 | 1/27/20 23:59 | ||||
1305753 | 1305753 | 2020-01-28 | Mainland China | Hubei | 3554 | 125 | 80 | 30.9756 | 112.2707 | 1/28/20 23:00 | ||||
197838 | 197838 | 2020-01-29 | Mainland China | Hubei | 3554 | 125 | 88 | 30.9756 | 112.2707 | 1/29/20 19:30 | ||||
1527490 | 1527490 | 2020-01-30 | Mainland China | Hubei | 4903 | 162 | 90 | 30.9756 | 112.2707 | 1/30/20 16:00 | ||||
3761175 | 3761175 | 2020-01-31 | Mainland China | Hubei | 5806 | 204 | 141 | 30.9756 | 112.2707 | 1/31/2020 23:59 | ||||
3413140 | 3413140 | 2020-02-01 | Mainland China | Hubei | 7153 | 249 | 168 | 30.9756 | 112.2707 | 2/1/2020 11:53 | ||||
2379228 | 2379228 | 2020-02-02 | Mainland China | Hubei | 11177 | 350 | 295 | 30.9756 | 112.2707 | 2020-02-02T23:43:02 | ||||
2860542 | 2860542 | 2020-02-03 | Mainland China | Hubei | 13522 | 414 | 386 | 30.9756 | 112.2707 | 2020-02-03T23:23:03 | ||||
3471878 | 3471878 | 2020-02-04 | Mainland China | Hubei | 16678 | 479 | 522 | 30.9756 | 112.2707 | 2020-02-04T23:43:01 | ||||
2091661 | 2091661 | 2020-02-05 | Mainland China | Hubei | 19665 | 549 | 633 | 30.9756 | 112.2707 | 2020-02-05T23:13:12 | ||||
566668 | 566668 | 2020-02-06 | Mainland China | Hubei | 22112 | 618 | 817 | 30.9756 | 112.2707 | 2020-02-06T23:23:02 | ||||
3221999 | 3221999 | 2020-02-07 | Mainland China | Hubei | 24953 | 699 | 1115 | 30.9756 | 112.2707 | 2020-02-07T23:43:02 | ||||
1366040 | 1366040 | 2020-02-08 | Mainland China | Hubei | 27100 | 780 | 1439 | 30.9756 | 112.2707 | 2020-02-08T23:33:06 | ||||
3362370 | 3362370 | 2020-02-09 | Mainland China | Hubei | 29631 | 871 | 1795 | 30.9756 | 112.2707 | 2020-02-09T23:33:02 | ||||
3089001 | 3089001 | 2020-02-10 | Mainland China | Hubei | 31728 | 974 | 2222 | 30.9756 | 112.2707 | 2020-02-10T23:33:02 | ||||
3197702 | 3197702 | 2020-02-11 | Mainland China | Hubei | 33366 | 1068 | 2639 | 30.9756 | 112.2707 | 2020-02-11T23:33:02 | ||||
2567243 | 2567243 | 2020-02-12 | Mainland China | Hubei | 33366 | 1068 | 2686 | 30.9756 | 112.2707 | 2020-02-12T14:13:08 | ||||
1559653 | 1559653 | 2020-02-13 | Mainland China | Hubei | 48206 | 1310 | 3459 | 30.9756 | 112.2707 | 2020-02-13T14:13:06 | ||||
1192446 | 1192446 | 2020-02-14 | Mainland China | Hubei | 54406 | 1457 | 4774 | 30.9756 | 112.2707 | 2020-02-14T23:33:02 | ||||
107027 | 107027 | 2020-02-15 | Mainland China | Hubei | 56249 | 1596 | 5623 | 30.9756 | 112.2707 | 2020-02-15T23:13:05 | ||||
1888701 | 1888701 | 2020-02-16 | Mainland China | Hubei | 58182 | 1696 | 6639 | 30.9756 | 112.2707 | 2020-02-16T23:53:01 | ||||
1243348 | 1243348 | 2020-02-17 | Mainland China | Hubei | 59989 | 1789 | 7862 | 30.9756 | 112.2707 | 2020-02-17T23:13:06 | ||||
1783074 | 1783074 | 2020-02-18 | Mainland China | Hubei | 61682 | 1921 | 9128 | 30.9756 | 112.2707 | 2020-02-18T23:13:11 | ||||
1720042 | 1720042 | 2020-02-19 | Mainland China | Hubei | 62031 | 2029 | 10337 | 30.9756 | 112.2707 | 2020-02-19T23:23:02 | ||||
2263450 | 2263450 | 2020-02-20 | Mainland China | Hubei | 62442 | 2144 | 11788 | 30.9756 | 112.2707 | 2020-02-20T23:43:02 | ||||
2135708 | 2135708 | 2020-02-21 | Mainland China | Hubei | 62662 | 2144 | 11881 | 30.9756 | 112.2707 | 2020-02-21T13:03:09 | ||||
1085626 | 1085626 | 2020-02-22 | Mainland China | Hubei | 64084 | 2346 | 15299 | 30.9756 | 112.2707 | 2020-02-22T23:33:06 | ||||
3173337 | 3173337 | 2020-02-23 | Mainland China | Hubei | 64084 | 2346 | 15343 | 30.9756 | 112.2707 | 2020-02-23T11:33:03 | ||||
3551193 | 3551193 | 2020-02-24 | Mainland China | Hubei | 64287 | 2495 | 16748 | 30.9756 | 112.2707 | 2020-02-24T11:13:09 | ||||
479129 | 479129 | 2020-02-25 | Mainland China | Hubei | 64786 | 2563 | 18971 | 30.9756 | 112.2707 | 2020-02-25T15:23:04 | ||||
2509746 | 2509746 | 2020-02-26 | Mainland China | Hubei | 65187 | 2615 | 20969 | 30.9756 | 112.2707 | 2020-02-26T14:13:10 | ||||
617390 | 617390 | 2020-02-27 | Mainland China | Hubei | 65596 | 2641 | 23383 | 30.9756 | 112.2707 | 2020-02-27T12:13:14 | ||||
2883905 | 2883905 | 2020-02-28 | Mainland China | Hubei | 65914 | 2682 | 26403 | 30.9756 | 112.2707 | 2020-02-28T00:43:01 | ||||
3205782 | 3205782 | 2020-02-29 | Mainland China | Hubei | 66337 | 2727 | 28993 | 30.9756 | 112.2707 | 2020-02-29T12:13:10 | ||||
562493 | 562493 | 2020-03-01 | Mainland China | Hubei | 66907 | 2761 | 31536 | 30.9756 | 112.2707 | 2020-03-01T10:13:19 | ||||
1152632 | 1152632 | 2020-03-02 | Mainland China | Hubei | 67103 | 2803 | 33934 | 30.9756 | 112.2707 | 2020-03-02T15:03:23 | ||||
261016 | 261016 | 2020-03-03 | Mainland China | Hubei | 67217 | 2835 | 36208 | 30.9756 | 112.2707 | 2020-03-03T11:43:02 | ||||
98801 | 98801 | 2020-03-04 | Mainland China | Hubei | 67332 | 2871 | 38557 | 30.9756 | 112.2707 | 2020-03-04T12:53:03 | ||||
40131 | 40131 | 2020-03-05 | Mainland China | Hubei | 67466 | 2902 | 40592 | 30.9756 | 112.2707 | 2020-03-05T14:53:03 | ||||
3177475 | 3177475 | 2020-03-06 | Mainland China | Hubei | 67592 | 2931 | 42033 | 30.9756 | 112.2707 | 2020-03-06T14:23:04 | ||||
62471 | 62471 | 2020-03-07 | Mainland China | Hubei | 67666 | 2959 | 43500 | 30.9756 | 112.2707 | 2020-03-07T11:13:04 | ||||
1527199 | 1527199 | 2020-03-08 | Mainland China | Hubei | 67707 | 2986 | 45235 | 30.9756 | 112.2707 | 2020-03-08T14:43:03 | ||||
657683 | 657683 | 2020-03-09 | Mainland China | Hubei | 67743 | 3008 | 46488 | 30.9756 | 112.2707 | 2020-03-09T14:33:03 | ||||
3752814 | 3752814 | 2020-03-10 | Mainland China | Hubei | 67760 | 3024 | 47743 | 30.9756 | 112.2707 | 2020-03-10T15:13:05 | ||||
2127430 | 2127430 | 2020-03-11 | China | Hubei | 67773 | 3046 | 49134 | 30.9756 | 112.2707 | 2020-03-11T10:53:02 | ||||
2282860 | 2282860 | 2020-03-12 | China | Hubei | 67781 | 3056 | 50318 | 30.9756 | 112.2707 | 2020-03-12T09:53:06 | ||||
3765284 | 3765284 | 2020-03-13 | China | Hubei | 67786 | 3062 | 51553 | 30.9756 | 112.2707 | 2020-03-13T11:09:03 | ||||
2111086 | 2111086 | 2020-03-14 | China | Hubei | 67790 | 3075 | 52960 | 30.9756 | 112.2707 | 2020-03-14T10:13:09 | ||||
1463461 | 1463461 | 2020-03-15 | China | Hubei | 67794 | 3085 | 54288 | 30.9756 | 112.2707 | 2020-03-15T18:20:18 | ||||
2255112 | 2255112 | 2020-03-16 | China | Hubei | 67798 | 3099 | 55142 | 30.9756 | 112.2707 | 2020-03-16T14:38:45 | ||||
3891306 | 3891306 | 2020-03-17 | China | Hubei | 67799 | 3111 | 56003 | 30.9756 | 112.2707 | 2020-03-17T11:53:10 | ||||
1176875 | 1176875 | 2020-03-18 | China | Hubei | 67800 | 3122 | 56927 | 30.9756 | 112.2707 | 2020-03-18T12:13:09 | ||||
1526871 | 1526871 | 2020-03-19 | China | Hubei | 67800 | 3130 | 57682 | 30.9756 | 112.2707 | 2020-03-19T10:13:14 | ||||
3733920 | 3733920 | 2020-03-20 | China | Hubei | 67800 | 3133 | 58382 | 30.9756 | 112.2707 | 2020-03-20T07:43:02 | ||||
339623 | 339623 | 2020-03-21 | China | Hubei | 67800 | 3139 | 58946 | 30.9756 | 112.2707 | 2020-03-21T10:13:08 | ||||
2910606 | 2910606 | 2020-03-22 | China | Hubei | 67800 | 3144 | 59433 | 5223 | 30.9756 | 112.2707 | 3/22/20 9:33 | Hubei, China | ||
2147064 | 2147064 | 2020-03-23 | China | Hubei | 67800 | 3153 | 59882 | 4765 | 30.9756 | 112.2707 | 2020-03-23 05:06:15 | Hubei, China | ||
1479005 | 1479005 | 2020-03-24 | China | Hubei | 67801 | 3160 | 60324 | 4317 | 30.9756 | 112.2707 | 2020-03-24 13:02:57 | Hubei, China | ||
1132497 | 1132497 | 2020-03-25 | China | Hubei | 67801 | 3163 | 60811 | 3827 | 30.9756 | 112.2707 | 2020-03-25 10:50:39 | Hubei, China | ||
919094 | 919094 | 2020-03-26 | China | Hubei | 67801 | 3169 | 61201 | 3431 | 30.9756 | 112.2707 | 2020-03-26 01:21:08 | Hubei, China | ||
809001 | 809001 | 2020-03-27 | China | Hubei | 67801 | 3174 | 61732 | 2895 | 30.9756 | 112.2707 | 2020-03-27 08:21:10 | Hubei, China | ||
3946951 | 3946951 | 2020-03-28 | China | Hubei | 67801 | 3177 | 62098 | 2526 | 30.9756 | 112.2707 | 3/28/20 1:26 | Hubei, China | ||
2875615 | 2875615 | 2020-03-29 | China | Hubei | 67801 | 3182 | 62570 | 2049 | 30.9756 | 112.2707 | 3/29/20 14:07 | Hubei, China | ||
1872378 | 1872378 | 2020-03-30 | China | Hubei | 67801 | 3186 | 62889 | 1726 | 30.9756 | 112.2707 | 3/30/20 12:30 | Hubei, China | ||
3815826 | 3815826 | 2020-03-31 | China | Hubei | 67801 | 3187 | 63153 | 1461 | 30.9756 | 112.2707 | 2020-03-31 01:06:37 | Hubei, China | ||
3364733 | 3364733 | 2020-04-01 | China | Hubei | 67802 | 3193 | 63326 | 1283 | 30.9756 | 112.2707 | 2020-04-01 06:20:26 | Hubei, China | ||
3701529 | 3701529 | 2020-04-02 | China | Hubei | 67802 | 3199 | 63471 | 1132 | 30.9756 | 112.2707 | 4/2/20 8:26 | Hubei, China | ||
3740499 | 3740499 | 2020-04-03 | China | Hubei | 67802 | 3203 | 63612 | 987 | 30.9756 | 112.2707 | 2020-04-03 02:54:04 | Hubei, China | ||
1750688 | 1750688 | 2020-04-04 | China | Hubei | 67803 | 3207 | 63762 | 834 | 30.9756 | 112.2707 | 4/4/20 1:13 | Hubei, China | ||
589044 | 589044 | 2020-04-05 | China | Hubei | 67803 | 3210 | 63945 | 648 | 30.9756 | 112.2707 | 2020-04-05 02:06:47 | Hubei, China | ||
3627356 | 3627356 | 2020-04-06 | China | Hubei | 67803 | 3212 | 64014 | 577 | 30.9756 | 112.2707 | 4/6/20 2:21 | Hubei, China | ||
3021674 | 3021674 | 2020-04-07 | China | Hubei | 67803 | 3212 | 64073 | 518 | 30.9756 | 112.2707 | 2020-04-07 01:46:23 | Hubei, China | ||
3561999 | 3561999 | 2020-04-08 | China | Hubei | 67803 | 3213 | 64142 | 448 | 30.9756 | 112.2707 | 2020-04-08 00:37:38 | Hubei, China | ||
3949892 | 3949892 | 2020-04-09 | China | Hubei | 67803 | 3215 | 64187 | 401 | 30.9756 | 112.2707 | 2020-04-09 01:34:36 | Hubei, China | ||
1250155 | 1250155 | 2020-04-10 | China | Hubei | 67803 | 3216 | 64236 | 351 | 30.9756 | 112.2707 | 2020-04-10 01:42:58 | Hubei, China | ||
2566970 | 2566970 | 2020-04-11 | China | Hubei | 67803 | 3219 | 64264 | 320 | 30.9756 | 112.2707 | 2020-04-11 01:38:00 | Hubei, China | ||
2578133 | 2578133 | 2020-04-12 | China | Hubei | 67803 | 3219 | 64281 | 303 | 30.9756 | 112.2707 | 2020-04-12 02:25:00 | Hubei, China | ||
43107 | 43107 | 2020-04-13 | China | Hubei | 67803 | 3221 | 64338 | 244 | 30.9756 | 112.2707 | 2020-04-13 09:36:31 | Hubei, China | ||
3338010 | 3338010 | 2020-04-14 | China | Hubei | 67803 | 3221 | 64363 | 219 | 30.9756 | 112.2707 | 2020-04-14 01:11:34 | Hubei, China | ||
860094 | 860094 | 2020-04-15 | China | Hubei | 67803 | 3222 | 64402 | 179 | 30.9756 | 112.2707 | 2020-04-15 01:45:25 | Hubei, China | ||
934200 | 934200 | 2020-04-16 | China | Hubei | 67803 | 3222 | 64435 | 146 | 30.9756 | 112.2707 | 2020-04-16 01:54:44 | Hubei, China | ||
50206 | 50206 | 2020-04-17 | China | Hubei | 68128 | 4512 | 63487 | 129 | 30.9756 | 112.2707 | 2020-04-17 05:08:48 | Hubei, China | ||
418734 | 418734 | 2020-04-18 | China | Hubei | 68128 | 4512 | 63494 | 122 | 30.9756 | 112.2707 | 2020-04-18 01:15:10 | Hubei, China | ||
1385046 | 1385046 | 2020-04-19 | China | Hubei | 68128 | 4512 | 63507 | 109 | 30.9756 | 112.2707 | 2020-04-19 01:34:48 | Hubei, China | ||
2473354 | 2473354 | 2020-04-20 | China | Hubei | 68128 | 4512 | 63511 | 105 | 30.9756 | 112.2707 | 2020-04-20 01:51:43 | Hubei, China | ||
522272 | 522272 | 2020-04-21 | China | Hubei | 68128 | 4512 | 63514 | 102 | 30.9756 | 112.2707 | 2020-04-21 01:02:30 | Hubei, China | ||
1199206 | 1199206 | 2020-04-22 | China | Hubei | 68128 | 4512 | 63519 | 97 | 30.9756 | 112.2707 | 2020-04-22 01:32:33 | Hubei, China | ||
2524763 | 2524763 | 2020-04-23 | China | Hubei | 68128 | 4512 | 63569 | 47 | 30.9756 | 112.2707 | 2020-04-24 01:35:26 | Hubei, China | ||
1459177 | 1459177 | 2020-04-24 | China | Hubei | 68128 | 4512 | 63593 | 23 | 30.9756 | 112.2707 | 2020-04-25 00:49:34 | Hubei, China | ||
3502776 | 3502776 | 2020-04-25 | China | Hubei | 68128 | 4512 | 63604 | 12 | 30.9756 | 112.2707 | 2020-04-26 00:51:44 | Hubei, China | ||
3592427 | 3592427 | 2020-04-26 | China | Hubei | 68128 | 4512 | 63616 | 0 | 30.9756 | 112.2707 | 2020-04-27 01:18:19 | Hubei, China | ||
3589246 | 3589246 | 2020-04-27 | China | Hubei | 68128 | 4512 | 63616 | 0 | 30.9756 | 112.2707 | 2020-04-27 01:18:19 | Hubei, China | ||
271584 | 271584 | 2020-04-28 | China | Hubei | 68128 | 4512 | 63616 | 0 | 30.9756 | 112.2707 | 2020-04-29 02:32:29 | Hubei, China | ||
137370 | 137370 | 2020-04-29 | China | Hubei | 68128 | 4512 | 63616 | 0 | 30.9756 | 112.2707 | 2020-04-30 02:32:27 | Hubei, 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]);