This data as json, CSV (advanced)
Suggested facets: column, 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 | |
38802 | 38802 | 1922-06-03 | 2-3 | f-a | Japanese authority will not withdraw their postal service from China. | Japan | http://trove.nla.gov.au/newspaper/page/24093994 | 24093994 | |
41714 | 41714 | 1924-06-21 | 2-3 | f-a | Chinese in Japan demonstrate against the anti-Chinese movement. | Japan | http://trove.nla.gov.au/newspaper/page/24100761 | 24100761 | |
41853 | 41853 | 1924-07-26 | 2-3 | f-a | Japanese talk about the Twenty-one Demands. | Japan | http://trove.nla.gov.au/newspaper/page/24100801 | 24100801 | |
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 | |
44369 | 44369 | 1926-01-30 | 2-3 | d | Japanese newspaper reports the secret treaty signed by Feng Yuxiang and Russian. | Japan | http://trove.nla.gov.au/newspaper/page/24101439 | 24101439 |
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]);