glam-datasets

1 row where file_description = "OpenGov NSW data and functionality are available via an open web API. This service provides additional options for agencies wishing to integrate OpenGov NSW with their own websites. It also means that external developers, and members of the public more broadly, can easily extract and use OpenGov NSW data. For more information, visit: [https://www.opengov.nsw.gov.au/api](https://www.opengov.nsw.gov.au/api)" and source = "data.nsw.gov.au"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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]);