This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22971 | 22971 | 1910-06-18 | 2 | b-c | Correspondence from Hunan analyses reason of the chaos. | China | http://trove.nla.gov.au/newspaper/page/26802666 | 26802666 | |
22973 | 22973 | 1910-06-18 | 2-3 | d-a | Beijing news/ Number of Japanese in Manchuria. Prince Regent discusses with ministers on the naval rebuilding. American ambassador on the tram line in Beijing. Either Tang Jingchong or Li Dianlin might be appoint Grand Scholar (da xue shi). China and Japan sign an agreement in Fengtian to build a bridge on the Yalu River. A survey on foreign troops in Beijing and Tianjin (German, British, French, Indian, Austrian, and Japanese). Dispute between China and Japan over Liugongdao island, outside of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/26802666 | 26802666 | |
22984 | 22984 | 1910-06-18 | 3 | d | News and petitions on the establishment of national parliament in China. | China | http://trove.nla.gov.au/newspaper/page/26802665 | 26802665 | |
22986 | 22986 | 1910-06-18 | 6 | a-b | Fourteen associations in Shanghai welcome Jiang Chunlin. | China | http://trove.nla.gov.au/newspaper/page/26802670 | 26802670 | |
22987 | 22987 | 1910-06-18 | 6 | b | Guangzhou-Hankou railway company elects its managers. | China | http://trove.nla.gov.au/newspaper/page/26802670 | 26802670 | |
22993 | 22993 | 1910-06-18 | 7 | a | A letter from Beijing by Lu Naixiang, representative of Chinese communities in Nanyang and Australasia for establishment of national parliament. | China | http://trove.nla.gov.au/newspaper/page/26802669 | 26802669 |
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]);