This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28796 | 28796 | 1914-05-09 | 2 | c | Chinese presidential office in Beijing is preparing for a national conference on the cabinet system, reform of provincial system, diplomacy, finance and military affairs. | China | http://trove.nla.gov.au/newspaper/page/24093102 | 24093102 | |
28805 | 28805 | 1914-05-09 | 3 | c | Canadian government helps to build a railway across the continent. | Canada | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28806 | 28806 | 1914-05-09 | 3 | c | China to revise the provisional constitution. | China | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28807 | 28807 | 1914-05-09 | 3 | c | Yuan Shikai centralises the power in his own hands. | China | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28808 | 28808 | 1914-05-09 | 3 | c | A man is on trial for attempting to assassinate the mayor of New York and his confession in the court. | America | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28809 | 28809 | 1914-05-09 | 3 | c | Epidemic in Cuba. | Other... | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28817 | 28817 | 1914-05-09 | 7 | c | First part of a report on the Chinese community & immigrants in Tahiti, written by He Xing, a native of Shunde county, Guangdong, now living in Tahiti. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093105 | 24093105 |
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]);