This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56346 | 56346 | 1936-10-24 | 2 | b | China news/ Japanese military policeman in Hankou are killed. Japanese soldiers in Shanghai. Guangdong troops in Hankou have a car accident. Li Zongren talks about peace in Guangxi. Wong Zhaoyuan is determined to protect the Chinese territory. | China | http://trove.nla.gov.au/newspaper/page/24097036 | 24097036 | |
56348 | 56348 | 1936-10-24 | 3 | a | Chinese troops in Manchuria form an alliance on the fifth anniversary of Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097035 | 24097035 | |
56353 | 56353 | 1936-10-24 | 6-7 | a-d | Guangdong news/ Jiang Jieshi seeks to control the 19th Route Army. Jiang Jieshi accepts the requests of Guangxi authority to fight Japanese invaders. Li Zongren and Huang Xuchu arrive Guangzhou. Teachers and students in Guangzhou present their petition to the government. Sales and monopoly of tobacco products in Guangdong. Railway project from Guangzhou to Shantou. The command of Guangxi troops has been finalised. Turbulence in the schools in Zhongshan county. The ban of gambling in Shunde county. | China | http://trove.nla.gov.au/newspaper/page/24097040 | 24097040 | |
56358 | 56358 | 1936-10-24 | 8 | e | Students in Beijing and their demonstration against the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 |
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]);