This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45585 | 45585 | 1927-04-02 | 2 | d | Proposal for the revision of Chinese tariff. | China | http://trove.nla.gov.au/newspaper/page/24101932 | 24101932 | |
45587 | 45587 | 1927-04-02 | 3 | c | Foreign gunboats in Shanghai and a survey. | China | http://trove.nla.gov.au/newspaper/page/24101931 | 24101931 | |
45588 | 45588 | 1927-04-02 | 3 | d | Governor of Shandong province Zhang Zongchang and his plan of transportation. | China | http://trove.nla.gov.au/newspaper/page/24101931 | 24101931 | |
45589 | 45589 | 1927-04-02 | 3 | e | Zhang Jingjiang is considering to topple the Chinese Communist Party and Jiang Jieshi supports his plan. | China | http://trove.nla.gov.au/newspaper/page/24101931 | 24101931 | |
45590 | 45590 | 1927-04-02 | 3 | f | Chinese students are returning from France and Belgium. | China | http://trove.nla.gov.au/newspaper/page/24101931 | 24101931 | |
45591 | 45591 | 1927-04-02 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101933 | 24101933 | |
45592 | 45592 | 1927-04-02 | 5 | c | Businessmen in the Beijiang area and the conflict with the government authority. | China | http://trove.nla.gov.au/newspaper/page/24101933 | 24101933 | |
45598 | 45598 | 1927-04-02 | 8 | a-d | Guangdong news/ A survey on the mining resources in Guangdong. Xiangshan county authority orders to stop harassment to local churches. Tax on gambling in Xiangshan county. Bandits in Xiangshan county are besieged. Bandits in Gaoming county hijack ferries. Dongguan Public Society asks for help to suppress bandits. Bandits in Yangjiang county. Transportation on the Guangzhou-Hankou railway. New orders on the house maids. Director of Public Security Bureau Deng Yanhua and his speech in Guangzhou. Army enlistment in Guangzhou and the resistance. | China | http://trove.nla.gov.au/newspaper/page/24101938 | 24101938 |
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]);