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 |
---|---|---|---|---|---|---|---|---|---|
6853 | 6853 | 1901-01-16 | 2 | b-c | A secret society in the Yangtze River area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
6854 | 6854 | 1901-01-16 | 2 | c-d | An article in remembrance of Gang Yi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
6855 | 6855 | 1901-01-16 | 2 | d-e | The fourth and final part of the record on the grand ceremony held to celebrate the establishment of an Australian Commonwealth, prepared by editor Zheng Lu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
6856 | 6856 | 1901-01-16 | 2 | e | A fire in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
6857 | 6857 | 1901-01-16 | 2 | e | A mad man in Brisbane jumped from a building and died as a result of the injuries he sustained. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
6859 | 6859 | 1901-01-16 | 2 | e | Sydney traffic was crowded during the ceremony for the Australian commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
6860 | 6860 | 1901-01-16 | 2 | e | Mr Johnson, Member of Parliament in New South Wales, is friend of the Chinese community. Many Chinese went inquire about the influence an Australian Commonwealth will have on their daily lives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
6862 | 6862 | 1901-01-16 | 2 | f | A big snake in Malaysia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
6871 | 6871 | 1901-01-16 | 3 | d | Britain purchased sugar from Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099917 | 24099917 | |
6872 | 6872 | 1901-01-16 | 3 | d | Liang Qichao was invited by the government to attend a big party to celebrate the establishment of Australian Commonwealth. Attendants include Lord Hopetoun, Prime Minister Barton, etc. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099917 | 24099917 | |
6873 | 6873 | 1901-01-16 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099917 | 24099917 |
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]);