"pa-gov/prek-counts-and-head-start-supplemental-assistance-pgbt-5wid:latest"."prek_counts_and_head_start_supplemental_assistance"

SELECT
    ":id", -- Socrata column ID
    "geocoded_column_1", -- Georeferenced Latitude and Longitude of the location for the physical location where Pre-K Counts (PKC) or Head Start Supplemental Assistance (HSSAP) services are delivered
    "master_provider_id_service_location_identification", -- Master Provider Index Numbers are used across the Department of Human Services to identify providers and service locations that participate in any of their programs. As such, they are used in PELICAN (Pennsylvania's Enterprise to Link Information for Children Across Networks) to  as a common identifier for all OCDEL (Office of Child Development and Early Learning) programs, including Child Care Licensing, Early Intervention, PA Pre-K Counts, Head Start Supplemental and Keystone STARS. This is the MPI Service Location ID for the Location.
    "legal_entity_master_provider_id", -- Master Provider Index Numbers are used across the Department of Human Services to identify providers and service locations that participate in any of their programs. As such, they are used in PELICAN as a common identifier for all OCDEL programs, including Child Care Licensing, Early Intervention, PA Pre-K Counts, Head Start Supplemental and Keystone STARS. This is the MPI for the Lead Agency.
    "master_provider_identification_", -- Master Provider Index Numbers are used across the Department of Human Services to identify providers and service locations that participate in any of their programs. As such, they are used in PELICAN (Pennsylvania's Enterprise to Link Information for Children Across Networks) as a common identifier for all OCDEL (Office of Child Development and Early Learning) programs, including Child Care Licensing, Early Intervention, PA Pre-K Counts, Head Start Supplemental and Keystone STARS. This is the MPI for the Lead Agency.
    "half_day_funded_slots", -- Slots equate to the number of funded enrollments within either the PA PKC or the HSSAP grant. PKC data can be captured at the part-day (2.5-4.45 hour a day 5 days a week. HSSAP only capture the number children funded. HSSAP funding models vary in accordance to the acceptable models acknowledged by the Head Start Performance Standards and can operate less than 5 days a week as well as full day or part day and home visits. A blank field means that the location did not receive funding during this program year in any form. A '0' in the field indicates “either full-day or part-day slots were not funded” at this location in the designated program year for PA PKC or are not able to be differentiated for HSSAP. 
    "full_day_funded_slots", -- Slots equate to the number of funded enrollments within either the PA PKC or the HSSAP grant. PKC data can be captured at the full-day (5 hours or more) a day 5 days a week. HSSAP only capture the number children funded. HSSAP funding models vary in accordance to the acceptable models acknowledged by the Head Start Performance Standards and can operate less than 5 days a week as well as full day or part day and home visits. A blank field means that the location did not receive funding during this program year in any form. A '0' in the field indicates “either full-day or part-day slots were not funded” at this location in the designated program year for PA PKC or are not able to be differentiated for HSSAP. 
    "location_county_served", -- The County of the location served address.
    "zip_code", -- The Zip Code is the zip code for the physical location where PKC or HSSAP services are delivered
    "city", -- The city name if the city for the physical location where PKC or HSSAP services are delivered
    "street_address", -- The location address is the street address for the physical location where PKC or HSSAP services are delivered
    "location_name", -- The name of the location where PKC or HSSAP services are provided.
    "partner_name", -- This column denotes the name of the provider if a lead agency is passing through funds to another eligible provider to deliver the grant funded program.
    "total_funded_slots", -- The number of full-day and/or part-day slots and total slots funded with in a period (per FY listed for the row) as continuation funding to slots awarded in a previous program year. A blank in the field means that the location did not receive funding during this program year in any form. A '0' in the field indicates “either full-day or part-day slots were not funded” at this location in the designated program year for PA PKC or are not able to be differentiated for HSSAP. 
    "fiscal_year", -- The Fiscal Year of the data in this row.
    "location_school_district", -- School District name of location address.
    "state", -- The state name is the state for the physical location where PKC or HSSAP services are delivered
    "provider_type", -- PKC and HSSAP can only be implemented by entities who are designated Child Care Center or Group participating in Keystone STARS at STAR 3 or 4; Head Start Grantees; Private Academic Preschools; or School Districts. Provider type identifies which eligible provider type the location is operating as.
    "lead_agency_name", -- Entity to which Pennsylvania Pre-K Counts (PKC) or Head Start Supplemental Assistance (HSSAP) funds are competitively awarded.
    "grant", -- Source of funding for the slots addressed in this row. PA PKC denotes Pennsylvania Pre-K Counts program and HSSAP denotes state funded* Head Start Supplemental Assistance Program. Both programs serve 3 and 4 year old children. Primary eligibility for children is PA PKC children whose families are at or below 300 percent of the Federal Poverty Guidelines. HSSAP is primarily children whose families earn at or below 100 percent of the Federal Poverty Guidelines.
    "state_fips_code", -- These are the first 2 digits of the 5-digit Federal Information Processing Standard (FIPS) code that designate the State association. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/library/reference/code-lists/ansi.html
    "county_fips_code", -- The FIPS county code is a five-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S. possessions, and certain freely associated states. This is the 3-digit part of the 5-digit county FIPS code specifically standing for the county.
    "date", -- The last day of the Fiscal Year that is considered in for the particular Fiscal Year in this data row.
    "loc_pre_k_id" -- The Location Pre-K ID is a unique identifier to identify pre-k providers in PELICAN (Pennsylvania Enterprise to Link Information for Children across Networks). 
FROM
    "pa-gov/prek-counts-and-head-start-supplemental-assistance-pgbt-5wid:latest"."prek_counts_and_head_start_supplemental_assistance"
LIMIT 100;

sgr mount socrata \
  "pa-gov/prek-counts-and-head-start-supplemental-assistance-pgbt-5wid" \
  --handler-options '{
    "domain": "data.pa.gov",
    "tables": {
        "prek_counts_and_head_start_supplemental_assistance": "pgbt-5wid"
    }
}'