This data as json, CSV (advanced)
Suggested facets: source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39544 | 39544 | 1923-03-03 | 3 | a-b | Duan Qirui replies to Zhang Shaozeng for his inquiry on current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39545 | 39545 | 1923-03-03 | 3 | b | Negotiation between China and Britain over the return of Weihaiwei has broken down. | China | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39546 | 39546 | 1923-03-03 | 3 | b | Japan's response to the abrogation of the Twenty-one Demands by the Chinese parliament. | Japan | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39547 | 39547 | 1923-03-03 | 3 | b-c | Members of the Chinese parliament refuse to discuss the constitutional problem for local province. | China | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39548 | 39548 | 1923-03-03 | 3 | c | Naval officers from Britain, America, France and Japan meet and want to jointly protect the navigation in the Yangtze River. | America | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39549 | 39549 | 1923-03-03 | 3 | d | Sun Yatsen returns to Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39550 | 39550 | 1923-03-03 | 3 | d | Japanese people demands general and direct election. | Japan | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39551 | 39551 | 1923-03-03 | 3 | d | American government requests Chinese authority to investigate the murder of American tourist last year. | America | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 | |
| 39552 | 39552 | 1923-03-03 | 3 | d-e | Guangming Electronics Manufacturer Co Ltd raises funds by floating shares. Founders include Liang Chuang, Zhong Zhongshuo, Liang Zhongce, Hu Yaoting, Ye Tonggui, Ye Bingnan, Zeng Tingguang, Chen Lin, Zheng Fanchang, Lin Ziguang, Guo Chao, and many other Chinese businessmen in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094318 | 24094318 |
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]);