This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4962 | 4962 | 1900-04-14 | 2 | f | Greeting telegrams, sent by Huang Liang, Chinese communities in Honolulu and other countries, were withheld in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24102767 | 24102767 | |
4963 | 4963 | 1900-04-14 | 2 | f | A type of big snake and other strange animals in the ocean off South Africa. | America | http://trove.nla.gov.au/newspaper/page/24102767 | 24102767 | |
4964 | 4964 | 1900-04-14 | 2 | f | Four hundred and twenty skilled workers migrated from Britain to Queensland; fruit prices in London; troops drilling in Launceston, Tasmania; two Japanese ships visiting Australia colonies; Queen of Britain visits ai li shi (ppp). | Australia | http://trove.nla.gov.au/newspaper/page/24102767 | 24102767 | |
4965 | 4965 | 1900-04-14 | 2 | f | Sydney holds a big fete to raise money for hospitals. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102767 | 24102767 | |
4966 | 4966 | 1900-04-14 | 2 | f | The Empress is not satisfied with performance of newly-established universities or colleges. | China | http://trove.nla.gov.au/newspaper/page/24102767 | 24102767 |
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]);