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 |
|---|---|---|---|---|---|---|---|---|---|
| 39044 | 39044 | 1922-11-25 | 2 | a-b | Editorial on the will of the people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094196 | 24094196 | |
| 39045 | 39045 | 1922-11-25 | 2 | b | Orders issued by the Beijing government (appointment or removal of local officials). | China | http://trove.nla.gov.au/newspaper/page/24094196 | 24094196 | |
| 39046 | 39046 | 1922-11-25 | 2 | b-f | Riots and chaos in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24094196 | 24094196 | |
| 39047 | 39047 | 1922-11-25 | 3 | a | Correspondence between Xu Qian and Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39048 | 39048 | 1922-11-25 | 3 | a | Chinese President Li Yuanhong opens the third term of the national parliament. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39049 | 39049 | 1922-11-25 | 3 | b | Martyr of the Wuchang Uprising Peng Chufan's father is sad on the National Day. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39050 | 39050 | 1922-11-25 | 3 | b-c | Miscellaneous report on the chaos in Fujian. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39051 | 39051 | 1922-11-25 | 3 | c | Zhang Zuolin and Wu Peifu to have a peace conference. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39052 | 39052 | 1922-11-25 | 3 | c-d | Zhang Zuolin stops to purchase weapon from Russian. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39053 | 39053 | 1922-11-25 | 3 | c-d | President Li Yuanhong pardons political offenders. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39054 | 39054 | 1922-11-25 | 3 | d | A military conference to be held in Baoding, capital of Zhili province. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39055 | 39055 | 1922-11-25 | 3 | e | Xu Chongzhi in Fujian talks to his visitors. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39056 | 39056 | 1922-11-25 | 3 | e | Hawaiian authority detains weapons that are smuggled to China. | Canada | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39057 | 39057 | 1922-11-25 | 3 | e | An American court pronounces that Japanese people are not white men. | America | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39058 | 39058 | 1922-11-25 | 3 | e | Bandits in Henan province kidnap foreign missionaries. | America | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39059 | 39059 | 1922-11-25 | 3 | f | Riots and looting in a German city. | Britain | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39060 | 39060 | 1922-11-25 | 3 | f | Emperor of Turkey Mehmed VI boards a British warship and flees to Malta. | Britain | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39061 | 39061 | 1922-11-25 | 3 | f | More than 20 communist activists are arrested and charged in Ankara. | Britain | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39062 | 39062 | 1922-11-25 | 3 | f | The Far Eastern Republic in Chita is incorporated into the Russian Soviet Federated Socialist Republic. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39063 | 39063 | 1922-11-25 | 3 | f | Chinese cabinet treasurer Luo Wengan is under custody in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
| 39064 | 39064 | 1922-11-25 | 6 | a-b | Second and final part of a letter from Bao Shijie to the Shandong provincial legislature assembly in regards to the municipal administration in Qingdao. | China | http://trove.nla.gov.au/newspaper/page/24094200 | 24094200 | |
| 39065 | 39065 | 1922-11-25 | 6 | b-c | Anfu Club members are pardoned and the comment by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094200 | 24094200 | |
| 39066 | 39066 | 1922-11-25 | 6 | b-c | Advertisement for hypnotism service provided by Chinese Institute of Mentalism, 2 Houtak Terrace, Shanghai, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094200 | 24094200 | |
| 39067 | 39067 | 1922-11-25 | 7 | a | Advertisement for Ho Hing & Co, importers, wholesale merchants, 50 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094199 | 24094199 | |
| 39068 | 39068 | 1922-11-25 | 7 | a | White businessmen in Parramatta, Sydney, are against Chinese shops and immigration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094199 | 24094199 | |
| 39069 | 39069 | 1922-11-25 | 7 | b | A Russian employee in Brisbane shoots dead his Chinese employer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094199 | 24094199 | |
| 39070 | 39070 | 1922-11-25 | 7 | b | Chinese treasurer Luo Wengan is charged with corruption. | America | http://trove.nla.gov.au/newspaper/page/24094199 | 24094199 | |
| 39071 | 39071 | 1922-11-25 | 7 | a-b | Australian Chinese communities donate to a charity hospital in Dongguan county, Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094199 | 24094199 | |
| 39072 | 39072 | 1922-11-25 | 7 | c | Pirates hijack a British ship near Macao. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24094199 | 24094199 | |
| 39073 | 39073 | 1922-11-25 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094199 | 24094199 | |
| 39074 | 39074 | 1922-11-25 | 8 | a-c | Guangdong news/ Pension to the servicemen who are killed or injured. Military Affairs Investigation Office to be re-opened in Guangzhou. Army provisions are robbed by the bandits in Renhua county. Dongguan people are trying to protect public property. Rice chaos in Zengcheng. Provincial legislature assembly and the effort to borrow foreign loans. Guangzhou students protest against secret loans from foreign sources. A series of bomb blasts in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094202 | 24094202 | |
| 39075 | 39075 | 1922-11-25 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094202 | 24094202 | |
| 39076 | 39076 | 1922-11-25 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094202 | 24094202 |
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]);