This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34445 | 34445 | 1919-05-03 | 3 | a | English Times in Beijing and Tianjin reveals the alliance of Japan and Germany. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34446 | 34446 | 1919-05-03 | 3 | b-c | Korean people and their independence movement. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34447 | 34447 | 1919-05-03 | 3 | d | Chinese labourers in France and their return to China. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34448 | 34448 | 1919-05-03 | 3 | d | Chinese delegation to the Paris Peace Conference. | France | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34449 | 34449 | 1919-05-03 | 3 | e | Items on racial equality included in the treaty to be signed at the Paris Peace Conference. Discussions on the Shandong issues at the Paris Peace Conference. Relations between China and Japan at the peace conference. | France | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34450 | 34450 | 1919-05-03 | 3 | f | Hundreds of people killed in the turmoil in Korea. | America | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34451 | 34451 | 1919-05-03 | 3 | f | Italy at the Paris Peace Conference. | Other... | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34452 | 34452 | 1919-05-03 | 3 | f | Japan wants to take over Shandong and Jiaozhou peninsula at the Paris Peace Conference and their attitude is strong. | Britain | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 |
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]);