This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27204 | 27204 | 1913-03-29 | 6 | a | N.S.W. Chinese Chamber of Commerce's notice about recruitment of new memberships. | Other... | http://trove.nla.gov.au/newspaper/page/24092629 | 24092629 | |
27205 | 27205 | 1913-03-29 | 6 | a | Comments on Germany's troop increase in Shangdong province. | Other... | http://trove.nla.gov.au/newspaper/page/24092629 | 24092629 | |
27206 | 27206 | 1913-03-29 | 6 | a-b | Five key figures of Republic China. Constitution not yet decided whether vice president position kept or not. Senate members elected by overseas Chinese. Members of Constitution Committee. China's foreign loans blocked due to dispute among foreign lenders. | Other... | http://trove.nla.gov.au/newspaper/page/24092629 | 24092629 |
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]);