Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_10" and state = "SD" sorted by male_int descending

View and edit SQL

year

grade

  • grade_10 · 4,696
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
495438 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2020   grade_10 454.0 57.0 80.0 24.0   16.0       0.0 27.0   363.0 295.0                       658.0 454 57 80 24   16       0 27   363 295                 658
257880 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   grade_10 480.0 36.0 75.0 28.0   22.0       0.0 15.0   354.0 302.0                       656.0 480 36 75 28   22       0 15   354 302                 656
457015 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School Not applicable High 09 12 2021   grade_10 451.0 63.0 103.0 17.0   12.0       0.0 29.0   353.0 322.0                       675.0 451 63 103 17   12       0 29   353 322                 675
365153 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2019   grade_10 479.0 47.0 75.0 22.0   18.0       1.0 17.0   348.0 311.0                       659.0 479 47 75 22   18       1 17   348 311                 659
3014308 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2017   grade_10 427.0 66.0 40.0 19.0   13.0         20.0   327.0 258.0                       585.0 427 66 40 19   13         20   327 258                 585
2969591 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No 3 09 12 2015   grade_10 427.0 51.0 51.0 41.0   17.0         19.0   324.0 282.0                       606.0 427 51 51 41   17         19   324 282                 606
3352186 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No 3 09 12 2016   grade_10 461.0 47.0 57.0 17.0   18.0       0.0 8.0   317.0 291.0                       608.0 461 47 57 17   18       0 8   317 291                 608
3352194 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2016   grade_10 361.0 83.0 52.0 22.0   37.0         12.0   295.0 272.0                       567.0 361 83 52 22   37         12   295 272                 567
3014318 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2017   grade_10 417.0 64.0 40.0 20.0   21.0       0.0 14.0   293.0 283.0                       576.0 417 64 40 20   21       0 14   293 283                 576
495428 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2020   grade_10 402.0 57.0 52.0 37.0   16.0       0.0 21.0   291.0 294.0                       585.0 402 57 52 37   16       0 21   291 294                 585
257889 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   grade_10 296.0 91.0 63.0 24.0   38.0       0.0 14.0   289.0 237.0                       526.0 296 91 63 24   38       0 14   289 237                 526
457005 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2021   grade_10 377.0 60.0 65.0 29.0   17.0       1.0 26.0   284.0 291.0                       575.0 377 60 65 29   17       1 26   284 291                 575
457024 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   grade_10 258.0 101.0 96.0 30.0   26.0       0.0 22.0   280.0 253.0                       533.0 258 101 96 30   26       0 22   280 253                 533
2969598 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No 3 09 12 2015   grade_10 339.0 85.0 42.0 23.0   49.0         10.0   279.0 269.0                       548.0 339 85 42 23   49         10   279 269                 548
365162 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2019   grade_10 275.0 109.0 67.0 20.0   42.0       0.0 17.0   272.0 258.0                       530.0 275 109 67 20   42       0 17   272 258                 530
3014328 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2017   grade_10 285.0 91.0 50.0 23.0   37.0       0.0 24.0   272.0 238.0                       510.0 285 91 50 23   37       0 24   272 238                 510
3352176 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No 3 09 12 2016   grade_10 375.0 44.0 35.0 39.0   14.0       0.0 9.0   272.0 244.0                       516.0 375 44 35 39   14       0 9   272 244                 516
365144 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2019   grade_10 375.0 57.0 41.0 24.0   12.0       0.0 18.0   270.0 257.0                       527.0 375 57 41 24   12       0 18   270 257                 527
456233 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2021   grade_10 296.0 8.0 40.0 83.0   6.0         64.0   263.0 234.0                       497.0 296 8 40 83   6         64   263 234                 497
3351385 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2016   grade_10 312.0 7.0 33.0 102.0   9.0         18.0   261.0 220.0                       481.0 312 7 33 102   9         18   261 220                 481
495447 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2020   grade_10 263.0 109.0 86.0 15.0   30.0       1.0 17.0   260.0 261.0                       521.0 263 109 86 15   30       1 17   260 261                 521
257870 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2018   grade_10 354.0 58.0 35.0 28.0   13.0       0.0 21.0   251.0 258.0                       509.0 354 58 35 28   13       0 21   251 258                 509
2968689 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No 3 09 12 2015   grade_10 338.0 6.0 25.0 93.0   9.0         23.0   250.0 244.0                       494.0 338 6 25 93   9         23   250 244                 494
494640 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 318.0 5.0 41.0 84.0   7.0       0.0 54.0   243.0 266.0                       509.0 318 5 41 84   7       0 54   243 266                 509
494659 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 362.0 2.0 24.0 15.0   8.0         32.0   239.0 204.0                       443.0 362 2 24 15   8         32   239 204                 443
2969579 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No 3 09 12 2015   grade_10 377.0 41.0 26.0 39.0   17.0       1.0 19.0   233.0 287.0                       520.0 377 41 26 39   17       1 19   233 287                 520
3013521 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2017   grade_10 318.0 13.0 14.0 91.0   4.0         20.0   233.0 227.0                       460.0 318 13 14 91   4         20   233 227                 460
364355 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2019   grade_10 306.0 7.0 31.0 80.0   2.0       0.0 43.0   231.0 238.0                       469.0 306 7 31 80   2       0 43   231 238                 469
257080 SD     school 4659820 51004   Rapid City Area 51-4 465982000529 41 Central Hi Sch   Regular School No High 09 12 2018   grade_10 318.0 10.0 28.0 78.0   4.0         24.0   229.0 233.0                       462.0 318 10 28 78   4         24   229 233                 462
456252 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School Not applicable High 09 12 2021   grade_10 342.0 1.0 37.0 18.0   11.0         28.0   227.0 210.0                       437.0 342 1 37 18   11         28   227 210                 437
3351404 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 2016   grade_10 354.0 2.0 12.0 15.0   6.0       0.0 14.0   225.0 178.0                       403.0 354 2 12 15   6       0 14   225 178                 403
2968708 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No 3 09 12 2015   grade_10 345.0 3.0 24.0 25.0   3.0         13.0   219.0 194.0                       413.0 345 3 24 25   3         13   219 194                 413
257099 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2018   grade_10 374.0 2.0 23.0 20.0   9.0       1.0 9.0   215.0 223.0                       438.0 374 2 23 20   9       1 9   215 223                 438
449910 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2021   grade_10 336.0 18.0 12.0 1.0   6.0         9.0   198.0 184.0                       382.0 336 18 12 1   6         9   198 184                 382
364374 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2019   grade_10 338.0 2.0 22.0 17.0   4.0         19.0   197.0 205.0                       402.0 338 2 22 17   4         19   197 205                 402
3013540 SD     school 4659820 51004   Rapid City Area 51-4 465982000525 42 Stevens Hi Sch   Regular School No High 09 12 2017   grade_10 338.0 5.0 20.0 23.0   3.0         10.0   187.0 212.0                       399.0 338 5 20 23   3         10   187 212                 399
488333 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 291.0 7.0 8.0 1.0   8.0         12.0   185.0 142.0                       327.0 291 7 8 1   8         12   185 142                 327
2971444 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No 3 09 12 2015   grade_10 300.0 3.0 13.0 13.0   3.0         2.0   181.0 153.0                       334.0 300 3 13 13   3         2   181 153                 334
3344184 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2016   grade_10 294.0 8.0 6.0 20.0   9.0       1.0 4.0   177.0 165.0                       342.0 294 8 6 20   9       1 4   177 165                 342
357059 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2019   grade_10 294.0 4.0 14.0 24.0   9.0       0.0 5.0   172.0 178.0                       350.0 294 4 14 24   9       0 5   172 178                 350
487344 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2020   grade_10 263.0 9.0 27.0 22.0   7.0       1.0 10.0   168.0 171.0                       339.0 263 9 27 22   7       1 10   168 171                 339
358064 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2019   grade_10 273.0 11.0 14.0 1.0   6.0       0.0 9.0   167.0 147.0                       314.0 273 11 14 1   6       0 9   167 147                 314
3016051 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2017   grade_10 279.0 5.0 9.0 12.0   2.0         4.0   167.0 144.0                       311.0 279 5 9 12   2         4   167 144                 311
458765 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2021   grade_10 259.0 5.0 12.0 15.0   2.0       0.0 8.0   162.0 139.0                       301.0 259 5 12 15   2       0 8   162 139                 301
3006241 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   grade_10 270.0 8.0 8.0 25.0   7.0       4.0 1.0   162.0 161.0                       323.0 270 8 8 25   7       4 1   162 161                 323
3353948 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No 3 09 12 2016   grade_10 282.0 0.0 11.0 11.0   4.0         3.0   162.0 149.0                       311.0 282 0 11 11   4         3   162 149                 311
452906 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2021   grade_10 276.0 9.0 10.0 0.0   6.0         12.0   160.0 153.0                       313.0 276 9 10 0   6         12   160 153                 313
2961618 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No 3 09 12 2015   grade_10 242.0 5.0 6.0 27.0   7.0         4.0   160.0 131.0                       291.0 242 5 6 27   7         4   160 131                 291
448921 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2021   grade_10 280.0 3.0 15.0 13.0   16.0       1.0 6.0   158.0 176.0                       334.0 280 3 15 13   16       1 6   158 176                 334
497186 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School Not applicable High 09 12 2020   grade_10 285.0 1.0 9.0 19.0   2.0         6.0   157.0 165.0                       322.0 285 1 9 19   2         6   157 165                 322
250805 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2018   grade_10 254.0 9.0 7.0 1.0   3.0       0.0 8.0   147.0 135.0                       282.0 254 9 7 1   3       0 8   147 135                 282
366885 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2019   grade_10 261.0 2.0 14.0 7.0   2.0         6.0   147.0 145.0                       292.0 261 2 14 7   2         6   147 145                 292
259658 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   grade_10 252.0 0.0 8.0 10.0   0.0       1.0 9.0   141.0 139.0                       280.0 252 0 8 10   0       1 9   141 139                 280
249816 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2018   grade_10 219.0 14.0 17.0 22.0   12.0       0.0 4.0   140.0 148.0                       288.0 219 14 17 22   12       0 4   140 148                 288
361060 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2019   grade_10 252.0 5.0 7.0 3.0   2.0         7.0   138.0 138.0                       276.0 252 5 7 3   2         7   138 138                 276
491329 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2020   grade_10 268.0 7.0 8.0 1.0   4.0       1.0 11.0   138.0 162.0                       300.0 268 7 8 1   4       1 11   138 162                 300
2962573 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2015   grade_10 253.0 6.0 6.0 0.0   3.0       0.0 2.0   138.0 132.0                       270.0 253 6 6 0   3       0 2   138 132                 270
3345142 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   grade_10 246.0 6.0 5.0 0.0   6.0       3.0 2.0   133.0 135.0                       268.0 246 6 5 0   6       3 2   133 135                 268
3010863 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2017   grade_10 123.0 4.0 51.0 4.0   46.0             132.0 96.0                       228.0 123 4 51 4   46             132 96                 228
253833 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2018   grade_10 220.0 1.0 5.0 3.0   1.0         8.0   130.0 108.0                       238.0 220 1 5 3   1         8   130 108                 238
488587 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2020   grade_10 199.0 1.0 15.0 7.0   8.0       0.0 5.0   129.0 106.0                       235.0 199 1 15 7   8       0 5   129 106                 235
3007214 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No High 09 12 2017   grade_10 235.0 8.0 7.0 0.0   3.0       0.0 3.0   129.0 127.0                       256.0 235 8 7 0   3       0 3   129 127                 256
459624 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2021   grade_10 199.0 4.0 27.0 9.0   1.0         5.0   128.0 117.0                       245.0 199 4 27 9   1         5   128 117                 245
3348201 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No 3 09 12 2016   grade_10 212.0 3.0 5.0 2.0   1.0         5.0   127.0 101.0                       228.0 212 3 5 2   1         5   127 101                 228
498015 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton High School   Regular School Not applicable High 09 12 2020   grade_10 200.0 5.0 8.0 12.0   3.0         5.0   126.0 107.0                       233.0 200 5 8 12   3         5   126 107                 233
2968416 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No 3 09 12 2015   grade_10 178.0 3.0 4.0 37.0   1.0         4.0   126.0 101.0                       227.0 178 3 4 37   1         4   126 101                 227
3016848 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2017   grade_10 201.0 5.0 10.0 12.0   3.0         1.0   124.0 108.0                       232.0 201 5 10 12   3         1   124 108                 232
3346613 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No 3 09 12 2016   grade_10 149.0 3.0 11.0 16.0   1.0       2.0 17.0   124.0 75.0                       199.0 149 3 11 16   1       2 17   124 75                 199
3348757 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No 3 09 12 2016   grade_10 97.0 3.0 52.0 3.0   54.0             119.0 90.0                       209.0 97 3 52 3   54             119 90                 209
450164 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2021   grade_10 208.0 7.0 17.0 4.0   7.0       1.0 17.0   118.0 143.0                       261.0 208 7 17 4   7       1 17   118 143                 261
451394 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2021   grade_10 148.0 7.0 21.0 15.0   3.0       1.0 16.0   118.0 93.0                       211.0 148 7 21 15   3       1 16   118 93                 211
358318 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2019   grade_10 202.0 7.0 12.0 2.0   15.0       1.0 8.0   117.0 130.0                       247.0 202 7 12 2   15       1 8   117 130                 247
494382 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2020   grade_10 150.0 3.0 4.0 26.0   1.0         31.0   116.0 99.0                       215.0 150 3 4 26   1         31   116 99                 215
3012464 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2017   grade_10 187.0 3.0 11.0 8.0   2.0         0.0   116.0 95.0                       211.0 187 3 11 8   2         0   116 95                 211
2972240 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2015   grade_10 201.0 6.0 9.0 6.0   0.0         2.0   115.0 109.0                       224.0 201 6 9 6   0         2   115 109                 224
2966173 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No 3 09 12 2015   grade_10 121.0 2.0 27.0 4.0   43.0         2.0   113.0 86.0                       199.0 121 2 27 4   43         2   113 86                 199
3010290 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2017   grade_10 202.0 4.0 5.0 2.0   3.0         4.0   113.0 107.0                       220.0 202 4 5 2   3         4   113 107                 220
260455 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   grade_10 190.0 3.0 12.0 9.0   1.0         4.0   112.0 107.0                       219.0 190 3 12 9   1         4   112 107                 219
359549 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2019   grade_10 143.0 3.0 12.0 16.0   1.0       1.0 26.0   112.0 90.0                       202.0 143 3 12 16   1       1 26   112 90                 202
3007468 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2017   grade_10 187.0 5.0 12.0 2.0   9.0       0.0 7.0   112.0 110.0                       222.0 187 5 12 2   9       0 7   112 110                 222
489818 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School Not applicable High 09 12 2020   grade_10 147.0 4.0 15.0 14.0   4.0       3.0 16.0   111.0 92.0                       203.0 147 4 15 14   4       3 16   111 92                 203
493567 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2020   grade_10 195.0 1.0 10.0 12.0   4.0       2.0 2.0   111.0 115.0                       226.0 195 1 10 12   4       2 2   111 115                 226
254406 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2018   grade_10 102.0 6.0 43.0 2.0   43.0       0.0 0.0   108.0 88.0                       196.0 102 6 43 2   43       0 0   108 88                 196
256822 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   grade_10 160.0 0.0 8.0 31.0   2.0       1.0 6.0   108.0 100.0                       208.0 160 0 8 31   2       1 6   108 100                 208
2965617 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No 3 09 12 2015   grade_10 187.0 1.0 0.0 6.0   2.0         4.0   108.0 92.0                       200.0 187 1 0 6   2         4   108 92                 200
367714 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2019   grade_10 177.0 1.0 18.0 11.0   0.0         1.0   107.0 101.0                       208.0 177 1 18 11   0         1   107 101                 208
3351127 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No 3 09 12 2016   grade_10 165.0 0.0 9.0 28.0   2.0         4.0   107.0 101.0                       208.0 165 0 9 28   2         4   107 101                 208
251059 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No High 09 12 2018   grade_10 192.0 6.0 6.0 5.0   6.0       1.0 8.0   105.0 119.0                       224.0 192 6 6 5   6       1 8   105 119                 224
3345412 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2016   grade_10 208.0 5.0 7.0 3.0   9.0       0.0 1.0   105.0 128.0                       233.0 208 5 7 3   9       0 1   105 128                 233
453479 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School Not applicable High 09 12 2021   grade_10 91.0 2.0 50.0 2.0   33.0       3.0 4.0   104.0 81.0                       185.0 91 2 50 2   33       3 4   104 81                 185
457787 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2021   grade_10 165.0 1.0 9.0 4.0   1.0       0.0 8.0   104.0 84.0                       188.0 165 1 9 4   1       0 8   104 84                 188
2962811 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School No 3 09 12 2015   grade_10 182.0 3.0 10.0 5.0   6.0       0.0 4.0   103.0 107.0                       210.0 182 3 10 5   6       0 4   103 107                 210
364097 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2019   grade_10 134.0 0.0 6.0 25.0   0.0         12.0   102.0 75.0                       177.0 134 0 6 25   0         12   102 75                 177
361633 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2019   grade_10 89.0 4.0 42.0 3.0   46.0       1.0 1.0   101.0 85.0                       186.0 89 4 42 3   46       1 1   101 85                 186
3354744 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No 3 09 12 2016   grade_10 171.0 3.0 15.0 4.0   2.0         1.0   100.0 96.0                       196.0 171 3 15 4   2         1   100 96                 196
455144 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2021   grade_10 170.0 2.0 11.0 8.0   1.0       2.0 2.0   99.0 97.0                       196.0 170 2 11 8   1       2 2   99 97                 196
496210 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2020   grade_10 166.0 2.0 13.0 8.0   1.0       1.0 4.0   99.0 96.0                       195.0 166 2 13 8   1       1 4   99 96                 195
252290 SD     school 4619410 51001   Douglas 51-1 461941000174 3 Douglas High School   Regular School No High 09 12 2018   grade_10 144.0 3.0 19.0 15.0   4.0       0.0 12.0   98.0 99.0                       197.0 144 3 19 15   4       0 12   98 99                 197
2967728 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No 3 09 12 2015   grade_10 161.0 1.0 4.0 7.0   2.0       0.0 1.0   98.0 78.0                       176.0 161 1 4 7   2       0 1   98 78                 176
258698 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2018   grade_10 153.0 1.0 7.0 9.0   1.0         5.0   96.0 80.0                       176.0 153 1 7 9   1         5   96 80                 176

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