This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42475 | 42475 | 1924-12-20 | 8 | a-d | Guangdong news/ Guangdong people request politicians in the north to condemn Sun Yatsen. Sun Yatsen's government seals up more properties owned by businessmen. Guangdong commercial chambers to elect the chairman. Troops and their looting in Guangzhou. Hunan army in Shaoguan and their pressgang. Chen Jiongming to be the general commander. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100977 | 24100977 | |
42476 | 42476 | 1924-12-20 | 8 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100977 | 24100977 | |
42477 | 42477 | 1924-12-20 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100977 | 24100977 |
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]);