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 |
---|---|---|---|---|---|---|---|---|---|
15324 | 15324 | 1906-02-10 | 2 | c | Chinese communities in Vietnam protest against American immigration policy that will ban Chinese entry. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800897 | 26800897 | |
15337 | 15337 | 1906-02-10 | 5 | c | Elegiac couplets in memory of Feng Xiawei who committed suicide at the front door of American consulate in Shanghai in protest against American immigration policy that to ban Chinese immigrants. Authors include See Yup Society in Melbourne and other individuals and organisations. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800901 | 26800901 | |
15338 | 15338 | 1906-02-10 | 5 | c | Statistics of import and export of the six Australian states. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800901 | 26800901 | |
15339 | 15339 | 1906-02-10 | 5 | c | Australia has new and stricter immigration laws. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800901 | 26800901 | |
15340 | 15340 | 1906-02-10 | 5 | c | A 15-year-old boy murdered a woman in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800901 | 26800901 | |
15341 | 15341 | 1906-02-10 | 5 | c | Another 63 Chinese are returning home from Sydney with their gold. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800901 | 26800901 | |
15350 | 15350 | 1906-02-10 | 6 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800898 | 26800898 |
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]);