This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26441 | 26441 | 1912-07-20 | 7 | a | Chinese consul general issues draft regulations of China's national treasury bonds in Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092315 | 24092315 | |
26442 | 26442 | 1912-07-20 | 7 | b-c | Australian news/ Sydney gets large amount of tax. More than 8,000 houses built in Sydney. Victoria not allow discount for boy scouts' fares. Fake money found in Sydney. Sydney overseas Chinese discuss promoting China's national treasury bonds in Australia. Sydney government issues regulations on litters. Foreign Affairs Department's decision on the issue of a Chinese woman for her stay in Australia. Woman of having bestial words prosecuted. | Other... | http://trove.nla.gov.au/newspaper/page/24092315 | 24092315 | |
26443 | 26443 | 1912-07-20 | 7 | c | Chinese soldiers in Xinjiang burn more than 100 Russians. | Russia | http://trove.nla.gov.au/newspaper/page/24092315 | 24092315 | |
26444 | 26444 | 1912-07-20 | 7 | c-d | More than 100 ships wrecked in the world last year. Baby posted to relative by a British woman. Spanish boys with over 12 fingers. A carpet made for three years values 2 millions. | Other... | http://trove.nla.gov.au/newspaper/page/24092315 | 24092315 |
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]);