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 |
---|---|---|---|---|---|---|---|---|---|
52204 | 52204 | 1932-11-19 | 2 | c | Japanese planes shot down in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091024 | 24091024 | |
52205 | 52205 | 1932-11-19 | 2 | c | Chinese representative Yan Huiqing on the report prepared by the delegation of the League of Nations on the Chinese issues. | Other... | http://trove.nla.gov.au/newspaper/page/24091024 | 24091024 | |
52212 | 52212 | 1932-11-19 | 3 | c | The Wuhan government under Jiang Jieshi issues land regulations. | China | http://trove.nla.gov.au/newspaper/page/24091023 | 24091023 | |
52224 | 52224 | 1932-11-19 | 8 | c | Australia news/ A man in Sydney poisons his younger brother to death. Police in Sydney raid opium dens. Convicts in Sydney prison beat guards. Underground mint raided in Sydney. Budget report of the NSW state government. Memorial Day in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 |
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]);