enrollments

Data source: Big Local News · About: Big Local

137,628 rows where state = "LA" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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 ▼
2284349 2284349 LA     school 2201020 032   Livingston Parish 220102000759 32006 Denham Springs Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284351 2284351 LA     school 2201020 032   Livingston Parish 220102000761 32008 Doyle High School   Regular School No High 06 12 2019 spring grade_1                                                   0                                             0
2284352 2284352 LA     school 2201020 032   Livingston Parish 220102000762 32009 French Settlement High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284357 2284357 LA     school 2201020 032   Livingston Parish 220102000767 32014 Live Oak High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284358 2284358 LA     school 2201020 032   Livingston Parish 220102001558 32015 Live Oak Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284363 2284363 LA     school 2201020 032   Livingston Parish 220102001559 32021 Southside Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284365 2284365 LA     school 2201020 032   Livingston Parish 220102000773 32023 Springfield High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284366 2284366 LA     school 2201020 032   Livingston Parish 220102000774 32024 Walker High School   Regular School No High 10 12 2019 spring grade_1                                                   0                                             0
2284367 2284367 LA     school 2201020 032   Livingston Parish 220102000775 32025 Walker Freshman High School   Regular School No Secondary 09 09 2019 spring grade_1                                                   0                                             0
2284369 2284369 LA     school 2201020 032   Livingston Parish 220102000777 32027 Westside Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284372 2284372 LA     school 2201020 032   Livingston Parish 220102001708 32032 Albany Middle School   Regular School No Middle 04 08 2019 spring grade_1                                                   0                                             0
2284375 2284375 LA     school 2201020 032   Livingston Parish 220102010339 32038 Springfield Middle School   Regular School No Middle 04 08 2019 spring grade_1                                                   0                                             0
2284376 2284376 LA     school 2201020 032   Livingston Parish 220102000400 32039 Albany Upper Elementary School   Regular School No Elementary 03 04 2019 spring grade_1                                                   0                                             0
2284379 2284379 LA     school 2201020 032   Livingston Parish 220102000904 32042 Denham Springs Freshman High School   Regular School No Secondary 08 09 2019 spring grade_1                                                   0                                             0
2284382 2284382 LA     school 2201020 032   Livingston Parish 220102002060 32046 North Corbin Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284385 2284385 LA     school 2201020 032   Livingston Parish 220102002312 32049 Juban Parc Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284386 2284386 LA     school 2201020 032   Livingston Parish 220102002435 32050 Live Oak Junior High   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284387 2284387 LA     school   032   Livingston Parish   32700 Livingston Central Office             2019 spring grade_1                                                   0                                             0
2284388 2284388 LA     school 2201050 033   Madison Parish 220105000779 33001 Madison Middle School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284389 2284389 LA     school 2201050 033   Madison Parish 220105000780 33002 Madison High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284391 2284391 LA     school 2201050 033   Madison Parish 220105000785 33007 Wright Elementary School   Regular School No Middle 04 06 2019 spring grade_1                                                   0                                             0
2284392 2284392 LA     school 2201050 033   Madison Parish 220105010412 33010 Christian Acres Alternative School   Regular School No High 06 12 2019 spring grade_1                                                   0                                             0
2284393 2284393 LA     school   033   Madison Parish   33700 Madison Central Office             2019 spring grade_1                                                   0                                             0
2284394 2284394 LA     school   034   Morehouse Parish   34000 Administrative Services - Special Education             2019 spring grade_1                                                   0                                             0
2284395 2284395 LA     school 2201110 034   Morehouse Parish 220111000805 34002 Bastrop High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284400 2284400 LA     school 2201140 035   Natchitoches Parish 220114000828 35005 East Natchitoches Elementary & Middle School   Regular School No Middle 05 06 2019 spring grade_1                                                   0                                             0
2284404 2284404 LA     school 2201140 035   Natchitoches Parish 220114000834 35009 Natchitoches Central High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284405 2284405 LA     school 2201140 035   Natchitoches Parish 220114001616 35010 Natchitoches Jr. High School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284408 2284408 LA     school 2201140 035   Natchitoches Parish 220114000838 35014 N.S.U. Middle Lab School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284410 2284410 LA     school 2201140 035   Natchitoches Parish 220114000845 35021 M.R. Weaver Elementary School   Regular School No Elementary 03 04 2019 spring grade_1                                                   0                                             0
2284411 2284411 LA     school 2201140 035   Natchitoches Parish 220114000101 35026 Lakeview Jr./Sr. High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284412 2284412 LA     school 2201140 035   Natchitoches Parish 220114001404 35030 Natchitoches Parish Technical and Career Center   Regular School No Other 04 12 2019 spring grade_1                                                   0                                             0
2284414 2284414 LA     school 2201140 035   Natchitoches Parish 220114002022 35032 Lakeview Annex   Regular School No Other 04 12 2019 spring grade_1                                                   0                                             0
2284416 2284416 LA     school 2201170 R36   All Orleans 220117000880 36035 Warren Easton Senior High School   Regular School Yes High 09 12 2019 spring grade_1                                                   0                                             0
2284418 2284418 LA     school 2201170 R36   All Orleans 220117000939 36088 McDonogh #35 College Preparatory School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284419 2284419 LA     school 2201170 R36   All Orleans 220117001522 36132 Youth Study Center   Regular School No Other 03 12 2019 spring grade_1                                                   0                                             0
2284425 2284425 LA     school 2201170 R36   All Orleans 220117002437 36198 Rooted School   Regular School Yes Secondary 09 10 2019 spring grade_1                                                   0                                             0
2284426 2284426 LA     school   R36   All Orleans   36700 Orleans Central Office             2019 spring grade_1                                                   0                                             0
2284427 2284427 LA     school   037   Ouachita Parish   37000 Administrative Services -- Special Education             2019 spring grade_1                                                   0                                             0
2284428 2284428 LA     school 2201200 037   Ouachita Parish 220120000986 37003 Central Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284430 2284430 LA     school 2201200 037   Ouachita Parish 220120000988 37006 Crosley Elementary School   Regular School No Elementary PK KG 2019 spring grade_1                                                   0                                             0
2284438 2284438 LA     school 2201200 037   Ouachita Parish 220120001001 37019 Ouachita Parish High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284439 2284439 LA     school 2201200 037   Ouachita Parish 220120001002 37020 Ouachita Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284442 2284442 LA     school 2201200 037   Ouachita Parish 220120001009 37028 Riser Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284446 2284446 LA     school 2201200 037   Ouachita Parish 220120001013 37032 Sterlington High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284447 2284447 LA     school 2201200 037   Ouachita Parish 220120001014 37033 Swartz Upper Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284449 2284449 LA     school 2201200 037   Ouachita Parish 220120001017 37036 West Monroe High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284451 2284451 LA     school 2201200 037   Ouachita Parish 220120001021 37039 Woodlawn Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284452 2284452 LA     school 2201200 037   Ouachita Parish 220120001889 37041 Calhoun Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284453 2284453 LA     school 2201200 037   Ouachita Parish 220120001939 37046 West Ouachita High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284455 2284455 LA     school 2201200 037   Ouachita Parish 220120001525 37049 Richwood High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284457 2284457 LA     school 2201200 037   Ouachita Parish 220120001557 37051 West Ridge Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284459 2284459 LA     school 2201200 037   Ouachita Parish 220120001564 37053 Good Hope Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284461 2284461 LA     school 2201200 037   Ouachita Parish 220120001683 37056 Richwood Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284462 2284462 LA     school 2201200 037   Ouachita Parish 220120002325 37057 Sterlington Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284463 2284463 LA     school 2201200 037   Ouachita Parish 220120002446 37058 East Ouachita Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284464 2284464 LA     school 2201230 038   Plaquemines Parish 220123001022 38001 Belle Chasse High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284465 2284465 LA     school 2201230 038   Plaquemines Parish 220123001023 38002 Belle Chasse Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284468 2284468 LA     school 2201230 038   Plaquemines Parish 220123000366 38010 Belle Chasse Elementary School   Regular School No Elementary 02 04 2019 spring grade_1                                                   0                                             0
2284470 2284470 LA     school 2201230 038   Plaquemines Parish 220123002028 38013 South Plaquemines High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284472 2284472 LA     school 2201260 039   Pointe Coupee Parish 220126001029 39003 Livonia High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284477 2284477 LA     school   039   Pointe Coupee Parish   39700 Point Coupee Parish Central Office             2019 spring grade_1                                                   0                                             0
2284478 2284478 LA     school 2201290 040   Rapides Parish 220129001038 40001 Acadian Elementary   Regular School No Elementary PK KG 2019 spring grade_1                                                   0                                             0
2284479 2284479 LA     school 2201290 040   Rapides Parish 220129001039 40002 Alexandria Middle Magnet School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284480 2284480 LA     school 2201290 040   Rapides Parish 220129001040 40003 Alexandria Senior High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284483 2284483 LA     school 2201290 040   Rapides Parish 220129001042 40006 Bolton High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284484 2284484 LA     school 2201290 040   Rapides Parish 220129001044 40008 Scott M. Brame Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284487 2284487 LA     school 2201290 040   Rapides Parish 220129001047 40011 Buckeye High School   Regular School No High 06 12 2019 spring grade_1                                                   0                                             0
2284492 2284492 LA     school 2201290 040   Rapides Parish 220129001054 40017 D.F. Huddle Elementary   Regular School No Elementary PK KG 2019 spring grade_1                                                   0                                             0
2284493 2284493 LA     school 2201290 040   Rapides Parish 220129001055 40018 Arthur F. Smith Middle Magnet School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284499 2284499 LA     school 2201290 040   Rapides Parish 220129001067 40030 Peabody Magnet High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284501 2284501 LA     school 2201290 040   Rapides Parish 220129001068 40032 Pineville Elementary School   Regular School No Middle 04 06 2019 spring grade_1                                                   0                                             0
2284502 2284502 LA     school 2201290 040   Rapides Parish 220129001069 40033 Pineville High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284503 2284503 LA     school 2201290 040   Rapides Parish 220129001070 40034 Pineville Junior High School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284506 2284506 LA     school 2201290 040   Rapides Parish 220129001073 40037 Rapides High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284508 2284508 LA     school 2201290 040   Rapides Parish 220129001075 40039 Julius Patrick 6th Grade Academy   Regular School No Middle 06 06 2019 spring grade_1                                                   0                                             0
2284511 2284511 LA     school 2201290 040   Rapides Parish 220129001078 40042 L.S. Rugg Elementary School   Regular School No Elementary 04 05 2019 spring grade_1                                                   0                                             0
2284512 2284512 LA     school 2201290 040   Rapides Parish 220129001080 40043 W.O. Hall 6th Grade Academy   Regular School No Middle 06 06 2019 spring grade_1                                                   0                                             0
2284514 2284514 LA     school 2201290 040   Rapides Parish 220129001083 40045 Alma Redwine Elementary   Regular School No Elementary 04 05 2019 spring grade_1                                                   0                                             0
2284516 2284516 LA     school 2201290 040   Rapides Parish 220129001084 40048 Tioga High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284517 2284517 LA     school 2201290 040   Rapides Parish 220129001085 40049 Tioga Junior High School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284519 2284519 LA     school 2201290 040   Rapides Parish 220129000115 40054 Rapides Training Academy   Special Education School No Other KG 12 2019 spring grade_1                                                   0                                             0
2284521 2284521 LA     school 2201290 040   Rapides Parish 220129001944 40056 Hayden R. Lawrence Upper Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284524 2284524 LA     school   040   Rapides Parish   40700 Rapides Central Office             2019 spring grade_1                                                   0                                             0
2284525 2284525 LA     school 2201320 041   Red River Parish 220132001090 41002 Red River High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284526 2284526 LA     school 2201320 041   Red River Parish 220132000784 41008 Ware Youth Center   Regular School No Other KG 12 2019 spring grade_1                                                   0                                             0
2284528 2284528 LA     school 2201320 041   Red River Parish 220132001530 41011 Red River Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284529 2284529 LA     school 2201350 042   Richland Parish 220135001095 42001 Delhi High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284530 2284530 LA     school 2201350 042   Richland Parish 220135001096 42002 Delhi Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284534 2284534 LA     school 2201350 042   Richland Parish 220135001100 42006 Mangham High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284535 2284535 LA     school 2201350 042   Richland Parish 220135001101 42007 Mangham Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284536 2284536 LA     school 2201350 042   Richland Parish 220135001102 42008 Rayville High School   Career and Technical School No High 09 12 2019 spring grade_1                                                   0                                             0
2284537 2284537 LA     school 2201350 042   Richland Parish 220135001103 42009 Rayville Junior High School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284540 2284540 LA     school   042   Richland Parish   42700 Richland Central Office             2019 spring grade_1                                                   0                                             0
2284545 2284545 LA     school 2201380 043   Sabine Parish 220138001112 43006 Many High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284546 2284546 LA     school 2201380 043   Sabine Parish 220138001113 43007 Many Junior High School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284550 2284550 LA     school 2201380 043   Sabine Parish 220138001118 43012 Zwolle High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284552 2284552 LA     school 2201410 044   St. Bernard Parish 220141001125 44006 Chalmette High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284555 2284555 LA     school 2201410 044   St. Bernard Parish 220141001136 44017 N.P. Trist Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284556 2284556 LA     school 2201410 044   St. Bernard Parish 220141000816 44019 C.F. Rowley Alternative School   Regular School No High 06 12 2019 spring grade_1                                                   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]);