This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53400 | 53400 | 1933-10-14 | 7-8 | a-f | Guangdong news/ Zou Lu to visit Nanyang for the Party organisation issues. Communist troops in north Fujian. Two airports in Guangzhou are named. Huang Zhiwen urges to organise mass associations to fight the Communists. Loans from Guangdong to the Central Government. Business in Hong Kong is recovering. Homeless people in Guangzhou. Fluctuation of rice prices in Guangzhou. The Ghost Festival in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091401 | 24091401 |
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]);