This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40645 | 40645 | 1923-11-03 | 8 | a | Chinese communities in Australia donate to the Lingnan University, Guangzhou, and to the Chinese Nanhua (South China) Sports Association. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094606 | 24094606 | |
40646 | 40646 | 1923-11-03 | 8 | a-d | Guangdong news/ Ningyang railway company is ordered to re-elect general manager. Chen Tiandou writes to Sun Yatsen. Complaints on the looting of Xu Shurong's army. Army from the north might attack Guangdong again. Guangdong army on the way to back up Huizhou. War clouds in Wuzhou. Xu Chongzhi's army is besieged by civil corps. Ten thousand people are unemployed in Guangzhou. Sign of famine in Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094606 | 24094606 | |
40647 | 40647 | 1923-11-03 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094606 | 24094606 | |
40648 | 40648 | 1923-11-03 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094606 | 24094606 |
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]);