Northwind Database

La base de datos Northwind es una base de datos de muestra creada originalmente por Microsoft y utilizada como base para sus tutoriales en una variedad de productos de bases de datos durante décadas. La base de datos de Northwind contiene datos de ventas de una empresa ficticia llamada "Northwind Traders", que importa y exporta alimentos especiales de todo el mundo. La base de datos Northwind es un excelente esquema tutorial para un ERP de pequeñas empresas, con clientes, pedidos, inventario, compras, proveedores, envíos, empleados y contabilidad de entrada única. Desde entonces, la base de datos Northwind ha sido trasladada a una variedad de bases de datos que no son de Microsoft, incluido PostgreSQL.

El conjunto de datos de Northwind incluye datos de muestra para lo siguiente.

• Proveedores: Proveedores y vendedores de Northwind
• Clientes: Clientes que compran productos de Northwind
• Empleados: detalles de los empleados de los comerciantes de Northwind
• Productos: Información del producto
• Transportistas: los detalles de los transportistas que envían los productos desde los comerciantes a los clientes finales.
• Órdenes y detalles de la orden: transacciones de órdenes de venta que tienen lugar entre los clientes y la empresa.

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F13411583%2Fa52a5bbc3d8842abfdfcfe608b7a8d25%2FNorthwind_E-R_Diagram.png?generation=1718785485874540&alt=media" alt="">

Chinook DataBase

Chinook es una base de datos de muestra disponible para SQL Server, Oracle, MySQL, etc. Se puede crear ejecutando un único script SQL. La base de datos Chinook es una alternativa a la base de datos Northwind, siendo ideal para demostraciones y pruebas de herramientas ORM dirigidas a servidores de bases de datos únicos o múltiples.

El modelo de datos Chinook representa una tienda de medios digitales, que incluye tablas para artistas, álbumes, pistas multimedia, facturas y clientes.

Los datos relacionados con los medios se crearon utilizando datos reales de una biblioteca de iTunes. La información de clientes y empleados se creó manualmente utilizando nombres ficticios, direcciones que se pueden ubicar en mapas de Google y otros datos bien formateados (teléfono, fax, correo electrónico, etc.). La información de ventas se genera automáticamente utilizando datos aleatorios durante un período de cuatro años.

¿Por qué el nombre Chinook? El nombre de esta base de datos de ejemplo se basó en la base de datos Northwind. Los chinooks son vientos en el interior oeste de América del Norte, donde las praderas canadienses y las grandes llanuras se encuentran con varias cadenas montañosas. Los chinooks son más frecuentes en el sur de Alberta en Canadá. Chinook es una buena opción de nombre para una base de datos que pretende ser una alternativa a Northwind.

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F13411583%2Fd856e0358e3a572d50f1aba5e171c1c6%2FChinook%20DataBase.png?generation=1718785749657445&alt=media" alt="">

Northwind Stock Report Dataset

This dataset was created by CHERGUELAINE Ayoub & BOUBEKRI Faycal for the purpose of document classification and analytics. The dataset contains monthly stock reports and monthly stock reports by category, extracted from the Northwind dataset. The Northwind dataset is a sample database that comes with Microsoft Access, and is commonly used as a demo database for learning SQL. The dataset contains data on a fictional company called "Northwind Traders"… See the full description on the dataset page: https://huggingface.co/datasets/AyoubChLin/northwind-Stock_rapport.

Data has been processed by NODC to the NODC standard Bathythermograph (MBT) (C128) format. The C128 format is used for temperature-depth profile data obtained using the mechanical bathythermograph (MBT) instrument. The maximum depth of MBT observations is approximately 285 m. Therefore, MBT data are useful only in studying the thermal structure of the upper layers of the ocean. Cruise information, date, position, and time are reported for each observation. The data record comprises pairs of temperature-depth values. Temperature data in this file are recorded at uniform 5 m depth intervals.

This dataset provides information about the number of properties, residents, and average property values for Northwinds North Drive cross streets in Wendell, NC.

Dataset

This dataset was created by Oladayo Felix, Olatunji

Released under Database: Open Database, Contents: Database Contents

Contents

This dataset provides information about the number of properties, residents, and average property values for Northwinds Drive cross streets in Lynwood, IL.

Conductivity, Temperature, Depth (CTD) and other data from multiple ships and other platforms were collected from NE Pacific (limit-180) from February 26, 1982 to April 5, 1983. The data was collected as part of Coastal Ocean Dynamics Experiment and submitted by Oregon State University. The bathythermograph XBT data is in C116 format of NODC while the CTD hi resolution data is in F022 format.

Data has been processed by NODC to the NODC standard Bathythermograph (XBT) (C116) format. The C116/C118 format contains temperature-depth profile data obtained using expendable bathythermograph (XBT) instruments. Cruise information, position, date and time were reported for each observation. The data record was comprised of pairs of temperature-depth values. Unlike the MBT Data File, in which temperature values were recorded at uniform 5 m intervals, the XBT data files contained temperature values at non-uniform depths. These depths were recorded at the minimum number of points ("inflection points") required to accurately define the temperature curve. Standard XBTs can obtain profiles to depths of either 450 or 760 m. With special instruments, measurements can be obtained to 1830 m. Prior to July 1994, XBT data were routinely processed to one of these standard types. XBT data are now processed and loaded directly in to the NODC Ocean Profile Data Base (OPDB). Historic data from these two data types were loaded into the OPDB.

This dataset provides information about the number of properties, residents, and average property values for Northwind Court cross streets in Hammond, OR.

description: The U.S. Geological Survey recovered 9 piston cores from the Northwind Ridge in the Canada Basin of the Arctic Ocean from a cruise of the USCGC Polar Star during 1988. Preliminary analysis of the cores suggests sediments deposited on Northwind Ridge preserve a detailed record of glacial and interglacial cycles for the last few hundred-thousand to one million years. This report includes quantitative data on foraminifers and selected sediment size-fraction data in samples from Northwind Ridge core PI-88AR P5.; abstract: The U.S. Geological Survey recovered 9 piston cores from the Northwind Ridge in the Canada Basin of the Arctic Ocean from a cruise of the USCGC Polar Star during 1988. Preliminary analysis of the cores suggests sediments deposited on Northwind Ridge preserve a detailed record of glacial and interglacial cycles for the last few hundred-thousand to one million years. This report includes quantitative data on foraminifers and selected sediment size-fraction data in samples from Northwind Ridge core PI-88AR P5.

Stream Temperature: Site: Jennifer Branch at Northwind (JBNW):

   In the Baltimore urban long-term ecological research (LTER) project, (Baltimore Ecosystem Study, BES) we use the watershed approach to evaluate integrated ecosystem function. The LTER research is centered on the Gwynns Falls watershed, a 17,150 ha catchment that traverses a gradient from the urban core of Baltimore, through older urban residential (1900 - 1950) and suburban (1950- 1980) zones, rapidly suburbanizing areas and a rural/suburban fringe.

   Stream temperature is continuously measured throughout the Gwynns Falls watershed along with supplemental sites around Baltimore County/City. A total of 22 sites contain sensors (HOBO Pro v2 Water Temperature Data Logger - U22-001) that take an instantaneous temperature reading every 2 minutes. These data are downloaded on a monthly basis. 

   This dataset is for Jennifer Branch off Northwind Rd in Carney, MD. It is located close to the Cub Hill flux tower. The area draining this site is about 448 ha and is 19% forested and 20.5% impervious of both high and low density development. This site includes drainage from the other Jennifer Branch sites that are monitored. 

   Watershed information was taken from delineations created with USGS StreamStats at http://water.usgs.gov/osw/streamstats/maryland.html


   Purpose: Long-term monitoring of stream temperature in a suburban watershed. 

   Theme keywords: stream, watershed, temperature, suburban, Baltimore Ecosystem Study

   Coordinates: Lat/Long

   39.4075 (39 24 27)  -76.5037 (-76 30 13)


   Review process for BES stream temperature data:

   Raw data were recorded and logged every 2-minutes using HOBO Pro v2 Water Temperature Data Logger - U22-001. 

   Data are exported into Microsoft Excel documents. 

   Then organized by site and by month

   Each month's data were entered into a pivot table in Microsoft Excel and daily means and counts of daily data points were calculated. 

   Plots were graphed of sites with close geographic proximity on the same graph to illustrate possible outlier data. 

   Missing and odd data were flagged, and notes taken from the field visits are provided where applicable.

The data in this accession was collected in Bay of Biscay from ship Northwind between October 8, 1988 and October 19, 1988. The real time data of water temperature at varying depth bathythermograph (XBT) was recorded in stripcharts by the US Coast Guard. These stripcharts and radio logs were submitted to NODC. The XBT data from these stripcharts have been digitized and is present in the current NODC data storage system in C116 file format.

About This Dataset

This dataset is derived from the AdventureWorks 2014 test database published by Microsoft, and is designed to simplify and enhance data analysis workflows. The dataset consists of multiple CSV files that have been pre-joined and transformed from the original SQL database, facilitating a smoother analytical experience in Python.

Dataset Composition

The dataset includes: * SalesOrderHeader: Integrates the sales header and sales item tables, providing a unified view of sales transactions. * CustomerMaster: Combines customer names, countries, addresses, and other related information into a single, comprehensive file. * VendorMaster: Combines vendor names, countries, addresses, and other related information into a single, comprehensive file.

These pre-joined CSVs aim to streamline data analysis, making it more accessible for users working in Python. The dataset can be used to showcase various Python projects or as a foundation for your own analyses.

Usage

Feel free to leverage this dataset for your data analysis projects, explore trends, and create visualizations. Whether you're showcasing your own Python projects or conducting independent analyses, this dataset is designed to support a wide range of data science tasks.

Documentation

For those interested in recreating the CSV files from the SQL database, detailed documentation is included at the bottom of this section. It provides step-by-step instructions on how to replicate the CSVs from the AdventureWorks 2014 database using SQL queries.

AdventureWorks_SalesOrderHeader

SELECT
  SalesOrderID
  , CAST (OrderDate AS date) AS OrderDate
  , CAST (ShipDate AS date) AS ShipDate
  , CustomerID
  , ShipToAddressID
  , BillToAddressID
  , SubTotal
  , TaxAmt
  , Freight
  , TotalDue
FROM
  Sales.SalesOrderHeader

AdventureWorks_CustomerMaster

SELECT
  pa.AddressID
  , pbea.BusinessEntityID
  , pa.AddressLine1
  , pa.City
  , pa.PostalCode
  , psp.[Name] AS ProvinceStateName
  , pat.[Name] AS AddressType
  , pea.EmailAddress
  , ppp.PhoneNumber
  , pp.FirstName
  , pp.LastName
  , sst.CountryRegionCode
  , pcr.[Name] AS CountryName
  , sst.[Group] AS CountryGroup
FROM 
  Person.[Address] AS pa
INNER JOIN
  Person.BusinessEntityAddress AS pbea ON pa.AddressID = pbea.AddressID
INNER JOIN
  Person.StateProvince AS psp ON pa.StateProvinceID = psp.StateProvinceID
INNER JOIN
  Person.AddressType AS pat ON pbea.AddressTypeID = pat.AddressTypeID 
INNER JOIN
  Person.EmailAddress AS pea ON pbea.BusinessEntityID = pea.BusinessEntityID
INNER JOIN
  Person.Person AS pp ON pbea.BusinessEntityID = pp.BusinessEntityID
INNER JOIN
  Person.PersonPhone AS ppp ON pbea.BusinessEntityID = ppp.BusinessEntityID
INNER JOIN
  Sales.SalesTerritory AS sst ON psp.TerritoryID = sst.TerritoryID
INNER JOIN
  Person.CountryRegion AS pcr ON sst.CountryRegionCode = pcr.CountryRegionCode;

The data in this accession was collected in Greenland Sea from ship Northwind between July 18, 1988 and September 26, 1988. The real time data of water temperature at varying depth bathythermograph (XBT) was recorded in stripcharts by the US Coast Guard. These stripcharts and radio logs were submitted to NODC. The XBT data from these stripcharts have been digitized and is present in the current NODC data storage system in C116 file format.

Temperature profile and water depth data were collected using BT and XBT casts from the USCGC NORTHWIND in the Northeast / Northwest Atlantic Ocean, Greenland Sea, Norwegian Sea, Labrador Sea, Davis Strait, and Baffin Bay. Data were collected from 02 April 1988 to 08 July 1988 by the US Coast Guard.

This dataset provides information about the number of properties, residents, and average property values for Northwinds Drive cross streets in Saint Louis, MO.

Subscribers can find out export and import data of 23 countries by HS code or product’s name. This demo is helpful for market analysis.

Temperature profile data were collected using bathythermograph (BT/XBT) casts from NORTHWIND in the Pacific Ocean from November 11, 1976 to November 15, 1976. Data were submitted by Scripps Institution of Oceanography as part of the Thermal Structure Monitoring Program in the Pacific (TRANSPAC) project. Data were processed by NODC to the NODC standard Universal Bathythermograph Output (UBT) format. Full BT descriptions are available at http://www.nodc.noaa.gov/General/NODC-Archive/bt.html.

The UBT format contains temperature-depth profile data obtained using expendable bathythermograph (XBT) instruments. Cruise information, position, date and time were reported for each observation. The data record was comprised of pairs of temperature-depth values. Unlike the MBT Data File, in which temperature values were recorded at uniform 5 m intervals, the XBT data files contained temperature values at non-uniform depths. These depths were recorded at the minimum number of points ("inflection points") required to accurately define the temperature curve. Standard XBTs can obtain profiles to depths of either 450 or 760 m. With special instruments, measurements can be obtained to 1830 m.

No description is available. Visit https://dataone.org/datasets/%7BABE1475A-19FA-4E3B-885D-2EF799DAD0C0%7D for complete metadata about this dataset.

This dataset provides information about the number of properties, residents, and average property values for Northwinds Drive cross streets in Saint Peters, MO.