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 |
---|---|---|---|---|---|---|---|---|---|
47034 | 47034 | 1928-05-19 | 2 | b | First part of an article written by He Peiyu on Confucianism and its relations with the current world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47041 | 47041 | 1928-05-19 | 3 | b | Communist leader Guo Liang is executed in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098809 | 24098809 | |
47046 | 47046 | 1928-05-19 | 5 | b | Polyandry in Tibet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098811 | 24098811 | |
47047 | 47047 | 1928-05-19 | 5 | b | Different social custom in a barbarian mountain in Yunnan province. A poor but happy life. Concubine and sons. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098811 | 24098811 | |
47053 | 47053 | 1928-05-19 | 7 | b | The Nationalist government in Nanjing appoints delegate to the international peace conference. | Britain | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47054 | 47054 | 1928-05-19 | 7 | b | Strike in India and the involvement of the Communist Party. | Other... | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47055 | 47055 | 1928-05-19 | 7 | b | American government offers to mediate the conflict between China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47056 | 47056 | 1928-05-19 | 7 | b | Jinan after the battle between Chinese and Japanese troops. | Britain | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 |
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]);