This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 33592 | 33592 | 1918-09-07 | 2 | c-d | A newspaper in Shanghai comments on the disputes between the north and the south in China. | China | http://trove.nla.gov.au/newspaper/page/24097420 | 24097420 | |
| 33593 | 33593 | 1918-09-07 | 2 | d-e | Qin Chunxuan arrives Guangdong and the report. | China | http://trove.nla.gov.au/newspaper/page/24097420 | 24097420 | |
| 33594 | 33594 | 1918-09-07 | 2 | e-f | A foreign government is trying to control north Manchuria and their effort. | China | http://trove.nla.gov.au/newspaper/page/24097420 | 24097420 | |
| 33595 | 33595 | 1918-09-07 | 2 | f | American Red Cross members comment on the Chinese people. | China | http://trove.nla.gov.au/newspaper/page/24097420 | 24097420 | |
| 33596 | 33596 | 1918-09-07 | 3 | a-b | People in Hengyang, Hunan province, issue a circular telegram for peace. | China | http://trove.nla.gov.au/newspaper/page/24097419 | 24097419 | |
| 33597 | 33597 | 1918-09-07 | 3 | b-c | China borrows more loans from Japan for the forest in Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24097419 | 24097419 | |
| 33598 | 33598 | 1918-09-07 | 3 | c-d | How much loans China has borrowed from Japan: a statistics. | China | http://trove.nla.gov.au/newspaper/page/24097419 | 24097419 | |
| 33599 | 33599 | 1918-09-07 | 3 | d-e | Qingdao under Japanese administration and its achievements. | China | http://trove.nla.gov.au/newspaper/page/24097419 | 24097419 | |
| 33603 | 33603 | 1918-09-07 | 6 | c | Number of foreigners in China and a survey on their business activities. | China | http://trove.nla.gov.au/newspaper/page/24097424 | 24097424 | |
| 33610 | 33610 | 1918-09-07 | 8 | b-c | Beijing news/ Chinese government in Beijing has a joint meeting for its participation in the World War I. The Alliance countries aid Siberia. Volunteer armies in Manchuria and their protection of railway operations. Duan Qirui seeks to attack Sichuan province. Chinese naval warship transport weapons to Fujian province. Commercial chambers in Ningbo, of Zhejiang province, demand repayment from the government authorities. Guangdong businessmen in Shanghai appeal for peace. Xiong Xiling offers assistance to solve the disputes between the south and the north. British businessman Ha Tong to translate Tibet Buddhist sutra. | China | http://trove.nla.gov.au/newspaper/page/24097426 | 24097426 | |
| 33611 | 33611 | 1918-09-07 | 8 | c-d | Guangdong news/ The central government in Beijing sends Ding Naiyang to meet Qin Chunxuan in Guangdong. Long Jiguang to mortgage his private property for loans. Long Jiguang's army have arrived Haikang. Police in Xiangshan county. Xiangshan county magistrate requests to send troops to Shiqi Town. The whereabouts of Tang Shaoyi. Qin Chunxuan and other government officials give dinner party to gentry and businessmen in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24097426 | 24097426 |
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]);