This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46206 | 46206 | 1927-09-24 | 2 | b | Editorial on the Outer Mongolia and its today. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098536 | 24098536 | |
46210 | 46210 | 1927-09-24 | 3 | b | Japan's policy in Manchuria and Mongolia and their strategy of invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098535 | 24098535 | |
46226 | 46226 | 1927-09-24 | 7 | a | Meeting notice by the Chinese Chamber of Commerce in Sydney on the birthday celebration for Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098539 | 24098539 | |
46227 | 46227 | 1927-09-24 | 7 | a | Australia news/ A white man is sentenced to three years' imprisonment for sexual harassment. Many Italian immigrants arrive Australia. Girl in Sydney suicides for love. Chinese sailor dies while working. Picnic for the birthday celebration of Confucius. Well-known play writer dies in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098539 | 24098539 | |
46229 | 46229 | 1927-09-24 | 7 | c | Counterfeit bank notes found on Sydney market. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098539 | 24098539 | |
46230 | 46230 | 1927-09-24 | 7 | c | Advertisement for Fred Walker & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098539 | 24098539 | |
46231 | 46231 | 1927-09-24 | 7 | c | Urgent notice by Zheng Wen to transfer Chinese graves for the proposed road construction. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098539 | 24098539 |
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]);