This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50290 | 50290 | 1931-05-16 | 2 | c | New Chinese consul-general to the Philippines Kuang Guanglin amazes the world with his first feat. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090381 | 24090381 | |
50296 | 50296 | 1931-05-16 | 3 | c | Japanese troops in Manchuria and their atrocities. | China | http://trove.nla.gov.au/newspaper/page/24090380 | 24090380 | |
50310 | 50310 | 1931-05-16 | 8 | c | Australia news/ Philanthropists in Sydney help the unemployed and homeless people. Two swindlers arrested in Sydney. More earthquakes in New Zealand. Jeweller robbed in Sydney and the report. Butchers on strike in Melbourne. Policeman found not guilty in Sydney. The Savings Bank of New South Wales has more clients now. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 |
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]);