enrollments

Data source: Big Local News · About: Big Local

137,628 rows where state = "LA"

✎ 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
595041 595041 LA     school 2200570 018   East Carroll Parish 220057000457 18005 Southside Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   55                                             55
595042 595042 LA     school 2200600 019   East Feliciana Parish 220060000461 19002 East Feliciana Middle School   Regular School No Middle 06 08 2020 spring grade_1                                                   0                                             0
595043 595043 LA     school 2200600 019   East Feliciana Parish 220060000459 19003 Clinton Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   28                                             28
595044 595044 LA     school 2200600 019   East Feliciana Parish 220060000464 19007 Jackson Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   43                                             43
595045 595045 LA     school 2200600 019   East Feliciana Parish 220060000468 19009 Slaughter Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   62                                             62
595046 595046 LA     school 2200600 019   East Feliciana Parish 220060000715 19013 East Feliciana Parish Enrichment Academy   Regular School No Other 01 12 2020 spring grade_1                                                   0                                             0
595047 595047 LA     school 2200600 019   East Feliciana Parish 220060000465 19014 East Feliciana High School   Regular School No High 08 12 2020 spring grade_1                                                   0                                             0
595048 595048 LA     school 2200600 019   East Feliciana Parish 220060002321 19015 Slaughter Community Charter School   Regular School Yes High 07 12 2020 spring grade_1                                                   0                                             0
595049 595049 LA     school 2200630 020   Evangeline Parish 220063000470 20001 Basile High School   Regular School No Other 04 12 2020 spring grade_1                                                   0                                             0
595050 595050 LA     school 2200630 020   Evangeline Parish 220063000471 20002 Bayou Chicot Elementary School   Regular School No Elementary PK 08 2020 spring grade_1                                                   44                                             44
595051 595051 LA     school 2200630 020   Evangeline Parish 220063000473 20004 Chataignier Elementary School   Regular School No Elementary PK 08 2020 spring grade_1                                                   48                                             48
595052 595052 LA     school 2200630 020   Evangeline Parish 220063000476 20007 Mamou Elementary School   Regular School No Elementary PK 04 2020 spring grade_1                                                   87                                             87
595053 595053 LA     school 2200630 020   Evangeline Parish 220063000475 20008 Mamou High School   Regular School No Other 04 12 2020 spring grade_1                                                   0                                             0
595054 595054 LA     school 2200630 020   Evangeline Parish 220063000478 20010 Pine Prairie High School   Regular School No Other PK 12 2020 spring grade_1                                                   59                                             59
595055 595055 LA     school 2200630 020   Evangeline Parish 220063000480 20012 W. W. Stewart Elementary School   Regular School No Elementary PK 04 2020 spring grade_1                                                   52                                             52
595056 595056 LA     school 2200630 020   Evangeline Parish 220063000481 20013 Vidrine Elementary School   Regular School No Elementary PK 08 2020 spring grade_1                                                   39                                             39
595057 595057 LA     school 2200630 020   Evangeline Parish 220063000482 20014 Ville Platte High School   Regular School No High 07 12 2020 spring grade_1                                                   0                                             0
595058 595058 LA     school 2200630 020   Evangeline Parish 220063000483 20015 Ville Platte Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   78                                             78
595059 595059 LA     school 2200630 020   Evangeline Parish 220063001659 20019 James Stephens Montessori School   Regular School No Elementary PK 06 2020 spring grade_1                                                   67                                             67
595060 595060 LA     school   020   Evangeline Parish   20700 Evangeline Central Office             2020 spring grade_1                                                   0                                             0
595061 595061 LA     school 2200660 021   Franklin Parish 220066000484 21001 Baskin School   Regular School No Elementary PK 08 2020 spring grade_1                                                   28                                             28
595062 595062 LA     school 2200660 021   Franklin Parish 220066000486 21003 Fort Necessity School   Regular School No Elementary PK 08 2020 spring grade_1                                                   17                                             17
595063 595063 LA     school 2200660 021   Franklin Parish 220066000487 21004 Gilbert School   Regular School No Elementary PK 08 2020 spring grade_1                                                   52                                             52
595064 595064 LA     school 2200660 021   Franklin Parish 220066000489 21006 Crowville School   Regular School No Elementary PK 08 2020 spring grade_1                                                   46                                             46
595065 595065 LA     school 2200660 021   Franklin Parish 220066000490 21007 Franklin Parish High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595066 595066 LA     school 2200660 021   Franklin Parish 220066000496 21010 Winnsboro Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   90                                             90
595067 595067 LA     school   021   Franklin Parish   21026 Franklin Parish Head Start             2020 spring grade_1                                                   0                                             0
595068 595068 LA     school 2200690 022   Grant Parish 220069000497 22001 Colfax Elementary School   Regular School No Elementary KG 06 2020 spring grade_1                                                   18                                             18
595069 595069 LA     school 2200690 022   Grant Parish 220069000498 22002 Grant Junior High School   Regular School No Middle 07 08 2020 spring grade_1                                                   0                                             0
595070 595070 LA     school 2200690 022   Grant Parish 220069000500 22004 Georgetown High School   Regular School No Other PK 12 2020 spring grade_1                                                   14                                             14
595071 595071 LA     school 2200690 022   Grant Parish 220069000501 22005 Grant High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595072 595072 LA     school 2200690 022   Grant Parish 220069000502 22006 Montgomery High School   Regular School No High 07 12 2020 spring grade_1                                                   0                                             0
595073 595073 LA     school 2200690 022   Grant Parish 220069000503 22007 Pollock Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   70                                             70
595074 595074 LA     school 2200690 022   Grant Parish 220069000504 22008 Verda Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   37                                             37
595075 595075 LA     school 2200690 022   Grant Parish 220069000084 22010 South Grant Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   73                                             73
595076 595076 LA     school   022   Grant Parish   22700 Grant Central Office             2020 spring grade_1                                                   0                                             0
595077 595077 LA     school 2200720 023   Iberia Parish 220072000505 23001 Anderson Middle School   Regular School No Middle 07 08 2020 spring grade_1                                                   0                                             0
595078 595078 LA     school 2200720 023   Iberia Parish 220072000509 23005 Center Street Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   59                                             59
595079 595079 LA     school 2200720 023   Iberia Parish 220072000510 23006 Coteau Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   48                                             48
595080 595080 LA     school 2200720 023   Iberia Parish 220072000511 23007 Delcambre High School   Regular School No High 06 12 2020 spring grade_1                                                   0                                             0
595081 595081 LA     school 2200720 023   Iberia Parish 220072000514 23010 Johnston Hopkins Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   71                                             71
595082 595082 LA     school 2200720 023   Iberia Parish 220072000519 23015 Jeanerette Senior High School   Regular School No High 07 12 2020 spring grade_1                                                   0                                             0
595083 595083 LA     school 2200720 023   Iberia Parish 220072000522 23019 Loreauville Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   87                                             87
595084 595084 LA     school 2200720 023   Iberia Parish 220072000523 23020 Loreauville High School   Regular School No High 07 12 2020 spring grade_1                                                   0                                             0
595085 595085 LA     school 2200720 023   Iberia Parish 220072000525 23022 Westgate High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595086 595086 LA     school 2200720 023   Iberia Parish 220072000527 23024 New Iberia Senior High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595087 595087 LA     school 2200720 023   Iberia Parish 220072000528 23025 North Lewis Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   72                                             72
595088 595088 LA     school 2200720 023   Iberia Parish 220072000530 23027 Park Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   42                                             42
595089 595089 LA     school 2200720 023   Iberia Parish 220072000532 23029 Pesson Addition Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   56                                             56
595090 595090 LA     school 2200720 023   Iberia Parish 220072001585 23030 Delcambre Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   78                                             78
595091 595091 LA     school 2200720 023   Iberia Parish 220072001924 23033 St. Charles Street Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   51                                             51
595092 595092 LA     school 2200720 023   Iberia Parish 220072001925 23034 Daspit Road Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   78                                             78
595093 595093 LA     school 2200720 023   Iberia Parish 220072001926 23035 Sugarland Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   42                                             42
595094 595094 LA     school 2200720 023   Iberia Parish 220072001927 23036 Belle Place Middle School   Regular School No Middle 07 08 2020 spring grade_1                                                   0                                             0
595095 595095 LA     school 2200720 023   Iberia Parish 220072000316 23038 Iberia Middle School   Regular School No Middle 07 08 2020 spring grade_1                                                   0                                             0
595096 595096 LA     school 2200720 023   Iberia Parish 220072002085 23070 Jefferson Island Road Elementary   Regular School No Elementary PK 06 2020 spring grade_1                                                   69                                             69
595097 595097 LA     school 2200720 023   Iberia Parish 220072002078 23071 Magnolia Elementary   Regular School No Elementary PK 06 2020 spring grade_1                                                   80                                             80
595098 595098 LA     school 2200720 023   Iberia Parish 220072002260 23072 Caneview Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   90                                             90
595099 595099 LA     school   023   Iberia Parish   23073 Belle Place Elementary School             2020 spring grade_1                                                   46                                             46
595100 595100 LA     school   023   Iberia Parish   23700 Iberia Central Office             2020 spring grade_1                                                   0                                             0
595101 595101 LA     school 2200750 024   Iberville Parish 220075000536 24003 Crescent Elementary/Junior High School   Regular School No Elementary PK 06 2020 spring grade_1                                                   48                                             48
595102 595102 LA     school 2200750 024   Iberville Parish 220075000543 24010 Plaquemine Senior High School   Regular School No High 07 12 2020 spring grade_1                                                   0                                             0
595103 595103 LA     school 2200750 024   Iberville Parish 220075000550 24017 White Castle High School   Regular School No High 07 12 2020 spring grade_1                                                   0                                             0
595104 595104 LA     school 2200750 024   Iberville Parish 220075001980 24019 Dorseyville Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   64                                             64
595105 595105 LA     school 2200750 024   Iberville Parish 220075001997 24022 Iberville Elementary School   Regular School No Elementary PK 06 2020 spring grade_1                                                   130                                             130
595106 595106 LA     school 2200750 024   Iberville Parish 220075001998 24023 North Iberville Elementary   Regular School No Elementary PK 06 2020 spring grade_1                                                   30                                             30
595107 595107 LA     school 2200750 024   Iberville Parish 220075000231 24025 East Iberville Elementary/High School   Regular School No Other PK 12 2020 spring grade_1                                                   42                                             42
595108 595108 LA     school 2200780 025   Jackson Parish 220078000555 25005 Jonesboro-Hodge High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595109 595109 LA     school 2200780 025   Jackson Parish 220078000557 25006 Jonesboro-Hodge Middle School   Regular School No Middle 06 08 2020 spring grade_1                                                   0                                             0
595110 595110 LA     school 2200780 025   Jackson Parish 220078000556 25007 Quitman High School   Regular School No Other PK 12 2020 spring grade_1                                                   44                                             44
595111 595111 LA     school 2200780 025   Jackson Parish 220078000558 25008 Jonesboro-Hodge Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   58                                             58
595112 595112 LA     school 2200780 025   Jackson Parish 220078000560 25010 Weston High School   Regular School No Other PK 12 2020 spring grade_1                                                   45                                             45
595113 595113 LA     school   026   Jefferson Parish   26000 Administrative Services -- Special Education             2020 spring grade_1                                                   0                                             0
595114 595114 LA     school 2200840 026   Jefferson Parish 220084000576 26001 John Q. Adams Middle School   Regular School No Middle 06 08 2020 spring grade_1                                                   0                                             0
595115 595115 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_1                                                   64                                             64
595116 595116 LA     school 2200840 026   Jefferson Parish 220084001512 26005 John James Audubon School   Regular School No Elementary PK 08 2020 spring grade_1                                                   58                                             58
595117 595117 LA     school 2200840 026   Jefferson Parish 220084000583 26008 Alice Birney Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   84                                             84
595118 595118 LA     school 2200840 026   Jefferson Parish 220084000584 26009 Bissonet Plaza School   Regular School No Elementary PK 08 2020 spring grade_1                                                   73                                             73
595119 595119 LA     school 2200840 026   Jefferson Parish 220084000585 26010 Bonnabel Magnet Academy High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595120 595120 LA     school 2200840 026   Jefferson Parish 220084000587 26012 Mildred S. Harris Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   55                                             55
595121 595121 LA     school 2200840 026   Jefferson Parish 220084000588 26013 Bridgedale Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   107                                             107
595122 595122 LA     school 2200840 026   Jefferson Parish 220084000591 26016 George Cox Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   66                                             66
595123 595123 LA     school 2200840 026   Jefferson Parish 220084000592 26017 Helen Cox High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595124 595124 LA     school 2200840 026   Jefferson Parish 220084000595 26020 Ella Dolhonde Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   110                                             110
595125 595125 LA     school 2200840 026   Jefferson Parish 220084002416 26021 Frederick Douglass Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   50                                             50
595126 595126 LA     school 2200840 026   Jefferson Parish 220084000597 26022 East Jefferson High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595127 595127 LA     school 2200840 026   Jefferson Parish 220084000598 26023 John Ehret High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
595128 595128 LA     school 2200840 026   Jefferson Parish 220084000599 26024 Allen Ellender School   Regular School No Elementary PK 08 2020 spring grade_1                                                   65                                             65
595129 595129 LA     school 2200840 026   Jefferson Parish 220084000600 26025 J.C. Ellis School   Regular School No Elementary PK 08 2020 spring grade_1                                                   76                                             76
595130 595130 LA     school 2200840 026   Jefferson Parish 220084002417 26026 Bonella A. St. Ville Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   73                                             73
595131 595131 LA     school 2200840 026   Jefferson Parish 220084000602 26027 Estelle School   Regular School No Elementary PK 08 2020 spring grade_1                                                   79                                             79
595132 595132 LA     school 2200840 026   Jefferson Parish 220084000604 26029 Fisher Middle/High School   Regular School No High 06 12 2020 spring grade_1                                                   0                                             0
595133 595133 LA     school 2200840 026   Jefferson Parish 220084000605 26030 Emmett C.Gilbert School of Excellence at Ford   Regular School No Elementary PK 08 2020 spring grade_1                                                   76                                             76
595134 595134 LA     school 2200840 026   Jefferson Parish 220084000606 26031 Grand Isle High School   Regular School No Other PK 12 2020 spring grade_1                                                   12                                             12
595135 595135 LA     school 2200840 026   Jefferson Parish 220084000608 26032 Green Park Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   74                                             74
595136 595136 LA     school 2200840 026   Jefferson Parish 220084000607 26033 Greenlawn Terrace Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   78                                             78
595137 595137 LA     school 2200840 026   Jefferson Parish 220084000609 26035 Gretna Middle School   Regular School No Middle 06 08 2020 spring grade_1                                                   0                                             0
595138 595138 LA     school 2200840 026   Jefferson Parish 220084000612 26036 Shirley Johnson/Gretna Park Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   118                                             118
595139 595139 LA     school 2200840 026   Jefferson Parish 220084000613 26038 Harahan Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   78                                             78
595140 595140 LA     school 2200840 026   Jefferson Parish 220084000614 26039 T.H. Harris Middle School   Regular School No Middle 06 08 2020 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]);