"sonomacounty-ca-gov/defaulted-tax-data-bp8v-uax7:latest"."defaulted_tax_data"

SELECT
    ":id", -- Socrata column ID
    "mailaddress2", -- Address line 2 except when MailAddress1 is C/O or DBA.  
    "mailaddress1", -- Address line 1 or C/O or DBA (Doing Business As)
    "defaultamt", -- 1st year of defaulted tax and penalties. Base Tax amount + Ten Percent Penalty + Cost Charge
    "assessment_roll_year", -- The year the bill was placed on the tax roll.
    "location_city_state", -- The city state location of the property.
    "location_address", -- The street address location of the property.
    "collection_code2", -- Set when payment is recorded.
    "fullredemptionpaid", -- Prior year taxes paid.
    "exemption_code1", -- Code = Description,  E01 =  Homeowner,  E04 =  Disabled Vet Spouse 100,000,  E06 =  Disabled Vet 100,000,  E08 =  Welfare-Charitable,  E16 =  Cemetery,  E17 =  Church,  E18 =  Free Museum/Library,  E21 =  Public School,  E22 =  Religious-One Time Filing,  E97 =  Hox Penalty (used for roll corrections),  E99 =  Low Value 
    "billednetvalue", -- The billed net value of the assessment.
    "billedgrowingimprvalue", -- Assessment billed for agricultural improvements value on property.
    "billedfixedimprvalue", -- Assessment billed for fixed improvements value on property.
    "billedmarketlandvalue", -- Bill value. If an original bill, amount represents total value. If original bill is paid, amount represents net change.  If reassessment results in a lower value, amount shown could be negative.
    "salenoticedate", -- When property becomes 5 years delinquent and the tax collector records the power to sell.  
    "mailaddress3", -- Address line 2 when MailAddress1 is C/O or DBA.  In all other cases City, State, zip
    "defaultnum", -- Systematically assigned number for secured records that go unpaid past their fiscal year.
    "secured_delinq_penality_amt_paid", -- The interest calculated for assessment from July 1st of the fiscal year through paid as of date.
    "billedpersonalpropmhvalue", -- he billed amount of personal property mobile home value on the assessment.
    "billedpersonalpropvalue", -- The billed amount of personal property value on the assessment.
    "taxability", -- Code = Description, 0 =  Normal Ownership,  1 =   Business, Ownership,  2 =  Zero Value Property,  10 =  Senior Citizens Postponement,  12 =  Low Value Real Property,  34 =  Taxable Gov’t Entity Section 11,   44 =  Gov’t Restricted Affordable Housing,  50 =  Property Under CLCA,  51 =  Property under CLCA/Business,  60 =  Tax Postponed (Sr Citizens Postponement),  70 =  Common Area,  600 =  Timber Preserve,  800 =  Prop 8 Reduction-Manual,  801 =  Prop 8 Reduction w Bus/Manual,  850 =  Prop 8 w/Contract CLCA,  860 =  Prop 8 Tax Postponed,  870 =  Prop 8 Value Uploaded,  871 =  Prop 8 Automatic Reduction w/business 
    "originating_assessment_number", -- The original assessment number on parcel splits.
    "originating_assessment", -- The parcel that originated the tax bill.
    "assessment_number", -- 1st 3 Characters = Book, 2nd 3 Characters = Page, 3rd 3 Characters = Parcel, 4th 3 Characters = Sub Parcel
    "base_tax_amount", -- Total tax amount for the 2nd installment.  
    "redeemed_date", -- Date default record is payed.
    "feeparcel", -- The parcel where the assessment is located.
    "taxyear", -- Tax rate year.
    "tax_rate_area", -- The original tax rate area for a delinquent assessment.
    "exemption_amount2", -- The amount of the exemption
    "mailaddress4", -- Address line 3 when MailAddr1 is C/O or DBA.
    "paid_amount", -- This represents the tax amount paid - Base_Tax_Amount + Ten_Percent_Penalty_Amount (if paid) + Cost_Charge (if paid) for redemptions.
    "isagpreserve", -- The property is an agricultural preserve.
    "default_date", -- The date the assessment defaulted.
    "ten_percent_penality_amount", -- Penalty amount for the Base_Tax_Amount. Always set, delinquent or not.
    "exemption_amount1", -- The amount of the exemption.  
    "billedstructuralimprvalue", -- Assessment billed for structural improvements value on property.
    "redemption_fee",
    "bill_date", -- The date the bill was printed.
    "exemption_code2", -- Code = Description,  E01 =  Homeowner,  E04 =  Disabled Vet Spouse 100,000,  E06 =  Disabled Vet 100,000,  E08 =  Welfare-Charitable,  E16 =  Cemetery,  E17 =  Church,  E18 =  Free Museum/Library,  E21 =  Public School,  E22 =  Religious-One Time Filing,  E97 =  Hox Penalty (used for roll corrections),  E99 =  Low Value 
    "existsbankruptcy", -- A bankruptcy exists on the assessment.
    "cost_charge", -- Second installment penalty cost charge.
    "redemptiontotalfees" -- Total redemption fees paid.
FROM
    "sonomacounty-ca-gov/defaulted-tax-data-bp8v-uax7:latest"."defaulted_tax_data"
LIMIT 100;

sgr mount socrata \
  "sonomacounty-ca-gov/defaulted-tax-data-bp8v-uax7" \
  --handler-options '{
    "domain": "data.sonomacounty.ca.gov",
    "tables": {
        "defaulted_tax_data": "bp8v-uax7"
    }
}'