This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43979 | 43979 | 1925-10-10 | 8 | a | Chinese communities in Sydney donate to the unemployed workers in Shanghai. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101312 | 24101312 | |
43980 | 43980 | 1925-10-10 | 8 | a-d | Guangdong news/ Guangzhou authority asks Russian to draft communist manifesto. Communists in Guangzhou and their targets for recruitment. Trade union pickets in Guangzhou detains residents. Business in Guangzhou and the restrictions. People in Zengcheng county plead for the end of war. Agricultural production is reduced due to the flood. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101312 | 24101312 | |
43981 | 43981 | 1925-10-10 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101312 | 24101312 | |
43982 | 43982 | 1925-10-10 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101312 | 24101312 |
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]);