This data as json, CSV (advanced)
Suggested facets: source, 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 | |
50699 | 50699 | 1931-09-12 | 5 | d | Story of Scholar He. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090520 | 24090520 | |
50700 | 50700 | 1931-09-12 | 5 | e | Notices issued by the Chinese Consulate-General in Australia | Tung Wah | 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]);