This data as json, CSV (advanced)
Suggested facets: page, column, description, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50712 | 50712 | 1931-09-19 | 2 | b | First part of editorial on China's negotiations with Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090527 | 24090527 | |
50719 | 50719 | 1931-09-19 | 5 | c | Hunting a girl in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090528 | 24090528 | |
50720 | 50720 | 1931-09-19 | 5 | e | Notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090528 | 24090528 | |
50728 | 50728 | 1931-09-19 | 8 | c | Australia news/ An old man in Sydney dies with grievance because of his savings in the Savings Bank of New South Wales. Profit of lottery in New South Wales. Dozens of people arrested in Sydney for communist propaganda. The Overseas Chinese Famine Relief Committee in Shanghai acknowledges receipt of the donations from the Chinese communities in Australia. Girl is raped in Sydney. Police arrest in a Sydney dancing club. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50729 | 50729 | 1931-09-19 | 8 | d | Notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50730 | 50730 | 1931-09-19 | 8 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 |
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]);