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 |
---|---|---|---|---|---|---|---|---|---|
47882 | 47882 | 1929-03-16 | 2 | b | Comments by Tung Wah Times on the precautions against Soviet Russian in Xinjiang, the north-west of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099146 | 24099146 | |
47899 | 47899 | 1929-03-16 | 5 | c-f | Notice issued by the Overseas Chinese Commission of the Nationalist government in Nanjing collecting sample producers among the overseas Chinese communities. And specified explanation of the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099147 | 24099147 | |
47906 | 47906 | 1929-03-16 | 8 | b | Australia news/ Earthquake in New Zealand. Arrest in Sydney for illegal wine. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47907 | 47907 | 1929-03-16 | 8 | c | Garden for hire in Bankstown, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47908 | 47908 | 1929-03-16 | 8 | c | Notice by Guo Jianying to resign from the position of executive member of the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47909 | 47909 | 1929-03-16 | 8 | d | Notice jointly issued by the Chinese Chamber of Commerce in Sydney and the Chinese-Foreign Famine Relief Committee in Shanghai calls for donations to the famine victims in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 |
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]);