This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46773 | 46773 | 1928-02-25 | 3 | b-c | Tang Shengzhi's troops and his relations with various sides. | China | http://trove.nla.gov.au/newspaper/page/24098703 | 24098703 | |
46774 | 46774 | 1928-02-25 | 3 | c | Zhu Peide and Li Zongren write to Jiang Jieshi and the Executive Committee of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24098703 | 24098703 | |
46775 | 46775 | 1928-02-25 | 3 | e | Sun Ke, Wu Chaoshu, Hu Hanmin and other members of the Nationalist central committee are going for overseas visit. Feng Yuxiang borrows money from German businessmen and leads his troops to attack Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098703 | 24098703 | |
46776 | 46776 | 1928-02-25 | 3 | e | General information about New York. | America | http://trove.nla.gov.au/newspaper/page/24098703 | 24098703 |
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]);