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 |
---|---|---|---|---|---|---|---|---|---|
50801 | 50801 | 1931-10-17 | 3 | e | Feng Yuxiang in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24090558 | 24090558 | |
50808 | 50808 | 1931-10-17 | 5 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. And another by this chamber of commerce on the amount of total donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090560 | 24090560 | |
50825 | 50825 | 1931-10-17 | 8 | e | Japanese soldiers in Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24090565 | 24090565 | |
50826 | 50826 | 1931-10-17 | 8 | e | Australia news/ Australian horse going for racing in Hong Kong. Underground mint smashed in NSW. Gibbs & Bright has new wharf in Sydney harbour. Australian companies to set up wool factory in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090565 | 24090565 |
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]);