This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47937 | 47937 | 1929-03-30 | 2 | b | First part of editorial by Tung Wah Times warns the people who are following the example of the October Revolution in Soviet Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099162 | 24099162 | |
47946 | 47946 | 1929-03-30 | 5 | b | Meeting the thief in local Guangdong, written by Bai Sha. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099163 | 24099163 | |
47958 | 47958 | 1929-03-30 | 8 | b | Guangdong dispatches troops to Jiangxi. | Canada | http://trove.nla.gov.au/newspaper/page/24099168 | 24099168 | |
47959 | 47959 | 1929-03-30 | 8 | b | Communist soldiers detained on board of liner Deqing. | China | http://trove.nla.gov.au/newspaper/page/24099168 | 24099168 | |
47960 | 47960 | 1929-03-30 | 8 | b | Australia news/ New board members of the Chinese Chamber of Commerce in New South Wales are sworn in. State government pays for children's expenses. Advertisement for the Automobile Maintenance Association Ltd, Sydney. Notice issued by Chinese Consulate-General on the arrival of new consul-general. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099168 | 24099168 |
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]);