• uniform_commercial_code_ucc_collateral_information
    0 Objects
     |  | 
    SELECT
    ":id", -- Socrata column ID
    "county", -- Name of counties associated with this collateral record, derived from countyId field.
    "fileid", -- Primary key link between filing, debtor, secured party, and collateral information. The state assigned identification number (unique) for the collateral entity.
    "farmproductendyear", -- Ending crop year for this crop.
    "actionreferenceid", -- The coll_id for the collateral item related to the record.
    "actiontype", -- Full description of type of action being performed when this collateral is recorded (A=add, B=change and delete, C=change only, D=delete only)
    "collateralid", -- The state assigned identification number (unique) for the collateral entity file.
    "farmproductflag", -- Flag indicating if the collateral code is for a farm product. Changes from source: Y's changed to 1 and N's changed to 0.
    "recordstatuscode", -- Designated codifier for inactive or active. If there was a change made that impacted the record, then the old listing associated becomes inactive. If a listing is 'deleted' from a filing, it is also listed as inactive.
    "collateraldescription", -- Type of crop or farm product, each categorized as types of livestock, field crops or other.
    "actiontypecode", -- Type of action being performed when this collateral is recorded (A=add, B=change and delete, C=change only, D=delete only)
    "farmproductallyears", -- Flag indicating if the selection of all years was made for reporting of this farm product. Changes from source: Y's changed to 1 and N's changed to 0.
    "countyid", -- Code for counties associated with this collateral record.
    "farmproductstartyear", -- Starting crop year for this crop.
    "additionalcollateraldescription", -- Notes, comments and other descriptive information on the type of crop or farm product.
    "recordstatus" -- Inactive or active designation, full description. If there was a change made that impacted the record, then the old listing associated becomes inactive. If a listing is 'deleted' from a filing, it is also listed as inactive.
    FROM
    "colorado-gov/uniform-commercial-code-ucc-collateral-information-4am6-w6u4:latest"."uniform_commercial_code_ucc_collateral_information"
     
     
    הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
     
     
     
     
     
    Failed
    Error: TypeError: Failed to fetch
Loading...