This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32098 | 32098 | 1917-02-17 | 7 | a-b | Australia news/ Chinese Chamber of Commerce in New South Wales elects Ma Yingbiao candidate for the Chinese national senator, and other two candidates are Guo Le and Lu Yijun. Statistics of Australia's imports and exports in the last seven years (1910-1917). A Chinese man in injured in a tram accident in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095604 | 24095604 | |
32099 | 32099 | 1917-02-17 | 7 | b-c | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095604 | 24095604 | |
32100 | 32100 | 1917-02-17 | 7 | c-d | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24095604 | 24095604 | |
32101 | 32101 | 1917-02-17 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095604 | 24095604 |
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]);