This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21799 | 21799 | 1909-10-16 | 2 | a-b | The last word from Manchurian official Yong Lin to Prince Regent. | China | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21802 | 21802 | 1909-10-16 | 2 | c | Duan Fang and Lu Zhengxiang ask for lift of the ban on political party. | China | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21806 | 21806 | 1909-10-16 | 2-3 | d-a | Beijing news/ Board of Revenue intends to borrow 5 million internal debt. A nail factory opened in Hankou. Wang Wenshao suggests reducing the number of eunuchs. New office set up to supervise Chinese students in America. Government officials required to attend lecturers on constitutional reform. News on the Jiandao island dispute between China and Japan. Proposal to reform Chinese army system. Xiong Xiling and his financial management in Manchuria. Xi Liang asks for weapon supply from Zhili province. | China | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21819 | 21819 | 1909-10-16 | 3 | d | Warning message to Zhili people on Japan's plot, published by a Beijing newspaper. | China | http://trove.nla.gov.au/newspaper/page/26802359 | 26802359 |
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]);