This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
14 | 14 | 1898-06-29 | 2 | Editorial on advantages and disadvantages of limited company in business. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
15 | 15 | 1898-06-29 | 2 | Ceremiony organised to celebrate the opening of the Bank of Guangdong | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
16 | 16 | 1898-06-29 | 2 | Rich girl in Panyu county marries poor boy and now leads a happy life. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
17 | 17 | 1898-06-29 | 2 | Burglar in Sydney stole clothes from Mr Bao Chi's house but returned them after a few days. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
18 | 18 | 1898-06-29 | 2 | Old fisherman in Guangzhou finds invaluable pearl in a suburban river. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
19 | 19 | 1898-06-29 | 2 | American steamship company installs fans in ocean liners to make summer travel more comfortable for passangers. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
20 | 20 | 1898-06-29 | 2 | Drought in Zengcheng, Guangdong, has reduced agricultural production dramatically. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
21 | 21 | 1898-06-29 | 2 | Recent development in war between America and Spain. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
22 | 22 | 1898-06-29 | 2 | Beautiful women selected as concubines for His Imperial Majesty in China. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
23 | 23 | 1898-06-29 | 2 | A strange wedding ceremony recently held in US. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
24 | 24 | 1898-06-29 | 2 | US Defence Secretary requests increase in military expenditure to win war against Spain. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 | |||
25 | 25 | 1898-06-29 | 2 | Twin boys in Zengcheng claim they are real descendants of an ancient genius. | http://trove.nla.gov.au/newspaper/page/24102043 | 24102043 |
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]);