This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
11764 | 11764 | 1903-04-25 | 2 | b | Yuan Shikai refused foreign loans for the railway building in north China with a purpose to protect China's sovereignty. | China | http://trove.nla.gov.au/newspaper/page/26800211 | 26800211 | |
11765 | 11765 | 1903-04-25 | 2 | b | Bandits in Jilin province. | China | http://trove.nla.gov.au/newspaper/page/26800211 | 26800211 | |
11766 | 11766 | 1903-04-25 | 2 | b | Austrian sent a note to Yuan Shikai asking for compensation for the railway building in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/26800211 | 26800211 | |
11767 | 11767 | 1903-04-25 | 2 | b | A gathering of Chinese students in Japan and speeches. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800211 | 26800211 | |
11779 | 11779 | 1903-04-25 | 3 | b | Kang Tongbi, Kang Youwei's daughter, is now in America. | America | http://trove.nla.gov.au/newspaper/page/26800210 | 26800210 | |
11780 | 11780 | 1903-04-25 | 3 | b | A man in Victoria discovered gold in his farm. | Australia | http://trove.nla.gov.au/newspaper/page/26800210 | 26800210 | |
11781 | 11781 | 1903-04-25 | 3 | b | Qin Chunxuan has been appointed governor of Guangdong and Guangxi. | China | http://trove.nla.gov.au/newspaper/page/26800210 | 26800210 | |
11782 | 11782 | 1903-04-25 | 3 | b | Japanese warship visit Melbourne and Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/26800210 | 26800210 | |
11783 | 11783 | 1903-04-25 | 3 | b | New South Wales government donated to relieve drought disaster in the country. | Australia | http://trove.nla.gov.au/newspaper/page/26800210 | 26800210 | |
11784 | 11784 | 1903-04-25 | 3 | b | Chaos in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/26800210 | 26800210 |
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]);