This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54748 | 54748 | 1934-12-22 | 2 | a | Notice issued by the Chinese Chamber of Commerce in NSW. Notice issued by Ye Bingnan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096271 | 24096271 | |
54749 | 54749 | 1934-12-22 | 2 | a | Government troops pursue the communist troops into Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24096271 | 24096271 | |
54750 | 54750 | 1934-12-22 | 2 | c | Jiang Jieshi's train is bombed and the report. Japanese troops invade Rehe province in north China. Financial situation is recovering in north China. Japanese plan to control the Manchuria. Wang Shuchang entertains Mongolian royalties. Police in Tangshan, Hebei province, smash the communist offices. | China | http://trove.nla.gov.au/newspaper/page/24096271 | 24096271 |
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]);