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
1168538 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High Sch   Regular School No 3.0 09 12 2015   grade_10                         95.0 96.0                       191.0                         95 96                 191
1168539 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High Sch   Regular School No 3.0 09 12 2015   grade_11                         79.0 111.0                       190.0                         79 111                 190
1168540 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High Sch   Regular School No 3.0 09 12 2015   grade_12                         81.0 81.0                       162.0                         81 81                 162
1168541 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High Sch   Regular School No 3.0 09 12 2015   grade_9                         111.0 86.0                       197.0                         111 86                 197
1168542 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High Sch   Regular School No 3.0 09 12 2015   pk_12_total 714.0 6.0 10.0     3.0     1.0   23.0   372.0 385.0     7.0             81.0   757.0 714 6 10     3     1   23   372 385     7       81   757
1168543 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         105.0 108.0                       213.0                         105 108                 213
1168544 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         106.0 98.0                       204.0                         106 98                 204
1168545 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle Sch   Regular School No 2.0 07 08 2015   pk_12_total 394.0 4.0 8.0 1.0   1.0     1.0   8.0   211.0 206.0     2.0             54.0   417.0 394 4 8 1   1     1   8   211 206     2       54   417
1168546 IN     school 1809120 7150   John Glenn School Corporation 180912001504 5916 Harold C Urey Middle School   Regular School No 2.0 07 08 2015   grade_7                         72.0 57.0                       129.0                         72 57                 129
1168547 IN     school 1809120 7150   John Glenn School Corporation 180912001504 5916 Harold C Urey Middle School   Regular School No 2.0 07 08 2015   grade_8                         76.0 51.0                       127.0                         76 51                 127
1168548 IN     school 1809120 7150   John Glenn School Corporation 180912001504 5916 Harold C Urey Middle School   Regular School No 2.0 07 08 2015   pk_12_total 228.0   17.0 2.0   4.0         5.0   148.0 108.0     3.0             26.0   256.0 228   17 2   4         5   148 108     3       26   256
1168549 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1168550 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No 3.0 09 12 2015   grade_10                         89.0 75.0                       164.0                         89 75                 164
1168551 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No 3.0 09 12 2015   grade_11                         75.0 100.0                       175.0                         75 100                 175
1168552 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No 3.0 09 12 2015   grade_12                         71.0 77.0                       148.0                         71 77                 148
1168553 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No 3.0 09 12 2015   grade_9                         63.0 74.0                       137.0                         63 74                 137
1168554 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No 3.0 09 12 2015   pk_12_total 572.0 5.0 22.0 9.0   3.0         14.0   299.0 326.0     5.0             53.0   625.0 572 5 22 9   3         14   299 326     5       53   625
1168555 IN     school 1809120 7150   John Glenn School Corporation 180912002210 7456 North Liberty School   Regular School No 1.0 KG 06 2015   grade_1                         27.0 37.0                       64.0                         27 37                 64
1168556 IN     school 1809120 7150   John Glenn School Corporation 180912002210 7456 North Liberty School   Regular School No 1.0 KG 06 2015   grade_2                         45.0 32.0                       77.0                         45 32                 77
1168557 IN     school 1809120 7150   John Glenn School Corporation 180912002210 7456 North Liberty School   Regular School No 1.0 KG 06 2015   grade_3                         40.0 35.0                       75.0                         40 35                 75
1168558 IN     school 1809120 7150   John Glenn School Corporation 180912002210 7456 North Liberty School   Regular School No 1.0 KG 06 2015   grade_4                         47.0 35.0                       82.0                         47 35                 82
1168559 IN     school 1809120 7150   John Glenn School Corporation 180912002210 7456 North Liberty School   Regular School No 1.0 KG 06 2015   grade_5                         45.0 32.0                       77.0                         45 32                 77
1168560 IN     school 1809120 7150   John Glenn School Corporation 180912002210 7456 North Liberty School   Regular School No 1.0 KG 06 2015   grade_6                         39.0 35.0                       74.0                         39 35                 74
1168561 IN     school 1809120 7150   John Glenn School Corporation 180912002210 7456 North Liberty School   Regular School No 1.0 KG 06 2015   kindergarten                         37.0 45.0                       82.0                         37 45                 82
1168562 IN     school 1809120 7150   John Glenn School Corporation 180912002210 7456 North Liberty School   Regular School No 1.0 KG 06 2015   pk_12_total 489.0   23.0 1.0             18.0   280.0 251.0     2.0             78.0   531.0 489   23 1             18   280 251     2       78   531
1168563 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         29.0 27.0                       56.0                         29 27                 56
1168564 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         29.0 33.0                       62.0                         29 33                 62
1168565 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         33.0 28.0                       61.0                         33 28                 61
1168566 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         39.0 40.0                       79.0                         39 40                 79
1168567 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         34.0 20.0                       54.0                         34 20                 54
1168568 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         29.0 31.0                       60.0                         29 31                 60
1168569 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         35.0 38.0                       73.0                         35 38                 73
1168570 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   pk_12_total 429.0 5.0 36.0 2.0             21.0   250.0 243.0     8.0             70.0   493.0 429 5 36 2             21   250 243     8       70   493
1168571 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         22.0 26.0                       48.0                         22 26                 48
1168572 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001454 7323 Walt Disney Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         43.0 35.0                       78.0                         43 35                 78
1168573 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001454 7323 Walt Disney Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         34.0 51.0                       85.0                         34 51                 85
1168574 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001454 7323 Walt Disney Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         43.0 34.0                       77.0                         43 34                 77
1168575 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001454 7323 Walt Disney Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         44.0 28.0                       72.0                         44 28                 72
1168576 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001454 7323 Walt Disney Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         32.0 32.0                       64.0                         32 32                 64
1168577 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001454 7323 Walt Disney Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         30.0 32.0                       62.0                         30 32                 62
1168578 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001454 7323 Walt Disney Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 237.0 93.0 42.0 1.0   34.0     1.0   30.0   226.0 212.0     37.0             53.0   438.0 237 93 42 1   34     1   30   226 212     37       53   438
1168579 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876002341 7324 Prairie Vista   Regular School No 1.0 KG 05 2015   grade_1                         38.0 44.0                       82.0                         38 44                 82
1168580 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876002341 7324 Prairie Vista   Regular School No 1.0 KG 05 2015   grade_2                         36.0 44.0                       80.0                         36 44                 80
1168581 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876002341 7324 Prairie Vista   Regular School No 1.0 KG 05 2015   grade_3                         43.0 51.0                       94.0                         43 51                 94
1168582 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876002341 7324 Prairie Vista   Regular School No 1.0 KG 05 2015   grade_4                         28.0 32.0                       60.0                         28 32                 60
1168583 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876002341 7324 Prairie Vista   Regular School No 1.0 KG 05 2015   grade_5                         48.0 45.0                       93.0                         48 45                 93
1168584 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876002341 7324 Prairie Vista   Regular School No 1.0 KG 05 2015   kindergarten                         41.0 35.0                       76.0                         41 35                 76
1168585 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876002341 7324 Prairie Vista   Regular School No 1.0 KG 05 2015   pk_12_total 387.0 10.0 30.0     42.0         16.0   234.0 251.0     24.0             54.0   485.0 387 10 30     42         16   234 251     24       54   485
1168586 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001448 7329 Mary Frank Harris Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         33.0 22.0                       55.0                         33 22                 55
1168587 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001448 7329 Mary Frank Harris Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         31.0 33.0                       64.0                         31 33                 64
1168588 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001448 7329 Mary Frank Harris Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         26.0 26.0                       52.0                         26 26                 52
1168589 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001448 7329 Mary Frank Harris Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         35.0 31.0                       66.0                         35 31                 66
1168590 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001448 7329 Mary Frank Harris Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         31.0 40.0                       71.0                         31 40                 71
1168591 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001448 7329 Mary Frank Harris Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         27.0 26.0                       53.0                         27 26                 53
1168592 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001448 7329 Mary Frank Harris Elementary Sch   Regular School No 1.0 KG 05 2015   pk_12_total 298.0 8.0 17.0 2.0   26.0         10.0   183.0 178.0     15.0             50.0   361.0 298 8 17 2   26         10   183 178     15       50   361
1168593 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001452 7334 Schmucker Middle School   Regular School No 2.0 06 08 2015   grade_6                         138.0 158.0                       296.0                         138 158                 296
1168594 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001452 7334 Schmucker Middle School   Regular School No 2.0 06 08 2015   grade_7                         163.0 153.0                       316.0                         163 153                 316
1168595 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001452 7334 Schmucker Middle School   Regular School No 2.0 06 08 2015   grade_8                         151.0 168.0                       319.0                         151 168                 319
1168596 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001452 7334 Schmucker Middle School   Regular School No 2.0 06 08 2015   pk_12_total 736.0 58.0 39.0 6.0   50.0     2.0   40.0   452.0 479.0     29.0             121.0   931.0 736 58 39 6   50     2   40   452 479     29       121   931
1168597 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001453 7336 Virgil I Grissom Middle Sch   Regular School No 2.0 06 08 2015   grade_6                         106.0 93.0                       199.0                         106 93                 199
1168598 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001453 7336 Virgil I Grissom Middle Sch   Regular School No 2.0 06 08 2015   grade_7                         96.0 95.0                       191.0                         96 95                 191
1168599 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001453 7336 Virgil I Grissom Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         107.0 102.0                       209.0                         107 102                 209
1168600 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001453 7336 Virgil I Grissom Middle Sch   Regular School No 2.0 06 08 2015   pk_12_total 487.0 29.0 37.0 4.0   15.0     1.0   26.0   309.0 290.0     14.0             82.0   599.0 487 29 37 4   15     1   26   309 290     14       82   599
1168601 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         14.0 8.0                       22.0                         14 8                 22
1168602 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         12.0 17.0                       29.0                         12 17                 29
1168603 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         9.0 9.0                       18.0                         9 9                 18
1168604 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         11.0 12.0                       23.0                         11 12                 23
1168605 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         10.0 17.0                       27.0                         10 17                 27
1168606 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         12.0 8.0                       20.0                         12 8                 20
1168607 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 124.0 1.0 5.0 1.0             8.0   68.0 71.0     0.0             29.0   139.0 124 1 5 1             8   68 71     0       29   139
1168608 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1168609 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2015   grade_10                         433.0 426.0                       859.0                         433 426                 859
1168610 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2015   grade_11                         421.0 430.0                       851.0                         421 430                 851
1168611 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2015   grade_12                         402.0 378.0                       780.0                         402 378                 780
1168612 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2015   grade_9                         438.0 445.0                       883.0                         438 445                 883
1168613 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2015   pk_12_total 2785.0 145.0 125.0 21.0   169.0     5.0   126.0   1696.0 1680.0     56.0             320.0   3376.0 2785 145 125 21   169     5   126   1696 1680     56       320   3376
1168614 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         51.0 36.0                       87.0                         51 36                 87
1168615 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         50.0 39.0                       89.0                         50 39                 89
1168616 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         48.0 45.0                       93.0                         48 45                 93
1168617 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         38.0 35.0                       73.0                         38 35                 73
1168618 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         38.0 28.0                       66.0                         38 28                 66
1168619 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         55.0 41.0                       96.0                         55 41                 96
1168620 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 428.0 20.0 24.0 2.0   8.0         22.0   280.0 224.0     12.0             91.0   504.0 428 20 24 2   8         22   280 224     12       91   504
1168621 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001443 7365 Elsie Rogers Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         22.0 25.0                       47.0                         22 25                 47
1168622 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001443 7365 Elsie Rogers Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         30.0 21.0                       51.0                         30 21                 51
1168623 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001443 7365 Elsie Rogers Elem Sch   Regular School No 1.0 KG 05 2015   grade_3                         20.0 21.0                       41.0                         20 21                 41
1168624 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001443 7365 Elsie Rogers Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         28.0 19.0                       47.0                         28 19                 47
1168625 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001443 7365 Elsie Rogers Elem Sch   Regular School No 1.0 KG 05 2015   grade_5                         29.0 22.0                       51.0                         29 22                 51
1168626 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001443 7365 Elsie Rogers Elem Sch   Regular School No 1.0 KG 05 2015   kindergarten                         21.0 26.0                       47.0                         21 26                 47
1168627 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001443 7365 Elsie Rogers Elem Sch   Regular School No 1.0 KG 05 2015   pk_12_total 219.0 11.0 35.0 2.0   8.0         9.0   150.0 134.0     13.0             45.0   284.0 219 11 35 2   8         9   150 134     13       45   284
1168628 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876000794 7372 Discovery Middle School   Regular School No 2.0 06 08 2015   grade_6                         163.0 142.0                       305.0                         163 142                 305
1168629 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876000794 7372 Discovery Middle School   Regular School No 2.0 06 08 2015   grade_7                         130.0 142.0                       272.0                         130 142                 272
1168630 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876000794 7372 Discovery Middle School   Regular School No 2.0 06 08 2015   grade_8                         166.0 153.0                       319.0                         166 153                 319
1168631 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876000794 7372 Discovery Middle School   Regular School No 2.0 06 08 2015   pk_12_total 735.0 21.0 31.0 5.0   82.0         22.0   459.0 437.0     10.0             92.0   896.0 735 21 31 5   82         22   459 437     10       92   896
1168632 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001449 7377 Moran Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         41.0 31.0                       72.0                         41 31                 72
1168633 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001449 7377 Moran Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         30.0 18.0                       48.0                         30 18                 48
1168634 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001449 7377 Moran Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         46.0 41.0                       87.0                         46 41                 87
1168635 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001449 7377 Moran Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         44.0 34.0                       78.0                         44 34                 78
1168636 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001449 7377 Moran Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         50.0 37.0                       87.0                         50 37                 87
1168637 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001449 7377 Moran Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         39.0 35.0                       74.0                         39 35                 74

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