This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36722 | 36722 | 1921-03-12 | 8 | a | Sixth part of the report from Shanghai, prepared by Zeng Tingguang, on the current situations there. | China | http://trove.nla.gov.au/newspaper/page/24093475 | 24093475 | |
36723 | 36723 | 1921-03-12 | 8 | a-b | Guangdong news/ Obstacles to the presidential election. Provincial government issues regulation on local self-government at the county level. Wei Bangping disobeys to governor Chen Jiongming. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093475 | 24093475 | |
36724 | 36724 | 1921-03-12 | 8 | b | A notice from Chinese herbalist Huang Junyue, Sun Man Lee & Co. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093475 | 24093475 | |
36725 | 36725 | 1921-03-12 | 8 | b | A notice from Liu Shuqing, agent for the Southern Insurance Association Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093475 | 24093475 | |
36726 | 36726 | 1921-03-12 | 8 | b | A notice for address change issued by Rev. Ye Huilu, Church of England Chinese Mission, Christ Church School Hall, Pitt Street, Sydney (opposite Central Railway Station). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093475 | 24093475 | |
36727 | 36727 | 1921-03-12 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093475 | 24093475 |
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]);