This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50012 | 50012 | 1931-02-21 | 3 | a | Chinese people boycott to Japanese fish. | China | http://trove.nla.gov.au/newspaper/page/24090281 | 24090281 | |
50013 | 50013 | 1931-02-21 | 3 | a | British historian predicts the Second World War. | Britain | http://trove.nla.gov.au/newspaper/page/24090281 | 24090281 | |
50018 | 50018 | 1931-02-21 | 5 | a | Hong Kong news/ Huang Shaoxiong in Hong Kong on his way to the north. Smuggling of opium and weapons in Hong Kong. Firms are leaving Macao for Hong Kong in order to avoid heavy taxes. The 48th seminar on Confucianism in the Confucian College, Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090283 | 24090283 | |
50023 | 50023 | 1931-02-21 | 8 | a | Unemployed people have demonstrations in America. | America | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 |
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]);