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 |
|---|---|---|---|---|---|---|---|---|---|
| 45395 | 45395 | 1927-01-01 | 2 | c | Editorial by Tung Wah Times on the New Year and the war in China between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101832 | 24101832 | |
| 45396 | 45396 | 1927-01-01 | 2 | d | The abrogation of the treaty with Belgium and the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24101832 | 24101832 | |
| 45397 | 45397 | 1927-01-01 | 2 | e | A party in Tianjin attended by Zhang Zongchang, Zhang Xueliang, Wu Junsheng, Chu Yupu, Tang Yulin and others. | China | http://trove.nla.gov.au/newspaper/page/24101832 | 24101832 | |
| 45398 | 45398 | 1927-01-01 | 2 | f | Wu Peifu steps down and the reason. | China | http://trove.nla.gov.au/newspaper/page/24101832 | 24101832 | |
| 45399 | 45399 | 1927-01-01 | 3 | c | Sun Chuanfang arrives in Tianjin and the report. | China | http://trove.nla.gov.au/newspaper/page/24101831 | 24101831 | |
| 45400 | 45400 | 1927-01-01 | 5 | a-c | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101833 | 24101833 | |
| 45401 | 45401 | 1927-01-01 | 7 | a-c | Australia news/ Two big companies in Sydney merge. Profit of tomato growing. Attention to vegetable sellers. Holiday on the New Year's holiday. Furniture factory John Hoe in Sydney on fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101835 | 24101835 | |
| 45402 | 45402 | 1927-01-01 | 7 | c | Emperor of Japan dies. | Japan | http://trove.nla.gov.au/newspaper/page/24101835 | 24101835 | |
| 45403 | 45403 | 1927-01-01 | 7 | d | An open letter by the Chinese National Chamber of Commerce on the treaty with Belgium. | China | http://trove.nla.gov.au/newspaper/page/24101835 | 24101835 | |
| 45404 | 45404 | 1927-01-01 | 8 | a-d | Guangdong news/ Executive Committee of the Nationalist Government in Guangzhou elects new members. Economic conditions and the development of silk industry in Guangdong. Chinese Communists and the students returned from overseas. Chen Gongbo is returning to Guangdong. Tax collected for rice in Shixing county. Wang Jingwei opposes to move the capital to Wuchang. Huang Dawei is going south to Guangdong as suggested by Zhang Zuolin. The proposed move of the Nationalist capital and the business. Wang Jingwei is sick. Why the Nationalist government is eager to move north. | China | http://trove.nla.gov.au/newspaper/page/24101838 | 24101838 | |
| 45405 | 45405 | 1927-01-01 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101838 | 24101838 |
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]);