Description

more
Financial information on large city projects.

Dataset Attributes

  • status
    Text
    {"value"=>"A", "count"=>3081} (), {"value"=>"C", "count"=>1773} (), {"value"=>"I", "count"=>77} ()
  • account_id
    Number
    69 to 12955
  • full_acount_number
    Text
    {"value"=>"4100-30-31-311-3112-00000-00000-000-492000-A0901 ", "count"=>1} (), {"value"=>"2230-40-41-412-4218-d0501-00000-000-528013-D0925 ", "count"=>1} (), {"value"=>"6110-91-91-911-0000-00000-00000-000-712203-W0807 ", "count"=>1} (), {"value"=>"4100-10-11-110-0000-00000-00000-000-524003-F1102 ", "count"=>1} (), {"value"=>"4100-01-01-313-0000-00000-00000-000-614101-G1501 ", "count"=>1} (), {"value"=>"6110-91-91-911-0000-00000-00000-000-443521-W1111 ", "count"=>1} (), {"value"=>"2250-40-41-412-4207-d1602-00000-000-528013-D0981 ", "count"=>1} (), {"value"=>"2200-40-41-412-4215-00000-00000-000-527101-D1301 ", "count"=>1} (), {"value"=>"2200-40-41-412-0000-00000-00000-000-521002-Q1423 ", "count"=>1} (), {"value"=>"6110-91-91-911-0000-00000-00000-000-498616-W1207 ", "count"=>1} ()
  • account_name
    Text
    {"value"=>"Awarded Grants ", "count"=>420} (), {"value"=>"Professional Services ", "count"=>271} (), {"value"=>"Contracted Services ", "count"=>213} (), {"value"=>"Construction ", "count"=>153} (), {"value"=>"Oper Transfers from General Fd", "count"=>145} (), {"value"=>"Oper Transfers Cap Reserve Fd ", "count"=>138} (), {"value"=>"Supplies - Other ", "count"=>134} (), {"value"=>"Mach & Equipment ", "count"=>128} (), {"value"=>"Restricted Intergov Fed Grants", "count"=>123} (), {"value"=>"Materials ", "count"=>121} ()
  • account_short
    Text
    {"value"=>"Prof Serv ", "count"=>271} (), {"value"=>"Award Grnt", "count"=>262} (), {"value"=>"Cont Serv ", "count"=>211} (), {"value"=>"Awarded Gr", "count"=>157} (), {"value"=>"CS Constr ", "count"=>153} (), {"value"=>"OpTr GenFd", "count"=>148} (), {"value"=>"OpTrCapRsv", "count"=>138} (), {"value"=>"Supp Other", "count"=>134} (), {"value"=>"Mach Equip", "count"=>128} (), {"value"=>"Materials ", "count"=>121} ()
  • account_type
    Text
    {"value"=>"E", "count"=>3261} (), {"value"=>"R", "count"=>1670} ()
  • account_subtype
    Text
    {"value"=>"Operating Expenses", "count"=>1976} (), {"value"=>"Oth Financing Source", "count"=>995} (), {"value"=>"Capital Outlay", "count"=>467} (), {"value"=>"Salary and Benefits", "count"=>428} (), {"value"=>"Intergov Revenue", "count"=>373} (), {"value"=>"Miscell Revenue", "count"=>238} (), {"value"=>"Oper Cost Transfers", "count"=>175} (), {"value"=>"Other Financing Uses", "count"=>109} (), {"value"=>"Debt Service", "count"=>68} (), {"value"=>"Sales and Services", "count"=>39} ()
  • fund_id
    Text
    {"value"=>"4100", "count"=>1434} (), {"value"=>"2200", "count"=>990} (), {"value"=>"2230", "count"=>766} (), {"value"=>"6110", "count"=>629} (), {"value"=>"2250", "count"=>617} (), {"value"=>"6510", "count"=>157} (), {"value"=>"6270", "count"=>113} (), {"value"=>"6250", "count"=>101} (), {"value"=>"6210", "count"=>79} (), {"value"=>"2240", "count"=>19} ()
  • function_id
    Text
    {"value"=>"40", "count"=>1644} (), {"value"=>"99", "count"=>638} (), {"value"=>"20", "count"=>592} (), {"value"=>"80", "count"=>510} (), {"value"=>"91", "count"=>424} (), {"value"=>"01", "count"=>392} (), {"value"=>"10", "count"=>371} (), {"value"=>"30", "count"=>161} (), {"value"=>"95", "count"=>118} (), {"value"=>"90", "count"=>72} ()
  • department_id
    Text
    {"value"=>"41", "count"=>1653} (), {"value"=>"31", "count"=>706} (), {"value"=>"91", "count"=>654} (), {"value"=>"80", "count"=>586} (), {"value"=>"21", "count"=>340} (), {"value"=>"01", "count"=>330} (), {"value"=>"12", "count"=>239} (), {"value"=>"11", "count"=>139} (), {"value"=>"90", "count"=>110} (), {"value"=>"05", "count"=>69} ()
  • division_id
    Text
    {"value"=>"412", "count"=>1616} (), {"value"=>"911", "count"=>636} (), {"value"=>"231", "count"=>270} (), {"value"=>"330", "count"=>257} (), {"value"=>"803", "count"=>199} (), {"value"=>"950", "count"=>156} (), {"value"=>"122", "count"=>137} (), {"value"=>"805", "count"=>136} (), {"value"=>"320", "count"=>131} (), {"value"=>"015", "count"=>125} ()
  • cost_center_id
    Text
    {"value"=>"0000", "count"=>2962} (), {"value"=>"4207", "count"=>990} (), {"value"=>"4998", "count"=>124} (), {"value"=>"3301", "count"=>99} (), {"value"=>"4218", "count"=>90} (), {"value"=>"8401", "count"=>81} (), {"value"=>"4999", "count"=>69} (), {"value"=>"3002", "count"=>50} (), {"value"=>"4213", "count"=>38} (), {"value"=>"8315", "count"=>27} ()
  • organization_id
    Text
    {"value"=>"61100911", "count"=>399} (), {"value"=>"61190911", "count"=>226} (), {"value"=>"41000231", "count"=>162} (), {"value"=>"41000803", "count"=>157} (), {"value"=>"22004207", "count"=>114} (), {"value"=>"65100950", "count"=>107} (), {"value"=>"22000015", "count"=>103} (), {"value"=>"22000122", "count"=>96} (), {"value"=>"41003301", "count"=>92} (), {"value"=>"41000330", "count"=>91} ()
  • object_id
    Text
    {"value"=>"527101", "count"=>421} (), {"value"=>"521002", "count"=>271} (), {"value"=>"521001", "count"=>213} (), {"value"=>"435000", "count"=>201} (), {"value"=>"616102", "count"=>153} (), {"value"=>"498100", "count"=>148} (), {"value"=>"498202", "count"=>138} (), {"value"=>"524001", "count"=>134} (), {"value"=>"614101", "count"=>128} (), {"value"=>"524101", "count"=>121} ()
  • project_id
    Text
    {"value"=>"D0947", "count"=>442} (), {"value"=>"D0981", "count"=>369} (), {"value"=>"D0998", "count"=>124} (), {"value"=>"D0999", "count"=>69} (), {"value"=>"A0901", "count"=>54} (), {"value"=>"K1201", "count"=>37} (), {"value"=>"R0943", "count"=>32} (), {"value"=>"E1202", "count"=>32} (), {"value"=>"W0001", "count"=>28} (), {"value"=>"D0986", "count"=>26} ()
  • organization_name
    Text
    {"value"=>"Wtr Cap Pr Fd - Water Gen Oper", "count"=>399} (), {"value"=>"Wtr Cap Pr Fd - Wtr Gen Oper ", "count"=>226} (), {"value"=>"Gen Cap Pr Fd - Str & Sidewlk ", "count"=>162} (), {"value"=>"Gen Cap Pr Fd - Parks Maint ", "count"=>157} (), {"value"=>"Trans CP Fd - Transit Admin ", "count"=>145} (), {"value"=>"City of Asheville ", "count"=>116} (), {"value"=>"CC Cap Pr - Civic Center Cap ", "count"=>109} (), {"value"=>"Grt Fd - Community Affairs ", "count"=>103} (), {"value"=>"Patrol Division ", "count"=>96} (), {"value"=>"GCPF - Sidewalks New Construct", "count"=>92} ()
  • organization_short
    Text
    {"value"=>"Water Op ", "count"=>628} (), {"value"=>"Sts Sdwlks", "count"=>198} (), {"value"=>"Park Maint", "count"=>157} (), {"value"=>"TrCapPrAdm", "count"=>145} (), {"value"=>"COA ", "count"=>116} (), {"value"=>"Com Afairs", "count"=>112} (), {"value"=>"CCCProj ", "count"=>109} (), {"value"=>"Suprt Serv", "count"=>107} (), {"value"=>"Patrol ", "count"=>96} (), {"value"=>"GCPF Sidew", "count"=>92} ()
  • object_name
    Text
    {"value"=>"Awarded Grants ", "count"=>421} (), {"value"=>"Professional Services ", "count"=>271} (), {"value"=>"Contracted Services ", "count"=>213} (), {"value"=>"Restricted Intergov Fed Grants", "count"=>201} (), {"value"=>"Construction ", "count"=>153} (), {"value"=>"Oper Transfers from General Fd", "count"=>148} (), {"value"=>"Oper Transfers Cap Reserve Fd ", "count"=>138} (), {"value"=>"Supplies - Other ", "count"=>134} (), {"value"=>"Mach & Equipment ", "count"=>128} (), {"value"=>"Materials ", "count"=>121} ()
  • object_short
    Text
    {"value"=>"Award Grnt", "count"=>421} (), {"value"=>"Prof Serv ", "count"=>271} (), {"value"=>"Cont Serv ", "count"=>213} (), {"value"=>"Fed Grnt ", "count"=>201} (), {"value"=>"CS Constr ", "count"=>153} (), {"value"=>"OpTr GenFd", "count"=>148} (), {"value"=>"OpTrCapRsv", "count"=>138} (), {"value"=>"Supp Other", "count"=>134} (), {"value"=>"Mach Equip", "count"=>128} (), {"value"=>"Materials ", "count"=>121} ()
  • fund_name
    Text
    {"value"=>"General Capital Projects Fund", "count"=>1434} (), {"value"=>"Grant Fund", "count"=>990} (), {"value"=>"Community Dev Block Grant Fund", "count"=>766} (), {"value"=>"Water Capital Projects Fund", "count"=>629} (), {"value"=>"HOME Ownership Grant Fund", "count"=>617} (), {"value"=>"Transit Capital Projects Fund", "count"=>157} (), {"value"=>"Civic Center Cap Projects Fund", "count"=>113} (), {"value"=>"Stormwater Capital Projects Fd", "count"=>101} (), {"value"=>"Parking Capital Projects Fund", "count"=>79} (), {"value"=>"Section 108 Rehab Grant Fund", "count"=>19} ()
  • function_name
    Text
    {"value"=>"Economic & Physical Developmnt", "count"=>1644} (), {"value"=>"Interfund Transfers", "count"=>638} (), {"value"=>"Transportation", "count"=>592} (), {"value"=>"Culture and Recreation", "count"=>510} (), {"value"=>"Water and Sewer", "count"=>424} (), {"value"=>"General Government", "count"=>392} (), {"value"=>"Public Safety", "count"=>371} (), {"value"=>"Environmental Services", "count"=>161} (), {"value"=>"Mass Transit", "count"=>118} (), {"value"=>"Civic Center", "count"=>72} ()
  • department_name
    Text
    {"value"=>"Planning & Development Dept", "count"=>1653} (), {"value"=>"Public Works Department", "count"=>706} (), {"value"=>"Water Department", "count"=>654} (), {"value"=>"Parks Rec & Cultural Arts Dept", "count"=>586} (), {"value"=>"Transportation Department", "count"=>340} (), {"value"=>"Administration Services Dept", "count"=>330} (), {"value"=>"Police Department", "count"=>239} (), {"value"=>"Fire & Rescue Department", "count"=>139} (), {"value"=>"Civic Center Department", "count"=>110} (), {"value"=>"Information Technology Dept.", "count"=>69} ()
  • division_name
    Text
    {"value"=>"Community Development Division", "count"=>1616} (), {"value"=>"Water General Operations Div", "count"=>636} (), {"value"=>"Streets & Sidewalks Division", "count"=>270} (), {"value"=>"Engineering Services Division", "count"=>257} (), {"value"=>"Parks Maintenance Division", "count"=>199} (), {"value"=>"Transit Administration Div", "count"=>156} (), {"value"=>"Patrol Division", "count"=>137} (), {"value"=>"Recreation Division", "count"=>136} (), {"value"=>"Stormwater Admin Division", "count"=>131} (), {"value"=>"Communication and Public Engag", "count"=>125} ()
  • cost_center_name
    Text
    {"value"=>"No Cost Center", "count"=>2962} (), {"value"=>"City of Asheville", "count"=>990} (), {"value"=>"CDBG Conversion", "count"=>124} (), {"value"=>"Sidewalks - New Construction", "count"=>99} (), {"value"=>"Mountain Housing Opportunities", "count"=>90} (), {"value"=>"WNC Nature Center", "count"=>81} (), {"value"=>"HOME Conversion", "count"=>69} (), {"value"=>"Paving", "count"=>50} (), {"value"=>"Homeward Bound of Asheville", "count"=>38} (), {"value"=>"Senior Opportunity Center", "count"=>27} ()
  • account_notes
    Text
  • transfers_2016
    Number
    -16801555 to 5961576
  • memo_balance
    Number
    -5300500.03 to 2260000
  • actual_2016
    Number
    -5300500.03 to 2260000
  • encumbered
    Number
    0 to 3531498.89
  • requisitioned
    Number
    0 to 53861
  • account_id2
    Number
    69 to 12328
  • original_budget_year
    Text
  • original_budget
    Number
  • transfers_2010
    Number
  • actual_2010
    Number
  • transfers_2011
    Number
  • actual_2011
    Number
  • transfers_2012
    Number
  • actual_2012
    Number
  • transfers_2013
    Number
  • actual_2013
    Number
  • transfers_2014
    Number
  • actual_2014
    Number
  • transfers_2015
    Number
  • actual_2015
    Number
  • project_id2
    Number
  • project_code
    Text
  • project_type
    Text
  • project_title
    Text
  • major_project
    Text
  • state_grant_number
    Text
  • federal_grant_number
    Text
  • department_code
    Text
  • comment
    Text
  • project_status
    Text
  • draw_down_frequency
    Text
  • start_year
    Number
  • start_period
    Number
  • start_month
    Number
  • start_day
    Number
  • end_month
    Number
  • end_day
    Number
  • expected_start_date
    Date
  • expected_end_date
    Date
  • original_total_days
    Number
  • revised_total_days
    Number
  • description
    Text
  • justification
    Text
  • short_title
    Text
  • project_notes
    Text
  • objectid
    Number

About

  • By on April 22, 2016
  • Updated about 1 year ago

Related Datasets