glam-datasets

1 row where dataset_description = "On 23 August 1894 George Hawker, member for North Adelaide, presented to the South Australian House of Assembly a petition in favour of women’s suffrage. It was signed by approximately 11,600 men and women. Members of the Women’s Suffrage League, Woman’s Christian Temperance Union, and the Working Women’s Trade Union were primarily responsible for collecting the signatures from metropolitan and country areas." and licence = "Other (Open)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), dataset_modified (date), start_date (date), file_created (date)

start_date ✖

source

licence

  • Other (Open) · 1 ✖

format

dataset_description ✖

  • On 23 August 1894 George Hawker, member for North Adelaide, presented to the South Australian House of Assembly a petition in favour of women’s suffrage. It was signed by approximately 11,600 men and women. Members of the Women’s Suffrage League, Woman’s Christian Temperance Union, and the Working Women’s Trade Union were primarily responsible for collecting the signatures from metropolitan and country areas. · 1 ✖
Link rowid ▼ dataset_title publisher author dataset_issued dataset_modified dataset_description source info_url start_date end_date file_title download_url format file_description file_created file_modified file_size licence
834 834 Women’s Suffrage Petition 1894 (South Australia) History Trust of South Australia History Trust of South Australia 2019-04-04T01:50:27.805462 2019-04-10T07:44:25.748567 On 23 August 1894 George Hawker, member for North Adelaide, presented to the South Australian House … data.sa.gov.au https://data.sa.gov.au/data/dataset/3f6fab54-8cc8-4732-9c1e-fb3f73df53b0 1894-01-01   Suffrage125 Petition https://data.sa.gov.au/data/dataset/3f6fab54-8cc8-4732-9c1e-fb3f73df53b0/resource/68036d75-1ea2-4bb7-9efe-71ea7115227c/download/suffrage125_petition.json JSON   2019-04-04T02:17:13.619366 2019-04-04T02:17:13.572653   Other (Open)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [glam-datasets] (
   [dataset_title] TEXT,
   [publisher] TEXT,
   [author] TEXT,
   [dataset_issued] TEXT,
   [dataset_modified] TEXT,
   [dataset_description] TEXT,
   [source] TEXT,
   [info_url] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [file_title] TEXT,
   [download_url] TEXT,
   [format] TEXT,
   [file_description] TEXT,
   [file_created] TEXT,
   [file_modified] TEXT,
   [file_size] TEXT,
   [licence] TEXT
);
CREATE INDEX [idx_glam-datasets_source_publisher_format_licence]
    ON [glam-datasets] ([source], [publisher], [format], [licence]);