This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21759 | 21759 | 1909-10-09 | 2 | a-b | Editorial claims that Confucius is founder of the state religion of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802352 | 26802352 | |
21760 | 21760 | 1909-10-09 | 2 | b-c | News in brief/ Board of Revenue to increase property and other taxes. Chinese ambassador to Japan Li Jiaju is returning. Agreement between China and Japan over the Jiandao island dispute. American Vice-President visits Beijing and meets Prince Regent. Another 42 Chinese students on the way to study in America. Preparation for the fair in Nanjing to be held next May. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802352 | 26802352 | |
21761 | 21761 | 1909-10-09 | 2 | c | A pamphlet from Hong Kong on the demarcation of Macao border. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802352 | 26802352 | |
21762 | 21762 | 1909-10-09 | 2 | c | Body of a white woman is found upstairs of a Chinese restaurant in New York; nine Chinese migrants in America have been murdered since the discovery. | America | http://trove.nla.gov.au/newspaper/page/26802352 | 26802352 | |
21763 | 21763 | 1909-10-09 | 2 | c-d | Beijing news/ Chinese ministry of foreign affairs forbids foreigners from interfering in local affairs. Ministry of civil affairs submits their budget report. Treaty between China and Japan on the Jiandao island dispute. Involvement of foreign loans in the railway construction in Hubei and Hunan province. | China | http://trove.nla.gov.au/newspaper/page/26802352 | 26802352 |
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]);