la-times

Custom SQL query returning 101 rows (hide)

This data as json, yaml, Notebook, copyable, CSV

rowidschoolstatusstaff_studenttransmissionstaff_student_ratecommunity_ratelac_ratecommunity_schoolscommunitydatetimecolorUnnamed: 0testing_periodtestspospos_ratechangecoscos_testscos_poscos_pos_ratecos_changelausd_testslausd_poslausd_pos_ratelausd_change
1 102ND ST EEC OPEN 1 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
2 107TH ST EL OPEN 3 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
3 109TH ST EL OPEN 0 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                                
4 10TH ST EL OPEN 6 0 35.42 27.58 31.39 MacArthur Park Community of Schools MacArthur Park Community 2021-08-26 10:00PM                                
5 112TH ST EEC OPEN 0 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                                
6 112TH ST EL OPEN 1 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                                
7 116TH ST EL OPEN 3 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                                
8 118TH ST EL OPEN 5 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
9 122ND ST EL OPEN 5 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
10 135TH ST EL OPEN 1 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
11 153RD ST EL OPEN 2 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
12 156TH ST EL OPEN 4 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
13 15TH ST EL OPEN 3 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                                
14 186TH ST EL OPEN 3 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
15 1ST ST EL OPEN 2 0 23.43 52.41 31.39 Boyle Heights Community of Schools Boyle Heights Community 2021-08-26 10:00PM                                
16 20TH ST EL OPEN 3 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                                
17 232ND PL EL OPEN 4 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
18 24TH ST EEC OPEN 0 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                                
19 24TH ST EL OPEN 7 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                                
20 28TH ST EEC OPEN 0 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                                
21 28TH ST EL OPEN 2 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                                
22 2ND ST EL OPEN 3 0 23.43 52.41 31.39 Boyle Heights Community of Schools Boyle Heights Community 2021-08-26 10:00PM                                
23 32ND ST USC PA MAG OPEN 3 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                                
24 36TH ST EEC OPEN 0 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                                
25 37TH ST EEC OPEN 0 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                                
26 3RD ST EL OPEN 2 0 12.79 27.86 31.39 Fairfax Community of Schools Fairfax Community 2021-08-26 10:00PM                                
27 42ND ST EL OPEN 6 0 44.85 40.16 31.39 H.E.E.T. (C/D) Community of Schools Baldwin Hills/Leimert Park Community 2021-08-26 10:00PM                                
28 49TH ST EL OPEN 5 0 30.1 37.5 31.39 Historic Central Avenue Community of Schools Jefferson/South Central (East) Community 2021-08-26 10:00PM                                
29 4TH ST EEC OPEN 0 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
30 4TH ST EL OPEN 1 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
31 4TH ST PC OPEN 1 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
32 52ND ST EL OPEN 4 0 49.08 45.08 31.39 South Mid-City Community of Schools South Mid-City Community 2021-08-26 10:00PM                                
33 54TH ST EL OPEN 1 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                                
34 59TH ST EL OPEN 3 0 44.85 40.16 31.39 H.E.E.T. (C/D) Community of Schools Baldwin Hills/Leimert Park Community 2021-08-26 10:00PM                                
35 61ST ST EL OPEN 5 0 49.08 45.08 31.39 South Mid-City Community of Schools South Mid-City Community 2021-08-26 10:00PM                                
36 66TH ST EEC OPEN 0 0 33.12 37.76 31.39 Rivera Community of Schools Florence-Firestone/Watts Community 2021-08-26 10:00PM                                
37 66TH ST EL OPEN 4 0 33.12 37.76 31.39 Rivera Community of Schools Florence-Firestone/Watts Community 2021-08-26 10:00PM                                
38 6TH AVE EL OPEN 5 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                                
39 74TH ST EL OPEN 4 0 44.85 40.16 31.39 H.E.E.T. (C/D) Community of Schools Baldwin Hills/Leimert Park Community 2021-08-26 10:00PM                                
40 75TH ST EEC OPEN 0 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
41 75TH ST EL OPEN 5 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
42 7TH ST EL AI MAG OPEN 1 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                                
43 92ND ST EL OPEN 6 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                                
44 93RD ST EL OPEN 1 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
45 95TH ST EEC OPEN 0 0 36.75 34.73 31.39 H.E.E.T. (W) Community of Schools Westmont/West Athens Community 2021-08-26 10:00PM                                
46 95TH ST EL OPEN 2 0 36.75 34.73 31.39 H.E.E.T. (W) Community of Schools Westmont/West Athens Community 2021-08-26 10:00PM                                
47 96TH ST EL OPEN 1 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                                
48 97TH ST EEC OPEN 0 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
49 99TH ST EL OPEN 6 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
50 9TH ST EL OPEN 1 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                                
51 ACAD ENRICH SCI MAG OPEN 2 0 42.46 34.23 31.39 Reseda Community of Schools Reseda Community 2021-08-26 10:00PM                                
52 ADAMS MS OPEN 4 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                                
53 ADDAMS HS OPEN 1 0 60.22 34.5 31.39 Kennedy/NAHS/VAAS Community of Schools Granada Hills/Northridge Community 2021-08-26 10:00PM                                
54 AGGELER HS OPEN 0 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
55 ALBION ST EEC OPEN 0 0 17.02 24.9 31.39 Lincoln Heights/El Sereno Community of Sc… Lincoln Heights/El Sereno Community 2021-08-26 10:00PM                                
56 ALBION ST EL OPEN 2 0 17.02 24.9 31.39 Lincoln Heights/El Sereno Community of Sc… Lincoln Heights/El Sereno Community 2021-08-26 10:00PM                                
57 ALDAMA EL OPEN 1 0 26.55 23.38 31.39 Eagle Rock/Highland Park Community of Scho… Eagle Rock/Highland Park Community 2021-08-26 10:00PM                                
58 ALEXANDER SCS OPEN 5 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                                
59 ALEXANDRIA AVE EEC OPEN 0 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                                
60 ALEXANDRIA AVE EL OPEN 4 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                                
61 ALLESANDRO EL OPEN 3 0 21.41 27.33 31.39 Glassell Park/Los Feliz Community of Schools Glassell Park/Los Feliz Community 2021-08-26 10:00PM                                
62 ALTA CALIFORNIA EL OPEN 5 0 45.59 36.92 31.39 Monroe Community of Schools North Hills/Panorama City Community 2021-08-26 10:00PM                                
63 ALTA LOMA EL OPEN 4 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                                
64 AMANECER PC OPEN 2 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
65 AMBLER AVE EL OPEN 5 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
66 AMESTOY EL OPEN 5 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
67 ANATOLA AVE EL OPEN 3 0 31.87 32.27 31.39 Cleveland Community of Schools Northridge/Reseda Community 2021-08-26 10:00PM                                
68 ANDASOL AVE EL OPEN 5 0 60.22 34.5 31.39 Kennedy/NAHS/VAAS Community of Schools Granada Hills/Northridge Community 2021-08-26 10:00PM                                
69 ANGEL'S GATE HS OPEN 0 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                                
70 ANGELES MESA EL OPEN 2 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                                
71 ANGELOU COMMUNITY SH OPEN 4 0 30.1 37.5 31.39 Historic Central Avenue Community of Schools Jefferson/South Central (East) Community 2021-08-26 10:00PM                                
72 ANN ST EL OPEN 0 0 17.02 24.9 31.39 Lincoln Heights/El Sereno Community of Sc… Lincoln Heights/El Sereno Community 2021-08-26 10:00PM                                
73 ANNALEE AVE EL OPEN 3 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
74 ANNANDALE EL OPEN 0 0 26.55 23.38 31.39 Eagle Rock/Highland Park Community of Scho… Eagle Rock/Highland Park Community 2021-08-26 10:00PM                                
75 ANTON EEC OPEN 0 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
76 ANTON EL OPEN 3 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
77 APPERSON ST EL OPEN 3 0 49.46 36.32 31.39 Sunland/Tujunga Community of Schools Sunland/Tujunga Community 2021-08-26 10:00PM                                
78 ARAGON AVE EL OPEN 1 0 21.41 27.33 31.39 Glassell Park/Los Feliz Community of Schools Glassell Park/Los Feliz Community 2021-08-26 10:00PM                                
79 ARLETA SH OPEN 4 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                                
80 ARLINGTON HTS EL OPEN 2 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                                
81 ARMINTA ST EEC OPEN 0 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                                
82 ARMINTA ST EL OPEN 0 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                                
83 ARROYO SECO MUS/S MAG OPEN 2 0 26.55 23.38 31.39 Eagle Rock/Highland Park Community of Scho… Eagle Rock/Highland Park Community 2021-08-26 10:00PM                                
84 ASCOT AVE EL OPEN 2 0 30.1 37.5 31.39 Historic Central Avenue Community of Schools Jefferson/South Central (East) Community 2021-08-26 10:00PM                                
85 ATWATER AVE EL OPEN 1 0 21.41 27.33 31.39 Glassell Park/Los Feliz Community of Schools Glassell Park/Los Feliz Community 2021-08-26 10:00PM                                
86 AUDUBON MS OPEN 3 0 44.85 40.16 31.39 H.E.E.T. (C/D) Community of Schools Baldwin Hills/Leimert Park Community 2021-08-26 10:00PM                                
87 AURORA EL OPEN 5 0 30.1 37.5 31.39 Historic Central Avenue Community of Schools Jefferson/South Central (East) Community 2021-08-26 10:00PM                                
88 AVALON GARDENS EL OPEN 0 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
89 BACA ARTS ACAD OPEN 5 0 33.12 37.76 31.39 Rivera Community of Schools Florence-Firestone/Watts Community 2021-08-26 10:00PM                                
90 BAKEWELL PC OPEN 0 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
91 BALA OPEN 1 0 49.08 45.08 31.39 South Mid-City Community of Schools South Mid-City Community 2021-08-26 10:00PM                                
92 BALBOA EL G/HG/HA MAG OPEN 7 0 60.22 34.5 31.39 Kennedy/NAHS/VAAS Community of Schools Granada Hills/Northridge Community 2021-08-26 10:00PM                                
93 BALDWIN HILLS EL OPEN 3 0 26.44 23.49 31.39 Hamilton Community of Schools Castle Heights Community 2021-08-26 10:00PM                                
94 BANCROFT MS OPEN 2 0 40.45 30.8 31.39 Hollywood Community of Schools Hollywood Community 2021-08-26 10:00PM                                
95 BANDINI ST EL OPEN 2 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                                
96 BANNEKER CTC OPEN 0 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
97 BANNING SH OPEN 33 0 55.08 40.32 31.39 Wilmington Community of Schools Wilmington Community 2021-08-26 10:00PM                                
98 BARRETT EL OPEN 3 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
99 BARTON HILL EL OPEN 8 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                                
100 BASSETT ST EL OPEN 7 0 42.46 34.23 31.39 Reseda Community of Schools Reseda Community 2021-08-26 10:00PM                                
101 BEACHY AVE EL OPEN 6 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM