This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
46228 | 46228 | 1927-09-24 | 7 | b | New faces in the Nationalist government in Nanjing. | China | 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]);