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 |
---|---|---|---|---|---|---|---|---|---|
50298 | 50298 | 1931-05-16 | 3 | e | Japanese naval fleet arrives Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24090380 | 24090380 | |
50299 | 50299 | 1931-05-16 | 3 | e | Chaos in Fujian province following the election. | China | http://trove.nla.gov.au/newspaper/page/24090380 | 24090380 | |
50311 | 50311 | 1931-05-16 | 8 | e | Notice issued by the Chinese Consulate-General in Australia on the help provided by the NSW state government to unemployed Chinese and advises them to register at the State Labour Exchange, Head Office at 132 George Street North. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 | |
50312 | 50312 | 1931-05-16 | 8 E | e | A meeting notice issued by the Young Chinese Association of Australia (li zhi hui). | 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]);