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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 |
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]);