This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38183 | 38183 | 1922-01-21 | 8 | a-b | Ninth part of the true report to the overseas Chinese communities on the current situations in China, written by Liu Shimu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093836 | 24093836 | |
38184 | 38184 | 1922-01-21 | 8 | b-c | Guangdong news/ Provincial authority prepares for a budget for the New Year. Military headquarters in Guangzhou urges county magistrates to pay their due contributions. Mandarin language will be used in all primary and secondary schools of Guangzhou from next semester. Suffering of Xiangshan people from the Portuguese authority in Macao. A young girl in Guangzhou beats back hooligans. Rice price in Gaoyao and countermeasures of the new county magistrate. A widow in Huaxian county and her story. Bandits in Enping county rape and kill a young woman. Chinese community in St Louis, America, makes a huge cake and presents it to Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093836 | 24093836 | |
38185 | 38185 | 1922-01-21 | 8 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093836 | 24093836 | |
38186 | 38186 | 1922-01-21 | 8 | e | English teacher is wanted for two Chinese students in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093836 | 24093836 | |
38187 | 38187 | 1922-01-21 | 8 | e | Advertisement for English class at the Church of England Chinese Mission, Christ Church School Hall, Pitt Street, Sydney (Opposite to Central Railway Station). People to contact: Rev. Ye Huilu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093836 | 24093836 |
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]);