This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39218 | 39218 | 1922-12-30 | 8 | a-c | Guangdong news/ Tang Shaoyi on the current situations. Wang Dinghua leads troops to besiege bandits in Gudou Mountain. County governments are required to reduce their department. A foreigner will be charged in Guangzhou for making bombs. Li Houji arrives Shantou. Yuan Dai leads troops to suppress bandits in Dongguan. Murder in Xiangshan. Government troops are trying to suppress bandits in Gaoyao county. Another robber in Songlong, Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094242 | 24094242 | |
39219 | 39219 | 1922-12-30 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094242 | 24094242 | |
39220 | 39220 | 1922-12-30 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094242 | 24094242 |
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]);