This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46999 | 46999 | 1928-05-05 | 3 | b | Guangdong asks the Nanjing government to arrest Li Hanhun. | China | http://trove.nla.gov.au/newspaper/page/24098793 | 24098793 | |
47000 | 47000 | 1928-05-05 | 3 | b | Xia Douyan plans a mutiny in Xuzhou, north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24098793 | 24098793 | |
47001 | 47001 | 1928-05-05 | 3 | b | Qian Dajun leads his army to enter Longhua and Xiong Shihui is appointed new mission. | China | http://trove.nla.gov.au/newspaper/page/24098793 | 24098793 | |
47002 | 47002 | 1928-05-05 | 3 | c | Foreign Investment Bureau (zhao shang ju) initiates reform under the control of the Ministry of Transportation of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24098793 | 24098793 | |
47003 | 47003 | 1928-05-05 | 3 | d | Anti-Japanese movement in Xiamen, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24098793 | 24098793 | |
47004 | 47004 | 1928-05-05 | 3 | e | Opium smuggling in Hankou and the fighting. | China | http://trove.nla.gov.au/newspaper/page/24098793 | 24098793 | |
47005 | 47005 | 1928-05-05 | 3 | a-c | Advertisement for the Assurance Homes of Australia Ltd in Sydney and its Chinese representative L. War Nock (Lu Huayue). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098793 | 24098793 |
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]);