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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
45313 | 45313 | 1926-11-27 | 2 | f | Russian harass the Chinese border in Xinjiang. | China | http://trove.nla.gov.au/newspaper/page/24101792 | 24101792 | |
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 | |
45311 | 45311 | 1926-11-27 | 2 | e | Sun Chuanfang replies to Chinese ambassadors overseas. | China | http://trove.nla.gov.au/newspaper/page/24101792 | 24101792 | |
45322 | 45322 | 1926-11-27 | 7 | c | The motives of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24101795 | 24101795 | |
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 |
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]);