enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 44,652 ✖
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
601373 601373 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_2                                                   0                                             0
602773 602773 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
604173 604173 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_4                                                   0                                             0
605573 605573 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_5                                                   0                                             0
606973 606973 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_6                                                   0                                             0
608373 608373 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_7                                                   0                                             0
609773 609773 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_8                                                   0                                             0
611173 611173 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_9                                                   162                                             162
612573 612573 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring grade_9_transitional                                                   6                                             6
613973 613973 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring kindergarten                                                   0                                             0
615373 615373 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring pk_12_total 175.0 307.0 30.0 0.0   53.0     0.0   23.0   288.0 300.0     22.0       470.0         588 175 307 30 0   53     0   23   288 300     22   470       588
616773 616773 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 spring pre_kindergarten                                                   0                                             0
2012196 2012196 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_1                                                   0                                             0
2013597 2013597 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_10                                                   153                                             153
2014998 2014998 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_11                                                   156                                             156
2016399 2016399 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_12                                                   121                                             121
2017800 2017800 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_2                                                   0                                             0
2019201 2019201 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_3                                                   0                                             0
2020602 2020602 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_4                                                   0                                             0
2022003 2022003 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_5                                                   0                                             0
2023404 2023404 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_6                                                   0                                             0
2024805 2024805 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2026206 2026206 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_8                                                   0                                             0
2027607 2027607 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_9                                                   171                                             171
2029008 2029008 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall grade_9_transitional                                                   6                                             6
2030409 2030409 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall kindergarten                                                   0                                             0
2031810 2031810 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall pk_12_total 179.0 321.0 32.0 0.0   52.0     0.0   23.0   299.0 308.0     22.0       471.0         607 179 321 32 0   52     0   23   299 308     22   471       607
2033211 2033211 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2020 fall pre_kindergarten                                                   0                                             0
595644 595644 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_1                                                   180                                             180
597044 597044 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_10                                                   0                                             0
598444 598444 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_11                                                   0                                             0
599844 599844 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_12                                                   0                                             0
601244 601244 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_2                                                   137                                             137
602644 602644 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_3                                                   155                                             155
604044 604044 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_4                                                   0                                             0
605444 605444 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_5                                                   0                                             0
606844 606844 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_6                                                   0                                             0
608244 608244 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_7                                                   0                                             0
609644 609644 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_8                                                   0                                             0
611044 611044 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_9                                                   0                                             0
612444 612444 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring grade_9_transitional                                                   0                                             0
613844 613844 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring kindergarten                                                   133                                             133
615244 615244 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring pk_12_total 524.0 73.0 45.0 0.0   7.0     3.0   25.0   327.0 350.0     17.0       414.0         677 524 73 45 0   7     3   25   327 350     17   414       677
616644 616644 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 spring pre_kindergarten                                                   63                                             63
2012067 2012067 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_1                                                   188                                             188
2013468 2013468 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_10                                                   0                                             0
2014869 2014869 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_11                                                   0                                             0
2016270 2016270 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_12                                                   0                                             0
2017671 2017671 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_2                                                   136                                             136
2019072 2019072 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_3                                                   160                                             160
2020473 2020473 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_4                                                   0                                             0
2021874 2021874 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_5                                                   0                                             0
2023275 2023275 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_6                                                   0                                             0
2024676 2024676 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_7                                                   0                                             0
2026077 2026077 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_8                                                   0                                             0
2027478 2027478 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_9                                                   0                                             0
2028879 2028879 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall grade_9_transitional                                                   0                                             0
2030280 2030280 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall kindergarten                                                   132                                             132
2031681 2031681 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall pk_12_total 531.0 78.0 48.0 0.0   7.0     3.0   24.0   333.0 358.0     17.0       422.0         691 531 78 48 0   7     3   24   333 358     17   422       691
2033082 2033082 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2020 fall pre_kindergarten                                                   65                                             65
595645 595645 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_1                                                   0                                             0
597045 597045 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_10                                                   0                                             0
598445 598445 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_11                                                   0                                             0
599845 599845 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_12                                                   0                                             0
601245 601245 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_2                                                   0                                             0
602645 602645 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_3                                                   0                                             0
604045 604045 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_4                                                   150                                             150
605445 605445 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_5                                                   161                                             161
606845 606845 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_6                                                   181                                             181
608245 608245 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_7                                                   0                                             0
609645 609645 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_8                                                   0                                             0
611045 611045 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_9                                                   0                                             0
612445 612445 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring grade_9_transitional                                                   0                                             0
613845 613845 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring kindergarten                                                   0                                             0
615245 615245 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring pk_12_total 358.0 70.0 35.0 1.0   3.0     0.0   25.0   241.0 251.0     13.0       286.0         492 358 70 35 1   3     0   25   241 251     13   286       492
616645 616645 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 spring pre_kindergarten                                                   0                                             0
2012068 2012068 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_1                                                   0                                             0
2013469 2013469 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_10                                                   0                                             0
2014870 2014870 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_11                                                   0                                             0
2016271 2016271 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_12                                                   0                                             0
2017672 2017672 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_2                                                   0                                             0
2019073 2019073 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_3                                                   0                                             0
2020474 2020474 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_4                                                   149                                             149
2021875 2021875 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_5                                                   165                                             165
2023276 2023276 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_6                                                   186                                             186
2024677 2024677 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_7                                                   0                                             0
2026078 2026078 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_8                                                   0                                             0
2027479 2027479 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_9                                                   0                                             0
2028880 2028880 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall grade_9_transitional                                                   0                                             0
2030281 2030281 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall kindergarten                                                   0                                             0
2031682 2031682 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall pk_12_total 366.0 70.0 36.0 1.0   3.0     0.0   24.0   247.0 253.0     11.0       290.0         500 366 70 36 1   3     0   24   247 253     11   290       500
2033083 2033083 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2020 fall pre_kindergarten                                                   0                                             0
595698 595698 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2020 spring grade_1                                                   0                                             0
597098 597098 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2020 spring grade_10                                                   0                                             0
598498 598498 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2020 spring grade_11                                                   0                                             0
599898 599898 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2020 spring grade_12                                                   0                                             0
601298 601298 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2020 spring grade_2                                                   0                                             0
602698 602698 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2020 spring grade_3                                                   0                                             0
604098 604098 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2020 spring grade_4                                                   0                                             0
605498 605498 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2020 spring grade_5                                                   0                                             0

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