enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2292150 2292150 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_4                                                   90                                             90
2293563 2293563 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_5                                                   90                                             90
2294976 2294976 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_6                                                   0                                             0
2296389 2296389 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_7                                                   0                                             0
2297802 2297802 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_8                                                   0                                             0
2299215 2299215 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_9                                                   0                                             0
2300628 2300628 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring grade_9_transitional                                                   0                                             0
2302041 2302041 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten                                                   88                                             88
2303454 2303454 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring pk_12_total 243.0 237.0 47.0 4.0   0.0     0.0   56.0   317.0 270.0     5.0       499.0         587 243 237 47 4   0     0   56   317 270     5   499       587
2304867 2304867 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring pre_kindergarten                                                   55                                             55
2518027 2518027 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_1                                                   82                                             82
2519444 2519444 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_10                                                   0                                             0
2520861 2520861 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_11                                                   0                                             0
2522278 2522278 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_12                                                   0                                             0
2523695 2523695 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_2                                                   95                                             95
2525112 2525112 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_3                                                   92                                             92
2526529 2526529 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_4                                                   89                                             89
2527946 2527946 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_5                                                   86                                             86
2529363 2529363 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_6                                                   0                                             0
2530780 2530780 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_7                                                   0                                             0
2532197 2532197 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_8                                                   0                                             0
2533614 2533614 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_9                                                   0                                             0
2535031 2535031 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall grade_9_transitional                                                   0                                             0
2536448 2536448 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten                                                   93                                             93
2537865 2537865 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall pk_12_total 249.0 243.0 45.0 4.0   0.0     0.0   55.0   328.0 268.0     4.0       502.0         596 249 243 45 4   0     0   55   328 268     4   502       596
2539282 2539282 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten                                                   57                                             57
594645 594645 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_1                                                   0                                             0
596045 596045 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_10                                                   119                                             119
597445 597445 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_11                                                   116                                             116
598845 598845 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_12                                                   124                                             124
600245 600245 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_2                                                   0                                             0
601645 601645 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_3                                                   0                                             0
603045 603045 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_4                                                   0                                             0
604445 604445 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_5                                                   0                                             0
605845 605845 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_6                                                   0                                             0
607245 607245 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_7                                                   0                                             0
608645 608645 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_8                                                   0                                             0
610045 610045 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_9                                                   138                                             138
611445 611445 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring grade_9_transitional                                                   30                                             30
612845 612845 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring kindergarten                                                   0                                             0
614245 614245 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring pk_12_total 338.0 141.0 17.0 0.0   1.0     0.0   30.0   273.0 254.0     2.0       345.0         527 338 141 17 0   1     0   30   273 254     2   345       527
615645 615645 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring pre_kindergarten                                                   0                                             0
1763542 1763542 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring extension_academy                                                   0                                             0
1764939 1764939 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_1                                                   0                                             0
1766336 1766336 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_10                                                   154                                             154
1767733 1767733 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_11                                                   111                                             111
1769130 1769130 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_12                                                   108                                             108
1770527 1770527 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_2                                                   0                                             0
1771924 1771924 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_3                                                   0                                             0
1773321 1773321 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_4                                                   0                                             0
1774718 1774718 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_5                                                   0                                             0
1776115 1776115 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_6                                                   0                                             0
1777512 1777512 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_7                                                   0                                             0
1778909 1778909 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_8                                                   0                                             0
1780306 1780306 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_9                                                   131                                             131
1781703 1781703 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring grade_9_transitional                                                   12                                             12
1783100 1783100 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring kindergarten                                                   0                                             0
1784497 1784497 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring pk_12_total 315.0 150.0 22.0 0.0   0.0     0.0   29.0   260.0 256.0     1.0       371.0         516 315 150 22 0   0     0   29   260 256     1   371       516
1785894 1785894 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring pre_kindergarten                                                   0                                             0
1987285 1987285 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall extension_academy                                                   0                                             0
1988684 1988684 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_1                                                   0                                             0
1990083 1990083 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_10                                                   159                                             159
1991482 1991482 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_11                                                   111                                             111
1992881 1992881 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_12                                                   109                                             109
1994280 1994280 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_2                                                   0                                             0
1995679 1995679 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_3                                                   0                                             0
1997078 1997078 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_4                                                   0                                             0
1998477 1998477 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_5                                                   0                                             0
1999876 1999876 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_6                                                   0                                             0
2001275 2001275 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_7                                                   0                                             0
2002674 2002674 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_8                                                   0                                             0
2004073 2004073 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_9                                                   133                                             133
2005472 2005472 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall grade_9_transitional                                                   12                                             12
2006871 2006871 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall kindergarten                                                   0                                             0
2008270 2008270 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall pk_12_total 320.0 152.0 22.0 0.0   0.0     0.0   30.0   263.0 261.0     1.0       372.0         524 320 152 22 0   0     0   30   263 261     1   372       524
2009669 2009669 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall pre_kindergarten                                                   0                                             0
2011068 2011068 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_1                                                   0                                             0
2012469 2012469 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_10                                                   123                                             123
2013870 2013870 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_11                                                   115                                             115
2015271 2015271 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_12                                                   126                                             126
2016672 2016672 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_2                                                   0                                             0
2018073 2018073 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_3                                                   0                                             0
2019474 2019474 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_4                                                   0                                             0
2020875 2020875 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_5                                                   0                                             0
2022276 2022276 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_6                                                   0                                             0
2023677 2023677 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_7                                                   0                                             0
2025078 2025078 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall grade_8                                                   0                                             0
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
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
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
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
2032083 2032083 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall pre_kindergarten                                                   0                                             0
2283673 2283673 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2285086 2285086 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_10                                                   137                                             137
2286499 2286499 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_11                                                   127                                             127
2287912 2287912 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_12                                                   98                                             98
2289325 2289325 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_2                                                   0                                             0
2290738 2290738 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_3                                                   0                                             0
2292151 2292151 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_4                                                   0                                             0
2293564 2293564 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring grade_5                                                   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);