Match events with items using canned_search

new_orleans_integration

• _su: "School integration--Louisiana--New Orleans"
• { "dcterms_subject": ["School integration--Louisiana--New Orleans"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%School integration--Louisiana--New Orleans% ")
• http://crdl.usg.edu/query:_su:%22School+integration--Louisiana--New+Orleans%22

civil_rights_act_1957

• _su: "United States. Civil Rights Act of 1957"
• { "dcterms_subject": ["United States. Civil Rights Act of 1957"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%United States. Civil Rights Act of 1957%")
• http://crdl.usg.edu/query:_su:%22United+States.+Civil+Rights+Act+of+1957%22

scope_project

• _su: "Summer Community Organization and Political Education (Organization)"
• { "dcterms_subject": ["Summer Community Organization and Political Education (Organization)"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Summer Community Organization and Political Education (Organization)%")
• http://crdl.usg.edu/query:_su:%22Summer+Community+Organization+and+Political+Education+%28Organization%29%22

freedom_rides

• _su: "Freedom ride*"
• { "dcterms_subject": ["Freedom ride*"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Freedom ride%")
• http://crdl.usg.edu/query:_su:%22Freedom+ride*%22

emmett_till_murder

• _sp: "Till, Emmett, 1941-1955--Assassination" or "Till, Emmett, 1941-1955--Death and burial"
• { "dlg_subject_personal": ["Till, Emmett, 1941-1955--Assassination", "Till, Emmett, 1941-1955--Death and burial"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dlg_subject_personal, '||') ILIKE :q1 OR array_to_string(dlg_subject_personal, '||') ILIKE :q2", q1: "%Till, Emmett, 1941-1955--Assassination%", q2: "%Till, Emmett, 1941-1955--Death and burial%")
• http://crdl.usg.edu/query:_su:%22Till,+Emmett,+1941-1955--Assassination%22+or+%22Till,+Emmett,+1941-1955--Death+and+burial%22

albany_movement

• _su: "Albany Movement (Albany, Ga.)*"
• { "dcterms_subject": ["Albany Movement (Albany, Ga.)*"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Albany Movement (Albany, Ga.)%")
• http://crdl.usg.edu/query:_su:%22Albany Movement %28Albany, Ga.%29*%22

mlk_nobel_prize

• _sp: "King, Martin Luther, Jr., 1929-1968" or "King, Martin Luther, Jr., 1929-1968--Awards" or _su: "Nobel Prizes"
• { "dlg_subject_personal": ["King, Martin Luther, Jr., 1929-1968", "King, Martin Luther, Jr., 1929-1968--Awards"], "dcterms_subject": ["Nobel Prizes"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dlg_subject_personal, '||') ILIKE :q1 OR array_to_string(dlg_subject_personal, '||') ILIKE :q2 OR array_to_string(dcterms_subject, '||') ILIKE :q3", q1: "%King, Martin Luther, Jr., 1929-1968%", q2: "%King, Martin Luther, Jr., 1929-1968--Awards%", q3: "%Nobel Prizes%")
• http://crdl.usg.edu/query:_sp:%22King,+Martin+Luther,+Jr.,+1929-1968%22+or+%22King,+Martin+Luther,+Jr.,+1929-1968--Awards%22+or+_su:+%22Nobel+Prizes%22

sit_ins_greensboro_nc

• _su: "Sit-ins--North Carolina--Greensboro"
• { "dcterms_subject": ["Sit-ins--North Carolina--Greensboro"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Sit-ins--North Carolina--Greensboro%")
• http://crdl.usg.edu/query:_su:%22Sit-ins--North+Carolina--Greensboro%22

sit_ins_nashville_tn

• _su: "Sit-ins--Tennessee--Nashville"
• { "dcterms_subject": ["Sit-ins--Tennessee--Nashville"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Sit-ins--Tennessee--Nashville%")
• http://crdl.usg.edu/query:_su:%22Sit-ins--Tennessee--Nashville%22

augusta_movement

• _su: "Augusta Movement (Augusta, Ga.)*"
• { "dcterms_subject": ["Augusta Movement (Augusta, Ga.)*"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Augusta Movement (Augusta, Ga.)%")
• http://crdl.usg.edu/query:_su:%22Augusta+Movement+%28Augusta,+Ga.%29*%22

sit_ins_atlanta_ga

• _su: "Sit-ins--Georgia--Atlanta"
• { "dcterms_subject": ["Sit-ins--Georgia--Atlanta"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Sit-ins--Georgia--Atlanta%")
• http://crdl.usg.edu/query:_su:%22Sit-ins--Georgia--Atlanta%22

civil_rights_act_1964

• _su: "United States. Civil Rights Act of 1964*"
• { "dcterms_subject": ["United States. Civil Rights Act of 1964*"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%United States. Civil Rights Act of 1964%")
• http://crdl.usg.edu/query:_su:%22United+States.+Civil+Rights+Act+of+1964*%22

heart_atl_pickrick_trial

• _su: "Heart of Atlanta Motel--Trials, litigation, etc." or "Pickrick (Atlanta, Ga.)"
• { "dcterms_subject": ["Heart of Atlanta Motel--Trials, litigation, etc."], ["Pickrick (Atlanta, Ga.)"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Heart of Atlanta Motel--Trials, litigation, etc.%")
• http://crdl.usg.edu/query:_su:%22Heart+of+Atlanta+Motel--Trials,+litigation,+etc.%22

sedition_trial_americus

• _su: "Trials (Sedition)--Georgia--Americus"
• { "dcterms_subject": ["Trials (Sedition)--Georgia--Americus"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Trials (Sedition)--Georgia--Americus%")
• http://crdl.usg.edu/query:_su:%22Trials+(Sedition)--Georgia--Americus%22

march_on_washington

• _su: "March on Washington for Jobs and Freedom, Washington, D.C., 1963"
• { "dcterms_subject": ["March on Washington for Jobs and Freedom, Washington, D.C., 1963"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%March on Washington for Jobs and Freedom, W ashington, D.C., 1963%")
• http://crdl.usg.edu/query:_su:%22March+on+Washington+for+Jobs+and+Freedom,+Washington,+D.C.,+1963%22

ua_integration

• _su: "University of Alabama" or "College integration--Alabama--Tuscaloosa"
• { "dcterms_subject": ["University of Alabama", "College integration--Alabama--Tuscaloosa"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%University of Alabama%")
• http://crdl.usg.edu/query:_su:%22University+of+Alabama%22

americus_movement

• _su: "Americus Movement (Americus, Ga.)*"
• { "dcterms_subject": ["Americus Movement (Americus, Ga.)*"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Americus Movement (Americus, Ga.)%")
• http://crdl.usg.edu/query:_su:%22Americus+Movement+(Americus,+Ga.)*%22

naacp_convention_atlanta

• _su: "National Association for the Advancement of Colored People. Convention (53rd : 1962 : Atlanta, Ga.)"
• { "dcterms_subject": ["National Association for the Advancement of Colored People. Convention (53rd : 1962 : Atlanta, Ga.)"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%National Association for the Advancement of Colored People. Convention (53rd : 1962 : Atlanta, Ga.)%")
• http://crdl.usg.edu/query:_su:%22National+Association+for+the+Advancement+of+Colored+People.+Convention+(53rd+:+1962+:+Atlanta,+Ga.)%22

selma_montgomery_march

• _su: "Selma-Montgomery Rights March, 1965" or "Selma to Montgomery Rights March (1965 : Selma, Ala.)"
• { "dcterms_subject": ["Selma-Montgomery Rights March, 1965", "Selma to Montgomery Rights March (1965 : Selma, Ala.)"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Selma-Montgomery Rights March, 1965%")
• http://crdl.usg.edu/query:_su:%22Selma-Montgomery+Rights+March,+1965%22

brown_vs_boe

• _su: "Brown versus Board of Education of Topeka*" or _sp: "Brown, Oliver, 1918*"
• { "dcterms_subject": ["Brown versus Board of Education of Topeka*"], "dlg_subject_personal": ["Brown, Oliver, 1918*"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Brown versus Board of Education of Topeka%" )
• http://crdl.usg.edu/query:_su:%22Brown+versus+Board+of+Education+of+Topeka*%22

ny_race_riots

• _su: "Race riots--New York (State)--New York"
• { "dcterms_subject": ["Race riots--New York (State)--New York"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Race riots--New York (State)--New York%")
• http://crdl.usg.edu/query:_su:%22Race+riots--New+York+(State)--New+York%22

montgomery_bus_boycott

• _su: "Montgomery Bus Boycott, Montgomery, Ala., 1955-1956"
• { "dcterms_subject": ["Montgomery Bus Boycott, Montgomery, Ala., 1955-1956"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Montgomery Bus Boycott, Montgomery, Ala., 1 955-1956%")
• http://crdl.usg.edu/query:_su:%22Montgomery+Bus+Boycott,+Montgomery,+Ala.,+1955-1956%22

birmingham_bombing

• _su: "Sixteenth Street Baptist Church Bombing, Birmingham, Ala., 1963*"
• { "dcterms_subject": ["Sixteenth Street Baptist Church Bombing, Birmingham, Ala., 1963*"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Sixteenth Street Baptist Church Bombing, Bi rmingham, Ala., 1963%")
• http://crdl.usg.edu/query:_su:%22Sixteenth+Street+Baptist+Church+Bombing,+Birmingham,+Ala.,+1963*%22

freedom_summer

• _su: "Mississippi Freedom Project*"
• { "dcterms_subject": ["Mississippi Freedom Project*"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Mississippi Freedom Project%")
• http://crdl.usg.edu/query:_su:%22Mississippi+Freedom+Project*%22

little_rock_integration

• _su: "Central High School (Little Rock, Ark.)" or "School integration--Arkansas--Little Rock"
• { "dcterms_subject": ["Central High School (Little Rock, Ark.)", "School integration--Arkansas--Little Rock"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Central High School (Little Rock, Ark.)%")
• http://crdl.usg.edu/query:_su:%22Central+High+School+(Little+Rock,+Ark.)%22

uga_integration

• _su: "College integration--Georgia--Athens" or "University of Georgia"
• { "dcterms_subject": ["College integration--Georgia--Athens", "University of Georgia"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1 OR array_to_string(dcterms_subject, '||') ILIKE :q2 ", q1: "%College integration--Georgia--Athens%", q2: "%University of Georgia%")
• http://crdl.usg.edu/query:_su:%22College+integration--Georgia--Athens%22+or+_su:%22University+of+Georgia%22

jfk_assassination

• _sp: "Kennedy, John F. (John Fitzgerald), 1917-1963--Assassination"
• { "dlg_subject_personal": ["Kennedy, John F. (John Fitzgerald), 1917-1963--Assassination"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dlg_subject_personal, '||') ILIKE :q1", q1: "%Kennedy, John F. (John Fitzgerald), 19 17-1963--Assassination%")
• http://crdl.usg.edu/query:_sp:%22Kennedy,+John+F.+(John+Fitzgerald),+1917-1963--Assassination%22

temple_bombing_atlanta

• _su: "Temple Bombing, Atlanta, Ga., 1958"
• { "dcterms_subject": ["Temple Bombing, Atlanta, Ga., 1958"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Temple Bombing, Atlanta, Ga., 1958%")
• http://crdl.usg.edu/query:_su:%22Temple+Bombing,+Atlanta,+Ga.,+1958%22

mlk_assassination

• _sp: "King, Martin Luther, Jr., 1929-1968--Assassination"
• { "dlg_subject_personal": ["King, Martin Luther, Jr., 1929-1968--Assassination"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dlg_subject_personal, '||') ILIKE :q1", q1: "%King, Martin Luther, Jr., 1929-1968--A ssassination%")
• http://crdl.usg.edu/query:_sp:%22King,+Martin+Luther,+Jr.,+1929-1968--Assassination%22

memphis_sanitation_strike

• _su: "Sanitation Workers Strike, Memphis, Tenn., 1968"
• { "dcterms_subject": ["Sanitation Workers Strike, Memphis, Tenn., 1968"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Sanitation Workers Strike, Memphis, Tenn., 1968%")
• http://crdl.usg.edu/query:_su:%22Sanitation+Workers+Strike,+Memphis,+Tenn.,+1968%22

poor_peoples_campaign

• _su: "Poor People's Campaign"
• { "dcterms_subject": ["Poor People's Campaign"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Poor People's Campaign%")
• http://crdl.usg.edu/query:_su:%22Poor+People's+Campaign%22

watts_riots

• _su: "Watts Riot, Los Angeles, Calif., 1965"
• { "dcterms_subject": ["Watts Riot, Los Angeles, Calif., 1965"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Watts Riot, Los Angeles, Calif., 1965%")
• http://crdl.usg.edu/query:_su:%22Watts+Riot,+Los+Angeles,+Calif.,+1965%22

ny_school_boycott

• _su: "Boycotts--New York (State)--New York" or "School integration--New York (State)--New York"
• { "dcterms_subject": ["Boycotts--New York (State)--New York", "School integration--New York (State)--New York"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1 OR array_to_string(dcterms_subject, '||') ILIKE :q2 ", q1: "%Boycotts--New York (State)--New York%", q2: "School integration--New York (State)--New York")
• http://crdl.usg.edu/query:_su:%22Boycotts--New+York+(State)--New+York%22

prayer_pilgrimage

• _su: "Prayer Pilgrimage for Freedom (1957 : Washington, D.C.)"
• { "dcterms_subject": ["Prayer Pilgrimage for Freedom (1957 : Washington, D.C.)"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Prayer Pilgrimage for Freedom (1957 : Washi ngton, D.C.)%")
• http://crdl.usg.edu/query:_su:%22Prayer+Pilgrimage+for+Freedom+(1957+:+Washington,+D.C.)%22

birmingham_demonstrations

• _su: "Project C, Birmingham, Ala., 1963"
• { "dcterms_subject": ["Project C, Birmingham, Ala., 1963"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Project C, Birmingham, Ala., 1963%")
• http://crdl.usg.edu/query:_su:%22Project+C,+Birmingham,+Ala.,+1963%22

gatech_integration

• _su: "Georgia Institute of Technology" or "College integration--Georgia--Atlanta"
• { "dcterms_subject": ["Georgia Institute of Technology", "College integration--Georgia--Atlanta"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1 OR array_to_string(dcterms_subject, '||') ILIKE :q2 ", q1: "%Georgia Institute of Technology%", q2: "%College integration--Georgia--Atlanta%")
• http://crdl.usg.edu/query:_su:%22Georgia+Institute+of+Technology%22+or+%22College+integration--Georgia--Atlanta%22

highlander_25th

• _su: "Highlander Folk School (Monteagle, Tenn.)--Anniversaries, etc."
• { "dcterms_subject": ["Highlander Folk School (Monteagle, Tenn.)--Anniversaries, etc."] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1", q1: "%Highlander Folk School (Monteagle, Tenn.)-- Anniversaries, etc.%")
• http://crdl.usg.edu/query:_su:%22Highlander+Folk+School+(Monteagle,+Tenn.)--Anniversaries,+etc.%22

ole_miss_integration

• _su: "University of Mississippi" or "College integration--Mississippi--Oxford"
• { "dcterms_subject": ["University of Mississippi", "College integration--Mississippi--Oxford"] }
• Item.joins(:portals).where("portals.code" => "crdl").where(public: true).where("array_to_string(dcterms_subject, '||') ILIKE :q1 OR array_to_string(dcterms_subject, '||') ILIKE :q2 ", q1: "%University of Mississippi%", q2: "%College integration--Mississippi--Oxford%")
• http://crdl.usg.edu/query:_su:%22University+of+Mississippi%22+or+%22College+integration--Mississippi--Oxford%22