This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21279 | 21279 | 1909-07-10 | 2-3 | d-a | Representatives from Anhui province have a debate with British businessman John Kay on the Tongguanshan mine. | China | http://trove.nla.gov.au/newspaper/page/26802246 | 26802246 | |
21282 | 21282 | 1909-07-10 | 3 | a-b | Beijing news/ The railway from Beijing to Hankou increases profit in 1909. French governor in Vietnam talks their intention in China. Hunan fellows in Shanghai fight for ownership of railway. A fire in Hankou destroys more than 2,000 shops. Japanese engineers are surveying in Mongolia. Prince of Mongolia tours Nanjing, Hankou and other inland cities on his way back from Japan. Board of Education bans societies that support freedom of marriage. | China | http://trove.nla.gov.au/newspaper/page/26802245 | 26802245 |
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]);