This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
14958 | 14958 | 1905-10-28 | 5 | a | Letters from Tung Wah readers from Queensland and New South Wales on the protest against American immigration policy. Names listed for individuals and shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800812 | 26800812 | |
14959 | 14959 | 1905-10-28 | 5 | a | Chinese communities in Geraldton of Western Australia, Newland of New South Wales, Bendigo of Victoria, Townsville of Queensland donate to the protest movement against American immigration policy that bans Chinese entry. Hundreds of names listed for individuals and shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800812 | 26800812 |
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]);