This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44195 | 44195 | 1925-11-28 | 8 | a-d | Guangdong news/ Local administration in Guangzhou. Official report on the military conflict in Beijiang area. Liu Yaohuan is killed in the battles in Huizhou. Transportation resumes in Huizhou. Government authority in Guangzhou takes over some charitable institutions. Ferry service resumes in Jiujiang. Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101371 | 24101371 | |
44196 | 44196 | 1925-11-28 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101371 | 24101371 | |
44197 | 44197 | 1925-11-28 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101371 | 24101371 |
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]);