This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31607 | 31607 | 1916-09-30 | 2 | a-b | Editorial on Lu Rongting's governance in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095422 | 24095422 | |
31613 | 31613 | 1916-09-30 | 6 | a-b | Zhang Xun's circular telegram on the national parliament and his interference. | China | http://trove.nla.gov.au/newspaper/page/24095426 | 24095426 | |
31615 | 31615 | 1916-09-30 | 7 | a-b | Australia news/ Memorial service on the birthday of Confucius organised by the Chinese community in Sydney, and speakers include Zheng Fanchang, Wu Elou, Peng Yuwen, Guo Jiexiu, Guo Shun, Chen Jinghan, Police raid headquarters of Labour Party in Sydney. Heavy rain in Melbourne and the tragedy. A Chinese man in Sydney hangs himself. Prime Minister talks about the War in Sydney and the coming federal election. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095425 | 24095425 | |
31618 | 31618 | 1916-09-30 | 8 | a-b | Beijing news/ President Li Yuanhong and his new politics. Chinese army in Mongolia. Army and civil politics in Yunnan province. Kang Youwei speaks in Hangzhou. Kang Youwei leaves Hangzhou. Sun Yatsen and Hu Hanmin arrive Hangzhou. Soldiers from the north are released in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24095427 | 24095427 |
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]);