Data source: Big Local News · About: Big Local

8,427 rows where grade = "grade_3" and state = "LA" sorted by total

View and edit SQL

year

grade

  • grade_3 · 8,227
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
602095 LA     school 2200720 023   Iberia Parish 220072000316 23038 Iberia Middle School   Regular School No Middle 07 08 2020 spring grade_3                                                   0                                             0
602100 LA     school   023   Iberia Parish   23700 Iberia Central Office             2020 spring grade_3                                                   0                                             0
602102 LA     school 2200750 024   Iberville Parish 220075000543 24010 Plaquemine Senior High School   Regular School No High 07 12 2020 spring grade_3                                                   0                                             0
602103 LA     school 2200750 024   Iberville Parish 220075000550 24017 White Castle High School   Regular School No High 07 12 2020 spring grade_3                                                   0                                             0
602108 LA     school 2200780 025   Jackson Parish 220078000555 25005 Jonesboro-Hodge High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602109 LA     school 2200780 025   Jackson Parish 220078000557 25006 Jonesboro-Hodge Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602113 LA     school   026   Jefferson Parish   26000 Administrative Services -- Special Education             2020 spring grade_3                                                   0                                             0
602114 LA     school 2200840 026   Jefferson Parish 220084000576 26001 John Q. Adams Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602119 LA     school 2200840 026   Jefferson Parish 220084000585 26010 Bonnabel Magnet Academy High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602123 LA     school 2200840 026   Jefferson Parish 220084000592 26017 Helen Cox High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602126 LA     school 2200840 026   Jefferson Parish 220084000597 26022 East Jefferson High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602127 LA     school 2200840 026   Jefferson Parish 220084000598 26023 John Ehret High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602132 LA     school 2200840 026   Jefferson Parish 220084000604 26029 Fisher Middle/High School   Regular School No High 06 12 2020 spring grade_3                                                   0                                             0
602137 LA     school 2200840 026   Jefferson Parish 220084000609 26035 Gretna Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602140 LA     school 2200840 026   Jefferson Parish 220084000614 26039 T.H. Harris Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602142 LA     school 2200840 026   Jefferson Parish 220084000617 26042 Haynes Academy School for Advanced Studies   Regular School No High 06 12 2020 spring grade_3                                                   0                                             0
602145 LA     school 2200840 026   Jefferson Parish 220084000620 26045 L.W. Higgins High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602148 LA     school 2200840 026   Jefferson Parish 220084000625 26051 Grace King High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602149 LA     school 2200840 026   Jefferson Parish 220084000630 26056 Livaudais Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602150 LA     school 2200840 026   Jefferson Parish 220084000632 26058 L.H. Marrero Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602153 LA     school 2200840 026   Jefferson Parish 220084000636 26062 J.D. Meisler Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602157 LA     school 2200840 026   Jefferson Parish 220084000642 26068 Riverdale High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602162 LA     school 2200840 026   Jefferson Parish 220084000654 26080 West Jefferson High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602166 LA     school 2200840 026   Jefferson Parish 220084000658 26085 Stella Worley Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602176 LA     school 2200840 026   Jefferson Parish 220084000320 26100 Riverdale Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602178 LA     school 2200840 026   Jefferson Parish 220084001667 26105 Patrick F. Taylor Science & Technology Academy   Regular School No High 06 12 2020 spring grade_3                                                   0                                             0
602179 LA     school 2200840 026   Jefferson Parish 220084001964 26107 Thomas Jefferson High School for Advanced Studies   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602181 LA     school 2200840 026   Jefferson Parish 220084002051 26111 L. W. Ruppel Academy for Advanced Studies   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602182 LA     school 2200840 026   Jefferson Parish 220084002044 26112 Strehle Community School   Regular School No High 08 12 2020 spring grade_3                                                   0                                             0
602189 LA     school 2200840 026   Jefferson Parish 220084002305 26123 JCFA   Regular School Yes High 08 12 2020 spring grade_3                                                   0                                             0
602193 LA     school 2200840 026   Jefferson Parish 220084002419 26128 Jefferson RISE Charter School   Regular School Yes Middle 06 10 2020 spring grade_3                                                   0                                             0
602195 LA     school 2200840 026   Jefferson Parish 220084002478 26130 Young Audiences Charter High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602197 LA     school   027   Jefferson Davis Parish   27000 Administrative Services -- Special Education             2020 spring grade_3                                                   0                                             0
602198 LA     school 2200810 027   Jefferson Davis Parish 220081000561 27001 Elton High School   Regular School No High 06 12 2020 spring grade_3                                                   0                                             0
602202 LA     school 2200810 027   Jefferson Davis Parish 220081000566 27006 Jennings High School   Regular School No High 07 12 2020 spring grade_3                                                   0                                             0
602203 LA     school 2200810 027   Jefferson Davis Parish 220081000568 27008 James Ward Elementary School   Regular School No Elementary PK 02 2020 spring grade_3                                                   0                                             0
602207 LA     school 2200810 027   Jefferson Davis Parish 220081000572 27012 Lake Arthur High School   Regular School No High 07 12 2020 spring grade_3                                                   0                                             0
602209 LA     school 2200810 027   Jefferson Davis Parish 220081000574 27014 Welsh High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602210 LA     school 2200810 027   Jefferson Davis Parish 220081000575 27015 Welsh-Roanoke Junior High School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602211 LA     school 2200870 028   Lafayette Parish 220087000659 28001 Acadian Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602212 LA     school 2200870 028   Lafayette Parish 220087000660 28002 Acadiana High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602213 LA     school 2200870 028   Lafayette Parish 220087000661 28003 L.J. Alleman Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602215 LA     school 2200870 028   Lafayette Parish 220087000663 28005 Paul Breaux Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602217 LA     school 2200870 028   Lafayette Parish 220087000665 28007 Broussard Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602218 LA     school 2200870 028   Lafayette Parish 220087000666 28008 Carencro Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602220 LA     school 2200870 028   Lafayette Parish 220087000668 28010 Carencro High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602221 LA     school 2200870 028   Lafayette Parish 220087000669 28011 O. Comeaux High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602225 LA     school 2200870 028   Lafayette Parish 220087000675 28016 Judice Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602227 LA     school 2200870 028   Lafayette Parish 220087000677 28018 Lafayette Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602228 LA     school 2200870 028   Lafayette Parish 220087000678 28019 Lafayette High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602230 LA     school 2200870 028   Lafayette Parish 220087000681 28022 Edgar Martin Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602234 LA     school 2200870 028   Lafayette Parish 220087000686 28027 Northside High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602238 LA     school 2200870 028   Lafayette Parish 220087000690 28032 Scott Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602239 LA     school 2200870 028   Lafayette Parish 220087000691 28033 Truman Early Childhood Education Center   Regular School No Prekindergarten PK PK 2020 spring grade_3                                                   0                                             0
602242 LA     school 2200870 028   Lafayette Parish 220087000695 28038 Youngsville Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602250 LA     school 2200870 028   Lafayette Parish 220087002072 28053 Early College Academy   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602251 LA     school 2200870 028   Lafayette Parish 220087002301 28054 David Thibodaux STEM Magnet Academy   Career and Technical School No High 06 12 2020 spring grade_3                                                   0                                             0
602252 LA     school 2200870 028   Lafayette Parish 220087002442 28055 Southside High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602253 LA     school 2200870 028   Lafayette Parish 220087002441 28056 Edward J Sam Accelerated School of Lafayette   Regular School No High 07 12 2020 spring grade_3                                                   0                                             0
602256 LA     school   028   Lafayette Parish   28700 Lafayette Central Office             2020 spring grade_3                                                   0                                             0
602257 LA     school 2200900 029   Lafourche Parish 220090000697 29001 Bayou Blue Elementary School   Regular School No Elementary PK 02 2020 spring grade_3                                                   0                                             0
602259 LA     school 2200900 029   Lafourche Parish 220090000699 29003 Central Lafourche High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602262 LA     school 2200900 029   Lafourche Parish 220090000703 29006 East Thibodaux Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602264 LA     school 2200900 029   Lafourche Parish 220090000706 29009 Golden Meadow Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602265 LA     school 2200900 029   Lafourche Parish 220090000707 29010 Golden Meadow Lower Elementary School   Regular School No Elementary PK 02 2020 spring grade_3                                                   0                                             0
602270 LA     school 2200900 029   Lafourche Parish 220090000711 29015 Larose-Cut Off Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602271 LA     school 2200900 029   Lafourche Parish 220090000712 29016 Lockport Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602272 LA     school 2200900 029   Lafourche Parish 220090000713 29017 Lockport Lower Elementary School   Regular School No Elementary PK 02 2020 spring grade_3                                                   0                                             0
602274 LA     school 2200900 029   Lafourche Parish 220090000716 29020 Raceland Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602275 LA     school 2200900 029   Lafourche Parish 220090000717 29021 Raceland Lower Elementary School   Regular School No Elementary PK 02 2020 spring grade_3                                                   0                                             0
602278 LA     school 2200900 029   Lafourche Parish 220090000701 29024 Sixth Ward Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602279 LA     school 2200900 029   Lafourche Parish 220090000721 29026 South Lafourche High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602280 LA     school 2200900 029   Lafourche Parish 220090000722 29027 C.M. Washington Elementary School   Regular School No Elementary 04 05 2020 spring grade_3                                                   0                                             0
602281 LA     school 2200900 029   Lafourche Parish 220090000724 29028 Thibodaux Elementary School   Regular School No Elementary PK 01 2020 spring grade_3                                                   0                                             0
602282 LA     school 2200900 029   Lafourche Parish 220090000725 29029 Thibodaux High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602283 LA     school 2200900 029   Lafourche Parish 220090000727 29030 West Thibodaux Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602284 LA     school 2200900 029   Lafourche Parish 220090001968 29038 Bayou Blue Middle School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602288 LA     school   029   Lafourche Parish   29700 Lafourche Central Office             2020 spring grade_3                                                   0                                             0
602291 LA     school 2200960 030   LaSalle Parish 220096000731 30003 Jena Elementary School   Regular School No Elementary PK 02 2020 spring grade_3                                                   0                                             0
602292 LA     school 2200960 030   LaSalle Parish 220096000732 30004 Jena High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602293 LA     school 2200960 030   LaSalle Parish 220096000733 30005 Jena Junior High School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602294 LA     school 2200960 030   LaSalle Parish 220096000734 30006 LaSalle High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602297 LA     school 2200960 030   LaSalle Parish 220096000738 30010 LaSalle Junior High School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602298 LA     school 2200990 031   Lincoln Parish 220099000742 31003 Choudrant High School   Regular School No High 07 12 2020 spring grade_3                                                   0                                             0
602301 LA     school 2200990 031   Lincoln Parish 220099000745 31006 Glen View Elementary School   Regular School No Elementary KG 02 2020 spring grade_3                                                   0                                             0
602302 LA     school 2200990 031   Lincoln Parish 220099000747 31008 Hillcrest Elementary School   Regular School No Elementary KG 02 2020 spring grade_3                                                   0                                             0
602303 LA     school 2200990 031   Lincoln Parish 220099000748 31009 I.A. Lewis School   Regular School No Middle 06 06 2020 spring grade_3                                                   0                                             0
602306 LA     school 2200990 031   Lincoln Parish 220099000752 31013 Ruston High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
602308 LA     school 2200990 031   Lincoln Parish 220099001815 31018 Ruston Junior High School   Regular School No Middle 07 08 2020 spring grade_3                                                   0                                             0
602310 LA     school   031   Lincoln Parish   31022 Howard School             2020 spring grade_3                                                   0                                             0
602311 LA     school 2200990 031   Lincoln Parish 220099002304 31023 Lincoln Parish Early Childhood Center   Regular School No Prekindergarten PK PK 2020 spring grade_3                                                   0                                             0
602312 LA     school   031   Lincoln Parish   31700 Lincoln Central Office             2020 spring grade_3                                                   0                                             0
602313 LA     school 2201020 032   Livingston Parish 220102000754 32001 Albany Lower Elementary School   Regular School No Elementary PK 02 2020 spring grade_3                                                   0                                             0
602314 LA     school 2201020 032   Livingston Parish 220102000755 32002 Albany High School   Regular School No High 08 12 2020 spring grade_3                                                   0                                             0
602317 LA     school 2201020 032   Livingston Parish 220102000758 32005 Denham Springs High School   Regular School No High 10 12 2020 spring grade_3                                                   0                                             0
602318 LA     school 2201020 032   Livingston Parish 220102000759 32006 Denham Springs Junior High School   Regular School No Middle 06 08 2020 spring grade_3                                                   0                                             0
602320 LA     school 2201020 032   Livingston Parish 220102000761 32008 Doyle High School   Regular School No High 06 12 2020 spring grade_3                                                   0                                             0
602321 LA     school 2201020 032   Livingston Parish 220102000762 32009 French Settlement High School   Regular School No High 07 12 2020 spring grade_3                                                   0                                             0
602326 LA     school 2201020 032   Livingston Parish 220102000767 32014 Live Oak High School   Regular School No High 08 12 2020 spring grade_3                                                   0                                             0
602327 LA     school 2201020 032   Livingston Parish 220102001558 32015 Live Oak Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   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]);