This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13669 | 13669 | 1904-08-13 | 2-3 | d-a | Third part of the battlefield report on the war with Russia on the Yalu River, written by Japanese journalist. | Japan | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
21585 | 21585 | 1909-09-04 | 2-3 | d-a | Correspondence from Tokyo/ Graduation ceremony at Meiji University, Tokyo, and the Chinese graduates. Chinese graduates from other public schools or universities. Dr Okada, former advisor in the Beijing Law Institute, talks on his return legal development in China. | Japan | http://trove.nla.gov.au/newspaper/page/26802312 | 26802312 | |
30685 | 30685 | 1915-11-13 | 2-3 | d-a | Foreigners' views on China's restoring imperial system. | Japan | http://trove.nla.gov.au/newspaper/page/24095051 | 24095051 | |
43355 | 43355 | 1925-06-20 | 2-3 | d-a | Japanese on the Twenty-one Demands and the implementation in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24101174 | 24101174 |
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]);