This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53543 | 53543 | 1933-11-18 | 3 | a | Japanese continue to encourage independence movement in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53544 | 53544 | 1933-11-18 | 3 | a | Russia to protect their railway by force. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53545 | 53545 | 1933-11-18 | 3 | b | More Russian troops reach the border of Manchuria. Russian planes fly along the Manchurian border. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53546 | 53546 | 1933-11-18 | 3 | c | Japanese politician on the international disarmament. | Japan | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53547 | 53547 | 1933-11-18 | 3 | d | Japanese cabinet reshuffled. | Japan | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53548 | 53548 | 1933-11-18 | 3 | d | Belgium strengthens its national defence. | Other... | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53549 | 53549 | 1933-11-18 | 3 | e | Japanese commander is injured in Jinzhou, Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53550 | 53550 | 1933-11-18 | 3 | e | Manchurian state replies to the protest of Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 | |
53551 | 53551 | 1933-11-18 | 3 | e | Japanese to appoint a governor in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24091437 | 24091437 |
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]);