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 |
---|---|---|---|---|---|---|---|---|---|
50484 | 50484 | 1931-07-11 | 2 | b | Comments on the military situations in Nanjing and Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090445 | 24090445 | |
50496 | 50496 | 1931-07-11 | 5 | d | Wives of Chinese politicians and their influence upon the political struggle. A dancing girl in Japan insures her leg for 2 million dollars. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090446 | 24090446 | |
50497 | 50497 | 1931-07-11 | 5 | e | Notices issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090446 | 24090446 | |
50509 | 50509 | 1931-07-11 | 8 | d | Australia news/ Storm in Sydney and the damages. China purchases railway sleepers from Australia. Australia repays debts to Britain with gold. Snow in Broken Hill, NSW. The future of the Savings Bank of New South Wales unclear. Australia exports railway sleepers to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 |
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]);