This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45534 | 45534 | 1927-03-12 | 2 | c | Editorial by Tung Wah Times on the petition presented by the Guangdong businessmen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45543 | 45543 | 1927-03-12 | 3 | e-f | A notice on shareholders' meeting of the Zhenguang China Company Ltd in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45545 | 45545 | 1927-03-12 | 7 | a-b | Australia news/ Cost of haircut for women in Sydney. Liner Zhangde (Changte) arrives Sydney. News from Solomon islands. Investigation on the bomb explosion in Redfern, Sydney. Artist performers come from China organised by Huang Guangzhao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45546 | 45546 | 1927-03-12 | 7 | b-c | The highest building, the oldest man and the biggest boy in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45548 | 45548 | 1927-03-12 | 7 | c | A notice by the Oriental Arts Company Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45549 | 45549 | 1927-03-12 | 7 | d | Names listed for donations to the Dongguan hospital. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45551 | 45551 | 1927-03-12 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101914 | 24101914 |
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]);