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 |
---|---|---|---|---|---|---|---|---|---|
50394 | 50394 | 1931-06-13 | 3 | a | Envoy of the Chinese government Hu Shize talks about his missions to Russia. | China | http://trove.nla.gov.au/newspaper/page/24090412 | 24090412 | |
50395 | 50395 | 1931-06-13 | 3 | a | Financial difficulties in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090412 | 24090412 | |
50401 | 50401 | 1931-06-13 | 5 | a | Hong Kong news/ Hong Kong government denies any introduction of gold standard system. Jiang Jieshi's troops are approaching the Dayuling Mountain in Guangdong. Hong Kong police raid Red Pills drug smuggling chains. Many rickshaw pullers are changing their career. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090414 | 24090414 |
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]);