This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34965 | 34965 | 1919-10-11 | 3 | c | Japan's true motives in Shandong. | America | http://trove.nla.gov.au/newspaper/page/24097891 | 24097891 | |
34967 | 34967 | 1919-10-11 | 3 | d | Racial clash between the black and the white in Nebraska, United States of America. | America | http://trove.nla.gov.au/newspaper/page/24097891 | 24097891 | |
34971 | 34971 | 1919-10-11 | 6 | b | Russian military authority in Lushun refuses Chinese ship to enter the Lushun River. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34972 | 34972 | 1919-10-11 | 6 | b | Japanese ambassador to Washington and American President Wilson talk on the return of Shandong to China. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34973 | 34973 | 1919-10-11 | 6 | b | Peace talks in China between the south and the north is halted again. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34974 | 34974 | 1919-10-11 | 6 | b | American President Wilson is ill. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34975 | 34975 | 1919-10-11 | 6 | c | Floods in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34976 | 34976 | 1919-10-11 | 6 | c | Japan seeks to occupy Siberia. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34977 | 34977 | 1919-10-11 | 6 | c | Japan to expand its navigation industry. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34978 | 34978 | 1919-10-11 | 6 | c | Chinese government engages former American ambassador the government adviser. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 |
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]);