This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27732 | 27732 | 1913-08-16 | 2 | a | Chinese government welcomes Kang Youwei, report from a Beijing newspaper. | China | http://trove.nla.gov.au/newspaper/page/24092785 | 24092785 | |
27733 | 27733 | 1913-08-16 | 2 | b | Tung Wah Times comments on foreign attitudes towards China, draft of China's national constitution and presidential election. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092785 | 24092785 | |
27734 | 27734 | 1913-08-16 | 2 | b-d | Orders issued by the interim president Yuan Shikai on worship of Confucius, rewards to Huang Rongliang and Australian Chinese community for their contribution to China's national construction, and suppress to rebellions in the south. | China | http://trove.nla.gov.au/newspaper/page/24092785 | 24092785 | |
27735 | 27735 | 1913-08-16 | 2 | d | Movement in Shanghai to promote Confucianism. | China | http://trove.nla.gov.au/newspaper/page/24092785 | 24092785 | |
27736 | 27736 | 1913-08-16 | 2 | d | President Yuan Shikai on Guangdong (appointment of officials and the people). | China | http://trove.nla.gov.au/newspaper/page/24092785 | 24092785 |
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]);