This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50923 | 50923 | 1931-12-05 | 2 | e | Li Shizeng talks about military and administrative divisions in China again. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50924 | 50924 | 1931-12-05 | 2 | e | Yan Xishan requests civil administration. Talks by Hu Hanmin. Zhang Xueliang is optimistic over the Chinese affairs. Loss of railways in Manchuria. Japanese troops in Shenyang set fire on radio station. Du Xuantai is arrested. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50944 | 50944 | 1931-12-05 | 8 | e | Chinese communities in Perth donate to the flooding victims in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090627 | 24090627 | |
50945 | 50945 | 1931-12-05 | 8 | e | Profit report of the Savings Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090627 | 24090627 |
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]);