This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40346 | 40346 | 1923-09-01 | 8 | a-b | Chinese communities in Australia donate to the establishment of an agriculture school in the Lingnan University. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094534 | 24094534 | |
40347 | 40347 | 1923-09-01 | 8 | b-d | Guangdong news/ Provincial governor orders to protect Guangfu School buildings. Yang Ximin on the way to Dongjiang and the report. Army from the north arrive Dayu Mountain, border of Guangdong province. Guangxi army in Wuzhou. Temple properties are auctioned. Tan Qixiu and his troops are defeated. Li Hu reports that his troops have taken over Raoping, Huanggang and Pinghe. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094534 | 24094534 | |
40348 | 40348 | 1923-09-01 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094534 | 24094534 | |
40349 | 40349 | 1923-09-01 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094534 | 24094534 |
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]);