This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18174 | 18174 | 1907-09-21 | 8 | a-b | Second part of an article written by Cao Yi (Hongdao) in Mexico provides advice to overseas Chinese men who married western women. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801482 | 26801482 | |
18175 | 18175 | 1907-09-21 | 8 | b | Attention. Obvious mistakes in another Chinese newspaper in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801482 | 26801482 | |
18176 | 18176 | 1907-09-21 | 8 | b-c | A New York newspaper reports financial difficulty of Japanese government. Statistics of Japan's international trade in the past few years. Number of warships in Britain, America, France, Germany and Japan. Total length of railway in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801482 | 26801482 | |
18177 | 18177 | 1907-09-21 | 8 | c | Jokes in the opium den. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801482 | 26801482 |
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]);