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
14634 14634 PA Adams 42001 school 4203450 112011103 SD Bermudian Springs SD 420345006921 6921 Bermudian Springs MS   Regular School No Middle 05 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14635 14635 PA Adams 42001 school   112011103 SD Bermudian Springs SD   9999 Bermudian Springs SD             2021 1-Oct grade_1                         0.0                         0.0                         0                   0
14636 14636 PA Columbia 42037 school 4203480 116191103 SD Berwick Area SD 420348001605 1605 Berwick Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14637 14637 PA Columbia 42037 school 4203480 116191103 SD Berwick Area SD 420348006808 6808 Berwick Area MS   Regular School No Middle 05 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14638 14638 PA Columbia 42037 school   116191103 SD Berwick Area SD   9999 Berwick Area SD             2021 1-Oct grade_1                         0.0                         0.0                         0                   0
14639 14639 PA Columbia 42037 school 4203480 116191103 SD Berwick Area SD 420348006349 6349 Nescopeck El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         18.0 14.0                       32.0                         18 14                 32
14640 14640 PA Columbia 42037 school 4203480 116191103 SD Berwick Area SD 420348001597 1597 Salem El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         42.0 38.0                       80.0                         42 38                 80
14641 14641 PA Columbia 42037 school 4203480 116191103 SD Berwick Area SD 420348007582 8378 West Berwick El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         56.0 38.0                       94.0                         56 38                 94
14642 14642 PA Allegheny 42003 school 4203510 103021252 SD Bethel Park SD 420351004802 4802 Abraham Lincoln El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         29.0 29.0                       58.0                         29 29                 58
14643 14643 PA Allegheny 42003 school 4203510 103021252 SD Bethel Park SD 420351009977 7326 Benjamin Franklin El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         37.0 32.0                       69.0                         37 32                 69
14644 14644 PA Allegheny 42003 school 4203510 103021252 SD Bethel Park SD 420351000055 55 Bethel Memorial El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         44.0 26.0                       70.0                         44 26                 70
14645 14645 PA Allegheny 42003 school 4203510 103021252 SD Bethel Park SD 420351000062 62 Bethel Park HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14646 14646 PA Allegheny 42003 school 4203510 103021252 SD Bethel Park SD 420351004902 4902 George Washington El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         28.0 18.0                       46.0                         28 18                 46
14647 14647 PA Allegheny 42003 school 4203510 103021252 SD Bethel Park SD 420351000061 61 Independence MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14648 14648 PA Allegheny 42003 school 4203510 103021252 SD Bethel Park SD 420351009978 7327 Neil Armstrong 5-6 MS   Regular School No Middle 05 06 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14649 14649 PA Allegheny 42003 school 4203510 103021252 SD Bethel Park SD 420351000060 60 William Penn El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         18.0 16.0                       34.0                         18 16                 34
14650 14650 PA Northampton 42095 school 4280370 120481107 OCCCTC Bethlehem AVTS 428037007083 5286 Bethlehem AVTS   Career and Technical School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14651 14651 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357005063 5063 Asa Packer El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         27.0 30.0                       57.0                         27 30                 57
14652 14652 PA Northampton 42095 school   120481002 SD Bethlehem Area SD   9999 Bethlehem Area SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14653 14653 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003464 3464 Broughal MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14654 14654 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003436 3436 Calypso El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         19.0 10.0                       29.0                         19 10                 29
14655 14655 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003453 3453 Clearview El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         31.0 36.0                       67.0                         31 36                 67
14656 14656 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357006722 6722 Donegan El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         27.0 37.0                       64.0                         27 37                 64
14657 14657 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357004956 4956 East Hills MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14658 14658 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003456 3456 Farmersville El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         28.0 26.0                       54.0                         28 26                 54
14659 14659 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357006723 6723 Fountain Hill El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         36.0 42.0                       78.0                         36 42                 78
14660 14660 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357004957 4957 Freedom HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14661 14661 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003458 3458 Freemansburg El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         26.0 23.0                       49.0                         26 23                 49
14662 14662 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003449 3449 Governor Wolf El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         39.0 40.0                       79.0                         39 40                 79
14663 14663 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003459 3459 Hanover El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         12.0 22.0                       34.0                         12 22                 34
14664 14664 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003442 3442 James Buchanan El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         17.0 18.0                       35.0                         17 18                 35
14665 14665 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003465 3465 Liberty HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14666 14666 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003443 3443 Lincoln El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         37.0 18.0                       55.0                         37 18                 55
14667 14667 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003454 3454 Marvine El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         18.0 19.0                       37.0                         18 19                 37
14668 14668 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003455 3455 Miller Heights El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         25.0 24.0                       49.0                         25 24                 49
14669 14669 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003463 3463 Nitschmann MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14670 14670 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003462 3462 Northeast MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14671 14671 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357003452 3452 Spring Garden El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         40.0 34.0                       74.0                         40 34                 74
14672 14672 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357006633 6633 Thomas Jefferson El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         23.0 12.0                       35.0                         23 12                 35
14673 14673 PA Northampton 42095 school 4203570 120481002 SD Bethlehem Area SD 420357006634 6634 William Penn El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         18.0 13.0                       31.0                         18 13                 31
14674 14674 PA Washington 42125 school 4203600 101631003 SD Bethlehem-Center SD 420360006975 6975 Bethlehem-Center El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         44.0 35.0                       79.0                         44 35                 79
14675 14675 PA Washington 42125 school 4203600 101631003 SD Bethlehem-Center SD 420360005267 5267 Bethlehem-Center MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14676 14676 PA Washington 42125 school   101631003 SD Bethlehem-Center SD   9999 Bethlehem-Center SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14677 14677 PA Washington 42125 school 4203600 101631003 SD Bethlehem-Center SD 420360004181 4181 Bethlehem-Center SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14678 14678 PA Beaver 42007 school 4203630 127041503 SD Big Beaver Falls Area SD 420363000649 649 Beaver Falls Area SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14679 14679 PA Beaver 42007 school 4203630 127041503 SD Big Beaver Falls Area SD 420363000648 648 Beaver Falls MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14680 14680 PA Beaver 42007 school 4203630 127041503 SD Big Beaver Falls Area SD 420363000650 650 Big Beaver El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         20.0 24.0                       44.0                         20 24                 44
14681 14681 PA Beaver 42007 school   127041503 SD Big Beaver Falls Area SD   9999 Big Beaver Falls Area SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14682 14682 PA Beaver 42007 school 4203630 127041503 SD Big Beaver Falls Area SD 420363000799 642 Central El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         43.0 43.0                       86.0                         43 43                 86
14683 14683 PA Cumberland 42041 school 4203660 115210503 SD Big Spring SD 420366001677 1677 Big Spring HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14684 14684 PA Cumberland 42041 school 4203660 115210503 SD Big Spring SD 420366006326 6326 Big Spring MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14685 14685 PA Cumberland 42041 school   115210503 SD Big Spring SD   9999 Big Spring SD             2021 1-Oct grade_1                         0.0 2.0                       2.0                         0 2                 2
14686 14686 PA Cumberland 42041 school 4203660 115210503 SD Big Spring SD 420366006116 7951 Mount Rock Elem Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         35.0 32.0                       67.0                         35 32                 67
14687 14687 PA Cumberland 42041 school 4203660 115210503 SD Big Spring SD 420366001676 1676 Newville El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         26.0 40.0                       66.0                         26 40                 66
14688 14688 PA Cumberland 42041 school 4203660 115210503 SD Big Spring SD 420366000038 7355 Oak Flat El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         48.0 28.0                       76.0                         48 28                 76
14689 14689 PA Beaver 42007 school 4203688 127041603 SD Blackhawk SD 420368806707 6707 Blackhawk HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14690 14690 PA Beaver 42007 school 4203688 127041603 SD Blackhawk SD 420368807694 8476 Blackhawk Intermediate Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         55.0 58.0                       113.0                         55 58                 113
14691 14691 PA Beaver 42007 school   127041603 SD Blackhawk SD   9999 Blackhawk SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14692 14692 PA Beaver 42007 school 4203688 127041603 SD Blackhawk SD 420368806558 6558 Highland MS   Regular School No Middle 05 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14693 14693 PA Beaver 42007 school 4203688 127041603 SD Blackhawk SD 420368806560 6560 Patterson Primary Sch   Regular School No Elementary KG 02 2021 1-Oct grade_1                         21.0 26.0                       47.0                         21 26                 47
14694 14694 PA Cambria 42021 school 4203690 108110603 SD Blacklick Valley SD 420369006828 6828 Blacklick Valley El Ctr   Regular School No Elementary PK 06 2021 1-Oct grade_1                         25.0 15.0                       40.0                         25 15                 40
14695 14695 PA Cambria 42021 school 4203690 108110603 SD Blacklick Valley SD 420369005135 5135 Blacklick Valley JSHS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14696 14696 PA Cambria 42021 school   108110603 SD Blacklick Valley SD   9999 Blacklick Valley SD             2021 1-Oct grade_1                         0.0                         0.0                         0                   0
14697 14697 PA Indiana 42063 school 4203750 128321103 SD Blairsville-Saltsburg SD 420375000135 7418 Blairsville El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         38.0 32.0                       70.0                         38 32                 70
14698 14698 PA Indiana 42063 school 4203750 128321103 SD Blairsville-Saltsburg SD 420375002317 2317 Blairsville MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14699 14699 PA Indiana 42063 school 4203750 128321103 SD Blairsville-Saltsburg SD 420375004706 4706 Blairsville SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14700 14700 PA Indiana 42063 school   128321103 SD Blairsville-Saltsburg SD   9999 Blairsville-Saltsburg SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14701 14701 PA Indiana 42063 school 4203750 128321103 SD Blairsville-Saltsburg SD 420375002352 2352 Saltsburg El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         16.0 11.0                       27.0                         16 11                 27
14702 14702 PA Indiana 42063 school 4203750 128321103 SD Blairsville-Saltsburg SD 420375002353 2353 Saltsburg MS/HS   Regular School No High 06 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14703 14703 PA Columbia 42037 school 4203840 116191203 SD Bloomsburg Area SD 420384001610 1610 Beaver-Main El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         11.0 7.0                       18.0                         11 7                 18
14704 14704 PA Columbia 42037 school 4203840 116191203 SD Bloomsburg Area SD 420384001612 1612 Bloomsburg Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14705 14705 PA Columbia 42037 school 4203840 116191203 SD Bloomsburg Area SD 420384001611 1611 Bloomsburg Area MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14706 14706 PA Columbia 42037 school 4203840 116191203 SD Bloomsburg Area SD 420384001606 1606 Memorial El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         41.0 27.0                       68.0                         41 27                 68
14707 14707 PA Columbia 42037 school 4203840 116191203 SD Bloomsburg Area SD 420384001608 1608 W W Evans Memorial El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         25.0 15.0                       40.0                         25 15                 40
14708 14708 PA Schuylkill 42107 school 4203870 129540803 SD Blue Mountain SD 420387000138 7419 Blue Mountain El Cressona Sch   Regular School No Elementary 03 05 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14709 14709 PA Schuylkill 42107 school 4203870 129540803 SD Blue Mountain SD 420387004659 4659 Blue Mountain El East Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         58.0 47.0                       105.0                         58 47                 105
14710 14710 PA Schuylkill 42107 school 4203870 129540803 SD Blue Mountain SD 420387003891 3891 Blue Mountain HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14711 14711 PA Schuylkill 42107 school 4203870 129540803 SD Blue Mountain SD 420387005263 5263 Blue Mountain MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14712 14712 PA Schuylkill 42107 school   129540803 SD Blue Mountain SD   9999 Blue Mountain SD             2021 1-Oct grade_1                         0.0 1.0                       1.0                         0 1                 1
14713 14713 PA Schuylkill 42107 school 4203870 129540803 SD Blue Mountain SD 420387003887 3887 Blue Mountain West/St. Ambrose Sch   Regular School No Elementary KG 02 2021 1-Oct grade_1                         24.0 38.0                       62.0                         24 38                 62
14714 14714 PA Susquehanna 42115 school 4203900 119581003 SD Blue Ridge SD 420390006891 6891 Blue Ridge El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         46.0 30.0                       76.0                         46 30                 76
14715 14715 PA Susquehanna 42115 school 4203900 119581003 SD Blue Ridge SD 420390004034 4034 Blue Ridge HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14716 14716 PA Susquehanna 42115 school 4203900 119581003 SD Blue Ridge SD 420390000101 7400 Blue Ridge MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14717 14717 PA Susquehanna 42115 school   119581003 SD Blue Ridge SD   9999 Blue Ridge SD             2021 1-Oct grade_1                           0.0                       0.0                           0                 0
14718 14718 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396006804 6804 Boyertown Area MS-East   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14719 14719 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396006305 6305 Boyertown Area MS-West   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14720 14720 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396006306 6306 Boyertown Area SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14721 14721 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396006307 6307 Boyertown El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         55.0 44.0                       99.0                         55 44                 99
14722 14722 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396000762 762 Colebrookdale El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         24.0 20.0                       44.0                         24 20                 44
14723 14723 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396000763 763 Earl El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         23.0 18.0                       41.0                         23 18                 41
14724 14724 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396000754 754 Gilbertsville El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         36.0 52.0                       88.0                         36 52                 88
14725 14725 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396000755 755 New Hanover-Upper Frederick El   Regular School No Elementary KG 05 2021 1-Oct grade_1                         46.0 42.0                       88.0                         46 42                 88
14726 14726 PA Berks 42011 school 4203960 114060753 SD Boyertown Area SD 420396000766 766 Washington El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         34.0 36.0                       70.0                         34 36                 70
14727 14727 PA Philadelphia 42101 school 4200760 185515523 CS Boys Latin of Philadelphia CS 420076006107 7981 Boys Latin of Philadelphia CS   Regular School Yes High 06 12 2021 1-Oct grade_1                         0.0                         0.0                         0                   0
14728 14728 PA McKean 42083 school 4204020 109420803 SD Bradford Area SD 420402004691 4691 Bradford Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14729 14729 PA McKean 42083 school   109420803 SD Bradford Area SD   9999 Bradford Area SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14730 14730 PA McKean 42083 school 4204020 109420803 SD Bradford Area SD 420402000281 3092 Floyd C Fretz MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14731 14731 PA McKean 42083 school 4204020 109420803 SD Bradford Area SD 420402007037 7037 George Blaisdell El Sch   Regular School No Elementary PK 02 2021 1-Oct grade_1                         121.0 75.0                       196.0                         121 75                 196
14732 14732 PA McKean 42083 school 4204020 109420803 SD Bradford Area SD 420402000349 7281 School Street El Sch   Regular School No Elementary 03 05 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14733 14733 PA Berks 42011 school   114060853 SD Brandywine Heights Area SD   9999 Brandywine Heights Area SD             2021 1-Oct grade_1                         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]);