This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40590 | 40590 | 1923-10-27 | 2 | a-b | Editorial by the Tung Wah Times on Li Yuanhong in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094592 | 24094592 | |
| 40591 | 40591 | 1923-10-27 | 2 | b-d | Third and final part of a report on the establishment of National Education Promotion Association of China (zhong hua ping min jiao yu zong hui), its mission, regulation and organisation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094592 | 24094592 | |
| 40599 | 40599 | 1923-10-27 | 6 | a | Tung Wah Times comments on the collaboration and conflict in China between Zhang Zuolin, Duan Qirui, Cao Kun and Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094596 | 24094596 | |
| 40601 | 40601 | 1923-10-27 | 6 | c-e | Third part of the report on the reclamation and agricultural development in Zhangjiakou area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094596 | 24094596 | |
| 40602 | 40602 | 1923-10-27 | 7 | a | A notice issued by the Chinese consulate general in Melbourne on the election of Cao Kun as new Chinese president, inaugural ceremony and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094595 | 24094595 | |
| 40603 | 40603 | 1923-10-27 | 7 | a | Chinese football team has a match in Tasmania. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094595 | 24094595 | |
| 40604 | 40604 | 1923-10-27 | 7 | a | Two trams collide in Sydney that causes a fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094595 | 24094595 | |
| 40606 | 40606 | 1923-10-27 | 7 | a | Chinese gamblers are detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094595 | 24094595 | |
| 40607 | 40607 | 1923-10-27 | 7 | b | White gamblers are detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094595 | 24094595 | |
| 40608 | 40608 | 1923-10-27 | 7 | b | Four Chinese men and two white women are arrested for opium smoking. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094595 | 24094595 | |
| 40612 | 40612 | 1923-10-27 | 8 | a-d | Guangdong news/ Sun Yatsen is recommended as presidential candidate. Nanxiong county under different armies. Sun Yatsen's headquarters has a special meeting. Hotels and restaurants in Guangzhou are closed in protest against the new banquet tax. Protest in Guangzhou against the business registration fee. Pressgang in Guangzhou and the report. Cheng Tiandou buys his life at a high price. Police authority in Guangzhou bans communist propaganda. Sun Yatsen narrowly escapes an assassination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094598 | 24094598 | |
| 40613 | 40613 | 1923-10-27 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094598 | 24094598 | |
| 40614 | 40614 | 1923-10-27 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094598 | 24094598 |
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]);