Civic Intelligence

San Joaquin Community Data Council San Joaquin Community Data Coopera

990 • Fiscal year 2018 • EIN 68-0453459

Jul 01, 2017 to Jun 30, 2018 • Filed on Nov 13, 2018

Organization ProfileN/A

View Organization Page

PO Box 1237Stockton, CA 95201

(209) 953-7128

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

96th percentile

1.40x

Higher debt load relative to assets than 96% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Liabilities / Revenue

94th percentile

0.65x

Higher debt load relative to revenue than 94% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Net Margin

24th percentile

-9.6%

Higher net margin than 24% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Top Officer Pay

96th percentile

$71,143

Higher top officer pay than 96% of similar nonprofits.

Top officer pay equals 22.8% of source-year revenue.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Asset Growth

18th percentile

-25%

Faster asset growth than 18% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

34th percentile

-9.6%

Faster revenue growth than 34% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / Assets96th percentile

Assets

Down

$143,802

Down $47,716 (-25%) from 2017

Net Assets

Down

-$57,869

Down $29,973 (-107%) from 2017

Liabilities

Down

$201,671

Down $17,743 (-8.1%) from 2017

Revenue And Expenses
Liabilities / Revenue94th percentileNet Margin24th percentile

Revenue

Down

$311,827

Down $33,168 (-9.6%) from 2017

Expenses

Up

$341,800

Up $336 (+0.1%) from 2017

Net Income

Down

-$29,973

Down $33,504 (-949%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth18th percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$300K$200K$100K$0-$100K-$200KAssets 2012: $76,208Liabilities 2012: $84,546Net Assets 2012: -$8,3382012Assets 2013: $111,247Liabilities 2013: $93,320Net Assets 2013: $17,9272013Assets 2014: $164,286Liabilities 2014: $215,619Net Assets 2014: -$51,3332014Assets 2015: $176,501Liabilities 2015: $199,359Net Assets 2015: -$22,8582015Assets 2016: $185,792Liabilities 2016: $217,219Net Assets 2016: -$31,4272016Assets 2017: $191,518Liabilities 2017: $219,414Net Assets 2017: -$27,8962017Assets 2018: $143,802Liabilities 2018: $201,671Net Assets 2018: -$57,8692018Assets 2019: $118,915Liabilities 2019: $205,538Net Assets 2019: -$86,6232019Assets 2020: $128,338Liabilities 2020: $230,945Net Assets 2020: -$102,6072020Assets 2021: $142,735Liabilities 2021: $216,709Net Assets 2021: -$73,9742021Assets 2022: $169,180Liabilities 2022: $219,714Net Assets 2022: -$50,5342022Assets 2023: $157,814Liabilities 2023: $214,067Net Assets 2023: -$56,2532023Assets 2024: $59,762Liabilities 2024: $14,817Net Assets 2024: $44,9452024Assets 2025: $83,254Liabilities 2025: $14,875Net Assets 2025: $68,3792025

Highlighted filing

2018

Assets$143,802
Liabilities$201,671
Net Assets-$57,869
Open 2018 Filing

Operations Trend

Revenue Growth34th percentile

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$400K$200K$0-$200KRevenue 2012: $226,335Expenses 2012: $217,458Net Income 2012: $8,8772012Revenue 2013: $247,259Expenses 2013: $220,994Net Income 2013: $26,2652013Revenue 2014: $171,771Expenses 2014: $241,031Net Income 2014: -$69,2602014Revenue 2015: $302,644Expenses 2015: $274,169Net Income 2015: $28,4752015Revenue 2016: $330,800Expenses 2016: $339,369Net Income 2016: -$8,5692016Revenue 2017: $344,995Expenses 2017: $341,464Net Income 2017: $3,5312017Revenue 2018: $311,827Expenses 2018: $341,800Net Income 2018: -$29,9732018Revenue 2019: $309,970Expenses 2019: $338,724Net Income 2019: -$28,7542019Revenue 2020: $307,991Expenses 2020: $323,975Net Income 2020: -$15,9842020Revenue 2021: $334,179Expenses 2021: $305,546Net Income 2021: $28,6332021Revenue 2022: $273,373Expenses 2022: $249,933Net Income 2022: $23,4402022Revenue 2023: $294,946Expenses 2023: $300,665Net Income 2023: -$5,7192023Revenue 2024: $374,241Expenses 2024: $273,043Net Income 2024: $101,1982024Revenue 2025: $138,371Expenses 2025: $114,937Net Income 2025: $23,4342025

Highlighted filing

2018

Revenue$311,827
Expenses$341,800
Net Income-$29,973
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Nov 13, 2018
Return Version
2017v2.2
Gross Receipts
$311,827
Mission and Program Overview

Mission

San joaquin community data council is working cooperatively with other community organizations, providing services to gather and analyze data for a healthier community.

Balance Sheet Detail
LineBeginningEndChange
Assets
Cash and Non-Interest-Bearing Accounts$109,330$112,507▲ $3,177
Accounts Receivable$81,925$30,011▼ $51,914
Land, Buildings, and Equipment, Net$263$1,284▲ $1,021
Savings and Temporary Cash Investments-$0-
Other Notes and Loans Receivable, Net-$0-
Pledges and Grants Receivable-$0-
Receivable From Disqualified Prsn-$0-
Receivables From Officers Etc-$0-
Investments Other Securities-$0-
Investments Program Related-$0-
Investments in Publicly Traded Securities-$0-
Intangible Assets-$0-
Inventories for Sale or Use-$0-
Prepaid Expenses and Deferred Charges-$0-
Total Assets$191,518$143,802▼ $47,716
Other Assets Total-$0-
Liabilities
Deferred Revenue$213,942$196,435▼ $17,507
Other Liabilities$5,472$4,270▼ $1,202
Accounts Payable and Accrued Expenses-$966-
Total Liabilities$219,414$201,671▼ $17,743
Net Assets / Fund Balance
Unrestricted Net Assets$-27,896$-57,869▼ $29,973
Total Net Assets Fund Balance$-27,896$-57,869▼ $29,973
Total Liabilities and Net Assets / Fund Balance$191,518$143,802▼ $47,716

Asset Categories

AssetBook ValueDepreciationBasis
Other Land Buildings$1,284$33,052$34,336
Compensation and Service Providers
Top Officer Pay96th percentile

Employees

NameTitleFull / Part TimeBaseTotal
Campbell BullockExecutive DirectorFT$71,143$71,143

Board Members and Trustees

NameTitle
Tim ViallChairman
Carol BedellDirector
Tiffany PhovixayDirector
Roy ChildsSecretary
Ron KerstiensTreasurer
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$311,827
Investment Income
$0
Other Revenue
$0
Change in Net Assets
$-29,973

Audited Revenue Reconciliation

Revenue per Audited Statements
$311,827
Total Revenue per Audited Statements
$311,827
Total Revenue per Form 990
$311,827
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$289,692
Other Expenses$52,108
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$138,586$34,647-$173,233
Current Officers, Directors, Trustees, and Key Employees$56,915$14,229-$71,144
Other Employee Benefits$17,754$4,439-$22,193
Payroll Taxes$17,107$4,277-$21,384
Occupancy$16,305$4,076-$20,381
Insurance$6,514$1,629-$8,143
Office Expenses$4,953$1,238-$6,191
Conferences and Meetings$4,062$1,016-$5,078
Travel$2,581$645-$3,226
Fees for Services Accounting$1,440$360-$1,800
Pension Plan Contributions$1,390$348-$1,738
Other Expenses$280$70-$350
Depreciation Depletion$210$52-$262
All Other Expenses$65$16-$81
Fees for Services Other$8$2-$10
Total Functional Expenses$273,438$68,362$0$341,800

Audited Expense Reconciliation

Line ItemAmount
Expenses per Audited Statements$341,800
Total Expenses per Audited Statements$341,800
Total Expenses per Form 990$341,800
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Insider Transactions and Loans

Loans and Receivables

Line ItemBeginningEndChange
Receivables from Disqualified Persons-$0-
Receivables from Officers, Directors, Trustees, and Key Employees-$0-
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Payroll Liabilities$4,270
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
Yes
Annual disclosure for covered persons
No
Audit committee
No
Backup withholding compliance
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
No
Other officer compensation reviewed
No
Conflict-of-interest policy
No
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Part VI, Line 11B: Form 990 Review Process

“Form 990 is reviewed by executive director before filing.”

Form 990, Part VI, Line 19: Other Organization Documents Publicly Available

“AVAILABLE UPON REQUEST”

Filing and Contact Details

Filer

Filer Name
San Joaquin Community Data Council
EIN
68-0453459
Phone
2099537128
Address
PO BOX 1237, STOCKTON, CA 95201

Signing Officer

Name
Campbell Bullock
Title
Executive Director
Signed
2018-11-13
Discuss with paid preparer
Yes

Organization Details

Voting Board Members
6
Independent Board Members
5
Employees
11

Preparer

Firm
Schwartz Giannini Lantsberger & Adamson CPAs
Address
4578 Feather River Drive D, Stockton, CA 95219
Preparer
Philip Lantsberger
Phone
2094741084
Supplemental Narrative

Financial Statement Notes

Part X : FIN48 Footnote

“The financial accounting standards board (fasb) fasb interpretation no.48 accounting for uncertainty in income taxes, (fin 48) which was subsequently included in the fasb codification as asc 740, prescribes a recognition threshold and measurement attribute for financial statement recognition and measurement of a tax position taken or expect to be taken in a tax return. Management of the association has evaluated its uncertain tax positions and related income tax contingencies. Management does not believe that any material uncertain tax positions exist. Therefore, these financial statements do not include a liability for unrecognized tax positions. Upon recognition of a liability for an unrecognized tax benefit the association would recognize interest accrued in interest expense and pelnaties in management and general functional expenses.the association files informational tax returns in the u.s. Federal jurisdiction and state of california jurisdiction. The association's tax returns are subject to examination by federal taxing authorities for a period of three years from the date they are filed and a period of four years for california taxing authorities.”

Raw XML AppendixShowing 400 of 416 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990/AccountantCompileOrReviewInd0true
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0966
IRS990/AccountsReceivableGrp/BOYAmt081925
IRS990/AccountsReceivableGrp/EOYAmt030011
IRS990/AcctCompileOrReviewBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0SAN JOAQUIN COMMUNITY DATA COUNCIL IS WORKING COOPERATIVELY WITH OTHER COMMUNITY ORGANIZATIONS, PROVIDING SERVICES TO GATHER AND ANALYZE DATA FOR A HEALTHIER COMMUNITY.
IRS990/AdvertisingGrp/TotalAmt00
IRS990/AllAffiliatesIncludedInd0false
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt016
IRS990/AllOtherExpensesGrp/ProgramServicesAmt065
IRS990/AllOtherExpensesGrp/TotalAmt081
IRS990/AnnualDisclosureCoveredPrsnInd0false
IRS990/AuditCommitteeInd0false
IRS990/BackupWthldComplianceInd0false
IRS990/BenefitsToMembersGrp/TotalAmt00
IRS990/BooksInCareOfDetail/PersonNm0CAMPBELL BULLOCK
IRS990/BooksInCareOfDetail/PhoneNum02099537130
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 1237
IRS990/BooksInCareOfDetail/USAddress/CityNm0STOCKTON
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CA
IRS990/BooksInCareOfDetail/USAddress/ZIPCd095201
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOfficerEntInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CashNonInterestBearingGrp/BOYAmt0109330
IRS990/CashNonInterestBearingGrp/EOYAmt0112507
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CntrctRcvdGreaterThan100KCnt00
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt014229
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt056915
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt071144
IRS990/CompDisqualPersonsGrp/TotalAmt00
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt01016
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt04062
IRS990/ConferencesMeetingsGrp/TotalAmt05078
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt052108
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt0311827
IRS990/CYRevenuesLessExpensesAmt0-29973
IRS990/CYSalariesCompEmpBnftPaidAmt0289692
IRS990/CYTotalExpensesAmt0341800
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0311827
IRS990/DAFExcessBusinessHoldingsInd0false
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DeferredRevenueGrp/BOYAmt0213942
IRS990/DeferredRevenueGrp/EOYAmt0196435
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt052
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0210
IRS990/DepreciationDepletionGrp/TotalAmt0262
IRS990/Desc0SAN JOAQUIN COMMUNITY DATA COUNCIL IS WORKING COOPERATIVELY WITH OTHER COMMUNITY ORGANIZATIONS, PROVIDING SERVICES TO GATHER AND ANALYZE DATA FOR A HEALTHIER COMMUNITY.
IRS990/DescribedInSection501c3Ind0true
IRS990/DisregardedEntityInd0false
IRS990/DistributionToDonorInd0false
IRS990/DocumentRetentionPolicyInd0false
IRS990/DonorAdvisedFundInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt011
IRS990/EmploymentTaxReturnsFiledInd0false
IRS990/EngagedInExcessBenefitTransInd0false
IRS990/EscrowAccountInd0false
IRS990/ExpenseAmt0273438
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt0360
IRS990/FeesForServicesAccountingGrp/ProgramServicesAmt01440
IRS990/FeesForServicesAccountingGrp/TotalAmt01800
IRS990/FeesForServicesLegalGrp/TotalAmt00
IRS990/FeesForServicesLobbyingGrp/TotalAmt00
IRS990/FeesForServicesManagementGrp/TotalAmt00
IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt02
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt08
IRS990/FeesForServicesOtherGrp/TotalAmt010
IRS990/FeesForServicesProfFundraising/TotalAmt00
IRS990/FeesForSrvcInvstMgmntFeesGrp/TotalAmt00
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignGrantsGrp/TotalAmt00
IRS990/ForeignOfficeInd0false
IRS990/Form1098CFiledInd0false
IRS990/Form8282FiledCnt00
IRS990/Form8282PropertyDisposedOfInd0false
IRS990/Form8899Filedind0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt00.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt10.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt20.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt30.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt40.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt50.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt11.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt240.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt51.00
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/PersonNm0CAROL BEDELL
IRS990/Form990PartVIISectionAGrp/PersonNm1TIFFANY PHOVIXAY
IRS990/Form990PartVIISectionAGrp/PersonNm2CAMPBELL BULLOCK
IRS990/Form990PartVIISectionAGrp/PersonNm3RON KERSTIENS
IRS990/Form990PartVIISectionAGrp/PersonNm4ROY CHILDS
IRS990/Form990PartVIISectionAGrp/PersonNm5TIM VIALL
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt271143
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/TitleTxt0Director
IRS990/Form990PartVIISectionAGrp/TitleTxt1Director
IRS990/Form990PartVIISectionAGrp/TitleTxt2Executive Dir.
IRS990/Form990PartVIISectionAGrp/TitleTxt3Treasurer
IRS990/Form990PartVIISectionAGrp/TitleTxt4Secretary
IRS990/Form990PartVIISectionAGrp/TitleTxt5Chairman
IRS990/Form990ProvidedToGvrnBodyInd0false
IRS990/Form990TFiledInd0false
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd0true
IRS990/FundraisingActivitiesInd0false
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt06
IRS990/GrantsToDomesticIndividualsGrp/TotalAmt00
IRS990/GrantsToDomesticOrgsGrp/TotalAmt00
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossReceiptsAmt0311827
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0true
IRS990/IncmFromInvestBondProceedsGrp/TotalRevenueColumnAmt00
IRS990/IndependentAuditFinclStmtInd0true
IRS990/IndependentVotingMemberCnt05
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InformationTechnologyGrp/TotalAmt00
IRS990/InsuranceGrp/ManagementAndGeneralAmt01629
IRS990/InsuranceGrp/ProgramServicesAmt06514
IRS990/InsuranceGrp/TotalAmt08143
IRS990/IntangibleAssetsGrp/EOYAmt00
IRS990/InterestGrp/TotalAmt00
IRS990/InventoriesForSaleOrUseGrp/EOYAmt00
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt00
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsOtherSecuritiesGrp/EOYAmt00
IRS990/InvestmentsProgramRelatedGrp/EOYAmt00
IRS990/InvestmentsPubTradedSecGrp/EOYAmt00
IRS990/InvestTaxExemptBondsInd0false
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt033052
IRS990/LandBldgEquipBasisNetGrp/BOYAmt0263
IRS990/LandBldgEquipBasisNetGrp/EOYAmt01284
IRS990/LandBldgEquipCostOrOtherBssAmt034336
IRS990/LicensedMoreThanOneStateInd0false
IRS990/LoanOutstandingInd0false
IRS990/LobbyingActivitiesInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd0false
IRS990/MinutesOfGoverningBodyInd0false
IRS990/MissionDesc0SAN JOAQUIN COMMUNITY DATA COUNCIL IS WORKING COOPERATIVELY WITH OTHER COMMUNITY ORGANIZATIONS, PROVIDING SERVICES TO GATHER AND ANALYZE DATA FOR A HEALTHIER COMMUNITY.
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesBOYAmt0-27896
IRS990/NetAssetsOrFundBalancesEOYAmt0-57869
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt00
IRS990/NetIncmFromFundraisingEvtGrp/TotalRevenueColumnAmt00
IRS990/NetIncomeFromGamingGrp/TotalRevenueColumnAmt00
IRS990/NetIncomeOrLossGrp/TotalRevenueColumnAmt00
IRS990/NetRentalIncomeOrLossGrp/TotalRevenueColumnAmt00
IRS990/NondeductibleContributionsInd0false
IRS990/OccupancyGrp/ManagementAndGeneralAmt04076
IRS990/OccupancyGrp/ProgramServicesAmt016305
IRS990/OccupancyGrp/TotalAmt020381
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt01238
IRS990/OfficeExpensesGrp/ProgramServicesAmt04953
IRS990/OfficeExpensesGrp/TotalAmt06191
IRS990/OfficerMailingAddressInd0false
IRS990/OnBehalfOfIssuerInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OrgFiledInLieuOfForm1041Ind0false
IRS990/OtherAssetsTotalGrp/EOYAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt04439
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt017754
IRS990/OtherEmployeeBenefitsGrp/TotalAmt022193
IRS990/OtherExpensesGrp/Desc0PAYROLL PROCESSING
IRS990/OtherExpensesGrp/Desc1REIMBURSEMENTS
IRS990/OtherExpensesGrp/Desc2WEBSITE
IRS990/OtherExpensesGrp/Desc3DUES AND SUBSCRIPTIONS
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt0672
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt1568
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt278
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt370
IRS990/OtherExpensesGrp/ProgramServicesAmt02686
IRS990/OtherExpensesGrp/ProgramServicesAmt12270
IRS990/OtherExpensesGrp/ProgramServicesAmt2312
IRS990/OtherExpensesGrp/ProgramServicesAmt3280
IRS990/OtherExpensesGrp/TotalAmt03358
IRS990/OtherExpensesGrp/TotalAmt12838
IRS990/OtherExpensesGrp/TotalAmt2390
IRS990/OtherExpensesGrp/TotalAmt3350
IRS990/OtherLiabilitiesGrp/BOYAmt05472
IRS990/OtherLiabilitiesGrp/EOYAmt04270
IRS990/OtherRevenueTotalAmt00
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt034647
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0138586
IRS990/OtherSalariesAndWagesGrp/TotalAmt0173233
IRS990/OthNotesLoansReceivableNetGrp/EOYAmt00
IRS990/PartialLiquidationInd0false
IRS990/PaymentsToAffiliatesGrp/TotalAmt00
IRS990/PayPremiumsPrsnlBnftCntrctInd0false
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt04277
IRS990/PayrollTaxesGrp/ProgramServicesAmt017107
IRS990/PayrollTaxesGrp/TotalAmt021384
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt0348
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt01390
IRS990/PensionPlanContributionsGrp/TotalAmt01738
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt00
IRS990/PoliticalCampaignActyInd0false
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt00
IRS990/ProfessionalFundraisingInd0false
IRS990/ProgramServiceRevenueGrp/Desc0CONTRACTS INCOME
IRS990/ProgramServiceRevenueGrp/Desc1EVALUATION SERVICES
IRS990/ProgramServiceRevenueGrp/Desc2GRANT SERVICES
IRS990/ProgramServiceRevenueGrp/Desc3OTHER INCOME
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt039550
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt1272188
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt289
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt039550
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt1272188
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt289
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYExcessBenefitTransInd0false
IRS990/PymtTravelEntrtnmntPubOfclGrp/TotalAmt00
IRS990/PYOtherExpensesAmt060510
IRS990/PYProgramServiceRevenueAmt0344995
IRS990/PYRevenuesLessExpensesAmt03531
IRS990/PYSalariesCompEmpBnftPaidAmt0280954
IRS990/PYTotalExpensesAmt0341464
IRS990/PYTotalRevenueAmt0344995
IRS990/QuidProQuoContributionsInd0false
IRS990/RcvblFromDisqualifiedPrsnGrp/EOYAmt00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990/ReceivablesFromOfficersEtcGrp/EOYAmt00
IRS990/ReconcilationRevenueExpnssAmt0-29973
IRS990/RegularMonitoringEnfrcInd0false
IRS990/RelatedEntityInd0false
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0true
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0true
IRS990/ReportProgramRelatedInvstInd0false
IRS990/RoyaltiesGrp/TotalAmt00
IRS990/RoyaltiesRevenueGrp/TotalRevenueColumnAmt00
IRS990/SavingsAndTempCashInvstGrp/EOYAmt00
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0311827
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0344996
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt0330800
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt0302644
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt0171771
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt01462038
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt00
IRS990ScheduleA/OtherIncome170Grp/TotalAmt00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct01.00000
IRS990ScheduleA/PublicSupportPY170Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt01462038
IRS990ScheduleA/SubstantialContributorsTotAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft170Grp/TotalAmt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0311827
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0344996
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0330800
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt0302644
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt0171771
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt01462038
IRS990ScheduleA/TotalSupportAmt01462038
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/TotalAmt00
IRS990/ScheduleBRequiredInd0false
IRS990ScheduleD/ExpensesSubtotalAmt0341800
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt01284
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt033052
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt034336
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt04270
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0PAYROLL LIABILITIES
IRS990ScheduleD/RevenueSubtotalAmt0311827
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0THE FINANCIAL ACCOUNTING STANDARDS BOARD (FASB) FASB INTERPRETATION NO.48 ACCOUNTING FOR UNCERTAINTY IN INCOME TAXES, (FIN 48) WHICH WAS SUBSEQUENTLY INCLUDED IN THE FASB CODIFICATION AS ASC 740, PRESCRIBES A RECOGNITION THRESHOLD AND MEASUREMENT ATTRIBUTE FOR FINANCIAL STATEMENT RECOGNITION AND MEASUREMENT OF A TAX POSITION TAKEN OR EXPECT TO BE TAKEN IN A TAX RETURN. MANAGEMENT OF THE ASSOCIATION HAS EVALUATED ITS UNCERTAIN TAX POSITIONS AND RELATED INCOME TAX CONTINGENCIES. MANAGEMENT DOES NOT BELIEVE THAT ANY MATERIAL UNCERTAIN TAX POSITIONS EXIST. THEREFORE, THESE FINANCIAL STATEMENTS DO NOT INCLUDE A LIABILITY FOR UNRECOGNIZED TAX POSITIONS. UPON RECOGNITION OF A LIABILITY FOR AN UNRECOGNIZED TAX BENEFIT THE ASSOCIATION WOULD RECOGNIZE INTEREST ACCRUED IN INTEREST EXPENSE AND PELNATIES IN MANAGEMENT AND GENERAL FUNCTIONAL EXPENSES.THE ASSOCIATION FILES INFORMATIONAL TAX RETURNS IN THE U.S. FEDERAL JURISDICTION AND STATE OF CALIFORNIA JURISDICTION. THE ASSOCIATION'S TAX RETURNS ARE SUBJECT TO EXAMINATION BY FEDERAL TAXING AUTHORITIES FOR A PERIOD OF THREE YEARS FROM THE DATE THEY ARE FILED AND A PERIOD OF FOUR YEARS FOR CALIFORNIA TAXING AUTHORITIES.
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0Part X : FIN48 Footnote
IRS990ScheduleD/TotalBookValueLandBuildingsAmt01284
IRS990ScheduleD/TotalExpensesPerForm990Amt0341800
IRS990ScheduleD/TotalLiabilityAmt04270
IRS990ScheduleD/TotalRevenuePerForm990Amt0311827
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt0311827
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt0341800
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0FORM 990 IS REVIEWED BY EXECUTIVE DIRECTOR BEFORE FILING.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1AVAILABLE UPON REQUEST
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990, Part VI, Line 11b: Form 990 Review Process
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990, Part VI, Line 19: Other Organization Documents Publicly Available
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/StatesWhereCopyOfReturnIsFldCd0CA
IRS990/SubjectToProxyTaxInd0false
IRS990/TaxableDistributionsInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TempOrPermanentEndowmentsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt0191518
IRS990/TotalAssetsEOYAmt0143802
IRS990/TotalAssetsGrp/BOYAmt0191518
IRS990/TotalAssetsGrp/EOYAmt0143802
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalContributionsAmt00
IRS990/TotalEmployeeCnt011
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt068362
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt0273438
IRS990/TotalFunctionalExpensesGrp/TotalAmt0341800
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt0219414
IRS990/TotalLiabilitiesEOYAmt0201671
IRS990/TotalLiabilitiesGrp/BOYAmt0219414
IRS990/TotalLiabilitiesGrp/EOYAmt0201671
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt0-27896
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt0-57869
IRS990/TotalProgramServiceExpensesAmt0273438
IRS990/TotalProgramServiceRevenueAmt0311827
IRS990/TotalReportableCompFromOrgAmt071143
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt0311827
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt0311827
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt0191518
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt0143802
IRS990/TravelGrp/ManagementAndGeneralAmt0645
IRS990/TravelGrp/ProgramServicesAmt02581
IRS990/TravelGrp/TotalAmt03226
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UnrestrictedNetAssetsGrp/BOYAmt0-27896
IRS990/UnrestrictedNetAssetsGrp/EOYAmt0-57869
IRS990/VotingMembersGoverningBodyCnt06
IRS990/VotingMembersIndependentCnt05
IRS990/WebsiteAddressTxt0N/A
IRS990/WhistleblowerPolicyInd0false
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0CAMPBELL BULLOCK
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Executive Director
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-11-13
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SAN JOAQUIN COMMUNITY DATA COUNCIL
ReturnHeader/Filer/BusinessNameControlTxt0SANJ
ReturnHeader/Filer/EIN0680453459
ReturnHeader/Filer/PhoneNum02099537128
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 1237

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2018 • Form 990Detailed filing. Detailed filing data is available for this year.

Open filing
Assets
$143,802
Liabilities
$201,671
Net assets
-$57,869
Revenue
$311,827
Expenses
$341,800
Net income
-$29,973
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$0.83$0.15$0.68$1.38$1.15$0.23
2024Detailed filing. Detailed filing data is available for this year.$0.60$0.15$0.45$3.74$2.73$1.01
2023Detailed filing. Detailed filing data is available for this year.$1.58$2.14$0.56$2.95$3.01$0.06
2022Detailed filing. Detailed filing data is available for this year.$1.69$2.20$0.51$2.73$2.50$0.23
2021Detailed filing. Detailed filing data is available for this year.$1.43$2.17$0.74$3.34$3.06$0.29
2020Detailed filing. Detailed filing data is available for this year.$1.28$2.31$1.03$3.08$3.24$0.16
2019Detailed filing. Detailed filing data is available for this year.$1.19$2.06$0.87$3.10$3.39$0.29
2018Detailed filing. Detailed filing data is available for this year.$1.44$2.02$0.58$3.12$3.42$0.30
2017Detailed filing. Detailed filing data is available for this year.$1.92$2.19$0.28$3.45$3.41$0.04
2016Detailed filing. Detailed filing data is available for this year.$1.86$2.17$0.31$3.31$3.39$0.09
2015Summary only. Only limited summary data is available for this year.$1.77$1.99$0.23$3.03$2.74$0.28
2014Summary only. Only limited summary data is available for this year.$1.64$2.16$0.51$1.72$2.41$0.69
2013Summary only. Only limited summary data is available for this year.$1.11$0.93$0.18$2.47$2.21$0.26
2012Summary only. Only limited summary data is available for this year.$0.76$0.85$0.08$2.26$2.17$0.09