This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43705 | 43705 | 1925-08-22 | 8 | a-d | Guangdong news/ British troops in Guangzhou fire at the demonstrators and the declaration issued by the provincial government. Guangdong people in Beijing send their representatives to investigate the Shamian Massacre. Xu Chongzhi replies to Guangdong fellows in Beijing on the Shamian massacre. Big gatherings in Guangzhou in protest against the Shamian Massacre. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101256 | 24101256 | |
43706 | 43706 | 1925-08-22 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101256 | 24101256 | |
43707 | 43707 | 1925-08-22 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101256 | 24101256 |
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]);