Explore Latest Public Databases

    Latest public databases and queries from the community

    Public Databases

    sort
    H1-B Data
    All H1-B data from the Department of Labor
    postgres
    h1b
    Overview
    sort
    SF School Lottery
    Data on San Francisco Unifed School District (SFUSD) lottery selections and outcomes
    postgres
    sfusd_lottery
    Overview
    sort
    US Life Expectancy Data
    Shows estimates of U.S. life expectancy at birth by state and census tract for the period 2010-2015
    postgres
    us_life_expectancy
    Overview
    sort
    Sample Product Catalog
    Sample product catalog database Use this database to test working with a product catalog database in Postgres. Please create issues for any data anomalies (such as an incorrect price).
    postgres
    product_catalog
    Overview
    sort
    Chicken Testing
    Poultry processing plants that have had at least one poultry sample since June 28, 2020.
    postgres
    chicken_testing
    Overview
    sort
    Favorite Databases and Companies
    Our favorite databases and companies behind them
    postgres
    favorite_dbs
    Overview
    sort
    Open Dental Sample Database
    Open Dental, also known as Open Dental Software, is a practice management software designed for dentists.
    postgres
    opendental
    Overview
    sort
    Air Quality Data
    Air quality data updated every 60 minutes.
    postgres
    air_quality
    Overview

    Public Queries

    H1-B Data
    Kenbenarduneanya
    1 select * from public jobs where = Data Analyst
    postgres
    H1-B Data
    Samuel George
    Hope it be user friendly and lively community
    postgres
    H1-B Data
    Emma Wilcox
    Jess Ramos SQl challenge query
    postgres
    H1-B Data
    wage desc
    job title, employer name, wage from
    postgres
    H1-B Data
    Gayathry Devi Logeswaran
    postgres
    H1-B Data
    Certified Business Analysts
    Selects Top 100 rows of Business Analysts who are Certified(case_status certified)
    postgres
    H1-B Data
    The Classic *
    Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅
    postgres
    H1-B Data
    The Classic *
    Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅
    postgres
    H1-B Data
    Himanshu_Select
    Query to show 10 records of the table.
    postgres
    H1-B Data
    Conversion rate
    Conversion rate of H1B applications
    postgres
    H1-B Data
    duplicate case_number
    duplicate case_number
    postgres
    H1-B Data
    group by visa class
    check the number of entries in each visa class
    postgres
    H1-B Data
    not H-1B Visa
    listing top 100 columns where the visa class is not equal to H-1B
    postgres
    H1-B Data
    Analyst Jobs near VA
    Jobs with 'analyst' near VA - includes NC, VA, DC, MD.
    postgres
    H1-B Data
    data scientists versus software developers
    comparing jobs
    postgres
    H1-B Data
    Denied Count by SOC Title
    This shows how many visas were denied in 2023 by SOC title.
    postgres
    H1-B Data
    Different Case Status
    List the Different Case Status of the H1B Visas.
    postgres
    H1-B Data
    Amalia Gamez
    The state with the highest H-1b Visas
    postgres