This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44430 | 44430 | 1926-02-13 | 8 | a | Photograph of the Suez Canal. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101461 | 24101461 | |
44431 | 44431 | 1926-02-13 | 8 | a-d | Guangdong news/ Collection of orders issued by the Nationalist Guangzhou government. Xiong Kewu is detained and the investigation. Talks between two factions of the Nationalist Party (Borodin and Tan Pingshan). Chen Gongbo is not welcomed by the Communists. Bandits in the Dongjiang area collect charges for so-called protection. | China | http://trove.nla.gov.au/newspaper/page/24101461 | 24101461 |
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]);