johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where confirmed = 631 and province_or_state = "Jiangsu" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update, day (date), last_update (date)
country_or_region 2
- Mainland China 21
- China 11
province_or_state 1
- Jiangsu · 32 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
339662 | 339662 | 2020-03-21 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
3733953 | 3733953 | 2020-03-20 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
1526902 | 1526902 | 2020-03-19 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
1176902 | 1176902 | 2020-03-18 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
3891333 | 3891333 | 2020-03-17 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
2255138 | 2255138 | 2020-03-16 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
1463487 | 1463487 | 2020-03-15 | China | Jiangsu | 631 | 0 | 631 | 32.9711 | 119.455 | 2020-03-15T01:53:02 | ||||
2111110 | 2111110 | 2020-03-14 | China | Jiangsu | 631 | 0 | 630 | 32.9711 | 119.455 | 2020-03-13T11:09:03 | ||||
3765292 | 3765292 | 2020-03-13 | China | Jiangsu | 631 | 0 | 630 | 32.9711 | 119.455 | 2020-03-13T11:09:03 | ||||
2282878 | 2282878 | 2020-03-12 | China | Jiangsu | 631 | 0 | 629 | 32.9711 | 119.455 | 2020-03-12T05:13:02 | ||||
2127447 | 2127447 | 2020-03-11 | China | Jiangsu | 631 | 0 | 627 | 32.9711 | 119.455 | 2020-03-11T02:18:14 | ||||
3752829 | 3752829 | 2020-03-10 | Mainland China | Jiangsu | 631 | 0 | 627 | 32.9711 | 119.455 | 2020-03-10T08:13:08 | ||||
657698 | 657698 | 2020-03-09 | Mainland China | Jiangsu | 631 | 0 | 621 | 32.9711 | 119.455 | 2020-03-09T08:53:03 | ||||
1527214 | 1527214 | 2020-03-08 | Mainland China | Jiangsu | 631 | 0 | 612 | 32.9711 | 119.455 | 2020-03-08T09:23:05 | ||||
62485 | 62485 | 2020-03-07 | Mainland China | Jiangsu | 631 | 0 | 606 | 32.9711 | 119.455 | 2020-03-07T14:53:02 | ||||
3177489 | 3177489 | 2020-03-06 | Mainland China | Jiangsu | 631 | 0 | 594 | 32.9711 | 119.455 | 2020-03-06T10:23:03 | ||||
40143 | 40143 | 2020-03-05 | Mainland China | Jiangsu | 631 | 0 | 583 | 32.9711 | 119.455 | 2020-03-05T14:53:03 | ||||
98813 | 98813 | 2020-03-04 | Mainland China | Jiangsu | 631 | 0 | 577 | 32.9711 | 119.455 | 2020-03-04T12:53:03 | ||||
261028 | 261028 | 2020-03-03 | Mainland China | Jiangsu | 631 | 0 | 562 | 32.9711 | 119.455 | 2020-03-03T11:03:09 | ||||
1152644 | 1152644 | 2020-03-02 | Mainland China | Jiangsu | 631 | 0 | 543 | 32.9711 | 119.455 | 2020-03-02T12:53:02 | ||||
562505 | 562505 | 2020-03-01 | Mainland China | Jiangsu | 631 | 0 | 536 | 32.9711 | 119.455 | 2020-03-01T10:03:03 | ||||
3205793 | 3205793 | 2020-02-29 | Mainland China | Jiangsu | 631 | 0 | 523 | 32.9711 | 119.455 | 2020-02-29T07:23:11 | ||||
2883916 | 2883916 | 2020-02-28 | Mainland China | Jiangsu | 631 | 0 | 515 | 32.9711 | 119.455 | 2020-02-28T08:53:03 | ||||
617401 | 617401 | 2020-02-27 | Mainland China | Jiangsu | 631 | 0 | 498 | 32.9711 | 119.455 | 2020-02-27T14:13:06 | ||||
2509756 | 2509756 | 2020-02-26 | Mainland China | Jiangsu | 631 | 0 | 478 | 32.9711 | 119.455 | 2020-02-26T10:13:11 | ||||
479139 | 479139 | 2020-02-25 | Mainland China | Jiangsu | 631 | 0 | 458 | 32.9711 | 119.455 | 2020-02-25T00:53:02 | ||||
3551203 | 3551203 | 2020-02-24 | Mainland China | Jiangsu | 631 | 0 | 452 | 32.9711 | 119.455 | 2020-02-24T14:53:02 | ||||
3173346 | 3173346 | 2020-02-23 | Mainland China | Jiangsu | 631 | 0 | 418 | 32.9711 | 119.455 | 2020-02-23T08:53:02 | ||||
1085635 | 1085635 | 2020-02-22 | Mainland China | Jiangsu | 631 | 0 | 401 | 32.9711 | 119.455 | 2020-02-22T07:43:03 | ||||
2135717 | 2135717 | 2020-02-21 | Mainland China | Jiangsu | 631 | 0 | 373 | 32.9711 | 119.455 | 2020-02-21T11:43:01 | ||||
2263458 | 2263458 | 2020-02-20 | Mainland China | Jiangsu | 631 | 0 | 356 | 32.9711 | 119.455 | 2020-02-20T12:53:02 | ||||
1720049 | 1720049 | 2020-02-19 | Mainland China | Jiangsu | 631 | 0 | 318 | 32.9711 | 119.455 | 2020-02-19T12:13:08 |
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]);