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 |
---|---|---|---|---|---|---|---|---|---|
47987 | 47987 | 1929-04-13 | 2 | b | Third and final 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/24099178 | 24099178 | |
48005 | 48005 | 1929-04-13 | 5 | d | Sex in Paris. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099179 | 24099179 | |
48006 | 48006 | 1929-04-13 | 5 | f | Predictions for the year of 1929. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099179 | 24099179 | |
48014 | 48014 | 1929-04-13 | 8 | b | Australia news/ Storm in Tasmania and the damages. Strike of the timber workers in Sydney turns into violence. Chinese Chamber of Commerce acknowledges receipt of donations to the famine victims in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48015 | 48015 | 1929-04-13 | 8 | d | The Dongguan gong yi tang in Sydney acknowledges receipt of donations to the hospital in their hometown. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 |
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]);