enrollments

Data source: Big Local News · About: Big Local

44,816 rows where state = "LA" and year = 2020 sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 43,692 ✖
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
605877 605877 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 spring grade_6                                                   0                                             0
605878 605878 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 spring grade_6                                                   0                                             0
605879 605879 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 spring grade_6                                                   106                                             106
605880 605880 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 spring grade_6                                                   36                                             36
605881 605881 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2020 spring grade_6                                                   0                                             0
605882 605882 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2020 spring grade_6                                                   21                                             21
605883 605883 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2020 spring grade_6                                                   108                                             108
605884 605884 LA     school   002   Allen Parish   2700 Allen Central Office             2020 spring grade_6                                                   0                                             0
607273 607273 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_7                                                   42                                             42
607274 607274 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_7                                                   32                                             32
607275 607275 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_7                                                   0                                             0
607276 607276 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 spring grade_7                                                   0                                             0
607277 607277 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 spring grade_7                                                   0                                             0
607278 607278 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 spring grade_7                                                   0                                             0
607279 607279 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 spring grade_7                                                   84                                             84
607280 607280 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 spring grade_7                                                   0                                             0
607281 607281 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2020 spring grade_7                                                   47                                             47
607282 607282 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2020 spring grade_7                                                   27                                             27
607283 607283 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2020 spring grade_7                                                   117                                             117
607284 607284 LA     school   002   Allen Parish   2700 Allen Central Office             2020 spring grade_7                                                   0                                             0
608673 608673 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_8                                                   23                                             23
608674 608674 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_8                                                   30                                             30
608675 608675 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_8                                                   0                                             0
608676 608676 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 spring grade_8                                                   0                                             0
608677 608677 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 spring grade_8                                                   0                                             0
608678 608678 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 spring grade_8                                                   0                                             0
608679 608679 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 spring grade_8                                                   96                                             96
608680 608680 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 spring grade_8                                                   0                                             0
608681 608681 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2020 spring grade_8                                                   44                                             44
608682 608682 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2020 spring grade_8                                                   15                                             15
608683 608683 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2020 spring grade_8                                                   98                                             98
608684 608684 LA     school   002   Allen Parish   2700 Allen Central Office             2020 spring grade_8                                                   0                                             0
610073 610073 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_9                                                   28                                             28
610074 610074 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_9                                                   21                                             21
610075 610075 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_9                                                   0                                             0
610076 610076 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 spring grade_9                                                   97                                             97
610077 610077 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 spring grade_9                                                   0                                             0
610078 610078 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 spring grade_9                                                   56                                             56
610079 610079 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 spring grade_9                                                   0                                             0
610080 610080 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 spring grade_9                                                   0                                             0
610081 610081 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2020 spring grade_9                                                   43                                             43
610082 610082 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2020 spring grade_9                                                   25                                             25
610083 610083 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2020 spring grade_9                                                   0                                             0
610084 610084 LA     school   002   Allen Parish   2700 Allen Central Office             2020 spring grade_9                                                   0                                             0
611473 611473 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_9_transitional                                                   7                                             7
611474 611474 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_9_transitional                                                   4                                             4
611475 611475 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_9_transitional                                                   0                                             0
611476 611476 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 spring grade_9_transitional                                                   1                                             1
611477 611477 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 spring grade_9_transitional                                                   0                                             0
611478 611478 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 spring grade_9_transitional                                                   15                                             15
611479 611479 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 spring grade_9_transitional                                                   0                                             0
611480 611480 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 spring grade_9_transitional                                                   0                                             0
611481 611481 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2020 spring grade_9_transitional                                                   0                                             0
611482 611482 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2020 spring grade_9_transitional                                                   1                                             1
611483 611483 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2020 spring grade_9_transitional                                                   0                                             0
611484 611484 LA     school   002   Allen Parish   2700 Allen Central Office             2020 spring grade_9_transitional                                                   0                                             0
612873 612873 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring kindergarten                                                   25                                             25
612874 612874 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring kindergarten                                                   32                                             32
612875 612875 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring kindergarten                                                   100                                             100
612876 612876 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 spring kindergarten                                                   0                                             0
612877 612877 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 spring kindergarten                                                   92                                             92
612878 612878 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 spring kindergarten                                                   0                                             0
612879 612879 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 spring kindergarten                                                   0                                             0
612880 612880 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 spring kindergarten                                                   38                                             38
612881 612881 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2020 spring kindergarten                                                   0                                             0
612882 612882 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2020 spring kindergarten                                                   15                                             15
612883 612883 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2020 spring kindergarten                                                   0                                             0
612884 612884 LA     school   002   Allen Parish   2700 Allen Central Office             2020 spring kindergarten                                                   0                                             0
614273 614273 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring pk_12_total 383.0 6.0 6.0 0.0   3.0     0.0   9.0   205.0 202.0     0.0       239.0         407 383 6 6 0   3     0   9   205 202     0   239       407
614274 614274 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring pk_12_total 344.0 1.0 4.0 0.0   13.0     0.0   7.0   168.0 201.0     4.0       246.0         369 344 1 4 0   13     0   7   168 201     4   246       369
614275 614275 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring pk_12_total 378.0 108.0 11.0 11.0   4.0     0.0   47.0   309.0 250.0     1.0       375.0         559 378 108 11 11   4     0   47   309 250     1   375       559
614276 614276 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 spring pk_12_total 255.0 68.0 4.0 10.0   4.0     1.0   16.0   191.0 167.0     3.0       192.0         358 255 68 4 10   4     1   16   191 167     3   192       358
614277 614277 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 spring pk_12_total 354.0 162.0 12.0 2.0   3.0     0.0   36.0   311.00000000000006 258.0     0.0       450.0         569 354 162 12 2   3     0   36     258     0   450       569
614278 614278 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 spring pk_12_total 175.0 95.0 6.0 0.0   3.0     0.0   1.0   141.0 139.0     0.0       199.0         280 175 95 6 0   3     0   1   141 139     0   199       280
614279 614279 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 spring pk_12_total 241.0 108.0 12.0 1.0   2.0     0.0   13.0   196.0 181.0     2.0       270.0         377 241 108 12 1   2     0   13   196 181     2   270       377
614280 614280 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 spring pk_12_total 179.0 81.0 2.0 3.0   1.0     0.0   24.0   158.0 132.0     0.0       207.0         290 179 81 2 3   1     0   24   158 132     0   207       290
614281 614281 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2020 spring pk_12_total 147.0 85.0 0.0 3.0   0.0     0.0   16.0   132.0 119.0     0.0       177.0         251 147 85 0 3   0     0   16   132 119     0   177       251
614282 614282 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2020 spring pk_12_total 264.0 13.0 4.0 2.0   2.0     0.0   2.0   151.0 136.0     2.0       223.0         287 264 13 4 2   2     0   2   151 136     2   223       287
614283 614283 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2020 spring pk_12_total 281.0 83.0 6.0 4.0   9.0     0.0   28.0   207.00000000000003 204.0     5.0       261.0         411 281 83 6 4   9     0   28     204     5   261       411
614284 614284 LA     school   002   Allen Parish   2700 Allen Central Office             2020 spring pk_12_total 1.0 0.0 0.0 0.0   0.0     0.0   0.0   0.0 1.0     0.0       1.0         1 1 0 0 0   0     0   0   0 1     0   1       1
615673 615673 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   20                                             20
615674 615674 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   16                                             16
615675 615675 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring pre_kindergarten                                                   71                                             71
615676 615676 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 spring pre_kindergarten                                                   0                                             0
615677 615677 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 spring pre_kindergarten                                                   77                                             77
615678 615678 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 spring pre_kindergarten                                                   0                                             0
615679 615679 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 spring pre_kindergarten                                                   0                                             0
615680 615680 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 spring pre_kindergarten                                                   37                                             37
615681 615681 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2020 spring pre_kindergarten                                                   0                                             0
615682 615682 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   18                                             18
615683 615683 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2020 spring pre_kindergarten                                                   0                                             0
615684 615684 LA     school   002   Allen Parish   2700 Allen Central Office             2020 spring pre_kindergarten                                                   0                                             0
2011096 2011096 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_1                                                   30                                             30
2011097 2011097 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_1                                                   28                                             28
2011098 2011098 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 fall grade_1                                                   103                                             103
2011099 2011099 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 fall grade_1                                                   0                                             0
2011100 2011100 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2020 fall grade_1                                                   115                                             115
2011101 2011101 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2020 fall grade_1                                                   0                                             0
2011102 2011102 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2020 fall grade_1                                                   0                                             0
2011103 2011103 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2020 fall grade_1                                                   45                                             45

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