This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23902 | 23902 | 1910-12-03 | 2 | b-c | Correspondence from America/ Wang Yitang is returning after a visit to America. Sa Zhenbing's son returns after graduation from an American university majored in railway engineering. Zhang Yuanji (Jusheng) arrives America from Europe. Five Chinese officials arrive America from Europe for a legal investigation. | America | http://trove.nla.gov.au/newspaper/page/26802858 | 26802858 | |
23913 | 23913 | 1910-12-03 | 3 | c | Defence budget for the Panama Canal. | America | http://trove.nla.gov.au/newspaper/page/26802857 | 26802857 | |
23914 | 23914 | 1910-12-03 | 3 | c | Chinese inventor Ma Zhuo has secured a patent for his arithmetic tool. | America | http://trove.nla.gov.au/newspaper/page/26802857 | 26802857 | |
23940 | 23940 | 1910-12-03 | 8 | c | Chinese Empire Reform Association in the east of America welcomes Zai Xun. | America | http://trove.nla.gov.au/newspaper/page/26802864 | 26802864 |
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]);