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 |
---|---|---|---|---|---|---|---|---|---|
50536 | 50536 | 1931-07-25 | 3 | a | Japanese people in Shandong province organise an association. | China | http://trove.nla.gov.au/newspaper/page/24090460 | 24090460 | |
50537 | 50537 | 1931-07-25 | 3 | a | Japanese and the railway management in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090460 | 24090460 | |
50542 | 50542 | 1931-07-25 | 5 | a | Hong Kong news/ Guangdong confronts the Nanjing government and their preparation. Zhongshan businessmen in Hong Kong protest against the land bureau director in their home town for land disputes. Street beggars to be collected. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 |
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]);