This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41877 | 41877 | 1924-07-26 | 8 | a-d | Guangdong news/ Foreigners in Guangzhou trust the commercial associations rather than the government. Wang Jingwei and Zhang Ji arrive Shantou for a peace talk with Chen Jiongming and Hong Zhaolin. Provincial governor and the ownership of the street. A big gathering of the commercial associations. Sun Ke seeks to resign. Military personnel and government employees are encouraged to join Guomindang. United army and their looting and raping in Boluo county. Sun Yatsen's comments in angry. Robber in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100807 | 24100807 | |
41878 | 41878 | 1924-07-26 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100807 | 24100807 | |
41879 | 41879 | 1924-07-26 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100807 | 24100807 |
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]);