Enforcement Case Search (new version)
The get_case_info service end point searches for civil enforcement and criminal cases based on the provided selection criteria and returns either individual cases or clusters of case facility locations.
Query parameters
Output Format Flag. Enter one of the following keywords:
- JSON = Data model formatted as Javascript Object Notation (default).
- JSONP = Data model formatted as Javascript Object Notation with Padding.
- XML = Data model formatted as Extensible Markup Language.
Case Category Filter. Enter one or more case category codes to filter results. Provide multiple values as a comma-delimited list.
- AFR = Administrative - Formal
- AIF = Administrative - Informal
- JDC = Judicial
Case Status Code Filter. Enter one or more case status codes to limit results. Provide multiple values as a comma-delimited list.
Administrative or Judicial Milestone Filter. Enter one or milestone values to restrict results. Provide multiple values as a comma-delimited list.
Administrative or Judicial Milestone Date Range Start Limiter. Enter a date value in MM/DD/YYYY format to limit milestone results. Parameter p_to_date must also be populated when using this parameter option.
Administrative or Judicial Milestone Date Range End Limiter. Enter a date value in MM/DD/YYYY format to limit milestone results. Parameter p_from_date must also be populated when using this parameter option.
Administrative or Judicial Milestone Fiscal Year Limiter. Enter a single fiscal year value to limit milestone searches to a given fiscal year.
Case Name Filter. Enter one or more case names to restrict results. Provide multiple values as a comma-delimited list. When using this parameter the p_name_type parameter is required.
Case Name Filter Modifier.
Case Number Filter. Enter one or more case numbers to restrict results. Provide multiple values as a comma-delimited list.
DOJ Docket Number Filter. Enter a single docket number or partial docket number to restrict results. Use "%" as a wildcard for more complex filtering.
Case Activity Number Filter. Enter a single case activity number to filter results.
Case Lead Limiter. Enter E or S to limit results.
- E = EPA is the case lead.
- S = The state is the case lead.
Case Sensitive Data Flag. Enter a Y or N to include or exclude cases with sensitive data.
EPA Region Filter. Provide a single value of 01 thru 10 to restrict results to a single EPA region.
Case Location State Filter. Enter one or more state USPS postal codes to filter results. Provide multiple values as a comma-delimited list.
Case Location Court District Limiter. Enter a single state court district code to limit results.
Standard Industrial Classification (SIC) Code Filter. Enter a single 4-digit SIC Code to filter results.
Case Location SIC/NAICS And/Or Modifier. Enter either AND or OR to govern the search logic of SIC and NAICS codes.
- AND = Search will return results having both the provided SIC code(s) and provided NAICS code(s).
- OR = Search will return results having either the provided SIC code(s) or the provided NAICS code(s).
Case Location Primary SIC Flag. Enter Y to limit SIC search results to primary SIC codes only.
Case Location Extended FRS SIC Search Flag. Enter Y to expand SIC search to include Federal Registry Service datasets.
North American Industry Classification System Filter. Enter two to six digits to filter results to facilities having matching NAICS codes. Digits less than six will match to all codes beginning with the provided values.
Case Location Primary NAICS Flag. Enter Y to limit NAICS search results to primary NAICS codes only.
Case Location Extended FRS NAICS Search Flag. Enter Y to expand NAICS search to include Federal Registry Service datasets.
Case Enforcement Type Filter. Enter one or more case enforcement type codes to limit results. Provide multiple values as a comma-delimited list.
Law Statute Code Filter. Enter a single statute code to limit results.
Law Section Code Filter. Enter one or more law section codes to limit results. Provide multiple values as a comma-delimited list.
Law Section Code Filter Alternative. Enter a single law section code to limit results. This parameter accepts partial codes and allows for advanced search modifiers.
Law Status Rank Order Limiter. Enter a single integer rank order to limit results.
Enforcement Program Code Limiter. Enter one or more enforcement program codes to limit results. Provide multiple values as a comma-delimited list.
Violation Type Code Filter. Enter one or more violation type codes to limit results. Provide multiple values as a comma-delimited list.
Case Priority Area Filter. Enter one or more case priority areas to limit results. Provide multiple values as a comma-delimited list.
Case Priority Area Description Filter. Enter a single case priority area description or partial case priority area description to limit results. Use "%" as a wild-card match for more complex searches.
Case Location Tribal Land Flag. Enter Y or N to include or disallow cases on tribal land.
OECA Core Program Flag. Enter Y or N to include or exclude core program cases.
Enforcement Multimedia Case Flag. Enter Y or N to include or exclude multimedia cases.
Federal Facility Involvement Flag. Enter a Y or N to include or exclude cases involving federal facilities.
Activity Contact Last Name Filter. Enter a single last name or partial last name to filter results. Use "%" as a wild-card for advanced searching.
Activity Contact Role Code Filter. Enter a single role code to restrict results.
Federal Penalty Assessed Amount Filter. Provide one of the following keywords to restrict results.
- ANY = cases with any penalty amount.
- LE5000 = cases with penalty amount less than or equal to $5,000.
- GT5000 = cases with penalty amount more than $5,000.
- GT50000 = cases with penalty amount more than $50,000.
- GT100000 = cases with penalty amount more than $100,000.
- GT500000 = cases with penalty amount more than $500,000.
- GT1000000 = cases with penalty amount more than $1,000,000.
- GT2500000 = cases with penalty amount more than $2,500,000.
Total Federal Penalty Limiter. Enter a keyword value to limit results to cases with given total federal penalties.
- ANY = Cases with any federal penalty greater than zero.
- LEXX = Replacing XX with a dollar value, return cases with federal penalty less than or equal to the given amount.
- GTXX = Replacing XX with a dollar value, return cases with federal penalty greater than the given amount.
Cost Recovery Awarded Amount Limiter. Enter a keyword value to limit results to cases with given cost recovery amounts.
- ANY = Cases with any cost recovery amount greater than zero.
- LEXX = Replacing XX with a dollar value, return cases with cost recovery amount less than or equal to the given amount.
- GTXX = Replacing XX with a dollar value, return cases with cost recovery amount greater than the given amount.
Total Cost Recovery Amount Limiter. Enter a keyword value to limit results to cases with given cost recovery amounts.
- ANY = Cases with any cost recovery amount greater than zero.
- LEXX = Replacing XX with a dollar value, return cases with cost recovery amount less than or equal to the given amount.
- GTXX = Replacing XX with a dollar value, return cases with cost recovery amount greater than the given amount.
Complying Actions Type Code Limiter. Enter one or more complying action codes to restrict results. Provide multiple values as a comma-delimited list.
Compliance Action Cost Limiter. Enter a keyword value to limit results to cases with given compliance cost amounts.
- ANY = Cases with any compliance cost amount greater than zero.
- LEXX = Replacing XX with a dollar value, return cases with compliance cost amount less than or equal to the given amount.
- GTXX = Replacing XX with a dollar value, return cases with compliance cost amount greater than the given amount.
Total Compliance Action Amount Limiter. Enter a keyword value to limit results to cases with given total compliance action amounts.
- ANY = Cases with any total compliance action amount greater than zero.
- LEXX = Replacing XX with a dollar value, return cases with total compliance action amount less than or equal to the given amount.
- GTXX = Replacing XX with a dollar value, return cases with total compliance action amount greater than the given amount.
Supplemental Environmental Projects Activity Category Code Limiter. Provide one or more SEP activity category codes to limit results. Provide multiple values as a comma-delimited list.
Supplemental Environmental Projects Activity Value Limiter. Provide a keyword to limit results.
- ANY = return cases with any SEP activity amount.
- LE10000 = return cases with SEP activity amount less than or equal to $10,000.
- GT10000 = return cases with SEP activity amount greater than $10,000.
- GT50000 = return cases with SEP activity amount greater than $50,000.
- GT100000 = return cases with SEP activity amount greater than $100,000.
- GT500000 = return cases with SEP activity amount greater than $500,000.
- GT1000000 = return cases with SEP activity amount greater than $1,000,000.
Supplemental Environmental Projects Total Value Limiter. Provide a keyword to limit results.
- ANY = return cases with any SEP total amount.
- LE10000 = return cases with SEP total amount less than or equal to $10,000.
- GT10000 = return cases with SEP total amount greater than $10,000.
- GT50000 = return cases with SEP total amount greater than $50,000.
- GT100000 = return cases with SEP total amount greater than $100,000.
- GT500000 = return cases with SEP total amount greater than $500,000.
- GT1000000 = return cases with SEP total amount greater than $1,000,000.
Settlement Lodged Date Limiter. Enter a single settlement lodged date in MM/DD/YYYY format to limit results.
Settlement Entered Date Limiter. Enter a single settlement entered date in MM/DD/YYYY format to limit results.
Case Facility Registration Identifier Limiter. Enter a single complete facility identifier to limit results.
Case Facility City Limiter. Enter a single complete city name to filter cases by facility location city.
Case Facility ZIP Code Limiter. Enter a single 5-digit zip code to filter cases by facility location zip code.
Case Facility County Limiter. Enter a single complete county name to filter cases by facility location county name.
Case Summary Search Limiter. Enter a single case summary to limit results. This parameter accepts partial codes and allows for advanced search modifiers.
Identifies how the the search terms enterened in p_case_summary are searched. Valid values are ALL (Default), WITHIN, and CONTAINS. Must be used with p_case_summary.
US-Mexico Border Flag. Enter Y/N to restrict searches to facilities located within 100KM of the border.
In decimal degrees. Latitude of 1st corner of box that bounds the resulting facilities. The latitude and longitude of both corners of the bounding box must be provided.
In decimal degrees. Longitude of 1st corner of box that bounds the resulting facilities. The latitude and longitude of both corners of the bounding box must be provided.
In decimal degrees. Latitude of 2nd corner of box that bounds the resulting facilities. The latitude and longitude of both corners of the bounding box must be provided.
In decimal degrees. Longitude of 2nd corner of box that bounds the resulting facilities. The latitude and longitude of both corners of the bounding box must be provided.
Voluntary Self Disclosure Flag. Enter Y or N to include or exclude cases results having voluntary disclosure.
Federal Facility/Cross Media Flag. Enter Y or N to limit results to cases with federal facility cross media.
Controls type of text search performed on facility name with parameter p_fn.
- EXACT = Find facilities having the exact provided name(s).
- BEGINS = Find facilities with names starting with the provided term(s).
- ALL = Find facilities using Oracle text search terms.
- CONTAINS =
Civil/Criminal Case Limiter. Provide a keyword to limit results.
- ANY = return both civil and criminal cases.
- CI = return only civil cases.
- CR = return only criminal cases.
Query Limiter. Enter a value to limit the number of records returned for each query. Value cannot exceed 70,000.
Response Set Limiter. Enter a value to limit the number of records per page. Value cannot exceed 1,000.
Identifies the maxium number of case facilities to return from the case_rest_services.get_case_info query.
JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response.
Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.
Optional flag to request GeoJSON formatted results to be pretty printed. Only provide a numeric value when the output needs to be human readable as pretty printing has a performance cost.
Fiscal Year to select cases that are displayed in the Office of Complicance Fiscal Year Map Services
Quick Search. Allows entry for city, state, and/or zip code.
Response
Returns an array of cases that meet the selection criteria.
Example response
{
"Results": {
"AFRRows": "5",
"CERCLARows": "50",
"CWARows": "50",
"Cases": [
{
"ActivityId": "???",
"CaaFlag": "1",
"CaseCategoryCode": "AIF",
"CaseCategoryDesc": "Administrative - Informal",
"CaseName": "Baltes Real Estate Company",
"CaseNumber": "05-200021274",
"CaseStatusCode": "ACH",
"CaseStatusDesc": "Achieved",
"CerclaFlag": "1",
"CivilCriminalIndicator": "CI",
"CostRecovery": "0",
"CwaFlag": "1",
"DOJDocketNmbr": "Achieved",
"DateClosed": "07/21/2011",
"DateFiled": "01/19/2005",
"DateLodged": "04/28/2009",
"EnfOutcome": "Final Order With Penalty",
"EpcraFlag": "1",
"FedPenalty": "$3,000.00",
"FederalFlag": "1",
"FifraFlag": "1",
"Lead": "EPA",
"MaxScore": "1",
"PrimaryLaw": "TSCA",
"PrimaryNAICSCode": "237310",
"PrimarySICCode": "1220",
"PrimarySection": "409",
"RcraFlag": "1",
"SEPCategories": "0",
"SEPCost": "$4,100.00",
"SEPTexts": "0",
"SdwaFlag": "1",
"SettlementCnt": "1",
"SettlementDate": "05/5/2005",
"TotalCompActionAmt": "279450"
}
],
"ClusterOutput": {
"ClusterData": [
{
"AFRRows": "5",
"CAARows": "50",
"CERCLARows": "50",
"CWARows": "50",
"ClusterLatitude": "38.904149",
"ClusterLongitude": "-77.017094",
"CriminalRows": "0",
"EPCRARows": "50",
"FIFRARows": "50",
"FedPenRows": "3",
"FederalRows": "50",
"JDCRows": "2",
"ObjectId": "1",
"RCRARows": "50",
"SDWARows": "50",
"SEPRows": "0",
"TSCARows": "50"
}
]
},
"ClusterRecords": "199",
"CriminalRows": "0",
"EPCRARows": "50",
"FIFRARows": "50",
"FedPenRows": "3",
"FederalRows": "50",
"JDCRows": "2",
"MapLocations": "200",
"Message": "Success",
"QueryParameters": [
{
"QP": "output",
"QV": "JSON"
}
],
"QueryRows": "5",
"RCRARows": "50",
"SDWARows": "50",
"SEPRows": "0",
"TSCARows": "50"
}
}