Data source: Big Local News · About: Big Local

29,136 rows where state = "GA" and year = 2017 sorted by ccd_school_type

View and edit SQL

grade

year

  • 2017 · 29,136
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
310859 GA     school   891   Department of Juvenile Justice   4203 Terrell Regional Youth Detention Center             2017 spring grade_9 0 2 0 0   0       0 0   2 0                       2 0 2 0 0   0       0 0   2 0                 2
310885 GA     school   891   Department of Juvenile Justice   4203 Terrell Regional Youth Detention Center             2017 spring pk_12_total 0 2 0 0   0       0 0   2 0                       2 0 2 0 0   0       0 0   2 0                 2
298082 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_1 1 0 0 0   0       0 0   0 1                       1 1 0 0 0   0       0 0   0 1                 1
298086 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_10 15 3 1 0   0       0 1   10 10                       20 15 3 1 0   0       0 1   10 10                 20
298088 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_11 33 2 0 0   1       0 1   17 20                       37 33 2 0 0   1       0 1   17 20                 37
298090 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_12 31 2 0 0   0       0 4   12 25                       37 31 2 0 0   0       0 4   12 25                 37
298095 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_3 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
298099 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_4 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
298106 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_6 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
298110 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_7 2 0 0 0   0       0 0   1 1                       2 2 0 0 0   0       0 0   1 1                 2
298114 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_8 8 0 0 0   0       0 2   6 4                       10 8 0 0 0   0       0 2   6 4                 10
298118 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_9 18 1 0 0   0       0 2   11 10                       21 18 1 0 0   0       0 2   11 10                 21
298123 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring pk_12_total 109 10 1 0   1       0 10   59 72                       131 109 10 1 0   1       0 10   59 72                 131
300502 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring grade_10 1 27 2 0   1       0 1   27 5                       32 1 27 2 0   1       0 1   27 5                 32
300530 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring grade_11 0 5 0 0   0       0 0   5 0                       5 0 5 0 0   0       0 0   5 0                 5
300557 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring grade_12 0 12 0 0   0       0 0   10 2                       12 0 12 0 0   0       0 0   10 2                 12
300920 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring grade_6 0 20 1 0   0       0 0   20 1                       21 0 20 1 0   0       0 0   20 1                 21
300953 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring grade_7 0 25 2 0   0       0 0   19 8                       27 0 25 2 0   0       0 0   19 8                 27
300984 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring grade_8 0 41 2 0   1       0 0   33 11                       44 0 41 2 0   1       0 0   33 11                 44
301016 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring grade_9 3 26 1 0   0       0 1   24 7                       31 3 26 1 0   0       0 1   24 7                 31
301148 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring pk_12_total 4 156 8 0   2       0 2   138 34                       172 4 156 8 0   2       0 2   138 34                 172
302574 GA     school 1302280 660   Fulton County 130228001958 386 Independence High School   Alternative School No High 09 12 2017 spring grade_10 6 7 8 0   0       0 2   12 11                       23 6 7 8 0   0       0 2   12 11                 23
302577 GA     school 1302280 660   Fulton County 130228002037 383 McClarin High School   Alternative School No High 09 12 2017 spring grade_10 0 33 3 0   0       0 0   22 14                       36 0 33 3 0   0       0 0   22 14                 36
302594 GA     school 1302280 660   Fulton County 130228001958 386 Independence High School   Alternative School No High 09 12 2017 spring grade_11 8 23 22 0   1       0 3   26 31                       57 8 23 22 0   1       0 3   26 31                 57
302597 GA     school 1302280 660   Fulton County 130228002037 383 McClarin High School   Alternative School No High 09 12 2017 spring grade_11 1 64 5 0   0       0 0   39 31                       70 1 64 5 0   0       0 0   39 31                 70
302613 GA     school 1302280 660   Fulton County 130228001958 386 Independence High School   Alternative School No High 09 12 2017 spring grade_12 33 26 41 0   2       0 7   67 42                       109 33 26 41 0   2       0 7   67 42                 109
302616 GA     school 1302280 660   Fulton County 130228002037 383 McClarin High School   Alternative School No High 09 12 2017 spring grade_12 1 64 5 0   0       0 1   36 35                       71 1 64 5 0   0       0 1   36 35                 71
302968 GA     school 1302280 660   Fulton County 130228001958 386 Independence High School   Alternative School No High 09 12 2017 spring grade_9 1 1 0 0   0       0 1   1 2                       3 1 1 0 0   0       0 1   1 2                 3
302971 GA     school 1302280 660   Fulton County 130228002037 383 McClarin High School   Alternative School No High 09 12 2017 spring grade_9 0 17 5 0   0       0 1   14 9                       23 0 17 5 0   0       0 1   14 9                 23
303092 GA     school 1302280 660   Fulton County 130228001958 386 Independence High School   Alternative School No High 09 12 2017 spring pk_12_total 48 57 71 0   3       0 13   106 86                       192 48 57 71 0   3       0 13   106 86                 192
303104 GA     school 1302280 660   Fulton County 130228002037 383 McClarin High School   Alternative School No High 09 12 2017 spring pk_12_total 2 178 18 0   0       0 2   111 89                       200 2 178 18 0   0       0 2   111 89                 200
303620 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 spring grade_10 11 48 16 0   0       0 6   51 30                       81 11 48 16 0   0       0 6   51 30                 81
303634 GA     school 1302550 667   Gwinnett County 130255002039 189 Phoenix High School   Alternative School No High 09 12 2017 spring grade_10 6 31 50 1   1       0 1   40 50                       90 6 31 50 1   1       0 1   40 50                 90
303646 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 spring grade_11 9 42 23 0   1       0 0   48 27                       75 9 42 23 0   1       0 0   48 27                 75
303660 GA     school 1302550 667   Gwinnett County 130255002039 189 Phoenix High School   Alternative School No High 09 12 2017 spring grade_11 7 19 28 1   0       0 0   25 30                       55 7 19 28 1   0       0 0   25 30                 55
303672 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 spring grade_12 8 28 9 1   1       0 2   31 18                       49 8 28 9 1   1       0 2   31 18                 49
303685 GA     school 1302550 667   Gwinnett County 130255002039 189 Phoenix High School   Alternative School No High 09 12 2017 spring grade_12 29 71 116 1   7       0 5   122 107                       229 29 71 116 1   7       0 5   122 107                 229
304031 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 spring grade_6 3 6 4 0   0       0 0   12 1                       13 3 6 4 0   0       0 0   12 1                 13
304066 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 spring grade_7 2 12 5 0   0       0 1   18 2                       20 2 12 5 0   0       0 1   18 2                 20
304101 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 spring grade_8 11 23 12 0   0       0 1   35 12                       47 11 23 12 0   0       0 1   35 12                 47
304135 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 spring grade_9 7 63 22 0   0       0 7   61 38                       99 7 63 22 0   0       0 7   61 38                 99
304149 GA     school 1302550 667   Gwinnett County 130255002039 189 Phoenix High School   Alternative School No High 09 12 2017 spring grade_9 4 4 10 0   1       0 1   10 10                       20 4 4 10 0   1       0 1   10 10                 20
304285 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 spring pk_12_total 51 222 91 1   2       0 17   256 128                       384 51 222 91 1   2       0 17   256 128                 384
304340 GA     school 1302550 667   Gwinnett County 130255002039 189 Phoenix High School   Alternative School No High 09 12 2017 spring pk_12_total 46 125 204 3   9       0 7   197 197                       394 46 125 204 3   9       0 7   197 197                 394
308346 GA     school 1304890 736   Thomas County 130489002342 100 Bishop Hall Charter School   Alternative School Yes High 08 12 2017 spring grade_10 33 18 2 1   0       0 1   22 33                       55 33 18 2 1   0       0 1   22 33                 55
308349 GA     school 1304890 736   Thomas County 130489002342 100 Bishop Hall Charter School   Alternative School Yes High 08 12 2017 spring grade_11 32 8 0 0   0       0 0   21 19                       40 32 8 0 0   0       0 0   21 19                 40
308352 GA     school 1304890 736   Thomas County 130489002342 100 Bishop Hall Charter School   Alternative School Yes High 08 12 2017 spring grade_12 16 10 1 0   0       0 1   13 15                       28 16 10 1 0   0       0 1   13 15                 28
308364 GA     school 1304890 736   Thomas County 130489002342 100 Bishop Hall Charter School   Alternative School Yes High 08 12 2017 spring grade_8 14 4 2 0   0       0 1   11 10                       21 14 4 2 0   0       0 1   11 10                 21
308367 GA     school 1304890 736   Thomas County 130489002342 100 Bishop Hall Charter School   Alternative School Yes High 08 12 2017 spring grade_9 38 15 3 0   0       0 2   26 32                       58 38 15 3 0   0       0 2   26 32                 58
308371 GA     school 1304890 736   Thomas County 130489002342 100 Bishop Hall Charter School   Alternative School Yes High 08 12 2017 spring pk_12_total 133 55 8 1   0       0 5   93 109                       202 133 55 8 1   0       0 5   93 109                 202
308608 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring grade_10 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
308610 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring grade_11 0 3 0 0   0       0 0   1 2                       3 0 3 0 0   0       0 0   1 2                 3
308612 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring grade_12 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
308618 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring grade_6 1 2 0 0   0       0 0   1 2                       3 1 2 0 0   0       0 0   1 2                 3
308620 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring grade_7 0 4 0 0   0       0 0   3 1                       4 0 4 0 0   0       0 0   3 1                 4
308622 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring grade_8 1 3 0 0   0       0 0   1 3                       4 1 3 0 0   0       0 0   1 3                 4
308624 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring grade_9 1 3 0 0   0       0 0   4 0                       4 1 3 0 0   0       0 0   4 0                 4
308629 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring pk_12_total 34 71 4 2   0       0 0   56 55                       111 34 71 4 2   0       0 0   56 55                 111
308630 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Other 06 12 2017 spring pre_kindergarten 30 55 4 2   0       0 0   45 46                       91 30 55 4 2   0       0 0   45 46                 91
309392 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 spring grade_10 0 13 0 0   0       0 0   9 4                       13 0 13 0 0   0       0 0   9 4                 13
309399 GA     school 1300120 761   Atlanta Public Schools 130012000120 2664 Crim High School   Alternative School No High 09 12 2017 spring grade_10 0 35 0 0   0       0 0   19 16                       35 0 35 0 0   0       0 0   19 16                 35
309411 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 spring grade_11 0 7 0 0   0       0 0   7 0                       7 0 7 0 0   0       0 0   7 0                 7
309417 GA     school 1300120 761   Atlanta Public Schools 130012000120 2664 Crim High School   Alternative School No High 09 12 2017 spring grade_11 0 29 0 0   0       0 0   18 11                       29 0 29 0 0   0       0 0   18 11                 29
309429 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 spring grade_12 0 7 0 0   0       0 0   3 4                       7 0 7 0 0   0       0 0   3 4                 7
309435 GA     school 1300120 761   Atlanta Public Schools 130012000120 2664 Crim High School   Alternative School No High 09 12 2017 spring grade_12 0 25 2 0   0       0 0   12 15                       27 0 25 2 0   0       0 0   12 15                 27
309671 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 spring grade_6 0 12 0 0   0       0 0   7 5                       12 0 12 0 0   0       0 0   7 5                 12
309694 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 spring grade_7 0 29 1 0   0       0 0   25 5                       30 0 29 1 0   0       0 0   25 5                 30
309717 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 spring grade_8 0 37 3 0   0       0 0   32 8                       40 0 37 3 0   0       0 0   32 8                 40
309740 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 spring grade_9 1 43 4 0   0       0 1   39 10                       49 1 43 4 0   0       0 1   39 10                 49
309747 GA     school 1300120 761   Atlanta Public Schools 130012000120 2664 Crim High School   Alternative School No High 09 12 2017 spring grade_9 0 44 2 0   0       0 0   32 14                       46 0 44 2 0   0       0 0   32 14                 46
309814 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 spring pk_12_total 1 148 8 0   0       0 1   122 36                       158 1 148 8 0   0       0 1   122 36                 158
309837 GA     school 1300120 761   Atlanta Public Schools 130012000120 2664 Crim High School   Alternative School No High 09 12 2017 spring pk_12_total 0 133 4 0   0       0 0   81 56                       137 0 133 4 0   0       0 0   81 56                 137
310272 GA     school 1303510 781   Marietta City 130351003700 207 George W. Hartmann Center   Alternative School No High 09 12 2017 spring grade_10 3 3 4 0   0       0 0   6 4                       10 3 3 4 0   0       0 0   6 4                 10
310274 GA     school 1303510 781   Marietta City 130351003700 207 George W. Hartmann Center   Alternative School No High 09 12 2017 spring grade_11 1 2 0 0   0       0 0   2 1                       3 1 2 0 0   0       0 0   2 1                 3
310276 GA     school 1303510 781   Marietta City 130351003700 207 George W. Hartmann Center   Alternative School No High 09 12 2017 spring grade_12 1 0 0 0   0       0 0   0 1                       1 1 0 0 0   0       0 0   0 1                 1
310312 GA     school 1303510 781   Marietta City 130351003700 207 George W. Hartmann Center   Alternative School No High 09 12 2017 spring grade_9 0 0 0 0   0       0 1   0 1                       1 0 0 0 0   0       0 1   0 1                 1
310323 GA     school 1303510 781   Marietta City 130351003700 207 George W. Hartmann Center   Alternative School No High 09 12 2017 spring pk_12_total 5 5 4 0   0       0 1   8 7                       15 5 5 4 0   0       0 1   8 7                 15
310761 GA     school 1300026 891   Department of Juvenile Justice 130002603806 1898 Aaron Cohn Regional Youth Detention Center   Alternative School No Other 05 10 2017 spring grade_10 0 4 0 0   0       0 0   3 1                       4 0 4 0 0   0       0 0   3 1                 4
310763 GA     school 1300026 891   Department of Juvenile Justice 130002603488 298 Augusta Youth Development Campus   Alternative School No High 07 12 2017 spring grade_10 5 15 1 0   0       0 0   21 0                       21 5 15 1 0   0       0 0   21 0                 21
310764 GA     school 1300026 891   Department of Juvenile Justice 130002603511 2798 Bob Richards Regional Youth Detention Center   Alternative School No Other 09 10 2017 spring grade_10 3 1 0 0   0       0 0   4 0                       4 3 1 0 0   0       0 0   4 0                 4
310765 GA     school 1300026 891   Department of Juvenile Justice 130002603487 205 Crisp RYDC   Alternative School No Other 05 10 2017 spring grade_10 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
310766 GA     school 1300026 891   Department of Juvenile Justice 130002603504 2098 DeKalb Regional Youth Detention Center   Alternative School No Other 07 10 2017 spring grade_10 0 2 0 0   0       0 0   2 0                       2 0 2 0 0   0       0 0   2 0                 2
310767 GA     school 1300026 891   Department of Juvenile Justice 130002603505 2198 Eastman Regional Youth Detention Center   Alternative School No Other 07 10 2017 spring grade_10 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
310768 GA     school 1300026 891   Department of Juvenile Justice 130002603492 898 Eastman Youth Development Campus   Alternative School No High 09 12 2017 spring grade_10 1 6 1 0   0       0 0   8 0                       8 1 6 1 0   0       0 0   8 0                 8
310769 GA     school 1300026 891   Department of Juvenile Justice 130002603506 2298 Gainesville Regional Youth Detention Center   Alternative School No Other 07 11 2017 spring grade_10 1 0 1 0   0       1 0   2 1                       3 1 0 1 0   0       1 0   2 1                 3
310770 GA     school 1300026 891   Department of Juvenile Justice 130002603509 2598 Macon Regional Youth Detention Center   Alternative School No Other 07 09 2017 spring grade_10 1 1 0 0   0       0 0   2 0                       2 1 1 0 0   0       0 0   2 0                 2
310771 GA     school 1300026 891   Department of Juvenile Justice 130002603490 598 Macon Youth Development Campus   Alternative School No High 07 12 2017 spring grade_10 1 9 1 0   0       0 0   0 11                       11 1 9 1 0   0       0 0   0 11                 11
310772 GA     school 1300026 891   Department of Juvenile Justice 130002603510 2698 Marietta Regional Youth Detention Center   Alternative School No Other 07 11 2017 spring grade_10 2 3 1 0   0       0 0   4 2                       6 2 3 1 0   0       0 0   4 2                 6
310773 GA     school 1300026 891   Department of Juvenile Justice 130002603500 1698 Martha K. Glaze Regional Youth Detention Center   Alternative School No Other 07 11 2017 spring grade_10 1 4 0 0   0       0 0   5 0                       5 1 4 0 0   0       0 0   5 0                 5
310774 GA     school 1300026 891   Department of Juvenile Justice 130002603517 4198 Metro Regional Youth Detention Center   Alternative School No Other 06 11 2017 spring grade_10 1 3 0 0   0       0 0   3 1                       4 1 3 0 0   0       0 0   3 1                 4
310776 GA     school 1300026 891   Department of Juvenile Justice 130002603650 405 Muscogee Youth Development Center   Alternative School No Other 07 11 2017 spring grade_10 2 6 3 0   0       0 0   11 0                       11 2 6 3 0   0       0 0   11 0                 11
310778 GA     school 1300026 891   Department of Juvenile Justice 130002603512 2898 Sandersville Regional Youth Detention Center   Alternative School No Other 08 10 2017 spring grade_10 0 3 0 0   0       0 0   3 0                       3 0 3 0 0   0       0 0   3 0                 3
310779 GA     school 1300026 891   Department of Juvenile Justice 130002603513 2998 Savannah Regional Youth Detention Center   Alternative School No Other 07 10 2017 spring grade_10 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
310780 GA     school 1300026 891   Department of Juvenile Justice 130002603518 5001 Sumter Youth Development Campus   Alternative School No High 08 12 2017 spring grade_10 2 16 0 0   0       0 0   18 0                       18 2 16 0 0   0       0 0   18 0                 18
310781 GA     school 1300026 891   Department of Juvenile Justice 130002603514 3098 T J Loftiss II Regional Youth Detention Center   Alternative School No Other 07 10 2017 spring grade_10 1 1 0 0   0       0 0   2 0                       2 1 1 0 0   0       0 0   2 0                 2
310783 GA     school 1300026 891   Department of Juvenile Justice 130002603488 298 Augusta Youth Development Campus   Alternative School No High 07 12 2017 spring grade_11 1 1 0 0   0       0 0   2 0                       2 1 1 0 0   0       0 0   2 0                 2
310784 GA     school 1300026 891   Department of Juvenile Justice 130002603492 898 Eastman Youth Development Campus   Alternative School No High 09 12 2017 spring grade_11 1 5 1 0   0       0 0   7 0                       7 1 5 1 0   0       0 0   7 0                 7
310785 GA     school 1300026 891   Department of Juvenile Justice 130002603490 598 Macon Youth Development Campus   Alternative School No High 07 12 2017 spring grade_11 1 3 0 0   0       0 0   0 4                       4 1 3 0 0   0       0 0   0 4                 4
310786 GA     school 1300026 891   Department of Juvenile Justice 130002603510 2698 Marietta Regional Youth Detention Center   Alternative School No Other 07 11 2017 spring grade_11 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
310788 GA     school 1300026 891   Department of Juvenile Justice 130002603650 405 Muscogee Youth Development Center   Alternative School No Other 07 11 2017 spring grade_11 1 4 1 0   0       0 0   6 0                       6 1 4 1 0   0       0 0   6 0                 6

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