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 |
---|---|---|---|---|---|---|---|---|---|
51632 | 51632 | 1932-06-25 | 2 | c | Report prepared by delegation of the League of Nations on Japanese invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
51639 | 51639 | 1932-06-25 | 5 | c | Chinese communities in Sydney and Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090850 | 24090850 | |
51645 | 51645 | 1932-06-25 | 8 | c | Another coup in Chile. | Other... | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
51646 | 51646 | 1932-06-25 | 8 | c | Spanish government confiscates properties owned by former emperor. | Britain | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
51647 | 51647 | 1932-06-25 | 8 | c | Japanese instruct the Manchurian state to collect tariff. | China | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
51648 | 51648 | 1932-06-25 | 8 | c | Australia news/ Statistics of international trade of the NSW. An old Chinese disappear in Queensland. New South Wales has a new cabinet. Letter from the Bank of China to the Chinese Progressive Association in Sydney. Australian federal government on the defence. Drunken driver is penalised in Sydney. Snowing in Sydney suburbs. New premier of NSW state on administration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 |
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]);