Data source: Big Local News · About: Big Local

154 rows where grade = "grade_12", state = "NV" and year = 2019 sorted by rowid descending

View and edit SQL

year

  • 2019 · 54

grade

  • grade_12 · 54
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
1877021 NV     school 3200060 2   Clark 320006000754 2623 Desert Oasis HS   Regular School No High 09 12 2019   grade_12 239.0 86.0 208.0     156.0       21.0 54.0   403.0 361.0                       764 239 86 208     156       21 54   403 361                 764
1877017 NV     school 3200060 2   Clark 320006000745 2621 Delta Charter   Regular School Yes High 06 12 2019   grade_12 28.0 23.0 28.0     4.0         8.0   47.0 44.0                       91 28 23 28     4         8   47 44                 91
1877009 NV     school 3200060 2   Clark 320006000755 2620 NW Career & Tech   Regular School No High 09 12 2019   grade_12 121.0 33.0 142.0   3.0 63.0       9.0 23.0   179.0 215.0                       394 121 33 142   3 63       9 23   179 215                 394
1877004 NV     school 3200060 2   Clark 320006000714 2619 Legacy   Regular School No High 09 12 2019   grade_12 116.0 222.0 239.0   4.0 37.0       9.0 49.0   332.0 344.0                       676 116 222 239   4 37       9 49   332 344                 676
1876999 NV     school 3200060 2   Clark 320006000661 2618 Arbor View   Regular School No High 09 12 2019   grade_12 370.0 92.0 169.0   6.0 54.0       13.0 60.0   397.0 367.0                       764 370 92 169   6 54       13 60   397 367                 764
1876995 NV     school 3200060 2   Clark 320006000707 2616 Expl Knowledge SEC   Regular School Yes High 06 12 2019   grade_12 13.0 1.0 9.0     1.0         2.0   11.0 15.0                       26 13 1 9     1         2   11 15                 26
1876982 NV     school 3200060 2   Clark 320006000609 2614 Odyssey HS   Regular School Yes High 09 12 2019   grade_12 145.0 30.0 157.0   2.0 13.0       4.0 20.0   167.0 204.0                       371 145 30 157   2 13       4 20   167 204                 371
1876977 NV     school 3200060 2   Clark 320006000540 2612 Coronado   Regular School No High 09 12 2019   grade_12 441.0 47.0 136.0     98.0       7.0 53.0   399.0 383.0                       782 441 47 136     98       7 53   399 383                 782
1876972 NV     school 3200060 2   Clark 320006000539 2611 Sierra Vista HS   Regular School No High 09 12 2019   grade_12 143.0 102.0 147.0   3.0 136.0       33.0 69.0   350.0 283.0                       633 143 102 147   3 136       33 69   350 283                 633
1876967 NV     school 3200060 2   Clark 320006000495 2609 Desert Pines   Regular School No High 09 12 2019   grade_12 19.0 92.0 479.0   2.0 10.0       5.0 15.0   309.0 313.0                       622 19 92 479   2 10       5 15   309 313                 622
1876962 NV     school 3200060 2   Clark 320006000494 2608 Foothill HS   Regular School No High 09 12 2019   grade_12 343.0 19.0 150.0   6.0 26.0       6.0 41.0   313.0 278.0                       591 343 19 150   6 26       6 41   313 278                 591
1876957 NV     school 3200060 2   Clark 320006000493 2607 Centennial   Regular School No High 09 12 2019   grade_12 325.0 106.0 195.0   6.0 34.0       12.0 66.0   381.0 363.0                       744 325 106 195   6 34       12 66   381 363                 744
1876953 NV     school 3200060 2   Clark 320006000686 2604 Indian Springs HS   Regular School No High 09 12 2019   grade_12 14.0   2.0   2.0               12.0 6.0                       18 14   2   2               12 6                 18
1876948 NV     school 3200060 2   Clark 320006000111 2603 Virgin Valley   Regular School No High 09 12 2019   grade_12 73.0 2.0 90.0   2.0 1.0         1.0   80.0 89.0                       169 73 2 90   2 1         1   80 89                 169
1876943 NV     school 3200060 2   Clark 320006000078 2602 Moapa Valley   Regular School No High 09 12 2019   grade_12 99.0   21.0   6.0         1.0 1.0   66.0 62.0                       128 99   21   6         1 1   66 62                 128
1876938 NV     school 3200060 2   Clark 320006000013 2601 Boulder City   Regular School No High 09 12 2019   grade_12 102.0 1.0 15.0     1.0       2.0 7.0   67.0 61.0                       128 102 1 15     1       2 7   67 61                 128
1876933 NV     school 3200060 2   Clark 320006000812 2435 West C&T HS   Regular School No High 09 12 2019   grade_12 141.0 13.0 42.0     69.0       2.0 30.0   156.0 141.0                       297 141 13 42     69       2 30   156 141                 297
1876928 NV     school 3200060 2   Clark 320006000777 2434 Sunrise Mountain HS   Regular School No High 09 12 2019   grade_12 47.0 60.0 427.0   1.0 7.0       1.0 17.0   273.0 287.0                       560 47 60 427   1 7       1 17   273 287                 560
1876923 NV     school 3200060 2   Clark 320006000780 2433 SWCTA HS   Regular School No High 09 12 2019   grade_12 87.0 19.0 69.0   1.0 132.0       5.0 20.0   153.0 180.0                       333 87 19 69   1 132       5 20   153 180                 333
1876919 NV     school 3200060 2   Clark 320006000778 2432 VTCTA HS   Regular School No High 09 12 2019   grade_12 29.0 7.0 133.0     4.0       1.0 4.0   55.0 123.0                       178 29 7 133     4       1 4   55 123                 178
1876914 NV     school 3200060 2   Clark 320006000616 2431 Spring Valley   Regular School No High 09 12 2019   grade_12 150.0 75.0 190.0   2.0 98.0       10.0 45.0   307.0 263.0                       570 150 75 190   2 98       10 45   307 263                 570
1876909 NV     school 3200060 2   Clark 320006000571 2430 Del Sol   Regular School No High 09 12 2019   grade_12 83.0 56.0 371.0   3.0 22.0       7.0 30.0   292.0 280.0                       572 83 56 371   3 22       7 30   292 280                 572
1876904 NV     school 3200060 2   Clark 320006000567 2429 Canyon Springs   Regular School No High 09 12 2019   grade_12 26.0 162.0 387.0   1.0 21.0       6.0 24.0   316.0 311.0                       627 26 162 387   1 21       6 24   316 311                 627
1876899 NV     school 3200060 2   Clark 320006000604 2428 Liberty   Regular School No High 09 12 2019   grade_12 224.0 69.0 175.0   4.0 101.0       39.0 79.0   367.0 324.0                       691 224 69 175   4 101       39 79   367 324                 691
1876894 NV     school 3200060 2   Clark 320006000595 2427 Shadow Ridge HS   Regular School No High 09 12 2019   grade_12 320.0 114.0 193.0   5.0 40.0       16.0 55.0   375.0 368.0                       743 320 114 193   5 40       16 55   375 368                 743
1876890 NV     school 3200060 2   Clark 320006000463 2426 Coll So. NV HS S   Regular School No High 11 12 2019   grade_12 56.0 2.0 16.0     9.0       1.0 6.0   23.0 67.0                       90 56 2 16     9       1 6   23 67                 90
1876887 NV     school 3200060 2   Clark 320006000446 2425 Palo Verde HS   Regular School No High 09 12 2019   grade_12 393.0 47.0 174.0   3.0 79.0       8.0 62.0   372.0 394.0                       766 393 47 174   3 79       8 62   372 394                 766
1876882 NV     school 3200060 2   Clark 320006000445 2424 Mojave   Regular School No High 09 12 2019   grade_12 45.0 151.0 286.0   2.0 15.0       7.0 19.0   262.0 263.0                       525 45 151 286   2 15       7 19   262 263                 525
1876878 NV     school 3200060 2   Clark 320006000444 2423 Coll So. NV HS W   Regular School No High 11 12 2019   grade_12 38.0 10.0 30.0     23.0       2.0 3.0   32.0 74.0                       106 38 10 30     23       2 3   32 74                 106
1876876 NV     school 3200060 2   Clark 320006000443 2422 Coll So. NV HS E   Regular School No High 11 12 2019   grade_12 20.0 16.0 50.0     4.0       2.0 3.0   33.0 62.0                       95 20 16 50     4       2 3   33 62                 95
1876873 NV     school 3200060 2   Clark 320006000420 2421 Silverado   Regular School No High 09 12 2019   grade_12 168.0 65.0 162.0   2.0 59.0       11.0 48.0   265.0 250.0                       515 168 65 162   2 59       11 48   265 250                 515
1876868 NV     school 3200060 2   Clark 320006000419 2420 Advanced Tech Aca   Regular School No High 09 12 2019   grade_12 47.0 22.0 103.0     53.0       4.0 16.0   139.0 106.0                       245 47 22 103     53       4 16   139 106                 245
1876863 NV     school 3200060 2   Clark 320006000277 2418 Las Vegas Acad   Regular School No High 09 12 2019   grade_12 181.0 31.0 104.0   1.0 39.0       4.0 38.0   128.0 270.0                       398 181 31 104   1 39       4 38   128 270                 398
1876858 NV     school 3200060 2   Clark 320006000276 2417 Durango   Regular School No High 09 12 2019   grade_12 113.0 82.0 209.0   3.0 93.0       12.0 43.0   304.0 251.0                       555 113 82 209   3 93       12 43   304 251                 555
1876853 NV     school 3200060 2   Clark 320006000407 2416 Green Valley   Regular School No High 09 12 2019   grade_12 292.0 59.0 254.0   4.0 53.0       12.0 70.0   386.0 358.0                       744 292 59 254   4 53       12 70   386 358                 744
1876848 NV     school 3200060 2   Clark 320006000405 2415 Cheyenne   Regular School No High 09 12 2019   grade_12 63.0 152.0 228.0   4.0 21.0       7.0 21.0   274.0 222.0                       496 63 152 228   4 21       7 21   274 222                 496
1876843 NV     school 3200060 2   Clark 320006000406 2414 Cimarron Mem HS   Regular School No High 09 12 2019   grade_12 105.0 117.0 286.0   1.0 21.0       14.0 36.0   342.0 238.0                       580 105 117 286   1 21       14 36   342 238                 580
1876838 NV     school 3200060 2   Clark 320006000796 2412 SECTA   Regular School No High 09 12 2019   grade_12 71.0 22.0 210.0     33.0       2.0 23.0   161.0 200.0                       361 71 22 210     33       2 23   161 200                 361
1876833 NV     school 3200060 2   Clark 320006000011 2411 Bonanza   Regular School No High 09 12 2019   grade_12 125.0 74.0 285.0   1.0 26.0       7.0 25.0   276.0 267.0                       543 125 74 285   1 26       7 25   276 267                 543
1876828 NV     school 3200060 2   Clark 320006000032 2410 Eldorado HS   Regular School No High 09 12 2019   grade_12 38.0 56.0 384.0   1.0 14.0       4.0 10.0   302.0 205.0                       507 38 56 384   1 14       4 10   302 205                 507
1876823 NV     school 3200060 2   Clark 320006000018 2409 Chaparral   Regular School No High 09 12 2019   grade_12 76.0 92.0 328.0   7.0 25.0       8.0 22.0   271.0 287.0                       558 76 92 328   7 25       8 22   271 287                 558
1876819 NV     school 3200060 2   Clark 320006000103 2408 Morris Sunset   Alternative School No High 09 12 2019   grade_12 2.0 4.0 29.0               2.0   17.0 20.0                       37 2 4 29               2   17 20                 37
1876814 NV     school 3200060 2   Clark 320006000007 2406 Basic   Regular School No High 09 12 2019   grade_12 209.0 69.0 219.0   4.0 27.0       21.0 38.0   292.0 295.0                       587 209 69 219   4 27       21 38   292 295                 587
1876809 NV     school 3200060 2   Clark 320006000114 2405 Western   Regular School No High 09 12 2019   grade_12 33.0 96.0 483.0   3.0 23.0       9.0 17.0   378.0 286.0                       664 33 96 483   3 23       9 17   378 286                 664
1876804 NV     school 3200060 2   Clark 320006000107 2404 Valley HS   Regular School No High 09 12 2019   grade_12 57.0 87.0 478.0   3.0 40.0       4.0 23.0   328.0 364.0                       692 57 87 478   3 40       4 23   328 364                 692
1876799 NV     school 3200060 2   Clark 320006000089 2403 Rancho   Regular School No High 09 12 2019   grade_12 62.0 61.0 554.0   4.0 34.0       4.0 14.0   340.0 393.0                       733 62 61 554   4 34       4 14   340 393                 733
1876794 NV     school 3200060 2   Clark 320006000065 2402 Las Vegas   Regular School No High 09 12 2019   grade_12 79.0 69.0 545.0   5.0 39.0       8.0 22.0   415.0 352.0                       767 79 69 545   5 39       8 22   415 352                 767
1876789 NV     school 3200060 2   Clark 320006000030 2401 Clark   Regular School No High 09 12 2019   grade_12 86.0 92.0 443.0   2.0 151.0       12.0 24.0   419.0 391.0                       810 86 92 443   2 151       12 24   419 391                 810
1876779 NV     school 3200060 2   Clark 320006000749 2363 Innovations SEC   Regular School Yes High 06 12 2019   grade_12 3.0 2.0 20.0                   14.0 11.0                       25 3 2 20                   14 11                 25
1876681 NV     school 3200060 2   Clark 320006000460 2330 West Prep Sec SEC   Regular School No High 06 12 2019   grade_12 1.0 8.0 72.0     2.0             39.0 44.0                       83 1 8 72     2             39 44                 83
1876650 NV     school 3200060 2   Clark 320006000408 2321 Laughlin JSHS   Regular School No High 06 12 2019   grade_12 20.0 1.0 15.0     2.0         2.0   18.0 22.0                       40 20 1 15     2         2   18 22                 40
1876643 NV     school 3200060 2   Clark 320006000304 2320 Sandy Valley   Regular School No High 06 12 2019   grade_12 8.0 1.0 5.0     1.0             8.0 7.0                       15 8 1 5     1             8 7                 15
1876013 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2019   grade_12 2.0   5.0     1.0             3.0 5.0                       8 2   5     1             3 5                 8
1874969 NV     school 3200030 1   Churchill 320003000001 1401 Churchill Co   Regular School No High 09 12 2019   grade_12 159.0 3.0 57.0   16.0 4.0       3.0 14.0   131.0 125.0                       256 159 3 57   16 4       3 14   131 125                 256

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