This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43075 | 43075 | 1925-04-25 | 7 | a | Two Chinese men in Melbourne are found no guilty in an opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43076 | 43076 | 1925-04-25 | 7 | a | More visitors to The Royal Agricultural Show at Moore Park, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43077 | 43077 | 1925-04-25 | 7 | a | Counterfeit bank notes found in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43078 | 43078 | 1925-04-25 | 7 | a | Two thieves are captured in Sydney for burglary. | Australia | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43079 | 43079 | 1925-04-25 | 7 | a | Riots in Portugal have been suppressed. | Other... | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43080 | 43080 | 1925-04-25 | 7 | b | Bandits in Guangdong. Hotel accommodation in Hong Kong is not safe. Feng Yuxiang's troops in Beijing. Long Jiguang dies in Beijing. Duan Zhigui dies in Tianjin. State funeral prepared for Sun Yatsen. Zhongshan Park in Beijing where Sun Yatsen's coffin lies. | China | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43081 | 43081 | 1925-04-25 | 7 | b-c | Military news from Dongjiang area, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43082 | 43082 | 1925-04-25 | 7 | c | Lin Hu's troops arrive Wongyuan county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43083 | 43083 | 1925-04-25 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 |
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]);