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 |
---|---|---|---|---|---|---|---|---|---|
49869 | 49869 | 1931-01-10 | 3 | c | Zhang Zongchang to return to China. | China | http://trove.nla.gov.au/newspaper/page/24090231 | 24090231 | |
49876 | 49876 | 1931-01-10 | 5 | c | Different types of prostitutes in Korea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090233 | 24090233 | |
49886 | 49886 | 1931-01-10 | 8 | c | Hong Kong police cruisers arrest pirates. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090238 | 24090238 | |
49887 | 49887 | 1931-01-10 | 8 | c | Australia news/ Labour government of NSW decides to resume 44 hours' working per week. NSW state to collect personal income tax. Time limit for application for Family Endowment Payment. Thieves arrested in Sydney. Railway operation in Queensland. A man in Sydney shoots dead two policemen because of his epilepsy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090238 | 24090238 |
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]);