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 |
---|---|---|---|---|---|---|---|---|---|
49787 | 49787 | 1930-12-13 | 2 | c | Racial discrimination and anti-Chinese movement in Tamolipa, Mexico. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099878 | 24099878 | |
49796 | 49796 | 1930-12-13 | 3 | c | Journalists in Fuzhou make trouble in the headquarters of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24099877 | 24099877 | |
49807 | 49807 | 1930-12-13 | 8 | c | A ship sinks in the Yangtze River on its way from Shanghai to Changsha. | China | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49808 | 49808 | 1930-12-13 | 8 | c | Red rain in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49809 | 49809 | 1930-12-13 | 8 | c | Oil found in Taiwan. | Japan | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49810 | 49810 | 1930-12-13 | 8 | c | Japanese police raid smugglers of opium, cocaine and other drugs. | Japan | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49811 | 49811 | 1930-12-13 | 8 | c | Australia news/ Agricultural authority of NSW issues new regulations for tomato package and the Chinese translation. Australian government bars Italian immigrants from entry. Strike of the butchers in Sydney fails. The Communist organisations in New Zealand. Chinese who was robbed a few days ago dies of injury. Business depressed in Sydney and the hope of businessmen. Heavy rain burst the railway in Adelaide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 |
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]);