immigration

Positions certified by the U

Positions certified by the U.S. Department of Labor on labor condition applications (LCAs) for H-1B specialty-occupation workers - and the H-1B1 (Chile, Singapore) and E-3 (Australia) programs that file the same form - at Georgia worksites, by federal fiscal year: the job slots DOL's Office of Foreign Labor Certification (OFLC) certified, with the positions requested and the number of applications decided. Statewide by case outcome, occupation group and visa program, and by the county of the LCA's first worksite. From OFLC's LCA program disclosure data, FY2020 through the third quarter of FY2026. An LCA precedes the H-1B petition and the cap lottery: certified positions are not visas issued or workers hired.

Filterable categorical columns (comma-separated values union; multiple columns AND together):

  • case_status — one of: all, certified, certified_withdrawn, certified_withdrawn_earlier_year, withdrawn, denied
  • occupation_group — one of: all, software_developers, other_computer_mathematical, architecture_engineering, management_business_finance, education_health, other
  • visa_class — one of: all, h1b, h1b1_chile, h1b1_singapore, e3_australia

Detail levels available: counties, states (default: states)

Year coverage: 2020–2026 (7 years, no gaps)

NULL handling: zero is a real value.

Source: U.S. Department of Labor, Employment and Training Administration, Office of Foreign Labor Certification: LCA (H-1B, H-1B1, E-3) program disclosure data (Performance Data), FY2020-FY2026 Q3

get/api/v1/immigration/h1b_lca_positions

Request

  • Base URL: https://georgiacivicdata.org
  • URL: https://georgiacivicdata.org/api/v1/immigration/h1b_lca_positions
  • Auth: none declared

Query parameters

yearinteger nullable

Exact year

year_mininteger nullable

Inclusive lower bound

year_maxinteger nullable

Inclusive upper bound

district_codestring nullable

Comma-separated list of GOSA district codes (e.g. 601,602)

school_codestring nullable

Comma-separated list of GOSA school codes. Combine with district_code for unique school keys.

county_fipsstring nullable

Comma-separated list of 5-digit county FIPS codes (e.g. 13121,13067)

tract_geoidstring nullable

Comma-separated list of 11-digit census tract GEOIDs (e.g. 13121011100)

block_group_geoidstring nullable

Comma-separated list of 12-digit census block group GEOIDs (e.g. 131210111001)

demographicstring nullable

Comma-separated demographic codes (e.g. all,black,hispanic)

detailstring nullable

Detail level (whatever the topic publishes — e.g. schools, districts, counties, or states).

limitinteger nullable

Page size

offsetinteger

Page offset

columnsstring nullable

Comma-separated output columns to return (fact columns plus joined dimension attributes). Defaults to all.

format'json' | 'csv' | 'parquet'

Response format: json | csv | parquet

Response

Paginated rows. JSON returns an envelope with data and pagination; CSV/Parquet return raw bytes with X-Total-Count header.

unknown required

Changes

No recorded changes to this operation across all 1 revision of this API.