Data source: Big Local News · About: Big Local

8,427 rows where grade = "kindergarten" and state = "LA" sorted by school_state_id

View and edit SQL

year

grade

  • kindergarten · 8,427
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
612841 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 spring kindergarten                                                   0                                             0
1783096 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2021 spring kindergarten                                                   0                                             0
2006867 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2021 fall kindergarten                                                   0                                             0
2029277 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2302038 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2019 spring kindergarten                                                   0                                             0
2536445 LA     school 2200030 001   Acadia Parish 220003000001 1001 Armstrong Middle School   Regular School No Middle 06 08 2019 fall kindergarten                                                   0                                             0
612842 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 spring kindergarten                                                   43                                             43
1783097 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2021 spring kindergarten                                                   33                                             33
2006868 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   34                                             34
2029278 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   38                                             38
2302039 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2019 spring kindergarten                                                   35                                             35
2536446 LA     school 2200030 001   Acadia Parish 220003000002 1002 Branch Elementary School   Regular School No Elementary PK 08 2019 fall kindergarten                                                   35                                             35
612843 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 spring kindergarten                                                   141                                             141
1783098 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2021 spring kindergarten                                                   134                                             134
2006869 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2021 fall kindergarten                                                   134                                             134
2029279 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2020 fall kindergarten                                                   142                                             142
2302040 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2019 spring kindergarten                                                   135                                             135
2536447 LA     school 2200030 001   Acadia Parish 220003000003 1003 Central Rayne Kindergarten School   Regular School No Elementary PK KG 2019 fall kindergarten                                                   139                                             139
612844 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten                                                   94                                             94
1783099 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2021 spring kindergarten                                                   90                                             90
2006870 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten                                                   91                                             91
2029280 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   92                                             92
2302041 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten                                                   88                                             88
2536448 LA     school 2200030 001   Acadia Parish 220003001505 1004 Church Point Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten                                                   93                                             93
612845 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 spring kindergarten                                                   0                                             0
1783100 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 spring kindergarten                                                   0                                             0
2006871 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2021 fall kindergarten                                                   0                                             0
2029281 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2020 fall kindergarten                                                   0                                             0
2302042 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 spring kindergarten                                                   0                                             0
2536449 LA     school 2200030 001   Acadia Parish 220003000004 1005 Church Point High School   Regular School No High 08 12 2019 fall kindergarten                                                   0                                             0
612846 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 spring kindergarten                                                   0                                             0
1783101 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2021 spring kindergarten                                                   0                                             0
2006872 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2021 fall kindergarten                                                   0                                             0
2029282 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2302043 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2019 spring kindergarten                                                   0                                             0
2536450 LA     school 2200030 001   Acadia Parish 220003000005 1006 Church Point Middle School   Regular School No Middle 06 08 2019 fall kindergarten                                                   0                                             0
612847 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 spring kindergarten                                                   0                                             0
1783102 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2021 spring kindergarten                                                   0                                             0
2006873 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2021 fall kindergarten                                                   0                                             0
2029283 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2020 fall kindergarten                                                   0                                             0
2302044 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2019 spring kindergarten                                                   0                                             0
2536451 LA     school 2200030 001   Acadia Parish 220003000006 1007 Crowley High School   Regular School No High 07 12 2019 fall kindergarten                                                   0                                             0
612848 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 spring kindergarten                                                   0                                             0
1783103 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2021 spring kindergarten                                                   0                                             0
2006874 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2021 fall kindergarten                                                   0                                             0
2029284 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2302045 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2019 spring kindergarten                                                   0                                             0
2536452 LA     school 2200030 001   Acadia Parish 220003000007 1008 Crowley Middle School   Regular School No Middle 06 08 2019 fall kindergarten                                                   0                                             0
612849 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 spring kindergarten                                                   194                                             194
1783104 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2021 spring kindergarten                                                   202                                             202
2006875 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2021 fall kindergarten                                                   204                                             204
2029285 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2020 fall kindergarten                                                   190                                             190
2302046 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2019 spring kindergarten                                                   183                                             183
2536453 LA     school 2200030 001   Acadia Parish 220003000008 1009 Crowley Kindergarten School   Regular School No Elementary PK KG 2019 fall kindergarten                                                   184                                             184
612850 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten                                                   1                                             1
1783105 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary KG 05 2021 spring kindergarten                                                   0                                             0
2006876 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary KG 05 2021 fall kindergarten                                                   0                                             0
2029286 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   0                                             0
2302047 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary KG 05 2019 spring kindergarten                                                   0                                             0
2536454 LA     school 2200030 001   Acadia Parish 220003000009 1010 North Crowley Elementary School   Regular School No Elementary KG 05 2019 fall kindergarten                                                   0                                             0
612851 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 spring kindergarten                                                   32                                             32
1783106 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2021 spring kindergarten                                                   28                                             28
2006877 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   29                                             29
2029287 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   31                                             31
2302048 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2019 spring kindergarten                                                   31                                             31
2536455 LA     school 2200030 001   Acadia Parish 220003000010 1011 Egan Elementary School   Regular School No Elementary PK 08 2019 fall kindergarten                                                   30                                             30
612852 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 spring kindergarten                                                   23                                             23
1783107 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2021 spring kindergarten                                                   25                                             25
2006878 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2021 fall kindergarten                                                   25                                             25
2029288 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2020 fall kindergarten                                                   22                                             22
2302049 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2019 spring kindergarten                                                   19                                             19
2536456 LA     school 2200030 001   Acadia Parish 220003000011 1012 Estherwood Elementary School   Regular School No Elementary PK 07 2019 fall kindergarten                                                   22                                             22
612853 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 spring kindergarten                                                   19                                             19
1783108 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2021 spring kindergarten                                                   16                                             16
2006879 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2021 fall kindergarten                                                   17                                             17
2029289 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   21                                             21
2302050 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2019 spring kindergarten                                                   16                                             16
2536457 LA     school 2200030 001   Acadia Parish 220003000012 1013 Evangeline Elementary School   Regular School No Elementary PK 08 2019 fall kindergarten                                                   15                                             15
612854 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten                                                   101                                             101
1783109 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2021 spring kindergarten                                                   100                                             100
2006880 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten                                                   99                                             99
2029290 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   98                                             98
2302051 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten                                                   94                                             94
2536458 LA     school 2200030 001   Acadia Parish 220003000013 1014 Iota Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten                                                   93                                             93
612855 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 spring kindergarten                                                   0                                             0
1783110 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2021 spring kindergarten                                                   0                                             0
2006881 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2021 fall kindergarten                                                   0                                             0
2029291 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2020 fall kindergarten                                                   0                                             0
2302052 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2019 spring kindergarten                                                   0                                             0
2536459 LA     school 2200030 001   Acadia Parish 220003001015 1015 Iota Middle School   Regular School No Middle 06 08 2019 fall kindergarten                                                   0                                             0
612856 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 spring kindergarten                                                   19                                             19
1783111 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2021 spring kindergarten                                                   20                                             20
2006882 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2021 fall kindergarten                                                   20                                             20
2029292 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2020 fall kindergarten                                                   20                                             20
2302053 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2019 spring kindergarten                                                   19                                             19
2536460 LA     school 2200030 001   Acadia Parish 220003000015 1016 Mermentau Elementary School   Regular School No Elementary PK 07 2019 fall kindergarten                                                   20                                             20
612857 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 spring kindergarten                                                   0                                             0
1783112 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2021 spring kindergarten                                                   0                                             0
2006883 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2021 fall kindergarten                                                   0                                             0
2029293 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2020 fall kindergarten                                                   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]);