This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48915 | 48915 | 1930-03-01 | 2 | b | Chinese army commander Lieutenant General Han Guangdi dies for the country during the military clash with Russian and his photograph. The Northeastern Political Council finalises pension plans to the martyrs' families. | China | http://trove.nla.gov.au/newspaper/page/24099543 | 24099543 | |
48916 | 48916 | 1930-03-01 | 2 | d | Talks between China and Russia is postponed. | China | http://trove.nla.gov.au/newspaper/page/24099543 | 24099543 | |
48917 | 48917 | 1930-03-01 | 2 | d | Yan Xishan and Zhang Xueliang will help each other. | China | http://trove.nla.gov.au/newspaper/page/24099543 | 24099543 | |
48918 | 48918 | 1930-03-01 | 2 | e | Li Houji returns to bury his mother in his home village near Xuzhou, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24099543 | 24099543 | |
48919 | 48919 | 1930-03-01 | 2 | e | Foreign visitors on the railway operations in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099543 | 24099543 | |
48920 | 48920 | 1930-03-01 | 2 | f | A recent survey on foreigners in China and their original countries. | China | http://trove.nla.gov.au/newspaper/page/24099543 | 24099543 | |
48921 | 48921 | 1930-03-01 | 2 | f | Japan's new China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24099543 | 24099543 | |
48922 | 48922 | 1930-03-01 | 2 | f | Chinese navy in Shanghai fight pirates. | China | http://trove.nla.gov.au/newspaper/page/24099543 | 24099543 |
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]);