This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28593 | 28593 | 1914-03-21 | 2 | d | Chinese community and the Chinese Society (zhong hua hui guan) in San Francisco writes to the Chinese authority in Beijing on the new immigration restrictions imposed by American parliament. The Chinese Society (zhong hua hui guan) in San Francisco writes to American President Woodrow Wilson and asks to lift the immigration restriction. | America | http://trove.nla.gov.au/newspaper/page/24093046 | 24093046 | |
28607 | 28607 | 1914-03-21 | 3 | d | Guangdong news/ Provincial authority takes every precautions against harassment of revolutionary rebels. | China | http://trove.nla.gov.au/newspaper/page/24093045 | 24093045 |
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]);