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 |
---|---|---|---|---|---|---|---|---|---|
18713 | 18713 | 1908-01-04 | 2 | c | Important report. Empress Dowager is ready to start constitutional reforms. A report on reform plans. Chinese government strictly disciplines all returned students from Japan in order to avoid further political chaos. | Britain | http://trove.nla.gov.au/newspaper/page/26801596 | 26801596 | |
18726 | 18726 | 1908-01-04 | 6 | c | The New York Times has the largest circulation of any newspaper in America. Magnificent old buildings in India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801600 | 26801600 | |
18727 | 18727 | 1908-01-04 | 6 | c | A notice to Zhou Jie whose article will be published in next issue. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801600 | 26801600 | |
18728 | 18728 | 1908-01-04 | 6 | c | Advertisement for Anthony Hordern and Sons. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801600 | 26801600 | |
18741 | 18741 | 1908-01-04 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801599 | 26801599 | |
18742 | 18742 | 1908-01-04 | 7 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801599 | 26801599 | |
18743 | 18743 | 1908-01-04 | 7 | c | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801599 | 26801599 | |
18745 | 18745 | 1908-01-04 | 8 | c | Life in the universe and exploration from the Earth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801602 | 26801602 |
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]);