This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25628 | 25628 | 1912-01-20 | 8 | a-b | Government organisation outline of the Republic of China | A temporary government organisation outline before the constitution is to be practised for the new republic. | China | http://trove.nla.gov.au/newspaper/page/24092081 | 24092081 |
25629 | 25629 | 1912-01-20 | 8 | b | Hankou after fire | The fire set by the government troops resulted in huge casualties in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24092081 | 24092081 |
25630 | 25630 | 1912-01-20 | 8 | b | Records of Guangdong north expedition troops | Xun Changqing is elected as the general commander of north expedition troop in Zhaocheng, Guangdong. People in Zhaocheng compete to donate for north expedition. Li Yue leads the second north expedition troop of Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24092081 | 24092081 |
25631 | 25631 | 1912-01-20 | 8 | c-d | Robberies occur often in Guangdong after revolution | Gun robberies after revolution occurred in many places in Guangdong, leading to great panic of people. | China | http://trove.nla.gov.au/newspaper/page/24092081 | 24092081 |
25632 | 25632 | 1912-01-20 | 8 | c-d | Poetry | Some poems of Wang Jingwei's. | Other... | http://trove.nla.gov.au/newspaper/page/24092081 | 24092081 |
25633 | 25633 | 1912-01-20 | 8 | d | Donations for revolutionary army in China | Overseas Chinese in Australia donate for the revolutionary army in China. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092081 | 24092081 |
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]);