This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32154 | 32154 | 1917-03-17 | 6 | a-b | Guangzhou welcomes Xu Mian, the ceremony and the welcome speech written by Hu Shaonan. | China | http://trove.nla.gov.au/newspaper/page/24095629 | 24095629 | |
32155 | 32155 | 1917-03-17 | 6 | b-c | Beijing news/ President Li Yuanhong to personally award medal to Liang Qichao. Liang Qichao talks his personal comments on the current political situations. Debate in the parliament on the state religion in China. Foreign minister Wu Tingfang on the border demarcation with Mongolia, Macao and others. Census and the population of China. | China | http://trove.nla.gov.au/newspaper/page/24095629 | 24095629 | |
32156 | 32156 | 1917-03-17 | 6 | c | Guangdong news/ Zhu Qinglan on the celebration of unification of the south and the north in China. Shops in Guangzhou will be closed for the celebration parade for the unification of the south and the north. Wuhua county magistrate Lin Daren is appreciated for his justice. Zhang Mingqi in Guangdong. Further report on the welcome of Xu Mian. | China | http://trove.nla.gov.au/newspaper/page/24095629 | 24095629 |
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]);