This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52455 | 52455 | 1933-01-28 | 2 | d | Chinese Ministry of Industry to set up big factory in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52456 | 52456 | 1933-01-28 | 2 | d | Chen Guohui is executed in Fujian. Two Korean men are arrested in Changchun for assassination. Japanese encourage independence of Mongolia. Fortification along the Yangtze River. Li Guojie is sentenced to three years' imprisonment in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52470 | 52470 | 1933-01-28 | 5 | d | Research on the manufacturing of robot. | Other... | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
52480 | 52480 | 1933-01-28 | 8 | d | Former French prime minister on the Manchurian issues. | Britain | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
52481 | 52481 | 1933-01-28 | 8 | d | China and Japan to have a big war. | China | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 |
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]);