This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50031 | 50031 | 1931-02-28 | 2 | b | First part of editorial on the American loans to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090292 | 24090292 | |
50040 | 50040 | 1931-02-28 | 5 | d | Article written by Chen Zhenxiang farewells the evil of war on the New Year occasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090293 | 24090293 | |
50041 | 50041 | 1931-02-28 | 5 | e | Different names for concubine. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090293 | 24090293 | |
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]);