This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50208 | 50208 | 1931-04-18 | 8 | b | Brother of Emperor of Japan escapes from an attack on his arrival in New York. | America | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50209 | 50209 | 1931-04-18 | 8 | b | Portuguese government denies any riots. | Other... | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50210 | 50210 | 1931-04-18 | 8 | b | Russian authority banishes farmers. | Russia | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50211 | 50211 | 1931-04-18 | 8 | b | New orders issued by the Comintern (Third International). | Britain | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50212 | 50212 | 1931-04-18 | 8 | b | Statistics on robberies and thefts in New York. | America | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50213 | 50213 | 1931-04-18 | 8 | c | Japanese prime minister resigns. | Japan | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50214 | 50214 | 1931-04-18 | 8 | c | Dog racing association sues Shanghai municipal government. | China | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50215 | 50215 | 1931-04-18 | 8 | c | Progress of democracy in Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50216 | 50216 | 1931-04-18 | 8 | c | Australia news/ A lawyer in Sydney is charged. Income of the Royal Agricultural Show decreases in Sydney. Ling Su'an, chief editor of Gong Bao, is returning to China and a farewell party at the zhi gong tang in Sydney. Result of the board election of the Chinese Chamber of Commerce in Sydney. Jockey injured during a horse racing in Sydney. Two people die in a plane accident in Sydney. Chinese Consul-General in Australia Gui Zhi entertains Lin Sen, Chairman of the Chinese Legislative Council, and Chen Yanyuan, chairman of the Overseas Chinese Commission. Opium smuggler detained in Sydney. Federal government sues the NSW state government for debt repudiation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50217 | 50217 | 1931-04-18 | 8 | e | Notice issued by Gui Zhi, Chinese Consul-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 |
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]);