This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48008 | 48008 | 1929-04-13 | 8 | a | Troops from Nanjing attack Hankou and the report, and the first battle ends. | China | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48009 | 48009 | 1929-04-13 | 8 | a | American businessmen on the development of aviation industry in China. | America | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48010 | 48010 | 1929-04-13 | 8 | a | Communist members arrested in Romania. | Britain | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48011 | 48011 | 1929-04-13 | 8 | a | The world of bandits in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48012 | 48012 | 1929-04-13 | 8 | b | Bomb explodes in the parliament in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48013 | 48013 | 1929-04-13 | 8 | b | Bandits in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48014 | 48014 | 1929-04-13 | 8 | b | Australia news/ Storm in Tasmania and the damages. Strike of the timber workers in Sydney turns into violence. Chinese Chamber of Commerce acknowledges receipt of donations to the famine victims in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48015 | 48015 | 1929-04-13 | 8 | d | The Dongguan gong yi tang in Sydney acknowledges receipt of donations to the hospital in their hometown. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 |
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]);