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 |
---|---|---|---|---|---|---|---|---|---|
50670 | 50670 | 1931-09-05 | 2 | c | Circular telegram issued by Jiang Jieshi on the current situation. | China | http://trove.nla.gov.au/newspaper/page/24090511 | 24090511 | |
50671 | 50671 | 1931-09-05 | 2 | c | General inspector of the Chinese customs Mei Lehe urges Guangdong to pay their debts. | China | http://trove.nla.gov.au/newspaper/page/24090511 | 24090511 | |
50674 | 50674 | 1931-09-05 | 3 | c | A comparison of military expenses of different countries last year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090510 | 24090510 | |
50678 | 50678 | 1931-09-05 | 5 | c | Tigers in the Nanyang region. Nuns in Shanghai and their life. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090512 | 24090512 | |
50688 | 50688 | 1931-09-05 | 8 | c | The flooding Yangtze River area. | China | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50689 | 50689 | 1931-09-05 | 8 | c | Australia news/ Advertisement article for insect killer Cooper's Arsinate of Lead Powder. The Savings Bank of New South Wales to be reopened. Amalgamation of the Bank of New South Wales and the ABC Bank in Sydney. Opium smugglers are penalised in Sydney. Chinese vegetable peddlers in Sydney and the city administrator. Police in Sydney arrest thieves. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50691 | 50691 | 1931-09-05 | 8 | c | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 |
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]);