This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39132 | 39132 | 1922-12-16 | 2 | a-b | Editorial on the fighting in the Chinese parliament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094220 | 24094220 | |
39149 | 39149 | 1922-12-16 | 6 | a | Tung Wah Times on the war clouds between Zhang Zuolin and Wu Peifu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094224 | 24094224 | |
39152 | 39152 | 1922-12-16 | 7 | a | Election of Sydney mayor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094223 | 24094223 | |
39153 | 39153 | 1922-12-16 | 7 | a | Murder suspect is released in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094223 | 24094223 | |
39155 | 39155 | 1922-12-16 | 7 | a | Japanese purchase land property in Sydney and the investigation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094223 | 24094223 | |
39158 | 39158 | 1922-12-16 | 7 | c | News in brief/ Bandits suppressed in Henan province. Sun Yatsen's envoy Dai Tianchou commits suicide on his way to Sichuan. Wu Peifu writes to Li Yuanhong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094223 | 24094223 | |
39159 | 39159 | 1922-12-16 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094223 | 24094223 | |
39160 | 39160 | 1922-12-16 | 8 | a-c | Guangdong news/ Guangzhou municipal government wants to borrow foreign loans and the conditions. Newspaper publishing in Guangzhou. Bank notes and the trouble. Long Qingyu is captured in Beihai. Trial on the foreigner who in involved in the bomb blast. Memorial service on the death of Wu Tingfang. A man in Guangzhou leaves his wife as a pledge. Bandit Xu Shurong is shot dead in Panyu county. Strange noise in Xinhui county. Dispute over the infrastructure building in Songlong town, of Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094226 | 24094226 | |
39161 | 39161 | 1922-12-16 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094226 | 24094226 | |
39162 | 39162 | 1922-12-16 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094226 | 24094226 |
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]);