This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48119 | 48119 | 1929-05-18 | 5 | a | Hong Kong news/ Guangdong provincial authority ban the entry of Hong Kong newspaper. Hong Kong authority investigates the disappearance of some money. Chen Mingshu is to be discharged from the hospital. Pilots from Yunnan province are testing flying in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099219 | 24099219 |
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]);