This data as json, CSV (advanced)
Suggested facets: date (date)
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 | |
38398 | 38398 | 1922-03-11 | 3 | c-d | Investment Bureau in Guangzhou sends telegram to naval commander in Beijing for hijack of their passenger liner near Xiamen (Amoy) last year and report their solutions. | China | 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]);