This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56332 | 56332 | 1936-10-17 | 3 | a | Resistance of Chinese troops in Manchuria to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 | |
56333 | 56333 | 1936-10-17 | 3 | a | Why Jiang Jieshi refuses to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 | |
56334 | 56334 | 1936-10-17 | 3 | c | Hitler awards medal to Japanese delegation. | Germany | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 | |
56335 | 56335 | 1936-10-17 | 3 | c | League of Nations to convene an international economic conference. | Other... | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 | |
56336 | 56336 | 1936-10-17 | 3 | d | The Chinese community in San Francisco issues circular telegram calling for resistance to Japanese invasion. | America | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 | |
56337 | 56337 | 1936-10-17 | 3 | e | A telegram from Fang Zhenwu to Cai Tingkai. | China | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 | |
56338 | 56338 | 1936-10-17 | 3 | e | The Chinese Chamber of Commerce in New South Wales to increase its membership fees and the notice. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 |
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]);