This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31071 | 31071 | 1916-03-25 | 7 | a-b | Australia news/ A bank robbery in Victoria. Bagasse used to manufacture papers in Melbourne. A white man is beaten to death while playing snake in Sydney. Chinese communities in Australia distrust the Chinese government for their lies. Number of Australian troops. Penalties for illegal wines in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31072 | 31072 | 1916-03-25 | 7 | b | Report on the political chaos in China following the independence of Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31073 | 31073 | 1916-03-25 | 7 | c | Miscellaneous reports on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31074 | 31074 | 1916-03-25 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 | |
31075 | 31075 | 1916-03-25 | 7 | c | A notice issued by the Wing On Insurance Company in Hong Kong on its branches and managers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095206 | 24095206 |
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]);