enrollments

Data source: Big Local News · About: Big Local

147 rows where grade = "grade_9", state = "NV" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 47 ✖

grade ✖

  • grade_9 · 47 ✖
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
1877880 1877880 NV     school 3200390 13   Carson 320039000280 13501 Carson HS   Regular School No High 09 12 2019   grade_9 265.0 2.0 273.0   13.0 9.0         25.0   288.0 299.0                       587 265 2 273   13 9         25   288 299                 587
1877885 1877885 NV     school 3200390 13   Carson 320039000480 13903 Pioneer HS   Alternative School No High 09 12 2019   grade_9 7.0   4.0               1.0   6.0 6.0                       12 7   4               1   6 6                 12
1877906 1877906 NV     school 3200420 14   Pershing 320042000198 14601 Pershing HS   Regular School No High 09 12 2019   grade_9 21.0   13.0   5.0           3.0   21.0 21.0                       42 21   13   5           3   21 21                 42
1877928 1877928 NV     school 3200450 15   Storey 320045000199 15601 Virginia City HS   Regular School No High 09 12 2019   grade_9 31.0   4.0               1.0   13.0 23.0                       36 31   4               1   13 23                 36
1878453 1878453 NV     school 3200480 16   Washoe 320048000525 16312 Coral Acad HS   Regular School Yes High 09 12 2019   grade_9 47.0 2.0 35.0   1.0 24.0       1.0 6.0   64.0 52.0                       116 47 2 35   1 24       1 6   64 52                 116
1878475 1878475 NV     school 3200480 16   Washoe 320048000208 16501 Wooster   Regular School No High 09 12 2019   grade_9 70.0 14.0 262.0   9.0 21.0       8.0 13.0   181.0 216.0                       397 70 14 262   9 21       8 13   181 216                 397
1878480 1878480 NV     school 3200480 16   Washoe 320048000239 16502 Reno   Regular School No High 09 12 2019   grade_9 314.0 13.0 104.0   1.0 21.0       5.0 32.0   258.0 232.0                       490 314 13 104   1 21       5 32   258 232                 490
1878485 1878485 NV     school 3200480 16   Washoe 320048000246 16503 Sparks   Regular School No High 09 12 2019   grade_9 48.0 13.0 210.0   2.0 4.0       6.0 14.0   164.0 133.0                       297 48 13 210   2 4       6 14   164 133                 297
1878490 1878490 NV     school 3200480 16   Washoe 320048000238 16504 Hug HS   Regular School No High 09 12 2019   grade_9 57.0 8.0 275.0   3.0 11.0       11.0 15.0   185.0 195.0                       380 57 8 275   3 11       11 15   185 195                 380
1878495 1878495 NV     school 3200480 16   Washoe 320048000210 16505 Reed   Regular School No High 09 12 2019   grade_9 260.0 17.0 209.0   9.0 30.0       6.0 33.0   312.0 252.0                       564 260 17 209   9 30       6 33   312 252                 564
1878505 1878505 NV     school 3200480 16   Washoe 320048000822 16507 Inspire   Alternative School No Other PK 12 2019   grade_9 9.0   4.0                   9.0 4.0                       13 9   4                   9 4                 13
1878510 1878510 NV     school 3200480 16   Washoe 320048000323 16508 McQueen HS   Regular School No High 09 12 2019   grade_9 255.0 4.0 108.0   4.0 30.0       9.0 29.0   224.0 215.0                       439 255 4 108   4 30       9 29   224 215                 439
1878515 1878515 NV     school 3200480 16   Washoe 320048000257 16509 Galena   Regular School No High 09 12 2019   grade_9 176.0 6.0 142.0   2.0 18.0       2.0 19.0   191.0 174.0                       365 176 6 142   2 18       2 19   191 174                 365
1878520 1878520 NV     school 3200480 16   Washoe 320048000869 16510 Innovations   Alternative School No High 09 12 2019   grade_9 5.0 2.0 5.0               1.0   7.0 6.0                       13 5 2 5               1   7 6                 13
1878532 1878532 NV     school 3200480 16   Washoe 320048000217 16601 Gerlach K-12   Regular School No Other PK 12 2019   grade_9 1.0   1.0                   2.0                         2 1   1                   2                   2
1878537 1878537 NV     school 3200480 16   Washoe 320048000225 16602 Incline HS   Regular School No High 09 12 2019   grade_9 48.0   26.0   1.0 2.0         2.0   37.0 42.0                       79 48   26   1 2         2   37 42                 79
1878544 1878544 NV     school 3200480 16   Washoe 320048000482 16604 I Can Do Anything   Regular School Yes High 09 12 2019   grade_9 6.0   6.0             2.0 4.0   9.0 9.0                       18 6   6             2 4   9 9                 18
1878557 1878557 NV     school 3200480 16   Washoe 320048000545 16606 Spanish Spgs   Regular School No High 09 12 2019   grade_9 314.0 13.0 254.0   17.0 17.0       4.0 41.0   344.0 316.0                       660 314 13 254   17 17       4 41   344 316                 660
1878562 1878562 NV     school 3200480 16   Washoe 320048000546 16607 North Valleys   Regular School No High 09 12 2019   grade_9 254.0 15.0 243.0   7.0 16.0       6.0 38.0   294.0 285.0                       579 254 15 243   7 16       6 38   294 285                 579
1878567 1878567 NV     school 3200480 16   Washoe 320048000562 16608 Acad for Career E   Regular School Yes High 09 12 2019   grade_9 19.0   23.0     1.0       1.0 2.0   39.0 7.0                       46 19   23     1       1 2   39 7                 46
1878571 1878571 NV     school 3200480 16   Washoe 320048000602 16609 Damonte Ranch HS   Regular School No High 09 12 2019   grade_9 284.0 6.0 128.0   6.0 31.0       1.0 27.0   237.0 246.0                       483 284 6 128   6 31       1 27   237 246                 483
1878576 1878576 NV     school 3200480 16   Washoe 320048000603 16610 enCompass HS   Regular School Yes High 09 12 2019   grade_9 12.0   7.0                   10.0 9.0                       19 12   7                   10 9                 19
1878580 1878580 NV     school 3200480 16   Washoe 320048000664 16611 AACT   Regular School No High 09 12 2019   grade_9 88.0   41.0     12.0       1.0 13.0   68.0 87.0                       155 88   41     12       1 13   68 87                 155
1878594 1878594 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2019   grade_9 5.0   3.0                   4.0 4.0                       8 5   3                   4 4                 8
1878608 1878608 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_9 2.0   2.0                   1.0 3.0                       4 2   2                   1 3                 4
1878620 1878620 NV     school 3200480 16   Washoe 320048000844 16923 North Star   Alternative School No Other PK 12 2019   grade_9 22.0       1.0 1.0         2.0   11.0 15.0                       26 22       1 1         2   11 15                 26
1878653 1878653 NV     school 3200510 17   White Pine 320051000267 17502 White Pine HS   Regular School No High 09 12 2019   grade_9 62.0   15.0   4.0 1.0         4.0   41.0 45.0                       86 62   15   4 1         4   41 45                 86
1878661 1878661 NV     school 3200510 17   White Pine 320051000606 17601 Lund Jr S HS   Regular School No High 06 12 2019   grade_9 22.0 8.0 5.0   1.0 1.0       4.0     17.0 24.0                       41 22 8 5   1 1       4     17 24                 41
1878665 1878665 NV     school 3200510 17   White Pine 320051000483 17903 Steptoe Vly HS   Alternative School No High 09 12 2019   grade_9 1.0 1.0                     1.0 1.0                       2 1 1                     1 1                 2
1878706 1878706 NV     school 3200001 47   Sports Leadership and Management Academy 320000100870 47434 SLAM ACAD   Regular School Yes Secondary 06 11 2019   grade_9 45.0 15.0 71.0     5.0       7.0 10.0   101.0 52.0                       153 45 15 71     5       7 10   101 52                 153
1878712 1878712 NV     school 3200001 48   Equipo Academy 320000100856 48433 Equipo ACAD   Regular School Yes High 06 12 2019   grade_9 4.0 1.0 142.0     1.0       1.0     69.0 80.0                       149 4 1 142     1       1     69 80                 149
1878743 1878743 NV     school 3200001 50   American Preparatory Academy 320000100848 50431 American Prep ACAD   Regular School Yes Other KG 12 2019   grade_9 43.0 29.0 28.0     23.0       2.0 7.0   57.0 75.0                       132 43 29 28     23       2 7   57 75                 132
1878756 1878756 NV     school 3200001 51   Founders Academy of Nevada 320000100843 51430 Founders ACAD   Regular School Yes Other KG 12 2019   grade_9 26.0 4.0 21.0     1.0         3.0   29.0 26.0                       55 26 4 21     1         3   29 26                 55
1878764 1878764 NV     school 3200001 52   Leadership Academy of Nevada 320000100886 52429 Leadership ACAD   Regular School Yes High 06 12 2019   grade_9 43.0 1.0 5.0     2.0       1.0 2.0   32.0 22.0                       54 43 1 5     2       1 2   32 22                 54
1878803 1878803 NV     school 3200001 55   Doral Academy 320000100830 55202 Doral Red Rock ACAD   Regular School Yes Other KG 11 2019   grade_9 91.0 9.0 36.0     11.0       6.0 7.0   79.0 81.0                       160 91 9 36     11       6 7   79 81                 160
1878848 1878848 NV     school 3200001 58   Pinecrest Academy of Nevada 320000100825 58423 PAN Cadence   Regular School Yes Other KG 11 2019   grade_9 67.0 6.0 32.0   3.0 5.0       1.0 5.0   62.0 57.0                       119 67 6 32   3 5       1 5   62 57                 119
1878887 1878887 NV     school 3200001 59   Somerset Academy 320000100898 59120 Somerset Losee   Regular School Yes Other KG 12 2019   grade_9 43.0 52.0 81.0   2.0 10.0       2.0 17.0   111.0 96.0                       207 43 52 81   2 10       2 17   111 96                 207
1878909 1878909 NV     school 3200001 59   Somerset Academy 320000100820 59122 Somerset SkyPt   Regular School Yes Other KG 12 2019   grade_9 98.0 23.0 54.0   2.0 4.0       2.0 21.0   103.0 101.0                       204 98 23 54   2 4       2 21   103 101                 204
1878966 1878966 NV     school 3200001 65   Oasis Academy 320000100817 65414 Oasis ACAD   Regular School Yes Other KG 12 2019   grade_9 28.0   6.0   1.0 4.0         1.0   19.0 21.0                       40 28   6   1 4         1   19 21                 40
1879005 1879005 NV     school 3200001 76   Alpine Academy 320000100800 76412 Alpine ACAD   Regular School Yes High 09 12 2019   grade_9 20.0   8.0   1.0           2.0   12.0 19.0                       31 20   8   1           2   12 19                 31
1879032 1879032 NV     school 3200001 85   Nevada Connections Academy 320000100731 85405 NV Connections ACAD   Regular School Yes Other KG 12 2019   grade_9 216.0 60.0 116.0   3.0 8.0       9.0 44.0   200.0 256.0                       456 216 60 116   3 8       9 44   200 256                 456
1879045 1879045 NV     school 3200001 86   Nevada Virtual Academy 320000100734 86404 Nevada Virtual ACAD   Regular School Yes Other KG 12 2019   grade_9 79.0 17.0 51.0   1.0 10.0       7.0     79.0 86.0                       165 79 17 51   1 10       7     79 86                 165
1879069 1879069 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100742 87312 CASLV SandyRidge   Regular School Yes High 06 12 2019   grade_9 42.0 17.0 22.0   1.0 33.0       4.0 20.0   66.0 73.0                       139 42 17 22   1 33       4 20   66 73                 139
1879088 1879088 NV     school 3200001 89   Beacon Academy of Nevada 320000100751 89409 Beacon ACAD   Regular School Yes High 09 12 2019   grade_9 3.0   1.0               1.0   3.0 2.0                       5 3   1               1   3 2                 5
1879100 1879100 NV     school 3200021 84   University Schools 320002100680 19406 Davidson Acad   Regular School No High 05 12 2019   grade_9 21.0   1.0   1.0 9.0             12.0 20.0                       32 21   1   1 9             12 20                 32
1879104 1879104 NV     school 3200023 79   Independence HS 320002300808 79903 Independence HS   Alternative School No High 07 12 2019   grade_9 2.0 1.0 2.0                   5.0                         5 2 1 2                   5                   5
1879120 1879120 NV     school 3200022 46   Democracy Prep 320002200882 46300 DP Agassi HS   Regular School Yes High 09 12 2019   grade_9 3.0 52.0 23.0               3.0   38.0 43.0                       81 3 52 23               3   38 43                 81

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