johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where country_or_region = "Mainland China" and province_or_state = "Jiangxi" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3752826 | 3752826 | 2020-03-10 | Mainland China | Jiangxi | 935 | 1 | 927 | 27.614 | 115.7221 | 2020-03-10T01:33:02 | ||||
657695 | 657695 | 2020-03-09 | Mainland China | Jiangxi | 935 | 1 | 923 | 27.614 | 115.7221 | 2020-03-09T01:53:01 | ||||
1527210 | 1527210 | 2020-03-08 | Mainland China | Jiangxi | 935 | 1 | 919 | 27.614 | 115.7221 | 2020-03-08T06:53:04 | ||||
62481 | 62481 | 2020-03-07 | Mainland China | Jiangxi | 935 | 1 | 916 | 27.614 | 115.7221 | 2020-03-07T01:13:18 | ||||
3177484 | 3177484 | 2020-03-06 | Mainland China | Jiangxi | 935 | 1 | 909 | 27.614 | 115.7221 | 2020-03-06T14:23:04 | ||||
40140 | 40140 | 2020-03-05 | Mainland China | Jiangxi | 935 | 1 | 901 | 27.614 | 115.7221 | 2020-03-05T01:16:58 | ||||
98810 | 98810 | 2020-03-04 | Mainland China | Jiangxi | 935 | 1 | 884 | 27.614 | 115.7221 | 2020-03-04T01:33:07 | ||||
261025 | 261025 | 2020-03-03 | Mainland China | Jiangxi | 935 | 1 | 870 | 27.614 | 115.7221 | 2020-03-03T02:03:11 | ||||
1152641 | 1152641 | 2020-03-02 | Mainland China | Jiangxi | 935 | 1 | 850 | 27.614 | 115.7221 | 2020-03-02T01:33:02 | ||||
562502 | 562502 | 2020-03-01 | Mainland China | Jiangxi | 935 | 1 | 831 | 27.614 | 115.7221 | 2020-03-01T01:13:10 | ||||
3205790 | 3205790 | 2020-02-29 | Mainland China | Jiangxi | 935 | 1 | 811 | 27.614 | 115.7221 | 2020-02-29T01:23:07 | ||||
2883912 | 2883912 | 2020-02-28 | Mainland China | Jiangxi | 935 | 1 | 790 | 27.614 | 115.7221 | 2020-02-28T01:13:11 | ||||
617397 | 617397 | 2020-02-27 | Mainland China | Jiangxi | 934 | 1 | 754 | 27.614 | 115.7221 | 2020-02-27T01:43:02 | ||||
2509753 | 2509753 | 2020-02-26 | Mainland China | Jiangxi | 934 | 1 | 719 | 27.614 | 115.7221 | 2020-02-26T01:13:04 | ||||
479136 | 479136 | 2020-02-25 | Mainland China | Jiangxi | 934 | 1 | 683 | 27.614 | 115.7221 | 2020-02-25T15:03:05 | ||||
3551199 | 3551199 | 2020-02-24 | Mainland China | Jiangxi | 934 | 1 | 645 | 27.614 | 115.7221 | 2020-02-24T01:23:09 | ||||
3173343 | 3173343 | 2020-02-23 | Mainland China | Jiangxi | 934 | 1 | 613 | 27.614 | 115.7221 | 2020-02-23T09:23:02 | ||||
1085632 | 1085632 | 2020-02-22 | Mainland China | Jiangxi | 934 | 1 | 555 | 27.614 | 115.7221 | 2020-02-22T06:13:05 | ||||
2135714 | 2135714 | 2020-02-21 | Mainland China | Jiangxi | 934 | 1 | 489 | 27.614 | 115.7221 | 2020-02-21T01:13:05 | ||||
2263456 | 2263456 | 2020-02-20 | Mainland China | Jiangxi | 934 | 1 | 433 | 27.614 | 115.7221 | 2020-02-20T05:23:02 | ||||
1720048 | 1720048 | 2020-02-19 | Mainland China | Jiangxi | 934 | 1 | 362 | 27.614 | 115.7221 | 2020-02-19T01:23:07 | ||||
1783080 | 1783080 | 2020-02-18 | Mainland China | Jiangxi | 933 | 1 | 310 | 27.614 | 115.7221 | 2020-02-18T01:33:01 | ||||
1243354 | 1243354 | 2020-02-17 | Mainland China | Jiangxi | 930 | 1 | 275 | 27.614 | 115.7221 | 2020-02-17T01:33:02 | ||||
1888707 | 1888707 | 2020-02-16 | Mainland China | Jiangxi | 925 | 1 | 240 | 27.614 | 115.7221 | 2020-02-16T10:03:06 | ||||
107033 | 107033 | 2020-02-15 | Mainland China | Jiangxi | 913 | 1 | 210 | 27.614 | 115.7221 | 2020-02-15T01:33:02 | ||||
1192452 | 1192452 | 2020-02-14 | Mainland China | Jiangxi | 900 | 1 | 187 | 27.614 | 115.7221 | 2020-02-14T01:13:06 | ||||
1559659 | 1559659 | 2020-02-13 | Mainland China | Jiangxi | 872 | 1 | 170 | 27.614 | 115.7221 | 2020-02-13T01:13:08 | ||||
2567249 | 2567249 | 2020-02-12 | Mainland China | Jiangxi | 844 | 1 | 152 | 27.614 | 115.7221 | 2020-02-12T01:23:06 | ||||
3197708 | 3197708 | 2020-02-11 | Mainland China | Jiangxi | 804 | 1 | 128 | 27.614 | 115.7221 | 2020-02-11T14:03:05 | ||||
3089007 | 3089007 | 2020-02-10 | Mainland China | Jiangxi | 771 | 1 | 105 | 27.614 | 115.7221 | 2020-02-10T13:53:02 | ||||
3362376 | 3362376 | 2020-02-09 | Mainland China | Jiangxi | 740 | 0 | 73 | 27.614 | 115.7221 | 2020-02-09T11:33:12 | ||||
1366046 | 1366046 | 2020-02-08 | Mainland China | Jiangxi | 698 | 0 | 55 | 27.614 | 115.7221 | 2020-02-08T01:23:02 | ||||
3222005 | 3222005 | 2020-02-07 | Mainland China | Jiangxi | 661 | 0 | 45 | 27.614 | 115.7221 | 2020-02-07T01:23:02 | ||||
566673 | 566673 | 2020-02-06 | Mainland China | Jiangxi | 600 | 0 | 37 | 27.614 | 115.7221 | 2020-02-06T02:33:01 | ||||
2091666 | 2091666 | 2020-02-05 | Mainland China | Jiangxi | 548 | 0 | 27 | 27.614 | 115.7221 | 2020-02-05T01:33:07 | ||||
3471884 | 3471884 | 2020-02-04 | Mainland China | Jiangxi | 476 | 0 | 20 | 27.614 | 115.7221 | 2020-02-04T14:43:02 | ||||
2860548 | 2860548 | 2020-02-03 | Mainland China | Jiangxi | 391 | 0 | 18 | 27.614 | 115.7221 | 2020-02-03T01:33:02 | ||||
2379234 | 2379234 | 2020-02-02 | Mainland China | Jiangxi | 333 | 0 | 12 | 27.614 | 115.7221 | 2020-02-02T18:03:05 | ||||
3413146 | 3413146 | 2020-02-01 | Mainland China | Jiangxi | 286 | 0 | 9 | 27.614 | 115.7221 | 2/1/2020 1:52 | ||||
3761180 | 3761180 | 2020-01-31 | Mainland China | Jiangxi | 240 | 0 | 7 | 27.614 | 115.7221 | 1/31/2020 23:59 | ||||
1527497 | 1527497 | 2020-01-30 | Mainland China | Jiangxi | 162 | 0 | 5 | 27.614 | 115.7221 | 1/30/20 16:00 | ||||
197847 | 197847 | 2020-01-29 | Mainland China | Jiangxi | 109 | 0 | 3 | 27.614 | 115.7221 | 1/29/20 19:30 | ||||
1305759 | 1305759 | 2020-01-28 | Mainland China | Jiangxi | 109 | 0 | 3 | 27.614 | 115.7221 | 1/28/20 23:00 | ||||
3753064 | 3753064 | 2020-01-27 | Mainland China | Jiangxi | 72 | 0 | 2 | 27.614 | 115.7221 | 1/27/20 23:59 | ||||
415843 | 415843 | 2020-01-26 | Mainland China | Jiangxi | 36 | 0 | 0 | 27.614 | 115.7221 | 1/26/20 16:00 | ||||
2938945 | 2938945 | 2020-01-25 | Mainland China | Jiangxi | 18 | 0 | 0 | 27.614 | 115.7221 | 1/25/20 17:00 | ||||
197767 | 197767 | 2020-01-24 | Mainland China | Jiangxi | 18 | 0 | 0 | 27.614 | 115.7221 | 1/24/20 17:00 | ||||
864394 | 864394 | 2020-01-23 | Mainland China | Jiangxi | 7 | 0 | 0 | 27.614 | 115.7221 | 1/23/20 17:00 | ||||
1802357 | 1802357 | 2020-01-22 | Mainland China | Jiangxi | 2 | 0 | 0 | 27.614 | 115.7221 | 1/22/2020 17:00 |
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]);