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 |
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]);