Data source: Big Local News · About: Big Local

29,461 rows where state = "GA" and year = 2021 sorted by school_nces_id

View and edit SQL

grade

year

  • 2021 · 29,461
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
415037 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 fall grade_6 107 167 33 1   12       0 13   157 176                       333 107 167 33 1   12       0 13   157 176                 333
415041 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 fall grade_7 116 153 39 0   6       1 16   161 170                       331 116 153 39 0   6       1 16   161 170                 331
415046 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 fall grade_8 138 142 43 1   11       1 15   176 175                       351 138 142 43 1   11       1 15   176 175                 351
415073 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 fall pk_12_total 361 462 115 2   29       2 44   494 521                       1015 361 462 115 2   29       2 44   494 521                 1015
2272957 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 spring grade_6 107 166 33 0   12       0 14   158 174                       332 107 166 33 0   12       0 14   158 174                 332
2272962 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 spring grade_7 118 150 38 0   5       1 18   160 170                       330 118 150 38 0   5       1 18   160 170                 330
2272967 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 spring grade_8 135 139 44 2   11       1 17   172 177                       349 135 139 44 2   11       1 17   172 177                 349
2272994 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 spring pk_12_total 360 455 115 2   28       2 49   490 521                       1011 360 455 115 2   28       2 49   490 521                 1011
414973 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 fall grade_1 55 18 10 1   2       0 1   44 43                       87 55 18 10 1   2       0 1   44 43                 87
414999 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 fall grade_2 54 15 9 0   4       0 6   49 39                       88 54 15 9 0   4       0 6   49 39                 88
415010 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 fall grade_3 35 16 16 0   1       0 2   42 28                       70 35 16 16 0   1       0 2   42 28                 70
415021 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 fall grade_4 65 21 13 0   3       0 5   58 49                       107 65 21 13 0   3       0 5   58 49                 107
415032 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 fall grade_5 59 28 6 0   4       0 3   55 45                       100 59 28 6 0   4       0 3   55 45                 100
415061 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten 56 24 9 0   2       0 5   51 45                       96 56 24 9 0   2       0 5   51 45                 96
415076 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 fall pk_12_total 363 138 68 1   19       0 22   334 277                       611 363 138 68 1   19       0 22   334 277                 611
415091 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten 39 16 5 0   3       0 0   35 28                       63 39 16 5 0   3       0 0   35 28                 63
2272893 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 spring grade_1 56 18 10 1   1       0 1   43 44                       87 56 18 10 1   1       0 1   43 44                 87
2272919 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 spring grade_2 58 12 10 0   4       0 7   52 39                       91 58 12 10 0   4       0 7   52 39                 91
2272930 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 spring grade_3 40 17 17 0   1       0 3   46 32                       78 40 17 17 0   1       0 3   46 32                 78
2272941 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 spring grade_4 65 22 13 0   2       0 5   57 50                       107 65 22 13 0   2       0 5   57 50                 107
2272952 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 spring grade_5 60 28 6 0   4       0 2   55 45                       100 60 28 6 0   4       0 2   55 45                 100
2272982 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 spring kindergarten 59 23 7 0   1       0 6   54 42                       96 59 23 7 0   1       0 6   54 42                 96
2272997 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 spring pk_12_total 380 139 69 1   16       0 24   347 282                       629 380 139 69 1   16       0 24   347 282                 629
2273012 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2021 spring pre_kindergarten 42 19 6 0   3       0 0   40 30                       70 42 19 6 0   3       0 0   40 30                 70
414979 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 fall grade_10 106 152 39 0   4       0 14   156 159                       315 106 152 39 0   4       0 14   156 159                 315
414984 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 fall grade_11 109 129 20 1   6       1 11   136 141                       277 109 129 20 1   6       1 11   136 141                 277
414989 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 fall grade_12 131 111 20 1   10       0 8   140 141                       281 131 111 20 1   10       0 8   140 141                 281
415051 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 fall grade_9 111 176 24 2   6       0 20   179 160                       339 111 176 24 2   6       0 20   179 160                 339
415077 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 fall pk_12_total 457 568 103 4   26       1 53   611 601                       1212 457 568 103 4   26       1 53   611 601                 1212
2272899 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 spring grade_10 105 155 40 0   5       0 15   158 162                       320 105 155 40 0   5       0 15   158 162                 320
2272904 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 spring grade_11 111 120 17 0   6       1 11   130 136                       266 111 120 17 0   6       1 11   130 136                 266
2272909 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 spring grade_12 128 111 19 2   10       0 8   136 142                       278 128 111 19 2   10       0 8   136 142                 278
2272972 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 spring grade_9 114 176 24 2   6       0 23   182 163                       345 114 176 24 2   6       0 23   182 163                 345
2272998 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2021 spring pk_12_total 458 562 100 4   27       1 57   606 603                       1209 458 562 100 4   27       1 57   606 603                 1209
414966 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 fall grade_1 3 44 1 0   0       0 1   26 23                       49 3 44 1 0   0       0 1   26 23                 49
414992 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 fall grade_2 3 40 0 1   0       0 1   22 23                       45 3 40 0 1   0       0 1   22 23                 45
415003 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 fall grade_3 1 40 4 0   0       0 2   27 20                       47 1 40 4 0   0       0 2   27 20                 47
415014 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 fall grade_4 2 42 5 0   0       0 2   24 27                       51 2 42 5 0   0       0 2   24 27                 51
415025 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 fall grade_5 0 31 2 0   0       0 1   15 19                       34 0 31 2 0   0       0 1   15 19                 34
415054 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten 3 37 2 0   0       0 3   24 21                       45 3 37 2 0   0       0 3   24 21                 45
415066 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 fall pk_12_total 12 255 15 1   0       0 10   151 142                       293 12 255 15 1   0       0 10   151 142                 293
415084 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten 0 21 1 0   0       0 0   13 9                       22 0 21 1 0   0       0 0   13 9                 22
2272886 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 spring grade_1 1 43 1 0   0       0 1   24 22                       46 1 43 1 0   0       0 1   24 22                 46
2272912 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 spring grade_2 3 41 0 1   0       0 1   22 24                       46 3 41 0 1   0       0 1   22 24                 46
2272923 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 spring grade_3 1 36 4 0   0       0 2   23 20                       43 1 36 4 0   0       0 2   23 20                 43
2272934 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 spring grade_4 2 40 5 0   0       0 2   25 24                       49 2 40 5 0   0       0 2   25 24                 49
2272945 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 spring grade_5 0 30 2 0   0       0 1   15 18                       33 0 30 2 0   0       0 1   15 18                 33
2272975 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 spring kindergarten 4 35 2 0   0       0 3   23 21                       44 4 35 2 0   0       0 3   23 21                 44
2272987 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 spring pk_12_total 11 243 15 1   0       0 10   143 137                       280 11 243 15 1   0       0 10   143 137                 280
2273005 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2021 spring pre_kindergarten 0 18 1 0   0       0 0   11 8                       19 0 18 1 0   0       0 0   11 8                 19
414971 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 fall grade_1 42 5 1 0   2       0 2   27 25                       52 42 5 1 0   2       0 2   27 25                 52
414997 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 fall grade_2 34 6 2 0   6       0 2   23 27                       50 34 6 2 0   6       0 2   23 27                 50
415008 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 fall grade_3 38 5 3 0   4       0 2   27 25                       52 38 5 3 0   4       0 2   27 25                 52
415019 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 fall grade_4 51 7 3 0   3       0 0   27 37                       64 51 7 3 0   3       0 0   27 37                 64
415030 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 fall grade_5 39 5 1 0   4       0 0   28 21                       49 39 5 1 0   4       0 0   28 21                 49
415059 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten 36 6 2 0   5       0 1   32 18                       50 36 6 2 0   5       0 1   32 18                 50
415074 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 fall pk_12_total 273 37 13 0   25       0 7   183 172                       355 273 37 13 0   25       0 7   183 172                 355
415089 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten 33 3 1 0   1       0 0   19 19                       38 33 3 1 0   1       0 0   19 19                 38
2272891 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 spring grade_1 44 6 1 0   2       0 3   29 27                       56 44 6 1 0   2       0 3   29 27                 56
2272917 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 spring grade_2 35 6 2 0   6       0 2   22 29                       51 35 6 2 0   6       0 2   22 29                 51
2272928 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 spring grade_3 35 5 3 0   5       0 2   26 24                       50 35 5 3 0   5       0 2   26 24                 50
2272939 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 spring grade_4 48 6 3 0   3       0 0   24 36                       60 48 6 3 0   3       0 0   24 36                 60
2272950 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 spring grade_5 40 4 1 0   4       0 0   28 21                       49 40 4 1 0   4       0 0   28 21                 49
2272980 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 spring kindergarten 38 5 2 0   4       0 1   30 20                       50 38 5 2 0   4       0 1   30 20                 50
2272995 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 spring pk_12_total 273 35 13 0   26       0 9   179 177                       356 273 35 13 0   26       0 9   179 177                 356
2273010 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2021 spring pre_kindergarten 33 3 1 0   2       0 1   20 20                       40 33 3 1 0   2       0 1   20 20                 40
414975 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 fall grade_1 73 7 2 0   2       0 8   44 48                       92 73 7 2 0   2       0 8   44 48                 92
415001 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 fall grade_2 63 4 3 0   2       0 2   36 38                       74 63 4 3 0   2       0 2   36 38                 74
415012 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 fall grade_3 68 6 3 0   5       0 6   49 39                       88 68 6 3 0   5       0 6   49 39                 88
415023 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 fall grade_4 65 10 2 0   3       0 4   44 40                       84 65 10 2 0   3       0 4   44 40                 84
415034 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 fall grade_5 59 13 0 0   4       0 5   34 47                       81 59 13 0 0   4       0 5   34 47                 81
415063 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten 65 12 4 0   2       0 4   40 47                       87 65 12 4 0   2       0 4   40 47                 87
415080 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 fall pk_12_total 431 54 15 0   19       0 35   268 286                       554 431 54 15 0   19       0 35   268 286                 554
415093 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten 38 2 1 0   1       0 6   21 27                       48 38 2 1 0   1       0 6   21 27                 48
2272895 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 spring grade_1 72 7 2 0   2       0 7   44 46                       90 72 7 2 0   2       0 7   44 46                 90
2272921 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 spring grade_2 57 4 4 0   2       0 1   34 34                       68 57 4 4 0   2       0 1   34 34                 68
2272932 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 spring grade_3 67 6 3 0   4       0 6   50 36                       86 67 6 3 0   4       0 6   50 36                 86
2272943 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 spring grade_4 65 11 2 0   3       0 3   44 40                       84 65 11 2 0   3       0 3   44 40                 84
2272954 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 spring grade_5 60 13 0 0   3       0 4   32 48                       80 60 13 0 0   3       0 4   32 48                 80
2272984 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 spring kindergarten 61 12 5 0   2       0 4   40 44                       84 61 12 5 0   2       0 4   40 44                 84
2273001 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 spring pk_12_total 419 55 17 0   17       0 32   266 274                       540 419 55 17 0   17       0 32   266 274                 540
2273014 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2021 spring pre_kindergarten 37 2 1 0   1       0 7   22 26                       48 37 2 1 0   1       0 7   22 26                 48
415038 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2021 fall grade_6 173 121 15 1   3       1 15   162 167                       329 173 121 15 1   3       1 15   162 167                 329
415042 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2021 fall grade_7 195 142 22 2   3       1 15   196 184                       380 195 142 22 2   3       1 15   196 184                 380
415047 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2021 fall grade_8 174 141 17 2   6       0 17   185 172                       357 174 141 17 2   6       0 17   185 172                 357
415079 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2021 fall pk_12_total 542 404 54 5   12       2 47   543 523                       1066 542 404 54 5   12       2 47   543 523                 1066
2272958 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2021 spring grade_6 168 119 16 1   3       1 16   160 164                       324 168 119 16 1   3       1 16   160 164                 324
2272963 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2021 spring grade_7 189 148 20 2   3       1 14   193 184                       377 189 148 20 2   3       1 14   193 184                 377
2272968 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2021 spring grade_8 174 136 17 1   4       0 15   178 169                       347 174 136 17 1   4       0 15   178 169                 347
2273000 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2021 spring pk_12_total 531 403 53 4   10       2 45   531 517                       1048 531 403 53 4   10       2 45   531 517                 1048
414972 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 fall grade_1 26 21 4 0   0       0 4   34 21                       55 26 21 4 0   0       0 4   34 21                 55
414998 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 fall grade_2 34 21 10 0   0       0 7   34 38                       72 34 21 10 0   0       0 7   34 38                 72
415009 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 fall grade_3 29 19 7 0   2       0 5   33 29                       62 29 19 7 0   2       0 5   33 29                 62
415020 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 fall grade_4 32 22 5 0   0       0 5   36 28                       64 32 22 5 0   0       0 5   36 28                 64
415031 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 fall grade_5 37 25 3 0   0       0 2   39 28                       67 37 25 3 0   0       0 2   39 28                 67
415060 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 fall kindergarten 36 28 4 0   0       0 6   40 34                       74 36 28 4 0   0       0 6   40 34                 74
415075 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 fall pk_12_total 211 156 36 0   2       0 31   239 197                       436 211 156 36 0   2       0 31   239 197                 436
415090 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten 17 20 3 0   0       0 2   23 19                       42 17 20 3 0   0       0 2   23 19                 42
2272892 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 spring grade_1 26 21 4 0   0       0 6   37 20                       57 26 21 4 0   0       0 6   37 20                 57
2272918 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2021 spring grade_2 36 22 9 0   0       0 4   32 39                       71 36 22 9 0   0       0 4   32 39                 71

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