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 |
---|---|---|---|---|---|---|---|---|---|
45535 | 45535 | 1927-03-12 | 2 | c-d | Chinese recent diplomacy with Britain, America and other countries. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45536 | 45536 | 1927-03-12 | 2 | d | A meeting between China and Japan to revise the treaties. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45537 | 45537 | 1927-03-12 | 2 | f | The trial of POWs in Jiangxi province, chaired by Guo Moruo. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45538 | 45538 | 1927-03-12 | 3 | c | Chinese foreign ministry in Beijing publicise the correspondence with Japan over the revision of treaties. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45540 | 45540 | 1927-03-12 | 3 | d | The Soviet Russia and the Nationalist government in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45541 | 45541 | 1927-03-12 | 3 | d | The Nationalist Party sets up local administration in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45550 | 45550 | 1927-03-12 | 8 | a-d | Guangdong news/ Petitions of the Guangzhou businessmen and Li Jishen. The Huangpu Military Academy and Li Jishen. Li Jishen dispatches troops to take over the Henan area. Old clothes shops in Guangzhou and their business. Strike in Humen area and the solution. Some private schools prefer to stay open. | China | http://trove.nla.gov.au/newspaper/page/24101914 | 24101914 |
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]);