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 |
---|---|---|---|---|---|---|---|---|---|
51818 | 51818 | 1932-08-20 | 2 | e | More fighting in north Manchuria between Ma Zhanshan's troops and Japanese invaders. Song Ziwen and his financial policy. | China | http://trove.nla.gov.au/newspaper/page/24090912 | 24090912 | |
51819 | 51819 | 1932-08-20 | 2 | e | Delegation of the League of Nations leaves Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090912 | 24090912 | |
51824 | 51824 | 1932-08-20 | 3 | e | Chinese navy requests to punish Gao Youtang. | China | http://trove.nla.gov.au/newspaper/page/24090911 | 24090911 | |
51837 | 51837 | 1932-08-20 | 8 | e | Australia news/ Investigation on the fake bank notes in Sydney. Chinese businessmen in Sydney boycott to Japanese goods. Federal government to appoint trade commissioner to the Far East. Chinese man is charged with cocaine. Exhibition of Australian products to be held in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090920 | 24090920 |
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]);