This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36960 | 36960 | 1921-05-14 | 2 | b-c | An order issued by President Xu Shichang on April 3. | China | http://trove.nla.gov.au/newspaper/page/24093541 | 24093541 | |
36966 | 36966 | 1921-05-14 | 3 | b-c | More than 500 women in Guangzhou fight for their rights to vote and their demonstration at the provincial legislature assembly. | China | http://trove.nla.gov.au/newspaper/page/24093540 | 24093540 | |
36973 | 36973 | 1921-05-14 | 6 | a | Story after the assassination of Wang Wenhua, military commander in Guizhou. | China | http://trove.nla.gov.au/newspaper/page/24093545 | 24093545 | |
36974 | 36974 | 1921-05-14 | 6 | a-b | second and final part of report on a family tragedy in Harbin, Jilin province, in which two brothers, Cao Peixiong and Cao Peiyuan, murder their parents, Cao Zhigang and his wife. | China | http://trove.nla.gov.au/newspaper/page/24093545 | 24093545 | |
36975 | 36975 | 1921-05-14 | 6 | b | A circular telegram issued by Lu Tao and Ren Kecheng. | China | http://trove.nla.gov.au/newspaper/page/24093545 | 24093545 | |
36983 | 36983 | 1921-05-14 | 7 | a | Sun Yatsen talks national unification, local self-government and cooperation with foreign countries. | China | http://trove.nla.gov.au/newspaper/page/24093544 | 24093544 | |
36989 | 36989 | 1921-05-14 | 8 | a-c | Guangdong news/ Guangzhou people gather and request to drive Chen Duxiu out of Guangdong. Such calls also from Guangdong businessmen in Shanghai and Hong Kong, and the provincial legislature assembly. How Sun Yatsen is elected president by the upper and lower houses in Guangzhou. Sun Yatsen suggests to borrow huge amount of loans from foreign sources. Suggestion to change the name of Guangzhou. Provincial authority to set up a public university in Guangzhou. Police in Guangzhou harass peddlers. The provincial bank is going to bankruptcy. | China | http://trove.nla.gov.au/newspaper/page/24093546 | 24093546 |
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]);