This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46480 | 46480 | 1927-11-26 | 5 | a | Disasters of war, locusts and drought in Shandong province. Political changes in Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46481 | 46481 | 1927-11-26 | 5 | a | A passenger train hijacked in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46482 | 46482 | 1927-11-26 | 5 | a | Troops from Nanjing occupy Hankou and the report. | China | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
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 |
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]);