enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

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
14534 14534 PA Armstrong 42005 school 4202590 128030852 SD Armstrong SD 420259000569 569 Dayton El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         22.0 17.0                       39.0                         22 17                 39
14535 14535 PA Armstrong 42005 school 4202590 128030852 SD Armstrong SD 420259006574 6574 Elderton El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         14.0 20.0                       34.0                         14 20                 34
14536 14536 PA Armstrong 42005 school 4202590 128030852 SD Armstrong SD 420259005002 5002 Lenape El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         44.0 43.0                       87.0                         44 43                 87
14537 14537 PA Armstrong 42005 school 4202590 128030852 SD Armstrong SD 420259006577 6577 Shannock Valley El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         26.0 13.0                       39.0                         26 13                 39
14538 14538 PA Armstrong 42005 school 4202590 128030852 SD Armstrong SD 420259000959 7896 West Hills Intermediate Sch   Regular School No Middle 04 06 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14539 14539 PA Armstrong 42005 school 4202590 128030852 SD Armstrong SD 420259000945 7895 West Hills Primary Sch   Regular School No Elementary KG 03 2021 1-Oct grade_1                         60.0 72.0                       132.0                         60 72                 132
14540 14540 PA Armstrong 42005 school 4202590 128030852 SD Armstrong SD 420259000517 7640 West Shamokin JSHS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14541 14541 PA Lehigh 42077 school 4200860 121395927 CS Arts Academy CS 420086007470 8214 Arts Academy CS   Regular School Yes Middle 05 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14542 14542 PA Lehigh 42077 school 4200883 121399898 CS Arts Academy Elementary CS 420088307561 8336 Arts Academy Elementary CS   Regular School Yes Elementary KG 05 2021 1-Oct grade_1                         35.0 34.0                       69.0                         35 34                 69
14543 14543 PA Bradford 42015 school 4202670 117080503 SD Athens Area SD 420267000958 958 Athens Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14544 14544 PA Bradford 42015 school 4202670 117080503 SD Athens Area SD 420267000626 4918 Audrielle Lynch-Ellen Bustin El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         41.0 43.0                       84.0                         41 43                 84
14545 14545 PA Bradford 42015 school 4202670 117080503 SD Athens Area SD 420267007466 8220 Harlan Rowe MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14546 14546 PA Bradford 42015 school 4202670 117080503 SD Athens Area SD 420267007453 8219 SRU El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         31.0 31.0                       62.0                         31 31                 62
14547 14547 PA Potter 42105 school 4202700 109530304 SD Austin Area SD 420270006221 6221 Austin Area El Sch   Regular School No Elementary PK 06 2021 1-Oct grade_1                         8.0 4.0                       12.0                         8 4                 12
14548 14548 PA Potter 42105 school 4202700 109530304 SD Austin Area SD 420270006222 6222 Austin Area JSHS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14549 14549 PA Washington 42125 school 4202760 101630504 SD Avella Area SD 420276004165 4165 Avella Area JSHS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14550 14550 PA Washington 42125 school   101630504 SD Avella Area SD   9999 Avella Area SD             2021 1-Oct grade_1                           0.0                       0.0                           0                 0
14551 14551 PA Washington 42125 school 4202760 101630504 SD Avella Area SD 420276007118 7098 Avella El Center   Regular School No Elementary KG 06 2021 1-Oct grade_1                         16.0 11.0                       27.0                         16 11                 27
14552 14552 PA Chester 42029 school   124150003 CS Avon Grove CS   9999 Avon Grove CS             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14553 14553 PA Chester 42029 school 4200101 124150003 CS Avon Grove CS 420010100656 7721 Avon Grove CS   Regular School Yes Other KG 12 2021 1-Oct grade_1                         82.0 92.0                       174.0                         82 92                 174
14554 14554 PA Chester 42029 school 4202790 124150503 SD Avon Grove SD 420279001367 1367 Avon Grove HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14555 14555 PA Chester 42029 school 4202790 124150503 SD Avon Grove SD 420279001365 1365 Avon Grove Intrmd Sch   Regular School No Elementary 03 06 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14556 14556 PA Chester 42029 school   124150503 SD Avon Grove SD   9999 Avon Grove SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14557 14557 PA Chester 42029 school 4202790 124150503 SD Avon Grove SD 420279005216 5216 Fred S Engle MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14558 14558 PA Chester 42029 school 4202790 124150503 SD Avon Grove SD 420279010008 7323 Penn London El Sch   Regular School No Elementary KG 02 2021 1-Oct grade_1                         167.0 172.0                       339.0                         167 172                 339
14559 14559 PA Allegheny 42003 school 4202820 103020753 SD Avonworth SD 420282000034 34 Avonworth El Sch   Regular School No Elementary 03 06 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14560 14560 PA Allegheny 42003 school 4202820 103020753 SD Avonworth SD 420282005199 5199 Avonworth HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14561 14561 PA Allegheny 42003 school 4202820 103020753 SD Avonworth SD 420282000559 7669 Avonworth MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14562 14562 PA Allegheny 42003 school 4202820 103020753 SD Avonworth SD 420282007520 8320 Avonworth Primary Center   Regular School No Elementary KG 02 2021 1-Oct grade_1                         88.0 73.0                       161.0                         88 73                 161
14563 14563 PA Lycoming 42081 school   117000000 IU BLaST IU 17   0 BLaST IU 17             2021 1-Oct grade_1                         16.0 5.0                       21.0                         16 5                 21
14564 14564 PA Beaver 42007 school 4200861 127046517 CS Baden Academy CS 420086107428 8211 Baden Academy CS   Regular School Yes Elementary KG 06 2021 1-Oct grade_1                         39.0 44.0                       83.0                         39 44                 83
14565 14565 PA Centre 42027 school 4202910 110141003 SD Bald Eagle Area SD 420291001335 1335 Bald Eagle Area JSHS   Regular School No High 06 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14566 14566 PA Centre 42027 school   110141003 SD Bald Eagle Area SD   9999 Bald Eagle Area SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14567 14567 PA Centre 42027 school 4202910 110141003 SD Bald Eagle Area SD 420291001333 1333 Howard El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         8.0 6.0                       14.0                         8 6                 14
14568 14568 PA Centre 42027 school 4202910 110141003 SD Bald Eagle Area SD 420291001334 1334 Mountaintop Area El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         9.0 8.0                       17.0                         9 8                 17
14569 14569 PA Centre 42027 school 4202910 110141003 SD Bald Eagle Area SD 420291001331 1331 Port Matilda El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         11.0 3.0                       14.0                         11 3                 14
14570 14570 PA Centre 42027 school 4202910 110141003 SD Bald Eagle Area SD 420291001330 1330 Wingate El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         31.0 24.0                       55.0                         31 24                 55
14571 14571 PA Allegheny 42003 school 4202970 103021102 SD Baldwin-Whitehall SD 420297000050 50 Baldwin SHS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14572 14572 PA Allegheny 42003 school   103021102 SD Baldwin-Whitehall SD   9999 Baldwin-Whitehall SD             2021 1-Oct grade_1                         0.0                         0.0                         0                   0
14573 14573 PA Allegheny 42003 school 4202970 103021102 SD Baldwin-Whitehall SD 420297006787 6787 J.E. Harrison Education Ctr   Regular School No Elementary KG 06 2021 1-Oct grade_1                         67.0 58.0                       125.0                         67 58                 125
14574 14574 PA Allegheny 42003 school 4202970 103021102 SD Baldwin-Whitehall SD 420297000037 37 McAnnulty El Sch   Regular School No Elementary KG 01 2021 1-Oct grade_1                         98.0 121.0                       219.0                         98 121                 219
14575 14575 PA Allegheny 42003 school 4202970 103021102 SD Baldwin-Whitehall SD 420297000048 48 Whitehall El Sch   Regular School No Elementary 02 05 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14576 14576 PA Northampton 42095 school 4203000 120480803 SD Bangor Area SD 420300003434 3434 Bangor Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14577 14577 PA Northampton 42095 school 4203000 120480803 SD Bangor Area SD 420300005257 5257 Bangor Area MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14578 14578 PA Northampton 42095 school 4203000 120480803 SD Bangor Area SD 420300007655 8450 DeFranco El Sch   Regular School No Middle 05 06 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14579 14579 PA Northampton 42095 school 4203000 120480803 SD Bangor Area SD 420300007654 8449 Five Points El Sch   Regular School No Elementary KG 02 2021 1-Oct grade_1                         109.0 90.0                       199.0                         109 90                 199
14580 14580 PA Northampton 42095 school 4203000 120480803 SD Bangor Area SD 420300003430 3430 Washington El Sch   Regular School No Elementary 03 04 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14581 14581 PA Luzerne 42079 school 4200126 118400001 CS Bear Creek Community CS 420012600848 7827 Bear Creek Community CS   Regular School Yes Elementary KG 08 2021 1-Oct grade_1                         28.0 24.0                       52.0                         28 24                 52
14582 14582 PA Beaver 42007 school 4203120 127041203 SD Beaver Area SD 420312000106 7386 Beaver Area MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14583 14583 PA Beaver 42007 school 4203120 127041203 SD Beaver Area SD 420312000640 640 Beaver Area SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14584 14584 PA Beaver 42007 school 4203120 127041203 SD Beaver Area SD 420312000639 8065 College Square El Sch   Regular School No Elementary KG 02 2021 1-Oct grade_1                         80.0 71.0                       151.0                         80 71                 151
14585 14585 PA Beaver 42007 school 4203120 127041203 SD Beaver Area SD 420312000842 7823 Dutch Ridge El Sch   Regular School No Elementary 03 06 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14586 14586 PA Beaver 42007 school 4280500 127041307 OCCCTC Beaver County CTC 428050007095 6985 Beaver County CTC   Career and Technical School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14587 14587 PA Beaver 42007 school   127000000 IU Beaver Valley IU 27   0 Beaver Valley IU 27             2021 1-Oct grade_1                         3.0 1.0                       4.0                         3 1                 4
14588 14588 PA Bedford 42009 school   108051003 SD Bedford Area SD   9999 Bedford Area SD             2021 1-Oct grade_1                         0.0                         0.0                         0                   0
14589 14589 PA Bedford 42009 school 4203180 108051003 SD Bedford Area SD 420318000347 7545 Bedford El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         64.0 55.0                       119.0                         64 55                 119
14590 14590 PA Bedford 42009 school 4203180 108051003 SD Bedford Area SD 420318007021 7021 Bedford MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14591 14591 PA Bedford 42009 school 4203180 108051003 SD Bedford Area SD 420318000726 726 Bedford SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14592 14592 PA Bedford 42009 school 4200001 108051307 OCCCTC Bedford County Technical Center 420000107136 7096 Bedford County Technical Center   Career and Technical School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14593 14593 PA Westmoreland 42129 school 4203210 107650603 SD Belle Vernon Area SD 420321004930 4930 Belle Vernon Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14594 14594 PA Westmoreland 42129 school 4203210 107650603 SD Belle Vernon Area SD 420321007513 8269 Belle Vernon Area MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14595 14595 PA Westmoreland 42129 school   107650603 SD Belle Vernon Area SD   9999 Belle Vernon Area SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14596 14596 PA Westmoreland 42129 school 4203210 107650603 SD Belle Vernon Area SD 420321004328 4328 Marion El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         34.0 41.0                       75.0                         34 41                 75
14597 14597 PA Westmoreland 42129 school 4203210 107650603 SD Belle Vernon Area SD 420321004325 4325 Rostraver El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         34.0 44.0                       78.0                         34 44                 78
14598 14598 PA Centre 42027 school 4203240 110141103 SD Bellefonte Area SD 420324001343 1343 Bellefonte Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14599 14599 PA Centre 42027 school 4203240 110141103 SD Bellefonte Area SD 420324001342 1342 Bellefonte Area MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14600 14600 PA Centre 42027 school 4203240 110141103 SD Bellefonte Area SD 420324001341 1341 Bellefonte El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         27.0 31.0                       58.0                         27 31                 58
14601 14601 PA Centre 42027 school 4203240 110141103 SD Bellefonte Area SD 420324001339 1339 Benner El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         19.0 16.0                       35.0                         19 16                 35
14602 14602 PA Centre 42027 school 4203240 110141103 SD Bellefonte Area SD 420324001340 1340 Marion-Walker El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         23.0 34.0                       57.0                         23 34                 57
14603 14603 PA Centre 42027 school 4203240 110141103 SD Bellefonte Area SD 420324006229 6229 Pleasant Gap El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         21.0 21.0                       42.0                         21 21                 42
14604 14604 PA Blair 42013 school 4203300 108071003 SD Bellwood-Antis SD 420330007170 7144 Bellwood Antis MS   Regular School No Middle 05 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14605 14605 PA Blair 42013 school 4203300 108071003 SD Bellwood-Antis SD 420330000917 917 Bellwood-Antis HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14606 14606 PA Blair 42013 school   108071003 SD Bellwood-Antis SD   9999 Bellwood-Antis SD             2021 1-Oct grade_1                         1.0 0.0                       1.0                         1 0                 1
14607 14607 PA Blair 42013 school 4203300 108071003 SD Bellwood-Antis SD 420330000914 914 Lewis M Myers El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         41.0 44.0                       85.0                         41 44                 85
14608 14608 PA Philadelphia 42101 school 4200108 126510010 CS Belmont CS 420010800692 7750 Belmont CS   Regular School Yes Other KG 12 2021 1-Oct grade_1                         42.0 45.0                       87.0                         42 45                 87
14609 14609 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333005211 5211 Belmont Hills El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         52.0 25.0                       77.0                         52 25                 77
14610 14610 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333004675 4675 Benjamin Rush El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         35.0 27.0                       62.0                         35 27                 62
14611 14611 PA Bucks 42017 school   122091002 SD Bensalem Township SD   9999 Bensalem Township SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14612 14612 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333005116 5116 Bensalem Twp HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14613 14613 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333006451 6451 Cecelia Snyder MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14614 14614 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333001006 1006 Cornwells El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         34.0 33.0                       67.0                         34 33                 67
14615 14615 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333007030 7030 Robert K Shafer MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14616 14616 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333006896 6896 Russell C Struble El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         38.0 28.0                       66.0                         38 28                 66
14617 14617 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333001008 1008 Samuel K Faust El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         44.0 56.0                       100.0                         44 56                 100
14618 14618 PA Bucks 42017 school 4203330 122091002 SD Bensalem Township SD 420333006788 6788 Valley El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         55.0 32.0                       87.0                         55 32                 87
14619 14619 PA Columbia 42037 school 4203390 116191004 SD Benton Area SD 420339001594 1594 Appleman El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         23.0 27.0                       50.0                         23 27                 50
14620 14620 PA Columbia 42037 school 4203390 116191004 SD Benton Area SD 420339007646 8434 Benton Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14621 14621 PA Columbia 42037 school 4203390 116191004 SD Benton Area SD 420339007644 8433 Benton Area MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14622 14622 PA Washington 42125 school 4203360 101630903 SD Bentworth SD 420336000242 7987 Bentworth El Ctr   Regular School No Elementary KG 04 2021 1-Oct grade_1                         37.0 29.0                       66.0                         37 29                 66
14623 14623 PA Washington 42125 school 4203360 101630903 SD Bentworth SD 420336004189 7988 Bentworth MS   Regular School No Middle 05 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14624 14624 PA Washington 42125 school 4203360 101630903 SD Bentworth SD 420336004188 4188 Bentworth SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14625 14625 PA Berks 42011 school 4280060 114060557 OCCCTC Berks CTC 428006007046 6304 Berks CTC-East Campus   Career and Technical School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14626 14626 PA Berks 42011 school 4280060 114060557 OCCCTC Berks CTC 428006007047 7068 Berks CTC-West Campus   Career and Technical School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14627 14627 PA Berks 42011 school   114000000 IU Berks County IU 14   0 Berks County IU 14             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14628 14628 PA Somerset 42111 school 4203420 108561003 SD Berlin Brothersvalley SD 420342006206 6206 Berlin Brothersvalley El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         27.0 32.0                       59.0                         27 32                 59
14629 14629 PA Somerset 42111 school 4203420 108561003 SD Berlin Brothersvalley SD 420342000527 7645 Berlin Brothersvalley MS   Regular School No Middle 05 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14630 14630 PA Somerset 42111 school   108561003 SD Berlin Brothersvalley SD   9999 Berlin Brothersvalley SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14631 14631 PA Somerset 42111 school 4203420 108561003 SD Berlin Brothersvalley SD 420342006207 6207 Berlin Brothersvalley SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14632 14632 PA Adams 42001 school 4203450 112011103 SD Bermudian Springs SD 420345009986 7302 Bermudian Springs El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         62.0 56.0                       118.0                         62 56                 118
14633 14633 PA Adams 42001 school 4203450 112011103 SD Bermudian Springs SD 420345000003 3 Bermudian Springs HS   Regular School No High 09 12 2021 1-Oct grade_1                         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]);