This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15785 | 15785 | 1906-06-16 | 2 | a-b | A report, submitted by the four Chinese officials after their overseas tour, proposes to implement constitutionalism as the basis for further political reform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801005 | 26801005 | |
15800 | 15800 | 1906-06-16 | 5 | a-b | Preparation of the railway project from Hankou to Guangzhou. Report on the homeless Chinese after the earthquake in San Francisco and donations to them. Excessive rains in Guangdong and flooding. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801009 | 26801009 | |
15806 | 15806 | 1906-06-16 | 6 | a-b | City council of Ashfield, Sydney, holds a meeting on immigration policy and suggests increasing the number of immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 |
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]);