enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2026479 2026479 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_9                                                   140                                             140
2026480 2026480 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall grade_9                                                   0                                             0
2026481 2026481 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall grade_9                                                   138                                             138
2026482 2026482 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall grade_9                                                   0                                             0
2026483 2026483 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall grade_9                                                   0                                             0
2026484 2026484 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall grade_9                                                   0                                             0
2026485 2026485 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall grade_9                                                   0                                             0
2026486 2026486 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall grade_9                                                   0                                             0
2026487 2026487 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall grade_9                                                   0                                             0
2026488 2026488 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall grade_9                                                   0                                             0
2026489 2026489 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall grade_9                                                   0                                             0
2026490 2026490 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall grade_9                                                   0                                             0
2026491 2026491 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall grade_9                                                   61                                             61
2026492 2026492 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2020 fall grade_9                                                   0                                             0
2026493 2026493 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2020 fall grade_9                                                   0                                             0
2026494 2026494 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2020 fall grade_9                                                   0                                             0
2026495 2026495 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2020 fall grade_9                                                   194                                             194
2026496 2026496 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2020 fall grade_9                                                   0                                             0
2026497 2026497 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary PK 06 2020 fall grade_9                                                   0                                             0
2026498 2026498 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary PK 05 2020 fall grade_9                                                   0                                             0
2026499 2026499 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2020 fall grade_9                                                   0                                             0
2026500 2026500 LA     school   001   Acadia Parish   1030 Church Point Head Start Center             2020 fall grade_9                                                   0                                             0
2026501 2026501 LA     school   001   Acadia Parish   1031 Rayne Head Start Center             2020 fall grade_9                                                   0                                             0
2026502 2026502 LA     school   001   Acadia Parish   1032 Ross Head Start Center             2020 fall grade_9                                                   0                                             0
2026503 2026503 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2020 fall grade_9                                                   152                                             152
2026504 2026504 LA     school   001   Acadia Parish   1035 Estherwood Head Start Center             2020 fall grade_9                                                   0                                             0
2026505 2026505 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2020 fall grade_9                                                   14                                             14
2026506 2026506 LA     school   001   Acadia Parish   1700 Acadia Parish Central Office             2020 fall grade_9                                                   0                                             0
2027876 2027876 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 fall grade_9_transitional                                                   0                                             0
2027877 2027877 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 fall grade_9_transitional                                                   0                                             0
2027878 2027878 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 fall grade_9_transitional                                                   0                                             0
2027879 2027879 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 fall grade_9_transitional                                                   0                                             0
2027880 2027880 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_9_transitional                                                   29                                             29
2027881 2027881 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall grade_9_transitional                                                   0                                             0
2027882 2027882 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall grade_9_transitional                                                   53                                             53
2027883 2027883 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall grade_9_transitional                                                   0                                             0
2027884 2027884 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall grade_9_transitional                                                   0                                             0
2027885 2027885 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall grade_9_transitional                                                   0                                             0
2027886 2027886 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall grade_9_transitional                                                   0                                             0
2027887 2027887 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall grade_9_transitional                                                   0                                             0
2027888 2027888 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall grade_9_transitional                                                   0                                             0
2027889 2027889 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall grade_9_transitional                                                   0                                             0
2027890 2027890 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall grade_9_transitional                                                   0                                             0
2027891 2027891 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall grade_9_transitional                                                   0                                             0
2027892 2027892 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall grade_9_transitional                                                   8                                             8
2027893 2027893 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2020 fall grade_9_transitional                                                   0                                             0
2027894 2027894 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2020 fall grade_9_transitional                                                   0                                             0
2027895 2027895 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2020 fall grade_9_transitional                                                   0                                             0
2027896 2027896 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2020 fall grade_9_transitional                                                   1                                             1
2027897 2027897 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2020 fall grade_9_transitional                                                   0                                             0
2027898 2027898 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary PK 06 2020 fall grade_9_transitional                                                   0                                             0
2027899 2027899 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary PK 05 2020 fall grade_9_transitional                                                   0                                             0
2027900 2027900 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2020 fall grade_9_transitional                                                   0                                             0
2027901 2027901 LA     school   001   Acadia Parish   1030 Church Point Head Start Center             2020 fall grade_9_transitional                                                   0                                             0
2027902 2027902 LA     school   001   Acadia Parish   1031 Rayne Head Start Center             2020 fall grade_9_transitional                                                   0                                             0
2027903 2027903 LA     school   001   Acadia Parish   1032 Ross Head Start Center             2020 fall grade_9_transitional                                                   0                                             0
2027904 2027904 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2020 fall grade_9_transitional                                                   10                                             10
2027905 2027905 LA     school   001   Acadia Parish   1035 Estherwood Head Start Center             2020 fall grade_9_transitional                                                   0                                             0
2027906 2027906 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2020 fall grade_9_transitional                                                   0                                             0
2027907 2027907 LA     school   001   Acadia Parish   1700 Acadia Parish Central Office             2020 fall grade_9_transitional                                                   0                                             0
2029277 2029277 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2029278 2029278 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   38                                             38
2029279 2029279 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 fall kindergarten                                                   142                                             142
2029280 2029280 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   92                                             92
2029281 2029281 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall kindergarten                                                   0                                             0
2029282 2029282 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2029283 2029283 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall kindergarten                                                   0                                             0
2029284 2029284 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2029285 2029285 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall kindergarten                                                   190                                             190
2029286 2029286 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   0                                             0
2029287 2029287 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   31                                             31
2029288 2029288 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall kindergarten                                                   22                                             22
2029289 2029289 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   21                                             21
2029290 2029290 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   98                                             98
2029291 2029291 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2029292 2029292 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall kindergarten                                                   20                                             20
2029293 2029293 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall kindergarten                                                   0                                             0
2029294 2029294 LA     school 2200030 001   Acadia Parish 220003000017 1018 Mire Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   60                                             60
2029295 2029295 LA     school 2200030 001   Acadia Parish 220003000018 1019 Morse Elementary School   Regular School No Elementary PK 07 2020 fall kindergarten                                                   29                                             29
2029296 2029296 LA     school 2200030 001   Acadia Parish 220003001504 1020 Martin Petitjean Elementary School   Regular School No Elementary 01 03 2020 fall kindergarten                                                   0                                             0
2029297 2029297 LA     school 2200030 001   Acadia Parish 220003000019 1021 Rayne High School   Regular School No High 08 12 2020 fall kindergarten                                                   0                                             0
2029298 2029298 LA     school 2200030 001   Acadia Parish 220003000020 1022 Richard Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   74                                             74
2029299 2029299 LA     school 2200030 001   Acadia Parish 220003000021 1023 Ross Elementary School   Regular School No Elementary PK 06 2020 fall kindergarten                                                   0                                             0
2029300 2029300 LA     school 2200030 001   Acadia Parish 220003000022 1024 South Crowley Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   0                                             0
2029301 2029301 LA     school 2200030 001   Acadia Parish 220003000023 1025 South Rayne Elementary School   Regular School No Middle 04 06 2020 fall kindergarten                                                   0                                             0
2029302 2029302 LA     school   001   Acadia Parish   1030 Church Point Head Start Center             2020 fall kindergarten                                                   0                                             0
2029303 2029303 LA     school   001   Acadia Parish   1031 Rayne Head Start Center             2020 fall kindergarten                                                   0                                             0
2029304 2029304 LA     school   001   Acadia Parish   1032 Ross Head Start Center             2020 fall kindergarten                                                   0                                             0
2029305 2029305 LA     school 2200030 001   Acadia Parish 220003000014 1034 Iota High School   Regular School No High 05 12 2020 fall kindergarten                                                   0                                             0
2029306 2029306 LA     school   001   Acadia Parish   1035 Estherwood Head Start Center             2020 fall kindergarten                                                   0                                             0
2029307 2029307 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2020 fall kindergarten                                                   0                                             0
2029308 2029308 LA     school   001   Acadia Parish   1700 Acadia Parish Central Office             2020 fall kindergarten                                                   0                                             0
2030678 2030678 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 146.0 139.0 11.0 0.0   0.0     0.0   23.0   167.0 152.0     2.0       258.0         319 146 139 11 0   0     0   23   167 152     2   258       319
2030679 2030679 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 fall pk_12_total 275.0 22.0 11.0 0.0   1.0     0.0   9.0   155.0 163.0     4.0       174.0         318 275 22 11 0   1     0   9   155 163     4   174       318
2030680 2030680 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 fall pk_12_total 111.0 83.0 9.0 0.0   1.0     0.0   18.0   128.0 94.0     0.0       175.0         222 111 83 9 0   1     0   18   128 94     0   175       222
2030681 2030681 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 251.0 235.0 40.0 3.0   0.0     0.0   46.0   307.0 268.0     3.0000000000000004       504.0         575 251 235 40 3   0     0   46   307 268         504       575
2030682 2030682 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall pk_12_total 342.0 143.0 18.0 0.0   1.0     0.0   29.0   276.0 257.0     2.0       336.0         533 342 143 18 0   1     0   29   276 257     2   336       533
2030683 2030683 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 108.0 122.0 19.0 1.0   0.0     0.0   19.0   126.0 143.0     2.0       222.0         269 108 122 19 1   0     0   19   126 143     2   222       269
2030684 2030684 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall pk_12_total 281.0 267.0 24.0 1.0   1.0     0.0   32.0   300.0 306.0     9.999999999999998       481.0         606 281 267 24 1   1     0   32   300 306         481       606
2030685 2030685 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 194.0 245.0 26.0 0.0   3.0     0.0   22.0   251.00000000000003 239.0     11.0       422.0         490 194 245 26 0   3     0   22     239     11   422       490

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