This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45113 | 45113 | 1926-08-28 | 7 | a-c | Australia news/ The New South Wales state authority investigate the Chinese furniture shops and their working hours. Captain is punished in Sydney for illegal immigrants. Rapist is sentenced to death in Melbourne. Conclusion of the court hearing in New Castle on the illegal Chinese immigrant. Japanese parliament members come to visit Australia. Chinese Chamber of Commerce in Sydney prepares to celebrate the birthday of Confucius. Shop burglary in Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101683 | 24101683 | |
45114 | 45114 | 1926-08-28 | 7 | d | Advertisement for the Australia-China Navigation Company Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101683 | 24101683 | |
45115 | 45115 | 1926-08-28 | 7 | d | A notice by the Chinese Presbyterian church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101683 | 24101683 |
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]);