This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50698 | 50698 | 1931-09-12 | 5 | a | Hong Kong news/ Police chief from Zhongshan county is attacked in Macao. The Tung Wah Hospital in Hong Kong donates to relief work in the flooding areas of Guangdong. Sun Yatsen's first wife comes to meet Sun Ke in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090520 | 24090520 |
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]);