enrollments

Data source: Big Local News · About: Big Local

44,816 rows where state = "LA" and year = 2020 sorted by district descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 44,560 ✖
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
595857 595857 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_1                                                   18                                             18
595858 595858 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_1                                                   19                                             19
595859 595859 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_1                                                   15                                             15
595860 595860 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_1                                                   88                                             88
595861 595861 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_1                                                   0                                             0
595862 595862 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
597257 597257 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_10                                                   14                                             14
597258 597258 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_10                                                   27                                             27
597259 597259 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_10                                                   24                                             24
597260 597260 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_10                                                   0                                             0
597261 597261 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_10                                                   0                                             0
597262 597262 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_10                                                   87                                             87
598657 598657 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_11                                                   14                                             14
598658 598658 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_11                                                   24                                             24
598659 598659 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_11                                                   24                                             24
598660 598660 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_11                                                   0                                             0
598661 598661 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_11                                                   0                                             0
598662 598662 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_11                                                   80                                             80
600057 600057 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_12                                                   9                                             9
600058 600058 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_12                                                   16                                             16
600059 600059 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_12                                                   24                                             24
600060 600060 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_12                                                   0                                             0
600061 600061 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_12                                                   0                                             0
600062 600062 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_12                                                   87                                             87
601457 601457 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_2                                                   20                                             20
601458 601458 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_2                                                   23                                             23
601459 601459 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_2                                                   17                                             17
601460 601460 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_2                                                   81                                             81
601461 601461 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_2                                                   0                                             0
601462 601462 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_2                                                   0                                             0
602857 602857 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_3                                                   18                                             18
602858 602858 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_3                                                   27                                             27
602859 602859 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_3                                                   25                                             25
602860 602860 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_3                                                   81                                             81
602861 602861 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602862 602862 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
604257 604257 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_4                                                   13                                             13
604258 604258 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_4                                                   22                                             22
604259 604259 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_4                                                   27                                             27
604260 604260 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_4                                                   107                                             107
604261 604261 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_4                                                   0                                             0
604262 604262 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_4                                                   0                                             0
605657 605657 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_5                                                   15                                             15
605658 605658 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_5                                                   29                                             29
605659 605659 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_5                                                   25                                             25
605660 605660 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_5                                                   0                                             0
605661 605661 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_5                                                   104                                             104
605662 605662 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_5                                                   0                                             0
607057 607057 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_6                                                   22                                             22
607058 607058 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_6                                                   21                                             21
607059 607059 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_6                                                   24                                             24
607060 607060 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_6                                                   0                                             0
607061 607061 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_6                                                   97                                             97
607062 607062 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_6                                                   0                                             0
608457 608457 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_7                                                   18                                             18
608458 608458 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_7                                                   17                                             17
608459 608459 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_7                                                   26                                             26
608460 608460 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_7                                                   0                                             0
608461 608461 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_7                                                   103                                             103
608462 608462 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_7                                                   0                                             0
609857 609857 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_8                                                   20                                             20
609858 609858 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_8                                                   22                                             22
609859 609859 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_8                                                   19                                             19
609860 609860 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_8                                                   0                                             0
609861 609861 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_8                                                   91                                             91
609862 609862 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_8                                                   0                                             0
611257 611257 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_9                                                   12                                             12
611258 611258 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_9                                                   21                                             21
611259 611259 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_9                                                   29                                             29
611260 611260 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_9                                                   0                                             0
611261 611261 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_9                                                   0                                             0
611262 611262 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_9                                                   95                                             95
612657 612657 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_9_transitional                                                   7                                             7
612658 612658 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_9_transitional                                                   1                                             1
612659 612659 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_9_transitional                                                   0                                             0
612660 612660 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_9_transitional                                                   0                                             0
612661 612661 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_9_transitional                                                   0                                             0
612662 612662 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_9_transitional                                                   22                                             22
614057 614057 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring kindergarten                                                   19                                             19
614058 614058 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring kindergarten                                                   24                                             24
614059 614059 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring kindergarten                                                   16                                             16
614060 614060 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring kindergarten                                                   77                                             77
614061 614061 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring kindergarten                                                   0                                             0
614062 614062 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring kindergarten                                                   0                                             0
615457 615457 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring pk_12_total 114.0 112.0 6.0 1.0   0.0     0.0   6.0   119.0 120.0     0.0       201.0         239 114 112 6 1   0     0   6   119 120     0   201       239
615458 615458 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring pk_12_total 251.0 48.0 8.0 1.0   0.0     0.0   5.0   165.0 148.0     0.0       176.0         313 251 48 8 1   0     0   5   165 148     0   176       313
615459 615459 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring pk_12_total 279.0 19.0 11.0 2.0   0.0     0.0   4.0   148.0 167.0     3.0000000000000004       248.0         315 279 19 11 2   0     0   4   148 167         248       315
615460 615460 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring pk_12_total 235.0 219.0 11.0 0.0   0.0     0.0   13.0   267.0 211.0     0.0       407.0         478 235 219 11 0   0     0   13   267 211     0   407       478
615461 615461 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring pk_12_total 197.0 176.0 16.0 0.0   0.0     0.0   6.0   208.0 187.0     1.0       293.0         395 197 176 16 0   0     0   6   208 187     1   293       395
615462 615462 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring pk_12_total 188.0 167.0 8.0 0.0   4.0     0.0   4.0   189.0 182.0     0.0       253.0         371 188 167 8 0   4     0   4   189 182     0   253       371
616857 616857 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   18                                             18
616858 616858 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   18                                             18
616859 616859 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   20                                             20
616860 616860 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring pre_kindergarten                                                   36                                             36
616861 616861 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring pre_kindergarten                                                   0                                             0
616862 616862 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring pre_kindergarten                                                   0                                             0
2012280 2012280 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 fall grade_1                                                   17                                             17
2012281 2012281 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 fall grade_1                                                   20                                             20
2012282 2012282 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 fall grade_1                                                   14                                             14
2012283 2012283 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 fall grade_1                                                   91                                             91

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