This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34348 | 34348 | 1919-04-05 | 3 | a-b | The railway in Siberia should be managed by the Chinese government and a study. | China | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 | |
34349 | 34349 | 1919-04-05 | 3 | b-c | Japanese encourage independent movement among the Muslim comminities in Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 | |
34350 | 34350 | 1919-04-05 | 3 | d | Gu Weijun, Chinese ambassador to America and representative to the Paris Peace Conference, talks to journalist that China should take over Jiaozhou peninsula. | France | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 | |
34351 | 34351 | 1919-04-05 | 3 | e | Report from London on the Paris peace conference. | Britain | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 | |
34352 | 34352 | 1919-04-05 | 3 | e | Report from the Paris Peace Conference/ League of the Nations. George Morrison at the conference and the Qingdao issues. Canadian and American governments report their loss. Amount of indemnity that Germany required to repay. Hungarian delegation at the conference. Australian delegation at the conference. | France | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 | |
34353 | 34353 | 1919-04-05 | 3 | f | Arrest of revolutionaries in Korea and their independence movement. | China | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 | |
34354 | 34354 | 1919-04-05 | 3 | f | The expected results of the Paris Peace Conference. | China | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 |
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]);