enrollments

Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_2", state = "NY" and year = 2018 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 4,722 ✖

grade ✖

  • grade_2 · 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
2050804 2050804 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_2 23.0   0.0               3.0   10.0 16.0             17     *   26 23   0               3   10 16         17       26
2050823 2050823 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_2 19.0   1.0         0.0     1.0   10.0 11.0             14     6   21 19   1         0     1   10 11         14   6   21
2051032 2051032 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 46.0   0.0   0.0           1.0   27.0 20.0             29     7   47 46   0   0           1   27 20         29   7   47
2051051 2051051 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_2 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2059487 2059487 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838004570 30601060004 F P DONNELLY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 46.0   0.0   0.0     0.0     1.0   21.0 26.0     *       23     *   47 46   0   0     0     1   21 26         23       47
2059696 2059696 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 08 2018   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
2060114 2060114 NY Broome   school 3602730 31701060000   WINDSOR 360273000047 31701060003 C R WEEKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 34.0   0.0         1.0     2.0   19.0 18.0             28     *   37 34   0         1     2   19 18         28       37
2060285 2060285 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 59.0   1.0   1.0     0.0     0.0   34.0 27.0             28     5   61 59   1   1     0     0   34 27         28   5   61
2060475 2060475 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239004858 42801060005 GOWANDA MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
2060513 2060513 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 62.0   0.0   1.0           1.0   25.0 39.0             36     *   64 62   0   1           1   25 39         36       64
2060912 2060912 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 53.0   2.0   1.0     0.0     1.0   37.0 20.0     *       21     8   57 53   2   1     0     1   37 20         21   8   57
2060931 2060931 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_2 63.0   1.0         1.0     2.0   35.0 32.0             34     6   67 63   1         1     2   35 32         34   6   67
2060950 2060950 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004435 50401040002 CATO-MERIDIAN MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
2060988 2060988 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2018   grade_2 0.0   0.0   0.0           0.0   0.0 0.0     0       0     0   0 0   0   0           0   0 0     0   0   0   0
2061254 2061254 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000453 60401040003 SINCLAIRVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 46.0   1.0         0.0     1.0   27.0 21.0             38     10   48 46   1         0     1   27 21         38   10   48
2061292 2061292 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801936 60503040001 CHAUTAUQUA LAKE SECONDARY SCHOOL public Regular School No High 07 12 2018   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
2061349 2061349 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003232 60601040003 PINE VALLEY CENTRAL JR-SR HIGH SCH public Regular School No High 07 12 2018   grade_2 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
2061634 2061634 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003665 61501040003 SILVER CREEK ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 54.0   9.0   15.0     0.0     7.0   36.0 49.0     *       60     14   85 54   9   15     0     7   36 49         60   14   85
2061691 2061691 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2018   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2061976 2061976 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000289 62301040003 BROCTON MIDDLE HIGH SCHOOL public Regular School No High 06 12 2018   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2062014 2062014 NY Chautauqua   school 3626730 62601040000   SHERMAN 362673004940 62601040002 SHERMAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 29.0   0.0   0.0     1.0         15.0 15.0     *       20     5   30 29   0   0     1         15 15         20   5   30
2063135 2063135 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 52.0   0.0   0.0               25.0 27.0             27     16   52 52   0   0               25 27         27   16   52
2063154 2063154 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
2063211 2063211 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126004489 90901040001 NORTHERN ADIRONDACK ELEMENTARY SCH public Regular School No Elementary PK 05 2018   grade_2 67.0   0.0   0.0     2.0         35.0 34.0             39     9   69 67   0   0     2         35 34         39   9   69
2063382 2063382 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 56.0   0.0               1.0   29.0 28.0             26     *   57 56   0               1   29 28         26       57
2063553 2063553 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2063819 2063819 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_2 28.0   0.0               0.0   15.0 13.0             16     *   28 28   0               0   15 13         16       28
2063838 2063838 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No High 09 12 2018   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2063857 2063857 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2064009 2064009 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 37.0   1.0               3.0   23.0 18.0     *       30     7   41 37   1               3   23 18         30   7   41
2064256 2064256 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000680 120501040001 DELAWARE ACADEMY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 53.0   0.0         0.0     1.0   33.0 21.0     *       24     *   54 53   0         0     1   33 21         24       54
2064408 2064408 NY Delaware   school 3626850 121601060000   SIDNEY 362685003664 121601060005 SIDNEY MIDDLE SCHOOL public Regular School No Elementary KG 08 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
2064959 2064959 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2018   grade_2 56.0   10.0         1.0     5.0   35.0 37.0     6       35     10   72 56   10         1     5   35 37     6   35   10   72
2064997 2064997 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No Elementary PK 01 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     0       0     0   0 0   0         0     0   0 0     0   0   0   0
2068341 2068341 NY Erie   school 3607590 140801060000   CLARENCE 360759000541 140801060007 CLARENCE CTR ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 58.0   3.0   0.0     0.0     2.0   35.0 28.0             9     8   63 58   3   0     0     2   35 28         9   8   63
2068398 2068398 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001062 141101060002 COLDEN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 27.0   1.0   0.0           1.0   16.0 13.0             13     *   29 27   1   0           1   16 13         13       29
2068436 2068436 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001065 141101060004 GRIFFITH INST MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2068550 2068550 NY Erie   school 3615360 141301060000   IROQUOIS 361536001296 141301060004 WALES PRIMARY SCHOOL public Regular School No Elementary KG 04 2018   grade_2 34.0   1.0         0.0     2.0   24.0 13.0             *     5   37 34   1         0     2   24 13             5   37
2068607 2068607 NY Erie   school 3615360 141301060000   IROQUOIS 361536004796 141301060007 ELMA PRIMARY SCHOOL public Regular School No Elementary KG 04 2018   grade_2 55.0   1.0         1.0     1.0   32.0 26.0             9     *   58 55   1         1     1   32 26         9       58
2068835 2068835 NY Erie   school 3613350 141601060000   HAMBURG 361335001096 141601060002 BOSTON VALLEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 29.0   2.0         2.0     0.0   17.0 16.0     *       9     8   33 29   2         2     0   17 16         9   8   33
2069386 2069386 NY Erie   school 3620970 142201040000   NORTH COLLINS 362097002977 142201040002 NORTH COLLINS ELEMENTARY SCHOOL public Regular School No Other PK 09 2018   grade_2 28.0   1.0   1.0     1.0     1.0   14.0 18.0     *       17     *   32 28   1   1     1     1   14 18         17       32
2069500 2069500 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190003109 142301060007 ELLICOTT ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 92.0   0.0         0.0     2.0   41.0 53.0     *       6     10   94 92   0         0     2   41 53         6   10   94
2069956 2069956 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 23.0   0.0         0.0         8.0 15.0             18     5   23 23   0         0         8 15         18   5   23
2070013 2070013 NY Essex   school 3619530 150801040000   MINERVA 361953001782 150801040001 MINERVA CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 6.0   1.0         0.0     0.0   4.0 3.0             *     *   7 6   1         0     0   4 3                 7
2070070 2070070 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 4.0   0.0         0.0         0.0 4.0             *     0   4 4   0         0         0 4             0   4
2070203 2070203 NY Essex   school 3631080 151601040000   WESTPORT 363108004170 151601040001 WESTPORT CENTRAL SCHOOL public Regular School No Other KG 12 2018   grade_2 15.0             0.0     0.0   6.0 9.0     *       6     *   15 15             0     0   6 9         6       15
2070222 2070222 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 19.0   0.0   0.0           2.0   13.0 8.0             12     *   21 19   0   0           2   13 8         12       21
2070279 2070279 NY Franklin   school 3607080 160801040000   CHATEAUGAY 360708000499 160801040001 CHATEAUGAY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 37.0   0.0                   19.0 18.0             19     8   37 37   0                   19 18         19   8   37
2070298 2070298 NY Franklin   school 3607080 160801040000   CHATEAUGAY 360708000498 160801040002 CHATEAUGAY HIGH SCHOOL public Regular School No High 07 12 2018   grade_2 0.0       0.0     0.0         0.0 0.0             0     0   0 0       0     0         0 0         0   0   0
2070317 2070317 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003525 161201040001 ST REGIS MOHAWK SCHOOL public Regular School No Elementary PK 06 2018   grade_2 1.0   0.0   49.0           5.0   27.0 28.0             46     *   55 1   0   49           5   27 28         46       55
2070336 2070336 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003524 161201040002 SALMON RIVER HIGH SCHOOL public Regular School No High 09 12 2018   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
2070355 2070355 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003522 161201040003 SALMON RIVER ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 32.0   4.0   9.0           6.0   26.0 25.0             37     *   51 32   4   9           6   26 25         37       51
2070450 2070450 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2018   grade_2 21.0                       8.0 13.0             8     0   21 21                       8 13         8   0   21
2070469 2070469 NY Franklin   school 3618180 161501060000   MALONE 361818001634 161501060006 FLANDERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 39.0   3.0   1.0           1.0   24.0 20.0             27     8   44 39   3   1           1   24 20         27   8   44
2070545 2070545 NY Franklin   school 3618180 161501060000   MALONE 361818001639 161501060016 ST JOSEPH'S ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 39.0   0.0   0.0     0.0     0.0   26.0 13.0             24     *   39 39   0   0     0     0   26 13         24       39
2070602 2070602 NY Franklin   school 3627990 161801040000   ST REGIS FALLS 362799003793 161801040001 ST REGIS FALLS CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 16.0   0.0   0.0           1.0   10.0 7.0     *       11     *   17 16   0   0           1   10 7         11       17
2070621 2070621 NY Fulton   school 3631200 170301020000   WHEELERVILLE 363120004173 170301020001 WHEELERVILLE SCHOOL public Regular School No Elementary PK 08 2018   grade_2 7.0   1.0         0.0     0.0   4.0 4.0             6     0   8 7   1         0     0   4 4         6   0   8
2070868 2070868 NY Fulton   school 3621300 170901040000   NORTHVILLE 362130003038 170901040001 NORTHVILLE HIGH SCHOOL public Regular School No High 06 12 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
2071134 2071134 NY Genesee   school 3610380 180901040000   ELBA 361038000801 180901040001 ELBA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 21.0   2.0               0.0   13.0 10.0     *       13     *   23 21   2               0   13 10         13       23
2071590 2071590 NY Greene   school 3615060 190901040000   HUNTER TANNERSVL 361506001259 190901040001 HUNTER-TANNERSVILLE MIDDLE/HIGH SCH public Regular School No High 07 12 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
2071666 2071666 NY Hamilton   school 3615330 200501080000   INLET 361533001291 200501080001 INLET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 2.0   0.0         0.0         0.0 2.0             *     *   2 2   0         0         0 2                 2
2071704 2071704 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 6.0                       4.0 2.0             *     0   6 6                       4 2             0   6
2071761 2071761 NY Herkimer   school 3630600 210302040000   WEST CANADA VALLEY 363060004108 210302040005 WEST CANADA VALLEY ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_2 49.0   0.0               2.0   19.0 32.0     *       24     6   51 49   0               2   19 32         24   6   51
2071932 2071932 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_2 51.0                       24.0 27.0             28     *   51 51                       24 27         28       51
2071951 2071951 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No High 09 12 2018   grade_2 0.0   0.0                   0.0 0.0     *       0     0   0 0   0                   0 0         0   0   0
2071970 2071970 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_2 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
2072008 2072008 NY Herkimer   school 3623370 211103040000   POLAND 362337004799 211103040003 POLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 35.0   2.0               0.0   20.0 17.0     *       26     5   37 35   2               0   20 17         26   5   37
2072103 2072103 NY Herkimer   school 3630930 212001040000   MOUNT MARKHAM 363093004155 212001040005 MT MARKHAM MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
2072236 2072236 NY Jefferson   school 3602340 220101040000   SOUTH JEFFERSON 360234000004 220101040004 MANNSVILLE MANOR ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 43.0   1.0         0.0     1.0   24.0 21.0             24     9   45 43   1         0     1   24 21         24   9   45
2072521 2072521 NY Jefferson   school 3607650 220701040000   THOUSAND ISLANDS 360765000547 220701040001 GUARDINO ELEMENTARY SCHOOL public Regular School No Elementary KG 07 2018   grade_2 43.0   2.0         1.0     1.0   29.0 18.0             20     *   47 43   2         1     1   29 18         20       47
2072540 2072540 NY Jefferson   school 3607650 220701040000   THOUSAND ISLANDS 360765000546 220701040002 CAPE VINCENT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 13.0   3.0   0.0           0.0   7.0 9.0             12     *   16 13   3   0           0   7 9         12       16
2080102 2080102 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015106199 332000010310 SCHOOL FOR FUTURE LEADERS (THE) public Regular School No Elementary KG 05 2018   grade_2 4.0   4.0         50.0         34.0 24.0     37       57     7   58 4   4         50         34 24     37   57   7   58
2083351 2083351 NY Lewis   school 3613770 230301040000   HARRISVILLE 361377001127 230301040001 HARRISVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 07 2018   grade_2 18.0   0.0   1.0           1.0   10.0 10.0             12     *   20 18   0   1           1   10 10         12       20
2083503 2083503 NY Lewis   school 3627360 231101040000   SOUTH LEWIS 362736003734 231101040008 PORT LEYDEN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_2 39.0   0.0               0.0   19.0 20.0             23     5   39 39   0               0   19 20         23   5   39
2083883 2083883 NY Livingston   school 3621450 241101040000   DALTON-NUNDA 362145003293 241101040001 DALTON-NUNDA INTERMEDIATE SCHOOL public Regular School No Middle 04 07 2018   grade_2 0.0   0.0               0.0   0.0 0.0     *       0     0   0 0   0               0   0 0         0   0   0
2083902 2083902 NY Livingston   school 3621450 241101040000   DALTON-NUNDA 362145003046 241101040002 DALTON-NUNDA PRIMARY SCHOOL public Regular School No Elementary PK 03 2018   grade_2 56.0   1.0               0.0   38.0 19.0             26     *   57 56   1               0   38 19         26       57
2084073 2084073 NY Madison   school 3608850 250301040000   DERUYTER 360885004585 250301040002 DERUYTER ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 28.0   1.0   0.0           0.0   15.0 14.0     *       18     *   29 28   1   0           0   15 14         18       29
2084168 2084168 NY Madison   school 3606390 250901060000   CANASTOTA 360639000420 250901060003 PETERBORO STREET ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
2084377 2084377 NY Madison   school 3628140 251501040000   STOCKBRIDGE VALLEY 362814003801 251501040001 STOCKBRIDGE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 25.0   0.0   0.0           0.0   13.0 12.0             14     *   25 25   0   0           0   13 12         14       25
2084396 2084396 NY Madison   school 3607470 251601060000   CHITTENANGO 360747000530 251601060001 BRIDGEPORT ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_2 36.0   3.0   0.0           2.0   22.0 19.0             25     7   41 36   3   0           2   22 19         25   7   41
2092091 2092091 NY Nassau   school 3623580 280404030000   PORT WASHINGTON 362358003292 280404030007 JOHN PHILIP SOUSA ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 53.0   11.0         9.0     3.0   39.0 37.0     5       9     13   76 53   11         9     3   39 37     5   9   13   76
2092205 2092205 NY Nassau   school 3620400 280405020000   NEW HYDE PARK 362040001884 280405020004 MANOR OAKS WILLIAM BOWIE SCHOOL public Regular School No Elementary KG 06 2018   grade_2 12.0   8.0   0.0     16.0     0.0   17.0 19.0     *       5     *   36 12   8   0     16     0   17 19         5       36
2092471 2092471 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 09 12 2018   grade_2 0.0   0.0         0.0         0.0 0.0             0     0   0 0   0         0         0 0         0   0   0
2092737 2092737 NY Nassau   school 3626370 280501060000   NORTH SHORE 362637003611 280501060001 GLEN HEAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 38.0   9.0   0.0     5.0     5.0   35.0 22.0     *       7     8   57 38   9   0     5     5   35 22         7   8   57
2092775 2092775 NY Nassau   school 3626370 280501060000   NORTH SHORE 362637003615 280501060003 SEA CLIFF ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 47.0   12.0         0.0     2.0   25.0 36.0     *       9     8   61 47   12         0     2   25 36         9   8   61
2092851 2092851 NY Nassau   school 3628560 280502060000   SYOSSET 362856003835 280502060002 WILLITS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 27.0   1.0         16.0     0.0   25.0 19.0     *       0     *   44 27   1         16     0   25 19         0       44
2092870 2092870 NY Nassau   school 3628560 280502060000   SYOSSET 362856003837 280502060003 BERRY HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 37.0   1.0         11.0     1.0   29.0 21.0     0       0     *   50 37   1         11     1   29 21     0   0       50
2092889 2092889 NY Nassau   school 3628560 280502060000   SYOSSET 362856003836 280502060004 BAYLIS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 39.0   1.0         29.0     1.0   41.0 29.0     6       8     6   70 39   1         29     1   41 29     6   8   6   70
2093098 2093098 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322004381 280504060001 PASADENA ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_2 51.0   3.0   1.0     20.0     0.0   41.0 34.0     *       9     6   75 51   3   1     20     0   41 34         9   6   75
2093136 2093136 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003250 280504060006 H B MATTLIN MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
2093174 2093174 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003253 280504060012 OLD BETHPAGE SCHOOL public Regular School No Elementary KG 04 2018   grade_2 49.0   8.0         11.0     3.0   41.0 30.0     0       *     *   71 49   8         11     3   41 30     0           71
2093573 2093573 NY Nassau   school 3623190 280518030000   PLAINEDGE 362319003245 280518030002 EASTPLAIN SCHOOL public Regular School No Elementary KG 05 2018   grade_2 46.0   2.0         1.0         22.0 27.0     *       *     *   49 46   2         1         22 27                 49
2093687 2093687 NY Nassau   school 3604740 280521030000   BETHPAGE 360474000221 280521030004 KRAMER LANE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 50.0   7.0         6.0     1.0   38.0 26.0     *       *     *   64 50   7         6     1   38 26                 64
2093725 2093725 NY Nassau   school 3604740 280521030000   BETHPAGE 360474000220 280521030008 JOHN F KENNEDY MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     0       0     0   0 0   0         0     0   0 0     0   0   0   0
2093915 2093915 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863001687 280523030006 LOCKHART ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 56.0   7.0         1.0     2.0   36.0 30.0             9     5   66 56   7         1     2   36 30         9   5   66
2096100 2096100 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No Elementary PK 05 2018   grade_2 2.0   3.0         104.0     4.0   62.0 51.0     46       63     17   113 2   3         104     4   62 51     46   63   17   113
2101363 2101363 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No Middle 06 08 2018   grade_2     0.0                   0.0 0.0     0       0     *   0     0                   0 0     0   0       0
2101648 2101648 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008301265 310600011552 GREGORIO LUPERON HS-SCI & MATH public Regular School No High 09 12 2018   grade_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
2101819 2101819 NY Niagara   school 3617190 400301060000   LEWISTON PORTER 361719004833 400301060003 INTERMEDIATE EDUCATION CENTER public Regular School No Elementary 03 05 2018   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
2102009 2102009 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2018   grade_2 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]);