This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20941 | 20941 | 1909-04-24 | 2 | a-b | Chinese community in New York organises a society to help Chinese naval rejuvenation (zhen xing hai jun she), the notice from the society, its management committee, and name list of the shareholders of zhenhua company in Guangxi province. | America | http://trove.nla.gov.au/newspaper/page/26802158 | 26802158 |
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]);