Description
Return queriedAt-start and end-queriedAt and test start-inclusive/end-exclusive active membership.
Cross-source records often use different labels, time spans, and support conventions. Exact equality and overlap checks describe the supplied metadata; they do not prove that sources measure the same social or geographic concept.
Return queriedAt-start and end-queriedAt and test start-inclusive/end-exclusive active membership.
When to use this tool
Use Territory Code Effective Gap when you need a literal source comparison or coverage diagnostic.
How to use the tool and how it works
- Enter effectiveFrom, effectiveUntil, queriedAt. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read fromStart, untilEnd, active. Inspect active before interpreting the associated values.
Require effectiveUntil no earlier than effectiveFrom. Return queriedAt-start and end-queriedAt and test start-inclusive/end-exclusive active membership.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| effectiveFrom | Effective From | Required. Finite number. |
| effectiveUntil | Effective Until | Required. Finite number. |
| queriedAt | Queried At | Required. Finite number. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| fromStart | From Start | Required. Finite number. |
| untilEnd | Until End | Required. Finite number. |
| active | Active | Required. Boolean. |
{
"input": {
"effectiveFrom": 10,
"effectiveUntil": 20,
"queriedAt": 15
},
"output": {
"fromStart": 5,
"untilEnd": 5,
"active": true
}
}Limitations and assumptions
- Time coordinates share units; code authority, territorial identity, sovereignty, actual effective records, and legal status are not inferred.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Inspect the original source definitions and collection methods. Harmonize conceptual scope and timing before treating matching labels or overlapping records as comparable evidence.
References
Similar or alternative tools
- Public Territory Period Share
Sum duration for selectedTerritory and its supported subset, dividing or returning zero with defined false for no selected duration.
- Country Comparison Fiscal Year Overlap
Return overlap duration and its share of each separate interval.