Bills and Installments 5 Years or Newer

Dataset Info

Total Rows
10,914,039
Columns
25
Updated each Sunday for Roll Years 5 years old or newer - Payment and balance statuses, delinquency information, tax rate areas, and more.
Visit Dataset

AI Agent

Online
ATC OpenData Agent

SQL Expert • San Bernardino County

Hi, I'm ATC OpenData Agent!

I can help you explore this dataset, write SQL queries, and create visualizations. What would you like to know?

Chart Builder

Group your data by these columns (e.g., Year, Category, Name)
Numeric values to visualize (e.g., Amount, Count, Total)
5 20 100

Data Preview — 100 of 10,914,039 rows

Custom SQL Query SELECT Only
Query Error
Use [TableData] to reference the data table. Only SELECT queries are allowed.
Data preview table
Roll_YrAccount_NumberBill_NumberBalance_StatusAccount_StatusInstallment_NumberInstallment_BalanceRollBill_TypeBill_CategoryBill_AmountBill_BalanceTRA_CodeTRA_NameTax_Default_DateTax_Default_NumberDelinquent_AfterBalance_Paid_Processed_DateBalance_Paid_Effective_DateAssessment_YearBillable_Period_StartBillable_Period_EndMailed_DateTotal_Assessed_Value_This_AssessmentReturned_Payment_Fee
2025010829107000020250864535Paid in FullPaid in Full10SecuredSecuredAnnual00004-091ONTARIO CITY2025-12-102025-09-102025-09-1020252025-07-012026-06-302025-10-310
2025010829107000020250864535Paid in FullPaid in Full20SecuredSecuredAnnual00004-091ONTARIO CITY2026-04-102025-09-102025-09-1020252025-07-012026-06-302025-10-310
202601082910700002026P0837923Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601082910700002026P0837923Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2025010829113000020250864536Paid in FullPaid in Full10SecuredSecuredAnnual00004-091ONTARIO CITY2025-12-102025-09-102025-09-1020252025-07-012026-06-302025-10-310
2025010829113000020250864536Paid in FullPaid in Full20SecuredSecuredAnnual00004-091ONTARIO CITY2026-04-102025-09-102025-09-1020252025-07-012026-06-302025-10-310
202601082911300002026P0837924Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601082911300002026P0837924Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2025010829114000020250864537Paid in FullPaid in Full10SecuredSecuredAnnual00004-091ONTARIO CITY2025-12-102025-09-102025-09-1020252025-07-012026-06-302025-10-310
2025010829114000020250864537Paid in FullPaid in Full20SecuredSecuredAnnual00004-091ONTARIO CITY2026-04-102025-09-102025-09-1020252025-07-012026-06-302025-10-310
202601082911400002026P0837925Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601082911400002026P0837925Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2021010830101000020210000001Paid in FullPaid in Full10SecuredSecuredAnnual2312.370004-091ONTARIO CITY2021-12-102021-12-092021-12-0920212021-07-012022-06-302021-09-204170000
2021010830101000020210000001Paid in FullPaid in Full20SecuredSecuredAnnual2312.330004-091ONTARIO CITY2022-04-112022-04-072022-04-0720212021-07-012022-06-302021-09-204170000
2022010830101000020220000001Paid in FullPaid in Full10SecuredSecuredAnnual2379.310004-091ONTARIO CITY2022-12-122022-12-092022-12-0920222022-07-012023-06-302022-09-214350000
2022010830101000020220000001Paid in FullPaid in Full20SecuredSecuredAnnual2379.260004-091ONTARIO CITY2023-04-102023-04-072023-04-0720222022-07-012023-06-302022-09-214350000
2023010830101000020230000001Paid in FullPaid in Full10SecuredSecuredAnnual2656.270004-091ONTARIO CITY2023-12-112023-12-072023-12-0720232023-07-012024-06-302023-09-194890250
2023010830101000020230000001Paid in FullPaid in Full20SecuredSecuredAnnual2656.230004-091ONTARIO CITY2024-04-102024-04-082024-04-0820232023-07-012024-06-302023-09-194890250
2024010830101000020240000001Paid in FullPaid in Full10SecuredSecuredAnnual2733.090004-091ONTARIO CITY2024-12-102024-12-062024-12-0620242024-07-012025-06-302024-09-174988050
2024010830101000020240000001Paid in FullPaid in Full20SecuredSecuredAnnual2733.030004-091ONTARIO CITY2025-04-102025-04-082025-04-0820242024-07-012025-06-302024-09-174988050
2025010830101000020250864538UnpaidUnpaid13076.2SecuredSecuredAnnual2796.555872.74004-091ONTARIO CITY2025-12-1020252025-07-012026-06-302025-10-315087810
2025010830101000020250864538UnpaidUnpaid22796.54SecuredSecuredAnnual2796.545872.74004-091ONTARIO CITY2026-04-1020252025-07-012026-06-302025-10-315087810
202601083010100002026P0681720Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601083010100002026P0681720Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2021010830102000020210000002Paid in FullPaid in Full10SecuredSecuredAnnual1316.780004-091ONTARIO CITY2021-12-102021-12-092021-12-0920212021-07-012022-06-302021-09-202366060
2021010830102000020210000002Paid in FullPaid in Full20SecuredSecuredAnnual1316.740004-091ONTARIO CITY2022-04-112022-04-072022-04-0720212021-07-012022-06-302021-09-202366060
2022010830102000020220000002Paid in FullPaid in Full10SecuredSecuredAnnual13250004-091ONTARIO CITY2022-12-122022-12-092022-12-0920222022-07-012023-06-302022-09-212413380
2022010830102000020220000002Paid in FullPaid in Full20SecuredSecuredAnnual1324.970004-091ONTARIO CITY2023-04-102023-04-072023-04-0720222022-07-012023-06-302022-09-212413380
2023010830102000020230000002Paid in FullPaid in Full10SecuredSecuredAnnual1342.760004-091ONTARIO CITY2023-12-112023-12-072023-12-0720232023-07-012024-06-302023-09-192461650
2023010830102000020230000002Paid in FullPaid in Full20SecuredSecuredAnnual1342.710004-091ONTARIO CITY2024-04-102024-04-082024-04-0820232023-07-012024-06-302023-09-192461650
2024010830102000020240000002Paid in FullPaid in Full10SecuredSecuredAnnual1597.180004-091ONTARIO CITY2024-12-102024-12-062024-12-0620242024-07-012025-06-302024-09-172510880
2024010830102000020240000002Paid in FullPaid in Full20SecuredSecuredAnnual1597.150004-091ONTARIO CITY2025-04-102025-04-082025-04-0820242024-07-012025-06-302024-09-172510880
2025010830102000020250864539Paid in FullUnpaid10SecuredSecuredAnnual1413.591413.58004-091ONTARIO CITY2025-12-102025-12-092025-12-0920252025-07-012026-06-302025-10-312561090
2025010830102000020250864539UnpaidUnpaid21413.58SecuredSecuredAnnual1413.581413.58004-091ONTARIO CITY2026-04-1020252025-07-012026-06-302025-10-312561090
202601083010200002026P0681721Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601083010200002026P0681721Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2021010830103000020210000003Paid in FullPaid in Full10SecuredSecuredAnnual1033.160004-091ONTARIO CITY2021-12-102021-11-292021-11-2920212021-07-012022-06-302021-09-201922150
2021010830103000020210000003Paid in FullPaid in Full20SecuredSecuredAnnual1033.110004-091ONTARIO CITY2022-04-112022-03-182022-03-1620212021-07-012022-06-302021-09-201922150
2022010830103000020220000003Paid in FullPaid in Full10SecuredSecuredAnnual1078.510004-091ONTARIO CITY2022-12-122022-11-302022-11-3020222022-07-012023-06-302022-09-211960590
2022010830103000020220000003Paid in FullPaid in Full20SecuredSecuredAnnual1078.470004-091ONTARIO CITY2023-04-102023-03-162023-03-1620222022-07-012023-06-302022-09-211960590
2023010830103000020230000003Paid in FullPaid in Full10SecuredSecuredAnnual1092.970004-091ONTARIO CITY2023-12-112023-11-302023-11-3020232023-07-012024-06-302023-09-191999800
2023010830103000020230000003Paid in FullPaid in Full20SecuredSecuredAnnual1092.920004-091ONTARIO CITY2024-04-102024-04-012024-04-0120232023-07-012024-06-302023-09-191999800
2024010830103000020240000003Paid in FullPaid in Full10SecuredSecuredAnnual1124.510004-091ONTARIO CITY2024-12-102024-12-092024-12-0920242024-07-012025-06-302024-09-172039800
2024010830103000020240000003Paid in FullPaid in Full20SecuredSecuredAnnual1124.470004-091ONTARIO CITY2025-04-102025-04-082025-04-0820242024-07-012025-06-302024-09-172039800
2025010830103000020250864540Paid in FullUnpaid10SecuredSecuredAnnual1150.61150.6004-091ONTARIO CITY2025-12-102025-11-132025-11-1320252025-07-012026-06-302025-10-312080600
2025010830103000020250864540UnpaidUnpaid21150.6SecuredSecuredAnnual1150.61150.6004-091ONTARIO CITY2026-04-1020252025-07-012026-06-302025-10-312080600
202601083010300002026P0681722Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601083010300002026P0681722Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2021010830104000020210000004Paid in FullPaid in Full10SecuredSecuredAnnual959.540004-091ONTARIO CITY2021-12-102021-12-092021-12-0920212021-07-012022-06-302021-09-201788780
2021010830104000020210000004Paid in FullPaid in Full20SecuredSecuredAnnual959.510004-091ONTARIO CITY2022-04-112022-04-072022-04-0720212021-07-012022-06-302021-09-201788780
2022010830104000020220000004Paid in FullPaid in Full10SecuredSecuredAnnual966.340004-091ONTARIO CITY2022-12-122022-12-092022-12-0920222022-07-012023-06-302022-09-211824560
2022010830104000020220000004Paid in FullPaid in Full20SecuredSecuredAnnual966.310004-091ONTARIO CITY2023-04-102023-04-072023-04-0720222022-07-012023-06-302022-09-211824560
2023010830104000020230000004Paid in FullPaid in Full10SecuredSecuredAnnual980.070004-091ONTARIO CITY2023-12-112023-12-072023-12-0720232023-07-012024-06-302023-09-191861050
2023010830104000020230000004Paid in FullPaid in Full20SecuredSecuredAnnual980.020004-091ONTARIO CITY2024-04-102024-04-082024-04-0820232023-07-012024-06-302023-09-191861050
2024010830104000020240000004Paid in FullPaid in Full10SecuredSecuredAnnual1009.110004-091ONTARIO CITY2024-12-102024-12-062024-12-0620242024-07-012025-06-302024-09-171898270
2024010830104000020240000004Paid in FullPaid in Full20SecuredSecuredAnnual1009.050004-091ONTARIO CITY2025-04-102025-06-102025-06-0520242024-07-012025-06-302024-09-171898270
2025010830104000020250864541Paid in FullPaid in Full10SecuredSecuredAnnual1033.270004-091ONTARIO CITY2025-12-102025-10-292025-10-2820252025-07-012026-06-302025-10-311936240
2025010830104000020250864541Paid in FullPaid in Full20SecuredSecuredAnnual1033.270004-091ONTARIO CITY2026-04-102026-01-182026-01-1820252025-07-012026-06-302025-10-311936240
202601083010400002026P0681723Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-102026-02-202026-02-2020262026-07-012027-06-300
202601083010400002026P0681723Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-122026-02-202026-02-2020262026-07-012027-06-300
2021010830105000020210000005Paid in FullPaid in Full10SecuredSecuredAnnual1229.770004-091ONTARIO CITY2021-12-102021-11-292021-11-2820212021-07-012022-06-302021-09-202208420
2021010830105000020210000005Paid in FullPaid in Full20SecuredSecuredAnnual1229.740004-091ONTARIO CITY2022-04-112022-04-062022-04-0520212021-07-012022-06-302021-09-202208420
2022010830105000020220000005Paid in FullPaid in Full10SecuredSecuredAnnual1237.470004-091ONTARIO CITY2022-12-122022-12-052022-12-0220222022-07-012023-06-302022-09-212252590
2022010830105000020220000005Paid in FullPaid in Full20SecuredSecuredAnnual1237.430004-091ONTARIO CITY2023-04-102023-04-032023-03-3120222022-07-012023-06-302022-09-212252590
2023010830105000020230000005Paid in FullPaid in Full10SecuredSecuredAnnual1254.050004-091ONTARIO CITY2023-12-112023-12-052023-12-0420232023-07-012024-06-302023-09-192297640
2023010830105000020230000005Paid in FullPaid in Full20SecuredSecuredAnnual1254.020004-091ONTARIO CITY2024-04-102024-04-082024-04-0520232023-07-012024-06-302023-09-192297640
2024010830105000020240000005Paid in FullPaid in Full10SecuredSecuredAnnual1290.260004-091ONTARIO CITY2024-12-102024-11-192024-11-1820242024-07-012025-06-302024-09-172343590
2024010830105000020240000005Paid in FullPaid in Full20SecuredSecuredAnnual1290.220004-091ONTARIO CITY2025-04-102025-04-102025-04-0920242024-07-012025-06-302024-09-172343590
2025010830105000020250864542Paid in FullUnpaid10SecuredSecuredAnnual1320.211320.2004-091ONTARIO CITY2025-12-102025-12-052025-11-2620252025-07-012026-06-302025-10-312390470
2025010830105000020250864542UnpaidUnpaid21320.2SecuredSecuredAnnual1320.21320.2004-091ONTARIO CITY2026-04-1020252025-07-012026-06-302025-10-312390470
202601083010500002026P0681724Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601083010500002026P0681724Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2021010830106000020210000006Paid in FullPaid in Full10SecuredSecuredAnnual1088.520004-091ONTARIO CITY2021-12-102021-12-092021-12-0920212021-07-012022-06-302021-09-202022460
2021010830106000020210000006Paid in FullPaid in Full20SecuredSecuredAnnual1088.460004-091ONTARIO CITY2022-04-112022-04-072022-04-0720212021-07-012022-06-302021-09-202022460
2022010830106000020220000006Paid in FullPaid in Full10SecuredSecuredAnnual1096.110004-091ONTARIO CITY2022-12-122022-12-092022-12-0920222022-07-012023-06-302022-09-212062910
2022010830106000020220000006Paid in FullPaid in Full20SecuredSecuredAnnual1096.060004-091ONTARIO CITY2023-04-102023-04-102023-04-0720222022-07-012023-06-302022-09-212062910
2023010830106000020230000006Paid in FullPaid in Full10SecuredSecuredAnnual1111.560004-091ONTARIO CITY2023-12-112023-12-072023-12-0720232023-07-012024-06-302023-09-192104170
2023010830106000020230000006Paid in FullPaid in Full20SecuredSecuredAnnual1111.510004-091ONTARIO CITY2024-04-102024-04-082024-04-0820232023-07-012024-06-302023-09-192104170
2024010830106000020240000006Paid in FullPaid in Full10SecuredSecuredAnnual1144.410004-091ONTARIO CITY2024-12-102024-12-062024-12-0620242024-07-012025-06-302024-09-172146250
2024010830106000020240000006Paid in FullPaid in Full20SecuredSecuredAnnual1144.360004-091ONTARIO CITY2025-04-102025-04-082025-04-0820242024-07-012025-06-302024-09-172146250
2025010830106000020250864543Paid in FullUnpaid10SecuredSecuredAnnual1171.721171.71004-091ONTARIO CITY2025-12-102025-12-092025-12-0920252025-07-012026-06-302025-10-312189180
2025010830106000020250864543UnpaidUnpaid21171.71SecuredSecuredAnnual1171.711171.71004-091ONTARIO CITY2026-04-1020252025-07-012026-06-302025-10-312189180
202601083010600002026P0681725Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601083010600002026P0681725Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2021010830107000020210000007Paid in FullPaid in Full10SecuredSecuredAnnual2533.130004-091ONTARIO CITY2021-12-102021-12-092021-12-0920212021-07-012022-06-302021-09-204640000
2021010830107000020210000007Paid in FullPaid in Full20SecuredSecuredAnnual2533.090004-091ONTARIO CITY2022-04-112022-04-072022-04-0720212021-07-012022-06-302021-09-204640000
2022010830107000020220000007Paid in FullPaid in Full10SecuredSecuredAnnual2836.590004-091ONTARIO CITY2022-12-122022-12-092022-12-0920222022-07-012023-06-302022-09-215260000
2022010830107000020220000007Paid in FullPaid in Full20SecuredSecuredAnnual2836.560004-091ONTARIO CITY2023-04-102023-04-072023-04-0720222022-07-012023-06-302022-09-215260000
2023010830107000020230000007Paid in FullPaid in Full10SecuredSecuredAnnual3083.390004-091ONTARIO CITY2023-12-112023-12-072023-12-0720232023-07-012024-06-302023-09-195750000
2023010830107000020230000007Paid in FullPaid in Full20SecuredSecuredAnnual3083.380004-091ONTARIO CITY2024-04-102024-04-082024-04-0820232023-07-012024-06-302023-09-195750000
2024010830107000020240000007Paid in FullPaid in Full10SecuredSecuredAnnual3471.280004-091ONTARIO CITY2024-12-102024-12-062024-12-0620242024-07-012025-06-302024-09-176411050
2024010830107000020240000007Paid in FullPaid in Full20SecuredSecuredAnnual3471.240004-091ONTARIO CITY2025-04-102025-04-082025-04-0820242024-07-012025-06-302024-09-176411050
2025010830107000020250864544Paid in FullUnpaid10SecuredSecuredAnnual3552.673552.67004-091ONTARIO CITY2025-12-102025-12-092025-12-0920252025-07-012026-06-302025-10-316539270
2025010830107000020250864544UnpaidUnpaid23552.67SecuredSecuredAnnual3552.673552.67004-091ONTARIO CITY2026-04-1020252025-07-012026-06-302025-10-316539270
202601083010700002026P0681726Preliminary RollPreliminary Roll10SecuredSecuredAnnual00004-091ONTARIO CITY2026-12-1020262026-07-012027-06-300
202601083010700002026P0681726Preliminary RollPreliminary Roll20SecuredSecuredAnnual00004-091ONTARIO CITY2027-04-1220262026-07-012027-06-300
2021010830108000020210000008Paid in FullPaid in Full10SecuredSecuredAnnual906.750004-091ONTARIO CITY2021-12-102021-12-092021-12-0920212021-07-012022-06-302021-09-201693120
2021010830108000020210000008Paid in FullPaid in Full20SecuredSecuredAnnual906.710004-091ONTARIO CITY2022-04-112022-04-072022-04-0720212021-07-012022-06-302021-09-201693120
2022010830108000020220000008Paid in FullPaid in Full10SecuredSecuredAnnual913.220004-091ONTARIO CITY2022-12-122022-12-092022-12-0920222022-07-012023-06-302022-09-211726980
2022010830108000020220000008Paid in FullPaid in Full20SecuredSecuredAnnual913.180004-091ONTARIO CITY2023-04-102023-04-072023-04-0720222022-07-012023-06-302022-09-211726980