This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42933 | 42933 | 1925-03-28 | 8 | a-d | Guangdong news/ Hu Hanmin borrows loans from Japan. Sun Yatsen's government and their censorship on freedom of speech. Hu Sishun orders his troops back from Dongjiang. Li Jishen sends his troops to collect levy. Han Youze declines to the post of magistrate in Boluo county. More Sun Yatsen's soldier desert. People in Xiangshan county complains the local bureaucracy. Robbery in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101084 | 24101084 | |
42934 | 42934 | 1925-03-28 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101084 | 24101084 | |
42935 | 42935 | 1925-03-28 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101084 | 24101084 |
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]);