This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39078 | 39078 | 1922-12-02 | 2 | b-c | Portuguese soldiers in Macao kill Chinese resident and the negotiation between Chinese ministry of foreign affairs in Beijing and the Portuguese authority in Macao. | China | http://trove.nla.gov.au/newspaper/page/24094204 | 24094204 | |
39093 | 39093 | 1922-12-02 | 6 | b-c | News in brief/ New cabinet in Beijing. Chen Jiongming's envoy meets Li Yuanhong. Sun Yatsen to send Chiang Kaishek to help Xu Chongzhi in Fujian. Fujian representatives meet Li Yuanhong. Wu Peifu supports Wang Chonghui and his cabinet. Sa Zhenbing to incorporate civil corps in Fujian. Withdrawal of French postal service from China. Wang Chonghui remains the state premier. | Other... | http://trove.nla.gov.au/newspaper/page/24094208 | 24094208 | |
39100 | 39100 | 1922-12-02 | 7 | b-c | Bandit suppressed in Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094207 | 24094207 |
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]);