This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32406 | 32406 | 1917-06-23 | 6 | a-b | Beijing news/ Members of the parliament meet Premier Duan Qirui. Earthquake in the south of Tianjin. The process of China's involvement in the World War. Chen Jintao and his destiny. Debate on the status of Confucianism. Chinese President Li Yuanhong entertains foreign missions in Beijing. Secret societies in China. | China | http://trove.nla.gov.au/newspaper/page/24095741 | 24095741 | |
32407 | 32407 | 1917-06-23 | 6 | b-c | Guangdong news/ Amount of soldiers' pay and provisions owed by the Guangdong government. Bandits and their fighting in Shunde county. A girl school in Guangzhou organises a meeting on national dignity and the protest from a foreign consul. A gambling son kills his father in Guangzhou. Severe punishment applies to opium addicts. A man in Qingyuan county avenges bandits for his wife. Bandits in Gaoyao county and the kidnap. Carrot and the eradication | China | http://trove.nla.gov.au/newspaper/page/24095741 | 24095741 |
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]);