This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51534 | 51534 | 1932-05-21 | 2 | a | Chinese passengers write in praise of services on aboard of liner Changte. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 | |
51535 | 51535 | 1932-05-21 | 2 | a | Second part of an open letter from a students' association in China to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 | |
51536 | 51536 | 1932-05-21 | 2 | d | Chinese National Crisis Association (guo nan hui) issues an open letter to the army officers and soldiers. | China | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 | |
51537 | 51537 | 1932-05-21 | 2 | d | Japanese foreign minister says they would not give up Manchuria. | France | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 | |
51538 | 51538 | 1932-05-21 | 2 | e | First part of a telegram from Ma Zhanshan to the delegation of the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 | |
51539 | 51539 | 1932-05-21 | 2 | e | Chinese businessman in San Francisco Zhou Song offers millions of dollars donation to the Chinese war of resistance to Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 | |
51540 | 51540 | 1932-05-21 | 2 | f | Resistance to Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090808 | 24090808 |
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]);