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 |
---|---|---|---|---|---|---|---|---|---|
37018 | 37018 | 1921-05-28 | 2 | c-d | Opposition to the Guangdong Presidential election from Hunan (commercial, educational and agricultural associations). | China | http://trove.nla.gov.au/newspaper/page/24093557 | 24093557 | |
37019 | 37019 | 1921-05-28 | 2 | d | Zhang Qian and 14 others oppose to the appointment of Wang Shizhen. | China | http://trove.nla.gov.au/newspaper/page/24093557 | 24093557 | |
37021 | 37021 | 1921-05-28 | 3 | a-b | How Sun Yatsen is elected President this time and the aftermath. | China | http://trove.nla.gov.au/newspaper/page/24093556 | 24093556 | |
37022 | 37022 | 1921-05-28 | 3 | b | Response of the central and local governments to the election of President Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24093556 | 24093556 | |
37033 | 37033 | 1921-05-28 | 6 | b | Ma Yushan and Zhang Jizhi (Qian) to set up five factories in Shanghai (biscuits, sweets, glass and sugar). | China | http://trove.nla.gov.au/newspaper/page/24093561 | 24093561 | |
37041 | 37041 | 1921-05-28 | 7 | b | News in brief/ Cao Kun, Zhang Zuolin, Wang Zhanyuan and 30 others stand against Sun Yatsen in the south. Navy commander Lan Jianshu meets Cao Kun and Zhang Zuolin in Tianjin for the joint action to Sun Yatsen. Shanghai police authority detains all communists and radicals. | China | http://trove.nla.gov.au/newspaper/page/24093560 | 24093560 |
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]);