enrollments

Data source: Big Local News · About: Big Local

137,628 rows where state = "LA" sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school ▲ school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2287375 2287375 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_11                                                   0                                             0
2288788 2288788 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_12                                                   0                                             0
2290201 2290201 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_2                                                   53                                             53
2291614 2291614 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_3                                                   59                                             59
2293027 2293027 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_4                                                   48                                             48
2294440 2294440 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_5                                                   75                                             75
2295853 2295853 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_6                                                   63                                             63
2297266 2297266 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_7                                                   0                                             0
2298679 2298679 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_8                                                   0                                             0
2300092 2300092 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_9                                                   0                                             0
2301505 2301505 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring grade_9_transitional                                                   0                                             0
2302918 2302918 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring kindergarten                                                   64                                             64
2304331 2304331 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring pk_12_total 103.0 131.0 24.0 157.0   1.0     0.0   74.0   228.0 262.0     2.0       419.0         490 103 131 24 157   1     0   74   228 262     2   419       490
2305744 2305744 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 spring pre_kindergarten                                                   57                                             57
2518906 2518906 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_1                                                   67                                             67
2520323 2520323 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_10                                                   0                                             0
2521740 2521740 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_11                                                   0                                             0
2523157 2523157 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_12                                                   0                                             0
2524574 2524574 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_2                                                   54                                             54
2525991 2525991 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_3                                                   55                                             55
2527408 2527408 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_4                                                   53                                             53
2528825 2528825 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_5                                                   72                                             72
2530242 2530242 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_6                                                   62                                             62
2531659 2531659 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2533076 2533076 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_8                                                   0                                             0
2534493 2534493 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_9                                                   0                                             0
2535910 2535910 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall grade_9_transitional                                                   0                                             0
2537327 2537327 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall kindergarten                                                   65                                             65
2538744 2538744 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall pk_12_total 101.0 135.0 24.0 160.0   1.0     0.0   70.0   235.0 256.0     2.0       417.0         491 101 135 24 160   1     0   70   235 256     2   417       491
2540161 2540161 LA     school 2201380 043   Sabine Parish 220138001117 43011 Zwolle Elementary School   Regular School No Elementary PK 06 2019 fall pre_kindergarten                                                   57                                             57
595890 595890 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
597290 597290 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_10                                                   384                                             384
598690 598690 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_11                                                   387                                             387
600090 600090 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_12                                                   383                                             383
601490 601490 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_2                                                   0                                             0
602890 602890 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
604290 604290 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_4                                                   0                                             0
605690 605690 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_5                                                   0                                             0
607090 607090 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_6                                                   0                                             0
608490 608490 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_7                                                   0                                             0
609890 609890 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_8                                                   0                                             0
611290 611290 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_9                                                   390                                             390
612690 612690 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring grade_9_transitional                                                   37                                             37
614090 614090 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring kindergarten                                                   0                                             0
615490 615490 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring pk_12_total 636.0 853.0 33.0 1.0   17.0     1.0   40.0   783.0 798.0     11.0       775.0         1581 636 853 33 1   17     1   40   783 798     11   775       1581
616890 616890 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring pre_kindergarten                                                   0                                             0
1764777 1764777 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring extension_academy                                                   0                                             0
1766174 1766174 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_1                                                   0                                             0
1767571 1767571 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_10                                                   411                                             411
1768968 1768968 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_11                                                   386                                             386
1770365 1770365 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_12                                                   384                                             384
1771762 1771762 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_2                                                   0                                             0
1773159 1773159 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_3                                                   0                                             0
1774556 1774556 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_4                                                   0                                             0
1775953 1775953 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_5                                                   0                                             0
1777350 1777350 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_6                                                   0                                             0
1778747 1778747 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_7                                                   0                                             0
1780144 1780144 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_8                                                   0                                             0
1781541 1781541 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_9                                                   382                                             382
1782938 1782938 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring grade_9_transitional                                                   51                                             51
1784335 1784335 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring kindergarten                                                   0                                             0
1785732 1785732 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring pk_12_total 623.0 895.0 30.0 1.0   17.0     1.0   47.0   809.0000000000001 805.0     5.0       782.0         1614 623 895 30 1   17     1   47     805     5   782       1614
1787129 1787129 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 spring pre_kindergarten                                                   0                                             0
1988530 1988530 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall extension_academy                                                   0                                             0
1989929 1989929 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_1                                                   0                                             0
1991328 1991328 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_10                                                   414                                             414
1992727 1992727 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_11                                                   389                                             389
1994126 1994126 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_12                                                   386                                             386
1995525 1995525 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_2                                                   0                                             0
1996924 1996924 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_3                                                   0                                             0
1998323 1998323 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_4                                                   0                                             0
1999722 1999722 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_5                                                   0                                             0
2001121 2001121 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_6                                                   0                                             0
2002520 2002520 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_7                                                   0                                             0
2003919 2003919 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_8                                                   0                                             0
2005318 2005318 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_9                                                   383                                             383
2006717 2006717 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall grade_9_transitional                                                   61                                             61
2008116 2008116 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall kindergarten                                                   0                                             0
2009515 2009515 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall pk_12_total 634.0 904.0 30.0 1.0   16.0     1.0   47.0   812.0 821.0     4.0       790.0         1633 634 904 30 1   16     1   47   812 821     4   790       1633
2010914 2010914 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2021 fall pre_kindergarten                                                   0                                             0
2012313 2012313 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_1                                                   0                                             0
2013714 2013714 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_10                                                   380                                             380
2015115 2015115 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_11                                                   386                                             386
2016516 2016516 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_12                                                   387                                             387
2017917 2017917 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_2                                                   0                                             0
2019318 2019318 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_3                                                   0                                             0
2020719 2020719 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_4                                                   0                                             0
2022120 2022120 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_5                                                   0                                             0
2023521 2023521 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_6                                                   0                                             0
2024922 2024922 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2026323 2026323 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_8                                                   0                                             0
2027724 2027724 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_9                                                   389                                             389
2029125 2029125 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_9_transitional                                                   39                                             39
2030526 2030526 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall kindergarten                                                   0                                             0
2031927 2031927 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall pk_12_total 641.0 850.0 30.0 1.0   17.0     1.0   41.0   785.0 795.9999999999999     7.000000000000001       766.0         1581 641 850 30 1   17     1   41   785           766       1581
2033328 2033328 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall pre_kindergarten                                                   0                                             0
2284924 2284924 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2286337 2286337 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 spring grade_10                                                   409                                             409
2287750 2287750 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 spring grade_11                                                   381                                             381
2289163 2289163 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 spring grade_12                                                   362                                             362

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