This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27076 | 27076 | 1913-03-01 | 7 | a | Chinese consul general's notice about donations to cracking dwon Mongolian claim for independence. More than 50 names listed for donations. | Other... | http://trove.nla.gov.au/newspaper/page/24092596 | 24092596 | |
27077 | 27077 | 1913-03-01 | 7 | a-b | Australian news/ Capital name is to be announced. Train accident in Victoria. Pan Ru's wife asked to leave Australia. Variola found on Hong Kong ship arrived in Sydney. Case of Australian born Chinese children. Vegetable and fruit gardens suffer heavy loss from heavy hail in Sydney. Japanese warship leaves Sydney for Brisbane. Sydney department store burned down. | Other... | http://trove.nla.gov.au/newspaper/page/24092596 | 24092596 | |
27078 | 27078 | 1913-03-01 | 7 | b | Dowager Cixi expresses her sadness before dies. | China | http://trove.nla.gov.au/newspaper/page/24092596 | 24092596 | |
27079 | 27079 | 1913-03-01 | 7 | b-c | Gaoyao county, Guangdong suffers heavy robbery tragedy. | Other... | http://trove.nla.gov.au/newspaper/page/24092596 | 24092596 |
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]);