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 |
---|---|---|---|---|---|---|---|---|---|
46430 | 46430 | 1927-11-19 | 2 | c | Wu Peifu in Sichuan province and his life. | China | http://trove.nla.gov.au/newspaper/page/24098600 | 24098600 | |
46431 | 46431 | 1927-11-19 | 2 | c | Jiang Jieshi talks to Japanese journalists. | Japan | http://trove.nla.gov.au/newspaper/page/24098600 | 24098600 | |
46432 | 46432 | 1927-11-19 | 2 | c | Bandits in Qingjiang, north Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098600 | 24098600 | |
46440 | 46440 | 1927-11-19 | 3 | c | Businessmen in Shanghai and the banditry. | China | http://trove.nla.gov.au/newspaper/page/24098599 | 24098599 | |
46441 | 46441 | 1927-11-19 | 3 | c | Poems ridicule Wu Peifu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098599 | 24098599 | |
46459 | 46459 | 1927-11-19 | 5 | c | Russian refugees in Shanghai attack the Soviet Russian consulate and the report. Chaos in Hankou following the attack from Nanjing and the flee of Tang Shengzhi. Sun Chuanfang leads his troops moving south. | China | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46460 | 46460 | 1927-11-19 | 5 | c | Italy and Hungary resume their talks. | Britain | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46461 | 46461 | 1927-11-19 | 5 | c | Troops from Nanjing occupy Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46462 | 46462 | 1927-11-19 | 5 | c | Gas explosion in Pittsburgh, America. | America | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 |
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]);