This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34682 | 34682 | 1919-07-12 | 8 | a | Song Yimei, speaker of the provincial legislature, sues shareholders of the Guangzhou-Hankou railway. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097790 | 24097790 | |
34683 | 34683 | 1919-07-12 | 8 | b-c | Beijing news/ Students in Shandong province and their demonstration. Zhang Zongxiang and Cao Rulin after the students' demonstration nation-wide. Shops in Wuhu, Anhui province, refuse to sell Japanese goods. Chamber of commerce in Shanghai appeal for reconciliation between the south and the north. Delegates from the south and their demands for peace talks with the north. | China | http://trove.nla.gov.au/newspaper/page/24097790 | 24097790 | |
34684 | 34684 | 1919-07-12 | 8 | c-d | Guangdong news/ The provincial legislature assembly is yet to be opened. Song Yimei and Huang Songling in the provincial legislature assembly. Provincial government delays repayment to the Taiwan Bank. Guo Qinguang, a Guangdong student in Beijing, dies in the demonstration and the memorial service in Guangdong. Survey on foreign ships navigating inland. Rice shortage in Maoming and Dianbai counties. Robbery in Zengcheng county. | China | http://trove.nla.gov.au/newspaper/page/24097790 | 24097790 |
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]);