This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54055 | 54055 | 1934-04-14 | 3 | a | Japanese spy planes are shot down in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54056 | 54056 | 1934-04-14 | 3 | a | Japanese propaganda on the economic cooperation between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54057 | 54057 | 1934-04-14 | 3 | b | Japanese ambassador is bombed in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54058 | 54058 | 1934-04-14 | 3 | c | Alliance troops of five provinces on the way to fight Sun Dianying. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54059 | 54059 | 1934-04-14 | 3 | c | Unemployment in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54060 | 54060 | 1934-04-14 | 3 | d | American parliament approves the new budget for navy. | America | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54061 | 54061 | 1934-04-14 | 3 | d | French newspaper predicts the war between Japan and Russia. | France | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54062 | 54062 | 1934-04-14 | 3 | e | Japanese troops still occupy fortifications along the Great Wall. | China | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54063 | 54063 | 1934-04-14 | 3 | f | Britain dispatches more troops to Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 |
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]);