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 |
---|---|---|---|---|---|---|---|---|---|
49385 | 49385 | 1930-08-09 | 2 | c | Four men are walking around the world. | China | http://trove.nla.gov.au/newspaper/page/24099731 | 24099731 | |
49386 | 49386 | 1930-08-09 | 2 | c | Sericulture in Japan is unable to recover after a setback. | Japan | http://trove.nla.gov.au/newspaper/page/24099731 | 24099731 | |
49391 | 49391 | 1930-08-09 | 3 | c | Even Lamas in Outer Mongolia are involved in the communist propaganda. | China | http://trove.nla.gov.au/newspaper/page/24099730 | 24099730 | |
49399 | 49399 | 1930-08-09 | 8 | c | The Communist loot in Changsha, capital of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24099737 | 24099737 | |
49400 | 49400 | 1930-08-09 | 8 | c | Han Fuqu steps down after being defeated. | China | http://trove.nla.gov.au/newspaper/page/24099737 | 24099737 | |
49401 | 49401 | 1930-08-09 | 8 | c | Earthquake in the Black Sea. | Britain | http://trove.nla.gov.au/newspaper/page/24099737 | 24099737 | |
49402 | 49402 | 1930-08-09 | 8 | c | Nanjing government asks foreigners to leave Wuhan in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24099737 | 24099737 |
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]);