enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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
1994751 1994751 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_2                                                   62                                             62
1996150 1996150 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_3                                                   71                                             71
1997549 1997549 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_4                                                   74                                             74
1998948 1998948 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_5                                                   66                                             66
2000347 2000347 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_6                                                   65                                             65
2001746 2001746 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_7                                                   69                                             69
2003145 2003145 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_8                                                   64                                             64
2004544 2004544 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_9                                                   0                                             0
2005943 2005943 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_9_transitional                                                   0                                             0
2007342 2007342 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   64                                             64
2008741 2008741 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall pk_12_total 92.0 82.0 436.0 0.0   18.0     0.0   14.0   315.0 327.0     221.0       578.0         642 92 82 436 0   18     0   14   315 327     221   578       642
2010140 2010140 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall pre_kindergarten                                                   35                                             35
2011538 2011538 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_1                                                   64                                             64
2012939 2012939 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_10                                                   0                                             0
2014340 2014340 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_11                                                   0                                             0
2015741 2015741 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_12                                                   0                                             0
2017142 2017142 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_2                                                   77                                             77
2018543 2018543 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_3                                                   78                                             78
2019944 2019944 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_4                                                   71                                             71
2021345 2021345 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_5                                                   66                                             66
2022746 2022746 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_6                                                   56                                             56
2024147 2024147 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_7                                                   63                                             63
2025548 2025548 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_8                                                   46                                             46
2026949 2026949 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_9                                                   0                                             0
2028350 2028350 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall grade_9_transitional                                                   0                                             0
2029751 2029751 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   62                                             62
2031152 2031152 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall pk_12_total 99.0 97.0 404.0 0.0   8.0     0.0   15.0   310.0 313.0     195.0       520.0         623 99 97 404 0   8     0   15   310 313     195   520       623
2032553 2032553 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 fall pre_kindergarten                                                   40                                             40
594825 594825 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   74                                             74
596225 596225 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_10                                                   0                                             0
597625 597625 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_11                                                   0                                             0
599025 599025 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_12                                                   0                                             0
600425 600425 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_2                                                   80                                             80
601825 601825 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_3                                                   81                                             81
603225 603225 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_4                                                   71                                             71
604625 604625 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_5                                                   72                                             72
606025 606025 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_6                                                   0                                             0
607425 607425 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_7                                                   0                                             0
608825 608825 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_8                                                   0                                             0
610225 610225 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_9                                                   0                                             0
611625 611625 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring grade_9_transitional                                                   0                                             0
613025 613025 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten                                                   60                                             60
614425 614425 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 313.0 101.0 21.0 1.0   2.0     0.0   20.0   238.0 220.0     8.0       222.0         458 313 101 21 1   2     0   20   238 220     8   222       458
615825 615825 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten                                                   20                                             20
1763723 1763723 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring extension_academy                                                   0                                             0
1765120 1765120 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_1                                                   65                                             65
1766517 1766517 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_10                                                   0                                             0
1767914 1767914 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_11                                                   0                                             0
1769311 1769311 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_12                                                   0                                             0
1770708 1770708 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_2                                                   68                                             68
1772105 1772105 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_3                                                   79                                             79
1773502 1773502 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_4                                                   75                                             75
1774899 1774899 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_5                                                   64                                             64
1776296 1776296 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_6                                                   0                                             0
1777693 1777693 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_7                                                   0                                             0
1779090 1779090 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_8                                                   0                                             0
1780487 1780487 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_9                                                   0                                             0
1781884 1781884 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring grade_9_transitional                                                   0                                             0
1783281 1783281 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring kindergarten                                                   63                                             63
1784678 1784678 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring pk_12_total 286.0 96.0 30.0 1.0   0.0     0.0   21.0   210.0 224.0     10.0       230.00000000000003         434 286 96 30 1   0     0   21   210 224     10           434
1786075 1786075 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 spring pre_kindergarten                                                   19                                             19
1987466 1987466 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall extension_academy                                                   0                                             0
1988865 1988865 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_1                                                   62                                             62
1990264 1990264 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_10                                                   0                                             0
1991663 1991663 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_11                                                   0                                             0
1993062 1993062 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_12                                                   0                                             0
1994461 1994461 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_2                                                   71                                             71
1995860 1995860 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_3                                                   79                                             79
1997259 1997259 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_4                                                   77                                             77
1998658 1998658 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_5                                                   68                                             68
2000057 2000057 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_6                                                   0                                             0
2001456 2001456 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_7                                                   0                                             0
2002855 2002855 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_8                                                   0                                             0
2004254 2004254 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_9                                                   0                                             0
2005653 2005653 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall grade_9_transitional                                                   0                                             0
2007052 2007052 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten                                                   63                                             63
2008451 2008451 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall pk_12_total 287.0 105.0 28.0 1.0   0.0     0.0   19.0   214.0 226.0     10.0       241.0         440 287 105 28 1   0     0   19   214 226     10   241       440
2009850 2009850 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten                                                   19                                             19
2011248 2011248 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_1                                                   74                                             74
2012649 2012649 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_10                                                   0                                             0
2014050 2014050 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_11                                                   0                                             0
2015451 2015451 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_12                                                   0                                             0
2016852 2016852 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_2                                                   80                                             80
2018253 2018253 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_3                                                   79                                             79
2019654 2019654 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_4                                                   70                                             70
2021055 2021055 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_5                                                   74                                             74
2022456 2022456 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_6                                                   0                                             0
2023857 2023857 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_7                                                   0                                             0
2025258 2025258 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_8                                                   0                                             0
2026659 2026659 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_9                                                   0                                             0
2028060 2028060 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall grade_9_transitional                                                   0                                             0
2029461 2029461 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   56                                             56
2030862 2030862 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 310.0 100.0 22.0 1.0   2.0     0.0   18.0   236.0 217.0     5.0       204.0         453 310 100 22 1   2     0   18   236 217     5   204       453
2032263 2032263 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten                                                   20                                             20
2283851 2283851 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   80                                             80
2285264 2285264 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_10                                                   0                                             0
2286677 2286677 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_11                                                   0                                             0
2288090 2288090 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_12                                                   0                                             0
2289503 2289503 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_2                                                   79                                             79
2290916 2290916 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_3                                                   69                                             69

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