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 |
---|---|---|---|---|---|---|---|---|---|
38393 | 38393 | 1922-03-11 | 2 | c-d | The Nine-Power Pact signed by the United States, Great Britain, Japan, France, Italy, The Netherlands, Portugal, Belgium, and China which affirms China's sovereignty, independence, and territorial integrity and gives all nations the right to do business with it on equal terms. | America | http://trove.nla.gov.au/newspaper/page/24093896 | 24093896 | |
38396 | 38396 | 1922-03-11 | 3 | a | Japanese delegation to the Washington Conference successfully blocks the discussion on Siberian issues. | America | http://trove.nla.gov.au/newspaper/page/24093895 | 24093895 | |
38397 | 38397 | 1922-03-11 | 3 | a-c | American Secretary of State Charles Hughes talks Shandong issues to the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093895 | 24093895 | |
38399 | 38399 | 1922-03-11 | 3 | d-e | Chinese and Japanese sailors are arrested in Taiwan for hijack attempt. | America | http://trove.nla.gov.au/newspaper/page/24093895 | 24093895 | |
38400 | 38400 | 1922-03-11 | 3 | e | Chita Republican government starts negotiation with Japan. | America | http://trove.nla.gov.au/newspaper/page/24093895 | 24093895 | |
38401 | 38401 | 1922-03-11 | 3 | e | American parliament approves to reduce number of servicemen. | America | http://trove.nla.gov.au/newspaper/page/24093895 | 24093895 | |
38411 | 38411 | 1922-03-11 | 6 | c | A big fire in America and the damages. | America | http://trove.nla.gov.au/newspaper/page/24093900 | 24093900 |
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]);