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