This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30004 | 30004 | 1915-05-01 | 8 | a-b | The Tax Department in China is encouraging businessmen unite to promote exports. | China | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 | |
30005 | 30005 | 1915-05-01 | 8 | b | Brief biography of Sun Yatsen by the central government ( to be continued). | China | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 | |
30006 | 30006 | 1915-05-01 | 8 | b-c | Letters from overseas Chinese in Mexico calling for help. | Other... | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 | |
30007 | 30007 | 1915-05-01 | 8 | c | America is to send a business delegation to China. | America | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 | |
30008 | 30008 | 1915-05-01 | 8 | c-d | Guangdong news/ Military commander Li is to set up training school for Guangdong officials. Naval warships are to unite police force to arrest bandits. Troops in Gao Yao county, Guangdong, do not help in bandits robberies. A detective in Guangdong is slanting an innocent person. A woman in Guangdong charges a Buhda for misleading her. A soldier charges his wife's adultery with another man in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 | |
30009 | 30009 | 1915-05-01 | 8 | d | A poem of Liang Qicao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 |
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]);