This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42995 | 42995 | 1925-04-11 | 7 | a | Three Chinese are arrested in Melbourne for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
42996 | 42996 | 1925-04-11 | 7 | a | Storm in Adelaide, South Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
42997 | 42997 | 1925-04-11 | 7 | a | A Chinese man in Cairns, Queensland, is penalised for selling opium. | Australia | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
42998 | 42998 | 1925-04-11 | 7 | a | Two Chinese are insulted in New Castle at mid-night. | Australia | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
42999 | 42999 | 1925-04-11 | 7 | a | Charity lottery tickets on sale: The Help for Consumptives Art Union. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43000 | 43000 | 1925-04-11 | 7 | a-b | Bandits rob a German tourist in Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43001 | 43001 | 1925-04-11 | 7 | b | Report on The Royal Agricultural Show at Moore Park, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43002 | 43002 | 1925-04-11 | 7 | b | Introduce the McNiven Brothers shop, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43003 | 43003 | 1925-04-11 | 7 | b | Introduce Briscoe & Co, Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43004 | 43004 | 1925-04-11 | 7 | b | Epidemic disease in New Zealand and the recent development. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43005 | 43005 | 1925-04-11 | 7 | b | A father in Wellington, New Zealand, murders his daughter. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43006 | 43006 | 1925-04-11 | 7 | c | A 14 year-old boy hangs himself in Auckland, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43007 | 43007 | 1925-04-11 | 7 | c | Earthquake in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43008 | 43008 | 1925-04-11 | 7 | c | Western missionaries are trapped in Shenqiu county, Henan province. | China | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43009 | 43009 | 1925-04-11 | 7 | c | Bandits in Guangdong and some high school students also joined. Women in Guangzhou are forced to join union. The war between Chen Jiongming and Sun Yatsen in Guangdong. Equity of man and woman in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 |
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]);