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 |
---|---|---|---|---|---|---|---|---|---|
7668 | 7668 | 1901-05-15 | 2 | d | Sydney will penalise those who spit on the sidewalk. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7669 | 7669 | 1901-05-15 | 2 | d | A young man in Sydney was punished for selling the bike he borrowed from his friend. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7670 | 7670 | 1901-05-15 | 2 | d | Sun Jialai and his story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7672 | 7672 | 1901-05-15 | 2 | e | A boy was poisoned to death in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7673 | 7673 | 1901-05-15 | 2 | e | An old maid in Prestons, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7681 | 7681 | 1901-05-15 | 3 | a | Liu Ruxing, Chinese businessman in Sydney, talks with Australian soldiers who just came back from China. Australian troops in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
7682 | 7682 | 1901-05-15 | 3 | b | Jing Liansan has been released from Macao and has now returned to Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
7683 | 7683 | 1901-05-15 | 3 | b | Magistrate of Xiangshan rewards civil corps for their efforts in maintaining social security. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
7689 | 7689 | 1901-05-15 | 3 | c | German soldiers in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
7696 | 7696 | 1901-05-15 | 3 | d | Liang Qichao is now on the way to Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
7698 | 7698 | 1901-05-15 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 |
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]);