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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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]);