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 |
---|---|---|---|---|---|---|---|---|---|
51880 | 51880 | 1932-09-10 | 2 | c | Delegation of the League of Nations refuses to recognise the Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24090938 | 24090938 | |
51895 | 51895 | 1932-09-10 | 5 | c | A speech by Zhao Yu at the welcome ceremony organised by the Chinese communities in Sydney. Urgent notice issued by the Chinese Chamber of Commerce in NSW on the exports to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090939 | 24090939 | |
51901 | 51901 | 1932-09-10 | 8 | c | American government comments on Japan's recognition of the Manchurian state. | America | http://trove.nla.gov.au/newspaper/page/24090944 | 24090944 | |
51902 | 51902 | 1932-09-10 | 8 | c | Chinese volunteer armies in Manchuria and their fighting with Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24090944 | 24090944 |
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]);