This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32938 | 32938 | 1918-02-09 | 6 | c-d | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24097175 | 24097175 | |
32941 | 32941 | 1918-02-09 | 7 | c-d | Further report on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097174 | 24097174 | |
32946 | 32946 | 1918-02-09 | 8 | c-d | Guangdong news/ An open letter issued by Yunnan army now stationing in Guangdong. Lu Rongting prepares for peace and the war as well. The railway from Guangzhou to Hankou resumes operation. Civic corps make trouble in Dongguan county. Civil corps suppressed in Shunde and Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24097176 | 24097176 |
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]);