This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44836 | 44836 | 1926-06-12 | 7 | a-b | A public notice by the Chinese Chamber of Commerce in Sydney on the meeting of its envoys with the federal government officials in Melbourne on the White Australia policy and the equal treatment to the Chinese community. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101593 | 24101593 | |
44837 | 44837 | 1926-06-12 | 7 | b-d | Australia news/ A pilot student dies in an accident in Melbourne. Proposal to close the night market in Sydney. Attention to the Chinese gardeners on the vegetable growing and the health requirements. A notice to gas customers. Flu in Sydney. Illegal Chinese immigrants are detained in Darwin. Change of women's fashion in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101593 | 24101593 | |
44838 | 44838 | 1926-06-12 | 7 | d | A man in New Zealand is sentenced to eight years' imprisonment for the rape of an underage girl. Returned servicemen support the White New Zealand policy. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101593 | 24101593 | |
44839 | 44839 | 1926-06-12 | 7 | d | Brazil quits the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24101593 | 24101593 | |
44840 | 44840 | 1926-06-12 | 7 | d | Gandhi on the way to Finland. | Other... | http://trove.nla.gov.au/newspaper/page/24101593 | 24101593 | |
44841 | 44841 | 1926-06-12 | 7 | d | Bandits in Guangxi province kill a foreigner. | China | http://trove.nla.gov.au/newspaper/page/24101593 | 24101593 |
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]);