Data source: Big Local News · About: Big Local

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

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
1763537 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   pk_12_total 119.0 5.0 29.0     1.0     1.0   4.0   64.0 95.0     15.0         93.0   17.0   159.0 119 5 29     1     1   4   64 95     15     93 17   159
1763536 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   grade_12                         25.0 37.0                       62.0                         25 37                 62
1763535 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   grade_11                         39.0 57.0                       96.0                         39 57                 96
1763534 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   grade_10                         0.0 1.0                       1.0                         0 1                 1
1763533 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   pk_12_total 5.0 152.0 5.0               4.0   89.0 77.0     0.0         136.0   14.0   166.0 5 152 5               4   89 77     0     136 14   166
1763532 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   kindergarten                         15.0 5.0                       20.0                         15 5                 20
1763531 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_7                         5.0 5.0                       10.0                         5 5                 10
1763530 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_6                         8.0 16.0                       24.0                         8 16                 24
1763529 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_5                         13.0 7.0                       20.0                         13 7                 20
1763528 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_4                         9.0 4.0                       13.0                         9 4                 13
1763527 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_3                         14.0 11.0                       25.0                         14 11                 25
1763526 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_2                         12.0 17.0                       29.0                         12 17                 29
1763525 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_1                         13.0 12.0                       25.0                         13 12                 25
1763524 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   pk_12_total 290.0 7.0 11.0 2.0   5.0         18.0   171.0 162.0     1.0         113.0   74.0   333.0 290 7 11 2   5         18   171 162     1     113 74   333
1763523 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   kindergarten                         30.0 21.0                       51.0                         30 21                 51
1763522 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_9                         3.0 13.0                       16.0                         3 13                 16
1763521 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_8                         5.0 10.0                       15.0                         5 10                 15
1763520 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_7                         11.0 14.0                       25.0                         11 14                 25
1763519 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_6                         13.0 16.0                       29.0                         13 16                 29
1763518 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_5                         14.0 16.0                       30.0                         14 16                 30
1763517 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_4                         27.0 16.0                       43.0                         27 16                 43
1763516 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_3                         15.0 7.0                       22.0                         15 7                 22
1763515 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_2                         18.0 21.0                       39.0                         18 21                 39
1763514 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_10                         11.0 1.0                       12.0                         11 1                 12
1763513 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_1                         24.0 27.0                       51.0                         24 27                 51
1763512 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   pk_12_total 3.0 414.0 11.0               15.0   217.0 226.0     3.0         443.0   80.0   443.0 3 414 11               15   217 226     3     443 80   443
1763511 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   kindergarten                         14.0 13.0                       27.0                         14 13                 27
1763510 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_9                         47.0 49.0                       96.0                         47 49                 96
1763509 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_8                         51.0 48.0                       99.0                         51 48                 99
1763508 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_7                         23.0 31.0                       54.0                         23 31                 54
1763507 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_11                         30.0 39.0                       69.0                         30 39                 69
1763506 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_10                         35.0 33.0                       68.0                         35 33                 68
1763505 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   grade_1                         17.0 13.0                       30.0                         17 13                 30
1763504 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 04 2019   pk_12_total 49.0 223.0 200.0 1.0   6.0         5.0   233.0 251.0     155.0         344.0   61.0   484.0 49 223 200 1   6         5   233 251     155     344 61   484
1763503 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 04 2019   kindergarten                         57.0 53.0                       110.0                         57 53                 110
1763502 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 04 2019   grade_4                         37.0 32.0                       69.0                         37 32                 69
1763501 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 04 2019   grade_3                         46.0 36.0                       82.0                         46 36                 82
1763500 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 04 2019   grade_2                         49.0 70.0                       119.0                         49 70                 119
1763499 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 04 2019   grade_1                         44.0 60.0                       104.0                         44 60                 104
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
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
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
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
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
1763493 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2019   pk_12_total 170.0 95.0 36.0 1.0   4.0         34.0   191.0 149.0     13.0         212.0   72.0   340.0 170 95 36 1   4         34   191 149     13     212 72   340
1763492 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2019   grade_8                         59.0 52.0                       111.0                         59 52                 111
1763491 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2019   grade_7                         64.0 44.0                       108.0                         64 44                 108
1763490 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2019   grade_6                         68.0 53.0                       121.0                         68 53                 121
1763489 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   pk_12_total 223.0 264.0 77.0     2.0         43.0   330.0 279.0     23.0         449.0   122.0   609.0 223 264 77     2         43   330 279     23     449 122   609
1763488 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   kindergarten                         62.0 46.0                       108.0                         62 46                 108
1763487 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   grade_5                         77.0 47.0                       124.0                         77 47                 124
1763486 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   grade_4                         48.0 49.0                       97.0                         48 49                 97
1763485 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   grade_3                         51.0 34.0                       85.0                         51 34                 85
1763484 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   grade_2                         49.0 45.0                       94.0                         49 45                 94
1763483 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   grade_1                         43.0 58.0                       101.0                         43 58                 101
1763482 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   pk_12_total 198.0 1.0 7.0 1.0             6.0   113.0 100.0     1.0         127.0   80.0   213.0 198 1 7 1             6   113 100     1     127 80   213
1763481 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   kindergarten                         12.0 12.0                       24.0                         12 12                 24
1763480 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   grade_7                         2.0 7.0                       9.0                         2 7                 9
1763479 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   grade_6                         12.0 15.0                       27.0                         12 15                 27
1763478 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   grade_5                         20.0 15.0                       35.0                         20 15                 35
1763477 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   grade_4                         17.0 12.0                       29.0                         17 12                 29
1763476 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   grade_3                         16.0 14.0                       30.0                         16 14                 30
1763475 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   grade_2                         14.0 12.0                       26.0                         14 12                 26
1763474 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   grade_1                         20.0 13.0                       33.0                         20 13                 33
1763473 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   pk_12_total 387.0   13.0 2.0   1.0         4.0   201.0 206.0     0.0         256.0   72.0   407.0 387   13 2   1         4   201 206     0     256 72   407
1763472 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   kindergarten                         12.0 11.0                       23.0                         12 11                 23
1763471 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_9                         22.0 24.0                       46.0                         22 24                 46
1763470 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_8                         23.0 17.0                       40.0                         23 17                 40
1763469 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_7                         17.0 24.0                       41.0                         17 24                 41
1763468 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_6                         10.0 14.0                       24.0                         10 14                 24
1763467 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_5                         9.0 9.0                       18.0                         9 9                 18
1763466 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_4                         13.0 16.0                       29.0                         13 16                 29
1763465 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_3                         5.0 13.0                       18.0                         5 13                 18
1763464 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_2                         25.0 11.0                       36.0                         25 11                 36
1763463 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_12                         17.0 21.0                       38.0                         17 21                 38
1763462 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_11                         14.0 23.0                       37.0                         14 23                 37
1763461 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_10                         17.0 13.0                       30.0                         17 13                 30
1763460 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_1                         17.0 10.0                       27.0                         17 10                 27
1763459 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2019   pk_12_total 3.0 357.0 20.0               19.0   194.0 205.0     13.0         322.0   34.0   399.0 3 357 20               19   194 205     13     322 34   399
1763458 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2019   kindergarten                         33.0 42.0                       75.0                         33 42                 75
1763457 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2019   grade_5                         31.0 39.0                       70.0                         31 39                 70
1763456 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2019   grade_4                         40.0 19.0                       59.0                         40 19                 59
1763455 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2019   grade_3                         26.0 37.0                       63.0                         26 37                 63
1763454 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2019   grade_2                         38.0 32.0                       70.0                         38 32                 70
1763453 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2019   grade_1                         26.0 36.0                       62.0                         26 36                 62
1763452 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2019   pk_12_total 2.0 251.0 11.0               12.0   133.0 143.0     2.0         211.0   34.0   276.0 2 251 11               12   133 143     2     211 34   276
1763451 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2019   grade_8                         38.0 45.0                       83.0                         38 45                 83
1763450 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2019   grade_7                         44.0 43.0                       87.0                         44 43                 87
1763449 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2019   grade_6                         51.0 55.0                       106.0                         51 55                 106
1763448 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   pk_12_total 25.0 334.0 46.0 1.0   2.0         21.0   222.0 207.0     22.0         364.0   91.0   429.0 25 334 46 1   2         21   222 207     22     364 91   429
1763447 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   kindergarten                         19.0 26.0                       45.0                         19 26                 45
1763446 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   grade_8                         18.0 20.0                       38.0                         18 20                 38
1763445 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   grade_7                         27.0 24.0                       51.0                         27 24                 51
1763444 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   grade_6                         24.0 20.0                       44.0                         24 20                 44
1763443 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   grade_5                         28.0 18.0                       46.0                         28 18                 46
1763442 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   grade_4                         28.0 23.0                       51.0                         28 23                 51
1763441 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   grade_3                         25.0 27.0                       52.0                         25 27                 52
1763440 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   grade_2                         26.0 23.0                       49.0                         26 23                 49
1763439 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   grade_1                         27.0 26.0                       53.0                         27 26                 53
1763438 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 06 2019   pk_12_total 4.0 204.0 1.0               7.0   113.0 103.0     0.0         167.0   13.0   216.0 4 204 1               7   113 103     0     167 13   216

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