This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40913 | 40913 | 1924-01-05 | 8 | a-d | Guangdong news/ Guangdong in the conflict of different military forces. Yuan Dai and his troops occupy Xiangshan county once again. Magistrate of Yunfu county pleas for emergency help. Guangdong army return to Yangjiang county. Huang Dawei dispatches troops to suppress pirates. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100564 | 24100564 | |
40914 | 40914 | 1924-01-05 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100564 | 24100564 | |
40915 | 40915 | 1924-01-05 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100564 | 24100564 |
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]);