This dataset provides a list of vendor payments made since FY2017
This dataset has the following 17 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Fiscal Year | fiscal_year | number | The City of Providence operates on a fiscal year, beginning July 1, through June 30. | 2019 2023 2022 2017 2018 view top 100 |
Fiscal Period | fiscal_period | number | Fiscal Periods are the month of the fiscal year, beginning with July as Period 1 and ending with June as Period 12 | 12 6 4 5 3 view top 100 |
Payment Date | date | calendar_date | 2018-12-21T00:00:00.000 2019-07-15T00:00:00.000 2017-06-09T00:00:00.000 2022-12-13T00:00:00.000 2023-10-17T00:00:00.000 view top 100 | |
City Service Account | service | text | Prov. Public Schools Public Safety Law Department / City Solicitor Department of Public Works Public Property & Purchasing view top 100 | |
City Department Account | department | text | Law Department (101-105) CENTRAL OFFICE (00000) Police (101-302) PLANT OPERATION & MAINTENANCE (02900) Public Property (101-1801) view top 100 | |
City Program Account | program | text | Regular Elementary/Secondary Education Programs (10) G&A SERVICES (52100) OTHER SUPPLY (54700) OTHER SERVICES (53500) Special Education (20) view top 100 | |
City Expense Account | expense_category | text | General Supplies and Materials (56101) MISC. EXPENSES (53500) PAY OF CLAIMS & DAMAGES (52192) Worker's Compensation Medical (Self Insured) (52730) FEES NOT CLASSIFIED (52120) view top 100 | |
Invoice Description | description | text | Speed Camera Citation Refund SUPPLIES see attached for accounts SERVICES PARTS view top 100 | |
Payment Amount | amount | number | 20 50 300 150 225 view top 100 | |
entry_type | entry_type | text | AP/AD AP/ view top 100 | |
Funding Source Account | fund | text | General Fund (101) School General Fund (10) Federal Revenue Through State (21) COMMUNITY DEVELPMT BLOCK GRANT (231) LEAD GRANT FUND (239) view top 100 | |
Vendor/Payee | vendor_name | text | WB MASON CO., INC PROVIDENCE WATER NARRAGANSETT BAY COMMISSION RHODE ISLAND ENERGY RICOH USA, INC. view top 100 | |
City Vendor ID | vendor_id | number | 51317 47187 30346 61767 41223 view top 100 | |
City Payment ID | payment_id | number | 872167 708557 615651 10118 837790 view top 100 | |
payment_method | payment_method | text | System Check Epayables view top 100 | |
payment_status | payment_status | text | Reconciled view top 100 | |
invoice_id | invoice_id | number | 136565 32283 33413 110121 192873 view top 100 |