This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15588 | 15588 | 1906-04-21 | 2-3 | d-a | A girls school in Guangzhou and its curriculum. A quit-opium-smoking society set up in Foshan, Guangdong. Students in Guangzhou purchase shares of the railway from Hankou to Guangzhou. Zhi Yanming has sold all his assets in order to purchase shares of the railway from Hankou to Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800957 | 26800957 |
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]);