This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46242 | 46242 | 1927-10-01 | 5 | a | British attitude towards the Communist party in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46243 | 46243 | 1927-10-01 | 5 | a | Military clash in Longhua, Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46244 | 46244 | 1927-10-01 | 5 | a | Bandits in Nicaragua. | America | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46245 | 46245 | 1927-10-01 | 5 | a | French government wants the Soviet Russian ambassador recalled back. | France | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46246 | 46246 | 1927-10-01 | 5 | a | Japanese invasion into Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46247 | 46247 | 1927-10-01 | 5 | b | Portuguese authority banishes political criminals. | Other... | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46248 | 46248 | 1927-10-01 | 5 | b | Clash between Chinese and Japanese in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46249 | 46249 | 1927-10-01 | 5 | b | Students in Holland and the communist propaganda. | Other... | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46250 | 46250 | 1927-10-01 | 5 | b | Japanese soldiers arrested in the international concession in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46251 | 46251 | 1927-10-01 | 5 | c | Arms smuggling into India. | Other... | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46252 | 46252 | 1927-10-01 | 5 | c | Jiang Jieshi rebuffs rumours and his talks. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46253 | 46253 | 1927-10-01 | 5 | c | Bandits in Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46254 | 46254 | 1927-10-01 | 5 | c | War clouds over Shandong and Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46255 | 46255 | 1927-10-01 | 5 | c | Japanese security guards in Benxi, Fengtian, kills two Chinese workers and the report. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46256 | 46256 | 1927-10-01 | 5 | d | Circular telegram issued by Li Zongren and He Yingqin. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 |
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]);