This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21526 | 21526 | 1909-08-21 | 6 | a | First part of a report submitted by Sun Baoqi on political reform and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802300 | 26802300 | |
21532 | 21532 | 1909-08-21 | 7 | a | Chinese communities in Sydney and Brisbane send telegram to governor general of Guangdong, Chinese government in Beijing and its envoy on the issue of border demarcation in Macao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802299 | 26802299 | |
21533 | 21533 | 1909-08-21 | 7 | a | Prime Minister Alfred Deakin discusses in Melbourne with state premiers the relationship between the state and the Commonwealth governments. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802299 | 26802299 | |
21534 | 21534 | 1909-08-21 | 7 | a | British women are trying to secure support from Australia in their fight for the right to vote. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802299 | 26802299 |
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]);