This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15538 | 15538 | 1906-04-07 | 2 | a-b | A petition from the Sydney Chinese Empire Reform Association to the five Chinese officials who are on overseas investigation for political reform. The petition also calls for power restoration to Emperor Guangxu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800945 | 26800945 | |
15551 | 15551 | 1906-04-07 | 5 | a-b | Representatives of Sydney Chinese communities meet the Governor of New South Wales for opium ban. They ask for a total ban following Victoria and South Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800949 | 26800949 |
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]);