Data source: Big Local News · About: Big Local

84,143 rows where state = "IN"

View and edit SQL

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
1162480 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No 3.0 09 12 2015   grade_9                         401.0 404.0                       805.0                         401 404                 805
1162481 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No 3.0 09 12 2015   pk_12_total 2344.0 226.0 141.0 7.0   173.0     6.0   120.0   1512.0 1505.0     44.0             282.0   3017.0 2344 226 141 7   173     6   120   1512 1505     44       282   3017
1162482 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         256.0 239.0                       495.0                         256 239                 495
1162483 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2015   grade_6                         261.0 228.0                       489.0                         261 228                 489
1162484 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2015   pk_12_total 757.0 63.0 52.0 2.0   54.0         56.0   517.0 467.0     26.0             122.0   984.0 757 63 52 2   54         56   517 467     26       122   984
1162485 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No 3.0 09 12 2015   grade_10                         94.0 74.0                       168.0                         94 74                 168
1162486 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No 3.0 09 12 2015   grade_11                         89.0 73.0                       162.0                         89 73                 162
1162487 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No 3.0 09 12 2015   grade_12                         90.0 80.0                       170.0                         90 80                 170
1162488 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No 3.0 09 12 2015   grade_9                         101.0 83.0                       184.0                         101 83                 184
1162489 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No 3.0 09 12 2015   pk_12_total 654.0 7.0 17.0 1.0   1.0         4.0   374.0 310.0     6.0             115.0   684.0 654 7 17 1   1         4   374 310     6       115   684
1162490 IN     school 1804260 3025   Hamilton Heights School Corp 180426002134 2478 Hamilton Heights Elem School   Regular School No 1.0 03 05 2015   grade_3                         110.0 91.0                       201.0                         110 91                 201
1162491 IN     school 1804260 3025   Hamilton Heights School Corp 180426002134 2478 Hamilton Heights Elem School   Regular School No 1.0 03 05 2015   grade_4                         89.0 73.0                       162.0                         89 73                 162
1162492 IN     school 1804260 3025   Hamilton Heights School Corp 180426002134 2478 Hamilton Heights Elem School   Regular School No 1.0 03 05 2015   grade_5                         88.0 84.0                       172.0                         88 84                 172
1162493 IN     school 1804260 3025   Hamilton Heights School Corp 180426002134 2478 Hamilton Heights Elem School   Regular School No 1.0 03 05 2015   pk_12_total 498.0 11.0 15.0 4.0   2.0         5.0   287.0 248.0     5.0             67.0   535.0 498 11 15 4   2         5   287 248     5       67   535
1162494 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle Sch   Regular School No 2.0 06 08 2015   grade_6                         97.0 89.0                       186.0                         97 89                 186
1162495 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         85.0 103.0                       188.0                         85 103                 188
1162496 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         90.0 95.0                       185.0                         90 95                 185
1162497 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle Sch   Regular School No 2.0 06 08 2015   pk_12_total 526.0 10.0 12.0 4.0   4.0         3.0   272.0 287.0     1.0             90.0   559.0 526 10 12 4   4         3   272 287     1       90   559
1162498 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2015   grade_1                         89.0 67.0                       156.0                         89 67                 156
1162499 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2015   grade_2                         79.0 76.0                       155.0                         79 76                 155
1162500 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2015   kindergarten                         68.0 68.0                       136.0                         68 68                 136
1162501 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2015   pk_12_total 459.0 8.0 12.0     3.0         11.0   263.0 230.0     3.0             62.0   493.0 459 8 12     3         11   263 230     3       62   493
1162502 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         27.0 19.0                       46.0                         27 19                 46
1162503 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2015   grade_6                         2.0 0.0                       2.0                         2 0                 2
1162504 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2015   grade_7                         289.0 245.0                       534.0                         289 245                 534
1162505 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2015   grade_8                         245.0 261.0                       506.0                         245 261                 506
1162506 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No 2.0 06 08 2015   pk_12_total 866.0 28.0 67.0 1.0   28.0         52.0   536.0 506.0     31.0             142.0   1042.0 866 28 67 1   28         52   536 506     31       142   1042
1162507 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         43.0 53.0                       96.0                         43 53                 96
1162508 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_2                         40.0 44.0                       84.0                         40 44                 84
1162509 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         59.0 59.0                       118.0                         59 59                 118
1162510 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         51.0 40.0                       91.0                         51 40                 91
1162511 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   kindergarten                         44.0 43.0                       87.0                         44 43                 87
1162512 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   pk_12_total 418.0 10.0 6.0 1.0   12.0         29.0   237.0 239.0     0.0             84.0   476.0 418 10 6 1   12         29   237 239     0       84   476
1162513 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   adult                         4.0 2.0                       6.0                         4 2                 6
1162514 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   grade_10                         244.0 243.0                       487.0                         244 243                 487
1162515 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   grade_11                         217.0 228.0                       445.0                         217 228                 445
1162516 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   grade_12                         230.0 210.0                       440.0                         230 210                 440
1162517 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   grade_9                         286.0 270.0                       556.0                         286 270                 556
1162518 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   pk_12_total 1625.0 52.0 141.0 1.0   42.0         73.0   981.0 953.0     45.0             248.0   1934.0 1625 52 141 1   42         73   981 953     45       248   1934
1162519 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_1                         64.0 66.0                       130.0                         64 66                 130
1162520 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_2                         61.0 42.0                       103.0                         61 42                 103
1162521 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_3                         41.0 49.0                       90.0                         41 49                 90
1162522 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_4                         47.0 47.0                       94.0                         47 47                 94
1162523 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1162524 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   pk_12_total 425.0 19.0 63.0 3.0   17.0         20.0   288.0 259.0     40.0             95.0   547.0 425 19 63 3   17         20   288 259     40       95   547
1162525 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   pre_kindergarten                         20.0 9.0                       29.0                         20 9                 29
1162526 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         38.0 47.0                       85.0                         38 47                 85
1162527 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         37.0 42.0                       79.0                         37 42                 79
1162528 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         41.0 44.0                       85.0                         41 44                 85
1162529 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         49.0 27.0                       76.0                         49 27                 76
1162530 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         38.0 28.0                       66.0                         38 28                 66
1162531 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   pk_12_total 273.0 7.0 78.0 1.0   5.0         27.0   203.0 188.0     44.0             63.0   391.0 273 7 78 1   5         27   203 188     44       63   391
1162532 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_1                         52.0 62.0                       114.0                         52 62                 114
1162533 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_2                         62.0 59.0                       121.0                         62 59                 121
1162534 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_3                         56.0 48.0                       104.0                         56 48                 104
1162535 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_4                         57.0 47.0                       104.0                         57 47                 104
1162536 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   kindergarten                         60.0 57.0                       117.0                         60 57                 117
1162537 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   pk_12_total 514.0 12.0 8.0     15.0         30.0   302.0 277.0     1.0             77.0   579.0 514 12 8     15         30   302 277     1       77   579
1162538 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   pre_kindergarten                         15.0 4.0                       19.0                         15 4                 19
1162539 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         34.0 28.0                       62.0                         34 28                 62
1162540 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         28.0 24.0                       52.0                         28 24                 52
1162541 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         20.0 22.0                       42.0                         20 22                 42
1162542 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         30.0 21.0                       51.0                         30 21                 51
1162543 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         49.0 29.0                       78.0                         49 29                 78
1162544 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   pk_12_total 201.0 10.0 60.0 1.0   12.0         10.0   168.0 126.0     49.0             89.0   294.0 201 10 60 1   12         10   168 126     49       89   294
1162545 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         7.0 2.0                       9.0                         7 2                 9
1162546 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         306.0 279.0                       585.0                         306 279                 585
1162547 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No 2.0 05 06 2015   grade_6                         271.0 268.0                       539.0                         271 268                 539
1162548 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No 2.0 05 06 2015   pk_12_total 920.0 27.0 90.0     33.0         54.0   577.0 547.0     39.0             162.0   1124.0 920 27 90     33         54   577 547     39       162   1124
1162549 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_1                         49.0 32.0                       81.0                         49 32                 81
1162550 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_2                         66.0 53.0                       119.0                         66 53                 119
1162551 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_3                         73.0 33.0                       106.0                         73 33                 106
1162552 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_4                         48.0 51.0                       99.0                         48 51                 99
1162553 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   kindergarten                         53.0 55.0                       108.0                         53 55                 108
1162554 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   pk_12_total 445.0 18.0 17.0 4.0   15.0         27.0   297.0 229.0     1.0             76.0   526.0 445 18 17 4   15         27   297 229     1       76   526
1162555 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1162556 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No 3.0 09 12 2015   grade_10                         43.0 31.0                       74.0                         43 31                 74
1162557 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No 3.0 09 12 2015   grade_11                         42.0 38.0                       80.0                         42 38                 80
1162558 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No 3.0 09 12 2015   grade_12                         39.0 48.0                       87.0                         39 48                 87
1162559 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No 3.0 09 12 2015   grade_9                         44.0 39.0                       83.0                         44 39                 83
1162560 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No 3.0 09 12 2015   pk_12_total 305.0 2.0 8.0               9.0   168.0 156.0     1.0             59.0   324.0 305 2 8               9   168 156     1       59   324
1162561 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         39.0 36.0                       75.0                         39 36                 75
1162562 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         46.0 29.0                       75.0                         46 29                 75
1162563 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         49.0 37.0                       86.0                         49 37                 86
1162564 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         43.0 31.0                       74.0                         43 31                 74
1162565 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         47.0 36.0                       83.0                         47 36                 83
1162566 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         38.0 43.0                       81.0                         38 43                 81
1162567 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   pk_12_total 448.0   24.0     1.0     1.0   11.0   270.0 215.0     4.0             85.0   485.0 448   24     1     1   11   270 215     4       85   485
1162568 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         8.0 3.0                       11.0                         8 3                 11
1162569 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No 2.0 06 08 2015   grade_6                         52.0 31.0                       83.0                         52 31                 83
1162570 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No 2.0 06 08 2015   grade_7                         48.0 33.0                       81.0                         48 33                 81
1162571 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No 2.0 06 08 2015   grade_8                         47.0 40.0                       87.0                         47 40                 87
1162572 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No 2.0 06 08 2015   pk_12_total 240.0   6.0               5.0   147.0 104.0     2.0             44.0   251.0 240   6               5   147 104     2       44   251
1162573 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No 3.0 09 12 2015   grade_10                         626.0 597.0                       1223.0                         626 597                 1223
1162574 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No 3.0 09 12 2015   grade_11                         604.0 614.0                       1218.0                         604 614                 1218
1162575 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No 3.0 09 12 2015   grade_12                         598.0 614.0                       1212.0                         598 614                 1212
1162576 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No 3.0 09 12 2015   grade_9                         586.0 591.0                       1177.0                         586 591                 1177
1162577 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No 3.0 09 12 2015   pk_12_total 3782.0 182.0 126.0 12.0   518.0     12.0   198.0   2414.0 2416.0     102.0             430.0   4830.0 3782 182 126 12   518     12   198   2414 2416     102       430   4830
1162578 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No 2.0 06 08 2015   grade_6                         181.0 201.0                       382.0                         181 201                 382
1162579 IN     school 1801200 3060   Carmel Clay Schools 180120000195 2506 Clay Middle School   Regular School No 2.0 06 08 2015   grade_7                         209.0 196.0                       405.0                         209 196                 405

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