H-2B Non-Agricultural Labor Certifications
H-2B temporary non-farm worker positions the Labor Department certified for Georgia worksites each fiscal year, by county, occupation, cap status, nature of need and outcome.
- 2020–2026
- quarterly
- 1.1.0
- 216345ac1472
Resumen
Positions certified by the U.S. Department of Labor for H-2B temporary non-agricultural workers at Georgia worksites, by federal fiscal year: the job slots DOL's Office of Foreign Labor Certification (OFLC) approved on each employer's H-2B application, with the positions requested and the number of applications decided. Statewide by case outcome, occupation (SOC), whether the workers are subject to the H-2B visa cap and the employer's stated nature of the temporary need (seasonal, peakload, one-time occurrence, intermittent), and by the county of the application's first worksite. From OFLC's H-2B program disclosure data, FY2020 through the third quarter of FY2026.
Granularidad de fila: Una fila por year, county_fips, case_status, soc_occupation, cap_status, nature_of_need.
num_positions_certified — H-2B Positions Certified (count)
El valor principal que la mayoría de las consultas busca.
Variables
Todas las columnas de la tabla de hechos. El código es el nombre exacto del campo que devuelve la API.
| Columna | Tipo | Unidad | Rango | ¿Nulo? | Descripción |
|---|---|---|---|---|---|
year | integer | — | — | no | Federal fiscal year (October 1 - September 30; FY2025 = October 1, 2024 - September 30, 2025) of DOL's final determination on the application (its decision date), NOT the calendar year. FY2020-FY2026. FY2026 is partial: decisions through June 30, 2026 only, with no Georgia decision before November 4, 2025 (the October 1 - November 12, 2025 federal shutdown); it will be replaced by the full-year file.Descripción completa▾Federal fiscal year (October 1 - September 30; FY2025 = October 1, 2024 - September 30, 2025) of DOL's final determination on the application (its decision date), NOT the calendar year. FY2020-FY2026. FY2026 is partial: decisions through June 30, 2026 only, with no Georgia decision before November 4, 2025 (the October 1 - November 12, 2025 federal shutdown); it will be replaced by the full-year file. |
county_fips | string | — | — | yes | 5-digit FIPS of the county of the application's first worksite. NULL on statewide rows. Where the worksite street address geocodes with certainty to another county and a second sign agrees (DOL's county holds under 5% of the worksite ZIP's residents, or the address lies at least 500 m from DOL's county in a county holding some of the ZIP's residents), the address's county replaces DOL's (88 applications); it also fills 4 counties DOL left blank. At addresses the geocoder cannot match (or matches in a county the records contradict), the county's own tax-parcel records set the county (18 applications: 0 moved from DOL's county, 0 filled where DOL left it blank; at 17 of them, landmark sites, a parcel found by owner name or map location and confirmed by an independent source). Where DOL's stated county is impossible for the worksite ZIP code (none of the ZIP's 2020 population lives there), it is replaced by the ZIP's county only when certain - at least 99% of the ZIP in that county and the city confirming the ZIP (1 application); 8 applications that fail the test keep DOL's county (see limitations). Where DOL left the worksite county blank the county comes from the street address or, failing that, the worksite ZIP code; applications with no placeable county count in statewide rows only.Descripción completa▾5-digit FIPS of the county of the application's first worksite. NULL on statewide rows. Where the worksite street address geocodes with certainty to another county and a second sign agrees (DOL's county holds under 5% of the worksite ZIP's residents, or the address lies at least 500 m from DOL's county in a county holding some of the ZIP's residents), the address's county replaces DOL's (88 applications); it also fills 4 counties DOL left blank. At addresses the geocoder cannot match (or matches in a county the records contradict), the county's own tax-parcel records set the county (18 applications: 0 moved from DOL's county, 0 filled where DOL left it blank; at 17 of them, landmark sites, a parcel found by owner name or map location and confirmed by an independent source). Where DOL's stated county is impossible for the worksite ZIP code (none of the ZIP's 2020 population lives there), it is replaced by the ZIP's county only when certain - at least 99% of the ZIP in that county and the city confirming the ZIP (1 application); 8 applications that fail the test keep DOL's county (see limitations). Where DOL left the worksite county blank the county comes from the street address or, failing that, the worksite ZIP code; applications with no placeable county count in statewide rows only. |
case_status | string | — | — | no | DOL's decision: certified, partially certified, withdrawn, denied, rejected, or all.Descripción completa▾OFLC's final determination on the application: 'certified' (certified in full), 'partially_certified' (certified only in part: almost always fewer positions than requested; on a few applications every requested position is certified for the same period, and the disclosure data do not say what part was not certified), 'withdrawn' (by the employer), 'denied', 'rejected' (an incomplete filing returned without a decision on the merits); 'all' = every application. Certifications DOL marks '(Returned)' - returned to DOL unused, most often because the visa cap was reached - are folded into their base status, as in DOL's totals. Statewide rows only; county rows are 'all'. 6 valores permitidos▾
|
soc_occupation | string | — | — | no | Occupation (SOC) of the job: top five, other, all.Descripción completa▾Occupation of the job (Standard Occupational Classification; O*NET detail codes folded to the SOC): 'landscaping_groundskeeping_workers' = SOC 37-3011 Landscaping and Groundskeeping Workers; 'forest_conservation_workers' = SOC 45-4011 Forest and Conservation Workers; 'meat_poultry_fish_cutters_trimmers' = SOC 51-3022 Meat, Poultry, and Fish Cutters and Trimmers; 'maids_housekeeping_cleaners' = SOC 37-2012 Maids and Housekeeping Cleaners; 'hand_packers_packagers' = SOC 53-7064 Packers and Packagers, Hand; 'other' = every other occupation (highway maintenance workers, construction laborers, dishwashers, amusement attendants, cooks, ...); 'all' = every occupation. The five named codes hold the most Georgia positions certified over FY2020-FY2026. Statewide rows only; county rows are 'all'. 7 valores permitidos▾
|
cap_status | string | — | — | no | Whether the application's workers count against the H-2B visa cap: subject, exempt, mixed, unknown, or all.Descripción completa▾Whether the application's H-2B workers are subject to the statutory annual H-2B visa cap - an application-level label: 'cap_subject' (all subject), 'cap_exempt' (all exempt), 'mixed' (some of each), 'unknown' (neither reported: 1 FY2026 application); 'all' = every application. The source changes in FY2024: through FY2023 the application's yes/no CAP_EXEMPT flag (so 'mixed' cannot occur); from FY2024 the requested-worker counts CAP_SUBJECT_WORKERS / CAP_EXEMPT_WORKERS (24 FY2024 applications on the older form use the flag). A mixed application's positions are not split. Statewide rows only; county rows are 'all'. 5 valores permitidos▾
|
nature_of_need | string | — | — | no | The employer's basis for a temporary need: one-time occurrence, seasonal, peakload, intermittent, or all.Descripción completa▾The basis on which the employer's need for H-2B workers is temporary, as stated on the application (Form ETA-9142B Section B, item 7, NATURE_OF_TEMPORARY_NEED; the four standards of 8 CFR 214.2(h)(6)(ii)(B)): 'one_time_occurrence' (a need that has not arisen before and will not recur), 'seasonal' (tied to a season or event, recurring each year), 'peakload' (permanent staff supplemented during a short peak), 'intermittent' (occasional short-term needs); 'all' = every application. No Georgia application stating an intermittent need was certified in FY2020-FY2026: 22 applications, all denied, rejected or withdrawn. The employer's claim, which DOL reviews; an application-level label. Added in version 1.1.0. Statewide rows only; county rows are 'all'. 5 valores permitidos▾
|
num_positions_certified | integer | — | yes | H-2B non-farm worker positions DOL certified in the fiscal year.Descripción completa▾Number of H-2B worker positions OFLC certified on the applications decided in the fiscal year (sum of TOTAL_WORKERS_CERTIFIED; blank on withdrawn, denied and rejected applications, counted 0). Job slots approved, not workers admitted or visas issued. DOL publishes no Georgia H-2B total; the national sum of the same field equals DOL's published positions certified exactly. | |
num_positions_requested | integer | — | yes | H-2B positions the employers requested.Descripción completa▾Number of H-2B workers the same applications requested (sum of TOTAL_WORKERS_REQUESTED, every status; blank on five FY2023 rejected filings, counted 0). Positions certified divided by positions requested is the share certified. | |
num_applications | integer | — | yes | H-2B applications DOL decided in the fiscal year.Descripción completa▾Number of H-2B applications (Form ETA-9142B) on which OFLC issued a final determination (or which were withdrawn or rejected) in the fiscal year. |
Filtros
Parámetros de consulta que acepta el endpoint de filas del conjunto de datos (/rows), y también sus rutas /values, /aggregate y /download. Los valores separados por comas o repetidos son OR dentro de un parámetro; varios parámetros se combinan con AND.
| Parámetro | Tipo | Valores permitidos | Notas |
|---|---|---|---|
year | year_exact | cualquier valor | valores múltiples |
year_min | year_range | cualquier valor | — |
year_max | year_range | cualquier valor | — |
detail | detail | countiesstates | enum validado, predeterminado: states |
county_fips | foreign_key | cualquier valor | valores múltiples |
case_status | categorical | allcertifiedpartially_certifiedwithdrawndeniedrejected | valores múltiples, enum validado |
soc_occupation | categorical | 7 valores permitidos▾
| valores múltiples, enum validado |
cap_status | categorical | allcap_subjectcap_exemptmixedunknown | valores múltiples, enum validado |
nature_of_need | categorical | allone_time_occurrenceseasonalpeakloadintermittent | valores múltiples, enum validado |
num_positions_certified_min | metric_bound | cualquier valor | — |
num_positions_certified_max | metric_bound | cualquier valor | — |
num_positions_requested_min | metric_bound | cualquier valor | — |
num_positions_requested_max | metric_bound | cualquier valor | — |
num_applications_min | metric_bound | cualquier valor | — |
num_applications_max | metric_bound | cualquier valor | — |
Ejemplos de solicitudes
Ejecútalos contra la URL base: devuelven datos en vivo.
All rows (first page), states level
curl "https://georgiacivicdata.org/api/v1/datasets/h2b_certifications/rows"states data for 2026
curl "https://georgiacivicdata.org/api/v1/datasets/h2b_certifications/rows?year=2026"Filtered to case_status = certified for 2026
curl "https://georgiacivicdata.org/api/v1/datasets/h2b_certifications/rows?year=2026&case_status=certified"One county (FIPS 13121), 2026
curl "https://georgiacivicdata.org/api/v1/datasets/h2b_certifications/rows?county_fips=13121&year=2026&detail=counties"Download every 2026 row as CSV
curl "https://georgiacivicdata.org/api/v1/datasets/h2b_certifications/download?year=2026&format=csv"Notas y limitaciones
Manejo de NULL
- El cero es un valor real y reportado.
Limitaciones
Federal fiscal years (October 1 - September 30), not calendar years: `year` is the fiscal year in which DOL's Office of Foreign Labor Certification issued its final determination on the application (the decision date), the basis DOL itself reports on. DOL publishes no Georgia H-2B total: its selected statistics list only the top 10 states, and Georgia (2.1%-2.9% of national positions certified) is never among them. The national totals of the same disclosure files - positions requested, positions certified, and applications by outcome - match DOL's published H-2B Selected Statistics exactly in every year, FY2020-FY2026 (DOL's FY2023 PDF prints 15,502 applications processed, one more than its own outcome rows and the file hold, 15,501). FY2026 is PARTIAL: it holds decisions through June 30, 2026 only (DOL's cumulative Q3 file) and will be replaced when DOL posts the full year; do not compare it with complete years. No decision is dated before November 3, 2025 nationally or November 4, 2025 in Georgia, so October 2025 is empty - a gap that falls within the October 1 - November 12, 2025 federal government shutdown. Positions certified are job slots DOL approved for temporary foreign non-agricultural workers, not workers admitted or visas issued: the employer must still petition USCIS - where cap-subject workers count against the annual H-2B visa cap - and each worker must obtain a visa, so fewer may arrive. Each fiscal year counts the determinations issued in it, as in DOL's own figures. Withdrawn, denied and rejected applications certify no positions (DOL leaves the count blank, counted 0 here); rejected applications are incomplete filings returned without a decision on the merits, and 5 FY2023 rejected applications left the requested count blank, counted 0. Geography is the application's FIRST worksite (its worksite state, county and ZIP). 67% of the FY2020-FY2026 Georgia applications report work at additional worksites (DOL's Appendix A), which may lie in other counties or states; those sites are not used, so each application is counted once, where its first worksite is, and an application whose first worksite is outside Georgia is not counted even if it also lists Georgia sites. Employer, agent and attorney addresses are never used. Worksite counties are checked against the worksite street address. The Census Bureau's geocoder located the Georgia worksite addresses in 2020 Census geography and matched 1,447 applications (75%) to the same street address (house number and street, or intersection) in the same ZIP code. For 1,348 of them the address lies in DOL's county. For 88 applications (2,470 positions certified; FY2020 7, FY2021 11, FY2022 10, FY2023 10, FY2024 12, FY2025 22, FY2026 16) it lies in another county and a second sign agrees DOL's county is wrong - DOL's county holds under 5% of the worksite ZIP's residents, or the address lies at least 500 m from DOL's county, too far for a small placement error to explain, in a county where some of the ZIP's residents live - so the address's county is used. It also gives a county to 4 applications DOL left blank (0 positions certified). For 7 applications (59 positions certified) the address points to another county but lies within 500 m of DOL's county, where a geocoder can err, and DOL's county holds at least 5% of the ZIP's residents, so DOL's county is kept; some are DOL errors and some geocoder errors, and the geocoder alone cannot tell which. 18 applications (196 positions certified) are at addresses the geocoder cannot match (or matches in a county the records contradict) whose county the county's own tax-parcel and address-point records settle (17 at landmark sites whose county parcel is filed under another address and was found by owner name or map location, each confirmed by an independent source), and take that county: 0 (0 positions) move from the county DOL gave, 0 fill a county DOL left blank, and 18 confirm DOL's county. Where the address could not settle it, DOL's own worksite county is sometimes impossible for the worksite ZIP code - none of the ZIP's 2020 population lives in it. Such a county is replaced only when the right one is certain: at least 99% of the ZIP's population lives in one other county, and the worksite city is the ZIP's postal name or a Census place in that county, and not also a place or postal name in the stated county. 1 Georgia application (0 positions certified) was moved to the ZIP's county this way (FY2025 1); it sits in 1 ZIP code, 0 wholly inside the new county and 1 at least 99% inside it. Another 8 applications (216 positions certified) keep a stated county that is impossible for their ZIP, because the evidence falls short of certain: in 2 the ZIP straddles a county line and in 6 the city does not match the ZIP (the ZIP itself may be mistyped). Their county may be wrong. DOL left the worksite county blank on 17 Georgia applications (FY2022 2, FY2023 7, FY2025 7, FY2026 1). 4 of them are placed by their street address (above); 11 (48 positions certified) are placed in the county holding most of the population of their worksite ZIP code (2020 Census); 1 of them sits in a ZIP code that straddles a county line. Where DOL does name the county (as corrected above), the ZIP's dominant county disagrees with it on 127 of the 1,895 Georgia applications whose ZIP is in the crosswalk (6.7%), so a recovered county may be the neighboring one. 2 FY2022 denied applications could not be placed (worksite ZIP 30026, 3026, not a Georgia ZIP in the crosswalk) and count in the state row only, so that year's county rows sum to 2 applications, 6 positions requested and 0 positions certified fewer than the state row. In every other year county rows sum exactly to the state row. `cap_status` says whether an application's workers count against the statutory H-2B cap, and its source changes with DOL's form, so the series breaks in FY2024: through FY2023 it is the application's single yes/no cap-exempt flag, so every application is wholly 'cap_subject' or 'cap_exempt' and none can be 'mixed'; from FY2024 the form reports how many of the requested workers are subject to the cap and how many are exempt, and an application with some of each is 'mixed' (FY2024 also includes 24 Georgia applications filed on the older form, classified by their flag); 'unknown' is a FY2026 rejected application that reports neither. It is an application-level label: the positions of a 'mixed' application are not split, because DOL reports the subject/exempt split for requested workers only, not for certified ones. `case_status` is the final determination. Certifications DOL marks '(Returned)' count as certified or partially certified, as in DOL's own totals, but the employer returned them to DOL: DOL's H-2B guidance lets an employer return a certification it no longer needs - typically unused, most often because the H-2B visa cap was reached - and file the same job again with a later start date (DOL does not define the label in the record layout; the return procedure is in its H-2B FAQs, https://www.dol.gov/sites/dolgov/files/ETA/oflc/pdfs/H-2B_Visa-Cap_FAQs_03.06.2020.pdf, and its H-2B webinars say only an unused certification may be returned). So the same job slots can be certified twice. Georgia's returned certifications: FY2020 14 applications, 399 positions (10%); FY2022 5 applications, 52 positions (1%); FY2023 6 applications, 195 positions (3%); FY2024 7 applications, 88 positions (1%); FY2025 6 applications, 121 positions (2%); FY2026 37 applications, 1,198 positions (20%). DOL's FY2021 file carries no '(Returned)' status at all, nationally, so returns cannot be identified in that year. `soc_occupation` names the five occupations (SOC codes) with the most Georgia positions certified over FY2020-FY2026 and groups every other occupation as 'other'. `nature_of_need` is the application's stated basis for the temporary need (one-time occurrence, seasonal, peakload, intermittent), as the employer filed it. County rows are totals only (every categorical 'all'); the breakdowns are statewide. No suppression: rows are applications (job orders), not people, so the domain's county small-cell rule does not apply, small county counts are published, and every zero is a real zero. Wages and employer identity are not published here.