This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51115 | 51115 | 1932-01-30 | 2 | c | A recent talk by Wu Zhihui. | China | http://trove.nla.gov.au/newspaper/page/24090678 | 24090678 | |
51122 | 51122 | 1932-01-30 | 3 | c | Miscellaneous report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090677 | 24090677 | |
51125 | 51125 | 1932-01-30 | 5 | c | Article written by Gong Ziyang mourns the northeast of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090679 | 24090679 | |
51128 | 51128 | 1932-01-30 | 6 | c | Guangdong news/ A meeting of the provincial government. Police in Guangzhou disband the Association of Resistance to Japanese Invasion. Communist members are arrested in Guangzhou and Shenzhen. The Communists in Guangdong. Temporary arsenal in Tangjiawan, Zhongshan county. | China | http://trove.nla.gov.au/newspaper/page/24090682 | 24090682 | |
51130 | 51130 | 1932-01-30 | 7 | c | Students in Wuhan to have a general demonstration. | China | http://trove.nla.gov.au/newspaper/page/24090681 | 24090681 | |
51138 | 51138 | 1932-01-30 | 8 | c | Prisoners in America try to escape but fail. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51141 | 51141 | 1932-01-30 | 8 | c | Chinese troops in Shanghai prepare for war. | China | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51142 | 51142 | 1932-01-30 | 8 | c | American government to expand their naval forces. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51143 | 51143 | 1932-01-30 | 8 | c | Japanese delegates to the League of Nations defend their invasion of Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 |
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]);