This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32753 | 32753 | 1917-12-08 | 3 | a | A special meeting in Beijing on the national affairs and its discussion on some key issues. | China | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32754 | 32754 | 1917-12-08 | 3 | a | A meeting in Beijing of the Wartime International Affairs Committee. | China | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32755 | 32755 | 1917-12-08 | 3 | a-b | The military government in Guangzhou and its communications with Lu Rongting, Tang Jiyao, Sun Hongyi, Cao Kun, Liu Cunhou, Zhong Tidao, Chen Bingkun and other local government officials. | China | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32756 | 32756 | 1917-12-08 | 3 | b-c | Qi Yunji, chief prosecutor in Tianjin, is charged with bribery. | China | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32757 | 32757 | 1917-12-08 | 3 | c | Production and administration of fabric and silk industries in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32758 | 32758 | 1917-12-08 | 3 | d | An open letter from Shen Peizheng to Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32759 | 32759 | 1917-12-08 | 3 | d | American shipping authorities stop trade with foreign countries. | America | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32760 | 32760 | 1917-12-08 | 3 | d | Relations between Austrian prime minister and German chancellor. | Other... | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32761 | 32761 | 1917-12-08 | 3 | d | Chao in China (President Feng Guozhang is not able to organise a cabinet, armies in Zhejiang and Anhui provinces). | Britain | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 | |
32762 | 32762 | 1917-12-08 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095931 | 24095931 |
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]);