This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42600 | 42600 | 1925-01-17 | 5 | a-d | Articles written by anonymous authors condemn Huang Laiwang, Liu Boming and other Nationalist Party members in Sydney and their radical propaganda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101004 | 24101004 | |
42619 | 42619 | 1925-01-17 | 8 | a-d | Guangdong news/ Primary education in Guangzhou suffers under the rule of Sun Yatsen. Communist movement in Guangdong. Many thieves are arrested in Guangzhou in the past month. Sun Yatsen's constitution and implementation. Opium smokers are pleased in Guangzhou. Guangzhou turns into a world of thieves. Local government are required to pay their provisions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101009 | 24101009 |
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]);