This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42512 | 42512 | 1924-12-27 | 8 | a-d | Guangdong news/ Troops in Guangzhou and report on their lootings. Yunnan army on their way to Shunde county. Businessmen and ordinary residents in Guangzhou condemn the Nationalist Party. Election of the Guangzhou mayor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100984 | 24100984 | |
42513 | 42513 | 1924-12-27 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100984 | 24100984 | |
42514 | 42514 | 1924-12-27 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100984 | 24100984 |
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]);