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 |
---|---|---|---|---|---|---|---|---|---|
47353 | 47353 | 1928-08-25 | 2 | b | Second and final part of the report on Japanese invasion in the three north-eastern Chinese provinces (Manchuria). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098922 | 24098922 | |
47365 | 47365 | 1928-08-25 | 5 | b | Fourth and final part of the survey on the mercurial mining resources in Guizhou province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098923 | 24098923 | |
47366 | 47366 | 1928-08-25 | 5 | c | Story from a girl school in Suzhou, Jiangsu province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098923 | 24098923 | |
47375 | 47375 | 1928-08-25 | 8 | c | Australia news/ Storm in Tahiti. Chinese Consul-General Wei Zijing is returning for holiday and the new consul Wu Qinfen takes office. The Pacific women's conference in Hawaii and women's rights. Pensions increases for families to the servicemen who died in the Europe war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47376 | 47376 | 1928-08-25 | 8 | d | A notice by the Chinese Chamber of Commerce in New South Wales soliciting contributions on the National Day of October 10 and the birthday celebration for Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 |
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]);