enrollments

Data source: Big Local News · About: Big Local

45,280 rows where state = "LA" and year = 2019 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 43,607 ✖
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
2295006 2295006 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_6                                                   30                                             30
2295007 2295007 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring grade_6                                                   0                                             0
2295008 2295008 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring grade_6                                                   0                                             0
2295009 2295009 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring grade_6                                                   0                                             0
2295010 2295010 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring grade_6                                                   0                                             0
2295011 2295011 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring grade_6                                                   89                                             89
2295012 2295012 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring grade_6                                                   44                                             44
2295013 2295013 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring grade_6                                                   0                                             0
2295014 2295014 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring grade_6                                                   19                                             19
2295015 2295015 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring grade_6                                                   126                                             126
2296418 2296418 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_7                                                   26                                             26
2296419 2296419 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_7                                                   31                                             31
2296420 2296420 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring grade_7                                                   0                                             0
2296421 2296421 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring grade_7                                                   0                                             0
2296422 2296422 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring grade_7                                                   0                                             0
2296423 2296423 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring grade_7                                                   0                                             0
2296424 2296424 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring grade_7                                                   97                                             97
2296425 2296425 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring grade_7                                                   0                                             0
2296426 2296426 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring grade_7                                                   43                                             43
2296427 2296427 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring grade_7                                                   16                                             16
2296428 2296428 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring grade_7                                                   102                                             102
2297831 2297831 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_8                                                   37                                             37
2297832 2297832 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_8                                                   27                                             27
2297833 2297833 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring grade_8                                                   0                                             0
2297834 2297834 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring grade_8                                                   0                                             0
2297835 2297835 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring grade_8                                                   0                                             0
2297836 2297836 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring grade_8                                                   0                                             0
2297837 2297837 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring grade_8                                                   70                                             70
2297838 2297838 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring grade_8                                                   0                                             0
2297839 2297839 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring grade_8                                                   46                                             46
2297840 2297840 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring grade_8                                                   27                                             27
2297841 2297841 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring grade_8                                                   98                                             98
2299244 2299244 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_9                                                   26                                             26
2299245 2299245 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_9                                                   21                                             21
2299246 2299246 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring grade_9                                                   0                                             0
2299247 2299247 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring grade_9                                                   107                                             107
2299248 2299248 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring grade_9                                                   0                                             0
2299249 2299249 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring grade_9                                                   80                                             80
2299250 2299250 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring grade_9                                                   0                                             0
2299251 2299251 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring grade_9                                                   0                                             0
2299252 2299252 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring grade_9                                                   34                                             34
2299253 2299253 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring grade_9                                                   10                                             10
2299254 2299254 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring grade_9                                                   0                                             0
2300657 2300657 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_9_transitional                                                   0                                             0
2300658 2300658 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_9_transitional                                                   3                                             3
2300659 2300659 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring grade_9_transitional                                                   0                                             0
2300660 2300660 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring grade_9_transitional                                                   0                                             0
2300661 2300661 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring grade_9_transitional                                                   0                                             0
2300662 2300662 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring grade_9_transitional                                                   1                                             1
2300663 2300663 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring grade_9_transitional                                                   0                                             0
2300664 2300664 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring grade_9_transitional                                                   0                                             0
2300665 2300665 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring grade_9_transitional                                                   0                                             0
2300666 2300666 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring grade_9_transitional                                                   0                                             0
2300667 2300667 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring grade_9_transitional                                                   0                                             0
2302070 2302070 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring kindergarten                                                   30                                             30
2302071 2302071 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring kindergarten                                                   32                                             32
2302072 2302072 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring kindergarten                                                   100                                             100
2302073 2302073 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring kindergarten                                                   0                                             0
2302074 2302074 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring kindergarten                                                   121                                             121
2302075 2302075 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring kindergarten                                                   0                                             0
2302076 2302076 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring kindergarten                                                   0                                             0
2302077 2302077 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring kindergarten                                                   44                                             44
2302078 2302078 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring kindergarten                                                   0                                             0
2302079 2302079 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring kindergarten                                                   34                                             34
2302080 2302080 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring kindergarten                                                   0                                             0
2303483 2303483 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring pk_12_total 393.0 4.0 5.0 2.0   3.0     0.0   7.0   214.0 200.0     0.0       241.0         414 393 4 5 2   3     0   7   214 200     0   241       414
2303484 2303484 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring pk_12_total 369.0 1.0 5.0 0.0   13.0     0.0   6.0   186.0 208.0     3.0       252.0         394 369 1 5 0   13     0   6   186 208     3   252       394
2303485 2303485 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring pk_12_total 382.0 95.0 12.0 13.0   3.0     0.0   47.0   295.0 257.0     2.0       367.0         552 382 95 12 13   3     0   47   295 257     2   367       552
2303486 2303486 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring pk_12_total 253.0 62.0 6.0 10.0   4.0     1.0   13.0   172.0 177.0     0.0       202.0         349 253 62 6 10   4     1   13   172 177     0   202       349
2303487 2303487 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring pk_12_total 369.0 182.0 9.0 3.0   2.0     0.0   30.0   339.0 256.0     1.0       461.0         595 369 182 9 3   2     0   30   339 256     1   461       595
2303488 2303488 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring pk_12_total 187.0 99.0 7.0 0.0   3.0     0.0   2.0   141.0 157.0     0.0       203.0         298 187 99 7 0   3     0   2   141 157     0   203       298
2303489 2303489 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring pk_12_total 228.0 108.0 8.0 1.0   2.0     0.0   13.0   183.0 177.0     1.0       252.0         360 228 108 8 1   2     0   13   183 177     1   252       360
2303490 2303490 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring pk_12_total 177.0 89.0 3.0 3.0   1.0     0.0   24.0   156.00000000000003 141.0     0.0       215.0         297 177 89 3 3   1     0   24     141     0   215       297
2303491 2303491 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring pk_12_total 140.0 89.0 1.0 4.0   0.0     0.0   12.0   123.0 123.0     0.0       177.0         246 140 89 1 4   0     0   12   123 123     0   177       246
2303492 2303492 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring pk_12_total 270.0 13.0 1.0 1.0   0.0     0.0   3.0   148.0 140.0     0.0       195.0         288 270 13 1 1   0     0   3   148 140     0   195       288
2303493 2303493 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring pk_12_total 299.0 84.0 6.0 6.0   9.0     0.0   25.0   225.0 204.0     5.0       277.0         429 299 84 6 6   9     0   25   225 204     5   277       429
2304896 2304896 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring pre_kindergarten                                                   20                                             20
2304897 2304897 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring pre_kindergarten                                                   25                                             25
2304898 2304898 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 spring pre_kindergarten                                                   68                                             68
2304899 2304899 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 spring pre_kindergarten                                                   0                                             0
2304900 2304900 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 spring pre_kindergarten                                                   75                                             75
2304901 2304901 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring pre_kindergarten                                                   0                                             0
2304902 2304902 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 spring pre_kindergarten                                                   0                                             0
2304903 2304903 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 spring pre_kindergarten                                                   29                                             29
2304904 2304904 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 spring pre_kindergarten                                                   0                                             0
2304905 2304905 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 spring pre_kindergarten                                                   18                                             18
2304906 2304906 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 spring pre_kindergarten                                                   0                                             0
2518056 2518056 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_1                                                   28                                             28
2518057 2518057 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_1                                                   36                                             36
2518058 2518058 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 fall grade_1                                                   99                                             99
2518059 2518059 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 09 12 2019 fall grade_1                                                   0                                             0
2518060 2518060 LA     school 2200060 002   Allen Parish 220006000028 2005 Oakdale Elementary School   Regular School No Elementary PK 04 2019 fall grade_1                                                   109                                             109
2518061 2518061 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 fall grade_1                                                   0                                             0
2518062 2518062 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 fall grade_1                                                   0                                             0
2518063 2518063 LA     school 2200060 002   Allen Parish 220006000031 2008 Oberlin Elementary School   Regular School No Elementary PK 06 2019 fall grade_1                                                   33                                             33
2518064 2518064 LA     school 2200060 002   Allen Parish 220006000032 2009 Oberlin High School   Regular School No High 07 12 2019 fall grade_1                                                   0                                             0
2518065 2518065 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 fall grade_1                                                   26                                             26
2518066 2518066 LA     school 2200060 002   Allen Parish 220006001049 2015 Kinder Middle School   Regular School No Middle 05 08 2019 fall grade_1                                                   0                                             0
2519473 2519473 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_10                                                   36                                             36
2519474 2519474 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_10                                                   32                                             32

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