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 |
---|---|---|---|---|---|---|---|---|---|
54128 | 54128 | 1934-05-12 | 2 | a | First part of comments on the constitution and the constitutional politics in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096010 | 24096010 | |
54137 | 54137 | 1934-05-12 | 5 | a | Massage in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096011 | 24096011 | |
54138 | 54138 | 1934-05-12 | 5 | d | On the novel Dream in the Red Chamber (hong lou meng). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096011 | 24096011 | |
54147 | 54147 | 1934-05-12 | 6 | e | Australia news/ Trade statistics between China and Australia in the past six years. Bandits fail to rob treasury of the Sydney city council. Visitor talks about modern China on his return. Chinese government entertains Australian trade commissioner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 |
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]);