This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55953 | 55953 | 1936-04-11 | 2 | b | First part of a letter to the Chinese people from the Cultural Ministry of the Nanjing government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096808 | 24096808 | |
55954 | 55954 | 1936-04-11 | 2 | c | New arrangement on transportation in north China. Magistrate of Jinshan county in Jiangsu province believes superstition. The autonomous movement in Fujian province. Ponographic performance in Shanghai. Bai Chongxi in Guangxi talks to students. New enlistment system in China. Japanese make trouble in Fujian province. Russian communists in Manchuria. Japanese prevent Chinese from leaving Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096808 | 24096808 |
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]);