This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36817 | 36817 | 1921-04-02 | 8 | a | Chinese community in Cairns, Queensland, gathers to support the China-Australia Mail Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093499 | 24093499 | |
36818 | 36818 | 1921-04-02 | 8 | a-b | A poem by Song Qing on the shipping competition. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093499 | 24093499 | |
36819 | 36819 | 1921-04-02 | 8 | b | Guangdong news/ Fighting in Guangzhou for the position of the head of public security bureau. Memorial meeting to be held for the officers and soldiers of Guangdong army who were killed in the battle. Guangdong military government declares to take over the customs administration and its aftermath. Banditry in Huiyang, Boluo, Zengcheng and Longmen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093499 | 24093499 | |
36820 | 36820 | 1921-04-02 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093499 | 24093499 |
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]);