This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27511 | 27511 | 1913-06-28 | 2 | b-c | Order issued by President Yuan Shikai on plot of some businessmen to make trouble. | China | http://trove.nla.gov.au/newspaper/page/24092729 | 24092729 | |
27527 | 27527 | 1913-06-28 | 3 | b-c | Beijing news/ Proposal for Sino-Russian negotiations. Chinese in Japan and their patriotism. Chinese in Canada and their angry with Sun Yatsen and Huang Xing. Businessmen in Shanghai and the new political party. Huang Shilong helps Zhang Xun. Ni Sichong and Long Jiguang are appointed governor respectively for Anhui and Guangdong. Japanese tourist group and their whereabouts in China. | China | http://trove.nla.gov.au/newspaper/page/24092728 | 24092728 |
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]);