Data source: Big Local News · About: Big Local

11,992 rows where state = "IN" and year = 2019 sorted by district

View and edit SQL

grade

year

  • 2019 · 11,992
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
1763025 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_1                         45.0 30.0                       75.0                         45 30                 75
1763026 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_10                         39.0 29.0                       68.0                         39 29                 68
1763027 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_11                         35.0 18.0                       53.0                         35 18                 53
1763028 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_12                         22.0 44.0                       66.0                         22 44                 66
1763029 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_2                         32.0 41.0                       73.0                         32 41                 73
1763030 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_3                         37.0 39.0                       76.0                         37 39                 76
1763031 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_4                         36.0 33.0                       69.0                         36 33                 69
1763032 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_5                         25.0 30.0                       55.0                         25 30                 55
1763033 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_6                         27.0 30.0                       57.0                         27 30                 57
1763034 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_7                         47.0 29.0                       76.0                         47 29                 76
1763035 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_8                         38.0 35.0                       73.0                         38 35                 73
1763036 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_9                         33.0 41.0                       74.0                         33 41                 74
1763037 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   kindergarten                         31.0 37.0                       68.0                         31 37                 68
1763038 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   pk_12_total   838.0 23.0               22.0   447.0 436.0     0.0         737.0   114.0   883.0   838 23               22   447 436     0     737 114   883
1763494 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_1                         15.0 19.0                       34.0                         15 19                 34
1763495 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_2                         9.0 8.0                       17.0                         9 8                 17
1763496 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_3                         6.0 8.0                       14.0                         6 8                 14
1763497 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   kindergarten                         16.0 8.0                       24.0                         16 8                 24
1763498 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   pk_12_total 10.0 61.0 7.0               11.0   46.0 43.0     5.0         70.0   10.0   89.0 10 61 7               11   46 43     5     70 10   89
1751546 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_6                         55.0 51.0                       106.0                         55 51                 106
1751547 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_7                         50.0 51.0                       101.0                         50 51                 101
1751548 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 30.0                       82.0                         52 30                 82
1751549 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   pk_12_total 270.0 3.0 12.0     2.0         2.0   157.0 132.0     1.0         74.0   21.0   289.0 270 3 12     2         2   157 132     1     74 21   289
1751550 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_1                         64.0 62.0                       126.0                         64 62                 126
1751551 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_2                         60.0 39.0                       99.0                         60 39                 99
1751552 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_3                         50.0 43.0                       93.0                         50 43                 93
1751553 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_4                         54.0 52.0                       106.0                         54 52                 106
1751554 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_5                         64.0 41.0                       105.0                         64 41                 105
1751555 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         51.0 46.0                       97.0                         51 46                 97
1751556 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 574.0 6.0 31.0 1.0   2.0         17.0   347.0 284.0     24.0         171.0   95.0   631.0 574 6 31 1   2         17   347 284     24     171 95   631
1751557 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         4.0 1.0                       5.0                         4 1                 5
1751558 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   adult                         3.0 0.0                       3.0                         3 0                 3
1751559 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_10                         48.0 55.0                       103.0                         48 55                 103
1751560 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_11                         40.0 52.0                       92.0                         40 52                 92
1751561 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_12                         48.0 50.0                       98.0                         48 50                 98
1751562 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_9                         38.0 40.0                       78.0                         38 40                 78
1751563 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   pk_12_total 350.0 5.0 5.0 1.0   7.0         6.0   177.0 197.0     6.0         74.0   22.0   374.0 350 5 5 1   7         6   177 197     6     74 22   374
1757482 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   grade_10                         62.0 64.0                       126.0                         62 64                 126
1757483 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   grade_11                         64.0 57.0                       121.0                         64 57                 121
1757484 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   grade_12                         49.0 48.0                       97.0                         49 48                 97
1757485 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   grade_7                         79.0 53.0                       132.0                         79 53                 132
1757486 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   grade_8                         59.0 61.0                       120.0                         59 61                 120
1757487 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   grade_9                         50.0 67.0                       117.0                         50 67                 117
1757488 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2019   pk_12_total 642.0 1.0 51.0     2.0         17.0   363.0 350.0     10.0         338.0   107.0   713.0 642 1 51     2         17   363 350     10     338 107   713
1757489 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_3                         65.0 49.0                       114.0                         65 49                 114
1757490 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_4                         65.0 67.0                       132.0                         65 67                 132
1757491 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_5                         63.0 48.0                       111.0                         63 48                 111
1757492 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_6                         51.0 50.0                       101.0                         51 50                 101
1757493 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   pk_12_total 402.0 2.0 37.0               17.0   244.0 214.0     6.0         263.0   95.0   458.0 402 2 37               17   244 214     6     263 95   458
1757494 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   grade_1                         62.0 53.0                       115.0                         62 53                 115
1757495 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   grade_2                         52.0 54.0                       106.0                         52 54                 106
1757496 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   kindergarten                         59.0 47.0                       106.0                         59 47                 106
1757497 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   pk_12_total 314.0 2.0 36.0     2.0     1.0   14.0   195.0 174.0     8.0         199.0   91.0   369.0 314 2 36     2     1   14   195 174     8     199 91   369
1757498 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   pre_kindergarten                         22.0 20.0                       42.0                         22 20                 42
1762731 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 01 2019   grade_1                         9.0 5.0                       14.0                         9 5                 14
1762732 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 01 2019   kindergarten                         12.0 11.0                       23.0                         12 11                 23
1762733 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 01 2019   pk_12_total 1.0 33.0 1.0               2.0   21.0 16.0     1.0         36.0   4.0   37.0 1 33 1               2   21 16     1     36 4   37
1757499 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_10                         5.0 5.0                       10.0                         5 5                 10
1757500 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_6                         5.0 1.0                       6.0                         5 1                 6
1757501 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_7                         9.0 3.0                       12.0                         9 3                 12
1757502 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_8                         25.0 5.0                       30.0                         25 5                 30
1757503 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_9                         13.0 3.0                       16.0                         13 3                 16
1757504 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   pk_12_total 26.0 27.0 9.0               12.0   57.0 17.0     3.0         66.0   19.0   74.0 26 27 9               12   57 17     3     66 19   74
1757505 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2019   grade_10                         231.0 194.0                       425.0                         231 194                 425
1757506 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2019   grade_11                         253.0 218.0                       471.0                         253 218                 471
1757507 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2019   grade_12                         250.0 202.0                       452.0                         250 202                 452
1757508 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2019   grade_9                         226.0 210.0                       436.0                         226 210                 436
1757509 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2019   pk_12_total 982.0 439.0 235.0 2.0   8.0         118.0   960.0 824.0     59.0         1180.0   377.0   1784.0 982 439 235 2   8         118   960 824     59     1180 377   1784
1757510 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   grade_1                         27.0 25.0                       52.0                         27 25                 52
1757511 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   grade_2                         23.0 26.0                       49.0                         23 26                 49
1757512 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   grade_3                         28.0 22.0                       50.0                         28 22                 50
1757513 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   grade_4                         23.0 28.0                       51.0                         23 28                 51
1757514 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   grade_5                         29.0 22.0                       51.0                         29 22                 51
1757515 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         35.0 28.0                       63.0                         35 28                 63
1757516 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 150.0 104.0 19.0     1.0         42.0   165.0 151.0     3.0         218.0   55.0   316.0 150 104 19     1         42   165 151     3     218 55   316
1757517 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   grade_1                         49.0 50.0                       99.0                         49 50                 99
1757518 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   grade_2                         72.0 53.0                       125.0                         72 53                 125
1757519 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   grade_3                         59.0 38.0                       97.0                         59 38                 97
1757520 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   grade_4                         58.0 37.0                       95.0                         58 37                 95
1757521 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   grade_5                         44.0 48.0                       92.0                         44 48                 92
1757522 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         37.0 45.0                       82.0                         37 45                 82
1757523 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 357.0 104.0 55.0 2.0   2.0         70.0   319.0 271.0     14.0         476.0   142.0   590.0 357 104 55 2   2         70   319 271     14     476 142   590
1757524 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2019   pk_12_total 150.0 20.0 37.0     2.0         17.0   137.0 89.0     0.0         127.0   104.0   226.0 150 20 37     2         17   137 89     0     127 104   226
1757525 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         137.0 89.0                       226.0                         137 89                 226
1757526 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_1                         65.0 44.0                       109.0                         65 44                 109
1757527 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_2                         47.0 51.0                       98.0                         47 51                 98
1757528 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_3                         56.0 49.0                       105.0                         56 49                 105
1757529 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_4                         61.0 36.0                       97.0                         61 36                 97
1757530 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_5                         48.0 48.0                       96.0                         48 48                 96
1757531 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         50.0 35.0                       85.0                         50 35                 85
1757532 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 356.0 120.0 45.0     1.0         68.0   327.0 263.0     20.0         458.0   137.0   590.0 356 120 45     1         68   327 263     20     458 137   590
1757533 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2019   grade_6                         287.0 262.0                       549.0                         287 262                 549
1757534 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2019   grade_7                         250.0 256.0                       506.0                         250 256                 506
1757535 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2019   grade_8                         230.0 219.0                       449.0                         230 219                 449
1757536 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2019   pk_12_total 824.0 327.0 219.0 1.0   1.0         132.0   767.0 737.0     49.0         1093.0   297.0   1504.0 824 327 219 1   1         132   767 737     49     1093 297   1504
1757537 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2019   grade_1                         58.0 48.0                       106.0                         58 48                 106
1757538 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2019   grade_2                         38.0 39.0                       77.0                         38 39                 77
1757539 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2019   grade_3                         51.0 41.0                       92.0                         51 41                 92
1757540 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2019   grade_4                         46.0 58.0                       104.0                         46 58                 104
1757541 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2019   grade_5                         59.0 55.0                       114.0                         59 55                 114

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