This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48147 | 48147 | 1929-06-01 | 2 | b | The key of politics relies on the administration of people, comments written by Wang Zhixian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48148 | 48148 | 1929-06-01 | 2 | b | A major earthquake may happen soon. | Britain | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48149 | 48149 | 1929-06-01 | 2 | c | Feng Yuxiang denies any collaboration with Soviet Russia. Liu Zhennian and his troops occupy Yantai, Shandong province. The Fourth Group Army surrender. Song Ziwen borrows more foreign loans. Jiang Jieshi appoints Chen Ce commander of the Fourth Fleet. Li Jishen is sleepless. Yang Sen is defeated by Liu Wenhui. Martial law enforced again in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48150 | 48150 | 1929-06-01 | 2 | d | Agreement on the relieve of Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48151 | 48151 | 1929-06-01 | 2 | d | Tang Shengzhi arrives Beijing secretly. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48152 | 48152 | 1929-06-01 | 2 | e | Twenty-two Communist students arrested in Fengyang county, north Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48153 | 48153 | 1929-06-01 | 2 | f | Feng Yuxiang urges Jiang Jieshi to come to Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48154 | 48154 | 1929-06-01 | 2 | f | Foreign missions in China protest against the search on board of foreign ships by Chinese authority. | China | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 |
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]);