This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44250 | 44250 | 1925-12-12 | 7 | a | More Russian immigrants arrive Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 | |
44251 | 44251 | 1925-12-12 | 7 | a | British doctor suggest a change to men's clothes for the purpose of hygiene. | Britain | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 | |
44252 | 44252 | 1925-12-12 | 7 | a | Two Japanese and 21 Chinese gamblers are arrested in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 | |
44253 | 44253 | 1925-12-12 | 7 | a | An Australian woman and her daughter travel around the country by carriage. | Australia | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 | |
44254 | 44254 | 1925-12-12 | 7 | a-b | New South Wales authority to ban the sales of some foreign products and the response of Chinese Chamber of Commerce in Sydney, represented by Ye Tonggui, Liu Guangfu, Zhu Songqing and Ma Zanfen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 | |
44255 | 44255 | 1925-12-12 | 7 | b | Japan's policy in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 | |
44256 | 44256 | 1925-12-12 | 7 | c | Battles in north China (Zhang Zuolin, Wu Peifu, Li Jinglin, Sun Chuanfang and others). | China | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 | |
44257 | 44257 | 1925-12-12 | 7 | c | Japan is closely watching the situation in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 |
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]);