schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

Query parameters

rowidstatecountycounty_state_idadmin_leveldistrict_nces_iddistrict_state_iddistrict_state_typedistrictschool_nces_idschool_state_idschoolschool_state_typeccd_school_typeccd_charter_schoolccd_school_lvlccd_school_low_gradeccd_school_high_gradeyeartermgradewhiteblackhispanicnative_americannative_american_alaskan_nativeasiannative_hawaiianasian_pacific_islandernative_hawaiian_pacific_islanderpacific_islandermultiracialunknown_racemalefemalenon_binaryunknown_genderellell_percenthomelesshomeless_percentlow_incomefree_and_reducedfree_and_reduced_percentdisabilitysection_504totalwhite_intblack_inthispanic_intnative_american_intnative_american_alaskan_native_intasian_intnative_hawaiian_intasian_pacific_islander_intnative_hawaiian_pacific_islander_intpacific_islander_intmultiracial_intunknown_race_intmale_intfemale_intnon_binary_intunknown_gender_intell_inthomeless_intlow_income_intfree_and_reduced_intdisability_intsection_504_inttotal_int
260995 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   pre_kindergarten                                                   0.0                                             0
261491 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   kindergarten                                                   0.0                                             0
261987 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   readiness                                                   0.0                                             0
262483 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_1                                                   0.0                                             0
262979 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_2                                                   0.0                                             0
263475 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_3                                                   0.0                                             0
263971 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_4                                                   0.0                                             0
264467 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_5                                                   0.0                                             0
264963 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_6                                                   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
265955 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_8                                                   0.0                                             0
266451 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_9                                                   864.0                                             864
266947 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_10                                                   796.0                                             796
267443 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_11                                                   797.0                                             797
267939 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   grade_12                                                   674.0                                             674
268435 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   post_graduate                                                   10.0                                             10
268931 NH     school 3307360 999   Pinkerton Academy 330736000510 20395 Pinkerton Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 13 2020   pk_12_total                                                   3141.0                                             3141
260994 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261490 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
261986 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   readiness                                                   0.0                                             0
262482 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262978 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
263474 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
263970 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
264466 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
264962 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
265458 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265954 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
266450 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_9                                                   182.0                                             182
266946 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_10                                                   156.0                                             156
267442 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_11                                                   173.0                                             173
267938 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_12                                                   179.0                                             179
268434 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   post_graduate                                                   0.0                                             0
268930 NH     school 3307330 998   Coe-Brown Northwood Academy 330733000519 22025 Coe-Brown Northwood Academy Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pk_12_total                                                   690.0                                             690
260575 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
261071 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   kindergarten                                                   28.0                                             28
261567 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   readiness                                                   0.0                                             0
262063 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_1                                                   29.0                                             29
262559 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_2                                                   19.0                                             19
263055 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_3                                                   19.0                                             19
263551 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_4                                                   28.0                                             28
264047 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_5                                                   18.0                                             18
264543 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_6                                                   26.0                                             26
265039 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_7                                                   27.0                                             27
265535 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_8                                                   20.0                                             20
266031 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_9                                                   0.0                                             0
266527 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_10                                                   0.0                                             0
267023 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_11                                                   0.0                                             0
267519 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
268015 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   post_graduate                                                   0.0                                             0
268511 NH     school 3302310 99   Chichester 330231000037 22590 Chichester Central School   Regular School No Elementary KG 08 2020   pk_12_total                                                   214.0                                             214
260996 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261492 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
261988 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   readiness                                                   0.0                                             0
262484 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
262980 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
263476 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
263972 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
264468 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
264964 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
265460 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
265956 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
266452 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_9                                                   129.0                                             129
266948 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_10                                                   126.0                                             126
267444 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_11                                                   90.0                                             90
267940 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   grade_12                                                   106.0                                             106
268436 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   post_graduate                                                   0.0                                             0
268932 NH     school 3300049 970   Prospect Mountain JMA 330004900619 28215 Prospect Mountain High School Public Academies and Joint Maintenance Agreements Regular School No High 09 12 2020   pk_12_total                                                   451.0                                             451
260574 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
261070 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   kindergarten                                                   35.0                                             35
261566 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   readiness                                                   0.0                                             0
262062 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_1                                                   22.0                                             22
262558 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_2                                                   35.0                                             35
263054 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_3                                                   41.0                                             41
263550 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_4                                                   34.0                                             34
264046 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_5                                                   43.0                                             43
264542 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_6                                                   26.0                                             26
265038 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_7                                                   34.0                                             34
265534 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_8                                                   20.0                                             20
266030 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_9                                                   0.0                                             0
266526 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_10                                                   0.0                                             0
267022 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_11                                                   0.0                                             0
267518 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
268014 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   post_graduate                                                   0.0                                             0
268510 NH     school 3302280 95   Chesterfield 330228000036 21140 Chesterfield Central School   Regular School No Elementary KG 08 2020   pk_12_total                                                   290.0                                             290
260573 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   16.0                                             16
261069 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   kindergarten                                                   45.0                                             45
261565 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   readiness                                                   0.0                                             0
262061 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_1                                                   50.0                                             50
262557 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_2                                                   44.0                                             44
263053 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_3                                                   53.0                                             53
263549 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_4                                                   56.0                                             56
264045 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_5                                                   57.0                                             57
264541 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_6                                                   55.0                                             55
265037 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_7                                                   69.0                                             69
265533 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_8                                                   54.0                                             54
266029 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_9                                                   0.0                                             0
266525 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_10                                                   0.0                                             0
267021 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_11                                                   0.0                                             0
267517 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
268013 NH     school 3302250 93   Chester 330225000035 20500 Chester Academy   Regular School No Elementary PK 08 2020   post_graduate                                                   0.0                                             0