This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53448 | 53448 | 1933-10-28 | 3 | a | Japanese foreign minister on their China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53449 | 53449 | 1933-10-28 | 3 | a | Soviet Russia dispatches more troops to the Far East. | China | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53450 | 53450 | 1933-10-28 | 3 | b | American government to recognise the Soviet Russian government. | America | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53451 | 53451 | 1933-10-28 | 3 | c | France and Russia to sign agreement on military and economic cooperation. | France | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53452 | 53452 | 1933-10-28 | 3 | d | Japan and Russia to form an economic alliance. | Japan | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53453 | 53453 | 1933-10-28 | 3 | d | American government plans to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53454 | 53454 | 1933-10-28 | 3 | d | Candidates of Japanese ambassador to China. | China | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53455 | 53455 | 1933-10-28 | 3 | e | Austria to reshuffle the cabinet. | Other... | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53456 | 53456 | 1933-10-28 | 3 | e | Japan and Afghanistan set up diplomatic relations. | Japan | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53457 | 53457 | 1933-10-28 | 3 | e | Russian's plan for warship building. | China | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 |
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]);