ScraperWiki Classic is now read-only.

But don’t worry! You can transfer this scraper to Morph.io if you want to continue editing it.

Transfer to Morph.io

Current status

Idle – next run ASAP

Last run

2 months ago

No pages scraped

About this scraper

Made this at the #jdcny event at Columbia.

Scrapes school budgets from the NYC Department of Ed site, see for example http://schools.nyc.gov/AboutUs/funding/schoolbudgets/GalaxyAllocationFY2010.htm?BSSS_INPUT=M411

Tricky thing is the markup changed slightly each year… and getting a list of school IDs.

Thanks to Julian Todd for making category part of the row key, this gives a more useful table with tons of rows and not so many columns.

Needs more work to categorize the categories into "major" categories (there are thousands of categories)

Address: Tweed Courthouse, 52 Chambers Street, New York, NY 10007, USA

This scraper is public

Anyone can see this scraper, and any registered user can edit it.

Users who have contributed to this scraper:

category val majorcategory fiscal_year school_name school_id dollars
TL NYSTL Library Books 1,197 tl 2012 PS 015 ROBERTO CLEMENTE M015 1197
TL NYSTL Textbooks 22,462 tl 2012 PS 020 ANNA SILVER M020 22462
TL NYSTL TEXTBOOKS 3,895 tl 2012 PS 063 WILLIAM MCKINLEY M063 3895
TL NYSTL SOFTWARE 4,088 tl 2012 PS 110 FLORENCE NIGHTING M110 4088
TL SBST SHARED TBD tl 2012 PS 110 FLORENCE NIGHTING M110 None
IDEA SBST Shared 47,173 unknown 2012 PS 134 HENRIETTA SZOLD M134 47173
TL NYSTL TEXTBOOKS 15,875 tl 2012 PS 184 M184 15875
TL Potential Mid Year Adj to be Repaid 10,964 tl 2012 PS 188 JOHN BURROUGHS M188 10964
TL NYSTL Library Books 1,863 tl 2012 NEIGHBORHOOD SCHL @ PS 63 M363 1863
TL NYSTL LIBRARY BOOKS 1,974 tl 2012 THE EARTH SCHOOL M364 1974
TL NYSTL Textbooks 18,620 tl 2012 THE EARTH SCHOOL M364 18620
TL NYSTL TEXTBOOKS 8,051 tl 2012 SCHOOL FOR GLOBAL LEADERS M378 8051
TL NYSTL TEXTBOOKS HS 20,406 tl 2012 UNIV. NEIGHBORHOOD HS M448 20406
TL IEP Teacher HS 69,578 tl 2012 CMSP-MARTE VALLE SEC. SCH M509 69578
Contract For Excellence FY 09 58,645 unknown 2012 WILLIAM T. HARRIS M011 58645
TL NYSTL TEXTBOOKS 11,586 tl 2012 CHELSEA SCHOOL M033 11586
TL NYSTL SOFTWARE 3,281 tl 2012 ELIAS HOWE M051 3281
TL NYSTL Textbooks 11,889 tl 2012 BEEKMAN HILL INTERNATIONA M059 11889
TL NYSTL Textbooks 28,413 tl 2012 PS 89 M089 28413
TL NYSTL TEXTBOOKS 61,382 tl 2012 JHS 104 SIMON BARUCH M104 61382
TL Attendance Shared 64,786 tl 2012 PS 116 MARY LINDLEY MURR M116 64786
TL NYSTL Textbooks 44,003 tl 2012 PS 116 MARY LINDLEY MURR M116 44003
TL NYSTL TEXTBOOKS 39,267 tl 2012 PS 124 YUNG WING M124 39267
TL NYSTL Library Books 4,516 tl 2012 PS 126 JACOB AUGUST RIIS M126 4516
IDEA SBST Shared 42,286 unknown 2012 PS 126 JACOB AUGUST RIIS M126 42286
TL NYSTL Textbooks 16,900 tl 2012 PS 126 JACOB AUGUST RIIS M126 16900
TL NYSTL Library Books 1,030 tl 2012 PS 150 M150 1030
TL NYSTL TEXTBOOKS 19,245 tl 2012 MIDTOWN WEST M212 19245
TL IEP PARA 55,897 tl 2012 IS 217 M217 55897
TL NYSTL Library Books 2,357 tl 2012 IS 217 M217 2357
TL Potential Mid Year Adj to be Repaid 35,567 tl 2012 PS 234 INDEPENDENCE SCHOO M234 35567
TL SECTION 504 TBD tl 2012 PS 234 INDEPENDENCE SCHOO M234 None
TL IEP Para 42,882 tl 2012 FOOD AND FINANCE M288 42882
TL NYSTL Textbooks HS 22,035 tl 2012 HS OF HOSPITALITY MGMT M296 22035
TL IEP PARA 64,908 tl 2012 U.A ACADEMY OF GOV and LA M305 64908
TL IEP Para 67,681 tl 2012 HS FOR ENVIRONMENTAL STUD M400 67681
TL NYSTL TEXTBOOKS HS 24,541 tl 2012 BARUCH COLLEGE CAMPUS HS M411 24541
TL NYSTL Textbooks HS 27,000 tl 2012 NYC Lab High School M412 27000
TL NYSTL TEXTBOOKS HS 20,116 tl 2012 LANDMARK HIGH SCHOOL M419 20116
TL NYSTL Textbooks HS 94,919 tl 2012 HEALTH PROF and HUMAN SVCS M420 94919
TL NYSTL TEXTBOOKS HS 11,274 tl 2012 Bayard Rustin Educational Complex M440 11274
TL ATTENDANCE SHARED 84,054 tl 2012 CITY AS SCHOOL M560 84054
TL NYSTL Textbooks HS 38,320 tl 2012 CITY AS SCHOOL M560 38320
TL NYSTL Textbooks HS 43,275 tl 2012 HS OF ECONOMICS and FINAN M489 43275
TL NYSTL TEXTBOOKS HS 11,787 tl 2012 REPERTORY SCHOOL M531 11787
TL SBST Shared 82,348 tl 2012 MANHATTAN BRIDGES HIGH SCHOOL M542 82348
IDEA IEP PARA 45,928 unknown 2012 NEW DESIGN HIGH SCHOOL M543 45928
TL ASA for AA 16,449 tl 2012 LIBERTY HS ACADEMY M550 16449
TL Potential Mid Year Adj to be Repaid 9 tl 2012 URBAN ACADEMY LAB HIGH SC M565 9
TL NYSTL TEXTBOOKS HS 97,025 tl 2012 HS FOR FASHION INDUSTRIES M600 97025
TL NYSTL Textbooks HS 68,100 tl 2012 HS OF ART AND DESIGN M630 68100
Private Grant 36 37,485 private 2012 PS 009 SARAH ANDERSON M009 37485
OASAS Sub Abuse 73,334 unknown 2012 PS 076 A. PHILIP RANDOLP M076 73334
TL NYSTL TEXTBOOKS 18,289 tl 2012 PS 199 JESSIE I. STRAUS M199 18289
TL ASA for AA 37,000 tl 2012 Manhattan Theatre Lab HS M283 37000
TL NYSTL TEXTBOOKS HS 16,513 tl 2012 Urban Assembly School M402 16513
21ST CENTURY 61 37,722 unknown 2012 WADLEIGH ARTS HIGH SCHOOL M415 37722
21st Century 61 26,841 unknown 2012 LOUIS D. BRANDEIS HS M470 26841
TL ASA for AA 61,884 tl 2012 PS 7 Samuel Stern M007 61884
TL NYSTL Textbooks 9,019 tl 2012 PS 83 Luis Munoz Rivera M083 9019
TL ASA for AA 10,000 tl 2012 PS 112 JOSE CELSO BARBOS M112 10000
TL Potential Mid Year Adj to be Repaid 4,402 tl 2012 PS 155 William Paca M155 4402
Contract For Excellence FY 09 132,834 unknown 2012 THE BILINGUAL BICULTURAL M182 132834
PRIVATE GRANT 36 TBD private 2012 MOSIAC PREPARATORY ACADEM M375 None
TL ASA for AA 24,493 tl 2012 MOSIAC PREPARATORY ACADEM M375 24493
TL Potential Mid Year Adj to be Repaid 6,296 tl 2012 GLOBAL NEIGHBORHOOD SECON M381 6296
TL LONG TERM ABSENCE TBD tl 2012 GLOBAL NEIGHBORHOOD SECON M381 None
TL NYSTL TEXTBOOKS 4,419 tl 2012 Global Technology Prep. M406 4419
TL SBST SHARED 42,309 tl 2012 ISAAC NEWTON JHS FOR SCI M825 42309
21ST CENTURY 62 50,670 unknown 2012 PS 046 ARTHUR TAPPAN M046 50670
TL NYSTL Library Books 1,222 tl 2012 PS 125 RALPH BUNCHE M125 1222
TL NYSTL Textbooks 3,804 tl 2012 PS 125 RALPH BUNCHE M125 3804
TL NYSTL TEXTBOOKS 6,400 tl 2012 PS 133 FRED R MOORE M133 6400
TL NYSTL Textbooks 21,911 tl 2012 PS 161 PEDRO ALBIZU CAMP M161 21911
21st Century 63 45,053 unknown 2012 JHS 052 INWOOD M052 45053
TL NYSTL Textbooks 14,349 tl 2012 PS 098M Shorackappock M098 14349
TL NYSTL TEXTBOOKS 14,941 tl 2012 PS 128 AUDUBON M128 14941
TL NYSTL Hardware 7,346 tl 2012 PS 173 M173 7346
TL SBST Shared 14,235 tl 2012 AMISTAD M311 14235
TL NYSTL Textbooks 10,568 tl 2012 AMISTAD M311 10568
TL NYSTL TEXTBOOKS 18,293 tl 2012 NEW SCHOOL 2 @ JHS 164 M328 18293
TL NYSTL Textbooks 7,243 tl 2012 Washington Heights Acad. M366 7243
TL LONG TERM ABSENCE 4,029 tl 2012 Hamilton Heights School M368 4029
TL Potential Mid Year Adj to be Repaid 3,746 tl 2012 H.S. MEDIA and COMMUNICAT M463 3746
21ST CENTURY 63 36,900 unknown 2012 Bea Fuller Rodgers, 528M M528 36900
21st Century 63 47,750 unknown 2012 GREGORIO LUPERON HS SCI and M552 47750
TL NYSTL TEXTBOOKS 6,924 tl 2012 PS 025 BILINGUAL SCHOOL X025 6924
TL NYSTL LIBRARY BOOKS 2,653 tl 2012 PS 043 JONAS BRONCK X043 2653
TL SECTION 504 30,799 tl 2012 PS 043 JONAS BRONCK X043 30799
TL SALARY SUBSIDY 2017 18,722 tl 2012 PS 179 INT'L CULTURES X179 18722
TL Potential Mid Year Adj to be Repaid 17,954 tl 2012 07X203 X203 17954
TL NYSTL Library Books 3,017 tl 2012 MS 223 X223 3017
21ST CENTURY 64 37,190 unknown 2012 MS 224 X224 37190
TL NYSTL Hardware 5,832 tl 2012 PS 277 CHILDREN'S LIT. X277 5832
TL NYSTL TEXTBOOKS 17,102 tl 2012 SBx Acad - Applied Media X296 17102
TL NYSTL SOFTWARE 2,545 tl 2012 Acad of Public Relations X298 2545
21st Century 64 27,561 unknown 2012 ACADEMY OF APPLIED MATHEM X343 27561
TL Potential Mid Year Adj to be Repaid 5,269 tl 2012 Bronx Haven High School X381 5269
TL IEP Para 179,064 tl 2012 SAMUEL GOMPERS VHS X655 179064
TL NYSTL LIBRARY BOOKS 2,906 tl 2012 PS 130 X130 2906

Tags:

January 2014
Permalink Hide details Show details 1390118975.309032_48fc023b-9635-4be1-8c60-cc26161492cb 08:10, 19 January 2014 1390118975.158809_4ac6b6a6-9adf-4ecf-8bce-a6867e146785 08:09, 19 January 2014
Run succeeded: - ran 2 times, most recently for 0 seconds (0 scraped pages, 0 records) 08:10, 19 January 2014

Loading...


          
December 2013
Permalink Hide details Show details 1387084556.635969_093b2668-bd14-4255-9fe9-65f27cc416cf 05:33, 15 December 2013
Currently running: - started 3 months, 1 week ago (so far 50 scraped pages, 41 records) 05:33, 15 December 2013

Loading...


          
November 2013
Permalink Hide details Show details 1384397265.310953_41e01bf4-edee-40de-9770-3c29519b3746 02:51, 14 November 2013
Run succeeded: - ran 1 time, most recently for 8639 seconds (1700 scraped pages, 1557 records) 02:51, 14 November 2013

Loading...


          
October 2013
Permalink Hide details Show details 1381715238.291364_b826f43f-2027-42d3-92dc-6a6808e94f91 02:47, 14 October 2013
Run succeeded: - ran 1 time, most recently for 0 seconds (0 scraped pages, 0 records) 02:47, 14 October 2013

Loading...


          
September 2013
Permalink Hide details Show details 1379036808.120258_28249fb6-610b-4537-8bdf-cc134d132746 02:46, 13 September 2013
Run succeeded: - ran 1 time, most recently for 0 seconds (0 scraped pages, 0 records) 02:46, 13 September 2013

Loading...


          
August 2013
Permalink Hide details Show details 1376347878.733335_8089e5c4-b5db-40e6-87a9-af84286521a0 23:59, 12 August 2013
Run succeeded: - ran 1 time, most recently for 10002 seconds (1720 scraped pages, 1584 records) 23:59, 12 August 2013

Loading...


          
July 2013
Permalink Hide details Show details 1373570998.395514_de3e8bc5-5c1d-4143-99e6-3655dcdb5b1b 20:40, 11 July 2013
Run succeeded: - ran 1 time, most recently for 12842 seconds (1717 scraped pages, 1578 records) 20:40, 11 July 2013

Loading...


          
May 2013
Permalink Hide details Show details 1367536420.997031_64f83682-cec2-467f-82d9-08ef653a674b 00:18, 3 May 2013
Currently running: - started 10 months, 3 weeks ago (so far 6 scraped pages, 0 records) 00:18, 3 May 2013

Loading...


          
March 2013
Permalink Hide details Show details 1364430110.630376_3212000e-6104-4253-97e8-803194040476 00:30, 28 March 2013
Run succeeded: - ran 1 time, most recently for 10022 seconds (1719 scraped pages, 1585 records) 00:30, 28 March 2013

Loading...


          
February 2012
Hide changes Show changes 9 20:41, 3 February 2012 8 8 20:36, 3 February 2012 7 7 20:34, 3 February 2012 6 6 20:33, 3 February 2012 5 5 20:33, 3 February 2012 4 4 20:32, 3 February 2012 3 3 20:30, 3 February 2012 2 2 20:27, 3 February 2012 1 1 20:27, 3 February 2012 0
Edited by Paul Winkler 9 times 20:41, 3 February 2012

Loading...

Difference between, revision and previous revision


            
Hide first version Show first version 0 20:24, 3 February 2012
Edited by Paul Winkler 20:24, 3 February 2012

Loading...

Difference between, revision and previous revision