This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32638 | 32638 | 1917-11-03 | 2 | c-d | Recent situations of Li Yuanhong in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24095892 | 24095892 | |
32645 | 32645 | 1917-11-03 | 3 | c-d | Liang Qichao sends telegram to Tang Jiyao in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24095891 | 24095891 | |
32651 | 32651 | 1917-11-03 | 7 | c-d | Australia news/ Railway profit decreases in New South Wales. Customs authority in Sydney and their regular inspection. Sugar production in Queensland. Four Chinese gambling dens are raided in Sydney. New South Wales state premier returns after a visit to London. Flooding in Murray River. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095895 | 24095895 | |
32656 | 32656 | 1917-11-03 | 8 | c-d | Guangdong news/ Shen Peizheng arrives in Guangzhou and her talks with journalists. Sun Yatsen to set up his headquarters in the cement factory. Ferry hijack in Dongguan county. Another robbery in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24095898 | 24095898 |
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]);