This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43870 | 43870 | 1925-09-19 | 8 | a | Chinese community in Sydney donates to the unemployed and victims of the May 30 massacre in Shanghai. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101288 | 24101288 | |
43871 | 43871 | 1925-09-19 | 8 | b-c | Guangdong news/ Hu Qingrui and the anti-communist sentiment in Guangzhou. War clouds in Guangzhou. Russian in Guangdong and their involvement of Chinese communist movement. Social security in Xiangshan county. Bandits and robbery in Xiangshan county. Typhoon and heavy rain in Guangzhou and Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101288 | 24101288 | |
43872 | 43872 | 1925-09-19 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101288 | 24101288 | |
43873 | 43873 | 1925-09-19 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101288 | 24101288 |
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]);