iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Use NYC Open Data’s official Citywide Payroll Data (Fiscal Year) dataset, provided by the City’s Office of Payroll Administration (OPA). Search or filter the records by fiscal year, agency, employee name, title and other fields, then read each pay measure separately. The file is an annual, fiscal-year record—not a live view of anyone’s current paycheck.
The listing reported 6.78 million rows and 17 columns when checked on October 4, 2026. Its latest-update date was April 16, 2026, but both the row count and available years can change. Check the live dataset page before citing a year as the newest available.
What the NYC payroll dataset contains
Each row represents an employee payroll record for a particular fiscal year. OPA says the respective city agencies enter the information into the City’s Personnel Management System. The dataset exists to show how the municipal budget is being spent on salary and overtime pay for city employees.
Recommended Free Tools
“Data is collected because of public interest in how the City’s budget is being spent on salary and overtime pay for all municipal employees.”
#1 Best Overall
Sale
Compressed Air Duster,130000RPM Super Power Cordless Air Duster,Rechargeable Brushless Blower,3 Gear Adjustable Blower with LED Light,Dust Remover for Computer/House/Outdoor/Car
- Powerful Turbo Fan:CAGIWIRU Electric Air Duster have reached speed up to 130000RPM,Can efficient remove dust and debris.With LED light and Three Adjustable Speed to meet with different cleaning tasks.
- With Attached USB C Fasting Charging cable.Charing 3 hours,Enjoy up to 240 minutes of use on the lowest setting, For third speed can use for 25mins.with four charging options to meet with your needs.
- Wide Application: attached 5 different nozzles,making it suitable for a variety of scenes, such as car,pet, pc, keyboards, and other electronic devices. It also serves for office and home clean duster.
- Handy Design & Portable:Cordless air duster electric nozzle is Light weight and small size, design and comfortable to hold and space saving, convenient to carry around. You can put it in your room or inside the car without taking up space.
- Economical &Reusable: Built durable materials with a long-lasting battery,our CAGIWIRU air duster it's a sustainable alternative to disposable air cans.
NYC Open Data dataset description
The official listing includes fields for:
- Fiscal year
- Payroll number
- Agency
- First and last name fields
- Agency start date
- Work-location borough
- Civil-service title description
- Leave status as of June 30
- Base Salary
- Pay Basis
- Regular Hours
- Regular Gross Paid
- Overtime Hours
- Overtime Paid
- Other Compensation, including lump-sum and/or retroactive payments
Those fields let you examine an employee, agency or title for a defined fiscal year. They do not provide a continuously updated paycheck balance, a guaranteed current salary, or a complete explanation of every payroll transaction.
Step-by-step: find an employee or agency
1. Open the authoritative listing
- Go to NYC Open Data and search for Citywide Payroll Data (Fiscal Year).
- Select the dataset published by NYC Open Data with OPA identified as the data provider.
- Use that official listing as the reference point. Community-created views can be useful for exploration, but they are not the authoritative dataset page.
2. Confirm the time period
Look at the fiscal-year values available in the listing and note the page’s latest-update date. NYC payroll data is updated annually. The April 16, 2026 update date reported on October 4, 2026 is a point-in-time metadata value, not a promise that every future visit will show the same years or row count.
3. Narrow the records
Use the page’s search and filter controls to combine the fields that identify the records you need:
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- Fiscal year: select one year before comparing pay.
- Agency: limit the result to a department or office.
- First name and last name: search an employee. Try spelling variations and inspect more than one year when a name is common.
- Title Description: find employees in a civil-service title.
- Work Location Borough: restrict the geographic work location.
- Leave Status as of June 30: identify the status recorded at the fiscal-year cutoff.
Combining agency, fiscal year and name is usually more reliable than searching a name alone. A name that does not appear can reflect spelling, redaction, a different fiscal year or an agency-record issue; it does not by itself prove that the person had no city payroll record.
4. Open the complete record
Read the row’s identifying fields together before looking at dollars. Confirm the fiscal year, agency, employee name, title and pay basis. Then record the exact labels and values for base salary, regular gross paid, overtime and other compensation. Preserve the row’s context if you quote or publish a figure.
How to read the pay fields
The most common error is treating every dollar column as “salary.” The dataset separates the measures, and each answers a different question.
| Field | What it represents | How to use it |
|---|---|---|
| Base Salary | The salary value associated with the employee’s position and pay basis. | Use it to describe the stated base rate, not the amount necessarily paid during the year. |
| Pay Basis | Whether the pay is hourly, per diem or annual. | Check this before comparing salary figures. An hourly or per-diem amount is not directly comparable to an annual rate without additional context. |
| Regular Hours | Hours recorded as regular work for the fiscal-year record. | Use with pay basis and regular gross paid to understand ordinary paid work. |
| Regular Gross Paid | Regular pay actually recorded as paid in that fiscal year. | Use when the question is how much regular pay was paid, rather than the employee’s stated base rate. |
| Overtime Hours | Overtime hours recorded for the fiscal year. | Pair with overtime paid; do not infer overtime from base salary alone. |
| Overtime Paid | Overtime compensation recorded for the fiscal year. | Use the exact field name when discussing overtime spending. |
| Other Compensation | Other payments described by the listing as lump-sum and/or retroactive payments. | Keep separate from regular and overtime pay because its timing and reason can differ. |
A base-salary figure can therefore be higher or lower than regular gross paid, and total compensation can include overtime or other payments. Do not add columns into a new “salary” number unless you clearly define the calculation and retain the original fields.
Free tools Windows power users keep installed
One-click scans. No signup required.
Fiscal year is not a calendar-year paycheck
Every record is tied to a city fiscal year. Use the fiscal-year label exactly as shown when writing a headline, chart or comparison. A fiscal-year amount can include payments made during that reporting period even when the underlying salary rate changed, an employee worked only part of the year, or a lump-sum or retroactive payment was posted.
The annual update schedule also means a newly hired employee, a recent raise or a current overtime shift may not appear until a later release. If you need the latest available information, verify the listing’s update date and the newest fiscal-year value on the day you make the claim.
Rank #2
- Screen Cleaner is Your Screen’s New Bestfriend! - EVEO is proud to present a screen cleaner that’s perfectly suited for your TV. Meet your new screen cleaner, computer screen cleaner, laptop cleaner, iPad cleaner, Macbook,tv cleaner or any other electronic device. Our screen cleaner spray and wipe along with the included plush microfiber cloth, easily removes dust, fingerprints & other smudges on the screen’s surface. Clean effectively for a streak-free screen
- Gentle on your Screens - Our screen cleaner spray and wipes is compatible to be used even for the most sensitive LCD, LED, CRT, and OLED screens in proper use. Be at ease knowing that this product is compatible with all the major brands: LG, SONY, Samsung, Sharp, iPad, iPhone, Android screens, Kindle, PC monitors - we’ve got you covered! Can be used as LCD screen cleaner, tv cleaner, smart tv screen cleaner, and more
- Premium Super Soft Plush Microfiber Cloth - Included in this efficient screen cleaning kit. This screen cleaner spray and wipe has our signature plush microfiber cloth specially designed to comply with screens and monitors and leave them streak-free. Has been shown to effectively absorbs stubborn stains, zero streaks, and no fiber shedding. Always use this together with our screen cleaner for the best results
- Easy-to-Use Screen Cleaner Kit + microfiber cleaning cloth - The EVEO Screen Cleaning Kit will easily be your new favorite tool when it comes to taking care of the things you love most, quick and easy solution for a streak-free screen. Simply screw on the sprayer gun on the screen cleaner bottle. Spray the cleaning liquid onto the microfiber cloth, then wipe the screen until desired cleanliness & shine is achieved.
- Quality Screen Care Kit Worth Purchasing - Enjoy a convenient Screen Cleaner anytime, anywhere you need it. Your satisfaction is our top priority. We stand behind the quality of our products and that’s why, you shouldn’t be worrying at all. We manufacture the Best Screen Cleaner. and can be used for laptop cleaning kit, laptop screen cleaner, tv screen cleaner for smart tv. MacBook screen cleaner, monitor cleaner or screen cleaner spray for electronic devices with microfiber cleaning cloth
Comparing employees, agencies or years
Make comparisons on matching dimensions. A useful comparison record includes the following:
| Comparison item | Why it matters |
|---|---|
| Fiscal year | Prevents mixing reporting periods. |
| Agency | Confirms that similarly named employees or titles belong to the same organization. |
| Pay basis | Separates annual, hourly and per-diem values. |
| Base Salary | Shows the stated base rate. |
| Regular Gross Paid | Shows regular pay recorded as paid in that fiscal year. |
| Overtime Hours and Overtime Paid | Shows both the amount of overtime work and its recorded compensation. |
| Other Compensation | Captures lump-sum or retroactive payments that can change totals. |
For a year-over-year comparison, keep the employee and agency consistent, put each fiscal year in its own row, and report the same field in every column. If the employee changed titles, agencies or pay basis, show that change instead of presenting the numbers as a like-for-like salary trend.
Exporting data for a spreadsheet or Tableau
You can inspect a few rows in the web interface or move a larger, repeatable analysis into a spreadsheet or Tableau. NYC Open Data documents an OData connection that can refresh on demand. Tableau users should choose the OData v2 endpoint option described in that documentation.
- Start from the official Citywide Payroll Data (Fiscal Year) listing.
- Use the listing’s documented OData access route rather than treating a screenshot or manually copied table as a permanent data source.
- In Tableau, select the OData v2 option when prompted.
- Apply fiscal-year, agency and other filters in the workbook, and retain the source field names.
- Record the refresh date and the dataset update date alongside any chart or exported result.
The OData route is an optional workflow for analysis. A paid application is not required to view the public dataset.
Redactions and missing names
The listing notes that some NYPD records and records for the Manhattan, Kings, Queens, Richmond, Bronx and Special Narcotics District Attorneys’ Offices are redacted. Its notes cite public-safety and law-enforcement exemptions under New York Public Officers Law § 87.
Redacted names may appear as a redaction marker. A masked or missing name does not show that no payroll record exists. You can still evaluate the non-name fields that are published, but do not attempt to identify a person from a redacted row or imply that the row is an ordinary named employee record.
Data-quality checks before publishing a number
- Quote the fiscal year: Never present a fiscal-year amount as a current paycheck without qualification.
- Use the exact field label: Say “Overtime Paid” or “Regular Gross Paid,” not an undifferentiated “salary,” when that is what the row contains.
- Check pay basis: Annual, hourly and per-diem values require different interpretation.
- Inspect hours: Regular and overtime hours can explain why gross paid differs from a base rate.
- Check other compensation: Lump-sum or retroactive payments can materially affect a year’s total.
- Confirm the agency and title: Similar names and titles can produce misleading matches.
- Preserve the update date: Note when the listing was last updated if the number is likely to change in a later annual release.
When a value is consequential or surprising, retain the row’s fiscal year and exact field names and seek confirmation from the responsible agency or OPA. The agencies enter the information into the Personnel Management System, so a follow-up question may need to go to the agency that supplied the record.
Common mistakes and how to fix them
Calling base salary “annual pay received”
Why it fails: Base Salary and Regular Gross Paid are separate fields, and Pay Basis may be hourly or per diem.
Fix: Report the base rate with its pay basis, then report regular gross paid separately if the question concerns money paid during the fiscal year.
Rank #3
- 【Large size】：Measuring 800 x 300 mm/ 31. 5×12 inches, which is wider and taller than others. Large mouse pad can perfectly fit your keyboard and mouse of any size, and there is also ample space for peripherals such as phones, tablets, etc.
- 【LED backlight mouse pad】：Blade Hawks RGB mouse pad provides 7 static modes and 7 dynamic modes will give you the options you are looking for. Power-off memory function remembers the last lighting mode you selected. The super glow fiber Chroma will give you a colorful gaming setup that you want.
- 【Anti-slip rubber base】：Made from Natural rubber, this gaming mousepad will firmly grip your desktop, allowing you to enjoy the ultimate precision in the games you are most passionate about. It also comes with a texture that enhances this ability even further.
- 【Smooth and waterproof surface】: Micro-textured cloth surface, for extremely precise mouse control and a smooth movement. When liquid splashes on the gaming mouse pad, it forms water droplets and slides down. Will not delay your work or gameplay.
- 【Plug and play】: This mouse and keyboard pad is powered by USB, plug and play, no driver required. One button control light modes. Press one time to change the lighting mode, press twice to change the brightness, press and hold about 3 seconds turn ON/OFF.
Adding overtime to base salary without explaining the calculation
Why it fails: Overtime Paid and Other Compensation are distinct components, and a simple sum can hide the difference between a rate and payments recorded in a period.
Fix: Show each component with its original label. If you calculate a total, identify the included fields and fiscal year.
Treating the file as a live payroll lookup
Why it fails: The dataset is updated annually, not continuously.
Fix: Check the page’s update date and newest fiscal year, and describe the result as a fiscal-year record.
Assuming a missing name means no record exists
Why it fails: Certain law-enforcement and public-safety records are redacted.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Fix: Look for the redaction notation and apply the listing’s disclosure note before drawing conclusions.
Comparing unlike records
Why it fails: Different fiscal years, agencies, titles, pay bases or hours can make a numerical comparison misleading.
Fix: Align those dimensions first and explain any change in job, agency or pay basis.
Build a reproducible lookup
For a one-person check, write down the search choices before opening the row: fiscal year, agency, first and last name, and title if known. This prevents a similarly named employee in another agency from being mistaken for the target record. If the name is common, review the payroll number, agency start date, work-location borough and title description as additional identifiers.
Rank #4
- 【Softer and More Comfortable】Vaydeer wrist rest has unique diamond pattern, which is the combination of softness and aesthetics. The materials of wrist rest are improved into higher quality memory foam and covered with silky smooth lycra. The computer wrist rest makes you as comfortable and cushiony as like rest your wrists on clouds.
- 【Ergonomic Wrist Saver】The wrist rests for keyboard and mouse comes with a 17.32×3.15×0.83 inch keyboard wrist pad and a 5.94×3.15×0.83 inch mouse wrist support. Based on ergonomic design, the unique concave shape is the perfect fit for your wrist joints. The wrist rest pad fits most computer keyboards and laptops, improve hand and wrist posture, release your wrist and arm stress.
- 【Non-Slip Rubber Bottom】Featuring an anti-skid silicone base on the bottom, this wrist keyboard support stays firmly in place on your desk, preventing the padding from sliding around, ensuring stable and consistent wrist support during extended computer sessions.
- 【Better Experience & Pain Relief】Our keyboard arm rest is beneficial to alleviate the soreness caused by direct contact and friction between your arm and a hard desk surface, reducing the risk of wrist fatigue or carpal tunnel. The soft texture of memory foam can evenly distribute the pressure around your wrists and provide good support with just enough give.
- 【Helpful in Multiple Scenarios】Whether you're working, studying, writing, typing, gaming, this keyboard and mouse rest combo is an essential accessory to add comfort and support to your hands and wrists. It’s also a great gift for men, women, family, friend, coworker, gamer, teacher, etc.
For an agency or title review, begin with the fiscal-year filter and agency or Title Description filter, then inspect the remaining dimensions. Keep annual, hourly and per-diem records in separate groups. A title search can return records from multiple agencies, and a borough filter describes work location rather than a person’s residence.
Save the exact values you used, not just a browser link. Include the fiscal year, agency, payroll number when relevant, title, pay basis, all pay fields being discussed, the dataset update date and your access date. A saved screenshot can document what you saw, but a citation to the official listing and field names makes the result easier to reproduce after the annual update.
Interpreting differences between pay fields
Differences among Base Salary, Regular Gross Paid, Overtime Paid and Other Compensation are not automatically errors. Base Salary is a rate associated with a position and pay basis, while Regular Gross Paid records regular money paid during the fiscal year. A person who worked part of a year may have regular gross pay below the stated annual base rate. Recorded overtime hours and Overtime Paid address extra work separately. Other Compensation can contain lump-sum or retroactive payments, so it may appear even when the regular-pay pattern looks ordinary.
Do not estimate an hourly rate by dividing an annual base salary by Regular Hours unless you clearly explain the assumptions; the listing’s Pay Basis already identifies whether the value is hourly, per diem or annual, and the fields are not presented as a single calculation. Likewise, do not assume that Regular Gross Paid plus Overtime Paid plus Other Compensation is an official “total salary” field. If you present such a sum for a defined purpose, label it as your calculation and list every included field.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errorsHow current is the listing?
The dataset is released on an annual schedule rather than continuously. The page showed a latest update of April 16, 2026 when checked October 4, 2026. That date describes the listing at that time; it does not guarantee that a later visit will show the same update date, row count or fiscal-year range. Always read the live metadata before calling a year the latest.
The listing showed 6.78 million rows and 17 columns on that access date. These are changeable metadata counts, not a citywide salary total, an employee headcount or a measure of spending. Rows can represent different fiscal years and employment circumstances, and the count alone cannot establish how many people worked for the City or how much the City paid.
Free access and optional analysis tools
The official NYC Open Data page is a public web resource, so a dedicated lookup product, payroll book or paid software license is not required to search it. The browser interface is sufficient for individual records. For repeatable spreadsheet or Tableau work, use the documented OData connection and refresh it on demand. Tableau users should select OData v2, as directed in NYC Open Data’s access documentation.
Whether you work in the browser, a spreadsheet or Tableau, retain the source URL, update date and filters. A paid tool may change how you analyze the rows, but it does not change the official field definitions or the annual nature of the release.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →A publication checklist
- Name the official Citywide Payroll Data (Fiscal Year) listing and identify OPA as the provider.
- State the fiscal year, agency and title or employee identifier used.
- Use the exact field label for every dollar or hour figure.
- State the Pay Basis before comparing salary values.
- Separate regular pay, overtime and other compensation.
- Note the listing’s update date and your access date for time-sensitive claims.
- Explain any redaction, masked name or missing value that affects interpretation.
- Do not turn row counts into salary totals or headcounts.
- For surprising values, ask the responsible agency or OPA to confirm the record.
What the row count does—and does not—tell you
The listing showed 6.78 million rows and 17 columns on October 4, 2026. Those are metadata counts for that access date and can change when the annual dataset is updated. A row count is not a citywide salary total, an employee headcount, or evidence that every row represents a full-year worker. Do not derive a citywide spending statistic from the count alone.
Best Value
- 【No Drill Mounted】Cable management tray can be assembled in as little as 3 minutes or less-simply. Side clips easily clampe the edge of desk, pass through the holes on the sides, and secure excess cables with baskets. Desk cable management supports inward or outward installation to meet your needs in different scenarios, and provides you with great convenience when collecting and organizing wires.
- 【Rubber Pad Protects Desk】Wire organizer under desk built-in soft rubber pads on the clamp protect your desk from scratches, so you will not damage your furniture or office.
- 【Sturdy and Beautiful】Cord management under desk is made of high-quality carbon steel and holds about 15 lbs. The wire basket has 2 holes on each side of the tray to enable your cables to pass freely. Cable baskets are suitable for desk thickness use from 0.4" to 2.4".
- 【Space Saving & Keep Organized】Desk cable management tray holds all your power cords, outlet strips, USB hubs and computer transformers hidden from your feet, and the data cables will not enter the vacuum cleaner to keep your desk clean and tidy. Desk wire organizer is also suitable for use in the kitchen and outdoors.
- 【Reduce Safety Risks】Cable tray under desk keeps all plugs away from your kids, no more worry about tripping. Using 2 holes wire tray saves extra space, helps you easily cabling and wire protection. The mesh design is not easy to accumulate dust, but avoids safety accidents caused by messy wires.
A practical citation format
For a chart, article or public-record request, identify the dataset and preserve the record’s context. A clear description includes:
- NYC Open Data’s Citywide Payroll Data (Fiscal Year) dataset
- OPA as the data provider
- The fiscal year
- The agency and title, when relevant
- The exact field name, such as Base Salary, Regular Gross Paid or Overtime Paid
- The dataset update date or the date you accessed the listing
This format lets readers distinguish a stated salary rate from money actually recorded as paid and gives them enough information to reproduce the lookup.
Frequently Asked Questions
Is NYC’s payroll dataset a live salary lookup?
No. Citywide Payroll Data (Fiscal Year) is an annual fiscal-year record. Check the listing’s update date and newest fiscal-year value; a current paycheck or recent overtime shift may not appear until a later release.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11What is the difference between Base Salary and Regular Gross Paid?
Base Salary is the stated salary value associated with the position and pay basis. Regular Gross Paid is regular compensation recorded as paid during that fiscal year. They are separate fields and should not be presented as the same amount.
How do I compare two NYC employees’ pay?
Match the fiscal year, agency, title and Pay Basis, then compare the same field—such as Base Salary, Regular Gross Paid or Overtime Paid—for each record. Keep overtime hours and Other Compensation separate.
Why does a person’s name appear as a redaction marker or not appear at all?
The listing says some NYPD records and records from the Manhattan, Kings, Queens, Richmond, Bronx and Special Narcotics District Attorneys’ Offices are redacted under public-safety and law-enforcement exemptions in New York Public Officers Law § 87. A masked name does not mean there is no payroll record.
Can I use the row count as the number of city employees?
No. The reported 6.78 million rows include records across fiscal years and employment circumstances. The count is changeable metadata, not an employee headcount or salary total.
Free tools Windows power users keep installed
One-click scans. No signup required.
Do I need paid software to view NYC payroll data?
No. The public NYC Open Data page can be searched in a browser. OData and Tableau are optional workflows for larger or repeatable analysis; Tableau users should select the documented OData v2 endpoint.
Who enters the payroll information?
OPA says the respective city agencies enter the information into the City’s Personnel Management System. For a consequential or surprising value, preserve the fiscal year and exact field labels and ask the responsible agency or OPA to confirm it.
What should I cite when publishing a payroll figure?
Cite the official Citywide Payroll Data (Fiscal Year) listing, identify OPA as provider, and include the fiscal year, agency or title, exact field name, and the listing’s update date or your access date.
The Bottom Line
For an NYC public-employee salary lookup, start with the official NYC Open Data Citywide Payroll Data (Fiscal Year) listing. Filter by fiscal year and identifying fields, check Pay Basis, and keep Base Salary, Regular Gross Paid, Overtime Paid and Other Compensation distinct. Treat the annual file as a historical fiscal-year record, account for redactions and changing metadata, and document the exact row and update date behind every published number.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
