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 |
---|---|---|---|---|---|---|---|---|---|
46960 | 46960 | 1928-04-21 | 5 | a | Hong Kong news/ Li Jishen, Chen Mingshu, Zhu Jiahua and Li Minren are going to Nanjing to meet Jiang Jieshi. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098769 | 24098769 | |
46963 | 46963 | 1928-04-21 | 7 | a | Chinese soldiers fire at British tugboat in Hankou, Hubei province. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098771 | 24098771 | |
46964 | 46964 | 1928-04-21 | 7 | a | Beijing authority bans films that offend against decency. | China | http://trove.nla.gov.au/newspaper/page/24098771 | 24098771 | |
46965 | 46965 | 1928-04-21 | 7 | a | Feng Yuxiang's troops harass foreign church in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098771 | 24098771 | |
46966 | 46966 | 1928-04-21 | 7 | a | Emperor of Italy narrowly escapes an assassination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098771 | 24098771 | |
46967 | 46967 | 1928-04-21 | 7 | a | Foreign report on the war in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24098771 | 24098771 | |
46968 | 46968 | 1928-04-21 | 7 | a | Hatred towards the Nationalist army in north Jiangsu province. Russian people detained from their consulate last year are still waiting for trial in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098771 | 24098771 |
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]);