Data source: Big Local News · About: Big Local

2,830 rows where grade = "grade_8", state = "LA" and year = 2019 sorted by school_nces_id

View and edit SQL

year

  • 2019 · 2,796

grade

  • grade_8 · 2,796
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
2297810 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2019 spring grade_8                                                   0                                             0
2532205 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2019 fall grade_8                                                   0                                             0
2297811 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2019 spring grade_8                                                   27                                             27
2532206 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2019 fall grade_8                                                   26                                             26
2297812 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2019 spring grade_8                                                   0                                             0
2532207 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2019 fall grade_8                                                   0                                             0
2297827 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2019 spring grade_8                                                   0                                             0
2532222 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2019 fall grade_8                                                   0                                             0
2297814 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2019 spring grade_8                                                   0                                             0
2532209 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2019 fall grade_8                                                   0                                             0
2297815 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2019 spring grade_8                                                   67                                             67
2532210 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2019 fall grade_8                                                   67                                             67
2297816 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2019 spring grade_8                                                   66                                             66
2532211 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2019 fall grade_8                                                   64                                             64
2297817 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2019 spring grade_8                                                   0                                             0
2532212 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2019 fall grade_8                                                   0                                             0
2297819 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2019 spring grade_8                                                   1                                             1
2532214 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2019 fall grade_8                                                   1                                             1
2297820 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2019 spring grade_8                                                   54                                             54
2532215 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2019 fall grade_8                                                   56                                             56
2297821 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary KG 06 2019 spring grade_8                                                   0                                             0
2532216 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary KG 06 2019 fall grade_8                                                   0                                             0
2297822 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary KG 05 2019 spring grade_8                                                   0                                             0
2532217 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary KG 05 2019 fall grade_8                                                   0                                             0
2297823 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2019 spring grade_8                                                   0                                             0
2532218 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2019 fall grade_8                                                   0                                             0
2297813 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2019 spring grade_8                                                   88                                             88
2532208 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2019 fall grade_8                                                   92                                             92
2297818 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2019 spring grade_8                                                   0                                             0
2532213 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2019 fall grade_8                                                   0                                             0
2297802 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_8                                                   0                                             0
2532197 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_8                                                   0                                             0
2297829 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2019 spring grade_8                                                   6                                             6
2532224 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2019 fall grade_8                                                   10                                             10
2299097 LA     school 2200036 334   New Orleans Center for Creative Arts 220003601499 334001 New Orleans Center for Creative Arts   Special Education School No High 09 12 2019 spring grade_8                                                   0                                             0
2533495 LA     school 2200036 334   New Orleans Center for Creative Arts 220003601499 334001 New Orleans Center for Creative Arts   Special Education School No High 09 12 2019 fall grade_8                                                   0                                             0
2299051 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 spring grade_8                                                   0                                             0
2533449 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_8                                                   0                                             0
2299052 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 spring grade_8                                                   418                                             418
2533450 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_8                                                   414                                             414
2299053 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 spring grade_8                                                   0                                             0
2533451 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_8                                                   0                                             0
2299054 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 spring grade_8                                                   0                                             0
2533452 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_8                                                   0                                             0
2299055 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 spring grade_8                                                   0                                             0
2533453 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_8                                                   0                                             0
2299056 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 spring grade_8                                                   0                                             0
2533454 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_8                                                   0                                             0
2299057 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 spring grade_8                                                   0                                             0
2533455 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_8                                                   0                                             0
2299059 LA     school 2200040 068   City of Baker School District 220004000342 68001 Baker Heights Elementary School   Regular School No Elementary PK 05 2019 spring grade_8                                                   0                                             0
2533457 LA     school 2200040 068   City of Baker School District 220004000342 68001 Baker Heights Elementary School   Regular School No Elementary PK 05 2019 fall grade_8                                                   0                                             0
2299061 LA     school 2200040 068   City of Baker School District 220004000343 68003 Baker Middle School   Regular School No Middle 06 08 2019 spring grade_8                                                   84                                             84
2533459 LA     school 2200040 068   City of Baker School District 220004000343 68003 Baker Middle School   Regular School No Middle 06 08 2019 fall grade_8                                                   79                                             79
2299060 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2019 spring grade_8                                                   0                                             0
2533458 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2019 fall grade_8                                                   0                                             0
2299062 LA     school 2200040 068   City of Baker School District 220004000345 68004 Bakerfield Elementary School   Regular School No Elementary PK 05 2019 spring grade_8                                                   0                                             0
2533460 LA     school 2200040 068   City of Baker School District 220004000345 68004 Bakerfield Elementary School   Regular School No Elementary PK 05 2019 fall grade_8                                                   0                                             0
2299063 LA     school 2200040 068   City of Baker School District 220004000410 68005 Park Ridge Academic Magnet School   Regular School No Elementary KG 08 2019 spring grade_8                                                   33                                             33
2533461 LA     school 2200040 068   City of Baker School District 220004000410 68005 Park Ridge Academic Magnet School   Regular School No Elementary KG 08 2019 fall grade_8                                                   32                                             32
2299157 LA     school 2200047 A02   Office of Juvenile Justice 220004701780 A02002 Riverside Alternative High School   Alternative School No Other 01 12 2019 spring grade_8                                                   2                                             2
2533556 LA     school 2200047 A02   Office of Juvenile Justice 220004701780 A02002 Riverside Alternative High School   Alternative School No Other 01 12 2019 fall grade_8                                                   1                                             1
2299158 LA     school 2200047 A02   Office of Juvenile Justice 220004701781 A02003 Southside Alternative High School   Alternative School No Other 01 12 2019 spring grade_8                                                   6                                             6
2533557 LA     school 2200047 A02   Office of Juvenile Justice 220004701781 A02003 Southside Alternative High School   Alternative School No Other 01 12 2019 fall grade_8                                                   6                                             6
2299136 LA     school 2200054 RLA   RSD-Direct Run 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2019 spring grade_8                                                   99                                             99
2297831 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_8                                                   37                                             37
2532226 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_8                                                   37                                             37
2297832 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_8                                                   27                                             27
2532227 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_8                                                   26                                             26
2297833 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring grade_8                                                   0                                             0
2532228 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 fall grade_8                                                   0                                             0
2297834 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring grade_8                                                   0                                             0
2532229 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 fall grade_8                                                   0                                             0
2297835 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring grade_8                                                   0                                             0
2532230 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 fall grade_8                                                   0                                             0
2297836 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring grade_8                                                   0                                             0
2532231 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 fall grade_8                                                   0                                             0
2297837 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring grade_8                                                   70                                             70
2532232 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 fall grade_8                                                   74                                             74
2297838 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring grade_8                                                   0                                             0
2532233 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 fall grade_8                                                   0                                             0
2297839 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring grade_8                                                   46                                             46
2532234 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 fall grade_8                                                   45                                             45
2297840 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring grade_8                                                   27                                             27
2532235 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 fall grade_8                                                   28                                             28
2297841 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring grade_8                                                   98                                             98
2532236 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 fall grade_8                                                   101                                             101
2297842 LA     school 2200090 003   Ascension Parish 220009000034 3001 G. W. Carver Primary School   Regular School No Elementary PK 05 2019 spring grade_8                                                   0                                             0
2532237 LA     school 2200090 003   Ascension Parish 220009000034 3001 G. W. Carver Primary School   Regular School No Elementary PK 05 2019 fall grade_8                                                   0                                             0
2297843 LA     school 2200090 003   Ascension Parish 220009000035 3002 Donaldsonville Primary School   Regular School No Elementary PK 02 2019 spring grade_8                                                   0                                             0
2532238 LA     school 2200090 003   Ascension Parish 220009000035 3002 Donaldsonville Primary School   Regular School No Elementary PK 02 2019 fall grade_8                                                   0                                             0
2297844 LA     school 2200090 003   Ascension Parish 220009000036 3003 Donaldsonville High School   Regular School No High 09 12 2019 spring grade_8                                                   0                                             0
2532239 LA     school 2200090 003   Ascension Parish 220009000036 3003 Donaldsonville High School   Regular School No High 09 12 2019 fall grade_8                                                   0                                             0
2297845 LA     school 2200090 003   Ascension Parish 220009000037 3004 Dutchtown Middle School   Regular School No Middle 06 08 2019 spring grade_8                                                   301                                             301
2532240 LA     school 2200090 003   Ascension Parish 220009000037 3004 Dutchtown Middle School   Regular School No Middle 06 08 2019 fall grade_8                                                   298                                             298
2297846 LA     school 2200090 003   Ascension Parish 220009000038 3005 East Ascension High School   Regular School No High 09 12 2019 spring grade_8                                                   0                                             0
2532241 LA     school 2200090 003   Ascension Parish 220009000038 3005 East Ascension High School   Regular School No High 09 12 2019 fall grade_8                                                   0                                             0
2297847 LA     school 2200090 003   Ascension Parish 220009000039 3006 Galvez Middle School   Regular School No Middle 06 08 2019 spring grade_8                                                   212                                             212
2532242 LA     school 2200090 003   Ascension Parish 220009000039 3006 Galvez Middle School   Regular School No Middle 06 08 2019 fall grade_8                                                   210                                             210
2297848 LA     school 2200090 003   Ascension Parish 220009000040 3007 Gonzales Middle School   Regular School No Middle 06 08 2019 spring grade_8                                                   259                                             259

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]);