This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29653 | 29653 | 1915-01-30 | 8 | a-b | Travel records/ Tradition and customs in Brazil. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094710 | 24094710 | |
29654 | 29654 | 1915-01-30 | 8 | b-c | Guangdong news/Long Jiguang cables the central government for training ground troops. All city gates are to practise inspecting regulations in Guangdong. Riot parties involved with troops are found in Guangdong. Central government awards personnel in pacifying Fushan bandits riot in Guangdong. A riot party organisation is found in Nanhai, Guangdong. Wang Hanqing, a beautiful lady in guise of prostitute works for riot party. | China | http://trove.nla.gov.au/newspaper/page/24094710 | 24094710 |
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]);