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 |
|---|---|---|---|---|---|---|---|---|---|
| 45299 | 45299 | 1926-11-20 | 2 | c-d | Editorial on the abrogation of the treaty between China and Belgium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101784 | 24101784 | |
| 45300 | 45300 | 1926-11-20 | 2 | d | The first cabinet meeting in Beijing under Premier Gu Weijun. | China | http://trove.nla.gov.au/newspaper/page/24101784 | 24101784 | |
| 45301 | 45301 | 1926-11-20 | 2 | e | Zhang Zuolin on the new central government in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101784 | 24101784 | |
| 45302 | 45302 | 1926-11-20 | 2 | e | Thirteen Chinese ambassadors in different countries on the solution to the current Chinese situations. | China | http://trove.nla.gov.au/newspaper/page/24101784 | 24101784 | |
| 45303 | 45303 | 1926-11-20 | 2 | f | The Anfu Club fights for the restoration of Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24101784 | 24101784 | |
| 45304 | 45304 | 1926-11-20 | 3 | d | Poems by Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24101783 | 24101783 | |
| 45305 | 45305 | 1926-11-20 | 3 | e | Wu Peifu in Zhengzhou and his dilemma. | China | http://trove.nla.gov.au/newspaper/page/24101783 | 24101783 | |
| 45306 | 45306 | 1926-11-20 | 5 | a-c | Miscellaneous report on the conflict in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24101785 | 24101785 | |
| 45307 | 45307 | 1926-11-20 | 7 | a | Australia news/ A meeting notice by the Chinese Chamber of Commerce in Sydney. A copy of the revised Factory Act issued by the New South Wales government that includes requirements for "Chinese Labour" or "European Labour Only". | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101787 | 24101787 | |
| 45308 | 45308 | 1926-11-20 | 7 | c | Foreign powers may interfere with the Chinese affairs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101787 | 24101787 | |
| 45309 | 45309 | 1926-11-20 | 8 | a-d | Guangdong news/ Guangzhou government to deal with the strikers. Government officials donate to thank the Northern Expedition troops. Taxes doubled for wines from other provinces. Shamian after the resumption of transportation. Troops in Zhongshan county force local villagers to pay for road construction. Commercial chambers in Dongguan county request to stop labour riots. Businessmen in Foshan fight against the business licence levy. | China | http://trove.nla.gov.au/newspaper/page/24101790 | 24101790 |
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]);