This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55836 | 55836 | 1936-02-29 | 6-7 | a-d | Guangdong news/ Fireworks in Macao kill six people. Japanese counsel initiates another negotiation with the Shantou government. Guangzhou welcomes Hu Hanmin. Zou Yunhe invents new materials for paper manufacturing. Russian arm smugglers detained in Guangzhou. Central government sends fleet to welcome Hu Hanmin. The international business last year and a detailed report. Zengcheng county legislature member is detained for opium smoking. | China | http://trove.nla.gov.au/newspaper/page/24096764 | 24096764 |
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]);