Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_1", state = "NY" and year = 2018 sorted by hispanic

View and edit SQL

year

  • 2018 · 4,722

grade

  • grade_1 · 4,722
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic ▼ native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2051047 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_1 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2062979 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_1 21.0 2.0                 0.0   13.0 10.0             17     *   23 21 2                 0   13 10         17       23
2063891 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_1 12.0 0.0                 0.0   8.0 4.0             7     *   12 12 0                 0   8 4         7       12
2070047 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 54.0 0.0                 0.0   23.0 31.0     *       35     10   54 54 0                 0   23 31         35   10   54
2070142 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0     0.0     0.0     0.0   0.0 0.0             0     0   0 0 0     0     0     0   0 0         0   0   0
2070161 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003893 151501060003 TICONDEROGA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 41.0 0.0     0.0     0.0     0.0   23.0 18.0             29     9   41 41 0     0     0     0   23 18         29   9   41
2070180 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003894 151501060007 TICONDEROGA MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
2070199 NY Essex   school 3631080 151601040000   WESTPORT 363108004170 151601040001 WESTPORT CENTRAL SCHOOL public Regular School No Other KG 12 2018   grade_1 15.0             0.0     0.0   7.0 8.0     *       6     *   15 15             0     0   7 8         6       15
2070294 NY Franklin   school 3607080 160801040000   CHATEAUGAY 360708000498 160801040002 CHATEAUGAY HIGH SCHOOL public Regular School No High 07 12 2018   grade_1 0.0       0.0     0.0         0.0 0.0             0     0   0 0       0     0         0 0         0   0   0
2070427 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003534 161401060003 SARANAC LAKE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2070446 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2018   grade_1 20.0                       11.0 9.0             9     0   20 20                       11 9         9   0   20
2070579 NY Franklin   school 3605820 161601040000   BRUSHTON MOIRA 360582000293 161601040003 BRUSHTON GRADE SCHOOL public Regular School No Elementary PK 06 2018   grade_1 54.0 0.0           0.0     1.0   33.0 22.0             39     11   55 54 0           0     1   33 22         39   11   55
2071700 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 3.0                       2.0 1.0             *     *   3 3                       2 1                 3
2071928 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_1 60.0                       30.0 30.0             42     6   60 60                       30 30         42   6   60
2071966 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_1 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
2102765 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000244 410401060002 WEST LEYDEN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 22.0                   0.0   7.0 15.0             16     *   22 22                   0   7 15         16       22
2102784 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000243 410401060003 FORESTPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 6.0                       2.0 4.0             *     0   6 6                       2 4             0   6
2103563 NY Oneida   school 3614580 412201060000   HOLLAND PATENT 361458001210 412201060003 HOLLAND PATENT ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2018   grade_1 0.0                       0.0 0.0     *       0     0   0 0                       0 0         0   0   0
2103582 NY Oneida   school 3614580 412201060000   HOLLAND PATENT 361458001208 412201060005 GENERAL WILLIAM FLOYD ELEM SCHOOL public Regular School No Elementary PK 02 2018   grade_1 99.0                       58.0 41.0             43     10   99 99                       58 41         43   10   99
2105254 NY Onondaga   school 3618480 421101060000   MARCELLUS 361848001665 421101060003 MARCELLUS HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0           0.0     0.0   0.0 0.0     *       0     0   0 0 0           0     0   0 0         0   0   0
2107800 NY Orange   school 3604758 441202020000   KIRYAS JOEL 360475804758 441202020001 KIRYAS JOEL VILLAGE SCHOOL public Regular School No Elementary PK KG 2018   grade_1 0.0                       0.0 0.0     0       0     0   0 0                       0 0     0   0   0   0
2109890 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Special Education School No Middle 06 08 2018   grade_1 0.0                       0.0 0.0                   *   0 0                       0 0                 0
2117376 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2018   grade_1 8.0                   1.0   4.0 5.0                   *   9 8                   1   4 5                 9
2120568 NY Saint Lawrence   school 3608100 510501040000   COLTON PIERREPONT 360810000576 510501040001 COLTON-PIERREPONT CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 23.0 0.0           0.0         12.0 11.0             12     *   23 23 0           0         12 11         12       23
2120625 NY Saint Lawrence   school 3613440 511201040000   HAMMOND 361344004511 511201040001 HAMMOND CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 20.0 0.0                     10.0 10.0             11     0   20 20 0                     10 10         11   0   20
2120815 NY Saint Lawrence   school 3619890 512101040000   MORRISTOWN 361989001817 512101040001 MORRISTOWN CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 23.0                   1.0   13.0 11.0             16     *   24 23                   1   13 11         16       24
2120967 NY Saint Lawrence   school 3622440 512501040000   PARISHVL HOPKINTON 362244003157 512501040002 PARISHVILLE-HOPKINTON ELEM SCH public Regular School No Elementary PK 06 2018   grade_1 21.0                       10.0 11.0             13     *   21 21                       10 11         13       21
2120986 NY Saint Lawrence   school 3622440 512501040000   PARISHVL HOPKINTON 362244003158 512501040004 PARISHVILLE-HOPKINTON JR-SR HS public Regular School No High 07 12 2018   grade_1 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
2121062 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 36.0       0.0           1.0   21.0 16.0             28     5   37 36       0           1   21 16         28   5   37
2123361 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Prekindergarten PK PK 2018   grade_1 0.0 0.0                     0.0 0.0             0     0   0 0 0                     0 0         0   0   0
2123646 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2018   grade_1 0.0 0.0                     0.0 0.0             0     *   0 0 0                     0 0         0       0
2123950 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101042 573002040003 WAYLAND-COHOCTON MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_1 0.0 0.0           0.0     0.0   0.0 0.0     *       0     0   0 0 0           0     0   0 0         0   0   0
2133070 NY Washington   school 3613830 641001040000   HARTFORD 361383001129 641001040001 HARTFORD MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2018   grade_1 0.0 0.0           0.0     0.0   0.0 0.0     *       0     0   0 0 0           0     0   0 0         0   0   0
2133203 NY Washington   school 3623970 641401040000   PUTNAM 362397003313 641401040001 PUTNAM CENTRAL SCHOOL public Regular School No Elementary PK 06 2018   grade_1 4.0                       2.0 2.0             *     *   4 4                       2 2                 4
2049546 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049565 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049641 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049660 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049774 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0               0     0   0 0 0 0         0     0   0           0   0   0
2049793 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0     0.0     0       0     0   0 0 0 0   0     0     0     0     0   0   0   0
2049812 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2049888 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_1 35.0 1.0 0.0         6.0     5.0   30.0 17.0     *       8     13   47 35 1 0         6     5   30 17         8   13   47
2049926 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2049945 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2049983 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2050040 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050097 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050116 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2050211 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050268 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050287 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2050306 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2018   grade_1 8.0 8.0 0.0   0.0     16.0     1.0   18.0 15.0     6       6     5   33 8 8 0   0     16     1   18 15     6   6   5   33
2050420 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2018   grade_1 36.0 4.0 0.0   0.0     12.0     10.0   28.0 34.0     5       18     8   62 36 4 0   0     12     10   28 34     5   18   8   62
2050439 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050458 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050553 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050591 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050648 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2050667 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2050705 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050743 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050762 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_1 17.0 0.0 0.0         0.0     0.0   10.0 7.0             *     *   17 17 0 0         0     0   10 7                 17
2050800 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_1 20.0   0.0               0.0   10.0 10.0             15     0   20 20   0               0   10 10         15   0   20
2050819 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_1 15.0   0.0         0.0     0.0   11.0 4.0             12     *   15 15   0         0     0   11 4         12       15
2050838 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 22.0 0.0 0.0               1.0   11.0 12.0             19     5   23 22 0 0               1   11 12         19   5   23
2050857 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 54.0 0.0 0.0   0.0     1.0         28.0 27.0     *       37     6   55 54 0 0   0     1         28 27         37   6   55
2050876 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 15.0 0.0 0.0                   6.0 9.0             6     *   15 15 0 0                   6 9         6       15
2050895 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
2050933 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0               0.0 0.0     *       0     0   0 0 0 0   0               0 0         0   0   0
2050952 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 24.0 0.0 0.0   0.0     0.0     0.0   13.0 11.0             18     6   24 24 0 0   0     0     0   13 11         18   6   24
2050971 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2051009 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No High 06 12 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2051028 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 56.0   0.0   0.0           1.0   33.0 24.0             43     10   57 56   0   0           1   33 24         43   10   57
2051256 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
2051351 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 LAB SCHOOL OF FIN & TECH: X223 public Regular School No High 06 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051370 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051408 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2051427 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051446 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405920 320700010343 ACADEMY OF APPLIED MATH AND TECH public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2051503 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406613 320700010584 KAPPA VII public Regular School No Middle 06 08 2018   grade_1   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
2051522 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No High 06 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051541 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051560 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405761 320700011321 CROTONA ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2018   grade_1 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
2051579 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405873 320700011334 INTERNATIONAL COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051598 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405988 320700011379 JILL CHAIFETZ TRANSFER HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2051617 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406056 320700011381 BRONX HAVEN HIGH SCHOOL public Regular School No High 09 12 2018   grade_1   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
2051636 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405180 320700011427 COMMUNITY SCHOOL-SOCIAL JUSTICE public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
2051655 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405187 320700011473 MOTT HAVEN VILLAGE PREP HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051674 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400749 320700011495 UNIVERSITY HEIGHTS SECONDARY SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051693 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No High 06 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051712 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406253 320700011522 BRONX DESIGN-CONSTRUCTION ACADEMY public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051731 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405189 320700011527 BRONX LEADERSHIP ACAD II HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051750 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405517 320700011547 NEW EXPLORERS HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2051769 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405512 320700011548 CAREERS IN SPORTS HS public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051788 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405504 320700011551 URBAN ASSEMBLY BRONX OF LETTERS public Regular School No High 06 12 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2051807 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406352 320700011557 MOTT HAVEN COMMUNITY HIGH SCHOOL public Regular School No High 10 12 2018   grade_1 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
2051826 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401909 320700011600 ALFRED E SMITH CAREER-TECH HIGH SCH public Career and Technical School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051845 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401338 320700011670 HEALTH OPPORTUNITIES HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051959 NY Bronx   school 3600963 320700860920   UNIVERSITY PREP CHARTER HIGH 360096306039 320700860920 UNIVERSITY PREP CHARTER HIGH SCHOOL charter Regular School Yes High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2051997 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);