This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43983 | 43983 | 1925-10-17 | 2 | a-b | Tension in China alleviates, and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101314 | 24101314 | |
44003 | 44003 | 1925-10-17 | 7 | a | A notice issued by the Chinese Chamber of Commerce in Sydney to celebrate the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101317 | 24101317 | |
44006 | 44006 | 1925-10-17 | 7 | b | Sydney city council purchases new machine for street cleaning. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101317 | 24101317 | |
44012 | 44012 | 1925-10-17 | 7 | c | Liner Changte invites visit of Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101317 | 24101317 | |
44013 | 44013 | 1925-10-17 | 8 | a-d | Guangdong news/ Self-government association in Guangzhou issues a circular telegram on the current situations. News on the special registration requirement for ferry service. Guangzhou government imposes more levies. Brief biography of Chen Qiulin who is assassinated with Liao Zhongkai. Two Chinese women reports their trip to Guangzhou. Guangzhou authority drives out illegal strikers. Bandits and robbery in Zhongshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101320 | 24101320 | |
44014 | 44014 | 1925-10-17 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101320 | 24101320 | |
44015 | 44015 | 1925-10-17 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101320 | 24101320 |
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]);