This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45324 | 45324 | 1926-11-27 | 8 | a-d | Guangdong news/ Deng Yanda reports the take-over of Wuchang. Companies and firms are urged to register. Song Ziwen is busy raising funds. Concubine system banned in Foshan. Waters retreat in Guangdong rivers. Wu Tiecheng is released from prison. | China | http://trove.nla.gov.au/newspaper/page/24101798 | 24101798 | |
45323 | 45323 | 1926-11-27 | 7 | d | Japanese businessmen oppose to new tax in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101795 | 24101795 | |
45322 | 45322 | 1926-11-27 | 7 | c | The motives of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24101795 | 24101795 | |
45321 | 45321 | 1926-11-27 | 7 | a | Australia news/ Vegetable prices going up in Sydney. Motorbikes stolen in Sydney. Chinese man is imprisoned for selling wine illegally. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101795 | 24101795 | |
45320 | 45320 | 1926-11-27 | 5 | c | A communist meeting in Moscow. | Britain | http://trove.nla.gov.au/newspaper/page/24101793 | 24101793 | |
45319 | 45319 | 1926-11-27 | 3 | f | A letter from Sun Chuanfang to gentry in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24101791 | 24101791 | |
45318 | 45318 | 1926-11-27 | 3 | e | Wu Peifu will fight to the end. | China | http://trove.nla.gov.au/newspaper/page/24101791 | 24101791 | |
45317 | 45317 | 1926-11-27 | 3 | e | The treaty between China and Belgium expires. | China | http://trove.nla.gov.au/newspaper/page/24101791 | 24101791 | |
45316 | 45316 | 1926-11-27 | 3 | d | Sun Chuanfang condemns Xia Chao and his circular telegram. | China | http://trove.nla.gov.au/newspaper/page/24101791 | 24101791 | |
45315 | 45315 | 1926-11-27 | 3 | d | Rumours says Jiang Jieshi is injured. | China | http://trove.nla.gov.au/newspaper/page/24101791 | 24101791 | |
45314 | 45314 | 1926-11-27 | 3 | c-d | New Soviet Russian ambassador on his way to Beijing and his visit in Harbin, of Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24101791 | 24101791 | |
45313 | 45313 | 1926-11-27 | 2 | f | Russian harass the Chinese border in Xinjiang. | China | http://trove.nla.gov.au/newspaper/page/24101792 | 24101792 | |
45312 | 45312 | 1926-11-27 | 2 | f | A national association supports the Chinese national flag. | China | http://trove.nla.gov.au/newspaper/page/24101792 | 24101792 | |
45311 | 45311 | 1926-11-27 | 2 | e | Sun Chuanfang replies to Chinese ambassadors overseas. | China | http://trove.nla.gov.au/newspaper/page/24101792 | 24101792 | |
45310 | 45310 | 1926-11-27 | 2 | c-d | A military parade in Nanyuan, south of Beijing, on the National Day, October 10. | China | http://trove.nla.gov.au/newspaper/page/24101792 | 24101792 |
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]);