test_db_1 12 Curated Stock, Geography, and Organization Reference Domains

Test database with sample tables for stocks, geography, organizations, and reference data, illustrating data quality patterns. All tables include id and timestamp columns. business-operations stock-market

  • DataBase

README

This test database contains sample stock, geographic, organizational, and reference data. All tables include id and ts columns for record identification and timestamp context. It contains 25 tables, 87 columns, 132 rows, and 1,032,192 bytes of data, and was created on 2024-09-03 05:54:56.

Tables and sample content

The data includes stock price records, geographic references, industry and business profiles, organizational departments and personnel, and reference values for countries, markets, continents, genders, and CEOs. Important examples include:

  • stock contains 8 rows; symbol and price are populated in all 8, while market is populated in 6. The sample includes MSFT on NASDAQ with a displayed price of 361.91.
  • business includes Microsoft Corporation with an address in Redmond, Washington.
  • industry contains 12 rows, including Computer Software and Media & Entertainment.
  • state, continent, department, gender, supervisor, consultants, country, ceo, and market provide supporting reference and organizational data.

Data notes

Sample records illustrate quality patterns including repeated text, placeholder values, empty fields, unusually long values, vague or possibly misspelled column names, and values represented as text. For example, state.title, gender.name, continent.name, and market.name contain repeated or padded text, while several description and association fields are sparsely populated.

The catalog records suggested many-to-many associations among business, stock, state, industry, department, personnel, gender, geography, CEO, and market data. No parent-child relationships are declared. Validate identifiers, timestamps, duplicates, null or empty values, field lengths, naming conventions, keys, codes, standardized vocabularies, and relationship semantics before analysis or production reporting.

Database Stats:

Size 0.98M
Tables 25
Columns 87
Rows 132

Database APIs:

  1. /test_api_11/ A test API again updated: Some description goes here
    Main: /main/list/
  2. /test_db_1/ test_db_1
    Main: /main/list/
  3. /test-api-1/ A test API: This is a really good test API
    Main: /main/list/