Data source: Big Local News · About: Big Local

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

View and edit SQL

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
2287161 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_11                                                   0                                             0
2288574 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_12                                                   0                                             0
2289987 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_2                                                   52                                             52
2291400 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_3                                                   53                                             53
2292813 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_4                                                   52                                             52
2294226 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_5                                                   34                                             34
2295639 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_6                                                   53                                             53
2297052 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_7                                                   34                                             34
2298465 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_8                                                   32                                             32
2299878 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_9                                                   0                                             0
2301291 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_9_transitional                                                   0                                             0
2302704 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring kindergarten                                                   50                                             50
2304117 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring pk_12_total 290.0 106.0 3.0 1.0   7.0     0.0   6.0   202.0 211.0     0.0       53.0         413 290 106 3 1   7     0   6   202 211     0   53       413
2305530 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring pre_kindergarten                                                   0                                             0
2518690 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_1                                                   53                                             53
2520107 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_10                                                   0                                             0
2521524 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_11                                                   0                                             0
2522941 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_12                                                   0                                             0
2524358 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_2                                                   52                                             52
2525775 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_3                                                   53                                             53
2527192 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_4                                                   52                                             52
2528609 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_5                                                   34                                             34
2530026 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_6                                                   54                                             54
2531443 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_7                                                   34                                             34
2532860 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_8                                                   32                                             32
2534277 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_9                                                   0                                             0
2535694 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_9_transitional                                                   0                                             0
2537111 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall kindergarten                                                   50                                             50
2538528 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall pk_12_total 291.0 106.0 3.0 1.0   7.0     0.0   6.0   203.0 211.00000000000003     0.0       46.0         414 291 106 3 1   7     0   6   203       0   46       414
2539945 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall pre_kindergarten                                                   0                                             0
2284148 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   85                                             85
2285561 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_10                                                   0                                             0
2286974 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_11                                                   0                                             0
2288387 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_12                                                   0                                             0
2289800 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_2                                                   86                                             86
2291213 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_3                                                   72                                             72
2292626 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_4                                                   76                                             76
2294039 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_5                                                   81                                             81
2295452 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_6                                                   0                                             0
2296865 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_7                                                   0                                             0
2298278 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_8                                                   0                                             0
2299691 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_9                                                   0                                             0
2301104 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring grade_9_transitional                                                   0                                             0
2302517 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten                                                   66                                             66
2303930 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring pk_12_total 80.0 76.0 330.0 0.0   7.0     0.0   13.0   257.0 249.0     195.0       441.0         506 80 76 330 0   7     0   13   257 249     195   441       506
2305343 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 spring pre_kindergarten                                                   37                                             37
2518503 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_1                                                   86                                             86
2519920 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_10                                                   0                                             0
2521337 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_11                                                   0                                             0
2522754 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_12                                                   0                                             0
2524171 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_2                                                   88                                             88
2525588 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_3                                                   72                                             72
2527005 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_4                                                   78                                             78
2528422 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_5                                                   78                                             78
2529839 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_6                                                   0                                             0
2531256 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_7                                                   0                                             0
2532673 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_8                                                   0                                             0
2534090 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_9                                                   0                                             0
2535507 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall grade_9_transitional                                                   0                                             0
2536924 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten                                                   68                                             68
2538341 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall pk_12_total 83.0 84.0 324.0 0.0   7.0     0.0   12.0   256.0 254.0     181.0       435.0         510 83 84 324 0   7     0   12   256 254     181   435       510
2539758 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten                                                   37                                             37
595115 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_1                                                   64                                             64
596515 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_10                                                   0                                             0
597915 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_11                                                   0                                             0
599315 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_12                                                   0                                             0
600715 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_2                                                   78                                             78
602115 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_3                                                   77                                             77
603515 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_4                                                   71                                             71
604915 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_5                                                   66                                             66
606315 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_6                                                   62                                             62
607715 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_7                                                   60                                             60
609115 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_8                                                   48                                             48
610515 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_9                                                   0                                             0
611915 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring grade_9_transitional                                                   0                                             0
613315 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring kindergarten                                                   65                                             65
614715 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring pk_12_total 101.0 94.0 411.0 0.0   8.0     0.0   15.0   319.0 310.0     209.0       543.0         629 101 94 411 0   8     0   15   319 310     209   543       629
616115 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2020 spring pre_kindergarten                                                   38                                             38
1764013 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring extension_academy                                                   0                                             0
1765410 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_1                                                   68                                             68
1766807 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_10                                                   0                                             0
1768204 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_11                                                   0                                             0
1769601 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_12                                                   0                                             0
1770998 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_2                                                   60                                             60
1772395 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_3                                                   71                                             71
1773792 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_4                                                   73                                             73
1775189 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_5                                                   63                                             63
1776586 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_6                                                   64                                             64
1777983 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_7                                                   69                                             69
1779380 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_8                                                   65                                             65
1780777 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_9                                                   0                                             0
1782174 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring grade_9_transitional                                                   0                                             0
1783571 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring kindergarten                                                   64                                             64
1784968 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring pk_12_total 91.0 93.0 417.0 0.0   17.0     0.0   14.0   309.0 322.99999999999994     211.0       562.0         632 91 93 417 0   17     0   14   309       211   562       632
1786365 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 spring pre_kindergarten                                                   32                                             32
1987756 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall extension_academy                                                   0                                             0
1989155 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_1                                                   69                                             69
1990554 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_10                                                   0                                             0
1991953 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_11                                                   0                                             0
1993352 LA     school 2200840 026   Jefferson Parish 220084000578 26003 A.C. Alexander School   Regular School No Elementary PK 08 2021 fall grade_12                                                   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]);