This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47962 | 47962 | 1929-04-06 | 2 | b | Second 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/24099170 | 24099170 | |
47963 | 47963 | 1929-04-06 | 2 | c | Lu Diping, chairman of the Hunan provincial government, is removed from his position. | China | http://trove.nla.gov.au/newspaper/page/24099170 | 24099170 | |
47964 | 47964 | 1929-04-06 | 2 | e | Chaos in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24099170 | 24099170 | |
47965 | 47965 | 1929-04-06 | 2 | f | Exhibition organised in Nanjing to raise funds for the famine victims in north China. | China | http://trove.nla.gov.au/newspaper/page/24099170 | 24099170 |
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]);