This data as json, CSV (advanced)
Suggested facets: page, title, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25919 | 25919 | 1912-03-23 | 7 | b-c | Overseas Chinese in Sydney donate for the revolutionary army | Chinese people in Sydney donate to the revolutionary army in China; names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092177 | 24092177 |
25920 | 25920 | 1912-03-23 | 8 | a | Donations are called for the expansion of Xiangshan Dongxiang Charity building | Xiangshan Dongxiang Charity offers helps to people in need of medical care, emergency relief and others. Donations are called for its business expansion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092180 | 24092180 |
25921 | 25921 | 1912-03-23 | 8 | a-b | Miscellany of constitutions in democratic countries (to be continued) | Provisions of French constitution related to election and functions of the upper house. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092180 | 24092180 |
25924 | 25924 | 1912-03-23 | 8 | c-d | Donation advertisement | Donations for the revolutionary army in China; names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092180 | 24092180 |
25927 | 25927 | 1912-03-23 | 8 | a-d | Overseas Chinese in Sydney donate for the revolutionary army | Donations for the military government are called for and names of donators are listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092180 | 24092180 |
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]);