Explore Latest Public Databases

    Latest public databases and queries from the community

    Public Databases

    sort
    SF School Lottery
    Data on San Francisco Unifed School District (SFUSD) lottery selections and outcomes
    postgres
    sfusd_lottery
    Overview
    sort
    H1-B Data
    All H1-B data from the Department of Labor
    postgres
    h1b
    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

    SF School Lottery
    My new query
    postgres
    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