This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56480 | 56480 | 1936-12-12 | 2 | b | Editorial calls for saving of the peace. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097093 | 24097093 | |
56481 | 56481 | 1936-12-12 | 2 | c | China news/ Birthday celebration in Nanjing for Jiang Jieshi. Duan Qirui dies in Shanghai and his will. Foreign minister Zhang Qun meets Japanese envoy in Nanjing. More than 200 Japanese soldiers are deserted. Song Zheyuan seeks to resign as governor of Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24097093 | 24097093 |
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]);