This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56430 | 56430 | 1936-11-21 | 2 | b | A declaration jointly issued by 77 school teachers in north China to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097068 | 24097068 | |
56431 | 56431 | 1936-11-21 | 2 | c | General Cai Tingkai in Wuzhou, of Guangxi province, and his talks. | China | http://trove.nla.gov.au/newspaper/page/24097068 | 24097068 | |
56432 | 56432 | 1936-11-21 | 2 | d | Envoy of Japanese government to meet Jiang Jieshi in Nanjing. Determination of the civil people in north China to resist Japanese invasion. Zhang Xueliang talks to British journalists on the resistance to Japanese invasion. Japanese have recruited many traitors in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097068 | 24097068 |
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]);