This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31217 | 31217 | 1916-05-13 | 6 | a-c | Liang Qichao's speech to the service men and his advice to the Chinese people. | China | http://trove.nla.gov.au/newspaper/page/24095264 | 24095264 | |
31218 | 31218 | 1916-05-13 | 6 | c | Guangdong news/ More travel allowance to members of the provincial legislature assembly. General commander of the Humen army headquarters has new office. Overseas Guangdong businessmen write to the Chamber of Commerce in Guangdong and the charity institutions. Long Jianzhang is going to Beijing. Bandits in Nanhai county kill local security guards. A scholarship society in Guangzhou is closed. Counterfeit money found in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24095264 | 24095264 |
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]);