Data source: Big Local News · About: Big Local

1,778 rows where grade = "grade_4" and state = "MD"

View and edit SQL

year

grade

  • grade_4 · 1,678
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
1238255 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   103                                             103
1238263 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   101                                             101
1238271 MD     school 2400120 3   Baltimore County 240012000382 104 Edmondson Heights Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   77                                             77
1238279 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   106                                             106
1238287 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2020   grade_4                                                   *                                              
1238302 MD     school 2400120 3   Baltimore County 240012002945 112 Dogwood Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   111                                             111
1238310 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   91                                             91
1238318 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   115                                             115
1238326 MD     school 2400120 3   Baltimore County 240012000499 116 Woodbridge Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   63                                             63
1238356 MD     school 2400120 3   Baltimore County 240012000457 202 Randallstown Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   88                                             88
1238364 MD     school 2400120 3   Baltimore County 240012000385 204 Featherbed Lane Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   92                                             92
1238372 MD     school 2400120 3   Baltimore County 240012000503 205 Woodmoor Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   88                                             88
1238379 MD     school 2400120 3   Baltimore County 240012000471 206 Scotts Branch Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   90                                             90
1238387 MD     school 2400120 3   Baltimore County 240012000364 207 Church Lane Elementary Technology   Regular School No Elementary PK 05 2020   grade_4                                                   56                                             56
1238395 MD     school 2400120 3   Baltimore County 240012000402 209 Hebbville Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   79                                             79
1238403 MD     school 2400120 3   Baltimore County 240012000455 210 Powhatan Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   44                                             44
1238411 MD     school 2400120 3   Baltimore County 240012000498 211 Winfield Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   87                                             87
1238419 MD     school 2400120 3   Baltimore County 240012000497 213 Winand Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   89                                             89
1238427 MD     school 2400120 3   Baltimore County 240012000405 214 Hernwood Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   56                                             56
1238435 MD     school 2400120 3   Baltimore County 240012000371 216 Deer Park Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   61                                             61
1238443 MD     school 2400120 3   Baltimore County 240012001159 217 New Town Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   132                                             132
1238480 MD     school 2400120 3   Baltimore County 240012000348 303 Bedford Elementary   Regular School No Elementary 01 05 2020   grade_4                                                   79                                             79
1238487 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   84                                             84
1238493 MD     school 2400120 3   Baltimore County 240012000431 307 Milbrook Elementary   Regular School No Elementary 01 05 2020   grade_4                                                   76                                             76
1238501 MD     school 2400120 3   Baltimore County 240012000387 308 Fort Garrison Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   43                                             43
1238508 MD     school 2400120 3   Baltimore County 240012000481 310 Summit Park Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   64                                             64
1238515 MD     school 2400120 3   Baltimore County 240012001405 311 Woodholme Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   131                                             131
1238536 MD     school 2400120 3   Baltimore County 240012000439 402 Owings Mills Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   118                                             118
1238544 MD     school 2400120 3   Baltimore County 240012000388 403 Franklin Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   74                                             74
1238552 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2020   grade_4                                                   59                                             59
1238560 MD     school 2400120 3   Baltimore County 240012000484 405 Timber Grove Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   95                                             95
1238568 MD     school 2400120 3   Baltimore County 240012000460 406 Reisterstown Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   89                                             89
1238576 MD     school 2400120 3   Baltimore County 240012001346 407 Glyndon Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   84                                             84
1238584 MD     school 2400120 3   Baltimore County 240012000356 408 Cedarmere Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   81                                             81
1238591 MD     school 2400120 3   Baltimore County 240012001730 410 Lyons Mill Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   126                                             126
1238617 MD     school 2400120 3   Baltimore County 240012000386 501 Fifth District Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   53                                             53
1238624 MD     school 2400120 3   Baltimore County 240012000456 601 Prettyboy Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   67                                             67
1238632 MD     school 2400120 3   Baltimore County 240012000473 701 Seventh District Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   82                                             82
1238644 MD     school 2400120 3   Baltimore County 240012000476 801 Sparks Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   100                                             100
1238651 MD     school 2400120 3   Baltimore County 240012000350 803 Lutherville Laboratory   Regular School No Elementary KG 05 2020   grade_4                                                   66                                             66
1238658 MD     school 2400120 3   Baltimore County 240012001433 805 Timonium Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   79                                             79
1238666 MD     school 2400120 3   Baltimore County 240012000454 808 Pot Spring Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   77                                             77
1238673 MD     school 2400120 3   Baltimore County 240012000462 809 Riderwood Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   72                                             72
1238681 MD     school 2400120 3   Baltimore County 240012090440 810 Padonia International Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   79                                             79
1238689 MD     school 2400120 3   Baltimore County 240012000452 811 Pinewood Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   98                                             98
1238697 MD     school 2400120 3   Baltimore County 240012000491 813 Warren Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   57                                             57
1238705 MD     school 2400120 3   Baltimore County 240012001722 814 Mays Chapel Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   123                                             123
1238729 MD     school 2400120 3   Baltimore County 240012000479 905 Stoneleigh Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   126                                             126
1238736 MD     school 2400120 3   Baltimore County 240012000465 907 Rodgers Forge Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   70                                             70
1238744 MD     school 2400120 3   Baltimore County 240012000490 908 Villa Cresta Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   112                                             112
1238752 MD     school 2400120 3   Baltimore County 240012000453 909 Pleasant Plains Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   88                                             88
1238760 MD     school 2400120 3   Baltimore County 240012000435 910 Oakleigh Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   88                                             88
1238768 MD     school 2400120 3   Baltimore County 240012000399 911 Hampton Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   93                                             93
1238776 MD     school 2400120 3   Baltimore County 240012000407 912 Halstead Academy   Regular School No Elementary PK 05 2020   grade_4                                                   68                                             68
1238784 MD     school 2400120 3   Baltimore County 240012000400 915 Harford Hills Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   51                                             51
1238792 MD     school 2400120 3   Baltimore County 240012000463 916 Cromwell Valley Elementary Technology   Regular School No Elementary PK 05 2020   grade_4                                                   62                                             62
1238800 MD     school 2400120 3   Baltimore County 240012000450 921 Pine Grove Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   82                                             82
1238808 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge Ruxton   Special Education School No Other PK 12 2020   grade_4                                                   13                                             13
1238823 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2020   grade_4                                                   13                                             13
1238830 MD     school 2400120 3   Baltimore County 240012001696 925 West Towson Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   81                                             81
1238869 MD     school 2400120 3   Baltimore County 240012000352 1001 Carroll Manor Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   60                                             60
1238876 MD     school 2400120 3   Baltimore County 240012000467 1002 Jacksonville Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   91                                             91
1238883 MD     school 2400120 3   Baltimore County 240012000413 1104 Kingsville Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   59                                             59
1238891 MD     school 2400120 3   Baltimore County 240012000445 1105 Perry Hall Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   100                                             100
1238899 MD     school 2400120 3   Baltimore County 240012000351 1106 Carney Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   101                                             101
1238906 MD     school 2400120 3   Baltimore County 240012000358 1107 Chapel Hill Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   111                                             111
1238914 MD     school 2400120 3   Baltimore County 240012090444 1109 Joppa View Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   114                                             114
1238922 MD     school 2400120 3   Baltimore County 240012000021 1110 Seven Oaks Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   66                                             66
1238929 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   88                                             88
1238937 MD     school 2400120 3   Baltimore County 240012001750 1113 Honeygo Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   102                                             102
1238954 MD     school 2400120 3   Baltimore County 240012000375 1202 Dundalk Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   126                                             126
1238962 MD     school 2400120 3   Baltimore County 240012000349 1205 Berkshire Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   85                                             85
1238970 MD     school 2400120 3   Baltimore County 240012000347 1206 Bear Creek Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1238984 MD     school 2400120 3   Baltimore County 240012000395 1210 Grange Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   81                                             81
1238992 MD     school 2400120 3   Baltimore County 240012000359 1212 Charlesmont Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   58                                             58
1238999 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2020   grade_4                                                   *                                              
1239014 MD     school 2400120 3   Baltimore County 240012000470 1216 Sandy Plains Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   91                                             91
1239022 MD     school 2400120 3   Baltimore County 240012000421 1217 Logan Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239029 MD     school 2400120 3   Baltimore County 240012000408 1253 Holabird Middle   Regular School No Middle 04 08 2020   grade_4                                                   121                                             121
1239054 MD     school 2400120 3   Baltimore County 240012000341 1302 Arbutus Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   65                                             65
1239062 MD     school 2400120 3   Baltimore County 240012000344 1307 Baltimore Highlands Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239070 MD     school 2400120 3   Baltimore County 240012000464 1308 Riverview Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   83                                             83
1239078 MD     school 2400120 3   Baltimore County 240012000461 1310 Relay Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   103                                             103
1239086 MD     school 2400120 3   Baltimore County 240012000415 1311 Lansdowne Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   86                                             86
1239094 MD     school 2400120 3   Baltimore County 240012000398 1313 Halethorpe Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   52                                             52
1239115 MD     school 2400120 3   Baltimore County 240012000426 1403 McCormick Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   53                                             53
1239123 MD     school 2400120 3   Baltimore County 240012000391 1404 Fullerton Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   91                                             91
1239131 MD     school 2400120 3   Baltimore County 240012000383 1405 Elmwood Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   96                                             96
1239139 MD     school 2400120 3   Baltimore County 240012000459 1406 Red House Run Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   95                                             95
1239147 MD     school 2400120 3   Baltimore County 240012000474 1409 Shady Spring Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   96                                             96
1239168 MD     school 2400120 3   Baltimore County 240012000381 1502 Edgemere Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   62                                             62
1239175 MD     school 2400120 3   Baltimore County 240012000367 1503 Colgate Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   73                                             73
1239183 MD     school 2400120 3   Baltimore County 240012000489 1505 Victory Villa Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   112                                             112
1239191 MD     school 2400120 3   Baltimore County 240012000425 1506 Martin Boulevard Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   46                                             46
1239199 MD     school 2400120 3   Baltimore County 240012000360 1507 Chase Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   57                                             57
1239207 MD     school 2400120 3   Baltimore County 240012000384 1508 Essex Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   80                                             80
1239215 MD     school 2400120 3   Baltimore County 240012000363 1511 Chesapeake Terrace Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   40                                             40
1239223 MD     school 2400120 3   Baltimore County 240012000424 1512 Mars Estates Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   62                                             62
1239231 MD     school 2400120 3   Baltimore County 240012000482 1513 Sussex Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   76                                             76
1239239 MD     school 2400120 3   Baltimore County 240012000430 1514 Middlesex Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   73                                             73

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