This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35530 | 35530 | 1920-03-20 | 8 | a | Warning by the Chinese Youth Patriotic Association in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098099 | 24098099 | |
35531 | 35531 | 1920-03-20 | 8 | a-c | Guangdong news/ Nationalist Party members in the provincial legislature distrust Qin Chunxuan and the report. A rice smuggler is executed in Guangdong. Chen Jiongming asks for provisions from the provincial military government. Committee for constitution is dissolved in Guangdong. Exercise of military police in Guangdong. Efforts to promote Chinese products. A court hearing in Gaoyao county on robbery. | China | http://trove.nla.gov.au/newspaper/page/24098099 | 24098099 | |
35532 | 35532 | 1920-03-20 | 8 | d | Advertisement for the Royal Easter Show (nine days and five nights) by the Royal Agricultural Society of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098099 | 24098099 |
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]);