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 |
---|---|---|---|---|---|---|---|---|---|
46473 | 46473 | 1927-11-26 | 3 | b | International colonies to have an exhibition in Paris for six months and the report. | France | http://trove.nla.gov.au/newspaper/page/24098607 | 24098607 | |
46483 | 46483 | 1927-11-26 | 5 | b | Mobil company makes huge profit. | America | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46484 | 46484 | 1927-11-26 | 5 | b | A case of counterfeit bank notes in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46485 | 46485 | 1927-11-26 | 5 | b | Policy in Turkey arrest the Communist members. | Other... | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46486 | 46486 | 1927-11-26 | 5 | b | Britain and Soviet Russia to resume their diplomatic relations. | Britain | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46487 | 46487 | 1927-11-26 | 5 | b | Clashes between troops under Zhang Fakui and Li Jishen in Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46488 | 46488 | 1927-11-26 | 5 | b | Jin Yunpeng is still alive. Professor Gao Renshan and nine students of the Beijing Normal University are arrested. Zhang Zuolin's troops take over Shijiazhuang and the orders issued Zhang. Song Qingling denies marriage with Chen Youren. Sun Ke to leave Hankou for Nanjing. Truce between Zhang Zuolin and Yan Xishan. Sun Chuanfang's army stage a comeback. | China | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46491 | 46491 | 1927-11-26 | 7 | b | Guangdong news/ Banditry in Taishan county, Guangdong. Homeless people in Foshan and their demonstration. Bandit chieftain arrested in Dongguan. Tiger eats passers-by in Chaoyang county. Bandits in Xinhui county. Chen Village in Xinhui county is looted. | China | http://trove.nla.gov.au/newspaper/page/24098611 | 24098611 |
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]);