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 |
|---|---|---|---|---|---|---|---|---|---|
| 47557 | 47557 | 1928-11-10 | 2 | b | Sun Ke is returning to China after a visit to America. Wuhan authority inspects Japanese news report. American company is keen to developing aviation industry. Jiang Jieshi persuades the leftist faction with money offer. Progress of Chinese tariff autonomy. | China | http://trove.nla.gov.au/newspaper/page/24099010 | 24099010 | |
| 47558 | 47558 | 1928-11-10 | 2 | c | British inspector general of the Chinese Maritime Customs Bureau may continue to work in China for a while. | China | http://trove.nla.gov.au/newspaper/page/24099010 | 24099010 | |
| 47559 | 47559 | 1928-11-10 | 2 | d | New rates of some imports after the tariff autonomy in China. | China | http://trove.nla.gov.au/newspaper/page/24099010 | 24099010 | |
| 47560 | 47560 | 1928-11-10 | 2 | d | Feng Yuxiang seeks for friendship from Japanese. | China | http://trove.nla.gov.au/newspaper/page/24099010 | 24099010 | |
| 47561 | 47561 | 1928-11-10 | 2 | e | The leftist faction within the Nationalist Party and their plan for counterattack. | China | http://trove.nla.gov.au/newspaper/page/24099010 | 24099010 | |
| 47562 | 47562 | 1928-11-10 | 2 | e | Hu Hanmin, Dai Jitao, Wang Chonghui and Sun Ke are busy with the organisation of new government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099010 | 24099010 | |
| 47563 | 47563 | 1928-11-10 | 2 | f | Deposed government officials are arriving in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099010 | 24099010 | |
| 47564 | 47564 | 1928-11-10 | 2 | f | Zhang Qun may be the chief-supervisor for Chinese ammunitions industry. | China | http://trove.nla.gov.au/newspaper/page/24099010 | 24099010 | |
| 47565 | 47565 | 1928-11-10 | 3 | b | Chaos in Mongolia subsidises. | China | http://trove.nla.gov.au/newspaper/page/24099009 | 24099009 | |
| 47566 | 47566 | 1928-11-10 | 3 | c | Defence in Mongolia and Tibet are a major concern to the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24099009 | 24099009 | |
| 47567 | 47567 | 1928-11-10 | 3 | d | A circular telegram issued by Zhang Xueliang on the future of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099009 | 24099009 | |
| 47568 | 47568 | 1928-11-10 | 3 | d | Fire in Hankou destroys many shops. | China | http://trove.nla.gov.au/newspaper/page/24099009 | 24099009 | |
| 47569 | 47569 | 1928-11-10 | 3 | e | Henan provincial government set up special office to promote natural feet for women. | China | http://trove.nla.gov.au/newspaper/page/24099009 | 24099009 | |
| 47570 | 47570 | 1928-11-10 | 3 | f | Bai Chongxi's army are going south. | China | http://trove.nla.gov.au/newspaper/page/24099009 | 24099009 | |
| 47571 | 47571 | 1928-11-10 | 5 | a | Guangdong news/ Education authority issued an order on the worship to Confucius in schools. Another major search and arrest in Guangzhou. Servicemen search residential houses in Guangzhou for the Communists. | China | http://trove.nla.gov.au/newspaper/page/24099011 | 24099011 | |
| 47572 | 47572 | 1928-11-10 | 6 | a | Advertisement for the Australian Roma Oil company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099014 | 24099014 | |
| 47573 | 47573 | 1928-11-10 | 8 | a | Pirates hijack ships in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24099016 | 24099016 | |
| 47574 | 47574 | 1928-11-10 | 8 | a | China and Japan start talks over the treaty. | China | http://trove.nla.gov.au/newspaper/page/24099016 | 24099016 | |
| 47575 | 47575 | 1928-11-10 | 8 | a | Presidential election in America and the betting. | America | http://trove.nla.gov.au/newspaper/page/24099016 | 24099016 | |
| 47576 | 47576 | 1928-11-10 | 8 | a | Internal trouble in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24099016 | 24099016 | |
| 47577 | 47577 | 1928-11-10 | 8 | b | Australia news/ Clash between strikers and police in Melbourne. Prisoner escapes but recaptured again. A case of manslaughter claims three lives in New South Wales. Japanese passenger liner is stranded on its way from Sydney to Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099016 | 24099016 |
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]);