This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36066 | 36066 | 1920-08-28 | 8 | a | A letter from the Chinese Scientific Association to the Young Chinese Association of Australia in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098290 | 24098290 | |
36067 | 36067 | 1920-08-28 | 8 | a | The ren xin bao (People's Conscientiousness Paper) in Shanghai seeks contributors and its notice. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098290 | 24098290 | |
36068 | 36068 | 1920-08-28 | 8 | b-c | Guangdong news/ Rumours in Guangzhou on revolution. Social security in Xiangshan county. He Kefu organises rebellion in Shunde county. Rains in the Dongjiang area. Spies for the government on revolutionary movement. Security in the Buddha Mountain (guan yin shan). Some Guangxi troops are on their way to Guangdong. Social security in local counties. | China | http://trove.nla.gov.au/newspaper/page/24098290 | 24098290 | |
36069 | 36069 | 1920-08-28 | 8 | c | Farewell message by Zhu Liguang on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098290 | 24098290 |
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]);