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 |
---|---|---|---|---|---|---|---|---|---|
24147 | 24147 | 1911-01-14 | 2 | c | Please look at how badly huaqiao (overseas Chinese) are treated in America | Chinese now enter San Fransico are forced to go through a humiliated medical check to see if they have any hookworm-related disease. The committed of the Chinese Masonic Association, including Xu Bienfen, Li Baoshen, Huang Shanghu, Tang Rui sent a cable to ask Chinese commissioner to protect their welfare. | America | http://trove.nla.gov.au/newspaper/page/24091597 | 24091597 |
24152 | 24152 | 1911-01-14 | 3 | a | Japan and the Philippines | According to a Filipino surveyor, Japan is intended to take over Manila before 1915 when it starts a war with America. | America | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24162 | 24162 | 1911-01-14 | 3 | b | American trade with China decreases | American exports to China decreased due to the competition of cheap Indian cotton cloth. | America | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
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]);