This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40115 | 40115 | 1923-07-14 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 | |
40116 | 40116 | 1923-07-14 | 8 | a-b | Chinese communities in Australia donate to building of a hospital in Dongguan. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 | |
40117 | 40117 | 1923-07-14 | 8 | b-d | Guangdong news/ A charity hospital in closed in Guangzhou. Government troops can not protect local residents. Guangdong army takes over Chaozhou and Shantou. City wall to be demolished in Zhaoqing for the disaster relief. Li Liejun shoots dead a envoy from Hong Zhaolin. Shen Rongguang escapes to Wuzhou. Ammunition depot near Sun Yatsen's headquarters is destroyed. Li Fulin reports from Shantou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 | |
40118 | 40118 | 1923-07-14 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 | |
40119 | 40119 | 1923-07-14 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 |
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]);