enrollments

Data source: Big Local News · About: Big Local

47,532 rows where state = "LA" and year = 2021 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 47,432 ✖
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
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
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
1763568 1763568 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring extension_academy                                                   0                                             0
1764965 1764965 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_1                                                   0                                             0
1766362 1766362 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_10                                                   5                                             5
1767759 1767759 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_11                                                   1                                             1
1769156 1769156 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_12                                                   0                                             0
1770553 1770553 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_2                                                   0                                             0
1771950 1771950 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_3                                                   0                                             0
1773347 1773347 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_4                                                   0                                             0
1774744 1774744 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_5                                                   0                                             0
1776141 1776141 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_6                                                   0                                             0
1777538 1777538 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_7                                                   3                                             3
1778935 1778935 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_8                                                   6                                             6
1780332 1780332 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_9                                                   6                                             6
1781729 1781729 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring grade_9_transitional                                                   0                                             0
1783126 1783126 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring kindergarten                                                   0                                             0
1784523 1784523 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring pk_12_total 9.0 10.0 2.0 0.0   0.0     0.0   0.0   21.0 0.0     0.0       21.0         21 9 10 2 0   0     0   0   21 0     0   21       21
1785920 1785920 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 spring pre_kindergarten                                                   0                                             0
1987311 1987311 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall extension_academy                                                   0                                             0
1988710 1988710 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_1                                                   0                                             0
1990109 1990109 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_10                                                   5                                             5
1991508 1991508 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_11                                                   1                                             1
1992907 1992907 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_12                                                   0                                             0
1994306 1994306 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_2                                                   0                                             0
1995705 1995705 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_3                                                   0                                             0
1997104 1997104 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_4                                                   0                                             0
1998503 1998503 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_5                                                   0                                             0
1999902 1999902 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_6                                                   0                                             0
2001301 2001301 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_7                                                   2                                             2
2002700 2002700 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_8                                                   5                                             5
2004099 2004099 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_9                                                   11                                             11
2005498 2005498 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall grade_9_transitional                                                   0                                             0
2006897 2006897 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall kindergarten                                                   0                                             0
2008296 2008296 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall pk_12_total 7.0 16.0 1.0 0.0   0.0     0.0   0.0   24.0 0.0     0.0       24.0         24 7 16 1 0   0     0   0   24 0     0   24       24
2009695 2009695 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2021 fall pre_kindergarten                                                   0                                             0
1764659 1764659 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring extension_academy                                                   0                                             0
1766056 1766056 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_1                                                   0                                             0
1767453 1767453 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_10                                                   149                                             149
1768850 1768850 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_11                                                   152                                             152
1770247 1770247 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_12                                                   132                                             132
1771644 1771644 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_2                                                   0                                             0
1773041 1773041 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_3                                                   0                                             0
1774438 1774438 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_4                                                   0                                             0
1775835 1775835 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_5                                                   0                                             0
1777232 1777232 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_6                                                   0                                             0
1778629 1778629 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_7                                                   0                                             0
1780026 1780026 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_8                                                   0                                             0
1781423 1781423 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_9                                                   172                                             172
1782820 1782820 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_9_transitional                                                   2                                             2
1784217 1784217 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring kindergarten                                                   0                                             0
1785614 1785614 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring pk_12_total 180.0 313.0 33.0 0.0   51.0     0.0   30.0   301.0 306.0     24.0       515.0         607 180 313 33 0   51     0   30   301 306     24   515       607
1787011 1787011 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring pre_kindergarten                                                   0                                             0
1988412 1988412 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall extension_academy                                                   0                                             0
1989811 1989811 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_1                                                   0                                             0
1991210 1991210 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_10                                                   148                                             148
1992609 1992609 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_11                                                   155                                             155
1994008 1994008 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_12                                                   134                                             134
1995407 1995407 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_2                                                   0                                             0
1996806 1996806 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_3                                                   0                                             0
1998205 1998205 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_4                                                   0                                             0
1999604 1999604 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_5                                                   0                                             0
2001003 2001003 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_6                                                   0                                             0
2002402 2002402 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_7                                                   0                                             0
2003801 2003801 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_8                                                   0                                             0
2005200 2005200 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_9                                                   179                                             179

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