enrollments

Data source: Big Local News · About: Big Local

45,280 rows where state = "LA" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 45,246 ✖
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 2287161 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_11                                                   0                                             0
2288574 2288574 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_12                                                   0                                             0
2289987 2289987 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_2                                                   52                                             52
2291400 2291400 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_3                                                   53                                             53
2292813 2292813 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_4                                                   52                                             52
2294226 2294226 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_5                                                   34                                             34
2295639 2295639 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_6                                                   53                                             53
2297052 2297052 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_7                                                   34                                             34
2298465 2298465 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_8                                                   32                                             32
2299878 2299878 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_9                                                   0                                             0
2301291 2301291 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring grade_9_transitional                                                   0                                             0
2302704 2302704 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring kindergarten                                                   50                                             50
2304117 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 2305530 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 spring pre_kindergarten                                                   0                                             0
2518690 2518690 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_1                                                   53                                             53
2520107 2520107 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_10                                                   0                                             0
2521524 2521524 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_11                                                   0                                             0
2522941 2522941 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_12                                                   0                                             0
2524358 2524358 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_2                                                   52                                             52
2525775 2525775 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_3                                                   53                                             53
2527192 2527192 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_4                                                   52                                             52
2528609 2528609 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_5                                                   34                                             34
2530026 2530026 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_6                                                   54                                             54
2531443 2531443 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_7                                                   34                                             34
2532860 2532860 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_8                                                   32                                             32
2534277 2534277 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_9                                                   0                                             0
2535694 2535694 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall grade_9_transitional                                                   0                                             0
2537111 2537111 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall kindergarten                                                   50                                             50
2538528 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 2539945 LA     school   031   Lincoln Parish   31011 A. E. Phillips Laboratory School             2019 fall pre_kindergarten                                                   0                                             0
2284148 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
2283851 2283851 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   80                                             80
2285264 2285264 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_10                                                   0                                             0
2286677 2286677 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_11                                                   0                                             0
2288090 2288090 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_12                                                   0                                             0
2289503 2289503 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_2                                                   79                                             79
2290916 2290916 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_3                                                   69                                             69
2292329 2292329 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_4                                                   72                                             72
2293742 2293742 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_5                                                   77                                             77
2295155 2295155 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_6                                                   0                                             0
2296568 2296568 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_7                                                   0                                             0
2297981 2297981 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_8                                                   0                                             0
2299394 2299394 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_9                                                   0                                             0
2300807 2300807 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring grade_9_transitional                                                   0                                             0
2302220 2302220 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten                                                   63                                             63
2303633 2303633 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring pk_12_total 325.0 91.0 20.0 1.0   1.0     1.0   19.0   246.0 212.0     4.0       197.0         458 325 91 20 1   1     1   19   246 212     4   197       458
2305046 2305046 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 spring pre_kindergarten                                                   18                                             18
2518206 2518206 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_1                                                   78                                             78
2519623 2519623 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_10                                                   0                                             0
2521040 2521040 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_11                                                   0                                             0
2522457 2522457 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_12                                                   0                                             0
2523874 2523874 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_2                                                   76                                             76
2525291 2525291 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_3                                                   69                                             69
2526708 2526708 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_4                                                   72                                             72
2528125 2528125 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_5                                                   72                                             72
2529542 2529542 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_6                                                   0                                             0
2530959 2530959 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_7                                                   0                                             0
2532376 2532376 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_8                                                   0                                             0
2533793 2533793 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_9                                                   0                                             0
2535210 2535210 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall grade_9_transitional                                                   0                                             0
2536627 2536627 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten                                                   60                                             60
2538044 2538044 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall pk_12_total 321.0 84.0 20.0 1.0   1.0     1.0   19.0   236.0 211.0     4.0       184.0         447 321 84 20 1   1     1   19   236 211     4   184       447
2539461 2539461 LA     school 2200300 009   Caddo Parish 220030000198 9060 A.C. Steere Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten                                                   20                                             20
2283699 2283699 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2019 spring grade_1                                                   0                                             0
2285112 2285112 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2019 spring grade_10                                                   9                                             9
2286525 2286525 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2019 spring grade_11                                                   0                                             0
2287938 2287938 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2019 spring grade_12                                                   0                                             0
2289351 2289351 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2019 spring grade_2                                                   0                                             0
2290764 2290764 LA     school 2200030 001   Acadia Parish 220003002381 1036 AMIKids Acadiana   Regular School No Other 04 12 2019 spring grade_3                                                   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]);