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 |
|---|---|---|---|---|---|---|---|---|---|
| 45254 | 45254 | 1926-10-30 | 2 | c-d | Germany joins the League of Nations and comments by Tung Wah Times on the future of the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101760 | 24101760 | |
| 45255 | 45255 | 1926-10-30 | 2 | d-f | Telegram from Sun Chuanfang to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24101760 | 24101760 | |
| 45256 | 45256 | 1926-10-30 | 2 | f | A letter from Nanjing to Jiang Jieshi advises him to lay down his knife. | China | http://trove.nla.gov.au/newspaper/page/24101760 | 24101760 | |
| 45257 | 45257 | 1926-10-30 | 3 | c | Wu Peifu is still in Zhengzhou, of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24101759 | 24101759 | |
| 45258 | 45258 | 1926-10-30 | 3 | d | Fighting in Hankou between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24101759 | 24101759 | |
| 45259 | 45259 | 1926-10-30 | 3 | d | Ji Yuanlin reports the fierce battle in Xinyang, of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24101759 | 24101759 | |
| 45260 | 45260 | 1926-10-30 | 3 | e | Sun Chuanfang's troops take over Nanchang, of Jiangxi province. Chaos in Shaanxi province. Military news from the border of Jiangxi and Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101759 | 24101759 | |
| 45261 | 45261 | 1926-10-30 | 3 | f | The world chemistry conference in Philadelphia. | America | http://trove.nla.gov.au/newspaper/page/24101759 | 24101759 | |
| 45262 | 45262 | 1926-10-30 | 5 | a-c | Miscellaneous report on the Chinese situation. | China | http://trove.nla.gov.au/newspaper/page/24101761 | 24101761 | |
| 45263 | 45263 | 1926-10-30 | 5 | c | Storm in Havana and the damages. | Canada | http://trove.nla.gov.au/newspaper/page/24101761 | 24101761 | |
| 45264 | 45264 | 1926-10-30 | 7 | a | Australia news/ Chinese fellows are advised to keep their house clean. Land price going up in Sydney. Smuggled opium seized on a coal ship. The World Thrift Day. Chinese Ah Foo is advised to withdraw his money from a Melbourne bank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101763 | 24101763 | |
| 45265 | 45265 | 1926-10-30 | 7 | b | Epidemic in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24101763 | 24101763 | |
| 45266 | 45266 | 1926-10-30 | 7 | b | Yang Sen and Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24101763 | 24101763 | |
| 45267 | 45267 | 1926-10-30 | 7 | b | Stories of Zhang Qian (Jizhi) and his death. | China | http://trove.nla.gov.au/newspaper/page/24101763 | 24101763 | |
| 45268 | 45268 | 1926-10-30 | 8 | a-d | Guangdong news/ Comments selected from Sydney newspaper on the Chinese affairs. The central bank in Guangzhou issues new bank notes. Li Jishen expands his troops. Bandits hijack trains in Guangdong. Huangpu students are called to fight in Hunan province. High alert in Xiangshan county. Transportation resumed between Guangzhou and Hong Kong. Another ferry hijack in Xiangshan county. Bridge opened in Shamian of Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101766 | 24101766 | |
| 45269 | 45269 | 1926-10-30 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101766 | 24101766 |
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]);