This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42386 | 42386 | 1924-11-29 | 8 | a-d | Guangdong news/ Sun Yatsen starts the first step for his communist plan. Division commander of Yunnan army Liao Chaoxing entertains gentry in Guangzhou. Sun Yatsen's troops sell stolen goods in Wuzhou. Foreign missions in Guangzhou warn Sun Yatsen. Hairdresser sets fire in Guangzhou. A case of murder in Guangzhou. The magistrate of Xiangshan county and his performance. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100953 | 24100953 | |
42387 | 42387 | 1924-11-29 | 8 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100953 | 24100953 | |
42388 | 42388 | 1924-11-29 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100953 | 24100953 |
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]);