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 |
---|---|---|---|---|---|---|---|---|---|
48259 | 48259 | 1929-07-06 | 3 | a | Nanjing government raises funds by issue of bonds. | China | http://trove.nla.gov.au/newspaper/page/24099271 | 24099271 | |
48260 | 48260 | 1929-07-06 | 3 | a | Suffering of the people in the west of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24099271 | 24099271 | |
48264 | 48264 | 1929-07-06 | 5 | a | Hong Kong news/ Water shortage worsening in Hong Kong. Liang Zhihong, principal of the girl school in Guangzhou, is going overseas. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099273 | 24099273 | |
48267 | 48267 | 1929-07-06 | 8 | a | Japanese cabinet resigns. | Japan | http://trove.nla.gov.au/newspaper/page/24099278 | 24099278 | |
48268 | 48268 | 1929-07-06 | 8 | a | Chinese government engages British officers to train the naval forces. | China | http://trove.nla.gov.au/newspaper/page/24099278 | 24099278 | |
48269 | 48269 | 1929-07-06 | 8 | a | Amount of loans from America. | America | http://trove.nla.gov.au/newspaper/page/24099278 | 24099278 | |
48270 | 48270 | 1929-07-06 | 8 | a | Australia news/ Jewellery thief caught in Sydney. Robbery in Lismore. Australia import coal from Britain. Father in Sydney commits incest and is punished. Population increase in Australia and a new census. Swiss ship sinks in storm. Two girls from Goulburn are walking to Melbourne. Redundancy of the federal government in order to reduce expenses. Chinese man in Sydney injured in a traffic accident. A nurse in Sydney hospital sees a ghost. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099278 | 24099278 |
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]);