This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25114 | 25114 | 1911-10-07 | 8 | a | Refute on Sun Wen's speech | Another refute on Sun Wen's speech. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24091953 | 24091953 |
25115 | 25115 | 1911-10-07 | 8 | b-c | Sun's activities in America | Revolutionary gangster Sun begs donations in America. | Other... | http://trove.nla.gov.au/newspaper/page/24091953 | 24091953 |
25116 | 25116 | 1911-10-07 | 8 | c | Refute on Mangchong Newspaper | An attack is on Mangchong Newspaper. | Other... | http://trove.nla.gov.au/newspaper/page/24091953 | 24091953 |
25117 | 25117 | 1911-10-07 | 8 | c | Satire on Jingdong Newspaper | A satrie on Jingdong Newspaper. | Other... | http://trove.nla.gov.au/newspaper/page/24091953 | 24091953 |
25118 | 25118 | 1911-10-07 | 8 | c-d | What I saw in New York | A famous America singer divorces her husband after three day marrage. | Other... | http://trove.nla.gov.au/newspaper/page/24091953 | 24091953 |
25119 | 25119 | 1911-10-07 | 8 | d | Chats | Unique wedding in Romania. Japanese story about a wild island. | Other... | http://trove.nla.gov.au/newspaper/page/24091953 | 24091953 |
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]);