This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38119 | 38119 | 1922-01-07 | 8 | a | Second part of an article on Japanese aggressive ambitions overseas and the awakening of Chinese nation, written by Liu Shimu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093821 | 24093821 | |
38120 | 38120 | 1922-01-07 | 8 | a-b | Guangdong news/ Further report on the backgrounds of the new county magistrates recently elected by the people in Guangdong. Sun Yatsen is planning to move his presidential office to Guilin in Guangxi province. Members of the provincial legislature assembly demand reimbursement from the financial department. Proposed administrative structure at the county level. Road Administrative Office to be disbanded. Negotiation between China and Portugal on the Macao dispute. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093821 | 24093821 | |
38121 | 38121 | 1922-01-07 | 8 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093821 | 24093821 | |
38122 | 38122 | 1922-01-07 | 8 | c-d | Advertisement for Zam-Buk, Proprietors, C. E. Fulford Australia Ltd, A. S. Watson & Co, Hong Kong, Shanghai, Maynard & Co, Battery Road, Singapore. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093821 | 24093821 | |
38123 | 38123 | 1922-01-07 | 8 | c | Advertisement for David Dudley, Men's Quality Boots, 474 George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093821 | 24093821 | |
38124 | 38124 | 1922-01-07 | 8 | e | Advertisement for Hop Lee & Co, Wholesale fruit and produce, Merchants and General Commission Agents, 8 Municipal Building, Ultimo Road, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093821 | 24093821 |
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]);