This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32182 | 32182 | 1917-03-31 | 3 | a | The new military governor of Zhejiang province Yang Shande and his story. | China | http://trove.nla.gov.au/newspaper/page/24095640 | 24095640 | |
32183 | 32183 | 1917-03-31 | 3 | a-b | Further report on the welcome ceremony in Beijing for Cai Yuanpei and Liang Qichao. | China | http://trove.nla.gov.au/newspaper/page/24095640 | 24095640 | |
32184 | 32184 | 1917-03-31 | 3 | c-d | Residents in Changshan county, Shandong province, request to suppress bandits. | China | http://trove.nla.gov.au/newspaper/page/24095640 | 24095640 | |
32185 | 32185 | 1917-03-31 | 3 | d | America and China join the War and the report. | China | http://trove.nla.gov.au/newspaper/page/24095640 | 24095640 | |
32186 | 32186 | 1917-03-31 | 3 | d-f | News on the World War I (Poland after the War, German ambassador in China leaves, Japanese government bans publication of liner timetable, and other news on the World War I). | Other... | http://trove.nla.gov.au/newspaper/page/24095640 | 24095640 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] ( [date] TEXT, [page] TEXT, [column] TEXT, [title] TEXT, [description] TEXT, [source] TEXT, [page_url] TEXT, [trove_id] TEXT ); CREATE INDEX [idx_article_index_date] ON [article_index] ([date]);