This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24240 | 24240 | 1911-01-28 | 8 | a-b | Issues concerning ban on opium | A letter from the Anti-opium Association of Chinese National Women to the Anti-opium Association of British, asking the latter to petition the British government to ban opium from exporting to China; a letter from the Association of Chinese National Anti-opium to the British imperial commissoner to urge the British government to ban opium export; a note against the new opium-related treaty with British from the same association. | China | http://trove.nla.gov.au/newspaper/page/24091618 | 24091618 |
24241 | 24241 | 1911-01-28 | 8 | b | The situation of cutting queue in Beijing | Zhou Chenlin initated the establishment of the Society for Queue-cutting and Dress-preserving; the cabinet member, Lao Jiejun also joined with Zhou to have his queue cut; soliders welcomed queue-cutting; students welcomed queue cutting. | China | http://trove.nla.gov.au/newspaper/page/24091618 | 24091618 |
24242 | 24242 | 1911-01-28 | 8 | b | Korean's optimison | A story about how one Korean began to appreciate being colonied by Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24091618 | 24091618 |
24243 | 24243 | 1911-01-28 | 8 | b-c | The freedom of wearing official hat? | Before officials needed to wear particular colour of hat according to the level of his position; now this principle did not seem to work when people are encouraged to purchase goverment position, or donate money for promotion. | China | http://trove.nla.gov.au/newspaper/page/24091618 | 24091618 |
24244 | 24244 | 1911-01-28 | 8 | c | Casual talks | Habits of Prince Qin and Earl Lang; the strategy for Chinese diplomats. | Other... | http://trove.nla.gov.au/newspaper/page/24091618 | 24091618 |
24245 | 24245 | 1911-01-28 | 8 | c | A couple of old news | Stories about two singer prostitutes in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091618 | 24091618 |
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]);