This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28525 | 28525 | 1914-03-07 | 2 | a-b | Editorial by the Tung Wah Times says that Chinese government should set up consular office in Tahiti to protect Chinese residents there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 | |
28526 | 28526 | 1914-03-07 | 2 | b | Tung Wah Times comments on current situations in China and suggests to set Confucianism as the state religion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 | |
28527 | 28527 | 1914-03-07 | 2 | c | Orders issued by the Chinese President Yuan Shikai on January 13 and 16 on legal and financial establishments. | China | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 | |
28528 | 28528 | 1914-03-07 | 2 | c-d | Chinese President Yuan Shikai on the establishment of provisional constitution office in the cabinet. | China | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 | |
28529 | 28529 | 1914-03-07 | 2 | d | New proposals on the presidential system in China. | China | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 | |
28530 | 28530 | 1914-03-07 | 2 | d | Detailed report on the political conference in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 |
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]);