This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26453 | 26453 | 1912-07-27 | 2 | b-c | President Yuan's several orders about keeping republic army office in Nanjing, restructuring education department and Manchu people's private property protected by republic government. | Other... | http://trove.nla.gov.au/newspaper/page/24092320 | 24092320 | |
26470 | 26470 | 1912-07-27 | 3 | b-c | Beijing news/ government army office in Nanjing promotes donations to nation. National Donation Committee set up in Nanjing, Sun Yat-sen as Chairman. Army officials and soldiers make donations. President Yuan willing to reduce his salary to half. President Yuan forbids women to join politics. Suggestions for government about donations to nation. Appeal for using Chinese goods for clothing industry. Central government decides all government appointments made by president. Chen Chunxuan tells president he prepares 10,000 soldiers for crashing rebellions. President appoints Chen Chunxuan as Eastsouth army head. President appoints Fan Zengxiang as literary adviser. All Beijing police cut pigtails. Education minister decides compulsory education. Qing Protection Society found in Gansu. | Other... | http://trove.nla.gov.au/newspaper/page/24092319 | 24092319 | |
26478 | 26478 | 1912-07-27 | 7 | b-c | Congress for promotion of donations to Chinese nation held in Sydney. Chinese consul general hands over collected donations from Sydney to Chinese foreign affairs department. Australia plans to build wool manufacturing factory. Hong Kong ship caught in Sydney for smuggling illegal migrants. Australian-Chinese's wife is asked to leave Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092323 | 24092323 | |
26481 | 26481 | 1912-07-27 | 8 | b-c | More than 300 names listed for their donations to Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092326 | 24092326 |
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]);