This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28802 | 28802 | 1914-05-09 | 3 | b | The investigation on the bribery case of Japanese navy. | Japan | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28803 | 28803 | 1914-05-09 | 3 | b | Foreign countries (Britain, France, Germany, Brazil, Peru, etc) are to mediate the conflict between America and Mexico. Report on the chaos in Mexico and their conflict with America. | Britain | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28820 | 28820 | 1914-05-09 | 8 | b | Beijing news/ Zhang Qihuang is going to Guangdong on new mission. Lawyer association in Beijing offer free service to some selected clients. Relations between revolutionary rebels like Chen Qimei and bandits. Zhao Er'tuan goes to the court on behalf of his brother. | China | http://trove.nla.gov.au/newspaper/page/24093108 | 24093108 |
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]);