Open Checkbook Data FY14

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.somervillema.gov
Id 3k8j-5r8r
Name Open Checkbook Data FY14
Attribution City of Somerville Auditing Department
Category Finance
Tags open checkbook, finance, fy14
Created 2016-02-01T15:33:26Z
Publication Date 2016-02-01T15:37:48Z

Description

The City of Somerville uses this dataset to provide residents with information regarding local government spending.

Columns

| Included | Schema Type    | Field Name      | Name            | Data Type     | Render Type   |
| ======== | ============== | =============== | =============== | ============= | ============= |
| Yes      | series tag     | item            | Item #          | text          | number        |
| Yes      | series tag     | category_of_gov | Category of Gov | text          | text          |
| Yes      | series tag     | vendor_name     | VENDOR NAME     | text          | text          |
| Yes      | numeric metric | amount          | Amount          | number        | number        |
| Yes      | time           | check_date      | Check Date      | calendar_date | calendar_date |
| Yes      | series tag     | department      | Department      | text          | text          |
| Yes      | series tag     | check           | Check #         | text          | number        |
| Yes      | series tag     | org_description | Org Description | text          | text          |
| Yes      | series tag     | account_desc    | Account Desc    | text          | text          |

Time Field

Value = check_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Data Commands

series e:3k8j-5r8r d:2013-11-20T00:00:00.000Z t:account_desc="IN STATE CONFERENCES" t:check=567463 t:department="OSPCD ADMINISTRATION" t:item=1 t:vendor_name="128 WEST TRANSPORTATION COUNCIL" t:org_description="OSPCD-TRANS ORDINARY MAINT" t:category_of_gov="General Government" m:amount=100

series e:3k8j-5r8r d:2014-03-12T00:00:00.000Z t:account_desc="HOME REHABILITATION" t:check=570972 t:department="EXEC OS ENVIRONMENT" t:item=2 t:vendor_name="17 MARSHALL STREET CONDO ASSOCIATION" t:org_description="ENERGY EFFIC.& CONSERV.BG" t:category_of_gov="General Government" m:amount=347.96

series e:3k8j-5r8r d:2014-07-02T00:00:00.000Z t:account_desc="PROFESSIONL & TECHNCL SVC" t:check=575708 t:department="ARTS COUNCIL" t:item=3 t:vendor_name="3 GRACES PRODUCTIONS" t:org_description="EXEC-ARTS CNCL ORDINARY MAINT" t:category_of_gov="General Government" m:amount=600

Meta Commands

metric m:amount p:float l:Amount t:dataTypeName=number

entity e:3k8j-5r8r l:"Open Checkbook Data FY14" t:attribution="City of Somerville Auditing Department" t:url=https://data.somervillema.gov/api/views/3k8j-5r8r

property e:3k8j-5r8r t:meta.view v:id=3k8j-5r8r v:category=Finance v:attributionLink=http://www.somervillema.gov/departments/finance/auditing v:averageRating=0 v:name="Open Checkbook Data FY14" v:attribution="City of Somerville Auditing Department"

property e:3k8j-5r8r t:meta.view.license v:name="Open Data Commons Open Database License" v:termsLink=http://opendatacommons.org/licenses/odbl/1.0/

property e:3k8j-5r8r t:meta.view.owner v:id=j34k-s96t v:screenName="Michael Mastrobuoni" v:displayName="Michael Mastrobuoni"

property e:3k8j-5r8r t:meta.view.tableauthor v:id=j34k-s96t v:screenName="Michael Mastrobuoni" v:roleName=administrator v:displayName="Michael Mastrobuoni"

Top Records

| item | category_of_gov    | vendor_name                          | amount  | check_date          | department               | check  | org_description                | account_desc                | 
| ==== | ================== | ==================================== | ======= | =================== | ======================== | ====== | ============================== | =========================== | 
| 1    | General Government | 128 WEST TRANSPORTATION COUNCIL      | 100.00  | 2013-11-20T00:00:00 | OSPCD ADMINISTRATION     | 567463 | OSPCD-TRANS ORDINARY MAINT     | IN STATE CONFERENCES        | 
| 2    | General Government | 17 MARSHALL STREET CONDO ASSOCIATION | 347.96  | 2014-03-12T00:00:00 | EXEC OS ENVIRONMENT      | 570972 | ENERGY EFFIC.& CONSERV.BG      | HOME REHABILITATION         | 
| 3    | General Government | 3 GRACES PRODUCTIONS                 | 600.00  | 2014-07-02T00:00:00 | ARTS COUNCIL             | 575708 | EXEC-ARTS CNCL ORDINARY MAINT  | PROFESSIONL & TECHNCL SVC   | 
| 4    | General Government | 3 GRACES PRODUCTIONS                 | 1500.00 | 2013-08-14T00:00:00 | ARTS COUNCIL             | 564353 | ARTS CNCL ARTS/UNION'13        | PROFESSIONAL & TECHNCAL SVC | 
| 5    | General Government | 4IMPRINT                             | 1249.76 | 2014-04-30T00:00:00 | ARTS COUNCIL             | 848    | ARTS COUNCIL                   | PGM SUPPLIES & MATERIALS    | 
| 6    | General Government | 4IMPRINT                             | 207.62  | 2013-12-04T00:00:00 | CONSTITUENT SERVICES 311 | 486    | EXEC-CONSTITUENT ORDINARY MAIN | OFFICE SUPPLIES             | 
| 7    | General Government | 4IMPRINT                             | 787.68  | 2014-04-02T00:00:00 | PERSONNEL DEPARTMENT     | 781    | PERSONNEL ORDINARY MAINT       | AWARDS                      | 
| 8    | General Government | 4IMPRINT                             | 1500.00 | 2014-04-30T00:00:00 | BOARD OF HEALTH          | 848    | BOARD OF HEALTH ORDINARY MAINT | UNIFORMS                    | 
| 9    | General Government | 4IMPRINT                             | 1544.31 | 2013-10-02T00:00:00 | BOARD OF HEALTH          | 318    | MASS IN MOTION '14             | OTHER SUPPLIES              | 
| 10   | General Government | 4IMPRINT                             | 240.43  | 2013-11-20T00:00:00 | BOARD OF HEALTH          | 444    | MASS IN MOTION '14             | OTHER SUPPLIES              |