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 |
---|---|---|---|---|---|---|---|---|---|
54091 | 54091 | 1934-04-28 | 2 | b | China news/ Economic Committee of the central government in Nanjing passes resolutions to the loans from America, and Song Ziwen reports to the Committee the loans from America. Third part of the draft constitution of the Republic of China. Sun Dianying's troops are besieged. | China | http://trove.nla.gov.au/newspaper/page/24095994 | 24095994 | |
54092 | 54092 | 1934-04-28 | 3 | a | Japanese military existence in north China. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54093 | 54093 | 1934-04-28 | 3 | a | The war clouds over Japan and Russia. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54096 | 54096 | 1934-04-28 | 3 | e | Manchurian state challenges Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54098 | 54098 | 1934-04-28 | 3 | e | Japanese ambassador in China on the relations between the two countries. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54099 | 54099 | 1934-04-28 | 3 | f | Japanese help set up land administration office in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54100 | 54100 | 1934-04-28 | 5 | a | The bank set up by Manchurian state and its operations. | China | http://trove.nla.gov.au/newspaper/page/24095997 | 24095997 |
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]);