This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
42620 | 42620 | 1925-01-17 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101009 | 24101009 | |
42621 | 42621 | 1925-01-17 | 8 | e | Gold price in Hong Kong. | 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]);