This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39907 | 39907 | 1923-05-26 | 8 | a-d | Guangdong news/ Authorities are selling more public properties and more reports. A newspaper in Guangzhou condemns a news agency for report. Zhu Zhuowen leads troops to attack Xiangshan county. Gaoyao county has two magistrates at the moment. Zengcheng people in Hong Kong sue their county magistrate. Casualty statistics of the Fan Shisheng's troops. Red Cross and emergency services in Guangdong. A car that belongs to the provincial government is detained. Planes bomb ammunitions factory near Guangzhou. Ferry passengers are drowned on their way to Zhaoqing. Military situation in Zhaoqing. Nobody cultivates the farm in Xinhui county as bandits would come to rob at any time. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094422 | 24094422 | |
39908 | 39908 | 1923-05-26 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094422 | 24094422 | |
39909 | 39909 | 1923-05-26 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094422 | 24094422 |
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]);