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