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 |
---|---|---|---|---|---|---|---|---|---|
46494 | 46494 | 1927-12-03 | 2 | b-c | Editorial by Tung Wah Times on the pains of Chinese peasants (farmers). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098616 | 24098616 | |
46522 | 46522 | 1927-12-03 | 7 | a | A notice issued by the Chinese Chamber of Commerce in Sydney on illegal Chinese immigrants and their deportation from Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098619 | 24098619 | |
46523 | 46523 | 1927-12-03 | 7 | a | Australia news/ The unemployment under the new state government in New South Wales. Ticket prices going up for train and trams in Sydney. Jeweller dies with his treasurer while on board of ferry Greycliffe. A young artist commit suicide in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098619 | 24098619 | |
46526 | 46526 | 1927-12-03 | 8 | e | Advertisement for G. Chew Lee & Company Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098622 | 24098622 |
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]);