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 |
---|---|---|---|---|---|---|---|---|---|
28982 | 28982 | 1914-06-27 | 2 | b-d | Second part of the revised constitution of the Republic of China. | China | http://trove.nla.gov.au/newspaper/page/24093156 | 24093156 | |
28983 | 28983 | 1914-06-27 | 3 | a | Speech by the Chinese President Yuan Shikai to newly-appointed county magistrates. | China | http://trove.nla.gov.au/newspaper/page/24093155 | 24093155 | |
28984 | 28984 | 1914-06-27 | 3 | a-b | Chinese Premier Xu Shichang and his major policies. | China | http://trove.nla.gov.au/newspaper/page/24093155 | 24093155 | |
28991 | 28991 | 1914-06-27 | 3 | c | Chinese government appoints Su Qisi ambassador to Britain. | China | http://trove.nla.gov.au/newspaper/page/24093155 | 24093155 | |
28994 | 28994 | 1914-06-27 | 3 | c-d | Beijing news/ Yuan Shikai on the bandits. Representatives of the commercial chambers arrive Beijing on petition. Chinese government to reduce military budget. Vice President Li Yuanhong and his recent life. Central government in Beijing to start new financial policy. | China | http://trove.nla.gov.au/newspaper/page/24093155 | 24093155 | |
28995 | 28995 | 1914-06-27 | 6 | a-c | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093160 | 24093160 | |
28999 | 28999 | 1914-06-27 | 8 | a | Full copy of the regulation of the Political Consulting Commission (can zheng yuan) in Beijing | China | http://trove.nla.gov.au/newspaper/page/24093162 | 24093162 | |
29001 | 29001 | 1914-06-27 | 8 | b | Conspiracy of the bandits and revolutionary rebels in China. | China | http://trove.nla.gov.au/newspaper/page/24093162 | 24093162 | |
29002 | 29002 | 1914-06-27 | 8 | c-d | Guangdong news/ Preparation for the establishment of Confucian Society. The Bank of China in Guangzhou and the paper notes issued. Provincial authority approves French companies to recruit labourers in Guangdong. Curfew imposed in Guangzhou and why. Long Jiguang's mother and her birthday celebration. A unfilial son is struck to death by lightning. | China | http://trove.nla.gov.au/newspaper/page/24093162 | 24093162 |
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]);