This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27216 | 27216 | 1913-04-05 | 2 | a-b | Liang Qichao's article on national financial policies. | Other... | http://trove.nla.gov.au/newspaper/page/24092633 | 24092633 | |
27228 | 27228 | 1913-04-05 | 3 | a-b | One American city suffers heavy loss from heavy storm. | America | http://trove.nla.gov.au/newspaper/page/24092632 | 24092632 | |
27236 | 27236 | 1913-04-05 | 6 | a-b | China faces Tibetan crisis. | Other... | http://trove.nla.gov.au/newspaper/page/24092637 | 24092637 | |
27240 | 27240 | 1913-04-05 | 7 | a-b | Australian news/ Number of work force in Sydney. Tram accident in Sydney. Chinese with mental problem arrested for destroying public property. Sydney Chinese gamblers caught and fined. Chinese using false money case dismissed. | Other... | http://trove.nla.gov.au/newspaper/page/24092636 | 24092636 | |
27241 | 27241 | 1913-04-05 | 8 | a-b | Comments on Confucianism. | Other... | http://trove.nla.gov.au/newspaper/page/24092639 | 24092639 |
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]);