This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45675 | 45675 | 1927-04-30 | 8 | a-d | Guangdong news/ Deng Yanhua reports to Jiang Jieshi every day. Political parties in the Huangpu Military Academy. Sales of British and American tobaccos in Guangzhou and the negotiations. Tai Jitao on Japanese loans to the Nationalist government. Opening of the Pacific conference in Guangzhou. Post service in China and the charges. Protest in Guangzhou against land tax. Detention centre in Guangzhou and the report. Shoes shops are closed down in Guangzhou. Prisoners of war are to be trained in the Huangpu military academy. Gambling in Zhongshan county. | China | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 | |
45676 | 45676 | 1927-04-30 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 | |
45677 | 45677 | 1927-04-30 | 8 | e | Advertisement for The Commercial Banking Company of Sydney Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 | |
45678 | 45678 | 1927-04-30 | 8 | e | Advertisement for The Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 | |
45679 | 45679 | 1927-04-30 | 8 | f | Advertisement for Shanghai Cafe in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 |
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]);