This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42865 | 42865 | 1925-03-14 | 8 | a-d | Guangdong news/ Sun Yatsen's government and the exorbitant levies. Foshan people and their civil corps. Yang Chisheng is appointed commander to the south of Jiangxi province. The Nationalist Party flag in Guangzhou. Zhenguang company in Guangzhou tries to raise more funds by floating shares. People in Xiangshan county condemn the corruption of court judges. People in Taishan escape pressgang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101068 | 24101068 | |
42866 | 42866 | 1925-03-14 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101068 | 24101068 | |
42867 | 42867 | 1925-03-14 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101068 | 24101068 |
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]);