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 |
---|---|---|---|---|---|---|---|---|---|
47060 | 47060 | 1928-05-26 | 2 | c | Army commanders and soldiers issues a circular telegram on the current situation in China and their hope. | China | http://trove.nla.gov.au/newspaper/page/24098818 | 24098818 | |
47077 | 47077 | 1928-05-26 | 7 | c | Japanese people demand their government to withdraw troops from Shandong. | Japan | http://trove.nla.gov.au/newspaper/page/24098821 | 24098821 | |
47078 | 47078 | 1928-05-26 | 7 | c | Rumours say Japanese troops to occupy Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098821 | 24098821 | |
47079 | 47079 | 1928-05-26 | 7 | c | Japanese government advises Zhang Zuolin to give up Beijing and to return to Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24098821 | 24098821 | |
47080 | 47080 | 1928-05-26 | 7 | c | Zhang Zuolin's troops may give up Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098821 | 24098821 | |
47081 | 47081 | 1928-05-26 | 7 | c | Panchen Lama appeals for peace in China. | Japan | http://trove.nla.gov.au/newspaper/page/24098821 | 24098821 | |
47082 | 47082 | 1928-05-26 | 7 | c | Japan seeks to take over Manchuria and Zhang Zuolin's attitude. | China | http://trove.nla.gov.au/newspaper/page/24098821 | 24098821 |
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]);