Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2019 · 11,892
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
1751672 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 361.0 5.0 9.0 2.0   18.0         34.0   211.0 218.0     16.0         85.0   73.0   429.0 361 5 9 2   18         34   211 218     16     85 73   429
1751673 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         6.0 2.0                       8.0                         6 2                 8
1751674 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_1                         66.0 47.0                       113.0                         66 47                 113
1751675 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_2                         57.0 67.0                       124.0                         57 67                 124
1751676 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_3                         55.0 43.0                       98.0                         55 43                 98
1751677 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_4                         56.0 58.0                       114.0                         56 58                 114
1751678 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_5                         59.0 59.0                       118.0                         59 59                 118
1751679 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         55.0 36.0                       91.0                         55 36                 91
1751680 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 544.0 9.0 39.0     29.0         37.0   348.0 310.0     26.0         218.0   116.0   658.0 544 9 39     29         37   348 310     26     218 116   658
1751690 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_1                         51.0 50.0                       101.0                         51 50                 101
1751691 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_2                         50.0 35.0                       85.0                         50 35                 85
1751692 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_3                         54.0 43.0                       97.0                         54 43                 97
1751693 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_4                         48.0 49.0                       97.0                         48 49                 97
1751694 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_5                         35.0 49.0                       84.0                         35 49                 84
1751695 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         45.0 54.0                       99.0                         45 54                 99
1751696 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 469.0 18.0 25.0     19.0         32.0   283.0 280.0     8.0         98.0   62.0   563.0 469 18 25     19         32   283 280     8     98 62   563
1751697 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_1                         48.0 45.0                       93.0                         48 45                 93
1751698 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_2                         52.0 50.0                       102.0                         52 50                 102
1751699 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_3                         43.0 34.0                       77.0                         43 34                 77
1751700 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_4                         41.0 39.0                       80.0                         41 39                 80
1751701 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_5                         40.0 33.0                       73.0                         40 33                 73
1751702 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         38.0 39.0                       77.0                         38 39                 77
1751703 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 424.0 9.0 16.0     17.0         36.0   262.0 240.0     14.0         42.0   42.0   502.0 424 9 16     17         36   262 240     14     42 42   502
1751704 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_1                         40.0 47.0                       87.0                         40 47                 87
1751705 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_2                         41.0 51.0                       92.0                         41 51                 92
1751706 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_3                         45.0 38.0                       83.0                         45 38                 83
1751707 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_4                         49.0 45.0                       94.0                         49 45                 94
1751708 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_5                         56.0 53.0                       109.0                         56 53                 109
1751709 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         56.0 29.0                       85.0                         56 29                 85
1751710 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 469.0 22.0 26.0 1.0   33.0         22.0   302.0 271.0     14.0         53.0   81.0   573.0 469 22 26 1   33         22   302 271     14     53 81   573
1751711 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         15.0 8.0                       23.0                         15 8                 23
1751712 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_1                         58.0 41.0                       99.0                         58 41                 99
1751713 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_2                         50.0 55.0                       105.0                         50 55                 105
1751714 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_3                         38.0 40.0                       78.0                         38 40                 78
1751715 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_4                         47.0 32.0                       79.0                         47 32                 79
1751716 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_5                         52.0 51.0                       103.0                         52 51                 103
1751717 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         50.0 64.0                       114.0                         50 64                 114
1751718 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 469.0 11.0 29.0     18.0         51.0   295.0 283.0     31.0         117.0   79.0   578.0 469 11 29     18         51   295 283     31     117 79   578
1751744 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_1                         40.0 31.0                       71.0                         40 31                 71
1751745 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_2                         31.0 35.0                       66.0                         31 35                 66
1751746 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_3                         37.0 31.0                       68.0                         37 31                 68
1751747 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_4                         41.0 35.0                       76.0                         41 35                 76
1751748 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_5                         32.0 40.0                       72.0                         32 40                 72
1751749 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_6                         33.0 40.0                       73.0                         33 40                 73
1751750 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_7                         45.0 43.0                       88.0                         45 43                 88
1751751 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_8                         43.0 42.0                       85.0                         43 42                 85
1751752 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   pk_12_total 258.0 138.0 128.0 5.0   17.0     2.0   51.0   302.0 297.0     61.0         295.0   90.0   599.0 258 138 128 5   17     2   51   302 297     61     295 90   599
1751785 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_1                         59.0 59.0                       118.0                         59 59                 118
1751786 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_2                         67.0 55.0                       122.0                         67 55                 122
1751787 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_3                         62.0 60.0                       122.0                         62 60                 122
1751788 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_4                         58.0 67.0                       125.0                         58 67                 125
1751789 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_5                         53.0 59.0                       112.0                         53 59                 112
1751790 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   pk_12_total 226.0 205.0 105.0 3.0   11.0     2.0   47.0   299.0 300.0     64.0         356.0   73.0   599.0 226 205 105 3   11     2   47   299 300     64     356 73   599
1751791 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   grade_1                         32.0 33.0                       65.0                         32 33                 65
1751792 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   grade_2                         39.0 48.0                       87.0                         39 48                 87
1751793 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   grade_3                         38.0 38.0                       76.0                         38 38                 76
1751794 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   grade_4                         45.0 40.0                       85.0                         45 40                 85
1751795 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   grade_5                         40.0 57.0                       97.0                         40 57                 97
1751796 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         43.0 40.0                       83.0                         43 40                 83
1751797 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 87.0 166.0 173.0 2.0   31.0         78.0   260.0 277.0     114.0         480.0   79.0   537.0 87 166 173 2   31         78   260 277     114     480 79   537
1751798 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         23.0 21.0                       44.0                         23 21                 44
1751799 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   grade_1                         33.0 34.0                       67.0                         33 34                 67
1751800 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   grade_2                         53.0 48.0                       101.0                         53 48                 101
1751801 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   grade_3                         41.0 29.0                       70.0                         41 29                 70
1751802 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   grade_4                         34.0 38.0                       72.0                         34 38                 72
1751803 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   grade_5                         35.0 30.0                       65.0                         35 30                 65
1751804 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         40.0 28.0                       68.0                         40 28                 68
1751805 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 26.0 224.0 173.0     6.0     1.0   44.0   251.0 223.0     120.0         403.0   68.0   474.0 26 224 173     6     1   44   251 223     120     403 68   474
1751806 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         15.0 16.0                       31.0                         15 16                 31
1751807 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_1                         20.0 22.0                       42.0                         20 22                 42
1751808 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_2                         23.0 23.0                       46.0                         23 23                 46
1751809 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_3                         21.0 16.0                       37.0                         21 16                 37
1751810 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_4                         25.0 34.0                       59.0                         25 34                 59
1751811 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_5                         28.0 16.0                       44.0                         28 16                 44
1751812 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         14.0 30.0                       44.0                         14 30                 44
1751813 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 48.0 88.0 96.0     23.0         35.0   142.0 148.0     77.0         241.0   32.0   290.0 48 88 96     23         35   142 148     77     241 32   290
1751814 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1751815 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   grade_1                         27.0 24.0                       51.0                         27 24                 51
1751816 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   grade_2                         20.0 24.0                       44.0                         20 24                 44
1751817 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   grade_3                         29.0 34.0                       63.0                         29 34                 63
1751818 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   grade_4                         26.0 22.0                       48.0                         26 22                 48
1751819 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   grade_5                         25.0 26.0                       51.0                         25 26                 51
1751820 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         31.0 22.0                       53.0                         31 22                 53
1751821 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 155.0 77.0 55.0     5.0         51.0   175.0 168.0     29.0         269.0   50.0   343.0 155 77 55     5         51   175 168     29     269 50   343
1751822 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         17.0 16.0                       33.0                         17 16                 33
1751823 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2019   kindergarten                         39.0 39.0                       78.0                         39 39                 78
1751824 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2019   pk_12_total 103.0 62.0 38.0     4.0         29.0   113.0 123.0     5.0         102.0   19.0   236.0 103 62 38     4         29   113 123     5     102 19   236
1751825 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2019   pre_kindergarten                         74.0 84.0                       158.0                         74 84                 158
1751826 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   grade_1                         40.0 36.0                       76.0                         40 36                 76
1751827 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   grade_2                         42.0 24.0                       66.0                         42 24                 66
1751828 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   grade_3                         36.0 40.0                       76.0                         36 40                 76
1751829 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   grade_4                         44.0 32.0                       76.0                         44 32                 76
1751830 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   grade_5                         51.0 29.0                       80.0                         51 29                 80
1751831 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         33.0 36.0                       69.0                         33 36                 69
1751832 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 150.0 173.0 60.0     63.0         49.0   281.0 214.0     58.0         346.0   114.0   495.0 150 173 60     63         49   281 214     58     346 114   495
1751833 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         35.0 17.0                       52.0                         35 17                 52
1751834 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2019   grade_1                         65.0 39.0                       104.0                         65 39                 104
1751835 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2019   grade_2                         68.0 62.0                       130.0                         68 62                 130
1751836 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2019   grade_3                         56.0 47.0                       103.0                         56 47                 103
1751837 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2019   grade_4                         57.0 48.0                       105.0                         57 48                 105

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