This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37603 | 37603 | 1921-09-17 | 8 | a | Fiction/ A sad woman, part I. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093693 | 24093693 | |
37604 | 37604 | 1921-09-17 | 8 | a-c | Guangdong news/ Sun Yatsen tries to restrict the power of Chen Jiongming. Election of county magistrate in Nanhai, Panyu, Dongguan, Xinhui and other counties. Suppress of bandits in Gaoyao county. Liu Yufang is elected school principal in Xiangshan county. A secret meeting in Nanning. Loss of Guangdong businessmen in the war between Guangdong and Guangxi. The Sun Electricity (da xin) resumes operation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093693 | 24093693 | |
37605 | 37605 | 1921-09-17 | 8 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093693 | 24093693 |
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]);