This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
45547 | 45547 | 1927-03-12 | 7 | c | A wonderful advertisement by a French cosmetics company in Paris. | France | 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 |
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]);