Data source: Big Local News · About: Big Local

991 rows where grade = "grade_7" and state = "NH" sorted by ccd_school_high_grade descending

View and edit SQL

year

grade

  • grade_7 · 991
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
265042 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265105 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265188 NH     school 3304040 276   Kearsarge Regional 330404000687 26565 James House Preschool   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265197 NH     school 3304050 279   Keene 330405000723 29180 Jonathan Daniels School   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265315 NH     school 3304980 371   Nashua 330498000714 29152 Nashua Title I Preschool   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265318 NH     school 3304980 371   Nashua 330498000682 28610 Purple Panthers Preschool   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265347 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265366 NH     school 3305820 449   Portsmouth 330582000547 22560 PEEP School - Pre School Program   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265393 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
349747 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
350138 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
350648 NH     school 3302990 174   Fall Mountain Regional 330299000259 27395 Fall Mountain Regional -Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
352127 NH     school 3304040 276   Kearsarge Regional 330404000687 26565 James House Preschool Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
352263 NH     school 3304050 279   Keene 330405000723 29180 Jonathan Daniels School Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
354048 NH     school 3304980 371   Nashua 330498000714 29152 Nashua Title I Preschool Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
354592 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
354626 NH     school 3305820 449   Portsmouth 330582000547 22560 PEEP School - Pre School Program Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
355493 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool Public School Regular School No Prekindergarten PK PK 2021   grade_7                                                   0                                             0
265016 NH     school 3301650 33   Barrington 330165000700 29010 Early Childhood Learning Center   Regular School No Elementary PK KG 2020   grade_7                                                   0.0                                             0
265074 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program   Regular School No Elementary PK KG 2020   grade_7                                                   0.0                                             0
265125 NH     school 3303240 199   Goffstown 330324000620 28525 Glen Lake School   Regular School No Elementary PK KG 2020   grade_7                                                   0.0                                             0
265230 NH     school 3304410 319   Londonderry 330441000594 27905 Moose Hill School   Regular School No Elementary PK KG 2020   grade_7                                                   0.0                                             0
265427 NH     school 3306720 534   Timberlane Regional 330672000438 22775 Sandown Central School   Regular School No Elementary PK KG 2020   grade_7                                                   0.0                                             0
265444 NH     school 3307115 572   Wilton-Lyndeborough Cooperative 330711500237 23035 Lyndeborough Central School   Regular School No Elementary PK KG 2020   grade_7                                                   0.0                                             0
350325 NH     school 3301650 33   Barrington 330165000700 29010 Early Childhood Learning Center Public School Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
350988 NH     school 3303240 199   Goffstown 330324000620 28525 Glen Lake School Public School Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
352977 NH     school 3307115 572   Wilton-Lyndeborough Cooperative 330711500237 23035 Lyndeborough Central School Public School Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
353827 NH     school 3304410 319   Londonderry 330441000594 27905 Moose Hill School Public School Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
355578 NH     school 3306720 534   Timberlane Regional 330672000438 22775 Sandown Central School Public School Regular School No Elementary PK KG 2021   grade_7                                                   0                                             0
265045 NH     school 3302340 101   Claremont 330234000045 20140 Stevens High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265052 NH     school 3302460 111   Concord 330246000055 20285 Concord High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265097 NH     school 3300017 172   Exeter Region Cooperative 330001700106 20600 Exeter High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265179 NH     school 3303960 269   Inter-Lakes Cooperative 330396000185 20035 Inter-Lakes High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265191 NH     school 3304040 276   Kearsarge Regional 330404000193 22015 Kearsarge Regional High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265204 NH     school 3304140 285   Laconia 330414000210 21255 Laconia High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265216 NH     school 3304260 305   Lincoln-Woodstock Cooperative 330426000532 23110 Lin-Wood Public School (High)   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265333 NH     school 3305280 399   Newmarket 330528000518 23115 Newmarket Jr.-Sr. High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265334 NH     school 3305310 401   Newport 330531000342 21985 Newport Middle High School (High)   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265373 NH     school 3305880 453   Raymond 330588000385 21390 Raymond High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265409 NH     school 3306240 491   Somersworth 330624000418 22845 Somersworth High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265421 NH     school 3306540 515   Sunapee 330654000431 22000 Sunapee Sr. High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265450 NH     school 3307170 575   Windham 330717000692 28640 Windham High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265452 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School   Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
265459 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_7                                                   0.0                                             0
349067 NH     school 3301740 41   Bedford 330174000680 28555 Bedford High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
349118 NH     school 3306180 486   Shaker Regional 330618000411 22145 Belmont High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
349900 NH     school 3302460 111   Concord 330246000055 20285 Concord High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
349917 NH     school 3302480 112   Contoocook Valley 330248000067 22290 Conval Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
350767 NH     school 3303090 185   Franklin 330309000128 20660 Franklin High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
351872 NH     school 3303900 263   Hopkinton 330390000177 20970 Hopkinton High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
352331 NH     school 3304040 276   Kearsarge Regional 330404000193 22015 Kearsarge Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
352824 NH     school 3304290 306   Lisbon Regional 330429000227 23100 Lisbon Regional School (High) Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
353759 NH     school 3304890 363   Monadnock Regional 330489000301 21700 Monadnock Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
353844 NH     school 3304960 369   Moultonborough 330496000527 22120 Moultonborough Academy Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354201 NH     school 3305220 388   Newfound Area 330522000336 20085 Newfound Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354269 NH     school 3305280 399   Newmarket 330528000518 23115 Newmarket Jr.-Sr. High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354286 NH     school 3305310 401   Newport 330531000342 21985 Newport Middle High School (High) Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354558 NH     school 3305520 423   Oyster River Coop 330552000354 22800 Oyster River High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
354609 NH     school 3303292 728   PACE Career Academy Charter School 330329200701 29035 PACE Career Academy Charter School Charter Schools approved by local district Regular School Yes High 09 13 2021   grade_7                                                   0                                             0
354898 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academy Regular School No High 09 13 2021   grade_7                                                   0                                             0
355051 NH     school 3399965 428   Pemi-Baker Regional 339996500369 22350 Plymouth Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
355476 NH     school 3306060 473   Salem 330606000407 22880 Salem High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
355952 NH     school 3302340 101   Claremont 330234000045 20140 Stevens High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
356088 NH     school 3306540 515   Sunapee 330654000431 22000 Sunapee Sr. High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
356717 NH     school 3307050 568   White Mountains Regional 330705000454 21480 White Mountains Regional High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
356921 NH     school 3307230 581   Winnacunnet Cooperative 330723000463 20780 Winnacunnet High School Public School Regular School No High 09 13 2021   grade_7                                                   0                                             0
265019 NH     school 3301740 41   Bedford 330174000680 28555 Bedford High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265027 NH     school 3301860 51   Berlin 330186000027 20050 Berlin Senior High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265030 NH     school 3301950 57   Bow 330195000563 27375 Bow High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265047 NH     school 3302400 105   Colebrook 330240000049 20185 Colebrook Academy and Elementary School (H)   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265056 NH     school 3302480 112   Contoocook Valley 330248000067 22290 Conval Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265069 NH     school 3302490 113   Conway 330249000076 20345 Kennett High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265083 NH     school 3302640 141   Dover 330264000088 20455 Dover Senior High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265088 NH     school 3302670 142   Dresden 330267000096 20820 Hanover High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265092 NH     school 3302880 165   Epping 330288000103 20515 Epping High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265104 NH     school 3302990 174   Fall Mountain Regional 330299000116 22990 Fall Mountain Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265112 NH     school 3303000 175   Farmington 330300000123 22050 Farmington Senior High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265115 NH     school 3303090 185   Franklin 330309000128 20660 Franklin High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265121 NH     school 3303180 191   Gilford 330318000135 21240 Gilford High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265126 NH     school 3303240 199   Goffstown 330324000137 20700 Goffstown High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265130 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500142 20750 Gorham High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265135 NH     school 3303330 208   Governor Wentworth Regional 330333000146 22425 Kingswood Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265152 NH     school 3303660 238   Haverhill Cooperative 330366000160 20910 Woodsville High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265156 NH     school 3303750 251   Hillsboro-Deering Cooperative 330375000166 20950 Hillsboro-Deering High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265159 NH     school 3303780 255   Hinsdale 330378000168 21675 Hinsdale High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265164 NH     school 3303850 260   Hollis-Brookline Cooperative 330385000170 21810 Hollis-Brookline High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265170 NH     school 3303900 263   Hopkinton 330390000177 20970 Hopkinton High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265173 NH     school 3303930 267   Hudson 330393000179 21050 Alvirne High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265183 NH     school 3304030 274   Jaffrey-Rindge Cooperative 330403000188 22265 Conant High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265187 NH     school 3300003 275   John Stark Regional 330000300500 26380 John Stark Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265198 NH     school 3304050 279   Keene 330405000202 21195 Keene High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265211 NH     school 3304230 295   Lebanon 330423000218 21360 Lebanon High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265219 NH     school 3304290 306   Lisbon Regional 330429000227 23100 Lisbon Regional School (High)   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265221 NH     school 3304350 315   Litchfield 330435000674 27715 Campbell High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265225 NH     school 3304380 317   Littleton 330438000229 21445 Littleton High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265228 NH     school 3304410 319   Londonderry 330441000484 20490 Londonderry Senior High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265245 NH     school 3304590 335   Manchester 330459000244 21510 Manchester Central High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265246 NH     school 3304590 335   Manchester 330459000253 21505 Manchester Memorial High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265247 NH     school 3304590 335   Manchester 330459000708 29085 Manchester School of Technology (High School)   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265248 NH     school 3304590 335   Manchester 330459000261 21555 Manchester West High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0

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