This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44316 | 44316 | 1926-01-02 | 2 | a | Editorial on the history of the Republic of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101407 | 24101407 | |
44317 | 44317 | 1926-01-02 | 2 | c | Guo Songling requests Zhang Zuolin to step down. | China | http://trove.nla.gov.au/newspaper/page/24101407 | 24101407 | |
44318 | 44318 | 1926-01-02 | 3 | a | Feng Yuxiang advises Zhang Zuolin to step down. | China | http://trove.nla.gov.au/newspaper/page/24101406 | 24101406 | |
44319 | 44319 | 1926-01-02 | 3 | b | Guo Songling defects and his circular telegram. | China | http://trove.nla.gov.au/newspaper/page/24101406 | 24101406 | |
44320 | 44320 | 1926-01-02 | 3 | c | Tang Shaoyi in Shanghai and his contacts with Zhang Taiyan and Guo Songling. | China | http://trove.nla.gov.au/newspaper/page/24101406 | 24101406 | |
44321 | 44321 | 1926-01-02 | 6 | a | Troops from Henan province occupy Baoding, capital of Hebei. | China | http://trove.nla.gov.au/newspaper/page/24101411 | 24101411 | |
44322 | 44322 | 1926-01-02 | 7 | b | Australia news/ Stamp duty in Sydney. Sydney Chinese School on holiday. The Singer Sewing Machine and its new features. Investment in forest and the profit, an introduction by the Commonwealth Underwriter Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101410 | 24101410 | |
44323 | 44323 | 1926-01-02 | 7 | c | Zhang Zuolin retreats. Li Jinglin and his troops are defeated. Battles in north China (Feng Yuxiang, Guo Songling, Zhang Zuolin, and their battles). | China | http://trove.nla.gov.au/newspaper/page/24101410 | 24101410 | |
44324 | 44324 | 1926-01-02 | 8 | a-c | Guangdong news/ Shareholders of the Guangzhou-Hankou railway to have a meeting. Management committee of the Guangdong universities including Wang Jingwei, Tan Yankai, Wu Chaoshu and Chen Gongbo. Union of builders in Guangzhou and their strike. Committee set up to investigate the railway from Guangzhou to Sanshui. Police in Taishan county. Bandits in Dongguan and Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101413 | 24101413 |
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]);