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,080 ✖
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
2295980 2295980 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 spring grade_6                                                   0                                             0
2297393 2297393 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 spring grade_7                                                   0                                             0
2298806 2298806 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 spring grade_8                                                   0                                             0
2300219 2300219 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 spring grade_9                                                   0                                             0
2301632 2301632 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 spring grade_9_transitional                                                   0                                             0
2303045 2303045 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 spring kindergarten                                                   143                                             143
2304458 2304458 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 spring pk_12_total 509.0 93.0 43.0 1.0   6.0     1.0   23.0   329.0 347.0     15.0       412.0         676 509 93 43 1   6     1   23   329 347     15   412       676
2305871 2305871 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 spring pre_kindergarten                                                   61                                             61
2519033 2519033 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_1                                                   169                                             169
2520450 2520450 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_10                                                   0                                             0
2521867 2521867 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_11                                                   0                                             0
2523284 2523284 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_12                                                   0                                             0
2524701 2524701 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_2                                                   165                                             165
2526118 2526118 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_3                                                   133                                             133
2527535 2527535 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_4                                                   0                                             0
2528952 2528952 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_5                                                   0                                             0
2530369 2530369 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_6                                                   0                                             0
2531786 2531786 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_7                                                   0                                             0
2533203 2533203 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_8                                                   0                                             0
2534620 2534620 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_9                                                   0                                             0
2536037 2536037 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall grade_9_transitional                                                   0                                             0
2537454 2537454 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall kindergarten                                                   137                                             137
2538871 2538871 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall pk_12_total 513.0 91.0 38.0 1.0   6.0     1.0   22.0   331.0 341.0     11.0       403.0         672 513 91 38 1   6     1   22   331 341     11   403       672
2540288 2540288 LA     school 2201650 052   St. Tammany Parish 220165001263 52001 Abita Springs Elementary School   Regular School No Elementary PK 03 2019 fall pre_kindergarten                                                   58                                             58
2284677 2284677 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_1                                                   0                                             0
2286090 2286090 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_10                                                   0                                             0
2287503 2287503 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_11                                                   0                                             0
2288916 2288916 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_12                                                   0                                             0
2290329 2290329 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_2                                                   0                                             0
2291742 2291742 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_3                                                   0                                             0
2293155 2293155 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_4                                                   163                                             163
2294568 2294568 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_5                                                   180                                             180
2295981 2295981 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_6                                                   179                                             179
2297394 2297394 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_7                                                   0                                             0
2298807 2298807 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_8                                                   0                                             0
2300220 2300220 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_9                                                   0                                             0
2301633 2301633 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring grade_9_transitional                                                   0                                             0
2303046 2303046 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring kindergarten                                                   0                                             0
2304459 2304459 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring pk_12_total 400.0 62.0 34.0 2.0   2.0     0.0   22.0   257.0 265.0     8.0       290.0         522 400 62 34 2   2     0   22   257 265     8   290       522
2305872 2305872 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 spring pre_kindergarten                                                   0                                             0
2519034 2519034 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_1                                                   0                                             0
2520451 2520451 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_10                                                   0                                             0
2521868 2521868 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_11                                                   0                                             0
2523285 2523285 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_12                                                   0                                             0
2524702 2524702 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_2                                                   0                                             0
2526119 2526119 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_3                                                   0                                             0
2527536 2527536 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_4                                                   163                                             163
2528953 2528953 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_5                                                   175                                             175
2530370 2530370 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_6                                                   174                                             174
2531787 2531787 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_7                                                   0                                             0
2533204 2533204 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_8                                                   0                                             0
2534621 2534621 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_9                                                   0                                             0
2536038 2536038 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall grade_9_transitional                                                   0                                             0
2537455 2537455 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall kindergarten                                                   0                                             0
2538872 2538872 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall pk_12_total 395.0 62.0 31.0 2.0   2.0     0.0   20.0   251.0 261.0     7.0       277.0         512 395 62 31 2   2     0   20   251 261     7   277       512
2540289 2540289 LA     school 2201650 052   St. Tammany Parish 220165001565 52002 Abita Springs Middle School   Regular School No Middle 04 06 2019 fall pre_kindergarten                                                   0                                             0
2284730 2284730 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_1                                                   0                                             0
2286143 2286143 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_10                                                   0                                             0
2287556 2287556 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_11                                                   0                                             0
2288969 2288969 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_12                                                   0                                             0
2290382 2290382 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_2                                                   0                                             0
2291795 2291795 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_3                                                   0                                             0
2293208 2293208 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_4                                                   0                                             0
2294621 2294621 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_5                                                   0                                             0
2296034 2296034 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_6                                                   0                                             0
2297447 2297447 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_7                                                   0                                             0
2298860 2298860 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_8                                                   0                                             0
2300273 2300273 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_9                                                   0                                             0
2301686 2301686 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring grade_9_transitional                                                   0                                             0
2303099 2303099 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring kindergarten                                                   145                                             145
2304512 2304512 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring pk_12_total 85.0 154.0 5.0 2.0   9.0     0.0   4.0   132.0 127.0     3.0       226.0         259 85 154 5 2   9     0   4   132 127     3   226       259
2305925 2305925 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 spring pre_kindergarten                                                   100                                             100
2519087 2519087 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_1                                                   0                                             0
2520504 2520504 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_10                                                   0                                             0
2521921 2521921 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_11                                                   0                                             0
2523338 2523338 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_12                                                   0                                             0
2524755 2524755 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_2                                                   0                                             0
2526172 2526172 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_3                                                   0                                             0
2527589 2527589 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_4                                                   0                                             0
2529006 2529006 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_5                                                   0                                             0
2530423 2530423 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_6                                                   0                                             0
2531840 2531840 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_7                                                   0                                             0
2533257 2533257 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_8                                                   0                                             0
2534674 2534674 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_9                                                   0                                             0
2536091 2536091 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall grade_9_transitional                                                   0                                             0
2537508 2537508 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall kindergarten                                                   149                                             149
2538925 2538925 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall pk_12_total 83.0 157.0 4.0 2.0   10.0     1.0   4.0   132.0 129.0     2.0       231.0         261 83 157 4 2   10     1   4   132 129     2   231       261
2540342 2540342 LA     school 2201650 052   St. Tammany Parish 220165002317 52064 Abney Elementary Early Childhood Center   Regular School No Elementary PK KG 2019 fall pre_kindergarten                                                   101                                             101
2284993 2284993 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_1                                                   0                                             0
2286406 2286406 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_10                                                   162                                             162
2287819 2287819 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_11                                                   145                                             145
2289232 2289232 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_12                                                   119                                             119
2290645 2290645 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_2                                                   0                                             0
2292058 2292058 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_3                                                   0                                             0
2293471 2293471 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_4                                                   0                                             0
2294884 2294884 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_5                                                   0                                             0
2296297 2296297 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_6                                                   0                                             0
2297710 2297710 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_7                                                   0                                             0
2299123 2299123 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_8                                                   0                                             0
2300536 2300536 LA     school   R36   All Orleans   382001 Abramson Sci Academy             2019 spring grade_9                                                   137                                             137

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