This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47553 | 47553 | 1928-11-03 | 8 | a | The Nationalist government in Nanjing engages German military adviser. | China | http://trove.nla.gov.au/newspaper/page/24099008 | 24099008 | |
47554 | 47554 | 1928-11-03 | 8 | a | Chinese student in London murders his wife. | Britain | http://trove.nla.gov.au/newspaper/page/24099008 | 24099008 | |
47555 | 47555 | 1928-11-03 | 8 | a-c | Australia news/ Thief arrested in Sydney. Italian consul asks for protection of Italian immigrants in Australia. Bomb explosion in an Italian residence in Sydney. Japanese purchase iron from Australia. White women are charged with wandering. The half-breed woman who murders her Chinese husband in on bail. Fire in Melbourne dockyard. White woman is sentenced for theft. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099008 | 24099008 | |
47556 | 47556 | 1928-11-03 | 8 | c | Book is available from Tung Wah Times on the National Day celebration and the birthday celebration of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099008 | 24099008 |
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]);