This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47148 | 47148 | 1928-06-16 | 6 | a-d | Guangdong news/ Guangdong is raising funds for the Northern Expedition. Anti-Japanese movement in Guangzhou. Provincial government is purchasing weapons from overseas. Provincial government promotes local products. Municipal government promotes Chinese-style clothes. | China | http://trove.nla.gov.au/newspaper/page/24098846 | 24098846 | |
47149 | 47149 | 1928-06-16 | 7 | a-d | Guangdong news/ Yulin port to be built in the Hainan island. The Chinese Communist Party is to start uprising in Bao'an county. Magistrate of Dianbai county absconds with public funds. Zhongshan county magistrate Liang Hongguang disbands more than 60 trade unions. Civil corps in Zhongshan county. Defence troops in Dongguan county suppress peasant bandits. Sand land in Dongguan county. Robbery in Gaoyao county. The ceramic industry in Nanhai county. Bandits in Shunde hijack cargo ship. | China | http://trove.nla.gov.au/newspaper/page/24098845 | 24098845 |
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]);