Explore Latest Public Databases

    Latest public databases and queries from the community

    Public Databases

    allium
    🦄 Real-time Ethereum data warehouse
    snowflake
    ETHEREUM
    sort
    📖 Data on San Francisco Unified School District (SFUSD) lottery selections and outcomes
    postgres
    sfusd_lottery
    sort
    👷‍♀️ All H1-B data from the Department of Labor
    postgres
    sort
    ⚕️ Shows estimates of U.S. life expectancy at birth by state and census tract for the period 2010-2015
    postgres
    us_life_expectancy
    sort
    📦 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
    sort
    🐣 Poultry processing plants that have had at least one poultry sample since June 28, 2020.
    postgres
    chicken_testing
    sort
    ❤️ Our favorite databases and companies behind them
    postgres
    favorite_dbs
    sort
    🦷 Open Dental, also known as Open Dental Software, is a practice management software designed for dentists.
    postgres
    opendental
    sort
    ☁️ Air quality data updated every 60 minutes.
    postgres
    air_quality

    Public Queries

    Ethereum Data Warehouse
    Ordered by block timestamp desc
    snowflake
    Ethereum Data Warehouse
    ENS Registrations ordered by timestamp
    snowflake
    Ethereum Data Warehouse
    Sales of $GPU coins
    snowflake
    SF School Lottery
    postgres
    H1-B Data
    1 select * from public jobs where = Data Analyst
    postgres
    H1-B Data
    Hope it be user friendly and lively community
    postgres
    H1-B Data
    Jess Ramos SQl challenge query
    postgres
    H1-B Data
    job title, employer name, wage from
    postgres
    postgres
    H1-B Data
    Selects Top 100 rows of Business Analysts who are Certified(case_status certified)
    postgres
    H1-B Data
    Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅
    postgres
    H1-B Data
    Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅
    postgres
    H1-B Data
    Query to show 10 records of the table.
    postgres
    H1-B Data
    Conversion rate of H1B applications
    postgres
    H1-B Data
    duplicate case_number
    postgres
    H1-B Data
    check the number of entries in each visa class
    postgres
    H1-B Data
    listing top 100 columns where the visa class is not equal to H-1B
    postgres
    H1-B Data
    Jobs with 'analyst' near VA - includes NC, VA, DC, MD.
    postgres