This data as json, CSV (advanced)
Suggested facets: column
date (date) 1 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39855 | 39855 | 1923-05-12 | 8 | a-d | Guangdong news/ Sun Yatsen moves his headquarters in Guangzhou. Sun Yatsen's headquarters detains an army commander. Shen Hongying's troops detain 13 military officers in Guangdong. Military situation in Xijiang River area. Sun Yatsen sells some agricultural experiment farm. Speaker of the provincial legislature assembly is against Sun Yatsen who is trying to borrow foreign loans. Protest against the kidnap of businessmen in Guangdong. Troops in Guangzhou commit robbery. Liu Zhenhuan's troops and their looting in Dongguan county. Dyke building in Songlong town, of Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094406 | 24094406 | |
39856 | 39856 | 1923-05-12 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094406 | 24094406 | |
39857 | 39857 | 1923-05-12 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094406 | 24094406 |
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]);