This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56322 | 56322 | 1936-10-10 | 2 | c | China news/ The Nanjing government to issue more bonds in order to reorganise the Guangdong finance. Japanese warships in Beihai of Guangxi province. Japanese new demands to the Nanjing government. Li Zongren and Bai Chongxi are appointed military commanders in Guangxi. Big cargo ships manufactured in China. | China | http://trove.nla.gov.au/newspaper/page/24097020 | 24097020 | |
56324 | 56324 | 1936-10-10 | 3 | c | American journalist in Nanjing talks about the journalism in America. | China | http://trove.nla.gov.au/newspaper/page/24097019 | 24097019 | |
56325 | 56325 | 1936-10-10 | 3 | c | Korean revolutionaries and their independence movement. | China | http://trove.nla.gov.au/newspaper/page/24097019 | 24097019 |
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]);