This dataset contains information about housing sales in Nashville, TN such as property, owner, sales, and tax information. The SQL queries I created for Data Cleaning can be found here.

Check out our data lens page for additional data filtering and sorting options: https://data.cityofnewyork.us/view/i4p3-pe6a

This dataset contains Open Parking and Camera Violations issued by the City of New York. Updates will be applied to this data set on the following schedule:

New or open tickets will be updated weekly (Sunday). Tickets satisfied will be updated daily (Tuesday through Sunday). NOTE: Summonses that have been written-off are indicated by blank financials.

Summons images will not be available during scheduled downtime on Sunday - Monday from 1:00 am to 2:30 am and on Sundays from 5:00 am to 10:00 am.

• Initial dataset loaded 05/14/2016.

Dataset

This dataset was created by Parth Mistry 20

Contents

Dataset

This dataset was created by Andrew Dolcimascolo-Garrett

Released under MIT

Contents

Dataset

This dataset was created by Thejeswini.V

Contents

Library Dataset for SQL Project

Watch Full Video -- https://www.youtube.com/watch?v=6X2-P9fNVvw

Project Files -- https://github.com/najirh/Library-System-Management---P2?tab=readme-ov-file

Dataset

This dataset was created by Najir 0123

Released under MIT

Contents

This project developed a comprehensive data management system designed to support collaborative groundwater research across institutions by establishing a centralized, structured database for hydrologic time series data. Built on the Observations Data Model (ODM), the system stores time series data and metadata in a relational SQLite database. Key project components included database construction, automation of data formatting and importation, development of analytical and visualization tools, and integration with ArcGIS for geospatial representation. The data import workflow standardizes and validates diverse .csv datasets by aligning them with ODM formatting. A Python-based module was created to facilitate data retrieval, analysis, visualization, and export, while an interactive map feature enables users to explore site-specific data availability. Additionally, a custom ArcGIS script was implemented to generate maps that incorporate stream networks, site locations, and watershed boundaries using DEMs from USGS sources. The system was tested using real-world datasets from groundwater wells and surface water gages across Utah, demonstrating its flexibility in handling diverse formats and parameters. The relational structure enabled efficient querying and visualization, and the developed tools promoted accessibility and alignment with FAIR principles.

Open Context (https://opencontext.org) publishes free and open access research data for archaeology and related disciplines. An open source (but bespoke) Django (Python) application supports these data publishing services. The software repository is here: https://github.com/ekansa/open-context-py

The Open Context team runs ETL (extract, transform, load) workflows to import data contributed by researchers from various source relational databases and spreadsheets. Open Context uses PostgreSQL (https://www.postgresql.org) relational database to manage these imported data in a graph style schema. The Open Context Python application interacts with the PostgreSQL database via the Django Object-Relational-Model (ORM).

This database dump includes all published structured data organized used by Open Context (table names that start with 'oc_all_'). The binary media files referenced by these structured data records are stored elsewhere. Binary media files for some projects, still in preparation, are not yet archived with long term digital repositories.

These data comprehensively reflect the structured data currently published and publicly available on Open Context. Other data (such as user and group information) used to run the Website are not included.

IMPORTANT

This database dump contains data from roughly 190+ different projects. Each project dataset has its own metadata and citation expectations. If you use these data, you must cite each data contributor appropriately, not just this Zenodo archived database dump.

Dataset

This dataset was created by Abdallah Nasser

Released under Apache 2.0

Contents

My Coursera Capstone SQL Project

The sql containing the files and queries used to acquire SQL certification performed in a MYSQL environment and queries performed are listed below for reference sake and to follow along with the output as well to view the queried data.

Blockchain data query: SQL query ton projects with high trading volume

Open Context (https://opencontext.org) publishes free and open access research data for archaeology and related disciplines. An open source (but bespoke) Django (Python) application supports these data publishing services. The software repository is here: https://github.com/ekansa/open-context-py

The Open Context team runs ETL (extract, transform, load) workflows to import data contributed by researchers from various source relational databases and spreadsheets. Open Context uses PostgreSQL (https://www.postgresql.org) relational database to manage these imported data in a graph style schema. The Open Context Python application interacts with the PostgreSQL database via the Django Object-Relational-Model (ORM).

In 2023, the Open Context team finished migration of from a legacy database schema to a revised and refactored database schema with stricter referential integrity and better consistency across tables. During this process, the Open Context team de-duplicated records, cleaned some metadata, and redacted attribute data left over from records that had been incompletely deleted in the legacy schema.

This database dump includes all Open Context data organized with the legacy schema (table names that start with the 'oc_' or 'link_' prefixes) along with all Open Context data after cleanup and migration to the new database schema (table names that start with 'oc_all_'). The binary media files referenced by these structured data records are stored elsewhere. Binary media files for some projects, still in preparation, are not yet archived with long term digital repositories.

These data comprehensively reflect the structured data currently published and publicly available on Open Context. Other data (such as user and group information) used to run the Website are not included.

IMPORTANT

This database dump contains data from roughly 180 different projects. Each project dataset has its own metadata and citation expectations. If you use these data, you must cite each data contributor appropriately, not just this Zenodo archived database dump.

I completed a PostgreSQL project to hone my SQL abilities. Following a tutorial video, I worked on a music store data analysis. In the project, I used SQL to answer several queries about the music shop company.

AutoTrain Dataset for project: sql-injection

  Dataset Description

This dataset has been automatically processed by AutoTrain for project sql-injection.

  Languages

The BCP-47 code for the dataset's language is unk.

  Dataset Structure





  Data Instances

A sample from this dataset looks as follows: [ { "feat_Data": "1' where 5230 = 5230", "target": 1 }, { "feat_Data": "1'+ ( select ouhd where 8905 = 8905 and 6510 =… See the full description on the dataset page: https://huggingface.co/datasets/firdhokk/autotrain-data-sql-injection.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

The BlueBio database is a comprehensive and robust compilation of international and national research projects active in the years 2003-2022 in Fisheries, Aquaculture, Seafood Processing and Marine Biotechnology. Based on the COFASP projects’ database, it was implemented within the ERA-NET Cofund BlueBio project through a 3-years data collection including 3 surveys (.xlsx file) and a wide data retrieval. After being integrated, data were harmonised, shared as open and disseminated through a WebGIS (https://bluebioeconomy.eu/the-bluebio-projects-online-database/). The WebGIS was key for data update and validation as users were enabled to add new projects and edit existing ones.The database consists of 3,761 “georeferenced” projects, described by 22 parameters that are clustered into textual and spatial, some directly collected while others deduced. The database is a living archive to inform actors of the Blue Bioeconomy sector in a period of rapid transformations and research needs. The selection of projects to be included in the database was based on a combination of keywords previously identified by database administrators within the title, abstract, and, when available, keywords.The complete BlueBio database information backup (.sql file) should be restored in Postgre SQL. Collected research projects are also presented in a more user friendly .csv file, along with the R code used for its extraction.As compared to the previous version, the database has been further enhanced by adding projects related to the years 2020-2022, as well as finalizing the harmonization of the data to achieve a more detailed and accurate allocation of projects.The related report MS37 refers on the results of a series of exploratory analyses aimed to describe the information contained in the BlueBio research projects’ database.* corresponding author: Anna Nora Tassetti, annanora.tassetti@cnr.it

Scope This dataset provides the SQL version of the ShareTrait database, corresponding to ShareTrait version 1.2.0. It represents the structured database equivalent of the previously published dataset, ShareTrait: a data portal for making trait data interoperable and reusable, version 1.0.0 (Zenodo, July 12, 2023, DOI: 10.5281/zenodo.8138904). This version includes the database file, an SQL query, and the resulting output file generated from the SQL query. Dataset content The repository provides: ShareTrait-database-v1.2.0.db : the database file. master-query-all.sql : SQL query used for reconstructing the dataset. master-query-output.csv : SQL query output file . ShareTrait-dataset-database-mapping.csv : mapping of attribute fields from the SQL query output to the corresponding attributes in ShareTrait_MetaData_v1.0.0.csv, with relevant column name = "Column_name", version 1.0.0 (DOI: 10.5281/zenodo.8138904) Access and usage Files and documentation are available on GitHub: ShareTrait Project. Users can execute the SQL query by using either SQLiteStudio or SQLite3. Detailed instructions are provided in this repository README. Citation When using this dataset, please provide the following citation: Leiva, F., Ellers, J., Berg, M. P., Cuxart-Erruz, R., Barneche, D., Blackburn, T., Castañeda, L. E., Chown, S., Gaitán-Espitia, J. D., Gebauer Mery, P. H., Gomez Isaza, D., Hardy, I., Hermaniuk, A., Hirst, A., Jorissen, S., Keasar, T., Koene, J. M., Le Lann, C., Martorelli, I., Molinet C., Niklitschek E.J., Oliveira B., Olivier B., Orizaola G., Pilakouta N., Shameer K.S., Shokri M., Stoks R., Tougeron K., Tuni C., van de Pol I.L.E., van Dis N.E., Visser B., Vogels J., White C.R., Wu N., and Verberk W. (2025). ShareTrait: a data portal for making trait data interoperable and reusable (version 1.2.0) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.14826294 For further information, please contact: i.martorelli@vu.nl

Reported data only. Data unavailable for Fiscal Year 2015-2016.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

Comprehensive open source project metrics including contributor activity, popularity trends, development velocity, and security assessments for Go-MySQL-Driver.