This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45529 | 45529 | 1927-03-05 | 8 | a-d | Guangdong news/ Li Fulin personally leads his troops to attack Yunnan province. Saint Heart School in Guangzhou is required to teach the Three People's Principles (Nationalism, Democracy and the People's Livelihood) and resistance. University of Hong Kong to teach Chinese literature. People are frozen to death in Guangzhou. The kidnap of Liang Peiji and the investigation. Racing course to be built in Guangzhou. Peasants' association in Dongguan county detains the government officials. Kidnap in Xiangshan county. Land Bureau on the amount of tax to be collected. Bandits in the Beijiang area. | China | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
45530 | 45530 | 1927-03-05 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
45531 | 45531 | 1927-03-05 | 8 | e | Advertisement for the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
45532 | 45532 | 1927-03-05 | 8 | f | Advertisement for Shanghai Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
45533 | 45533 | 1927-03-05 | 8 | f | Advertisement for Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 |
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]);