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 |
---|---|---|---|---|---|---|---|---|---|
50512 | 50512 | 1931-07-18 | 2 | e | Wu Chaoshu condemns Jiang Jieshi. Chen Mingshu comes with cash to Jiangxi province to rewards the troops. Wu Zhihui on the Guangdong situation. Troops from Bengbu are leaving for the Longhai railway line. German military adviser on the way to Jiangxi to help fight the communist troops. Zhang Xueliang's troops are entering the Shanhaiguan. Sichuan troops enter the west of Hubei province to suppress bandits. Share of power at the Fifth Plenary of the Central Committee. People in Manchuria who are against Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24090453 | 24090453 | |
50518 | 50518 | 1931-07-18 | 3 | e | Japanese army officers in Tianjin and their atrocities. | China | http://trove.nla.gov.au/newspaper/page/24090452 | 24090452 | |
50519 | 50519 | 1931-07-18 | 3 | e | Soviet Union is planning for communist propaganda in Inner Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24090452 | 24090452 | |
50522 | 50522 | 1931-07-18 | 5 | e | Fighting thief and a story from Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090454 | 24090454 | |
50523 | 50523 | 1931-07-18 | 5 | e | Teacher of a private school in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090454 | 24090454 |
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]);