This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54224 | 54224 | 1934-06-09 | 6 | a | The Philippines welcomes Australian trade delegation. | Other... | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54225 | 54225 | 1934-06-09 | 6 | a | Puyi is sick. | China | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54226 | 54226 | 1934-06-09 | 6 | a | Japanese naval commander dies. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54227 | 54227 | 1934-06-09 | 6 | c | Recent negotiations between Russia and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54228 | 54228 | 1934-06-09 | 6 | d | Hot weather in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54229 | 54229 | 1934-06-09 | 6 | d | Brother of Emperor of Japan becomes ambassador to Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 | |
54230 | 54230 | 1934-06-09 | 6 | d | Australia news/ Australian businessmen to set up a Far East Trade company. New regulations on the sale of tobacco products. Woman pilot flies from Britain to Australia. Australian export to China. French man arrives Sydney by a Chinese ship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096048 | 24096048 |
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]);