This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15335 | 15335 | 1906-02-10 | 5 | a | Second part of the letter from Kang Youwei to President Roosevelt of the United States. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800901 | 26800901 | |
15336 | 15336 | 1906-02-10 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy that bans Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800901 | 26800901 | |
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 |
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]);