This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29594 | 29594 | 1915-01-16 | 8 | a | Ministry of Agriculture and Trade in China designates regulations for office administering commercial products. | China | http://trove.nla.gov.au/newspaper/page/24094694 | 24094694 | |
29595 | 29595 | 1915-01-16 | 8 | a | Beijing news/ Government plans to make temples of Guang Gong and Yue Fei to be a united one. A Shanghai jewellery shop suffers dearly in a cheating deal. A group of bandits in Sichun wearing red hats are defeated by government troops. | China | http://trove.nla.gov.au/newspaper/page/24094694 | 24094694 | |
29596 | 29596 | 1915-01-16 | 8 | b-c | Guangdong news/ A case of four death including a unborn baby resulting from bandits killing. Government troops defeats bandits in Gaozhou, Guangdong. Guangdong people are strongly against public gambling. Some illegal party members attempt to start a riot in Guangzhou. Guangdong government approves a businessman dealing with gambling business for his highest donation to military funds. | China | http://trove.nla.gov.au/newspaper/page/24094694 | 24094694 |
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]);