johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Sichuan" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2127450 | 2127450 | 2020-03-11 | China | Sichuan | 539 | 3 | 488 | 30.6171 | 102.7103 | 2020-03-11T14:33:03 | ||||
2282882 | 2282882 | 2020-03-12 | China | Sichuan | 539 | 3 | 498 | 30.6171 | 102.7103 | 2020-03-12T12:13:07 | ||||
3765294 | 3765294 | 2020-03-13 | China | Sichuan | 539 | 3 | 503 | 30.6171 | 102.7103 | 2020-03-13T11:09:03 | ||||
2111113 | 2111113 | 2020-03-14 | China | Sichuan | 539 | 3 | 511 | 30.6171 | 102.7103 | 2020-03-14T04:33:02 | ||||
1463489 | 1463489 | 2020-03-15 | China | Sichuan | 539 | 3 | 516 | 30.6171 | 102.7103 | 2020-03-15T18:20:18 | ||||
2255141 | 2255141 | 2020-03-16 | China | Sichuan | 539 | 3 | 516 | 30.6171 | 102.7103 | 2020-03-15T18:20:18 | ||||
3891335 | 3891335 | 2020-03-17 | China | Sichuan | 540 | 3 | 520 | 30.6171 | 102.7103 | 2020-03-17T08:33:02 | ||||
1176904 | 1176904 | 2020-03-18 | China | Sichuan | 540 | 3 | 525 | 30.6171 | 102.7103 | 2020-03-18T02:13:05 | ||||
1526906 | 1526906 | 2020-03-19 | China | Sichuan | 540 | 3 | 536 | 30.6171 | 102.7103 | 2020-03-19T10:13:14 | ||||
3733958 | 3733958 | 2020-03-20 | China | Sichuan | 541 | 3 | 536 | 30.6171 | 102.7103 | 2020-03-20T01:43:03 | ||||
339666 | 339666 | 2020-03-21 | China | Sichuan | 542 | 3 | 536 | 30.6171 | 102.7103 | 2020-03-21T01:13:11 | ||||
2910614 | 2910614 | 2020-03-22 | China | Sichuan | 543 | 3 | 536 | 4 | 30.6171 | 102.7103 | 3/22/20 7:20 | Sichuan, China | ||
2147100 | 2147100 | 2020-03-23 | China | Sichuan | 543 | 3 | 536 | 4 | 30.6171 | 102.7103 | 2020-03-22 07:20:38 | Sichuan, China | ||
1479043 | 1479043 | 2020-03-24 | China | Sichuan | 545 | 3 | 536 | 6 | 30.6171 | 102.7103 | 2020-03-24 01:27:08 | Sichuan, China | ||
1132535 | 1132535 | 2020-03-25 | China | Sichuan | 547 | 3 | 536 | 8 | 30.6171 | 102.7103 | 2020-03-25 06:43:02 | Sichuan, China | ||
919133 | 919133 | 2020-03-26 | China | Sichuan | 547 | 3 | 536 | 8 | 30.6171 | 102.7103 | 2020-03-25 06:43:02 | Sichuan, China | ||
809040 | 809040 | 2020-03-27 | China | Sichuan | 548 | 3 | 536 | 9 | 30.6171 | 102.7103 | 2020-03-27 02:27:01 | Sichuan, China | ||
3946990 | 3946990 | 2020-03-28 | China | Sichuan | 548 | 3 | 536 | 9 | 30.6171 | 102.7103 | 3/27/20 2:27 | Sichuan, China | ||
2875654 | 2875654 | 2020-03-29 | China | Sichuan | 550 | 3 | 536 | 11 | 30.6171 | 102.7103 | 3/29/20 1:49 | Sichuan, China | ||
1872417 | 1872417 | 2020-03-30 | China | Sichuan | 550 | 3 | 536 | 11 | 30.6171 | 102.7103 | 3/30/20 1:09 | Sichuan, China | ||
3815865 | 3815865 | 2020-03-31 | China | Sichuan | 550 | 3 | 536 | 11 | 30.6171 | 102.7103 | 2020-03-30 01:09:15 | Sichuan, China | ||
3364772 | 3364772 | 2020-04-01 | China | Sichuan | 552 | 3 | 537 | 12 | 30.6171 | 102.7103 | 2020-04-01 11:54:10 | Sichuan, China | ||
3701568 | 3701568 | 2020-04-02 | China | Sichuan | 554 | 3 | 537 | 14 | 30.6171 | 102.7103 | 4/2/20 0:58 | Sichuan, China | ||
3740538 | 3740538 | 2020-04-03 | China | Sichuan | 555 | 3 | 537 | 15 | 30.6171 | 102.7103 | 2020-04-03 04:49:20 | Sichuan, China | ||
1750727 | 1750727 | 2020-04-04 | China | Sichuan | 557 | 3 | 538 | 16 | 30.6171 | 102.7103 | 4/4/20 1:07 | Sichuan, China | ||
589084 | 589084 | 2020-04-05 | China | Sichuan | 558 | 3 | 539 | 16 | 30.6171 | 102.7103 | 2020-04-05 01:28:19 | Sichuan, China | ||
3627396 | 3627396 | 2020-04-06 | China | Sichuan | 559 | 3 | 540 | 16 | 30.6171 | 102.7103 | 4/6/20 1:14 | Sichuan, China | ||
3021714 | 3021714 | 2020-04-07 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
3562039 | 3562039 | 2020-04-08 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
3949932 | 3949932 | 2020-04-09 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
1250195 | 1250195 | 2020-04-10 | China | Sichuan | 560 | 3 | 546 | 11 | 30.6171 | 102.7103 | 2020-04-10 01:07:31 | Sichuan, China | ||
2567010 | 2567010 | 2020-04-11 | China | Sichuan | 560 | 3 | 547 | 10 | 30.6171 | 102.7103 | 2020-04-11 00:41:14 | Sichuan, China | ||
2578173 | 2578173 | 2020-04-12 | China | Sichuan | 560 | 3 | 547 | 10 | 30.6171 | 102.7103 | 2020-04-11 00:41:00 | Sichuan, China | ||
43147 | 43147 | 2020-04-13 | China | Sichuan | 560 | 3 | 548 | 9 | 30.6171 | 102.7103 | 2020-04-13 09:36:31 | Sichuan, China | ||
3338050 | 3338050 | 2020-04-14 | China | Sichuan | 560 | 3 | 548 | 9 | 30.6171 | 102.7103 | 2020-04-13 09:36:31 | Sichuan, China | ||
860134 | 860134 | 2020-04-15 | China | Sichuan | 560 | 3 | 550 | 7 | 30.6171 | 102.7103 | 2020-04-15 01:04:46 | Sichuan, China | ||
934240 | 934240 | 2020-04-16 | China | Sichuan | 560 | 3 | 552 | 5 | 30.6171 | 102.7103 | 2020-04-16 01:07:06 | Sichuan, China | ||
50246 | 50246 | 2020-04-17 | China | Sichuan | 560 | 3 | 552 | 5 | 30.6171 | 102.7103 | 2020-04-16 01:07:06 | Sichuan, China | ||
418774 | 418774 | 2020-04-18 | China | Sichuan | 561 | 3 | 553 | 5 | 30.6171 | 102.7103 | 2020-04-18 01:43:34 | Sichuan, China | ||
1385086 | 1385086 | 2020-04-19 | China | Sichuan | 561 | 3 | 554 | 4 | 30.6171 | 102.7103 | 2020-04-19 00:51:07 | Sichuan, China | ||
2473394 | 2473394 | 2020-04-20 | China | Sichuan | 561 | 3 | 554 | 4 | 30.6171 | 102.7103 | 2020-04-19 00:51:07 | Sichuan, China | ||
522312 | 522312 | 2020-04-21 | China | Sichuan | 561 | 3 | 554 | 4 | 30.6171 | 102.7103 | 2020-04-19 00:51:07 | Sichuan, China | ||
1199246 | 1199246 | 2020-04-22 | China | Sichuan | 561 | 3 | 556 | 2 | 30.6171 | 102.7103 | 2020-04-22 00:45:39 | Sichuan, China | ||
2524800 | 2524800 | 2020-04-23 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
1459211 | 1459211 | 2020-04-24 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
3502810 | 3502810 | 2020-04-25 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
3592461 | 3592461 | 2020-04-26 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
3589283 | 3589283 | 2020-04-27 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
271624 | 271624 | 2020-04-28 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-29 02:32:29 | Sichuan, China | ||
137410 | 137410 | 2020-04-29 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-30 02:32:27 | Sichuan, China | ||
228663 | 228663 | 2020-04-30 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-01 02:32:28 | Sichuan, China | ||
1184182 | 1184182 | 2020-05-01 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-02 02:32:27 | Sichuan, China | ||
2043288 | 2043288 | 2020-05-02 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-03 02:32:28 | Sichuan, China | ||
2278612 | 2278612 | 2020-05-03 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-04 02:32:28 | Sichuan, China | ||
3084753 | 3084753 | 2020-05-04 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-05 02:32:34 | Sichuan, China | ||
1931890 | 1931890 | 2020-05-05 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-06 02:32:31 | Sichuan, China | ||
2110850 | 2110850 | 2020-05-06 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-07 02:32:28 | Sichuan, China | ||
3295629 | 3295629 | 2020-05-07 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-08 02:32:32 | Sichuan, China | ||
114186 | 114186 | 2020-05-08 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-09 02:32:35 | Sichuan, China | ||
2899137 | 2899137 | 2020-05-09 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-10 02:32:30 | Sichuan, China | ||
3459596 | 3459596 | 2020-05-10 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-11 02:32:30 | Sichuan, China | ||
3330981 | 3330981 | 2020-05-11 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-12 03:32:27 | Sichuan, China | ||
2581447 | 2581447 | 2020-05-12 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-13 03:32:26 | Sichuan, China | ||
3847240 | 3847240 | 2020-05-13 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-14 03:32:28 | Sichuan, China | ||
1404473 | 1404473 | 2020-05-14 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-15 02:33:02 | Sichuan, China | ||
3276299 | 3276299 | 2020-05-15 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-16 02:32:19 | Sichuan, China | ||
1829583 | 1829583 | 2020-05-16 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-17 02:32:32 | Sichuan, China | ||
3416349 | 3416349 | 2020-05-17 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-18 02:32:21 | Sichuan, China | ||
3260955 | 3260955 | 2020-05-18 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-19 02:32:18 | Sichuan, China | ||
2390217 | 2390217 | 2020-05-19 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-20 02:32:19 | Sichuan, China | ||
1431986 | 1431986 | 2020-05-20 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-21 02:32:48 | Sichuan, China | ||
268403 | 268403 | 2020-05-21 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-22 02:36:51 | Sichuan, China | ||
1864897 | 1864897 | 2020-05-22 | China | Sichuan | 563 | 3 | 558 | 2 | 30.6171 | 102.7103 | 2020-05-23 02:32:42 | Sichuan, China | ||
997874 | 997874 | 2020-05-23 | China | Sichuan | 563 | 3 | 558 | 2 | 30.6171 | 102.7103 | 2020-05-24 02:32:43 | Sichuan, China | ||
875683 | 875683 | 2020-05-24 | China | Sichuan | 564 | 3 | 558 | 3 | 30.6171 | 102.7103 | 2020-05-25 02:32:44 | Sichuan, China | ||
1105003 | 1105003 | 2020-05-25 | China | Sichuan | 564 | 3 | 558 | 3 | 30.6171 | 102.7103 | 2020-05-26 02:32:35 | Sichuan, China | ||
1041273 | 1041273 | 2020-05-26 | China | Sichuan | 564 | 3 | 558 | 3 | 30.6171 | 102.7103 | 2020-05-27 02:32:31 | Sichuan, China | ||
2548310 | 2548310 | 2020-05-27 | China | Sichuan | 564 | 3 | 558 | 3 | 30.6171 | 102.7103 | 2020-05-28 02:32:31 | Sichuan, China | ||
2712376 | 2712376 | 2020-05-28 | China | Sichuan | 564 | 3 | 558 | 3 | 30.6171 | 102.7103 | 2020-05-29 02:32:50 | Sichuan, China | ||
1790497 | 1790497 | 2020-05-29 | China | Sichuan | 564 | 3 | 558 | 3 | 30.6171 | 102.7103 | 2020-05-30 02:32:48 | Sichuan, China | ||
3638956 | 3638956 | 2020-05-30 | China | Sichuan | 564 | 3 | 558 | 3 | 30.6171 | 102.7103 | 2020-05-31 02:32:45 | Sichuan, China | ||
1794063 | 1794063 | 2020-05-31 | China | Sichuan | 575 | 3 | 558 | 14 | 30.6171 | 102.7103 | 2020-06-01 02:32:46 | Sichuan, China | ||
805502 | 805502 | 2020-06-01 | China | Sichuan | 577 | 3 | 558 | 16 | 30.6171 | 102.7103 | 2020-06-02 02:33:08 | Sichuan, China | ||
2555965 | 2555965 | 2020-06-02 | China | Sichuan | 577 | 3 | 558 | 16 | 30.6171 | 102.7103 | 2020-06-03 02:33:13 | Sichuan, China | ||
3866923 | 3866923 | 2020-06-03 | China | Sichuan | 577 | 3 | 558 | 16 | 30.6171 | 102.7103 | 2020-06-04 02:33:14 | Sichuan, China | ||
1281368 | 1281368 | 2020-06-04 | China | Sichuan | 578 | 3 | 558 | 17 | 30.6171 | 102.7103 | 2020-06-05 02:33:06 | Sichuan, China | ||
1269899 | 1269899 | 2020-06-05 | China | Sichuan | 578 | 3 | 558 | 17 | 30.6171 | 102.7103 | 2020-06-06 02:33:00 | Sichuan, China | ||
574202 | 574202 | 2020-06-06 | China | Sichuan | 578 | 3 | 558 | 17 | 30.6171 | 102.7103 | 2020-06-07 03:53:30 | Sichuan, China | ||
2800146 | 2800146 | 2020-06-07 | China | Sichuan | 581 | 3 | 558 | 20 | 30.6171 | 102.7103 | 2020-06-08 03:33:22 | Sichuan, China | ||
217350 | 217350 | 2020-06-08 | China | Sichuan | 582 | 3 | 558 | 21 | 30.6171 | 102.7103 | 2020-06-09 03:33:03 | Sichuan, China | ||
1210923 | 1210923 | 2020-06-09 | China | Sichuan | 582 | 3 | 558 | 21 | 30.6171 | 102.7103 | 2020-06-10 04:07:00 | Sichuan, China | ||
2864097 | 2864097 | 2020-06-10 | China | Sichuan | 582 | 3 | 560 | 19 | 30.6171 | 102.7103 | 2020-06-11 03:33:41 | Sichuan, China | ||
1273656 | 1273656 | 2020-06-11 | China | Sichuan | 582 | 3 | 561 | 18 | 30.6171 | 102.7103 | 2020-06-12 05:09:52 | Sichuan, China | ||
737686 | 737686 | 2020-06-12 | China | Sichuan | 583 | 3 | 562 | 18 | 30.6171 | 102.7103 | 2020-06-13 03:33:14 | Sichuan, China | ||
3061366 | 3061366 | 2020-06-13 | China | Sichuan | 583 | 3 | 563 | 17 | 30.6171 | 102.7103 | 2020-06-14 03:33:15 | Sichuan, China | ||
1837314 | 1837314 | 2020-06-14 | China | Sichuan | 587 | 3 | 563 | 21 | 30.6171 | 102.7103 | 2020-06-15 03:33:14 | Sichuan, China | ||
287363 | 287363 | 2020-06-15 | China | Sichuan | 588 | 3 | 564 | 21 | 30.6171 | 102.7103 | 2020-06-16 04:33:09 | Sichuan, China | ||
2386800 | 2386800 | 2020-06-16 | China | Sichuan | 589 | 3 | 565 | 21 | 30.6171 | 102.7103 | 2020-06-17 04:33:21 | Sichuan, China | ||
1196037 | 1196037 | 2020-06-17 | China | Sichuan | 589 | 3 | 567 | 19 | 30.6171 | 102.7103 | 2020-06-18 04:33:18 | Sichuan, China | ||
3682834 | 3682834 | 2020-06-18 | China | Sichuan | 589 | 3 | 569 | 17 | 30.6171 | 102.7103 | 2020-06-19 04:33:17 | Sichuan, 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]);