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 |
---|---|---|---|---|---|---|---|---|---|
43285 | 43285 | 1925-06-06 | 2 | a | My criticism on Sun Yatsen, written by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
43313 | 43313 | 1925-06-06 | 7 | a | A Chinese market garden in New Castle turns to ashes in a fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
43315 | 43315 | 1925-06-06 | 7 | b | Introduce Dr Ian Crawford, sight testing and spectacule specialist in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
43317 | 43317 | 1925-06-06 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
43318 | 43318 | 1925-06-06 | 8 | a-d | Guangdong news/ Guangdong may see another political crisis. Guangdong government is determined to stop Liu Zhenhuan back to Guangxi. Xiangshan (Zhongshan) county to start communist system and the people gather to protest. People in Xiangshan county demonstrate the name change and takeover by the Central Executive Committee. Division of the new eight administrative regions. Primary school teachers in Guangzhou to have a strike for more pay. Army looting in Zengcheng. Strange rain in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101164 | 24101164 | |
43319 | 43319 | 1925-06-06 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101164 | 24101164 | |
43320 | 43320 | 1925-06-06 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101164 | 24101164 |
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]);