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 |
---|---|---|---|---|---|---|---|---|---|
45534 | 45534 | 1927-03-12 | 2 | c | Editorial by Tung Wah Times on the petition presented by the Guangdong businessmen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45535 | 45535 | 1927-03-12 | 2 | c-d | Chinese recent diplomacy with Britain, America and other countries. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45536 | 45536 | 1927-03-12 | 2 | d | A meeting between China and Japan to revise the treaties. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45537 | 45537 | 1927-03-12 | 2 | f | The trial of POWs in Jiangxi province, chaired by Guo Moruo. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45538 | 45538 | 1927-03-12 | 3 | c | Chinese foreign ministry in Beijing publicise the correspondence with Japan over the revision of treaties. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45539 | 45539 | 1927-03-12 | 3 | d | A speech by Shi Zhaoji in America. | America | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45540 | 45540 | 1927-03-12 | 3 | d | The Soviet Russia and the Nationalist government in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45541 | 45541 | 1927-03-12 | 3 | d | The Nationalist Party sets up local administration in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45542 | 45542 | 1927-03-12 | 3 | e-f | A survey on the rich and single women in America. | America | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45543 | 45543 | 1927-03-12 | 3 | e-f | A notice on shareholders' meeting of the Zhenguang China Company Ltd in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45544 | 45544 | 1927-03-12 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101909 | 24101909 | |
45545 | 45545 | 1927-03-12 | 7 | a-b | Australia news/ Cost of haircut for women in Sydney. Liner Zhangde (Changte) arrives Sydney. News from Solomon islands. Investigation on the bomb explosion in Redfern, Sydney. Artist performers come from China organised by Huang Guangzhao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45546 | 45546 | 1927-03-12 | 7 | b-c | The highest building, the oldest man and the biggest boy in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45547 | 45547 | 1927-03-12 | 7 | c | A wonderful advertisement by a French cosmetics company in Paris. | France | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45548 | 45548 | 1927-03-12 | 7 | c | A notice by the Oriental Arts Company Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45549 | 45549 | 1927-03-12 | 7 | d | Names listed for donations to the Dongguan hospital. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45550 | 45550 | 1927-03-12 | 8 | a-d | Guangdong news/ Petitions of the Guangzhou businessmen and Li Jishen. The Huangpu Military Academy and Li Jishen. Li Jishen dispatches troops to take over the Henan area. Old clothes shops in Guangzhou and their business. Strike in Humen area and the solution. Some private schools prefer to stay open. | China | http://trove.nla.gov.au/newspaper/page/24101914 | 24101914 | |
45551 | 45551 | 1927-03-12 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101914 | 24101914 |
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]);