This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17711 | 17711 | 1907-07-06 | 2 | c-d | Overseas Chinese students. News about Chinese students in Tokyo. Chinese embassy in Tokyo is accused of subsidising private students. Many Chinese students in Tokyo hospital. Other news about Chinese students in Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801388 | 26801388 | |
17721 | 17721 | 1907-07-06 | 3 | c-d | Report on a peace conference in New York. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801387 | 26801387 |
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]);