Data source: Big Local News · About: Big Local

3,371,677 rows sorted by black

View and edit SQL

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
14434 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14435 PA Allegheny 42003 school 4280010 103020407 OCCCTC A W Beattie Career Center 428001007041 5273 A W Beattie Career Center   Career and Technical School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14436 PA Indiana 42063 school   128000000 IU ARIN IU 28   0 ARIN IU 28             2021 1-Oct grade_1                         1.0 0.0                       1.0                         1 0                 1
14437 PA Philadelphia 42101 school 4200835 181519176 CS ASPIRA Bilingual Cyber CS 420083507354 8148 ASPIRA Bilingual Cyber CS   Regular School Yes Other KG 12 2021 1-Oct grade_1                         8.0 7.0                       15.0                         8 7                 15
14438 PA Lackawanna 42069 school 4202010 119350303 SD Abington Heights SD 420201005091 5091 Abington Heights HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14439 PA Lackawanna 42069 school 4202010 119350303 SD Abington Heights SD 420201006839 6839 Abington Heights MS   Regular School No Middle 05 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14440 PA Lackawanna 42069 school   119350303 SD Abington Heights SD   9999 Abington Heights SD             2021 1-Oct grade_1                         0.0 1.0                       1.0                         0 1                 1
14441 PA Lackawanna 42069 school 4202010 119350303 SD Abington Heights SD 420201000371 7570 Clarks Summit El Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         47.0 37.0                       84.0                         47 37                 84
14442 PA Lackawanna 42069 school 4202010 119350303 SD Abington Heights SD 420201002407 2407 Newton-Ransom Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         23.0 16.0                       39.0                         23 16                 39
14443 PA Lackawanna 42069 school 4202010 119350303 SD Abington Heights SD 420201006398 6398 South Abington Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         34.0 34.0                       68.0                         34 34                 68
14444 PA Lackawanna 42069 school 4202010 119350303 SD Abington Heights SD 420201002402 2402 Waverly Sch   Regular School No Elementary KG 04 2021 1-Oct grade_1                         33.0 34.0                       67.0                         33 34                 67
14445 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204003242 3242 Abington JHS   Regular School No Middle 07 09 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14446 PA Montgomery 42091 school   123460302 SD Abington SD   9999 Abington SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14447 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204003241 3241 Abington SHS   Regular School No High 10 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14448 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204000620 7707 Copper Beech Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         67.0 70.0                       137.0                         67 70                 137
14449 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204003229 3229 Highland Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         33.0 33.0                       66.0                         33 33                 66
14450 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204005075 5075 McKinley Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         44.0 38.0                       82.0                         44 38                 82
14451 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204003232 3232 Overlook Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         38.0 29.0                       67.0                         38 29                 67
14452 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204003234 3234 Roslyn Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         28.0 31.0                       59.0                         28 31                 59
14453 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204003226 3226 Rydal East Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         57.0 45.0                       102.0                         57 45                 102
14454 PA Montgomery 42091 school 4202040 123460302 SD Abington SD 420204004910 4910 Willow Hill Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         37.0 29.0                       66.0                         37 29                 66
14455 PA Chester 42029 school 4200128 125230001 CS Achievement House CS 420012800843 7824 Achievement House CS   Regular School Yes High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14456 PA Philadelphia 42101 school 4200129 126510015 CS Ad Prima CS 420012900846 7825 Ad Prima CS   Regular School Yes Elementary KG 08 2021 1-Oct grade_1                         29.0 32.0                       61.0                         29 32                 61
14457 PA Adams 42001 school 4200905 112015106 OCCCTC Adams County Technical Institute 420090507684 8471 Adams County Technical Institute   Career and Technical School No High 11 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14458 PA Cambria 42021 school 4280120 108110307 OCCCTC Admiral Peary AVTS 428012007053 6661 Admiral Peary AVTS   Career and Technical School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14459 PA Montgomery 42091 school   126510020 CS Agora Cyber CS   9999 Agora Cyber CS             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14460 PA Montgomery 42091 school 4200140 126510020 CS Agora Cyber CS 420014000896 7858 Agora Cyber CS   Regular School Yes Other KG 12 2021 1-Oct grade_1                         175.0 195.0                       370.0                         175 195                 370
14461 PA Fayette 42051 school 4202100 101260303 SD Albert Gallatin Area SD 420210007575 8364 A L Wilson El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         28.0 27.0                       55.0                         28 27                 55
14462 PA Fayette 42051 school 4202100 101260303 SD Albert Gallatin Area SD 420210006001 6001 Albert Gallatin Area SHS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14463 PA Fayette 42051 school 4202100 101260303 SD Albert Gallatin Area SD 420210000407 7607 Albert Gallatin North MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14464 PA Fayette 42051 school 4202100 101260303 SD Albert Gallatin Area SD 420210000408 7608 Albert Gallatin South MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14465 PA Fayette 42051 school 4202100 101260303 SD Albert Gallatin Area SD 420210004922 4922 Friendship Hill El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         11.0 16.0                       27.0                         11 16                 27
14466 PA Fayette 42051 school 4202100 101260303 SD Albert Gallatin Area SD 420210002129 2129 George J Plava El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         31.0 32.0                       63.0                         31 32                 63
14467 PA Fayette 42051 school 4202100 101260303 SD Albert Gallatin Area SD 420210006002 6002 Masontown El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         16.0 24.0                       40.0                         16 24                 40
14468 PA Fayette 42051 school 4202100 101260303 SD Albert Gallatin Area SD 420210004921 4921 Smithfield El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         26.0 26.0                       52.0                         26 26                 52
14469 PA Beaver 42007 school 4202130 127040503 SD Aliquippa SD 420213000615 8085 Aliquippa El Sch   Regular School No Elementary KG 06 2021 1-Oct grade_1                         34.0 34.0                       68.0                         34 34                 68
14470 PA Beaver 42007 school 4202130 127040503 SD Aliquippa SD 420213007336 8086 Aliquippa JSHS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14471 PA Allegheny 42003 school   103000000 IU Allegheny IU 3   0 Allegheny IU 3             2021 1-Oct grade_1                         13.0 3.0                       16.0                         13 3                 16
14472 PA Allegheny 42003 school 4202190 103020603 SD Allegheny Valley SD 420219005296 5296 Acmetonia El Sch   Regular School No Elementary PK 06 2021 1-Oct grade_1                         37.0 37.0                       74.0                         37 37                 74
14473 PA Allegheny 42003 school   103020603 SD Allegheny Valley SD   9999 Allegheny Valley SD             2021 1-Oct grade_1                         0.0 1.0                       1.0                         0 1                 1
14474 PA Allegheny 42003 school 4202190 103020603 SD Allegheny Valley SD 420219000029 29 Springdale JSHS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14475 PA Clarion 42031 school 4202310 106160303 SD Allegheny-Clarion Valley SD 420231000208 7467 Allegheny-Clarion Valley Elem   Regular School No Elementary KG 06 2021 1-Oct grade_1                         30.0 19.0                       49.0                         30 19                 49
14476 PA Clarion 42031 school 4202310 106160303 SD Allegheny-Clarion Valley SD 420231004664 4664 Allegheny-Clarion Valley HS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14477 PA Clarion 42031 school   106160303 SD Allegheny-Clarion Valley SD   9999 Allegheny-Clarion Valley SD             2021 1-Oct grade_1                         0.0                         0.0                         0                   0
14478 PA Lehigh 42077 school   121390302 SD Allentown City SD   9999 Allentown City SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14479 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228007690 8484 Brigadier General Anna Mae Hays El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         48.0 59.0                       107.0                         48 59                 107
14480 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228007623 8412 Building 21 Allentown   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14481 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002790 2790 Central El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         63.0 66.0                       129.0                         63 66                 129
14482 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002792 2792 Francis D Raub MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14483 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002791 2791 Harrison-Morton MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14484 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002768 2768 Hiram W Dodd El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         59.0 50.0                       109.0                         59 50                 109
14485 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228007624 8413 Jackson Early Childhood Center   Regular School No Elementary KG KG 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14486 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002774 2774 Jefferson El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         47.0 56.0                       103.0                         47 56                 103
14487 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002775 2775 Lehigh Parkway El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         25.0 27.0                       52.0                         25 27                 52
14488 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002795 2795 Louis E Dieruff HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14489 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228007364 8140 Luis A. Ramos El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         67.0 58.0                       125.0                         67 58                 125
14490 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002779 2779 Mosser El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         36.0 32.0                       68.0                         36 32                 68
14491 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002780 2780 Muhlenberg El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         40.0 50.0                       90.0                         40 50                 90
14492 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002781 2781 Ritter El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         28.0 27.0                       55.0                         28 27                 55
14493 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002782 2782 Roosevelt El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         50.0 45.0                       95.0                         50 45                 95
14494 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228006448 6448 Sheridan El Sch   Regular School No Elementary 01 05 2021 1-Oct grade_1                         69.0 55.0                       124.0                         69 55                 124
14495 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002793 2793 South Mountain MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14496 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228004929 4929 Trexler MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14497 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002785 2785 Union Terrace El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         50.0 64.0                       114.0                         50 64                 114
14498 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002786 2786 Washington El Sch   Regular School No Elementary 01 05 2021 1-Oct grade_1                         42.0 30.0                       72.0                         42 30                 72
14499 PA Lehigh 42077 school 4202280 121390302 SD Allentown City SD 420228002794 2794 William Allen HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14500 PA Philadelphia 42101 school 4200039 126512990 CS Alliance for Progress CS 420003900398 7543 Alliance for Progress CS   Regular School Yes Elementary KG 08 2021 1-Oct grade_1                         31.0 39.0                       70.0                         31 39                 70
14501 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234000913 913 Altoona Area HS   Regular School No High 06 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14502 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234006850 7986 Altoona Area Jr HS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14503 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234000891 891 Baker El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         35.0 24.0                       59.0                         35 24                 59
14504 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234000908 908 Irving El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         30.0 20.0                       50.0                         30 20                 50
14505 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234000895 895 Juniata El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         33.0 38.0                       71.0                         33 38                 71
14506 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234000930 930 Juniata Gap El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         49.0 45.0                       94.0                         49 45                 94
14507 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234000933 933 Logan El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         43.0 25.0                       68.0                         43 25                 68
14508 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234007254 7199 Mowrie A Ebner El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         42.0 36.0                       78.0                         42 36                 78
14509 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234007486 8280 Penn-Lincoln El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         35.0 19.0                       54.0                         35 19                 54
14510 PA Blair 42013 school 4202340 108070502 SD Altoona Area SD 420234000902 902 Pleasant Valley El Sch   Regular School No Elementary KG 05 2021 1-Oct grade_1                         47.0 49.0                       96.0                         47 49                 96
14511 PA Beaver 42007 school 4202440 127040703 SD Ambridge Area SD 420244006555 6555 Ambridge Area HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14512 PA Beaver 42007 school 4202440 127040703 SD Ambridge Area SD 420244000633 633 Ambridge Area MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14513 PA Beaver 42007 school   127040703 SD Ambridge Area SD   9999 Ambridge Area SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14514 PA Beaver 42007 school 4202440 127040703 SD Ambridge Area SD 420244000629 629 Economy El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         37.0 34.0                       71.0                         37 34                 71
14515 PA Beaver 42007 school 4202440 127040703 SD Ambridge Area SD 420244000800 661 Highland El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         26.0 23.0                       49.0                         26 23                 49
14516 PA Beaver 42007 school 4202440 127040703 SD Ambridge Area SD 420244000632 632 State Street El Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         20.0 20.0                       40.0                         20 20                 40
14517 PA Lebanon 42075 school 4202490 113380303 SD Annville-Cleona SD 420249002725 2725 Annville Cleona HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14518 PA Lebanon 42075 school 4202490 113380303 SD Annville-Cleona SD 420249002724 2724 Annville El Sch   Regular School No Elementary 03 06 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14519 PA Lebanon 42075 school 4202490 113380303 SD Annville-Cleona SD 420249007417 8178 Annville-Cleona MS   Regular School No Middle 07 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14520 PA Lebanon 42075 school   113380303 SD Annville-Cleona SD   9999 Annville-Cleona SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14521 PA Lebanon 42075 school 4202490 113380303 SD Annville-Cleona SD 420249002723 2723 Cleona El Sch   Regular School No Elementary KG 02 2021 1-Oct grade_1                         65.0 55.0                       120.0                         65 55                 120
14522 PA Berks 42011 school 4202480 114060503 SD Antietam SD 420248000820 820 Antietam MS/HS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14523 PA Berks 42011 school   114060503 SD Antietam SD   9999 Antietam SD             2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14524 PA Berks 42011 school 4202480 114060503 SD Antietam SD 420248005205 5205 Mt Penn El Sch   Regular School No Elementary 03 06 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14525 PA Berks 42011 school 4202480 114060503 SD Antietam SD 420248007687 8482 Mt Penn Primary Ctr   Regular School No Elementary KG 02 2021 1-Oct grade_1                         53.0 34.0                       87.0                         53 34                 87
14526 PA Philadelphia 42101 school 4200813 104510394 CS Antonia Pantoja Community CS 420081306909 8031 Antonia Pantoja Community CS   Regular School Yes Elementary KG 08 2021 1-Oct grade_1                         49.0 47.0                       96.0                         49 47                 96
14527 PA Armstrong 42005 school 4202550 128030603 SD Apollo-Ridge SD 420255000779 7787 Apollo-Ridge Elem Sch   Regular School No Elementary PK 05 2021 1-Oct grade_1                         47.0 37.0                       84.0                         47 37                 84
14528 PA Armstrong 42005 school 4202550 128030603 SD Apollo-Ridge SD 420255002320 2320 Apollo-Ridge HS   Regular School No High 09 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14529 PA Armstrong 42005 school 4202550 128030603 SD Apollo-Ridge SD 420255006570 6570 Apollo-Ridge MS   Regular School No Middle 06 08 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14530 PA Armstrong 42005 school   128030603 SD Apollo-Ridge SD   9999 Apollo-Ridge SD             2021 1-Oct grade_1                         1.0 0.0                       1.0                         1 0                 1
14531 PA Blair 42013 school   108000000 IU Appalachia IU 8   0 Appalachia IU 8             2021 1-Oct grade_1                         1.0 2.0                       3.0                         1 2                 3
14532 PA Armstrong 42005 school 4202590 128030852 SD Armstrong SD 420259007569 8342 Armstrong JSHS   Regular School No High 07 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
14533 PA Armstrong 42005 school   128030852 SD Armstrong SD   9999 Armstrong SD             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]);