This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39179 | 39179 | 1922-12-23 | 6 | a | Yu Wenhou on road construction in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094232 | 24094232 | |
39183 | 39183 | 1922-12-23 | 7 | a | Prime Minister Billy Hughes sues Sydney Daily Mail for defamation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39184 | 39184 | 1922-12-23 | 7 | a | A case of manslaughter in Goulburn, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39185 | 39185 | 1922-12-23 | 7 | a | A shoe factory in Redfern, Sydney, is on fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39186 | 39186 | 1922-12-23 | 7 | a | Former secretary of the Sydney zhi gong tang Yang Du is sentenced to two years' imprisonment for embezzlement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39187 | 39187 | 1922-12-23 | 7 | a | A ban robber in America. | America | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39190 | 39190 | 1922-12-23 | 8 | a | Poems by Shouzhen and Miusheng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094234 | 24094234 |
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]);