This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13655 | 13655 | 1904-08-13 | 2 | b | Report on the coordination and training of the army in China. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13656 | 13656 | 1904-08-13 | 2 | b | Two barbarous teachers in Beijing beat their students. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13657 | 13657 | 1904-08-13 | 2 | b | Imperial scholar Xie Xiquan provides advice for army training in China. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13658 | 13658 | 1904-08-13 | 2 | c | Prominent gentry in Hunan try to set up a railway company for more building projects. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13659 | 13659 | 1904-08-13 | 2 | c | Students of Shandong province in Japan. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13660 | 13660 | 1904-08-13 | 2 | c | Two traitors collaborate with foreigners during the war. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13661 | 13661 | 1904-08-13 | 2 | c | Russia demands China pays for the return of Yingkou. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13662 | 13662 | 1904-08-13 | 2 | c | Russia talks with Western nation about stratergies to stop China purchasing weapons from overseas. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13663 | 13663 | 1904-08-13 | 2 | c | Russia has asked China to help suppress bandits in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 |
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]);