Data source: Big Local News · About: Big Local

29,417 rows where state = "GA" and year = 2020 sorted by school_nces_id

View and edit SQL

grade

year

  • 2020 · 29,417
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
323107 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 spring grade_6 119 148 39 0   6       1 14   163 164                       327 119 148 39 0   6       1 14   163 164                 327
323112 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 spring grade_7 135 145 44 1   10       1 14   179 171                       350 135 145 44 1   10       1 14   179 171                 350
323117 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 spring grade_8 95 155 18 1   4       0 15   151 137                       288 95 155 18 1   4       0 15   151 137                 288
323144 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 spring pk_12_total 349 448 101 2   20       2 43   493 472                       965 349 448 101 2   20       2 43   493 472                 965
429760 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 fall grade_6 113 150 38 1   6       1 14   164 159                       323 113 150 38 1   6       1 14   164 159                 323
429765 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 fall grade_7 137 156 46 1   11       1 14   189 177                       366 137 156 46 1   11       1 14   189 177                 366
429770 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 fall grade_8 97 169 18 1   5       0 14   157 147                       304 97 169 18 1   5       0 14   157 147                 304
429797 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 347 475 102 3   22       2 42   510 483                       993 347 475 102 3   22       2 42   510 483                 993
323043 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 52 14 8 0   4       0 6   46 38                       84 52 14 8 0   4       0 6   46 38                 84
323068 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 37 16 15 0   1       0 1   40 30                       70 37 16 15 0   1       0 1   40 30                 70
323079 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 66 23 11 0   3       0 4   57 50                       107 66 23 11 0   3       0 4   57 50                 107
323090 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 58 27 7 0   4       0 1   51 46                       97 58 27 7 0   4       0 1   51 46                 97
323101 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 60 20 9 0   3       0 3   54 41                       95 60 20 9 0   3       0 3   54 41                 95
323132 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 55 18 10 1   2       0 1   46 41                       87 55 18 10 1   2       0 1   46 41                 87
323147 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 356 136 68 1   19       0 17   330 267                       597 356 136 68 1   19       0 17   330 267                 597
323162 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 28 18 8 0   2       0 1   36 21                       57 28 18 8 0   2       0 1   36 21                 57
429696 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 fall grade_1 51 16 8 0   4       0 6   46 39                       85 51 16 8 0   4       0 6   46 39                 85
429721 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 fall grade_2 39 19 15 0   1       0 1   42 33                       75 39 19 15 0   1       0 1   42 33                 75
429732 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 fall grade_3 64 23 10 0   3       0 3   53 50                       103 64 23 10 0   3       0 3   53 50                 103
429743 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 fall grade_4 57 29 9 0   5       0 1   54 47                       101 57 29 9 0   5       0 1   54 47                 101
429754 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 fall grade_5 60 19 8 0   3       0 3   52 41                       93 60 19 8 0   3       0 3   52 41                 93
429785 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten 57 19 10 0   1       0 1   46 42                       88 57 19 10 0   1       0 1   46 42                 88
429800 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 359 145 67 0   19       0 16   333 273                       606 359 145 67 0   19       0 16   333 273                 606
429815 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten 31 20 7 0   2       0 1   40 21                       61 31 20 7 0   2       0 1   40 21                 61
323049 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 spring grade_10 114 137 21 1   6       1 12   141 151                       292 114 137 21 1   6       1 12   141 151                 292
323054 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 spring grade_11 121 105 17 1   10       0 8   131 131                       262 121 105 17 1   10       0 8   131 131                 262
323058 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 spring grade_12 115 101 20 0   9       0 5   141 109                       250 115 101 20 0   9       0 5   141 109                 250
323122 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 spring grade_9 115 159 48 1   5       0 15   180 163                       343 115 159 48 1   5       0 15   180 163                 343
323148 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 spring pk_12_total 465 502 106 3   30       1 40   593 554                       1147 465 502 106 3   30       1 40   593 554                 1147
429702 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 fall grade_10 121 142 22 2   6       1 12   146 160                       306 121 142 22 2   6       1 12   146 160                 306
429707 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 fall grade_11 126 115 21 1   11       0 8   139 143                       282 126 115 21 1   11       0 8   139 143                 282
429711 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 fall grade_12 117 101 18 0   9       0 5   144 106                       250 117 101 18 0   9       0 5   144 106                 250
429775 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 fall grade_9 122 164 55 1   5       0 16   191 172                       363 122 164 55 1   5       0 16   191 172                 363
429801 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2020 fall pk_12_total 486 522 116 4   31       1 41   620 581                       1201 486 522 116 4   31       1 41   620 581                 1201
323036 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 5 42 0 1   0       0 0   24 24                       48 5 42 0 1   0       0 0   24 24                 48
323061 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 1 37 4 0   0       0 2   25 19                       44 1 37 4 0   0       0 2   25 19                 44
323072 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 3 49 3 0   0       0 3   30 28                       58 3 49 3 0   0       0 3   30 28                 58
323083 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 2 36 1 0   0       0 1   19 21                       40 2 36 1 0   0       0 1   19 21                 40
323094 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 0 41 1 0   0       0 0   22 20                       42 0 41 1 0   0       0 0   22 20                 42
323125 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 3 40 2 0   0       0 1   25 21                       46 3 40 2 0   0       0 1   25 21                 46
323137 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 17 258 14 1   0       0 10   160 140                       300 17 258 14 1   0       0 10   160 140                 300
323155 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 3 13 3 0   0       0 3   15 7                       22 3 13 3 0   0       0 3   15 7                 22
429689 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 fall grade_1 4 42 0 1   0       0 0   23 24                       47 4 42 0 1   0       0 0   23 24                 47
429714 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 fall grade_2 1 36 4 0   0       0 4   26 19                       45 1 36 4 0   0       0 4   26 19                 45
429725 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 fall grade_3 2 48 4 0   0       0 2   29 27                       56 2 48 4 0   0       0 2   29 27                 56
429736 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 fall grade_4 2 34 1 0   0       0 1   19 19                       38 2 34 1 0   0       0 1   19 19                 38
429747 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 fall grade_5 0 40 1 0   0       0 0   22 19                       41 0 40 1 0   0       0 0   22 19                 41
429778 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten 2 44 2 0   0       0 2   28 22                       50 2 44 2 0   0       0 2   28 22                 50
429790 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 14 257 15 1   0       0 12   164 135                       299 14 257 15 1   0       0 12   164 135                 299
429808 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten 3 13 3 0   0       0 3   17 5                       22 3 13 3 0   0       0 3   17 5                 22
323041 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 36 5 2 0   6       0 1   24 26                       50 36 5 2 0   6       0 1   24 26                 50
323066 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 34 3 2 0   4       0 2   23 22                       45 34 3 2 0   4       0 2   23 22                 45
323077 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 51 8 3 0   2       0 0   33 31                       64 51 8 3 0   2       0 0   33 31                 64
323088 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 42 6 1 0   4       0 0   30 23                       53 42 6 1 0   4       0 0   30 23                 53
323099 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 40 7 3 0   4       0 4   31 27                       58 40 7 3 0   4       0 4   31 27                 58
323130 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 38 6 1 0   2       0 2   24 25                       49 38 6 1 0   2       0 2   24 25                 49
323145 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 276 41 13 0   24       0 9   190 173                       363 276 41 13 0   24       0 9   190 173                 363
323160 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 35 6 1 0   2       0 0   25 19                       44 35 6 1 0   2       0 0   25 19                 44
429694 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 fall grade_1 34 4 2 0   7       0 1   25 23                       48 34 4 2 0   7       0 1   25 23                 48
429719 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 fall grade_2 33 2 3 0   4       0 2   22 22                       44 33 2 3 0   4       0 2   22 22                 44
429730 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 fall grade_3 50 8 3 0   3       0 0   34 30                       64 50 8 3 0   3       0 0   34 30                 64
429741 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 fall grade_4 43 6 1 0   5       0 0   31 24                       55 43 6 1 0   5       0 0   31 24                 55
429752 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 fall grade_5 42 7 3 0   4       0 4   31 29                       60 42 7 3 0   4       0 4   31 29                 60
429783 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten 38 6 1 0   2       0 2   24 25                       49 38 6 1 0   2       0 2   24 25                 49
429798 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 277 40 15 0   27       0 9   195 173                       368 277 40 15 0   27       0 9   195 173                 368
429813 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten 37 7 2 0   2       0 0   28 20                       48 37 7 2 0   2       0 0   28 20                 48
323045 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 65 5 3 0   2       0 3   36 42                       78 65 5 3 0   2       0 3   36 42                 78
323070 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 66 7 4 0   5       0 6   53 35                       88 66 7 4 0   5       0 6   53 35                 88
323081 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 68 9 2 0   4       0 5   48 40                       88 68 9 2 0   4       0 5   48 40                 88
323092 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 59 14 0 0   3       0 5   35 46                       81 59 14 0 0   3       0 5   35 46                 81
323103 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 63 9 2 1   2       0 2   41 38                       79 63 9 2 1   2       0 2   41 38                 79
323134 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 64 7 2 0   2       0 6   41 40                       81 64 7 2 0   2       0 6   41 40                 81
323151 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 427 53 14 2   18       0 28   276 266                       542 427 53 14 2   18       0 28   276 266                 542
323164 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 42 2 1 1   0       0 1   22 25                       47 42 2 1 1   0       0 1   22 25                 47
429698 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 fall grade_1 66 6 2 0   2       0 3   36 43                       79 66 6 2 0   2       0 3   36 43                 79
429723 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 fall grade_2 68 8 4 0   5       0 6   56 35                       91 68 8 4 0   5       0 6   56 35                 91
429734 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 fall grade_3 67 8 3 0   4       0 4   48 38                       86 67 8 3 0   4       0 4   48 38                 86
429745 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 fall grade_4 59 13 0 0   3       0 5   33 47                       80 59 13 0 0   3       0 5   33 47                 80
429756 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 fall grade_5 61 9 1 1   2       0 3   40 37                       77 61 9 1 1   2       0 3   40 37                 77
429787 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten 64 6 2 0   2       0 7   41 40                       81 64 6 2 0   2       0 7   41 40                 81
429804 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 fall pk_12_total 424 54 14 2   18       0 29   276 265                       541 424 54 14 2   18       0 29   276 265                 541
429817 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2020 fall pre_kindergarten 39 4 2 1   0       0 1   22 25                       47 39 4 2 1   0       0 1   22 25                 47
323108 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2020 spring grade_6 186 148 21 2   5       1 17   197 183                       380 186 148 21 2   5       1 17   197 183                 380
323113 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2020 spring grade_7 161 140 17 2   7       0 17   179 165                       344 161 140 17 2   7       0 17   179 165                 344
323118 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2020 spring grade_8 172 128 16 0   4       1 12   167 166                       333 172 128 16 0   4       1 12   167 166                 333
323150 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2020 spring pk_12_total 519 416 54 4   16       2 46   543 514                       1057 519 416 54 4   16       2 46   543 514                 1057
429761 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2020 fall grade_6 191 147 20 2   5       1 18   201 183                       384 191 147 20 2   5       1 18   201 183                 384
429766 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2020 fall grade_7 162 137 14 2   5       0 17   171 166                       337 162 137 14 2   5       0 17   171 166                 337
429771 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2020 fall grade_8 171 130 15 0   3       1 13   174 159                       333 171 130 15 0   3       1 13   174 159                 333
429803 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 524 414 49 4   13       2 48   546 508                       1054 524 414 49 4   13       2 48   546 508                 1054
323042 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 37 24 10 0   0       0 5   41 35                       76 37 24 10 0   0       0 5   41 35                 76
323067 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 30 19 7 0   2       0 6   36 28                       64 30 19 7 0   2       0 6   36 28                 64
323078 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 32 24 3 0   0       0 6   38 27                       65 32 24 3 0   0       0 6   38 27                 65
323089 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 38 22 2 0   0       0 2   36 28                       64 38 22 2 0   0       0 2   36 28                 64
323100 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 32 27 6 0   0       0 7   42 30                       72 32 27 6 0   0       0 7   42 30                 72
323131 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 28 25 6 0   0       0 8   37 30                       67 28 25 6 0   0       0 8   37 30                 67
323146 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 223 157 35 0   2       0 36   250 203                       453 223 157 35 0   2       0 36   250 203                 453
323161 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 26 16 1 0   0       0 2   20 25                       45 26 16 1 0   0       0 2   20 25                 45
429695 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 fall grade_1 37 22 11 0   0       0 4   40 34                       74 37 22 11 0   0       0 4   40 34                 74
429720 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2020 fall grade_2 32 19 6 0   2       0 5   36 28                       64 32 19 6 0   2       0 5   36 28                 64

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