This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41398 | 41398 | 1924-04-12 | 3 | a-b | Jiangsu provincial committee of self-government has a conference and their discussions. | China | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
41399 | 41399 | 1924-04-12 | 3 | b | League of Nations to have a disarmament conference in Tokyo. | Other... | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
41400 | 41400 | 1924-04-12 | 3 | b-c | Japanese government is considering to use the Boxer Indemnity for promotion of Chinese cultural exchange. | Japan | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
41401 | 41401 | 1924-04-12 | 3 | c-d | British chamber of commerce in Shanghai and its policy in China. | China | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
41402 | 41402 | 1924-04-12 | 3 | d | The end of imperial Russian families. | Russia | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
41403 | 41403 | 1924-04-12 | 3 | d-e | Japanese seismologist predicts another earthquake in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
41404 | 41404 | 1924-04-12 | 3 | e-f | Soviet Russian Communist universities are recruiting students in China and the response of Chinese authorities. | China | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
41405 | 41405 | 1924-04-12 | 3 | f | Pirates hijack a Portuguese cargo ship near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 |
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]);