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 |
---|---|---|---|---|---|---|---|---|---|
46716 | 46716 | 1928-02-11 | 2 | b | Editorial on the rebellions in China and the peace effort. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098688 | 24098688 | |
46740 | 46740 | 1928-02-11 | 5 | d | Advertisement for Reo Motors Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
46741 | 46741 | 1928-02-11 | 7 | a | Australia news/ Chinese kitchen hand is killed in Newcastle. Ferry stops travelling to Parramatta. A tea party at the lian yi tang, association in Sydney of the Dongguan and Zengcheng fellows, and speakers include Zhu Songqing, Ye Bingnan, Guo Jiexiu, Ye Guo'en, Li Run, Chen Qin, and others. Insurance industry in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098691 | 24098691 | |
46742 | 46742 | 1928-02-11 | 7 | b-c | A woman in strange pregnancy. Dead boy walks. Wife for lease in Gansu province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098691 | 24098691 |
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]);