"citydata-mesaaz-gov/city-expenditures-vdg8-dx96:latest"."city_expenditures"

SELECT
    ":id", -- Socrata column ID
    "fiscal_year", -- The span of the accounting fiscal year the document was created. Ex: FY 16/17
    "date_12", -- The Date field adjusted so that period 13 information is included as period 12
    "document_type_code", -- The number assigned to the type of document the transaction was recorded in the accounting system.
    "fund_code", -- The number assigned to the governmental segment that benefited from the transaction.
    "document_id", -- The number assigned to the transaction by the accounting system.
    "reporting_code_name", -- A reporting mechanism used to track the expenditures related to a specific event or item.  Examples are shows at the Mesa Arts Center and Park expenses.
    "fund_name", -- The governmental segment that benefited from the transaction. Examples include Cemetery, Transit and Arts and Culture.
    "reporting_code", -- The number assigned to a reporting mechanism used to track the expenditures related to a specific event or item.  Examples are shows at the Mesa Arts Center and Park expenses.
    "program_name", -- A program represents a smaller segment of a project the City is working on. For example, renovating a Park would be a major program, installing the bathroom would be a program.
    "sub_fund_name", -- The breakdown of a fund based on purpose, classification, and other specific characteristics.
    "unit_name", -- The organizational unit within the department that benefited from the transaction. Examples include Planning, Development Services, Energy Resources, Electric Utility and Gas Utility.
    "unit_code", -- The number assigned to the organizational unit within the department that benefited from the transaction.
    "phase_name", -- A project is split into phases which generally represent pre-design/design/construction or may be split into purchases (where no construction is involved in the acquisition of the asset).
    "fiscal_month_name", -- The month and period name of the fiscal year in the format of month-period.
    "expense_category_name", -- The grouping of expense types into categories on the chart of accounts. Category examples include Personal Services, Other Services, or Commodities.
    "row_id", -- Unique record identifier that is being used for sorting and grouping purposes.
    "department_code", -- The number assigned to the department that benefited from the transaction.
    "department_name", -- The department that benefited from the transaction.
    "business_objective_code", -- The number assigned to a major line of business that aligns with one or more of the Council's strategic initiatives; denotes a primary public purpose; and defines where the City allocates its resources.
    "business_objective_name", -- A major line of business that aligns with one or more of the Council's strategic initiatives; denotes a primary public purpose; and defines where the City allocates its resources.  Examples include Fleet Services and Economic Development.
    "sub_fund_code", -- The numbers assigned for the breakdown of a fund based on purpose, classification, and other specific characteristics.
    "calendar_year", -- The calendar year portion of the current fiscal year derived from the document creation date. Ex: 2017
    "service_level_code", -- The number assigned to a group of core business processes related by a common purpose (mission, outcomes, and expected performance).  This level of structure is optional depending on departmental needs.
    "service_level_name", -- A group of core business processes related by a common purpose (mission, outcomes, and expected performance).  This level of structure is optional depending on departmental needs.  Examples include Operations Bureau and Investigations Bureau.
    "appropriation_name", -- The type of appropriation of the transaction. These will either be the base operating budget or a capital improvement project.
    "core_business_process_code", -- The number assigned to a collection of related programs and services that are designed and managed to achieve a common outcome or set of outcomes.
    "core_business_proces_name", -- A collection of related programs and services that are designed and managed to achieve a common outcome or set of outcomes.  These include Patrol, Metro, and Criminal Investigations.
    "activity_code", -- The number assigned to the activity the department was engaged in that led to the transaction.
    "phase_code", -- The number assigned to a phase of a project.
    "activity_name", -- The activity that the department was engaged in that led to the transaction. Activities are generally recurring activities such as accounting, inspections or planning.
    "sub_activity_code", -- The number assigned to a sub-activity.
    "sub_activity_name", -- Activities are broken down into sub-activities for reporting and analysis purposes.
    "expense_type_code", -- The number assigned to the expense type on the chart of accounts.
    "expense_code", -- The number assigned to the type of expense being paid. In the private sector, this would be called a general ledger account number, however in the government sector, these are most often referred to as object codes.
    "expense_name", -- The type of expense being paid. In the private sector, this would be called a general ledger account, however in the government sector, these are most often referred to as objects. Examples include Payroll, Professional Services or Travel.
    "payroll_expense_name", -- The type of payroll expense being paid. Examples include Salaries, Vacation, or Taxes.
    "amount", -- The amount of the transaction.
    "legal_name", -- Legal name of the vendor.
    "vendor_name", -- Name of vendor paid if different than legal name.
    "commodity_name", -- A category of tangible product purchased. Commodity categories are used by the purchasing department for analysis of major expenditures and contract opportunities.
    "major_program_code", -- The number assigned to a project.
    "commodity_code", -- The number assigned to a tangible product purchase.
    "payroll_expense_code", -- The number assigned to the type of payroll expense being paid.
    "appropriation_code", -- The number assigned to the type of appropriation of the transaction.
    "program_code", -- The number assigned to a program.
    "date", -- The date of the transaction or when the document was created.
    "accounting_fiscal_year", -- The accounting fiscal year the document was created. The accounting fiscal year is determined by rules of recognition of liability or revenue and can differ from the budget fiscal year.  The City's fiscal year is from July 1 to June 30.
    "expense_category_code", -- The number assigned to the category of expense on the chart of accounts.
    "fiscal_month_and_year", -- The Fiscal Year and Fiscal Month formatted as as a date
    "document_type_name", -- The type of document the transaction was recorded in the accounting system.
    "major_program_name", -- A project the City is working on. Generally, a major program is created to capture all of the costs of creating a new or improving an existing asset before the asset is placed in service. Major programs may also track costs related to a grant awarded to the City.
    "accounting_period_12", -- The Accounting Period field adjusted so that period 13 information is included as period 12.
    "expense_type_name", -- A grouping of expenses into types on the chart of accounts. Types are then grouped into categories. Expense type examples include Machinery and Equipment, Infrastructure, and Contractual Services.
    "accounting_period", -- The accounting period the transaction was recorded. The City's accounting year runs from July 1 to June 30, where July is accounting period 1.
    "fiscal_month_name_12" -- The Fiscal Month Name field adjusted so that period 13 information is included as period 12.
FROM
    "citydata-mesaaz-gov/city-expenditures-vdg8-dx96:latest"."city_expenditures"
LIMIT 100;

sgr clone citydata-mesaaz-gov/city-expenditures-vdg8-dx96

sgr checkout citydata-mesaaz-gov/city-expenditures-vdg8-dx96:latest

sgr checkout --layered citydata-mesaaz-gov/city-expenditures-vdg8-dx96:latest