This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39575 | 39575 | 1923-03-10 | 3 | a-b | Lin Changmin comments on the case of Luo Wengan. | China | http://trove.nla.gov.au/newspaper/page/24094326 | 24094326 | |
| 39576 | 39576 | 1923-03-10 | 3 | b | Beijing students who are injured in their clash with parliamentarian will sue the house speaker Wu Jinglian and security head Tang Buying. | China | http://trove.nla.gov.au/newspaper/page/24094326 | 24094326 | |
| 39577 | 39577 | 1923-03-10 | 3 | b-c | Chinese Cabinet finds it difficult to resume sovereignty in Tibet and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24094326 | 24094326 | |
| 39578 | 39578 | 1923-03-10 | 3 | c | Liu Chengxun sends envoy to meet Li Yuanhong in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094326 | 24094326 | |
| 39579 | 39579 | 1923-03-10 | 3 | d | A telegram from Qin Chunxuan to Zhang Shaozeng. | China | http://trove.nla.gov.au/newspaper/page/24094326 | 24094326 | |
| 39580 | 39580 | 1923-03-10 | 3 | d | A notice by Cai Chang of The Sun company in Hong Kong to shareholders. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094326 | 24094326 | |
| 39581 | 39581 | 1923-03-10 | 3 | c-f | 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/24094326 | 24094326 |
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]);