This data as json, CSV (advanced)
Suggested facets: page, date (date)
page_url 4 ✖
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40033 | 40033 | 1923-06-30 | 2 | a-b | Editorial on the hijack of train in Shandong province and its influence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094456 | 24094456 | |
| 40034 | 40034 | 1923-06-30 | 2 | b-c | A copy of the Twenty-one Demands signed between China and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094456 | 24094456 | |
| 40045 | 40045 | 1923-06-30 | 6 | a-b | A public notice issued by the Chinese Chamber of Commerce in New South Wales on the sales of public properties in Guangzhou and China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094460 | 24094460 | |
| 40052 | 40052 | 1923-06-30 | 7 | a | Four white women found in a Sydney Chinese opium den. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094459 | 24094459 | |
| 40057 | 40057 | 1923-06-30 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094462 | 24094462 | |
| 40058 | 40058 | 1923-06-30 | 8 | a-d | Guangdong news/ Liao Zhongkai becomes governor of Guangdong province and the inaugural ceremony. Sale of public properties in Guangzhou. Guangdong authority borrows foreign loans. Some Hong Kong businessmen cease to be adviser of the provincial government. Some public properties are to be auctioned. Municipal government in Guangzhou sells public properties. Guangdong military officers oppose to sale of public properties. Temples are also on the list for sale. Refugees from Zhaoqing. Demonstration in Zengcheng. Sun Ke punishes legislature assembly member Zhong Xifen. Guangdong army has arrived Shilong, of Boluo county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094462 | 24094462 | |
| 40059 | 40059 | 1923-06-30 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094462 | 24094462 | |
| 40060 | 40060 | 1923-06-30 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094462 | 24094462 |
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]);