Data source: Big Local News · About: Big Local

29,360 rows where state = "GA" and year = 2019 sorted by school_nces_id

View and edit SQL

grade

year

  • 2019 · 29,360
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
1273713 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 fall grade_6 136 149 40 1   12       1 12   182 169                       351 136 149 40 1   12       1 12   182 169                 351
1273717 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 fall grade_7 101 164 22 0   7       0 14   153 155                       308 101 164 22 0   7       0 14   153 155                 308
1273721 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 fall grade_8 110 158 38 1   5       1 13   165 161                       326 110 158 38 1   5       1 13   165 161                 326
1273746 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 fall pk_12_total 347 471 100 2   24       2 39   500 485                       985 347 471 100 2   24       2 39   500 485                 985
2567904 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 spring grade_6 137 150 43 1   14       1 15   184 177                       361 137 150 43 1   14       1 15   184 177                 361
2567908 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 spring grade_7 98 165 20 0   6       0 15   151 153                       304 98 165 20 0   6       0 15   151 153                 304
2567912 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 spring grade_8 112 157 37 1   5       1 16   162 167                       329 112 157 37 1   5       1 16   162 167                 329
2567937 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 spring pk_12_total 347 472 100 2   25       2 46   497 497                       994 347 472 100 2   25       2 46   497 497                 994
1273652 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 fall grade_1 34 18 10 0   3       0 1   37 29                       66 34 18 10 0   3       0 1   37 29                 66
1273674 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 fall grade_2 59 24 9 0   3       0 3   49 49                       98 59 24 9 0   3       0 3   49 49                 98
1273685 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 fall grade_3 60 30 8 0   5       0 0   49 54                       103 60 30 8 0   5       0 0   49 54                 103
1273696 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 fall grade_4 62 21 8 0   3       0 3   54 43                       97 62 21 8 0   3       0 3   54 43                 97
1273708 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 fall grade_5 66 24 12 0   1       0 2   60 45                       105 66 24 12 0   1       0 2   60 45                 105
1273734 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten 51 13 6 0   2       0 6   44 34                       78 51 13 6 0   2       0 6   44 34                 78
1273749 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 fall pk_12_total 363 149 61 0   17       0 15   333 272                       605 363 149 61 0   17       0 15   333 272                 605
1273763 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten 31 19 8 0   0       0 0   40 18                       58 31 19 8 0   0       0 0   40 18                 58
2567842 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 spring grade_1 37 16 13 0   3       0 1   37 33                       70 37 16 13 0   3       0 1   37 33                 70
2567864 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 spring grade_2 58 25 9 0   3       1 3   49 50                       99 58 25 9 0   3       1 3   49 50                 99
2567875 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 spring grade_3 57 23 10 0   6       0 2   46 52                       98 57 23 10 0   6       0 2   46 52                 98
2567886 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 spring grade_4 57 26 9 0   3       1 2   54 44                       98 57 26 9 0   3       1 2   54 44                 98
2567898 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 spring grade_5 65 23 12 0   1       0 2   57 46                       103 65 23 12 0   1       0 2   57 46                 103
2567925 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten 52 15 7 0   3       0 5   46 36                       82 52 15 7 0   3       0 5   46 36                 82
2567940 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 spring pk_12_total 358 151 70 0   19       2 16   333 283                       616 358 151 70 0   19       2 16   333 283                 616
2567954 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2019 spring pre_kindergarten 32 23 10 0   0       0 1   44 22                       66 32 23 10 0   0       0 1   44 22                 66
1273658 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 fall grade_10 136 143 23 1   13       0 14   174 156                       330 136 143 23 1   13       0 14   174 156                 330
1273662 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 fall grade_11 122 106 16 0   11       0 8   150 113                       263 122 106 16 0   11       0 8   150 113                 263
1273665 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 fall grade_12 113 113 22 1   8       0 10   121 146                       267 113 113 22 1   8       0 10   121 146                 267
1273725 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 fall grade_9 134 161 24 0   6       2 11   175 163                       338 134 161 24 0   6       2 11   175 163                 338
1273750 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 fall pk_12_total 505 523 85 2   38       2 43   620 578                       1198 505 523 85 2   38       2 43   620 578                 1198
2567848 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 spring grade_10 133 131 23 1   12       0 12   167 145                       312 133 131 23 1   12       0 12   167 145                 312
2567852 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 spring grade_11 119 99 15 0   11       0 8   147 105                       252 119 99 15 0   11       0 8   147 105                 252
2567855 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 spring grade_12 115 116 22 1   9       0 10   123 150                       273 115 116 22 1   9       0 10   123 150                 273
2567916 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 spring grade_9 130 157 28 0   6       2 12   173 162                       335 130 157 28 0   6       2 12   173 162                 335
2567941 GA     school 1300001 741   Troup County 130000100608 1052 LaGrange High School   Regular School No High 09 12 2019 spring pk_12_total 497 503 88 2   38       2 42   610 562                       1172 497 503 88 2   38       2 42   610 562                 1172
1273645 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 fall grade_1 4 40 5 0   0       0 3   25 27                       52 4 40 5 0   0       0 3   25 27                 52
1273667 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 fall grade_2 4 45 3 0   0       0 1   27 26                       53 4 45 3 0   0       0 1   27 26                 53
1273678 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 fall grade_3 4 33 2 0   0       0 2   18 23                       41 4 33 2 0   0       0 2   18 23                 41
1273689 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 fall grade_4 0 44 0 0   0       0 1   21 24                       45 0 44 0 0   0       0 1   21 24                 45
1273701 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 fall grade_5 1 44 1 0   0       0 1   28 19                       47 1 44 1 0   0       0 1   28 19                 47
1273727 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten 5 36 0 0   0       0 0   18 23                       41 5 36 0 0   0       0 0   18 23                 41
1273739 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 fall pk_12_total 18 262 12 0   0       0 9   146 155                       301 18 262 12 0   0       0 9   146 155                 301
1273756 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten 0 20 1 0   0       0 1   9 13                       22 0 20 1 0   0       0 1   9 13                 22
2567835 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 spring grade_1 4 37 4 0   0       0 3   25 23                       48 4 37 4 0   0       0 3   25 23                 48
2567857 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 spring grade_2 3 44 3 0   0       0 1   26 25                       51 3 44 3 0   0       0 1   26 25                 51
2567868 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 spring grade_3 3 32 1 0   0       0 2   17 21                       38 3 32 1 0   0       0 2   17 21                 38
2567879 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 spring grade_4 0 44 0 0   0       0 1   24 21                       45 0 44 0 0   0       0 1   24 21                 45
2567891 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 spring grade_5 1 47 1 0   0       0 1   29 21                       50 1 47 1 0   0       0 1   29 21                 50
2567918 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten 3 38 0 1   0       0 0   18 24                       42 3 38 0 1   0       0 0   18 24                 42
2567930 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 spring pk_12_total 14 262 10 1   0       0 9   148 148                       296 14 262 10 1   0       0 9   148 148                 296
2567947 GA     school 1300001 741   Troup County 130000100643 5052 Berta Weathersbee Elementary School   Regular School No Elementary PK 05 2019 spring pre_kindergarten 0 20 1 0   0       0 1   9 13                       22 0 20 1 0   0       0 1   9 13                 22
1273650 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 fall grade_1 37 2 3 0   4       0 2   25 23                       48 37 2 3 0   4       0 2   25 23                 48
1273672 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 fall grade_2 48 7 3 1   4       0 1   34 30                       64 48 7 3 1   4       0 1   34 30                 64
1273683 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 fall grade_3 43 8 1 0   4       0 0   33 23                       56 43 8 1 0   4       0 0   33 23                 56
1273694 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 fall grade_4 37 11 4 0   4       0 5   34 27                       61 37 11 4 0   4       0 5   34 27                 61
1273706 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 fall grade_5 48 11 4 0   1       0 3   28 39                       67 48 11 4 0   1       0 3   28 39                 67
1273732 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten 31 4 2 0   4       0 4   26 19                       45 31 4 2 0   4       0 4   26 19                 45
1273747 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 fall pk_12_total 280 50 17 1   23       0 16   203 184                       387 280 50 17 1   23       0 16   203 184                 387
1273761 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten 36 7 0 0   2       0 1   23 23                       46 36 7 0 0   2       0 1   23 23                 46
2567840 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 spring grade_1 37 3 3 0   5       0 2   26 24                       50 37 3 3 0   5       0 2   26 24                 50
2567862 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 spring grade_2 50 6 3 1   5       0 2   35 32                       67 50 6 3 1   5       0 2   35 32                 67
2567873 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 spring grade_3 42 9 2 0   4       0 0   34 23                       57 42 9 2 0   4       0 0   34 23                 57
2567884 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 spring grade_4 37 9 3 0   4       0 5   31 27                       58 37 9 3 0   4       0 5   31 27                 58
2567896 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 spring grade_5 47 13 4 0   2       0 3   28 41                       69 47 13 4 0   2       0 3   28 41                 69
2567923 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten 34 3 3 0   5       0 3   26 22                       48 34 3 3 0   5       0 3   26 22                 48
2567938 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 spring pk_12_total 284 49 18 1   27       0 16   204 191                       395 284 49 18 1   27       0 16   204 191                 395
2567952 GA     school 1300001 741   Troup County 130000101706 3050 Hillcrest Elementary School   Regular School No Elementary PK 05 2019 spring pre_kindergarten 37 6 0 0   2       0 1   24 22                       46 37 6 0 0   2       0 1   24 22                 46
1273654 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 fall grade_1 72 7 3 0   4       0 8   56 38                       94 72 7 3 0   4       0 8   56 38                 94
1273676 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 fall grade_2 66 7 3 0   4       1 3   48 36                       84 66 7 3 0   4       1 3   48 36                 84
1273687 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 fall grade_3 53 11 0 0   3       0 5   31 41                       72 53 11 0 0   3       0 5   31 41                 72
1273698 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 fall grade_4 60 6 2 1   2       0 4   36 39                       75 60 6 2 1   2       0 4   36 39                 75
1273710 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 fall grade_5 91 18 3 0   3       0 7   58 64                       122 91 18 3 0   3       0 7   58 64                 122
1273736 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten 54 4 2 0   2       0 3   29 36                       65 54 4 2 0   2       0 3   29 36                 65
1273753 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 fall pk_12_total 431 54 14 1   19       1 37   278 279                       557 431 54 14 1   19       1 37   278 279                 557
1273765 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten 35 1 1 0   1       0 7   20 25                       45 35 1 1 0   1       0 7   20 25                 45
2567844 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 spring grade_1 71 7 3 0   3       0 6   55 35                       90 71 7 3 0   3       0 6   55 35                 90
2567866 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 spring grade_2 65 8 2 0   4       1 4   50 34                       84 65 8 2 0   4       1 4   50 34                 84
2567877 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 spring grade_3 54 10 2 0   3       0 5   32 42                       74 54 10 2 0   3       0 5   32 42                 74
2567888 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 spring grade_4 62 6 2 1   2       0 4   37 40                       77 62 6 2 1   2       0 4   37 40                 77
2567900 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 spring grade_5 89 17 3 0   3       0 7   59 60                       119 89 17 3 0   3       0 7   59 60                 119
2567927 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten 56 4 2 0   2       0 3   29 38                       67 56 4 2 0   2       0 3   29 38                 67
2567944 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 spring pk_12_total 432 53 15 1   18       1 36   283 273                       556 432 53 15 1   18       1 36   283 273                 556
2567956 GA     school 1300001 741   Troup County 130000101710 5050 Rosemont Elementary School   Regular School No Elementary PK 05 2019 spring pre_kindergarten 35 1 1 0   1       0 7   21 24                       45 35 1 1 0   1       0 7   21 24                 45
1273714 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2019 fall grade_6 168 139 13 3   5       1 12   172 169                       341 168 139 13 3   5       1 12   172 169                 341
1273718 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2019 fall grade_7 170 123 16 0   3       1 13   172 154                       326 170 123 16 0   3       1 13   172 154                 326
1273722 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2019 fall grade_8 195 120 11 0   7       0 14   171 176                       347 195 120 11 0   7       0 14   171 176                 347
1273752 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2019 fall pk_12_total 533 382 40 3   15       2 39   515 499                       1014 533 382 40 3   15       2 39   515 499                 1014
2567905 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2019 spring grade_6 164 140 14 2   5       0 14   175 164                       339 164 140 14 2   5       0 14   175 164                 339
2567909 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2019 spring grade_7 170 122 13 0   3       1 12   165 156                       321 170 122 13 0   3       1 12   165 156                 321
2567913 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2019 spring grade_8 190 119 12 0   7       0 15   166 177                       343 190 119 12 0   7       0 15   166 177                 343
2567943 GA     school 1300001 741   Troup County 130000101852 297 Long Cane Middle School   Regular School No Middle 06 08 2019 spring pk_12_total 524 381 39 2   15       1 41   506 497                       1003 524 381 39 2   15       1 41   506 497                 1003
1273651 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 fall grade_1 37 21 6 0   1       0 3   31 37                       68 37 21 6 0   1       0 3   31 37                 68
1273673 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 fall grade_2 36 34 4 0   0       0 7   48 33                       81 36 34 4 0   0       0 7   48 33                 81
1273684 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 fall grade_3 41 22 2 0   0       0 2   33 34                       67 41 22 2 0   0       0 2   33 34                 67
1273695 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 fall grade_4 38 26 6 0   0       0 7   42 35                       77 38 26 6 0   0       0 7   42 35                 77
1273707 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 fall grade_5 36 24 7 0   0       0 3   41 29                       70 36 24 7 0   0       0 3   41 29                 70
1273733 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten 38 23 11 0   0       0 3   41 34                       75 38 23 11 0   0       0 3   41 34                 75
1273748 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 fall pk_12_total 252 165 37 0   1       0 28   257 226                       483 252 165 37 0   1       0 28   257 226                 483
1273762 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten 26 15 1 0   0       0 3   21 24                       45 26 15 1 0   0       0 3   21 24                 45
2567841 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 spring grade_1 34 20 5 0   1       0 2   27 35                       62 34 20 5 0   1       0 2   27 35                 62
2567863 GA     school 1300001 741   Troup County 130000101853 397 Hogansville Elementary School   Regular School No Elementary PK 05 2019 spring grade_2 37 29 4 0   0       0 7   44 33                       77 37 29 4 0   0       0 7   44 33                 77

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