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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
45320 | 45320 | 1926-11-27 | 5 | c | A communist meeting in Moscow. | Britain | http://trove.nla.gov.au/newspaper/page/24101793 | 24101793 | |
45322 | 45322 | 1926-11-27 | 7 | c | The motives of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24101795 | 24101795 | |
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 | |
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 | |
45315 | 45315 | 1926-11-27 | 3 | d | Rumours says Jiang Jieshi is injured. | 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 | |
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 | |
45311 | 45311 | 1926-11-27 | 2 | e | Sun Chuanfang replies to Chinese ambassadors overseas. | China | http://trove.nla.gov.au/newspaper/page/24101792 | 24101792 | |
45317 | 45317 | 1926-11-27 | 3 | e | The treaty between China and Belgium expires. | 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 | |
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 | |
45313 | 45313 | 1926-11-27 | 2 | f | Russian harass the Chinese border in Xinjiang. | China | http://trove.nla.gov.au/newspaper/page/24101792 | 24101792 | |
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 |
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]);