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 |
---|---|---|---|---|---|---|---|---|---|
51864 | 51864 | 1932-09-03 | 3 | c | Japanese invasion of Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24090929 | 24090929 | |
51867 | 51867 | 1932-09-03 | 5 | c | A notice issued by the Chinese Chamber of Commerce in New South Wales on the exports to China. Regulations issued by the Chinese government on the exports to China (by overseas Chinese businessmen). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090932 | 24090932 | |
51872 | 51872 | 1932-09-03 | 8 | c | Deterioration of relations between Japan and America. | Japan | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
51873 | 51873 | 1932-09-03 | 8 | c | Prince of Japan helps the flooding relief in north Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
51874 | 51874 | 1932-09-03 | 8 | c | Report prepared by the delegation of the League of Nations on the Chinese situation. | China | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 |
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]);