This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50043 | 50043 | 1931-02-28 | 8 | a | American senate on the economic recession. | America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50044 | 50044 | 1931-02-28 | 8 | a | Chinese communities in American on the loans to the Chinese government. | America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50045 | 50045 | 1931-02-28 | 8 | a | Disputes between Soviet Russia and Japan over the fishing fields. | Japan | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50046 | 50046 | 1931-02-28 | 8 | b | An old couple in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50047 | 50047 | 1931-02-28 | 8 | b | Explosion of a coal mine in Germany claims many lives. | Germany | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50048 | 50048 | 1931-02-28 | 8 | b | Russian troops on the border of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50049 | 50049 | 1931-02-28 | 8 | b | Prince of Britain continues his tour in South America. | South America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50050 | 50050 | 1931-02-28 | 8 | b | Famine in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50051 | 50051 | 1931-02-28 | 8 | b | More riots in Burma. | Other... | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50052 | 50052 | 1931-02-28 | 8 | c | Australia news/ A picnic organised by the hong men zhi gong tang in Sydney and speakers include Gui Zhi, Yu junxian, Huang Zhu, Ling Su'an. and others. Birthday celebration for Ma Xinsi in Sydney organised by his son Ma Lianghua and attendants include Liu Guangfu, Zhu Songqing, Ouyang Nan, Li Shurong, Xiao Daoming, Dong Zhi, Ma Meichu, and others. Police man is charged with injury in Sydney. Pedlars in Fiji refuses to use Australia money. Floods in Fiji. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 |
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]);