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 |
|---|---|---|---|---|---|---|---|---|---|
| 45442 | 45442 | 1927-01-29 | 2 | c-d | Editorial on China's foreign policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101864 | 24101864 | |
| 45443 | 45443 | 1927-01-29 | 2 | d | Zhang Zuolin's army on the war south and the current situation in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24101864 | 24101864 | |
| 45444 | 45444 | 1927-01-29 | 2 | e-f | Civil administration in Yunnan province and the future. | China | http://trove.nla.gov.au/newspaper/page/24101864 | 24101864 | |
| 45445 | 45445 | 1927-01-29 | 5 | a-c | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101863 | 24101863 | |
| 45446 | 45446 | 1927-01-29 | 7 | a-b | Australia news/ A notice by the Chinese Consulate-General in Melbourne on the Chinese immigration to Fiji and the new regulations issued by Fijian authority. Workers' union federation in Australia opposes to any foreign interference with the Chinese affairs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101865 | 24101865 | |
| 45447 | 45447 | 1927-01-29 | 3 | d | Well-known figures in Tianjin on the communist disasters. | China | http://trove.nla.gov.au/newspaper/page/24101867 | 24101867 | |
| 45448 | 45448 | 1927-01-29 | 3 | e | Wu Peifu removes Jin Yunpeng suddenly. | China | http://trove.nla.gov.au/newspaper/page/24101867 | 24101867 | |
| 45449 | 45449 | 1927-01-29 | 3 | f | Chen Youren on China's diplomacy. | China | http://trove.nla.gov.au/newspaper/page/24101867 | 24101867 | |
| 45450 | 45450 | 1927-01-29 | 3 | f | Britain and the current situations in China. | China | http://trove.nla.gov.au/newspaper/page/24101867 | 24101867 | |
| 45451 | 45451 | 1927-01-29 | 3 | f | The international court in Shanghai to be returned to China. | China | http://trove.nla.gov.au/newspaper/page/24101867 | 24101867 | |
| 45452 | 45452 | 1927-01-29 | 8 | a-d | Guangdong news/ Survey on the Nationalist Party members and their professions. Jewellery stolen from The Sun company in Guangzhou. A gambling man kills his brother. Provincial government tries to reduce land tax and other levies. More taxes to be collected for the Northern Expedition. Search for nationalists. Workers in Guangzhou make trouble in the department store. | China | http://trove.nla.gov.au/newspaper/page/24101868 | 24101868 |
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]);