This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 26483 | 26483 | 1912-08-03 | 2 | a-b | Editorial on promotion of donations to Chinese nation in Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092328 | 24092328 | |
| 26484 | 26484 | 1912-08-03 | 2 | b-c | Comments on China-France Friendship Association's banquet in Paris. | France | http://trove.nla.gov.au/newspaper/page/24092328 | 24092328 | |
| 26485 | 26485 | 1912-08-03 | 2 | c | Chinese financial department's regulations on collecting donations to Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092328 | 24092328 | |
| 26486 | 26486 | 1912-08-03 | 2 | c | Members of Tongmen Hui meet President asking him to appoint member of Tongmen Hui as premier. | China | http://trove.nla.gov.au/newspaper/page/24092328 | 24092328 | |
| 26487 | 26487 | 1912-08-03 | 2 | c-d | Yunnan governor Cai E askes President Yuan to appoint Liang Qichao. | Other... | http://trove.nla.gov.au/newspaper/page/24092328 | 24092328 | |
| 26488 | 26488 | 1912-08-03 | 2 | d | Li Yuanhong breaks off relations with Tongmen Hui as he joins united republic party. | Other... | http://trove.nla.gov.au/newspaper/page/24092328 | 24092328 | |
| 26489 | 26489 | 1912-08-03 | 2 | d | Senate secretly discusses way of disarmament. | China | http://trove.nla.gov.au/newspaper/page/24092328 | 24092328 | |
| 26490 | 26490 | 1912-08-03 | 2 | d | Financial minister proposes seperate office for taxation. | Other... | http://trove.nla.gov.au/newspaper/page/24092328 | 24092328 | |
| 26491 | 26491 | 1912-08-03 | 3 | a | Four hundred thousand strike workers suffer hunger in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26492 | 26492 | 1912-08-03 | 3 | a | Heavy rain disaster in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26493 | 26493 | 1912-08-03 | 3 | a | Chinese workers crash with police in East India, casualties claimed. | Other... | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26494 | 26494 | 1912-08-03 | 3 | a | President Yuan not allow cabinet to resign by themselves. | China | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26495 | 26495 | 1912-08-03 | 3 | a | Canadian government asks its people to donate for buying warships. | Britain | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26496 | 26496 | 1912-08-03 | 3 | a | German aircraft's speed is fastest in the world. | Germany | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26497 | 26497 | 1912-08-03 | 3 | a | Turkish army rejects constitution. Government asks to crack down rejection. | Other... | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26498 | 26498 | 1912-08-03 | 3 | a-b | British woman caught for intention to assassinate premier. | Britain | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26499 | 26499 | 1912-08-03 | 3 | b | Army officials ask president to allow them to join senate as government policies always rejected by senate. | China | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26500 | 26500 | 1912-08-03 | 3 | b | Greece buys more warships from Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26501 | 26501 | 1912-08-03 | 3 | b | President Yuan forms new cabinet. | China | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26502 | 26502 | 1912-08-03 | 3 | b | Japanese king dies. | Japan | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26503 | 26503 | 1912-08-03 | 3 | b | Another British woman arrested for intention to assassinate civil affairs minister. | Britain | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26504 | 26504 | 1912-08-03 | 3 | b | Gvoernment army fight again with revolutionary troops in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26505 | 26505 | 1912-08-03 | 3 | b | Many sea crabs die mysteriously near San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26506 | 26506 | 1912-08-03 | 3 | b | German colony minister rejects black and white couple's divoice. | Germany | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26507 | 26507 | 1912-08-03 | 3 | b-c | Western's book reveals aircraft first invented in China. | Other... | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26508 | 26508 | 1912-08-03 | 3 | c-d | Beijing news/ President Yuan rejects compensation to foreign businessmen for their claim loss of business due to rise of republic army. Former Guizhou governor executed for his corruption. Head of Guangdong-Hankou railway suggests to government to get the railway under government control. Financial department claims huge amount of money collected from donations during last three months. Disaster floods in Anhui. Head of Guangdong-Hankou railway recommends Li Yuanhong or Liang Qichao as premier. Zhang Taiyan recommends Chen Chunxuan as premier. Guangdong governor said to be tyranny. Proposal to government for selling raffles for collecting money. Souvenir for republic's capture of newspaper offices. Mongolian prince in Beijing supports donations to Chinese nation. Reason for premier flees to Tianjin. | Other... | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26509 | 26509 | 1912-08-03 | 3 | d | Guangdong news/ Academics and politicians promote donations to nation. Police chief in Xiangshan county donates one-month salary to nation. Guangdong government has a big debt from sending Northern Expedition Army. People frightened on the day of Duanwu Festival. Disaster assistance general office set up. Shantang Business Association discusses about shares of Guangdong-Hankou railway. | Other... | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26510 | 26510 | 1912-08-03 | 6 | a-b | Floods in different counties of Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092332 | 24092332 | |
| 26511 | 26511 | 1912-08-03 | 6 | b | Former Qing officials asked to hand over some of their property to government. | Other... | http://trove.nla.gov.au/newspaper/page/24092332 | 24092332 | |
| 26512 | 26512 | 1912-08-03 | 6 | b-c | Chinese in New Zealand promote donations to Chinese nation. More than 30 names listed for their donations. | Other... | http://trove.nla.gov.au/newspaper/page/24092332 | 24092332 | |
| 26513 | 26513 | 1912-08-03 | 7 | a-b | Chinese consul general issues draft regulations on promotion of donations to Chinese nation in Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092331 | 24092331 | |
| 26514 | 26514 | 1912-08-03 | 7 | b | Chinese consul general's notice about regulations on promotion of donations to Chinese nation in Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092331 | 24092331 | |
| 26515 | 26515 | 1912-08-03 | 7 | b-c | Australian news/Beijing foreign affairs department replies to Chinese consul general to Australia for generous donations. Australian navy college opens in New South Wales. Australia's ordered warship finished one month in advance. Sydney government asks Britain to send navy fleet to Sydney. Several Australian Chinese asked to sit for English test before they allowed to stay in Australia as they lived in China for several years. Ship smuggling illegal Chinese migrants has a heavy fine. Another ship found illegal migrants. | Other... | http://trove.nla.gov.au/newspaper/page/24092331 | 24092331 | |
| 26516 | 26516 | 1912-08-03 | 8 | a | Sydney branch's regulations on promotion of donations to Chinese nation. Members of the branch's committee. | Other... | http://trove.nla.gov.au/newspaper/page/24092334 | 24092334 | |
| 26517 | 26517 | 1912-08-03 | 8 | a | Notice for donations to floods in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092334 | 24092334 | |
| 26518 | 26518 | 1912-08-03 | 8 | a-c | Republic government's national policies for discussion. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24092334 | 24092334 | |
| 26519 | 26519 | 1912-08-03 | 8 | c | More than 100 names listed for second round donations to Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092334 | 24092334 | |
| 26520 | 26520 | 1912-08-03 | 8 | c | Correction for wrong print of previous issue of the newspaper. | Other... | http://trove.nla.gov.au/newspaper/page/24092334 | 24092334 | |
| 26521 | 26521 | 1912-08-03 | 8 | c-d | More than 30 organisations' names listed for their donations to republic army. | Other... | http://trove.nla.gov.au/newspaper/page/24092334 | 24092334 | |
| 26522 | 26522 | 1912-08-03 | 8 | d | More than 20 names listed for their donations to floods in Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092334 | 24092334 | |
| 26523 | 26523 | 1912-08-03 | 8 | d | More than 70 names listed for their donations to the flood in Dongguan, Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092334 | 24092334 |
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]);