This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29475 | 29475 | 1914-12-19 | 3 | a | General Zhang Xun arrives Beijing and his meeting with President Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24093361 | 24093361 | |
29476 | 29476 | 1914-12-19 | 3 | b | Guangdong reports to the central authority in Beijing its educational development in the past few years. | China | http://trove.nla.gov.au/newspaper/page/24093361 | 24093361 | |
29477 | 29477 | 1914-12-19 | 3 | b-c | Miscellaneous report on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24093361 | 24093361 | |
29478 | 29478 | 1914-12-19 | 3 | c-d | Beijing news/ School teachers will be in the rank of government officials. Meeting of central government on the currency reform. Proposal to permit government bonds circulating throughout the country. Famine and beggars in north Anhui province (Liu'an, Huoshan, Shucheng and Woyang counties). | China | http://trove.nla.gov.au/newspaper/page/24093361 | 24093361 | |
29479 | 29479 | 1914-12-19 | 3 | d | Guangdong news/ Building of the Confucian temple in Guangzhou and arrangement of memorial tablets. Navy school in Guangzhou and its future. | China | http://trove.nla.gov.au/newspaper/page/24093361 | 24093361 |
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]);