This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
11726 | 11726 | 1903-04-11 | 3 | a | Chinese products have excellent performance in the Hanoi fair. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800202 | 26800202 | |
11735 | 11735 | 1903-04-11 | 3 | c | Chinese Ya Wang was beaten by two White man on Sydney street. A court trial is currently taking place. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800202 | 26800202 | |
11736 | 11736 | 1903-04-11 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800202 | 26800202 | |
11737 | 11737 | 1903-04-11 | 3 | c | A notice from Lian Fu Tang (an association of Zengcheng fellows in Sydney) for transporting remains of the dead fellows to China. Only those who died seven years ago are eligible. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800202 | 26800202 | |
11738 | 11738 | 1903-04-11 | 3 | c | An admission notice from Rockdale College, a Sydney boarding school for boys. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800202 | 26800202 |
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]);