Visualization of datamap

CSV

The datamap applies to the Checkbook data published by San Mateo County. Even though the information is checkbook / spending data, we were still able to pull out some relevant contracting fields.

Standardized FieldnameConceptTypeLanguageTitleDescriptionAllowable Values
account_descriptionGOODS / SERVICESSingleSelectU.S. EnglishAccount DescriptionThis is good's dsecription that goes with Account Code e.g. 5343 - Advertising and Publicity Expense; 5142 - Milk
acct_codeGOODS / SERVICESNumberU.S. EnglishAcct CodeThis is good's code that goes with Account Description e.g. 5343 - Advertising and Publicity Expense; 5142 - Milk
category_codeBUYERNumberU.S. EnglishCategory CodeCode associated with Category of Government1, 2, 3, 4, 5, 7, 8
government_categoryBUYERSingleSelectU.S. EnglishCategory of GovernmentThis is a property of the Department purchasing.A048671, Capital Projects, General go...
check_datePERFORMANCEDateTimeU.S. EnglishCheck Date
check_numberPERFORMANCENumberU.S. EnglishCheck Number
department_codeBUYERNumberU.S. EnglishDepartment Code
department_nameBUYERTextU.S. EnglishDepartment Name
org_codeBUYERNumberU.S. EnglishOrg Code
org_descriptionBUYERTextU.S. EnglishOrganization Description
payment_amountPERFORMANCECurrencyU.S. EnglishPayment Amount
unique_keyPERFORMANCETextU.S. EnglishUNIQUE_KEY
vendor_idSUPPLIERLetter, NumberU.S. EnglishVendor ID
vendor_nameSUPPLIERTextU.S. EnglishVendor Name