This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40796 | 40796 | 1923-12-15 | 6 | a | A circular telegram issued by Lu Mengfei. | China | http://trove.nla.gov.au/newspaper/page/24094652 | 24094652 | |
40797 | 40797 | 1923-12-15 | 6 | a-b | Chen Buxian of the Nationalist Party issues an open letter to all Chinese compatriots inside and outside China. | China | http://trove.nla.gov.au/newspaper/page/24094652 | 24094652 | |
40798 | 40798 | 1923-12-15 | 6 | b-d | Parliament in Shanghai lists second group of names of the members who are elected by bribery. | China | http://trove.nla.gov.au/newspaper/page/24094652 | 24094652 | |
40799 | 40799 | 1923-12-15 | 6 | d | Chinese Chamber of Commerce organises a fundraising concert/ party in the city Town Hall for Sydney hospital and those who are involved include Ye Tonggui and his wife, actor Lang Deshan, Zhang Maokuan, Zhu Hechou, Liu Guangfu, and Ma Zanfen. And report on the programme. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094652 | 24094652 |
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]);