This data as json, CSV (advanced)
Suggested facets: page
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39478 | 39478 | 1923-02-17 | 12 | a | Photograph of Moo Yeung Gateway of the Peiking City. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094305 | 24094305 | |
39479 | 39479 | 1923-02-17 | 12-13 | b | Editorial on the national unification and the New Year celebration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094305 | 24094305 | |
39480 | 39480 | 1923-02-17 | 12 | c | Advertisement for the Bank of New South Wales, George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094305 | 24094305 |
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]);