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 |
|---|---|---|---|---|---|---|---|---|---|
| 36159 | 36159 | 1920-10-02 | 2 | a-c | An article written by Miu Huili, of Tingha, New South Wales, on the exploitation of mineral resources. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098329 | 24098329 | |
| 36160 | 36160 | 1920-10-02 | 2 | b | Cao Kun, Zhang Zuolin and their peace proposals. | China | http://trove.nla.gov.au/newspaper/page/24098329 | 24098329 | |
| 36161 | 36161 | 1920-10-02 | 2 | c | The new parliament in China and the peace effort. | China | http://trove.nla.gov.au/newspaper/page/24098329 | 24098329 | |
| 36162 | 36162 | 1920-10-02 | 2 | d | Chinese in miao jie suffer under Japanese administration. | Other... | http://trove.nla.gov.au/newspaper/page/24098329 | 24098329 | |
| 36163 | 36163 | 1920-10-02 | 2 | d | Foreign government interfere with the railway construction from Beijing to Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24098329 | 24098329 | |
| 36164 | 36164 | 1920-10-02 | 2 | e | Yan Xishan in the political turmoil. | China | http://trove.nla.gov.au/newspaper/page/24098329 | 24098329 | |
| 36165 | 36165 | 1920-10-02 | 2 | e | Li Liejun arrives Chongqing, of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24098329 | 24098329 | |
| 36166 | 36166 | 1920-10-02 | 3 | a | A reply from Tang Jiyao to Sa Zhenbing. | China | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36167 | 36167 | 1920-10-02 | 3 | b-c | Agriculture, education and forestry in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36168 | 36168 | 1920-10-02 | 3 | c | A circular telegram issued by Chen Jiongming. | China | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36169 | 36169 | 1920-10-02 | 3 | c | Charity institutions in Guangzhou help the famine disaster in north China. | China | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36170 | 36170 | 1920-10-02 | 3 | d | Riots in Taiwan. | America | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36171 | 36171 | 1920-10-02 | 3 | d | Japanese cabinet on the discrimination against Japanese immigrants in California. | America | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36172 | 36172 | 1920-10-02 | 3 | d | Changes of the diplomatic relations between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36173 | 36173 | 1920-10-02 | 3 | e | Japan has not withdrawn troops from the Siberian railway. | America | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36174 | 36174 | 1920-10-02 | 3 | e | Independence movement in Korea. | America | http://trove.nla.gov.au/newspaper/page/24098328 | 24098328 | |
| 36175 | 36175 | 1920-10-02 | 6 | a-b | A notice by Wei Zijing, Chinese Consul-General in Australia, calls for donations to the famine victims in north China. Names listed for the donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098333 | 24098333 | |
| 36176 | 36176 | 1920-10-02 | 6 | b-c | A debate in Hong Kong for women's hair style. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098333 | 24098333 | |
| 36177 | 36177 | 1920-10-02 | 7 | a | A notice by Yang Fu on the legal case against the Republic News (min guo bao) for the defamation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098332 | 24098332 | |
| 36178 | 36178 | 1920-10-02 | 7 | a-b | Former Chinese Consul to Samoa Lin Runzhao (Baoheng) sues the Republic News (min guo bao) in Sydney for defamation and report on the case. The Chinese Chamber of Commerce in Sydney calls for donations to the famine victims in north China. Fundraising fete organised by the Chinese Chamber of Commerce for the famine victims in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098332 | 24098332 | |
| 36179 | 36179 | 1920-10-02 | 8 | a-b | Chinese Chamber of Commerce in Sydney calls for donations to the famine victims in north China and the names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098335 | 24098335 | |
| 36180 | 36180 | 1920-10-02 | 8 | b-c | Guangdong news/ Military government on the peace talks. Revolutionaries are executed for recruiting bandits in the Beijiang area. Students in Meixian county destroy low-quality commodities. Gambling in Guangzhou and the casualties. Afforestation in Enping county. | China | http://trove.nla.gov.au/newspaper/page/24098335 | 24098335 |
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]);