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 |
---|---|---|---|---|---|---|---|---|---|
45834 | 45834 | 1927-06-25 | 2 | b | Editorial by Tung Wah Times on the class classification in Soviet Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
45851 | 45851 | 1927-06-25 | 5 | b-c | Bandits in Guangdong: the past and the present. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102037 | 24102037 | |
45852 | 45852 | 1927-06-25 | 7 | a | Poems by Wu Elou (Xiuguang) on his travel back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102039 | 24102039 | |
45853 | 45853 | 1927-06-25 | 7 | a | Australia news/ Chinese football team wins again in Adelaide. Chinese man dies in accident in Sydney. Storm in Perth. Police raid Chinese gambling den in Sydney. Rev. Li Baoshen is on the way to Fiji for gospel work. Advertisement for the International Ball in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102039 | 24102039 |
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]);