This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48244 | 48244 | 1929-06-29 | 8 | a | Arsenal of the Guangdong army on fire. | China | http://trove.nla.gov.au/newspaper/page/24099270 | 24099270 | |
48245 | 48245 | 1929-06-29 | 8 | a | Foreign visitor on the famine in Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24099270 | 24099270 | |
48246 | 48246 | 1929-06-29 | 8 | a-c | Australia news/ Residents in Yass, New South Wales, protest against the plan of co-education for white and aboriginal children. A man in Sydney is sentenced to one year's prison for opium smuggling. Solution to the timbers' strike in Melbourne. Sydney students return with smallpox after tour to America. Former Chinese consul-general in Australia Wei Zijing is appointed ambassador to Peru. Federal government issues their budget. A burglary in Sydney. Police in Sydney raid Chinese opium den. Earthquake in New Zealand. A man is detained in Darlinghurst, Sydney, for pretending to be woman. A train accident in the Northshore claims a life. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099270 | 24099270 | |
48247 | 48247 | 1929-06-29 | 8 | d | Advertisement for the Fowler's Moter College, a driving school in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099270 | 24099270 | |
48248 | 48248 | 1929-06-29 | 8 | d | Advertisement for The Sun Company in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099270 | 24099270 | |
48249 | 48249 | 1929-06-29 | 8 | d | Advertisement for Swiss Studio, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099270 | 24099270 | |
48250 | 48250 | 1929-06-29 | 8 | d | Advertisement for Valvoline, J. Carrigan, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099270 | 24099270 | |
48251 | 48251 | 1929-06-29 | 8 | e | Advertisement for Allen & Hanburys (Australasia) Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099270 | 24099270 |
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]);