Friday, October 6, 2017

New York City Salaries in our Open Data Website

This is one of the strengths of our Open Data Website.  The informationcan be organized and updated in a standard format.

See https://dev.socrata.com/foundry/data.cityofnewyork.us/4qxi-jgbe and https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e
This payroll data is updated in one place so if you write applications that use the data you will see that your application will always have the latest data.

This avoids the need to constantly download data or even worse extract data from PDF files, etc.

For example see: https://docs.google.com/spreadsheets/d/17eGj0ag7UtXRM8GAcmZbKiSi5RdUepSmEBvDhCbw-v8/edit?usp=sharing

This is a sample of the New York City Superintendents salaries.

Notice that there is a misspelling: "SUPERINTENDENT" is sometimes spelled "SUPERTINDENT"  

using curl:
 curl  'https://data.cityofnewyork.us/resource/4qxi-jgbe.csv?$where=title_description%20like%20%27%25COMMUNITY%20SUPER%25%27' >nyc_superintendent_salaries.csv

using a link: 

https://data.cityofnewyork.us/resource/4qxi-jgbe.json?$where=title_description%20like%20%27%25COMMUNITY%20SUPER%25%27
first_namelast_namefiscal_yearregular_gross_paidtitle_description
MICHAELPRAYOR2015$219,374.36COMMUNITY SUPERTINDENT
TIMOTHYLISANTE2017$206,275.84COMMUNITY SUPERTINDENT
TIMOTHYLISANTE2015$206,244.56COMMUNITY SUPERTINDENT
DONALDCONYERS2017$202,001.64COMMUNITY SUPERTINDENT
DONALDCONYERS2015$201,819.78COMMUNITY SUPERTINDENT
TIMOTHYLISANTE2016$200,426.88COMMUNITY SUPERTINDENT
MILADYBAEZ2017$197,280.76COMMUNITY SUPERTINDENT
DONALDCONYERS2016$196,273.88COMMUNITY SUPERTINDENT
ESTHERFRIEDMAN2017$195,557.04COMMUNITY SUPERTINDENT
EDNALABOY2017$195,429.76COMMUNITY SUPERTINDENT
ESTHERFRIEDMAN2015$195,210.98COMMUNITY SUPERTINDENT
EDNALABOY2015$194,023.08COMMUNITY SUPERTINDENT
RACHELLEKLAINBERG2017$193,465.89DEPUTY COMMUNITY SUPERINTENDENT
GARYHECHT2015$192,497.92COMMUNITY SUPERTINDENT
MILADYBAEZ2016$191,686.64COMMUNITY SUPERTINDENT
ESTHERFRIEDMAN2016$190,011.36COMMUNITY SUPERTINDENT
EDNALABOY2016$189,887.96COMMUNITY SUPERTINDENT
ROSE MARIEMILLS2015$189,348.00COMMUNITY SUPERTINDENT
TIMOTHYLISANTE2014$187,746.96COMMUNITY SUPERTINDENT
LASHAWNROBINSON2017$187,556.17COMMUNITY SUPERTINDENT
ROSE MARIEMILLS2017$186,044.56COMMUNITY SUPERTINDENT
YOLANDATORRES2017$186,000.60COMMUNITY SUPERTINDENT
JUANMENDEZ2015$185,514.06COMMUNITY SUPERTINDENT
MANUELRAMIREZ2015$184,089.82COMMUNITY SUPERTINDENT
GARYHECHT2017$183,931.90COMMUNITY SUPERTINDENT
DONALDCONYERS2014$183,408.86COMMUNITY SUPERTINDENT
KATHYREHFIELD2017$182,974.60COMMUNITY SUPERTINDENT
JUANMENDEZ2017$182,670.12COMMUNITY SUPERTINDENT
MEISHAROSS PORTER2016$181,994.93COMMUNITY SUPERTINDENT
ANITASAUNDERS2015$181,778.22DEPUTY COMMUNITY SUPERINTENDENT
JULIANNABOVE2017$181,216.96COMMUNITY SUPERTINDENT
MICHELELLOYD BEY2014$180,526.08COMMUNITY SUPERTINDENT
ROSE MARIEMILLS2016$180,180.75COMMUNITY SUPERTINDENT
AHOROWITZ2017$179,780.12COMMUNITY SUPERTINDENT
JULIANNABOVE2015$179,414.03COMMUNITY SUPERTINDENT
MICHAELALCOFF2017$179,353.16COMMUNITY SUPERTINDENT
AHOROWITZ2015$179,240.88COMMUNITY SUPERTINDENT
BARBARAFREEMAN2017$178,745.92COMMUNITY SUPERTINDENT
YOLANDATORRES2016$178,136.44COMMUNITY SUPERTINDENT
KETLERLOUISSAINT2017$177,988.92COMMUNITY SUPERTINDENT
KATHYREHFIELD2016$177,786.32COMMUNITY SUPERTINDENT
JUANMENDEZ2016$177,490.60COMMUNITY SUPERTINDENT
LASHAWNROBINSON2015$177,482.25COMMUNITY SUPERTINDENT
BARBARAFREEMAN2015$177,256.28COMMUNITY SUPERTINDENT
ALEXANDRAESTRELLA2017$176,241.36COMMUNITY SUPERTINDENT
JULIANNABOVE2016$176,079.29COMMUNITY SUPERTINDENT
MARIALOPEZ2016$175,651.69COMMUNITY SUPERTINDENT
ELAINELINDSEY2017$175,355.76COMMUNITY SUPERTINDENT
GARYHECHT2014$175,233.12COMMUNITY SUPERTINDENT
ANTHONYLODICO2017$175,051.28COMMUNITY SUPERTINDENT
AHOROWITZ2016$174,682.12COMMUNITY SUPERTINDENT
DANIELLEDIMANGO2015$174,617.72COMMUNITY SUPERTINDENT
MEISHAROSS PORTER2017$174,404.12COMMUNITY SUPERTINDENT
RAHESHAAMON2017$174,249.92COMMUNITY SUPERTINDENT
CARRONSTAPLE2017$173,905.72COMMUNITY SUPERTINDENT
KARINACOSTANTINO2017$173,831.92COMMUNITY SUPERTINDENT
DANIELLAPHILLIPS2017$173,831.92COMMUNITY SUPERTINDENT
BARBARAFREEMAN2016$173,677.12COMMUNITY SUPERTINDENT
PAULROTONDO2017$173,671.92COMMUNITY SUPERTINDENT
ESTHERFRIEDMAN2014$173,254.85COMMUNITY SUPERTINDENT
MICHAELALCOFF2016$172,893.91COMMUNITY SUPERTINDENT
ISABELDIMOLA2017$172,527.36COMMUNITY SUPERTINDENT
LASHAWNROBINSON2016$172,054.72COMMUNITY SUPERTINDENT
MARIALOPEZ2017$171,882.52COMMUNITY SUPERTINDENT
ANTHONYLODICO2015$171,782.01COMMUNITY SUPERTINDENT
KARINACOSTANTINO2015$171,481.12COMMUNITY SUPERTINDENT
LENONMURRAY2015$171,481.12COMMUNITY SUPERTINDENT
YOLANDATORRES2015$171,481.12COMMUNITY SUPERTINDENT                                      
Posted by at No comments:

Saturday, September 23, 2017

Look at the Current New York City Department of Education Budget on a map

See https://taxhistory.brooklyncoop.org/nyc_schoolbudget_map.html

Correction to place Pre-K allocation in proper district


Please zoom in to see details.

If you zoom in you will see details for multiple schools at one location (if any exist)

For Example, if you zoom in on a marble hill school, you'll see:



There are some missing places because it is hard to find certain Schools by the identifier.

For example, the following school identifiers are not even found in the NYC DOE School Search site.  See http://schools.nyc.gov/SchoolSearch/

The large points in Wall Street area of Manhattan is where these ungeocoded points are until they are moved to their correct location.

 This has been corrected, it appears that the NYC DOE Budget using numbers such as 20KP20 to mean ALL PRE-KINDERGARTEN programs in district 20.

New List of School Identifiers that cannot be found:


33K891
79K755
79M331
79M645
79M973
79Q344
79Q950
79Q952
79X695
88KLC1
88KLC1*
88MLC1
88QLC1
88RLC1
88XLC1

Old List of School Identifiers that cannot be found:

02M473
02MP02
02MS02
04MS04
05MS05
06M457
06MS06
07X456
07XP07
07XS07
08X408
08X507
09XP09
10X503
10X504
10X668
10XP10
10XS10
11X417
11XP11
11XS11
12X428
12XS12
13K657
13KP13
13KS13
14K923
15K010*
15K418
15KP15
16K959
17K467
17KS17
18K922
18KS18
19K431
19K501
19KS19
20K658
20KP20
21K411
21KP21
22KP22
24Q457
24QP24
25Q467
25QP25
25QS25
26QS26
27Q316*
27Q377*
27Q487
27QP27
27QS27
28QP28
28QS28
29QP29
29QS29
30QP30
31R607
31RP31
31RS31
33K891
79K755
79M331
79M645
79M973
79Q344
79Q950
79Q952
79X695
88KLC1
88KLC1*
88MLC1
88QLC1
88RLC1
88XLC1
Posted by at No comments:
Subscribe to: Comments (Atom)