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 |
---|---|---|---|---|---|---|---|---|---|
3482 | 3482 | 1899-09-06 | 3 | a | A proposal to set up a charity in the Chinese community of Australia. | http://trove.nla.gov.au/newspaper/page/24102521 | 24102521 | ||
3483 | 3483 | 1899-09-06 | 3 | a | A British assistant helps Zhang Yu to collect tax in Tianjin. | http://trove.nla.gov.au/newspaper/page/24102521 | 24102521 | ||
3484 | 3484 | 1899-09-06 | 3 | a | Chinese in Bendigo attempted to exchange fake gold for money. His attempted fraud was detected. | http://trove.nla.gov.au/newspaper/page/24102521 | 24102521 | ||
3502 | 3502 | 1899-09-06 | 4 | a | Immigration regulations, Queensland government refuses the entry of 72 Filipinos. | http://trove.nla.gov.au/newspaper/page/24102524 | 24102524 | ||
3503 | 3503 | 1899-09-06 | 4 | a | Population of Guangdong province is aging. | http://trove.nla.gov.au/newspaper/page/24102524 | 24102524 |
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]);