This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27046 | 27046 | 1913-02-22 | 8 | a | Fan Yuanlian asks president to build memorial monument in Wuchang. | Other... | http://trove.nla.gov.au/newspaper/page/24092591 | 24092591 | |
27047 | 27047 | 1913-02-22 | 8 | a-b | Guangdong governor announces crimes of several cases of cheating people under disguise of government officials. | Other... | http://trove.nla.gov.au/newspaper/page/24092591 | 24092591 | |
27048 | 27048 | 1913-02-22 | 8 | b-c | Guangdong Dongguan Baoan Public Office's notice about its functions. | Other... | http://trove.nla.gov.au/newspaper/page/24092591 | 24092591 | |
27049 | 27049 | 1913-02-22 | 8 | c-d | Singapore Chinese donate to support China's war against Russia over Mongolian issue. Woman lets baby die due to her madness with religion. Prostitutes active in Indonesia. Singapore Chinese reluctant to cut pigtail. | Other... | http://trove.nla.gov.au/newspaper/page/24092591 | 24092591 | |
27050 | 27050 | 1913-02-22 | 8 | d | Satire on China's current situation. | Other... | http://trove.nla.gov.au/newspaper/page/24092591 | 24092591 | |
27051 | 27051 | 1913-02-22 | 8 | d | More than 20 names listed for donations to saving China. | Other... | http://trove.nla.gov.au/newspaper/page/24092591 | 24092591 |
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]);