This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7667 | 7667 | 1901-05-15 | 2 | d | A report on the international troops in China. | Britain | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
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 | |
7694 | 7694 | 1901-05-15 | 3 | d | Chinese government is seeking foreign help to refuse the treaty with Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
7695 | 7695 | 1901-05-15 | 3 | d | Somebody purchased munitions in Yokohama and tried to send them into China. | China | 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 | |
7697 | 7697 | 1901-05-15 | 3 | d | A German newspaper on the Siberia railway. | China | 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]);