This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17368 | 17368 | 1907-05-04 | 2 | a-b | Editorial. History of communication between China and Europe. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801316 | 26801316 | |
17372 | 17372 | 1907-05-04 | 3 | a-b | Guangdong news. Chinese central government requires local authorities to carefully select talents to deal with foreign affairs. Governor Zhou Fu bans rice exports from Guangdong in order to stabilise the market. Guangdong schools call for donations to famine victims in north Anhui province. New magistrate of Xiangshan county sets up telephone line in the office. Guangzhou to reform police school. Girl student Zhang Huizhen is refused to enrol in a teachers' school. Guangzhou sets up new office to manage the market. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801315 | 26801315 | |
17383 | 17383 | 1907-05-04 | 6 | a-b | Fiction. Fraud. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801320 | 26801320 | |
17391 | 17391 | 1907-05-04 | 7 | a-b | Commonwealth government of Australia to administer the Northern Territory directly. There are now 1100 Chinese and 868 white men in the territory. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801319 | 26801319 |
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]);