This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 15889 | 15889 | 1906-07-07 | 5 | a-b | Special notice & regulations for the establishment and operation of the Mexico Bank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801027 | 26801027 | |
| 15890 | 15890 | 1906-07-07 | 5 | b | An article, published in Pittsburgh Chronicle Telegraph, about stories of Huang Kuanzhuo, a businessman and member of the Chinese Empire Reform Association in Mexico who is enthusiastic in the community and in association affairs. | America | http://trove.nla.gov.au/newspaper/page/26801027 | 26801027 | |
| 15891 | 15891 | 1906-07-07 | 5 | b | Warning. Excessive rain in Gaoyao county has been followed by flooding and famine. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801027 | 26801027 | |
| 15892 | 15892 | 1906-07-07 | 5 | b-c | Help your compatriots. Chinese communities in Sydney, Tingha, Armidale and other New South Wales towns. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801027 | 26801027 | |
| 15893 | 15893 | 1906-07-07 | 5 | c | Chinese communities in New Zealand continue to donate to the protest movement against American immigration policy that will ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801027 | 26801027 |
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]);