This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26131 | 26131 | 1912-05-11 | 6 | a-b | Counsellor Huang's diplomatic documentation | Counsellor Huang's negotiation with Australian premier and the foreign minister. The new regulations to Chinese businessmen, students and labourers are designated by Australian government, which treats Chinese equally with all European people. | Australia | http://trove.nla.gov.au/newspaper/page/24092236 | 24092236 |
26132 | 26132 | 1912-05-11 | 6 | b-c | State affairs in Beijing | Content of Beijing government conference. Beijing views Nanjing lower house as an obstacle and wants to dissolve it. Beijing government embraces both previous and new officials. | China | http://trove.nla.gov.au/newspaper/page/24092236 | 24092236 |
26133 | 26133 | 1912-05-11 | 6 | c | Notice of donations | Name list of donators for Anhui and Lianghu floods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092236 | 24092236 |
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]);