mvhub-dev team mailing list archive

[Lee Goodrich <lgoodrich@xxxxxxxxxx>]

Lee Goodrich has proposed merging lp:~leegoodrich/mvhub/add_db_schema_script into lp:mvhub.

Requested reviews:
  MVHub devs with commit rights (mvhub-commit)


Refactored the update_db.pl file and got it working in our current 
setup. Look at commit messages for further details.
-- 
https://code.launchpad.net/~leegoodrich/mvhub/add_db_schema_script/+merge/24528
Your team MVHub Developers is subscribed to branch lp:mvhub.

=== modified file 'app-mvhub/conf/sql_select.lib'
--- app-mvhub/conf/sql_select.lib	2010-04-29 14:58:08 +0000
+++ app-mvhub/conf/sql_select.lib	2010-04-30 20:30:33 +0000
@@ -187,7 +187,18 @@
    category 
 WHERE 
    category_id = ?
-  
+
+[INFORMATION_SCHEMA_X_TABLE_EXISTS]
+SELECT 
+	1 
+FROM 
+	information_schema.tables
+WHERE
+	table_name = ?
+AND
+	schema = 'public' 
+LIMIT 1
+
 [PROGRAM_AGENCY_PROGRAM_CATEGORY_X_AGENCY_NAME_ID_PROGRAM_NAME]
 SELECT 
     a.agency_name, p.program_id, p.program_name,
@@ -248,6 +259,7 @@
   program 
 WHERE 
   program_id = ?   
+<<<<<<< TREE
 
 [SYNONYM_STEM_X_WORD_STEM]  
 SELECT DISTINCT 
@@ -265,3 +277,11 @@
       word_stem 
     IN	(?)
    )
+=======
+  
+[VERSION_LOG_X_VERSION]
+SELECT 
+	max(version)
+FROM
+	version_log
+>>>>>>> MERGE-SOURCE

=== modified file 'app-mvhub/project-tools/templates/template.conf'
--- app-mvhub/project-tools/templates/template.conf	2010-04-06 20:52:15 +0000
+++ app-mvhub/project-tools/templates/template.conf	2010-04-30 20:30:33 +0000
@@ -109,6 +109,7 @@
 reports_dir=reports/
 project_tools_dir=link-to-live-code/app-mvhub/project-tools/
 tmp_dir=tmp/
+setup_db_dir=link-to-live-code/app-mvhub/setup/database/sql/
 
 [COOKIES]
 # name of cookie used to store 

=== added file 'app-mvhub/project-tools/templates/template_version_log.sql'
--- app-mvhub/project-tools/templates/template_version_log.sql	1970-01-01 00:00:00 +0000
+++ app-mvhub/project-tools/templates/template_version_log.sql	2010-04-30 20:30:33 +0000
@@ -0,0 +1,5 @@
+BEGIN;
+INSERT INTO version_log ( note ) 
+	VALUES ('');
+
+COMMIT;

=== removed directory 'app-mvhub/setup/database/data'
=== removed file 'app-mvhub/setup/database/data/001_data_update.sql'
--- app-mvhub/setup/database/data/001_data_update.sql	2009-03-04 18:11:56 +0000
+++ app-mvhub/setup/database/data/001_data_update.sql	1970-01-01 00:00:00 +0000
@@ -1,37 +0,0 @@
-/*
-  $REVISION$
-  FILE: 001_schema_update.sql
-*/
-BEGIN;
-
-INSERT INTO meta_data_version ( version,note) 
-	VALUES (1, 'display TRUE north shore towns in table: town / add magnolia to town table');
-
-UPDATE town set display=TRUE WHERE town_state LIKE 'Peabody%';   
-UPDATE town set display=TRUE WHERE town_state LIKE 'Beverly%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Danvers%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Essex%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Gloucester%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Hamilton%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Ipswich%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Lynn%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Lynnfield%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Manchester-by-the-Sea%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Marblehead%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Middleton%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Nahant%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Newbury%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Newburyport%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'North Reading%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Peabody%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Rockport%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Rowley%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Salem%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Salisbury%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Swampscott%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Topsfield%';
-UPDATE town set display=TRUE WHERE town_state LIKE 'Wenham%';
-
-INSERT INTO town ( town_state,county,display) VALUES ('Magnolia, MA', 'Essex County',TRUE);
-
-COMMIT;
\ No newline at end of file

=== removed file 'app-mvhub/setup/database/data/00_data_and_schema.sql'
--- app-mvhub/setup/database/data/00_data_and_schema.sql	2009-03-04 21:15:20 +0000
+++ app-mvhub/setup/database/data/00_data_and_schema.sql	1970-01-01 00:00:00 +0000
@@ -1,2699 +0,0 @@
---
--- PostgreSQL database dump
---
-
-SET client_encoding = 'SQL_ASCII';
-SET check_function_bodies = false;
-SET client_min_messages = warning;
-
-SET search_path = public, pg_catalog;
-
-ALTER TABLE ONLY public.heading_category DROP CONSTRAINT "$2";
-ALTER TABLE ONLY public.program_category DROP CONSTRAINT "$2";
-ALTER TABLE ONLY public.date_program_created DROP CONSTRAINT "$1";
-ALTER TABLE ONLY public.date_agency_created DROP CONSTRAINT "$1";
-ALTER TABLE ONLY public.program_category DROP CONSTRAINT "$1";
-ALTER TABLE ONLY public.heading_category DROP CONSTRAINT "$1";
-ALTER TABLE ONLY public.alias DROP CONSTRAINT "$1";
-ALTER TABLE ONLY public.program DROP CONSTRAINT "$1";
-DROP INDEX public.start_zip_index_on_zip_distances;
-DROP INDEX public.session_id_index_on_category_search_log;
-DROP INDEX public.session_id_index_on_agency_search_log;
-DROP INDEX public.log_category_search_index_by_session_id;
-ALTER TABLE ONLY public.user_type DROP CONSTRAINT user_type_type_name_key;
-ALTER TABLE ONLY public.user_type DROP CONSTRAINT user_type_pkey;
-ALTER TABLE ONLY public.town DROP CONSTRAINT town_pkey;
-ALTER TABLE ONLY public.synonym_stem DROP CONSTRAINT synonym_pkey;
-ALTER TABLE ONLY public.search_log DROP CONSTRAINT search_log_pkey;
-ALTER TABLE ONLY public.program DROP CONSTRAINT program_pkey;
-ALTER TABLE ONLY public.program_category DROP CONSTRAINT program_category_pkey;
-ALTER TABLE ONLY public.meta_schema_version DROP CONSTRAINT meta_schema_version_version_key;
-ALTER TABLE ONLY public.meta_data_version DROP CONSTRAINT meta_data_version_version_key;
-ALTER TABLE ONLY public.log_category_search DROP CONSTRAINT log_category_search_pkey;
-ALTER TABLE ONLY public.heading DROP CONSTRAINT heading_pkey;
-ALTER TABLE ONLY public.heading_category DROP CONSTRAINT heading_category_pkey;
-ALTER TABLE ONLY public.date_program_created DROP CONSTRAINT date_program_created_pkey;
-ALTER TABLE ONLY public.date_agency_created DROP CONSTRAINT date_agency_created_pkey;
-ALTER TABLE ONLY public.category DROP CONSTRAINT category_pkey;
-ALTER TABLE ONLY public.category DROP CONSTRAINT category_category_name_key;
-ALTER TABLE ONLY public.alias DROP CONSTRAINT alias_pkey;
-ALTER TABLE ONLY public.agency DROP CONSTRAINT agency_pkey;
-ALTER TABLE ONLY public.agency DROP CONSTRAINT agency_agency_name_key;
-DROP TABLE public.zip_distances;
-DROP TABLE public.web_requests;
-DROP SEQUENCE public.web_requests_id_seq;
-DROP TABLE public.user_type;
-DROP SEQUENCE public.user_type_type_id_seq;
-DROP SEQUENCE public.user_id_sequence;
-DROP TABLE public.town;
-DROP TABLE public.synonym_stem;
-DROP SEQUENCE public.synonym_id_sequence;
-DROP SEQUENCE public.program_id_sequence;
-DROP VIEW public.opt_in_contact_email_view;
-DROP TABLE public.meta_schema_version;
-DROP TABLE public.meta_data_version;
-DROP VIEW public.mailing_list;
-DROP TABLE public.log_category_search;
-DROP SEQUENCE public.log_category_search_search_id_seq;
-DROP TABLE public.heading_category;
-DROP TABLE public.heading;
-DROP VIEW public.entity;
-DROP TABLE public.date_program_created;
-DROP TABLE public.date_agency_created;
-DROP VIEW public.contact_email_list_view;
-DROP VIEW public.contacts;
-DROP TABLE public.category_search_log;
-DROP SEQUENCE public.category_id_sequence;
-DROP VIEW public.all_names_view;
-DROP VIEW public.cats_with_visible_programs_view;
-DROP TABLE public.program_category;
-DROP TABLE public.program;
-DROP TABLE public.category;
-DROP TABLE public.alias;
-DROP TABLE public.agency_search_log;
-DROP TABLE public.search_log;
-DROP SEQUENCE public.search_log_search_id_seq;
-DROP SEQUENCE public.agency_id_sequence;
-DROP TABLE public.agency;
-DROP FUNCTION public.our_concat(text, text);
-DROP FUNCTION public.get_password(integer);
-DROP FUNCTION public.get_agency_name(integer);
-DROP SCHEMA public;
---
--- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
---
-
-CREATE SCHEMA public;
-
-
---
--- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
---
-
-COMMENT ON SCHEMA public IS 'Standard public schema';
-
-
---
--- Name: get_agency_name(integer); Type: FUNCTION; Schema: public; Owner: mdadhania
---
-
-CREATE FUNCTION get_agency_name(integer) RETURNS text
-    AS $_$select agency_name from agency where agency_id = $1;$_$
-    LANGUAGE sql STABLE STRICT;
-
-
---
--- Name: get_password(integer); Type: FUNCTION; Schema: public; Owner: mdadhania
---
-
-CREATE FUNCTION get_password(integer) RETURNS text
-    AS $_$select password from agency where agency_id = $1;$_$
-    LANGUAGE sql STABLE STRICT;
-
-
---
--- Name: our_concat(text, text); Type: FUNCTION; Schema: public; Owner: mdadhania
---
-
-CREATE FUNCTION our_concat(text, text) RETURNS text
-    AS $_$select $1 || ', ' || $2;$_$
-    LANGUAGE sql STABLE STRICT;
-
-
-SET default_tablespace = '';
-
-SET default_with_oids = false;
-
---
--- Name: agency; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE agency (
-    agency_id integer DEFAULT nextval(('agency_id_sequence'::text)::regclass) NOT NULL,
-    last_updated date NOT NULL,
-    hidden boolean DEFAULT false NOT NULL,
-    "password" text NOT NULL,
-    agency_name text NOT NULL,
-    agency_alias text,
-    address1 text NOT NULL,
-    address2 text,
-    city text NOT NULL,
-    state text NOT NULL,
-    zip text NOT NULL,
-    main_phone text NOT NULL,
-    toll_free_phone text,
-    hotline text,
-    fax text,
-    website text,
-    email text,
-    mission text,
-    hours text NOT NULL,
-    other_info text,
-    mail_address1 text,
-    mail_address2 text,
-    mail_city text,
-    mail_state text,
-    mail_zip text,
-    chief text NOT NULL,
-    title text NOT NULL,
-    parent_organization text,
-    resource_library text NOT NULL,
-    resource_library_description text,
-    meeting_space text NOT NULL,
-    meeting_space_description text,
-    staff_internet_access text NOT NULL,
-    contact_first_name text NOT NULL,
-    contact_last_name text NOT NULL,
-    contact_phone text NOT NULL,
-    contact_fax text,
-    contact_email text NOT NULL,
-    contact_email_available text NOT NULL,
-    tty_tdd text,
-    reminders_sent integer DEFAULT 0 NOT NULL,
-    admin_notes text,
-    CONSTRAINT agency_address1 CHECK ((address1 <> ''::text)),
-    CONSTRAINT agency_agency_name CHECK ((agency_name <> ''::text)),
-    CONSTRAINT agency_chief CHECK ((chief <> ''::text)),
-    CONSTRAINT agency_city CHECK ((city <> ''::text)),
-    CONSTRAINT agency_contact_email CHECK ((contact_email <> ''::text)),
-    CONSTRAINT agency_contact_email_available CHECK ((contact_email_available <> ''::text)),
-    CONSTRAINT agency_contact_first_name CHECK ((contact_first_name <> ''::text)),
-    CONSTRAINT agency_contact_last_name CHECK ((contact_last_name <> ''::text)),
-    CONSTRAINT agency_contact_phone CHECK ((contact_phone <> ''::text)),
-    CONSTRAINT agency_hours CHECK ((hours <> ''::text)),
-    CONSTRAINT agency_main_phone CHECK ((main_phone <> ''::text)),
-    CONSTRAINT agency_meeting_space CHECK ((meeting_space <> ''::text)),
-    CONSTRAINT agency_password CHECK (("password" <> ''::text)),
-    CONSTRAINT agency_resource_library CHECK ((resource_library <> ''::text)),
-    CONSTRAINT agency_staff_internet_access CHECK ((staff_internet_access <> ''::text)),
-    CONSTRAINT agency_state CHECK ((state <> ''::text)),
-    CONSTRAINT agency_title CHECK ((title <> ''::text)),
-    CONSTRAINT agency_zip CHECK ((zip <> ''::text))
-);
-
-
---
--- Name: agency_id_sequence; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE agency_id_sequence
-    INCREMENT BY 11
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: agency_id_sequence; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('agency_id_sequence', 103542, true);
-
-
---
--- Name: search_log_search_id_seq; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE search_log_search_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: search_log_search_id_seq; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('search_log_search_id_seq', 36588, true);
-
-
---
--- Name: search_log; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE search_log (
-    search_id integer DEFAULT nextval('search_log_search_id_seq'::regclass) NOT NULL,
-    session_id text,
-    ip_address text,
-    "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
-    search_phrase text,
-    referer text
-);
-
-
---
--- Name: agency_search_log; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE agency_search_log (
-    hit_count integer NOT NULL
-)
-INHERITS (search_log);
-
-
---
--- Name: alias; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE alias (
-    category_id integer NOT NULL,
-    alias_name text NOT NULL,
-    stems_name text NOT NULL,
-    CONSTRAINT alias_alias_name CHECK ((alias_name <> ''::text)),
-    CONSTRAINT alias_stems_name CHECK ((stems_name <> ''::text))
-);
-
-
---
--- Name: category; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE category (
-    category_id integer DEFAULT nextval(('category_id_sequence'::text)::regclass) NOT NULL,
-    category_name text NOT NULL,
-    stems_name text NOT NULL,
-    CONSTRAINT category_category_name CHECK ((category_name <> ''::text)),
-    CONSTRAINT category_stems_name CHECK ((stems_name <> ''::text))
-);
-
-
---
--- Name: program; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE program (
-    program_id integer DEFAULT nextval(('program_id_sequence'::text)::regclass) NOT NULL,
-    agency_id integer NOT NULL,
-    last_updated date NOT NULL,
-    hidden_reason text,
-    program_name text NOT NULL,
-    program_alias text,
-    address1 text NOT NULL,
-    address2 text,
-    city text NOT NULL,
-    state text NOT NULL,
-    zip text NOT NULL,
-    main_phone text NOT NULL,
-    toll_free_phone text,
-    hotline text,
-    fax text,
-    website text,
-    email text,
-    short_program_description text NOT NULL,
-    long_program_description text NOT NULL,
-    eligibility text NOT NULL,
-    fees_charged text NOT NULL,
-    fees_explained text,
-    program_schedule text NOT NULL,
-    hours text NOT NULL,
-    languages text NOT NULL,
-    appointment text NOT NULL,
-    bring text,
-    bus_lines text,
-    parking text,
-    transportation text,
-    handicapped_accessible text NOT NULL,
-    child_care_provided text NOT NULL,
-    child_care_description text,
-    wait_list text NOT NULL,
-    wait_list_description text,
-    other_information text,
-    mail_address1 text,
-    mail_address2 text,
-    mail_city text,
-    mail_state text,
-    mail_zip text,
-    volunteer_opportunities text NOT NULL,
-    volunteer_information text,
-    resource_library text NOT NULL,
-    resource_library_description text,
-    meeting_space text NOT NULL,
-    meeting_space_description text,
-    news_letter text NOT NULL,
-    news_letter_description text,
-    public_net_access text NOT NULL,
-    public_net_access_description text,
-    contact_first_name text NOT NULL,
-    contact_last_name text NOT NULL,
-    contact_phone text NOT NULL,
-    contact_fax text,
-    contact_email text NOT NULL,
-    contact_email_available text NOT NULL,
-    area_type text NOT NULL,
-    area_data text,
-    tty_tdd text,
-    areas_served_description text,
-    languages_description text,
-    online_registration text NOT NULL,
-    reminders_sent integer DEFAULT 0 NOT NULL,
-    admin_notes text,
-    CONSTRAINT area_check CHECK ((((area_data IS NOT NULL) AND (area_data <> ''::text)) OR (area_type = 'EVERYWHERE'::text))),
-    CONSTRAINT program_address1 CHECK ((address1 <> ''::text)),
-    CONSTRAINT program_appointment CHECK ((appointment <> ''::text)),
-    CONSTRAINT program_area_type CHECK ((area_type <> ''::text)),
-    CONSTRAINT program_child_care_provided CHECK ((child_care_provided <> ''::text)),
-    CONSTRAINT program_city CHECK ((city <> ''::text)),
-    CONSTRAINT program_contact_email CHECK ((contact_email <> ''::text)),
-    CONSTRAINT program_contact_email_available CHECK ((contact_email_available <> ''::text)),
-    CONSTRAINT program_contact_first_name CHECK ((public_net_access_description <> ''::text)),
-    CONSTRAINT program_contact_last_name CHECK ((contact_last_name <> ''::text)),
-    CONSTRAINT program_contact_phone CHECK ((contact_phone <> ''::text)),
-    CONSTRAINT program_eligibility CHECK ((eligibility <> ''::text)),
-    CONSTRAINT program_fees_charged CHECK ((fees_charged <> ''::text)),
-    CONSTRAINT program_handicapped_accessible CHECK ((handicapped_accessible <> ''::text)),
-    CONSTRAINT program_hours CHECK ((hours <> ''::text)),
-    CONSTRAINT program_languages CHECK ((languages <> ''::text)),
-    CONSTRAINT program_long_program_description CHECK ((long_program_description <> ''::text)),
-    CONSTRAINT program_main_phone CHECK ((main_phone <> ''::text)),
-    CONSTRAINT program_meeting_space CHECK ((meeting_space <> ''::text)),
-    CONSTRAINT program_news_letter CHECK ((news_letter <> ''::text)),
-    CONSTRAINT program_online_registration CHECK ((online_registration <> ''::text)),
-    CONSTRAINT program_program_name CHECK ((program_name <> 'program_name'::text)),
-    CONSTRAINT program_program_schedule CHECK ((program_schedule <> ''::text)),
-    CONSTRAINT program_public_net_access CHECK ((public_net_access <> ''::text)),
-    CONSTRAINT program_resource_library CHECK ((resource_library <> ''::text)),
-    CONSTRAINT program_short_program_description CHECK ((short_program_description <> ''::text)),
-    CONSTRAINT program_state CHECK ((state <> ''::text)),
-    CONSTRAINT program_volunteer_opportunities CHECK ((volunteer_opportunities <> ''::text)),
-    CONSTRAINT program_wait_list CHECK ((wait_list <> ''::text)),
-    CONSTRAINT program_zip CHECK ((zip <> ''::text))
-);
-
-
---
--- Name: program_category; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE program_category (
-    category_id integer NOT NULL,
-    program_id integer NOT NULL
-);
-
-
---
--- Name: cats_with_visible_programs_view; Type: VIEW; Schema: public; Owner: mdadhania
---
-
-CREATE VIEW cats_with_visible_programs_view AS
-    SELECT pc.category_id, c.category_name, count(pc.program_id) AS program_count FROM program_category pc, program p, category c WHERE (((pc.program_id = p.program_id) AND (pc.category_id = c.category_id)) AND (p.hidden_reason IS NULL)) GROUP BY pc.category_id, c.category_name;
-
-
---
--- Name: all_names_view; Type: VIEW; Schema: public; Owner: mdadhania
---
-
-CREATE VIEW all_names_view AS
-    SELECT all_names.category_id, all_names.name, all_names.stems_name, all_names.category_name FROM (SELECT category.category_id, lower(category.category_name) AS name, category.stems_name, category.category_name FROM category UNION SELECT a.category_id, lower(a.alias_name) AS name, a.stems_name, c.category_name FROM alias a, category c WHERE (a.category_id = c.category_id)) all_names WHERE (all_names.category_id IN (SELECT cats_with_visible_programs_view.category_id FROM cats_with_visible_programs_view));
-
-
---
--- Name: category_id_sequence; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE category_id_sequence
-    INCREMENT BY 11
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: category_id_sequence; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('category_id_sequence', 805038, true);
-
-
---
--- Name: category_search_log; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE category_search_log (
-    phrase_stems text NOT NULL,
-    top_score numeric(4,2) NOT NULL,
-    CONSTRAINT category_search_log_phrase_stems CHECK ((phrase_stems <> ''::text))
-)
-INHERITS (search_log);
-
-
---
--- Name: contacts; Type: VIEW; Schema: public; Owner: mdadhania
---
-
-CREATE VIEW contacts AS
-    SELECT agency.contact_first_name, agency.contact_last_name, agency.address1, agency.address2, agency.city, agency.state, agency.zip, agency.mail_address1, agency.mail_address2, agency.mail_city, agency.mail_state, agency.mail_zip, agency.contact_email, agency.contact_phone, agency.contact_fax, agency.agency_id FROM agency UNION SELECT program.contact_first_name, program.contact_last_name, program.address1, program.address2, program.city, program.state, program.zip, program.mail_address1, program.mail_address2, program.mail_city, program.mail_state, program.mail_zip, program.contact_email, program.contact_phone, program.contact_fax, program.agency_id FROM program;
-
-
---
--- Name: contact_email_list_view; Type: VIEW; Schema: public; Owner: mdadhania
---
-
-CREATE VIEW contact_email_list_view AS
-    SELECT DISTINCT ((((contacts.agency_id)::text || ' <'::text) || lower(contacts.contact_email)) || '>'::text) AS verbose_email FROM contacts WHERE ((contacts.contact_email !~* '(unknown|noemail)'::text) AND (contacts.contact_last_name !~* 'contact'::text)) ORDER BY ((((contacts.agency_id)::text || ' <'::text) || lower(contacts.contact_email)) || '>'::text);
-
-
---
--- Name: date_agency_created; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE date_agency_created (
-    agency_id integer NOT NULL,
-    date_created date NOT NULL
-);
-
-
---
--- Name: date_program_created; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE date_program_created (
-    program_id integer NOT NULL,
-    date_created date NOT NULL
-);
-
-
---
--- Name: entity; Type: VIEW; Schema: public; Owner: mdadhania
---
-
-CREATE VIEW entity AS
-    SELECT agency.agency_id AS id, agency.contact_email AS email FROM agency UNION SELECT program.program_id AS id, program.contact_email AS email FROM program;
-
-
---
--- Name: heading; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE heading (
-    heading_name text NOT NULL
-);
-
-
---
--- Name: heading_category; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE heading_category (
-    category_id integer NOT NULL,
-    heading_name text NOT NULL
-);
-
-
---
--- Name: log_category_search_search_id_seq; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE log_category_search_search_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: log_category_search_search_id_seq; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('log_category_search_search_id_seq', 1762, true);
-
-
---
--- Name: log_category_search; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE log_category_search (
-    search_id integer DEFAULT nextval('log_category_search_search_id_seq'::regclass) NOT NULL,
-    session_id text,
-    ip_address text,
-    "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
-    phrase_stems text NOT NULL,
-    top_score numeric(4,2) NOT NULL,
-    search_phrase text,
-    CONSTRAINT log_category_search_phrase_stems CHECK ((phrase_stems <> ''::text))
-);
-
-
---
--- Name: mailing_list; Type: VIEW; Schema: public; Owner: mdadhania
---
-
-CREATE VIEW mailing_list AS
-    SELECT ((c.contact_first_name || ' '::text) || c.contact_last_name) AS name, a.agency_name, CASE WHEN (c.mail_address1 IS NOT NULL) THEN c.mail_address1 ELSE c.address1 END AS address1, CASE WHEN (c.mail_address1 IS NOT NULL) THEN c.mail_address2 ELSE c.address2 END AS address2, CASE WHEN (c.mail_address1 IS NOT NULL) THEN c.mail_city ELSE c.city END AS city, CASE WHEN (c.mail_address1 IS NOT NULL) THEN c.mail_state ELSE c.state END AS state, CASE WHEN (c.mail_address1 IS NOT NULL) THEN c.mail_zip ELSE c.zip END AS zip FROM contacts c, agency a WHERE (c.agency_id = a.agency_id) ORDER BY ((c.contact_first_name || ' '::text) || c.contact_last_name);
-
-
---
--- Name: meta_data_version; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE meta_data_version (
-    version integer NOT NULL,
-    change_date date DEFAULT now() NOT NULL,
-    note text NOT NULL
-);
-
-
---
--- Name: TABLE meta_data_version; Type: COMMENT; Schema: public; Owner: mdadhania
---
-
-COMMENT ON TABLE meta_data_version IS 'track version of meta data like towns , categories, synonyms';
-
-
---
--- Name: meta_schema_version; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE meta_schema_version (
-    version integer NOT NULL,
-    change_date date DEFAULT now() NOT NULL,
-    note text NOT NULL
-);
-
-
---
--- Name: TABLE meta_schema_version; Type: COMMENT; Schema: public; Owner: mdadhania
---
-
-COMMENT ON TABLE meta_schema_version IS 'track version of tables/indexes setup';
-
-
---
--- Name: opt_in_contact_email_view; Type: VIEW; Schema: public; Owner: mdadhania
---
-
-CREATE VIEW opt_in_contact_email_view AS
-    SELECT condensed_contacts_favoring_no_answers.contact_email FROM (SELECT DISTINCT ON (all_contacts.contact_email) all_contacts.contact_email, all_contacts.contact_email_available FROM (SELECT agency.contact_email, agency.contact_email_available FROM agency UNION SELECT program.contact_email, program.contact_email_available FROM program) all_contacts WHERE (all_contacts.contact_email !~* '(unknown|noemail)'::text) ORDER BY all_contacts.contact_email, all_contacts.contact_email_available) condensed_contacts_favoring_no_answers WHERE (condensed_contacts_favoring_no_answers.contact_email_available = 'Yes'::text);
-
-
---
--- Name: program_id_sequence; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE program_id_sequence
-    INCREMENT BY 11
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: program_id_sequence; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('program_id_sequence', 509559, true);
-
-
---
--- Name: synonym_id_sequence; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE synonym_id_sequence
-    INCREMENT BY 11
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: synonym_id_sequence; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('synonym_id_sequence', 900319, true);
-
-
---
--- Name: synonym_stem; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE synonym_stem (
-    synonym_id integer NOT NULL,
-    word_stem text NOT NULL,
-    submitted_word text NOT NULL,
-    CONSTRAINT synonym_stem_submitted_word CHECK ((submitted_word <> ''::text)),
-    CONSTRAINT synonym_stem_word_stem CHECK ((word_stem <> ''::text))
-);
-
-
---
--- Name: town; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE town (
-    town_state text NOT NULL,
-    county text NOT NULL,
-    region text,
-    display boolean DEFAULT false,
-    CONSTRAINT town_county CHECK ((county <> ''::text)),
-    CONSTRAINT town_region CHECK ((region <> ''::text)),
-    CONSTRAINT town_town_state CHECK ((town_state <> ''::text))
-);
-
-
---
--- Name: user_id_sequence; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE user_id_sequence
-    INCREMENT BY 11
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: user_id_sequence; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('user_id_sequence', 300055, true);
-
-
---
--- Name: user_type_type_id_seq; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE user_type_type_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: user_type_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('user_type_type_id_seq', 1, false);
-
-
---
--- Name: user_type; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE user_type (
-    type_id integer DEFAULT nextval('user_type_type_id_seq'::regclass) NOT NULL,
-    type_name text NOT NULL,
-    CONSTRAINT user_type_type_name CHECK ((type_name <> ''::text))
-);
-
-
---
--- Name: web_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: mdadhania
---
-
-CREATE SEQUENCE web_requests_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Name: web_requests_id_seq; Type: SEQUENCE SET; Schema: public; Owner: mdadhania
---
-
-SELECT pg_catalog.setval('web_requests_id_seq', 749579, true);
-
-
---
--- Name: web_requests; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE web_requests (
-    id integer DEFAULT nextval('web_requests_id_seq'::regclass) NOT NULL,
-    host text NOT NULL,
-    username text,
-    date timestamp without time zone NOT NULL,
-    rtype text NOT NULL,
-    file text NOT NULL,
-    proto text NOT NULL,
-    code integer NOT NULL,
-    bytes integer NOT NULL,
-    refer text NOT NULL,
-    agent text NOT NULL
-);
-
-
---
--- Name: zip_distances; Type: TABLE; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE TABLE zip_distances (
-    start_zip character varying(5) NOT NULL,
-    end_zip character varying(5) NOT NULL,
-    distance numeric(6,2) NOT NULL,
-    CONSTRAINT zip_distances_end_zip CHECK (((end_zip)::text <> ''::text)),
-    CONSTRAINT zip_distances_start_zip CHECK (((start_zip)::text <> ''::text))
-);
-
-
---
--- Data for Name: agency; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO agency (agency_id, last_updated, hidden, "password", agency_name, agency_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, mission, hours, other_info, mail_address1, mail_address2, mail_city, mail_state, mail_zip, chief, title, parent_organization, resource_library, resource_library_description, meeting_space, meeting_space_description, staff_internet_access, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, tty_tdd, reminders_sent, admin_notes) VALUES (103520, '2009-02-11', false, 'nscap98', 'North Shore Community Action Programs, Inc.', 'NSCAP', '98 Main St.', NULL, 'Peabody', 'MA', '01960', '978-531-0767', NULL, NULL, '978-531-1012', 'www.nscap.org', 'info@xxxxxxxxx', 'North Shore Community Action Programs, Inc. is the designated anti-poverty agency for the communities of Salem, Peabody, Beverly and Danvers. In addition, we serve 25 cities and towns on the North Shore. Established in 1965 under the Economic Opportunity Act, NSCAP’s mission is to help low-income people empower themselves as they move towards self-sufficiency and to motivate the larger community to be more responsive to the needs of low-income people.', 'Monday through Friday 9:00 to 5:00', NULL, NULL, NULL, NULL, NULL, NULL, 'Elizabeth Hogan', 'Executive Director', NULL, 'Not Applicable', NULL, 'No', NULL, 'Yes', 'Chester', 'Chester', '978-934-4350', '978-531-1012', 'chester@xxxxxxxxxxxxxx', 'Yes', NULL, 0, NULL);
-INSERT INTO agency (agency_id, last_updated, hidden, "password", agency_name, agency_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, mission, hours, other_info, mail_address1, mail_address2, mail_city, mail_state, mail_zip, chief, title, parent_organization, resource_library, resource_library_description, meeting_space, meeting_space_description, staff_internet_access, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, tty_tdd, reminders_sent, admin_notes) VALUES (103531, '2009-02-26', false, 'BOOTSTRAP', 'Operation Bootstrap', NULL, '156 Broad Street', NULL, 'Lynn, Ma.', 'MA', '01905', '781-599-8543', NULL, NULL, NULL, 'www.operationbootstrap-lynn.org', NULL, 'Our mission is to address the educational needs of adults in the Greater Lynn area by providing high quality services.', 'Monday thru Thursday 8:00 am - 8:00 pm
-Friday 8:00 am - 12:00 pm', NULL, NULL, NULL, NULL, NULL, NULL, 'Don Philips Edwards', 'Executive Director', NULL, 'Yes', 'Our resource library consists of materials to support the learning process for ESL, ABE, Citizenship and Literacy students.', 'Not Applicable', NULL, 'Yes', 'Chester', 'Chester', '978-934-4350', NULL, 'chester@xxxxxxxxxxxxxx', 'Yes', NULL, 0, NULL);
-INSERT INTO agency (agency_id, last_updated, hidden, "password", agency_name, agency_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, mission, hours, other_info, mail_address1, mail_address2, mail_city, mail_state, mail_zip, chief, title, parent_organization, resource_library, resource_library_description, meeting_space, meeting_space_description, staff_internet_access, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, tty_tdd, reminders_sent, admin_notes) VALUES (103542, '2009-03-03', false, 'password', 'The Children''s Law Center of Massachusetts', NULL, '298 Union Street', NULL, 'Lynn', 'MA', '01901', '781-581-1977', NULL, NULL, NULL, 'www.clcm.org', NULL, 'The mission of the Children''s Law Center of Massachusetts is to promote and secure equal justice and to maximize opportunity for low income children and youth by providing quality advocacy and legal services.', 'Monday to Friday
-9am to 5pm', NULL, NULL, NULL, NULL, NULL, NULL, 'Jay McManus', 'Executive Director', NULL, 'No', NULL, 'No', NULL, 'No', 'Chester', 'Chester', '978-934-4350', NULL, 'chester@xxxxxxxxxxxxxx', 'No', NULL, 0, NULL);
-
-
---
--- Data for Name: agency_search_log; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36542, '66.80.237.78.18111109', '66.80.237.78', '2009-02-11 18:44:47.258492', 'nscap', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl?rm=browse_headings', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36544, '66.80.237.78.10121109', '66.80.237.78', '2009-02-12 10:08:06.583349', 'nscap', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36546, '74.10.197.220.9141109', '74.10.197.220', '2009-02-14 09:29:12.757537', 'North shore community action program', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl?rm=browse_headings', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36558, '66.92.77.160.6261109', '66.92.77.160', '2009-02-26 06:02:07.529782', 'nscap', 'http://northshoreport.org/', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36561, '75.144.137.57.8261109', '75.144.137.57', '2009-02-26 08:50:01.602167', 'nscap', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl?rm=show_program&program_id=509526&search_phrase=shelter', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36567, '75.144.137.57.9261109', '75.144.137.57', '2009-02-26 09:04:30.480871', 'north', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36570, '155.212.138.182.11261109', '155.212.138.182', '2009-02-26 11:29:38.263896', 'my turn', 'http://northshoreport.org/', 0);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36576, '64.206.127.11.11271109', '64.206.127.11', '2009-02-27 11:49:22.29741', 'children', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36577, '66.92.77.160.19271109', '66.92.77.160', '2009-02-27 19:33:13.606274', 'law', 'http://northshoreport.org/', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36581, '205.188.116.10.15281109', '205.188.116.10', '2009-02-28 15:17:13.577537', 'My turn', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 0);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36582, '205.188.116.10.15281109', '205.188.116.10', '2009-02-28 15:17:20.482974', 'Girls Inc', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 0);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36586, '209.235.0.249.1132109', '209.235.0.249', '2009-03-03 11:18:58.649736', 'children', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 1);
-INSERT INTO agency_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, hit_count) VALUES (36588, '205.237.102.178.1632109', '205.237.102.178', '2009-03-03 16:22:03.87067', 'Catholic Charities North', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 0);
-
-
---
--- Data for Name: alias; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800000, 'History', 'histori');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800121, 'Code Violations', 'code violat');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800132, 'Trash', 'trash');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800132, 'Sanitation Inspection', 'sanit inspect');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800198, 'Volunteering', 'volunt');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800286, 'Neighborhood Organizations', 'organ neighborhood');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800297, 'Community Access', 'access commun');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800297, 'Public Access', 'access public');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800308, 'Computer, Open Access', 'open access comput');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800396, 'Counseling Bereavement, Counseling Grief', 'counsel bereav grief');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800407, 'Support Group, Death', 'death group support');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800473, 'Couples Counseling', 'counsel coupl');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800539, 'Hotlines, Battered Woman', 'hotlin batter woman');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800539, 'Crisis Lines, Domestic Violence', 'crisi domest line violenc');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800539, 'Crisis Lines Battered Woman', 'crisi batter woman line');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800561, 'Hotlines, Battered', 'hotlin batter');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800561, 'Crisis Lines, Child Abuse', 'crisi child abus line');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800561, 'Crisis Lines, Battered Children', 'children crisi batter line');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800594, 'Advocacy, Battered Women', 'advocaci batter women');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800605, 'Counseling, Battered Children', 'counsel children batter');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800616, 'Battered Women', 'batter women');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800616, 'Domestic Violence', 'domest violenc');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800627, 'Counseling, Battered Women', 'counsel batter women');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800638, 'Hotlines, Sexual Assault', 'hotlin sexual assault');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800638, 'Crisis Lines Rape', 'crisi rape line');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800638, 'Crisis Lines Sexual Assault', 'crisi sexual assault line');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800649, 'Abuse, Elderly', 'elderli abus');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800660, 'Domestic Violence', 'domest violenc');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800671, 'Advocacy, Battered Children', 'children advocaci batter');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800693, 'Battered Children Prevention', 'prevent children batter');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800715, 'Information and Referral, Battered Children', 'children inform batter and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800726, 'Information and Referral, Sexual Assault', 'inform sexual and assault referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800759, 'Information and Referral, Battered Woman', 'inform batter and referr woman');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800770, 'Counseling Sexual Assault', 'counsel sexual assault');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800792, 'Victims'' Advocacy Rape', 'advocaci rape victim');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800792, 'Victims'' Advocacy Sexual Assault', 'advocaci sexual assault victim');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800803, 'Sexual Assault', 'sexual assault');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800517, 'Support Group Rape', 'group rape support');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800869, 'Advocacy Mental Illness', 'ill advocaci mental');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800880, 'Halfway House, Disabled', 'disabl halfwai hous');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800935, 'ADD', 'add');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800979, 'Blind', 'blind');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801023, 'Screen Reader/Magnification Software', 'softwar reader screen magnif');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801034, 'SSI', 'ssi');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801034, 'SSDI', 'ssdi');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801056, 'Deaf', 'deaf');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801067, 'Special Education', 'special educ');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801078, 'Developmental Disability', 'development disabl');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801078, 'Mental Disability', 'mental disabl');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801111, 'Adaptive Aids/Equipment', 'equip aid adapt');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801188, 'Education Grade School', 'grade educ school');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801210, 'Skipping School', 'school skip');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801210, 'Playing Hooky', 'hooki plai');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801243, 'English As a Second Language', 'languag english a second');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801243, 'English for Speakers of Other Foreign Languages', 'english languag speaker foreign other');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801254, 'Advocacy, Special Education', 'special educ advocaci');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801265, 'Tutoring Junior High School', 'school junior high tutor');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801342, 'Homework Assistance Junior High School', 'homework school junior assist high');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801386, 'Education, Junior High School', 'educ school junior high');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800913, 'Special Education', 'special educ');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801485, 'Tutoring Grade School', 'grade school tutor');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801529, 'Homework Assistance Grade School', 'grade homework school assist');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801540, 'Information and Referral, Special Education', 'special inform educ and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801551, 'Hotlines, Special Education', 'special educ hotlin');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801584, 'ABE', 'abe');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801672, 'FMLA', 'fmla');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801694, 'Employment Discrimination Assistance', 'assist discrimin employ');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801749, 'Unemployment Disputes', 'disput unemploy');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801749, 'Unemployment Rights', 'right unemploy');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801749, 'Legal Assistance, Unemployment', 'legal unemploy assist');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801771, 'Job Search Support Groups', 'search group job support');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801826, 'Job Prep and Readiness Training', 'train readi and prep job');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801837, 'Business Training', 'train busi');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801892, 'Advocacy, Debt', 'debt advocaci');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801903, 'Tax Assistance', 'assist tax');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801903, 'VITA', 'vita');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801914, 'Information and Referral, Paying for College', 'inform colleg pai and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801925, 'Debt Management', 'debt manag');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801925, 'Cleaning Up Credit', 'up credit clean');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801947, 'Hotlines, Debt', 'debt hotlin');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801958, 'Financial Advisor', 'advisor financi');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801969, 'Budgeting', 'budget');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801980, 'Information and Referral, Debt', 'inform debt and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801991, 'Paying for College', 'colleg pai');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802002, 'Homeless, Families', 'homeless famili');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802035, 'Food Program', 'food program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802035, 'Woman Infants and Children', 'infant children and woman');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802046, 'Homeless, Women', 'homeless women');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802079, 'Advocacy, TANF', 'advocaci tanf');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802079, 'Advocacy, Welfare', 'advocaci welfar');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802090, 'Homeless, Men', 'men homeless');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802123, 'Information and Referral Food Stamps', 'inform food and referr stamp');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802134, 'Information and Referral Homeless', 'inform homeless and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802156, 'Furniture', 'furnitur');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802178, 'TANF', 'tanf');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802178, 'Welfare', 'welfar');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802189, 'Hotlines Homeless', 'homeless hotlin');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802222, 'Phone Assistance', 'assist phone');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802233, 'Information and Referral, TANF', 'inform and referr tanf');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802233, 'Information and Referral AFDC', 'inform and referr afdc');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802255, 'Advocacy Shelter', 'advocaci shelter');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802288, 'Disability Insurance', 'insur disabl');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802299, 'Eating Healthy', 'eat healthi');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802343, 'Weight Control', 'weight control');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802343, 'Weight loss', 'weight loss');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802343, 'Over Weight', 'weight over');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802343, 'Diet', 'diet');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802343, 'Lose Weight', 'weight lose');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802376, 'Hotlines, Free Medical Care', 'free hotlin care medic');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802453, 'Information and Referral, Free Medical Care', 'free inform care and medic referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802508, 'Nursing', 'nurs');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802519, 'Shots', 'shot');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802574, 'Health Care, Pediatric', 'care health pediatr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802640, 'Sexually Transmitted Diseases', 'diseas transmit sexual');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802662, 'Nurses Assistant', 'assist nurs');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802717, 'Birth Control', 'birth control');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802750, 'Giving Blood', 'blood give');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802805, 'Dentist', 'dentist');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802849, 'Find Doctor', 'doctor find');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802915, 'Hotlines, Homeless', 'homeless hotlin');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802981, 'Rental Assistance', 'rental assist');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803069, 'Information and Referral, Homeless', 'inform homeless and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803080, 'Homeless Shelter', 'homeless shelter');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803102, 'Get the Lead Out', 'lead out get');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803113, 'Advocacy, Homeless', 'homeless advocaci');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803124, 'Hotlines, Refugees', 'refuge hotlin');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803179, 'Advocacy, Refugees', 'refuge advocaci');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803201, 'Refugee Rights', 'refuge right');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803245, 'Information and Referral Refugees', 'refuge inform and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803256, 'Legal Assistance, Refugees', 'refuge legal assist');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803300, 'Hotlines, Law', 'hotlin law');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803300, 'Hotlines, Lawyer', 'hotlin lawyer');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803311, 'Consumer Protection, Consumer Advocacy', 'advocaci protect consum');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803311, 'Consumer Complaints', 'complaint consum');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803344, 'Lawyer Criminal', 'crimin lawyer');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803366, 'Legal Assistance, Lawyer', 'legal lawyer assist');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803388, 'Lawyer, Civil', 'civil lawyer');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803399, 'Hotlines, Consumer Protection', 'hotlin protect consum');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803399, 'Hotlines, Consumer Advocacy', 'advocaci hotlin consum');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803399, 'Hotlines Consumer Complaints', 'hotlin complaint consum');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803487, 'Bipolar', 'bipolar');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803487, 'Depressed', 'depress');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801034, 'SSI, SSDI', 'ssi ssdi');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804026, 'Sports/Recreation, Junior High School', 'recreat school junior sport high');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804081, 'Sports/Recreation, Grade School', 'recreat grade school sport');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804103, 'Little League', 'littl leagu');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804169, 'Pop Warner', 'warner pop');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804191, 'Residential Program, Drug Addiction', 'drug addict program residenti');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804202, 'Support Group, Drug Addiction', 'group drug addict support');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804235, 'Counseling, Drug Addiction', 'counsel drug addict');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804279, 'Recovery, Drug Addiction', 'drug addict recoveri');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804279, 'Drug Rehabilitation', 'drug rehabilit');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804301, 'Prevention Program, Drug Addiction', 'prevent drug addict program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804312, 'Hotlines, Drug Addiction', 'hotlin drug addict');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804356, 'Halfway House, Drug Addiction', 'halfwai drug addict hous');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804378, 'Advocacy, Drug Addiction', 'advocaci drug addict');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804389, 'Information and Referral, Drug Addiction', 'inform drug and addict referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804444, 'Advocacy, Teen', 'advocaci teen');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804444, 'Advocacy Infant/Toddler', 'toddler infant advocaci');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800693, 'Domestic Violence Prevention', 'prevent domest violenc');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804477, 'Prevention Programs Junior High School', 'prevent school junior high program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804521, 'Companion Programs Youth', 'youth program companion');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804554, 'Hotlines, Teen', 'hotlin teen');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804554, 'Hotlines Infant/Toddler', 'toddler infant hotlin');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804587, 'Homework Assistance Junior High School', 'homework school junior assist high');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804609, 'Companion Programs Teen', 'teen program companion');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804620, 'After School Programs, Grade School', 'grade school after program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804631, 'Information and Referral, Teen', 'inform teen and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804631, 'Information and Referral Infant/Toddler', 'toddler inform infant and referr');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804708, 'Prevention Programs Grade School', 'prevent grade school program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804741, 'Day Care, 0 - 05', 'care dai');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804719, 'Day Care, 05 - 12', 'care dai');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804532, 'Youth Camp', 'camp youth');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804686, 'Teen Camp', 'camp teen');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804686, 'Youth Camp', 'camp youth');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804598, 'Teen Camp', 'camp teen');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804598, 'Youth Camp', 'camp youth');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804466, 'After School Programs Teen', 'teen school after program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804466, 'After School Programs Youth', 'youth school after program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804587, 'After School Programs Teen', 'teen school after program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804587, 'After School Programs Youth', 'youth school after program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804620, 'After School Programs Youth', 'youth school after program');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804796, 'Painting Classes, Youth/Teen', 'youth class paint teen');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804796, 'Drawing Classes, Youth/Teen', 'youth class teen draw');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804796, 'Video Classes, Youth/Teen', 'youth class teen video');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804796, 'Graphic Design Classes, Youth/Teen', 'youth class teen graphic design');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804807, 'Acting Classes, Youth/Teen', 'youth class teen act');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804807, 'Theater Classes, Youth/Teen', 'youth class teen theatre');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804026, 'Youth Sports', 'youth sport');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804026, 'Teen Sports', 'teen sport');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804081, 'Youth Sports', 'youth sport');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804092, 'Youth Sports', 'youth sport');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804092, 'Teen Sports', 'teen sport');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804851, 'Painting Drawing Video Graphic Design Classes, Adult', 'paint graphic draw design video adult class');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804807, 'Dance Classes, Youth/Teen', 'youth class teen danc');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804862, 'Acting Theater Dance Classes, Adult', 'class danc act adult theater');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804884, 'Discount Health Care', 'care health discout');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804884, 'Sliding Scale Health Care', 'scale care health slide');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802519, 'Vaccinations', 'vaccin');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804917, 'Affordable Housing Elderly', 'elderli hous afford');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802222, 'Bills', 'bill');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804939, 'Meals', 'meal');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804939, 'Food', 'food');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804950, 'Going back to school', 'back school go');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804961, 'Financial Education', 'educ financi');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804961, 'Banking', 'bank');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804961, 'Credit', 'credit');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804532, 'Summer', 'summer');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804598, 'Summer', 'summer');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804686, 'Summer', 'summer');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (805005, 'Bulimia', 'bulimia');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (805005, 'Anorexia', 'anorexia');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802244, 'Soup Kitchen', 'kitchen soup');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (805027, 'Karate', 'karat');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (805027, 'Tae Kwon Do', 'do kwon tae');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (805027, 'Taekwon Do', 'do taekwon');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (805027, 'Taekwondo', 'taekwondo');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801221, 'Childcare Training', 'childcar train');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (801408, 'Home Based Childcare Certification', 'childcar certif home base');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804774, 'Information and Referral, Childcare', 'childcar referr inform and');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804774, 'Information and Referral, Day Care', 'referr inform dai and care');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804653, 'Childcare Vouchers', 'childcar voucher');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804763, 'Home Based Childcare 0 - 05', 'childcar   home base 0 05');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804763, 'Home Based Day Care 0 - 05', '  home base dai care 0 05');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804752, 'Home Based Childcare 05 - 12', 'childcar  home base  05 12');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (804752, 'Home Based Day Care 05 - 12', ' home base dai  care 05 12');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (803707, 'DSS', 'dss');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800550, 'Battered Children', 'children batter');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (800550, 'DSS', 'dss');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (805038, 'Discount Drugs', 'drug discount');
-INSERT INTO alias (category_id, alias_name, stems_name) VALUES (802211, 'SNAP', 'snap');
-
-
---
--- Data for Name: category; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800000, 'Cultural Heritage', 'cultur heritag');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800022, 'Music', 'music');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800033, 'Arts/Entertainment', 'entertain art');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800044, 'Theater/Performance Art', 'art perform theater');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800055, 'Museum', 'museum');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800066, 'Arts, Youth', 'youth art');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800077, 'Culture', 'cultur');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800088, 'Information and Referral, City Services', 'servic inform citi and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800099, 'Hotlines, City Services', 'servic hotlin citi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800110, 'Waste Management', 'wast manag');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800121, 'Code Enforcement', 'enforc code');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800132, 'Sanitation', 'sanit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800143, 'Voter Registration', 'registr voter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800154, 'Public Transportation', 'public transport');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800165, 'Recycling', 'recycl');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800176, 'City Services', 'servic citi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800187, 'Elections / Campaign', 'campaign elect');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800198, 'Community Service', 'servic commun');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800209, 'Crime Watch', 'watch crime');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800220, 'Library', 'librari');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800231, 'Newspapers', 'newspap');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800242, 'Media', 'media');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800253, 'Community Gardens', 'garden commun');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800264, 'Bookmobile', 'bookmobil');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800275, 'Book Club', 'club book');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800286, 'Neighborhood Groups', 'group neighborhood');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800297, 'Television/Radio', 'radio televis');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800308, 'Computer, Public Access', 'access public comput');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800319, 'Counseling, Suicide', 'counsel suicid');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800330, 'Counseling, Teen', 'counsel teen');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800341, 'Suicide Hotline', 'hotlin suicid');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800352, 'Counseling, Crisis', 'counsel crisi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800363, 'Hotlines, Counseling', 'counsel hotlin');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800374, 'Support Group, Mental Health', 'group health mental support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800385, 'Support Group, Medical', 'group medic support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800396, 'Counseling, Death', 'counsel death');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800407, 'Support Group, Bereavement', 'group bereav support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800418, 'Counseling, Mental Health', 'counsel health mental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800429, 'Information and Referral, Counseling', 'counsel inform and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800440, 'Counseling, Child', 'counsel child');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800451, 'Counseling, Sexual Assault', 'counsel sexual assault');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800462, 'Counseling, Health', 'counsel health');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800473, 'Marital Counseling', 'counsel marit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800484, 'Pastoral Care', 'care pastor');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800495, 'Support Group, Other', 'group other support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800517, 'Support Group, Sexual Assault', 'group sexual assault support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800528, 'Counseling, Family', 'counsel famili');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800539, 'Hotlines, Domestic Violence', 'hotlin domest violenc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800561, 'Hotlines, Child Abuse', 'hotlin child abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800572, 'Incest', 'incest');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800583, 'Safe House', 'safe hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800594, 'Advocacy, Domestic Violence', 'advocaci domest violenc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800605, 'Counseling, Child Abuse', 'counsel child abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800616, 'Abuse, Domestic', 'domest abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800627, 'Counseling, Domestic Violence', 'counsel domest violenc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800638, 'Hotlines, Rape', 'hotlin rape');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800649, 'Abuse, Elder', 'elder abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800660, 'Crisis Intervention, Abuse', 'intervent crisi abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800671, 'Advocacy, Child Abuse', 'advocaci child abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800682, 'Adult Protective Services', 'protect servic adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800693, 'Child Abuse Prevention', 'prevent child abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800704, 'Abuse, Sexual', 'sexual abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800715, 'Information and Referral, Child Abuse', 'inform and child referr abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800726, 'Information and Referral, Rape', 'inform rape and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800737, 'Family Violence', 'famili violenc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800748, 'Domestic Violence Prevention', 'prevent domest violenc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800759, 'Information and Referral, Domestic Violence', 'inform and referr domest violenc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800770, 'Counseling, Rape', 'counsel rape');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800781, 'Battered Women Shelter', 'shelter batter women');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800792, 'Advocacy, Rape', 'advocaci rape');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800803, 'Rape', 'rape');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800814, 'Caregivers, Disabled', 'disabl caregiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800825, 'Autism', 'autism');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800836, 'Vocational Assessment, Disabled', 'disabl vocat assess');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800847, 'Information and Referral, Disabled', 'disabl inform and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800858, 'Hotlines Disabled', 'disabl hotlin');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800869, 'Advocacy, Disabled', 'disabl advocaci');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800880, 'Transitional Living Program, Disabled', 'disabl transition program live');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800891, 'Housing, Disabled', 'disabl hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800902, 'Transportation, Disabled', 'disabl transport');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800913, 'Special Needs', 'special ne');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800924, 'Residential Programs, Disabled', 'disabl program residenti');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800935, 'Attention Deficit Disorder', 'deficit disord attent');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800946, 'Services, Disabled', 'disabl servic');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800957, 'Adult Day Care, Disabled', 'disabl care dai adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800968, 'Dyslexia', 'dyslexia');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800979, 'Visually Impaired', 'impair visual');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800990, 'Independent Living Facility, Disabled', 'disabl independ facil live');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801001, 'Life Skills Training, Disabled', 'disabl train life skill');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801012, 'Independent Living, Disabled', 'disabl independ live');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801023, 'Reading Aids', 'read aid');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801034, 'Social Security', 'secur social');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801045, 'Employment, Disabled', 'disabl employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801056, 'Hearing Impaired', 'impair hear');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801067, 'Learning Disabilities', 'learn disabl');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801078, 'Mental Retardation', 'retard mental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801089, 'Independent Living Program, Disabled', 'disabl independ program live');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801100, 'Vocational Rehabilitation, Disabled', 'disabl vocat rehabilit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801111, 'Assistive Devices', 'devic assist');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801122, 'Braille', 'braill');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801133, 'Education/Training, Disabled', 'disabl train educ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801144, 'Meals on Wheels', 'meal wheel');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801155, 'Mental Illness', 'ill mental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801166, 'Therapeutic Riding', 'ride therapeut');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801177, 'Computer Training, Adult', 'train comput adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801188, 'Education, Elementary', 'educ elementari');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801199, 'Life Skills Training, Adult', 'train life adult skill');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801210, 'Truancy', 'truanci');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801232, 'Head Start', 'head start');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801243, 'ESL/ESOL', 'esl esol');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801254, 'Advocacy, Special Needs', 'special advocaci ne');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801265, 'Tutoring, Middle School', 'school middl tutor');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801276, 'Certificate Programs', 'certif program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801287, 'First Aid Classes', 'aid class first');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801298, 'Literacy', 'literaci');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801309, 'Professional Training', 'train profession');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801320, 'School, Alternative/Charter', 'charter school altern');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801331, 'High School Diploma', 'diploma school high');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801342, 'Homework Assistance, Middle School', 'homework school assist middl');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801353, 'Information and Referral, Education', 'inform educ and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801364, 'Adult Education', 'educ adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801375, 'Homework Assistance, Adult', 'homework assist adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801386, 'Education, Middle School', 'educ school middl');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801397, 'CPR Classes', 'class cpr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801419, 'Medical Training', 'train medic');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801430, 'Continuing Education', 'educ continu');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801441, 'GED', 'ged');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801452, 'Computer Training, Youth', 'youth train comput');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801463, 'Tutoring, High School', 'school high tutor');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801474, 'School, Public', 'school public');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801485, 'Tutoring, Elementary School', 'school elementari tutor');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801496, 'Life Skills Training, Youth', 'youth train life skill');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801507, 'School Private/Parochial', 'school parochi privat');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801518, 'Homework Assistance, College', 'colleg homework assist');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801529, 'Homework Assistance, Elementary School', 'homework school assist elementari');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801540, 'Information and Referral, Special Needs', 'special inform ne and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801551, 'Hotlines, Special Needs', 'special hotlin ne');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801562, 'Advocacy, Education', 'educ advocaci');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801573, 'Life Skills Training, Teens', 'train life teen skill');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801584, 'Adult Basic Education', 'educ basic adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801595, 'Homework Assistance, High School', 'homework school assist high');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801606, 'Dropout Program', 'dropout program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801617, 'Computer Training, Teen', 'train teen comput');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801628, 'Education, High School', 'educ school high');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801639, 'Vocational Assessment', 'vocat assess');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801650, 'Hotlines, Unemployment', 'hotlin unemploy');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801661, 'Hotlines, Employment Discrimination', 'hotlin discrimin employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801672, 'Family Medical Leave Act', 'leav famili act medic');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801683, 'Unemployment', 'unemploy');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801694, 'Advocacy, Employment Discrimination', 'advocaci discrimin employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801705, 'Job Search', 'search job');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801716, 'Employee Rights', 'right employe');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801727, 'Job Bank', 'bank job');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801738, 'Information and Referral, Employment', 'inform and referr employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801749, 'Advocacy, Unemployment', 'advocaci unemploy');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801760, 'Employment, Youth/Teens', 'youth teen employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801771, 'Job Club', 'club job');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801782, 'Employment, Counseling', 'counsel employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801793, 'Resume Assistance', 'resum assist');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801804, 'Vocational Rehabilitation', 'vocat rehabilit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801815, 'Employment, Senior', 'senior employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801826, 'Job Training', 'train job');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801837, 'Business Assistance', 'assist busi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801848, 'Employment, Veterans', 'veteran employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801859, 'Employment, Services', 'servic employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801870, 'Business Loans', 'loan busi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801881, 'Information and Referral, Retirement Planning', 'retir inform and referr plan');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801892, 'Advocacy, Credit', 'advocaci credit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801903, 'Tax Preparation Assistance', 'assist prepar tax');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801914, 'Information and Referral, Financial Aid', 'aid inform and financi referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801925, 'Credit Counseling', 'counsel credit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801936, 'Retirement', 'retir');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801947, 'Hotlines, Credit', 'hotlin credit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801958, 'Financial Counseling', 'counsel financi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801969, 'Budget Counseling', 'counsel budget');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801980, 'Information and Referral, Credit', 'inform credit and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801991, 'Financial Aid College', 'aid colleg financi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802002, 'Shelter, Families', 'famili shelter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802013, 'Hotlines, Utilities', 'hotlin util');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802024, 'Clothing', 'cloth');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802035, 'WIC', 'wic');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802046, 'Shelter, Women', 'shelter women');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802057, 'Advocacy, Utilities', 'advocaci util');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802068, 'Shelter, Veterans', 'veteran shelter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802079, 'Advocacy, TAFDC', 'advocaci tafdc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802090, 'Shelter, Men', 'men shelter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802101, 'Shelter, Runaways', 'runawai shelter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802112, 'FEMA', 'fema');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802123, 'Information and Referral, Food', 'inform food and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802134, 'Information and Referral, Shelter', 'inform shelter and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802145, 'Shelter, Homeless', 'homeless shelter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802156, 'Household Items', 'item household');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802167, 'Financial Assistance', 'assist financi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802178, 'TAFDC', 'tafdc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802189, 'Hotlines, Shelter', 'hotlin shelter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802200, 'Furniture', 'furnitur');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802222, 'Utility Assistance', 'assist util');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802233, 'Information and Referral, Welfare', 'inform and welfar referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802255, 'Advocacy, Homeless', 'homeless advocaci');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802266, 'Shelter, Elderly', 'elderli shelter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802277, 'Homeless Services', 'servic homeless');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802288, 'SSDI', 'ssdi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802299, 'Nutrition', 'nutrition');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802310, 'Tobacco Education/Cessation, Adult', 'educ cessat adult tobacco');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802321, 'Information and Referral, AIDS/HIV', 'inform and referr aids hiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802332, 'Hotlines, AIDS/HIV', 'hotlin aids hiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802343, 'Weight Management', 'weight manag');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802354, 'Pregnancy Prevention', 'prevent pregnanc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802365, 'Yoga', 'yoga');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802376, 'Hotlines, Health Insurance', 'hotlin health insur');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802387, 'Information and Referral, Cancer', 'inform and referr cancer');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802398, 'Childbirth Classes', 'class childbirth');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802409, 'Fitness', 'fit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802420, 'Hotlines, Cancer', 'hotlin cancer');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802431, 'Health Education', 'educ health');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802442, 'Information and Referral, Health', 'inform health and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802453, 'Information and Referral, Health Insurance', 'inform health insur and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802464, 'AIDS/HIV, Prevention & Education', 'prevent educ aids hiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802475, 'Tobacco Education/Cessation, Youth/Teen', 'youth educ teen cessat tobacco');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802486, 'Rehabilitation, Medical', 'medic rehabilit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802497, 'Pain Management', 'manag pain');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802508, 'Home Visiting', 'home visit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802519, 'Immunizations', 'immun');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802530, 'Advocacy, AIDS/HIV', 'advocaci aids hiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802541, 'First Aid', 'aid first');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802552, 'Pregnancy Testing', 'test pregnanc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802563, 'Health Insurance', 'health insur');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802574, 'Health Care, Children', 'children care health');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802585, 'Cancer', 'cancer');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802596, 'Prevention Programs, Health', 'prevent health program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802607, 'Free Health Care', 'free care health');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802618, 'Hospice Care', 'care hospic');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802629, 'Home Health Care', 'home care health');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802640, 'STD', 'std');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802651, 'Health Care, Adults', 'adult care health');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802662, 'Homemaker Services', 'servic homemak');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802673, 'Advocacy, Cancer', 'advocaci cancer');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802684, 'AIDS/HIV, Testing & Screening', 'screen test aids hiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802695, 'Blood Pressure', 'blood pressur');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802706, 'Men''s Health', 'health men');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802717, 'Contraceptive Services', 'contracept servic');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802728, 'Health Care, Teens', 'care health teen');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802739, 'Abortion', 'abort');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802750, 'Donating Blood', 'blood donat');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802761, 'Family Planning', 'famili plan');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802772, 'AIDS/HIV, Treatment & Support', 'treatment support aids hiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802783, 'Advocacy, Health', 'advocaci health');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802794, 'Medicare', 'medicar');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802805, 'Dental Care', 'care dental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802816, 'Alternative Health', 'health altern');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802827, 'Women''s Health', 'women health');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802838, 'Advocacy, Health Insurance', 'advocaci health insur');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802849, 'Physician Referral', 'physician referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802860, 'Early Intervention', 'intervent earli');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802871, 'MassHealth/Medicaid', 'masshealth medicaid');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802882, 'Health Care, Infants/Toddlers', 'infant care health toddler');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802893, 'Code Violations', 'code violat');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802904, 'Landlord Trainings', 'train landlord');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802915, 'Hotlines, Housing', 'hotlin hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802926, 'Home Buying', 'home bui');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802937, 'Lead Paint', 'lead paint');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802948, 'AIDS/HIV, Housing', 'hous aids hiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802959, 'Loans, Housing', 'loan hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802970, 'Housing, Affordable', 'hous afford');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802981, 'Section 8 Housing', ' hous section 8');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802992, 'Public Housing', 'hous public');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803003, 'Tenant Rights', 'right tenant');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803014, 'Housing, Transitional', 'hous transition');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803025, 'Housing, Counseling', 'counsel hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803036, 'Housing, Financial Assistance', 'assist hous financi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803047, 'Fair Housing', 'hous fair');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803058, 'Landlord Rights', 'right landlord');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803069, 'Information and Referral, Housing', 'inform hous and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803080, 'Housing, Shelter', 'hous shelter');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803091, 'Mediation, Housing', 'hous mediat');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803102, 'Home Improvement/Modification', 'home improv modif');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803113, 'Advocacy, Housing', 'advocaci hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803124, 'Hotlines, Immigrants', 'hotlin immigr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803135, 'Immigrant Employment Services', 'servic immigr employ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803146, 'Refugees', 'refuge');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803157, 'Translating/Interpreting', 'interpret translat');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803168, 'Asylum', 'asylum');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803179, 'Advocacy, Immigrants', 'advocaci immigr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803190, 'Citizenship Preparation', 'citizenship prepar');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803201, 'Immigrant Rights', 'right immigr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803212, 'Immigrant Education Assistance', 'educ assist immigr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803223, 'Discrimination', 'discrimin');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803234, 'Immigration/Naturalization', 'natur immigr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803245, 'Information and Referral Immigrants', 'inform immigr and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803256, 'Legal Assistance, Immigrants', 'legal immigr assist');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803267, 'Crime Prevention', 'prevent crime');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803278, 'Court', 'court');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803289, 'Divorce', 'divorc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803300, 'Hotlines, Legal', 'legal hotlin');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803311, 'Consumer Rights', 'right consum');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803322, 'Information and Referral', 'inform and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803333, 'Legal Assistance, Child Custody', 'legal assist child custodi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803344, 'Legal Representation Criminal', 'crimin legal represent');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803355, 'Offenders', 'offend');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803366, 'Legal Services', 'servic legal');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803377, 'Legal Advocacy', 'advocaci legal');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803388, 'Legal Representation, Civil', 'civil legal represent');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803399, 'Hotlines, Consumer Rights', 'hotlin right consum');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803410, 'Benefits Law', 'law benefit');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803421, 'Dual Diagnosis', 'dual diagnosi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803432, 'Advocacy, Mental Retardation', 'retard advocaci mental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803443, 'Information and Referral, Mental Health', 'inform health mental and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803454, 'Hotlines, Mental Health', 'hotlin health mental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803465, 'Panic Disorder', 'panic disord');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803476, 'Psychiatric Services', 'servic psychiatr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803487, 'Depression/Manic Depression', 'manic depress');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803498, 'Mental Health, Services', 'servic health mental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803509, 'Residential Programs, Psychiatric', 'psychiatr program residenti');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803520, 'Information and Referral, Mental Retardation', 'retard inform mental and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803531, 'Anxiety', 'anxieti');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803542, 'Advocacy, Mental Health', 'advocaci health mental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803553, 'Mental Health, Information and Education', 'inform educ health and mental');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803564, 'Stress Management', 'stress manag');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803575, 'Coalition/Partnership', 'partnership coalition');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803586, 'Environmental Education', 'educ environment');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803597, 'Planning/Funding Organizations', 'fund organ plan');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803608, 'Clubhouse', 'clubhous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803619, 'Environment', 'environ');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803630, 'Veterans', 'veteran');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803641, 'Gay/Lesbian/Bisexual', 'bisexu lesbian gai');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803652, 'Transportation, Other', 'other transport');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803663, 'Membership Organizations', 'organ membership');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803674, 'Parenting Education', 'educ parent');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803685, 'Parenting Groups', 'parent group');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803696, 'Teen Parents', 'teen parent');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803718, 'Supervised Visitation', 'visit superv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803729, 'Single Parents', 'singl parent');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803740, 'Hotlines, Parenting', 'hotlin parent');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803751, 'Baby Items', 'item babi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803762, 'Advocacy, Parenting', 'advocaci parent');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803773, 'Information and Referral, Parenting', 'inform and parent referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803784, 'Parenting Support', 'parent support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803795, 'Mediation/Conflict Resolution, Family', 'conflict resolut famili mediat');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803806, 'Adoption', 'adopt');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803817, 'Hotlines, Crime', 'crime hotlin');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803828, 'Police', 'polic');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803839, 'Gang Prevention/Intervention', 'intervent prevent gang');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803850, 'Law Enforcement', 'enforc law');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803861, 'Juvenile Delinquency Prevention', 'prevent juvenil delinqu');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803872, 'Public Safety', 'safeti public');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803883, 'Information and Referral, Public Safety', 'inform safeti public and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803894, 'Hotlines, Public Safety', 'safeti hotlin public');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803905, 'Crime Victim', 'crime victim');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803916, 'Senior Center', 'senior center');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803927, 'Adult Day Care, Senior', 'senior care dai adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803938, 'Transportation, Senior', 'senior transport');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803949, 'Hotlines, Senior', 'senior hotlin');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803960, 'Elder Services', 'elder servic');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803971, 'Information and Referral, Senior', 'senior inform and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803982, 'Advocacy, Senior', 'senior advocaci');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803993, 'Caregivers', 'caregiv');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804004, 'Elder Abuse', 'elder abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804015, 'Soccer', 'soccer');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804026, 'Sports/Recreation, Middle School', 'recreat school sport middl');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804037, 'Parks', 'park');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804048, 'Sports/Recreation, Adult', 'recreat sport adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804059, 'Swimming Lessons', 'lesson swim');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804070, 'Water Safety', 'safeti water');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804081, 'Sports/Recreation, Elementary School', 'recreat school sport elementari');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804092, 'Sports/Recreation, High School', 'recreat school sport high');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804103, 'Baseball', 'basebal');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804114, 'Basketball', 'basketbal');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804136, 'Sports/Recreation, Preschool', 'preschool recreat sport');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804147, 'Gymnastics', 'gymnast');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804158, 'Swimming', 'swim');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804169, 'Football', 'footbal');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804180, 'Prevention Program, Alcohol Addiction', 'prevent alcohol addict program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804191, 'Residential Program, Drug Abuse', 'drug abus program residenti');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804202, 'Support Group, Drug Abuse', 'group drug abus support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804213, 'Advocacy, Alcohol Addiction', 'alcohol advocaci addict');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804224, 'Gambling Addiction', 'addict gambl');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804235, 'Counseling, Drug Abuse', 'counsel drug abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804246, 'Counseling, Alcohol Addiction', 'counsel alcohol addict');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804257, 'Halfway House, Alcohol Addiction', 'halfwai alcohol addict hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804268, 'Support Group, Alcohol Addiction', 'alcohol group addict support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804279, 'Recovery, Drug Abuse', 'drug abus recoveri');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804290, 'Methadone Treatment', 'methadon treatment');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804301, 'Prevention Program, Drug Abuse', 'prevent drug abus program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804312, 'Hotlines, Drug Abuse', 'hotlin drug abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804323, 'Information and Referral, Alcohol Addiction', 'inform alcohol and addict referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804334, 'Recovery, Alcohol Addiction', 'alcohol addict recoveri');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804345, 'Residential Program, Alcohol Addiction', 'alcohol addict program residenti');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804356, 'Halfway House, Drug Abuse', 'halfwai drug abus hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804367, 'Detoxification', 'detoxif');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804378, 'Advocacy, Drug Abuse', 'advocaci drug abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804389, 'Information and Referral, Drug Abuse', 'inform drug and referr abus');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804400, 'Hotlines, Alcohol Addiction', 'alcohol hotlin addict');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804411, 'Peer Leadership', 'leadership peer');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804422, 'Babysitter Training', 'train babysitt');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804433, 'Infants/Toddlers', 'infant toddler');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804444, 'Advocacy, Youth', 'youth advocaci');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804466, 'After School Programs, High School', 'school after high program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804477, 'Drug Prevention Programs Middle School', 'prevent school drug program middl');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804488, 'Drug Prevention Programs High School', 'prevent school drug high program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804499, 'Youth Programs, 05 - 10', ' youth  program 05 10');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804510, 'Mediation/Conflict Resolution, Youth', 'youth conflict resolut mediat');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804521, 'Mentoring, Youth', 'youth mentor');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804532, 'Camp, 05 - 10', '  camp 05 10');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804543, 'Runaways', 'runawai');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804554, 'Hotlines, Youth', 'youth hotlin');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804565, 'Teen Programs', 'teen program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804576, 'Youth Programs, 14 - 19', 'youth  program  14 19');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804587, 'After School Programs, Middle School', 'school after program middl');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804598, 'Camp, 14 - 19', ' camp  14 19');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804609, 'Mentoring, Teens', 'teen mentor');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804620, 'After School Programs, Elementary School', 'school after elementari program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804631, 'Information and Referral, Youth', 'youth inform and referr');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804642, 'Children''s Playgroups', 'children playgroup');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804664, 'Youth Programs, 11 - 15', 'youth  program  11 15');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804675, 'Preschool Programs', 'preschool program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804686, 'Camp, 11 - 15', ' camp  11 15');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804697, 'Youth Programs, 17 - 22', 'youth   program 17 22');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804708, 'Drug Prevention Programs Elementary School', 'prevent school drug elementari program');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804719, 'Child Care, 05 - 12', ' care child  05 12');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804730, 'Kinship Care', 'care kinship');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804741, 'Child Care, 0 - 05', '  care child 0 05');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804785, 'Music Lessons, Youth/Teen', 'youth lesson teen music');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804796, 'Visual Arts Classes, Youth/Teen', 'youth class teen art visual');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804807, 'Performance Art Classes, Youth/Teen', 'youth class teen art perform');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804818, 'Senior Recreation/Social', 'recreat senior social');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804829, 'Hockey', 'hockei');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804840, 'Music Lessons, Adult', 'lesson music adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804851, 'Visual Art Classes, Adult', 'adult class art visual');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804862, 'Performance Art Classes, Adult', 'class art perform adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804873, 'Prenatal', 'prenat');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804884, 'Affordable Health Care', 'care health afford');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804895, 'Uninsured Services', 'servic uninsur');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804906, 'Support Group, Cancer', 'group cancer support');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804917, 'Housing, Elderly', 'elderli hous');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804928, 'Food', 'food');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804939, 'Soup Kitchen', 'soup kitchen');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804950, 'College Preparation, Adult', 'colleg prepar adult');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804961, 'Financial Literacy', 'literaci financi');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804972, 'Counseling, Group', 'counsel group');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804983, 'Social/Singles Groups', 'singl social group');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804994, 'Computer/Technology Providers', 'technologi provid comput');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (805005, 'Eating Disorder', 'eat disord');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (805016, 'Diabetes', 'diabet');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802244, 'Food Pantry', 'pantri food');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (805027, 'Martial Arts', 'art martial');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801221, 'Child Care Training', 'child train care');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (801408, 'Home Based Child Care Certification', 'certif home base child care');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804774, 'Information and Referral, Child Care', 'referr inform child and care');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804653, 'Child Care Vouchers', 'voucher child care');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804763, 'Home Based Child Care 0 - 05', '  home base child care 0 05');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (804752, 'Home Based Child Care 05 - 12', ' home base child  care 05 12');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (803707, 'Foster Care', 'foster care');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800550, 'Abuse, Child', 'abus child');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (805038, 'Prescription Drugs', 'drug prescript');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (800011, 'Dance', 'danc');
-INSERT INTO category (category_id, category_name, stems_name) VALUES (802211, 'Food Stamps', 'stamp food');
-
-
---
--- Data for Name: category_search_log; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36539, '66.92.77.160.5111109', '66.92.77.160', '2009-02-11 05:54:18.729039', 'test', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl?rm=browse_one_heading&heading_name=Arts%2FCulture%2FEntertainment', 'test', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36540, '173.114.4.71.7111109', '173.114.4.71', '2009-02-11 07:59:36.053505', 'rent', 'http://northshoreport.org/', 'rent', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36541, '173.114.4.71.7111109', '173.114.4.71', '2009-02-11 07:59:47.315014', 'housing', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'hous', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36543, '66.80.237.78.10121109', '66.80.237.78', '2009-02-12 10:00:34.45959', 'shelter', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl?rm=show_program&program_id=509515', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36545, '74.10.197.220.9141109', '74.10.197.220', '2009-02-14 09:23:46.233276', 'job training', 'http://northshoreport.org/', 'job train', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36547, '74.10.197.220.9141109', '74.10.197.220', '2009-02-14 09:36:37.469211', 'shelter', 'http://northshoreport.org/', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36548, '74.10.197.220.20171109', '74.10.197.220', '2009-02-17 20:40:46.111652', 'nscap', 'http://northshoreport.org/', 'nscap', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36549, '74.10.197.220.20171109', '74.10.197.220', '2009-02-17 20:41:04.072078', 'north shore community action program', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'action commun north shore', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36550, '12.151.131.131.15191109', '12.151.131.131', '2009-02-19 15:39:54.602304', 'test', 'http://northshoreport.org/', 'test', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36551, '66.92.77.160.20191109', '66.92.77.160', '2009-02-19 20:22:35.157509', 'test', 'http://northshoreport.org/', 'test', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36552, '66.92.77.160.20191109', '66.92.77.160', '2009-02-19 20:22:39.770904', 'shelter', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36553, '76.118.140.125.11201109', '76.118.140.125', '2009-02-20 11:06:21.931781', 'shelter', 'http://northshoreport.org/', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36554, '66.92.77.160.20211109', '66.92.77.160', '2009-02-21 20:40:36.675187', 'shelter', 'http://northshoreport.org/', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36555, '129.63.96.191.15241109', '129.63.96.191', '2009-02-24 15:58:16.504203', 'shelter', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36556, '129.63.96.191.16241109', '129.63.96.191', '2009-02-24 16:35:09.482926', 'shelter', 'http://northshoreport.org/', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36557, '66.92.77.160.22251109', '66.92.77.160', '2009-02-25 22:54:31.39761', 'shelter', 'http://northshoreport.org/', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36559, '75.144.137.57.8261109', '75.144.137.57', '2009-02-26 08:47:23.524549', 'test', 'http://northshoreport.org/', 'test', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36560, '75.144.137.57.8261109', '75.144.137.57', '2009-02-26 08:47:31.314394', 'shelter', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36562, '75.144.137.57.9261109', '75.144.137.57', '2009-02-26 09:02:34.148773', 'computer', 'http://northshoreport.org/', 'comput', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36563, '75.144.137.57.9261109', '75.144.137.57', '2009-02-26 09:02:54.367852', 'food', 'http://northshoreport.org/', 'food', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36564, '75.144.137.57.9261109', '75.144.137.57', '2009-02-26 09:03:12.524706', 'job', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'job', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36565, '75.144.137.57.9261109', '75.144.137.57', '2009-02-26 09:04:08.934804', 'love', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'love', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36566, '75.144.137.57.9261109', '75.144.137.57', '2009-02-26 09:04:18.412128', 'peace', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'peac', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36568, '75.144.137.57.9261109', '75.144.137.57', '2009-02-26 09:07:24.977557', 'shelter', 'http://northshoreport.org/', 'shelter', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36569, '75.144.137.57.9261109', '75.144.137.57', '2009-02-26 09:30:13.224785', 'north', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'north', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36571, '208.54.90.21.13261109', '208.54.90.21', '2009-02-26 13:07:00.078196', 'test', 'http://northshoreport.org/', 'test', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36572, '209.235.0.250.9271109', '209.235.0.250', '2009-02-27 09:20:22.949539', 'child ', 'http://northshoreport.org', 'child', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36573, '209.235.0.250.9271109', '209.235.0.250', '2009-02-27 09:21:26.314343', 'lynn', 'http://northshoreport.org/', 'lynn', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36574, '209.235.0.250.9271109', '209.235.0.250', '2009-02-27 09:21:31.553396', 'legal', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'legal', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36575, '64.206.127.11.11271109', '64.206.127.11', '2009-02-27 11:49:18.326637', 'children', 'http://northshoreport.org/', 'children', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36578, '205.188.116.10.15281109', '205.188.116.10', '2009-02-28 15:15:36.592602', 'youth', 'http://northshoreport.org/', 'youth', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36579, '205.188.116.10.15281109', '205.188.116.10', '2009-02-28 15:16:26.24067', 'tutoring', 'http://northshoreport.org/', 'tutor', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36580, '205.188.116.10.15281109', '205.188.116.10', '2009-02-28 15:16:34.877609', 'GED', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'ged', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36583, '96.39.15.106.20281109', '96.39.15.106', '2009-02-28 20:51:36.047453', 'GED', 'http://northshoreport.org/', 'ged', 0.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36584, '96.39.15.106.20281109', '96.39.15.106', '2009-02-28 20:51:49.440508', 'Food', 'http://northshoreport.org/cgi-bin/mvhub/guide.pl', 'food', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36585, '209.235.0.249.1132109', '209.235.0.249', '2009-03-03 11:18:40.970955', 'children', 'http://northshoreport.org/', 'children', 1.00);
-INSERT INTO category_search_log (search_id, session_id, ip_address, "timestamp", search_phrase, referer, phrase_stems, top_score) VALUES (36587, '205.237.102.178.1632109', '205.237.102.178', '2009-03-03 16:21:49.739075', 'Catholic Charities North', 'http://northshoreport.org/', 'cathol chariti north', 0.00);
-
-
---
--- Data for Name: date_agency_created; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO date_agency_created (agency_id, date_created) VALUES (103520, '2009-02-11');
-INSERT INTO date_agency_created (agency_id, date_created) VALUES (103531, '2009-02-26');
-INSERT INTO date_agency_created (agency_id, date_created) VALUES (103542, '2009-02-27');
-
-
---
--- Data for Name: date_program_created; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO date_program_created (program_id, date_created) VALUES (509460, '2009-02-11');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509471, '2009-02-11');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509482, '2009-02-11');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509493, '2009-02-11');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509504, '2009-02-11');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509515, '2009-02-11');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509526, '2009-02-11');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509537, '2009-02-11');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509548, '2009-02-26');
-INSERT INTO date_program_created (program_id, date_created) VALUES (509559, '2009-02-27');
-
-
---
--- Data for Name: heading; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO heading (heading_name) VALUES ('Arts/Culture/Entertainment');
-INSERT INTO heading (heading_name) VALUES ('City/Town Services');
-INSERT INTO heading (heading_name) VALUES ('Community/Civic');
-INSERT INTO heading (heading_name) VALUES ('Counseling');
-INSERT INTO heading (heading_name) VALUES ('Crisis/Abuse/Rape');
-INSERT INTO heading (heading_name) VALUES ('Disabled/Handicapped');
-INSERT INTO heading (heading_name) VALUES ('Education/Training');
-INSERT INTO heading (heading_name) VALUES ('Employment');
-INSERT INTO heading (heading_name) VALUES ('Financial Education/Credit');
-INSERT INTO heading (heading_name) VALUES ('Food/Shelter & Financial Assistance');
-INSERT INTO heading (heading_name) VALUES ('Health Education/Fitness/Well-being');
-INSERT INTO heading (heading_name) VALUES ('Health/Health Insurance');
-INSERT INTO heading (heading_name) VALUES ('Housing');
-INSERT INTO heading (heading_name) VALUES ('Immigrant Services');
-INSERT INTO heading (heading_name) VALUES ('Legal/Consumer Protection');
-INSERT INTO heading (heading_name) VALUES ('Mental Health');
-INSERT INTO heading (heading_name) VALUES ('Other');
-INSERT INTO heading (heading_name) VALUES ('Parenting/Family');
-INSERT INTO heading (heading_name) VALUES ('Public Safety');
-INSERT INTO heading (heading_name) VALUES ('Senior/Elderly');
-INSERT INTO heading (heading_name) VALUES ('Sports/Recreation');
-INSERT INTO heading (heading_name) VALUES ('Substance Abuse/Addiction');
-INSERT INTO heading (heading_name) VALUES ('Youth');
-
-
---
--- Data for Name: heading_category; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO heading_category (category_id, heading_name) VALUES (800000, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800022, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800033, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800044, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800055, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800066, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800077, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800088, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800099, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800110, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800121, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800132, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800143, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800154, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800165, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800176, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800187, 'City/Town Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800198, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800209, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800220, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800231, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800242, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800253, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800264, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800275, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800143, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800286, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800297, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800308, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800319, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800330, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800341, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800352, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800363, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800374, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800385, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800396, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800407, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800418, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800429, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800440, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800451, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800462, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800473, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800484, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800495, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800517, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800528, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800539, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800561, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800572, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800583, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800594, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800605, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800616, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800627, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800638, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800649, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800660, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800671, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800682, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800693, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800704, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800715, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800726, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800737, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800748, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800759, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800770, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800781, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800792, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800803, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800517, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800814, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800825, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800836, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800847, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800858, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800869, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800880, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800891, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800902, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800913, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800924, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800935, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800946, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800957, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800968, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800979, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800990, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801001, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801012, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801023, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801034, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801045, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801056, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800682, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801067, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801078, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801089, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801100, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801111, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801122, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801133, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801144, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801155, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801166, 'Disabled/Handicapped');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801177, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801188, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801199, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801210, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801232, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801243, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801254, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801265, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801276, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801287, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800220, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801298, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801309, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801320, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801331, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801342, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801353, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801364, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801375, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801386, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800913, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800935, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801397, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800968, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801419, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801430, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801441, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801452, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801463, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801474, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801485, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801496, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801507, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801518, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801067, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801529, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801540, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801551, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801562, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801573, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801584, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801595, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801606, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801617, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801628, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801177, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801639, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801650, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801661, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801672, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801683, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801694, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801705, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801716, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801727, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801045, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801738, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801749, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801760, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801771, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801309, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801782, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801793, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801804, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801815, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801826, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801837, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801848, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801859, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801870, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801881, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801892, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801903, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801914, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801925, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801936, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801947, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801958, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801969, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801980, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801991, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802002, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802013, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802024, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802035, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802046, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801683, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802057, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802068, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802079, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802090, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802101, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802112, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802123, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802134, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801034, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802145, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802156, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802167, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802178, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802189, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802200, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802222, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802233, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802255, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802266, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802277, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802288, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802299, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802310, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802321, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802332, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802343, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801397, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802354, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802365, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802376, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802387, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801287, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802398, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802409, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802420, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802431, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802442, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802453, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802464, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802475, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802486, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802497, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802519, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802332, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802530, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802541, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802552, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802563, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802574, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802585, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802596, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800385, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802607, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802618, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802354, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802629, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802640, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802376, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802651, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802662, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802673, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802684, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802695, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802706, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802717, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802728, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802739, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802420, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802750, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802453, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802761, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801166, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802772, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802783, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802794, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802805, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802816, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802321, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802827, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802838, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802387, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802849, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802860, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802871, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802442, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802882, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802893, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802904, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800891, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802915, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802926, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802937, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802948, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802959, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802970, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802981, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802992, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803003, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803014, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803025, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802222, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803036, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803047, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803058, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803069, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802277, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803080, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803091, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803102, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803113, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803124, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803135, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803146, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803157, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803168, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803179, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803190, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803201, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801243, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803212, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803223, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803234, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803245, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803256, 'Immigrant Services');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803267, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803278, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803289, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803300, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801749, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803311, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803322, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803333, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803344, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803355, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803366, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803377, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803388, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803399, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803410, 'Legal/Consumer Protection');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803421, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800341, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800374, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803432, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803443, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803454, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803465, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803476, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803487, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803498, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801078, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803509, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803520, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801155, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803531, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803542, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803553, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803564, 'Mental Health');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803575, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803586, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803597, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803608, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803619, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803630, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803641, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803652, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803663, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803674, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803685, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803696, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801232, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803718, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803729, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803740, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800693, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803751, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803289, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803762, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803773, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803784, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802860, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803795, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800473, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803806, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800209, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803817, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803828, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802937, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803839, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800121, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803850, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803861, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803872, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803883, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803894, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803905, 'Public Safety');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800682, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803916, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803927, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803938, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803949, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803960, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801936, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801144, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803971, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801034, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803982, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803993, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804004, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804015, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804026, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804037, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804048, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804059, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804070, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804081, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804092, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804103, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802365, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804114, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804136, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802409, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804147, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804158, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804169, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804180, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804191, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804202, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804213, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804224, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804235, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804246, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804257, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804268, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804279, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804290, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804301, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804312, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804323, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804334, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804345, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804356, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804367, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804378, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804389, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804400, 'Substance Abuse/Addiction');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804411, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803696, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801210, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804422, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801232, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803861, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804433, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802354, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801265, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804444, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804466, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800693, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804477, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804488, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803839, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804499, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804510, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804521, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804532, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804543, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801342, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804554, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804565, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802475, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804576, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804587, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804598, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804609, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804620, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804631, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804642, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801463, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804664, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801485, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804675, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804686, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804697, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804708, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801529, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804719, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802860, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804730, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804741, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801595, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801606, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801760, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804785, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804796, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804807, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804785, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804796, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804807, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804818, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804829, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804840, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804851, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804862, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804884, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804895, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804906, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804818, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804917, 'Senior/Elderly');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804917, 'Housing');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804950, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804961, 'Financial Education/Credit');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804972, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802508, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800770, 'Counseling');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804983, 'Other');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804994, 'Community/Civic');
-INSERT INTO heading_category (category_id, heading_name) VALUES (805005, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (805016, 'Health Education/Fitness/Well-being');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802244, 'Food/Shelter & Financial Assistance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (805027, 'Sports/Recreation');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801221, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801221, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801408, 'Education/Training');
-INSERT INTO heading_category (category_id, heading_name) VALUES (801408, 'Employment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804774, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804774, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804653, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804653, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804763, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804763, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804752, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (804752, 'Youth');
-INSERT INTO heading_category (category_id, heading_name) VALUES (803707, 'Parenting/Family');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800550, 'Crisis/Abuse/Rape');
-INSERT INTO heading_category (category_id, heading_name) VALUES (805038, 'Health/Health Insurance');
-INSERT INTO heading_category (category_id, heading_name) VALUES (800011, 'Arts/Culture/Entertainment');
-INSERT INTO heading_category (category_id, heading_name) VALUES (802211, 'Food/Shelter & Financial Assistance');
-
-
---
--- Data for Name: log_category_search; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-
-
---
--- Data for Name: meta_data_version; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO meta_data_version (version, change_date, note) VALUES (0, '2009-02-25', 'created this table');
-INSERT INTO meta_data_version (version, change_date, note) VALUES (1, '2009-02-25', 'display TRUE north shore towns in table: town / add magnolia to town table');
-
-
---
--- Data for Name: meta_schema_version; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO meta_schema_version (version, change_date, note) VALUES (1, '2009-02-25', 'created tables: meta_schema_version meta_data_version');
-
-
---
--- Data for Name: program; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509482, 103520, '2009-02-11', NULL, 'Project Pathways', NULL, '98 Main St.', NULL, 'Peabody', 'MA', '01960', '978-531-0767', NULL, NULL, '978-531-1012', 'www.nscap.org', 'info@xxxxxxxxx', 'Transition to College', 'Project Pathwyas is a program that will prepare North Shore residents, 18 years or older, to enter college courses and get good jobs in the health and human services field. The rigorous curriculum for Project Pathways will include classes in math, reading, writing, college success skills, computer instruction, health science and career awareness and exploration.  Staff of the project will assist students with developing the skills, supports and academic requirements to enter post secondary education.', 'Must have GED and be out of high school for at least 5 years.', 'Free', NULL, 'Class schedule varies but will likely be evenings and weekends. Business hours are Monday through Friday 9:00 to 5:00', 'Monday through Friday 9:00 to 5:00.', 'Spanish', 'Yes', NULL, '', NULL, NULL, 'Yes', 'Yes', NULL, 'No', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No', NULL, 'Not Applicable', NULL, 'No', NULL, 'No', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', '978-531-1012', 'chester@xxxxxxxxxxxxxx', 'Yes', 'COUNTY', 'Essex County', NULL, NULL, NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509515, 103520, '2009-02-11', NULL, 'Adult Basic Education', NULL, '75 Central St.', NULL, 'Peabody', 'MA', '01960', '978-531-0767 x204', NULL, NULL, '978-531-1012', 'www.nscap.org', 'info@xxxxxxxxx', 'Adult Basic Education/English for Speakers of Other Language', 'The Adult Basic Education program offers instruction in English for Speakers of Other Languages (ESOL). There are three levels: Level 1 (Beginner), Level 2 (Intermediate), and Level 3 (Advanced). Students receive instruction in American English listening, speaking, reading, and writing skills. Local, regional, and national history and civics, as well as traditions, holidays, and customs, are an integral part of our program. In our classes, teachers and students also enjoy sharing their cultures and histories, taking field trips to a variety of locations, and inviting speakers from many community organizations.
-The ABE Program also has a Workplace Education program has a 5 year grant from the DOE. NSCAP partners with Brooksby Village to provide ESOL and ABE classes to employees. Students also learn workplace skills relevant to their jobs.
-', 'Peabody, Beverly, Danvers, Salem area', 'Free', NULL, 'Academic year Monday through Thursday 9:00 to 12:00', 'Monday through Friday 9:00 to 5:00', 'English', 'No', NULL, '', NULL, NULL, 'Yes', 'No', NULL, 'Yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Yes', 'tutors', 'Not Applicable', NULL, 'No', NULL, 'No', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', '978-531-1012', 'chester@xxxxxxxxxxxxxx', 'No', 'TOWN', 'Peabody, MA!DELIM!Beverly, MA!DELIM!Salem, MA!DELIM!Danvers, MA', NULL, NULL, NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509460, 103520, '2009-02-11', NULL, 'Advocacy', NULL, '98 Main St.', NULL, 'Peabody', 'MA', '01960', '978-531-0767', NULL, NULL, '978-531-1012', 'www.nscap.org', 'info@xxxxxxxxx', 'Advocacy', 'The Advocacy Program offers assistance with a wide range of issues to low-income individuals in their main service areas of Salem, Peabody, Danvers, and Beverly. The Advocates work one-on-one with individuals and/or families to resolve crises, make referrals, and help clients attain and/or maintain self-sufficiency. The Advocates assist with Immigration, Social Security Benefits, housing, public benefits, Unemployment benefits, MassHealth and Medicare, and credit and consumer issues. Advocacy also administers funds, which with the Advocates discretion can be used to resolve many utility or rent crisis. Advocacy also administers the Representative Payee Program in conjunction with the Social Security Administration. This program assists individuals who are not capable of managing their own funds by maintaining a stable financial situation for them. However, it should be noted that at this time no new Representative Payee clients can be taken on due to limited staff.
-The component’s staff is bi-lingual and bi-cultural in Spanish and Portuguese.
-', 'low-income residents from the Peabody, Beverly, Danvers and Salem area.', 'Free', NULL, 'MOnday through Friday 9:00 to 5:00', 'Monday through Friday 9:00 to 5:00', 'English!DELIM!Portuguese!DELIM!Spanish', 'Yes', NULL, '', NULL, NULL, 'Yes', 'No', NULL, 'No', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No', NULL, 'Not Applicable', NULL, 'No', NULL, 'No', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', '978-531-1012', 'chester@xxxxxxxxxxxxxx', 'Yes', 'TOWN', 'Peabody, MA!DELIM!Beverly, MA!DELIM!Salem, MA!DELIM!Danvers, MA', NULL, 'Peabody Beverly Danvers Salem', NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509471, 103520, '2009-02-11', NULL, 'Home Care', 'Elder Home Care', '98 Main St.', NULL, 'Peabody', 'MA', '01960', '978-531-0767', NULL, NULL, '978-531-1012', 'www.nscap.org', 'info@xxxxxxxxx', 'Home care services for low income elders', 'We all need a helping hand from time to time. When an elderly parent or a beloved partner requires assistance our trained staff can provide you with the service that will best fit your needs.
-Whether it''s a few hours of shopping a week or daily personal care for someone who is ill we can help.
-An additional benefit for NSCAP clients is the knowledge that their dollars are returned to the community to help others.
-', 'Clients are referred to our Program by the Elder Service Agency in their communities. Families and/or Clients themselves who live in the North Shore should contact North Shore Elders; Beverly and Cape Ann should contact SeniorCare, Inc and clients who live in Lynn, Revere, Swampscott, Saugus and Nahant should contact Greater Lynn Senior Services for eligibility requirements. Clients who are not eligible for services from these agencies can contact our Program directly and their pay rates will be determined by a sliding scale according to their personal income.', 'Sliding Scale', NULL, 'Monday through Friday 9:00 to 5:00', 'Monday through Friday 9:00 to 5:00', 'English!DELIM!Portuguese!DELIM!Spanish', 'No', NULL, '', NULL, NULL, 'Yes', 'No', NULL, 'No', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No', NULL, 'Not Applicable', NULL, 'No', NULL, 'No', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', '978-531-1012', 'chester@xxxxxxxxxxxxxx', 'No', 'TOWN', 'Ipswich, MA!DELIM!Peabody, MA!DELIM!Beverly, MA!DELIM!Lynn, MA!DELIM!Salem, MA!DELIM!Lynnfield, MA!DELIM!Swampscott, MA!DELIM!Danvers, MA!DELIM!Manchester-by-the-Sea, MA!DELIM!Marblehead, MA!DELIM!Topsfield, MA!DELIM!Middleton, MA!DELIM!Hamilton, MA', NULL, 'Beverly, Danvers, Hamilton, Ipswich, Salem, Marblehead, Middleton, Peabody, Topsfield, Wenham, Essex, Manchester, Lynn, Lynnfield, Swampscott, Saugus, Revere', NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509526, 103520, '2009-02-11', NULL, 'Housing Pathways', NULL, '75 Central St.', NULL, 'Peabody', 'MA', '01960', '978-531-0767', NULL, NULL, '978-531-1012', 'www.nscap.org', 'info@xxxxxxxxx', 'Scattered site emergency shelter for families', 'Project Pathways provides homeless families with temporary shelter in apartments, which they occupy until they find permanent housing. NSCAP leases apartments in the Salem area, and pays the rent and utilities. Families pay for phone service. This program is designed for large families and those with, for example, health issues that preclude them from residing in congregate shelters
-.During a family’s stay NSCAP provides: 
-• Food, clothing and (when moving out) furniture donation referrals;
-
-• housing search assistance (including transportation) for families to find affordable, permanent housing;
-
-• case management services to foster a healthy family life;
-
-• referrals to other agencies for education and job training to help parents increase their incomes and move toward self-sufficiency;
-
-• assistance with budgeting in order to save; and
-
-• mediation, paralegal assistance, and referrals for one year to maintain permanent housing.
-
-
-', 'Referral from Dept. of Transistional Assistance', 'Free', NULL, 'Monday through Friday 9:00 to 5:00', 'Monday through Friday 9:00 to 5:00', 'English!DELIM!Portuguese!DELIM!Spanish', 'Yes', NULL, '', NULL, NULL, 'Yes', 'No', NULL, 'No', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No', NULL, 'Not Applicable', NULL, 'No', NULL, 'No', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', '978-531-1012', 'chester@xxxxxxxxxxxxxx', 'No', 'STATE', 'MA', NULL, NULL, NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509537, 103520, '2009-02-11', NULL, 'Salem Cyberspace', NULL, '98 Lafayette St', NULL, 'Salem', 'MA', '01960', '978-740-6667', NULL, NULL, '978-740-6668', 'www.nscap.org', 'info@xxxxxxxxx', 'Community technology center', 'Salem CyberSpace expands the educational and career opportunities for low-income youth and adults, thereby providing the foundation for achievement and self sufficiency. Utilizing state-of-the-art technology and innovative curricula, we successfully meet our goals for English Literacy, Computer Literacy, workplace readiness, and job internships.', 'none', 'Sliding Scale', NULL, 'The office is open at 9am for classes, enrollment, and to answer questions. For public computer access, please see hours posted below.
-Public Access Hours of Operation
-As of October 1, 2008:
-Mondays and Wednesdays:
-
-6:00pm - 8:00pm (time limit is one hour*)
-
-Fridays and Saturdays:
-
-1:00pm - 5:00pm
-
-', 'Monday through Friday 9:00 to 5:00', 'English!DELIM!Spanish', 'No', NULL, '', NULL, NULL, 'Yes', 'No', NULL, 'No', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Yes', 'tutors', 'Not Applicable', NULL, 'No', NULL, 'Yes', NULL, 'Limited', NULL, 'Chester', 'Chester', '978-934-4350', '978-740-6668', 'chester@xxxxxxxxxxxxxx', 'No', 'EVERYWHERE', '', NULL, NULL, NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509504, 103520, '2009-02-11', NULL, 'Tax Services', 'Earned Income Tax Credit  EITC', '75 Central St.', NULL, 'Peabody', 'MA', '01960', '978-531-0767 x222', NULL, NULL, '978-531-1012', 'www.nscap.org', 'info@xxxxxxxxx', 'tax preparation for low income workers', 'Tax preparation services for low income households whose gross income may qualify them for the Earned Income Tax Credit.', 'Typically below $42,000 gross annual income', 'Free', NULL, 'Monday 3 to 6:30, Tuesday 9:00 to 12:00, Wednesday 3:00 to 6:30, Saturday 9:00 to 12:30 -- January 26, 2009 to April 13, 2009', 'Monday through Friday 9:00 to 5:00', 'English', 'Yes', NULL, '', NULL, NULL, 'Yes', 'No', NULL, 'No', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Yes', 'Volunteer Tax Preparers', 'Not Applicable', NULL, 'No', NULL, 'No', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', '978-531-1012', 'chester@xxxxxxxxxxxxxx', 'No', 'EVERYWHERE', '', NULL, NULL, NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509493, 103520, '2009-02-11', NULL, 'Transition to Work', 'TTW', '75 Central St', NULL, 'Peabody', 'MA', '01960', '978-531-0767', NULL, NULL, '978-531-1012', 'www.nscap.org', 'info@xxxxxxxxx', 'Transition to work for homeless heads of household', 'TTW is a collaborative effort initiated between, North Shore Community Action Program, Citizens for Adequate Housing, Help for Abused Women and Children (HAWC), Taking Care of Business (TCB), Turning Point and Wellspring House, shelters serving homeless families in transition. TTW’s mission is to provide job related services to families referred to us from the shelters within the collaborative. The TTW Career Specialists endeavor to remove barriers to work, by linking participants up with education, training and employment opportunities in and around the North Shore area. Some of the services the Career Specialists provide include, but are not limited to, Career Counseling, GED tutoring funds, Job Preparedness and Life Skills Workshops, Job Training and Placement, and a Matching Fund program for Individual Development Savings Accounts.', 'Shelter resident at one of the collaborative shelters', 'Free', NULL, 'Monday through Friday 9:00 to 5:00', 'Monday through Friday 9:00 to 5:00', 'English!DELIM!Spanish', 'Yes', NULL, '', NULL, NULL, 'Yes', 'No', NULL, 'No', NULL, NULL, '98 Main St.', NULL, 'Peabody', 'MA', '01960', 'Yes', NULL, 'Not Applicable', NULL, 'No', NULL, 'No', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', '978-531-1012', 'chester@xxxxxxxxxxxxxx', 'Yes', 'STATE', 'MA', NULL, NULL, NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509548, 103531, '2009-02-26', NULL, 'Northshore Pathways Project', NULL, '156 Broad Street', NULL, 'Lynn, Ma.', 'MA', '01905', '781-599-8543', NULL, NULL, NULL, 'www.operationbootstrap-lynn.org', NULL, 'This is a 30 week pre-vocational training program.', 'We currently are offering pre-vocational training for people interested in becoming nurse assistants.
-This Program provides low skill adults with the basic skills they need to enter and advance in post secondary education and career training. 
-
-North Shore Pathways Project is a pilot program headed by the North Shore Workforce Investment Board and Operation Bootstrap with other community partners. ', 'Legal US Resident
-Advanced English Language Skills ', 'Free', NULL, 'Runs in 30 week secrements', 'Monday thru Friday
-5:00 - 8:00 pm', 'English', 'Yes', 'Proof of legal US residency
-Social Security Card
-Driver''s License
-Check or Money Order for $25 to send out to request a CORI (Criminal Background Check)
-A letter of intent explaining why you would be a good student for our program', '', NULL, NULL, 'Not Applicable', 'No', NULL, 'Not Applicable', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Not Applicable', NULL, 'No', 'Our resource library consists of materials to support the learning process for ESL, ABE, Citizenship and Literacy students.', 'Not Applicable', NULL, 'Not Applicable', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', NULL, 'chester@xxxxxxxxxxxxxx', 'Yes', 'COUNTY', 'Essex County', NULL, NULL, NULL, 'No', 0, NULL);
-INSERT INTO program (program_id, agency_id, last_updated, hidden_reason, program_name, program_alias, address1, address2, city, state, zip, main_phone, toll_free_phone, hotline, fax, website, email, short_program_description, long_program_description, eligibility, fees_charged, fees_explained, program_schedule, hours, languages, appointment, bring, bus_lines, parking, transportation, handicapped_accessible, child_care_provided, child_care_description, wait_list, wait_list_description, other_information, mail_address1, mail_address2, mail_city, mail_state, mail_zip, volunteer_opportunities, volunteer_information, resource_library, resource_library_description, meeting_space, meeting_space_description, news_letter, news_letter_description, public_net_access, public_net_access_description, contact_first_name, contact_last_name, contact_phone, contact_fax, contact_email, contact_email_available, area_type, area_data, tty_tdd, areas_served_description, languages_description, online_registration, reminders_sent, admin_notes) VALUES (509559, 103542, '2009-02-27', NULL, 'Children''s Law Center', NULL, '298 Union Street', NULL, 'Lynn', 'MA', '01901', '781-581-1977', NULL, NULL, NULL, 'www.clcm.org', NULL, 'Legal representation for low-income children.', 'The Children''s Law Center represents young people in a variety of legal and administrative proceedings including education, child welfare and juvenile justice.
-Information, referrals and representation available for education matters, suspensions, expulsions, special education, and other school-related issues, child welfare, delinquencies, abuse & neglect, and CHINS proceedings. 
-', 'Eligible clients are low-income children under the age of 18, or under 22 for special education matters.', 'Free', NULL, 'Year-round.', 'Monday - Friday
-9am - 5pm', 'English!DELIM!Spanish', 'No', NULL, '', NULL, NULL, 'Yes', 'Not Applicable', NULL, 'Not Applicable', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Not Applicable', NULL, 'No', NULL, 'No', NULL, 'Not Applicable', NULL, 'No', NULL, 'Chester', 'Chester', '978-934-4350', NULL, 'chester@xxxxxxxxxxxxxx', 'No', 'TOWN', 'Amesbury, MA!DELIM!Lawrence, MA!DELIM!Peabody, MA!DELIM!Rockport, MA!DELIM!Beverly, MA!DELIM!Lynn, MA!DELIM!Salem, MA!DELIM!Lynnfield, MA!DELIM!Manchester-by-the-Sea, MA!DELIM!Marblehead, MA!DELIM!Essex County, MA!DELIM!Methuen, MA!DELIM!Gloucester, MA!DELIM!Nahant, MA!DELIM!Newbury, MA!DELIM!Newburyport, MA', NULL, 'Essex County.
-Limited Middlesex County. 
-Revere, Chelsea and Saugus in addition.', NULL, 'No', 0, NULL);
-
-
---
--- Data for Name: program_category; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO program_category (category_id, program_id) VALUES (802233, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802035, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (801683, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802112, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802057, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (803245, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802211, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (803113, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802123, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802167, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802288, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802222, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (803234, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (801034, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (803971, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (802178, 509460);
-INSERT INTO program_category (category_id, program_id) VALUES (803993, 509471);
-INSERT INTO program_category (category_id, program_id) VALUES (801364, 509482);
-INSERT INTO program_category (category_id, program_id) VALUES (804950, 509482);
-INSERT INTO program_category (category_id, program_id) VALUES (804961, 509493);
-INSERT INTO program_category (category_id, program_id) VALUES (801793, 509493);
-INSERT INTO program_category (category_id, program_id) VALUES (801826, 509493);
-INSERT INTO program_category (category_id, program_id) VALUES (801309, 509493);
-INSERT INTO program_category (category_id, program_id) VALUES (801782, 509493);
-INSERT INTO program_category (category_id, program_id) VALUES (801749, 509493);
-INSERT INTO program_category (category_id, program_id) VALUES (801903, 509504);
-INSERT INTO program_category (category_id, program_id) VALUES (801584, 509515);
-INSERT INTO program_category (category_id, program_id) VALUES (801243, 509515);
-INSERT INTO program_category (category_id, program_id) VALUES (802002, 509526);
-INSERT INTO program_category (category_id, program_id) VALUES (801617, 509537);
-INSERT INTO program_category (category_id, program_id) VALUES (801177, 509537);
-INSERT INTO program_category (category_id, program_id) VALUES (801452, 509537);
-INSERT INTO program_category (category_id, program_id) VALUES (801353, 509548);
-INSERT INTO program_category (category_id, program_id) VALUES (801826, 509548);
-INSERT INTO program_category (category_id, program_id) VALUES (801419, 509548);
-INSERT INTO program_category (category_id, program_id) VALUES (801584, 509548);
-INSERT INTO program_category (category_id, program_id) VALUES (803377, 509559);
-INSERT INTO program_category (category_id, program_id) VALUES (801386, 509559);
-INSERT INTO program_category (category_id, program_id) VALUES (801628, 509559);
-INSERT INTO program_category (category_id, program_id) VALUES (803366, 509559);
-INSERT INTO program_category (category_id, program_id) VALUES (803322, 509559);
-INSERT INTO program_category (category_id, program_id) VALUES (800913, 509559);
-INSERT INTO program_category (category_id, program_id) VALUES (801188, 509559);
-INSERT INTO program_category (category_id, program_id) VALUES (801067, 509559);
-
-
---
--- Data for Name: search_log; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-
-
---
--- Data for Name: synonym_stem; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900000, 'add', 'ADD');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900000, 'adhd', 'ADHD');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900000, 'hadd', 'HADD');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900011, 'alcohol', 'alcohol');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900011, 'drink', 'drinking');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900011, 'drunk', 'drunk');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900022, 'assist', 'assist');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900022, 'help', 'help');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900033, 'cessat', 'cessation');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900033, 'quit', 'quit');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900044, 'child', 'child');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900044, 'children', 'children');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900044, 'kid', 'kid');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900044, 'youth', 'youth');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900055, 'class', 'class');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900055, 'lesson', 'lesson');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900066, 'comput', 'computer');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900066, 'technologi', 'technology');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900066, 'internet', 'internet');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900077, 'counsel', 'counseling');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900077, 'therapi', 'therapy');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900088, 'detoxif', 'detoxification');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900088, 'detox', 'detox');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900099, 'disabl', 'disabled');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900099, 'handicap', 'handicapped');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900110, 'drug', 'drug');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900110, 'substanc', 'substance');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900121, 'elder', 'elder');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900121, 'elderli', 'elderly');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900121, 'senior', 'senior');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900132, 'fit', 'fitness');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900132, 'exerc', 'exercise');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900143, 'health', 'health');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900143, 'medic', 'medical');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900143, 'healthcar', 'healthcare');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900154, 'infant', 'infant');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900154, 'babi', 'baby');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900165, 'job', 'job');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900165, 'career', 'career');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900165, 'vocat', 'vocation');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900165, 'employ', 'employment');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900176, 'literaci', 'literacy');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900176, 'read', 'reading');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900176, 'write', 'writing');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900176, 'languag', 'language');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900187, 'marit', 'marital');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900187, 'marriag', 'marriage');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900198, 'methadon', 'methadone');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900198, 'heroin', 'heroine');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900209, 'monei', 'money');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900209, 'financ', 'finance');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900220, 'nurs', 'nurse');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900220, 'rna', 'rna');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900231, 'nutrition', 'nutrition');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900231, 'nutritionist', 'nutritionist');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900242, 'pregnant', 'pregnant');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900242, 'pregnanc', 'pregnancy');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900253, 'regist', 'register');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900253, 'registr', 'registration');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900264, 'teen', 'teen');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900264, 'adolesc', 'adolescent');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900275, 'televis', 'television');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900275, 'tv', 'tv');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900286, 'tenant', 'tenant');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900286, 'rent', 'rent');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900286, 'renter', 'renter');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900286, 'rental', 'rental');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900297, 'tobacco', 'tobacco');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900297, 'smoke', 'smoking');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900308, 'util', 'utility');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900308, 'electr', 'electricity');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900308, 'energi', 'energy');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900308, 'fuel', 'fuel');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900308, 'heat', 'heat');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900308, 'ga', 'gas');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900308, 'oil', 'oil');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900319, 'vote', 'vote');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900319, 'voter', 'voter');
-INSERT INTO synonym_stem (synonym_id, word_stem, submitted_word) VALUES (900319, 'elect', 'elect');
-
-
---
--- Data for Name: town; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO town (town_state, county, region, display) VALUES ('Bedford, MA', 'Middlesex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Billerica, MA', 'Middlesex County', 'Greater Lowell', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Chelmsford, MA', 'Middlesex County', 'Greater Lowell', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Dracut, MA', 'Middlesex County', 'Greater Lowell', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Littleton, MA', 'Middlesex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Lowell, MA', 'Middlesex County', 'Greater Lowell', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Tewksbury, MA', 'Middlesex County', 'Greater Lowell', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Tyngsborough, MA', 'Middlesex County', 'Greater Lowell', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Westford, MA', 'Middlesex County', 'Greater Lowell', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Amesbury, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Andover, MA', 'Essex County', 'Greater Lawrence', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Haverhill, MA', 'Essex County', 'Greater Lawrence', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Lawrence, MA', 'Essex County', 'Greater Lawrence', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Merrimac, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Methuen, MA', 'Essex County', 'Greater Lawrence', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Acton, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Arlington, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Ashby, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Ashland, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Ayer, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Belmont, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Boxborough, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Burlington, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Cambridge, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Carlisle, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Concord, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Everett, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Framingham, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Groton, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Holliston, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Hopkinton, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Hudson, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Lexington, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Lincoln, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Malden, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Marlborough, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Maynard, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Medford, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Melrose, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Natick, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Newton, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Pepperell, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Reading, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Sherborn, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Shirley, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Somerville, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Stoneham, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Stow, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Sudbury, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Townsend, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Wakefield, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Waltham, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Watertown, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Wayland, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Weston, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Winchester, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Woburn, MA', 'Middlesex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Saugus, MA', 'Essex County', NULL, false);
-INSERT INTO town (town_state, county, region, display) VALUES ('Dunstable, MA', 'Middlesex County', 'Greater Lowell', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('North Andover, MA', 'Essex County', 'Greater Lawrence', true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Boxford, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Georgetown, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Groveland, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('West Newbury, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Wilmington, MA', 'Middlesex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Beverly, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Danvers, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Essex County, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Gloucester, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Hamilton, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Ipswich, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Lynn, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Lynnfield, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Manchester-by-the-Sea, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Marblehead, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Middleton, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Nahant, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Newbury, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Newburyport, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('North Reading, MA', 'Middlesex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Peabody, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Rockport, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Rowley, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Salem, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Salisbury, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Swampscott, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Topsfield, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Wenham, MA', 'Essex County', NULL, true);
-INSERT INTO town (town_state, county, region, display) VALUES ('Magnolia, MA', 'Essex County', NULL, true);
-
-
---
--- Data for Name: user_type; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-INSERT INTO user_type (type_id, type_name) VALUES (1, 'Data Entry');
-
-
---
--- Data for Name: web_requests; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-
-
---
--- Data for Name: zip_distances; Type: TABLE DATA; Schema: public; Owner: mdadhania
---
-
-
-
---
--- Name: agency_agency_name_key; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY agency
-    ADD CONSTRAINT agency_agency_name_key UNIQUE (agency_name);
-
-
---
--- Name: agency_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY agency
-    ADD CONSTRAINT agency_pkey PRIMARY KEY (agency_id);
-
-
---
--- Name: alias_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY alias
-    ADD CONSTRAINT alias_pkey PRIMARY KEY (category_id, alias_name);
-
-
---
--- Name: category_category_name_key; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY category
-    ADD CONSTRAINT category_category_name_key UNIQUE (category_name);
-
-
---
--- Name: category_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY category
-    ADD CONSTRAINT category_pkey PRIMARY KEY (category_id);
-
-
---
--- Name: date_agency_created_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY date_agency_created
-    ADD CONSTRAINT date_agency_created_pkey PRIMARY KEY (agency_id);
-
-
---
--- Name: date_program_created_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY date_program_created
-    ADD CONSTRAINT date_program_created_pkey PRIMARY KEY (program_id);
-
-
---
--- Name: heading_category_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY heading_category
-    ADD CONSTRAINT heading_category_pkey PRIMARY KEY (category_id, heading_name);
-
-
---
--- Name: heading_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY heading
-    ADD CONSTRAINT heading_pkey PRIMARY KEY (heading_name);
-
-
---
--- Name: log_category_search_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY log_category_search
-    ADD CONSTRAINT log_category_search_pkey PRIMARY KEY (search_id);
-
-
---
--- Name: meta_data_version_version_key; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY meta_data_version
-    ADD CONSTRAINT meta_data_version_version_key UNIQUE (version);
-
-
---
--- Name: meta_schema_version_version_key; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY meta_schema_version
-    ADD CONSTRAINT meta_schema_version_version_key UNIQUE (version);
-
-
---
--- Name: program_category_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY program_category
-    ADD CONSTRAINT program_category_pkey PRIMARY KEY (category_id, program_id);
-
-
---
--- Name: program_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY program
-    ADD CONSTRAINT program_pkey PRIMARY KEY (program_id);
-
-
---
--- Name: search_log_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY search_log
-    ADD CONSTRAINT search_log_pkey PRIMARY KEY (search_id);
-
-
---
--- Name: synonym_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY synonym_stem
-    ADD CONSTRAINT synonym_pkey PRIMARY KEY (synonym_id, word_stem);
-
-
---
--- Name: town_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY town
-    ADD CONSTRAINT town_pkey PRIMARY KEY (town_state);
-
-
---
--- Name: user_type_pkey; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY user_type
-    ADD CONSTRAINT user_type_pkey PRIMARY KEY (type_id);
-
-
---
--- Name: user_type_type_name_key; Type: CONSTRAINT; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-ALTER TABLE ONLY user_type
-    ADD CONSTRAINT user_type_type_name_key UNIQUE (type_name);
-
-
---
--- Name: log_category_search_index_by_session_id; Type: INDEX; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE INDEX log_category_search_index_by_session_id ON log_category_search USING btree (session_id, phrase_stems);
-
-
---
--- Name: session_id_index_on_agency_search_log; Type: INDEX; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE INDEX session_id_index_on_agency_search_log ON agency_search_log USING btree (session_id, search_phrase);
-
-
---
--- Name: session_id_index_on_category_search_log; Type: INDEX; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE INDEX session_id_index_on_category_search_log ON category_search_log USING btree (session_id, phrase_stems);
-
-
---
--- Name: start_zip_index_on_zip_distances; Type: INDEX; Schema: public; Owner: mdadhania; Tablespace: 
---
-
-CREATE UNIQUE INDEX start_zip_index_on_zip_distances ON zip_distances USING btree (start_zip, end_zip);
-
-
---
--- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: mdadhania
---
-
-ALTER TABLE ONLY program
-    ADD CONSTRAINT "$1" FOREIGN KEY (agency_id) REFERENCES agency(agency_id) ON DELETE CASCADE;
-
-
---
--- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: mdadhania
---
-
-ALTER TABLE ONLY alias
-    ADD CONSTRAINT "$1" FOREIGN KEY (category_id) REFERENCES category(category_id) ON DELETE CASCADE;
-
-
---
--- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: mdadhania
---
-
-ALTER TABLE ONLY heading_category
-    ADD CONSTRAINT "$1" FOREIGN KEY (category_id) REFERENCES category(category_id) ON DELETE CASCADE;
-
-
---
--- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: mdadhania
---
-
-ALTER TABLE ONLY program_category
-    ADD CONSTRAINT "$1" FOREIGN KEY (category_id) REFERENCES category(category_id) ON DELETE CASCADE;
-
-
---
--- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: mdadhania
---
-
-ALTER TABLE ONLY date_agency_created
-    ADD CONSTRAINT "$1" FOREIGN KEY (agency_id) REFERENCES agency(agency_id) ON DELETE CASCADE;
-
-
---
--- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: mdadhania
---
-
-ALTER TABLE ONLY date_program_created
-    ADD CONSTRAINT "$1" FOREIGN KEY (program_id) REFERENCES program(program_id) ON DELETE CASCADE;
-
-
---
--- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: mdadhania
---
-
-ALTER TABLE ONLY program_category
-    ADD CONSTRAINT "$2" FOREIGN KEY (program_id) REFERENCES program(program_id) ON DELETE CASCADE;
-
-
---
--- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: mdadhania
---
-
-ALTER TABLE ONLY heading_category
-    ADD CONSTRAINT "$2" FOREIGN KEY (heading_name) REFERENCES heading(heading_name) ON UPDATE CASCADE ON DELETE CASCADE;
-
-
---
--- PostgreSQL database dump complete
---
-

=== added file 'app-mvhub/setup/database/readme'
--- app-mvhub/setup/database/readme	1970-01-01 00:00:00 +0000
+++ app-mvhub/setup/database/readme	2010-04-30 20:30:33 +0000
@@ -0,0 +1,31 @@
+*** VERSION LOG CHANGES FORMATTING README ***
+
+___ Copy the template_version_log.sql file from 
+	app-mvhub/project-tools/templates/ into the 
+	app-mvhub/setup/database/sql/ directory.
+	
+___ RENAME the version_log_template.sql file according to these rules:
+
+	___ Start with a 3 digit number that is one increment higher
+		than the largest numbered file currently in the sql directory.
+	
+	___ Follow that with an underscore (_), and then a BRIEF (6 words or
+		less) description of the change, words seperated by underscores.
+		
+	___ End the file with a .sql extension.
+	
+
+EXAMPLE: You have a change that adds a new test column to the agency
+		 table. The largest numbered file in the sql directory is 
+		 currently 003, so a good name would be:
+		 
+		 004_add_test_column_to_agency.sql
+
+___ OPEN up your newly-named file in an editor and make your changes
+	between the BEGIN and COMMIT lines.
+
+___ MODIFY the VALUES ('') statement to include a note of your changes
+	in between the quotes for inclusion in the version_log. Try to keep
+	it under 20 words. THIS IS REQUIRED OR YOUR SQL CHANGES WILL FAIL.
+	
+___ RUN update_db.pl to make your changes to the database. 

=== removed directory 'app-mvhub/setup/database/schema'
=== removed file 'app-mvhub/setup/database/schema/001_schema_update.sql'
--- app-mvhub/setup/database/schema/001_schema_update.sql	2009-03-04 18:11:56 +0000
+++ app-mvhub/setup/database/schema/001_schema_update.sql	1970-01-01 00:00:00 +0000
@@ -1,27 +0,0 @@
-/*
-  $REVISION$
-  FILE: 001_schema_update.sql
-*/
-
-BEGIN;
-CREATE TABLE meta_schema_version ( 
-	version integer not null UNIQUE, 
-	change_date date not null DEFAULT now(),
-	note text not null
-);
-
-COMMENT ON TABLE meta_schema_version IS 'track version of tables/indexes setup';
-
-CREATE TABLE meta_data_version ( 
-	version integer not null UNIQUE, 
-	change_date date not null DEFAULT now(),
-	note text not null
-);
-
-COMMENT ON TABLE meta_data_version IS 'track version of meta data like towns , categories, synonyms';
-
-INSERT INTO meta_schema_version ( version,note) 
-	VALUES (1, 'created tables: meta_schema_version meta_data_version');
-INSERT INTO meta_data_version ( version,note) 
-	VALUES (0, 'created this table');
-COMMIT;

=== added directory 'app-mvhub/setup/database/sql'
=== added file 'app-mvhub/setup/database/sql/001_setup_version_log.sql'
--- app-mvhub/setup/database/sql/001_setup_version_log.sql	1970-01-01 00:00:00 +0000
+++ app-mvhub/setup/database/sql/001_setup_version_log.sql	2010-04-30 20:30:33 +0000
@@ -0,0 +1,17 @@
+BEGIN;
+
+DROP TABLE IF EXISTS meta_data_version;
+DROP TABLE IF EXISTS meta_schema_version;
+
+CREATE TABLE version_log (
+	version SERIAL PRIMARY KEY,
+	change_date DATE NOT NULL DEFAULT now(),
+	note TEXT NOT NULL UNIQUE
+);
+
+COMMENT ON TABLE version_log IS 'Tracks schema and other metadata changes for MVHub app';
+
+INSERT INTO version_log ( note ) 
+	VALUES ('initial creation of the version log table');
+
+COMMIT;

=== added file 'app-mvhub/setup/database/sql/002_add_comment_to_version_log_table.sql'
--- app-mvhub/setup/database/sql/002_add_comment_to_version_log_table.sql	1970-01-01 00:00:00 +0000
+++ app-mvhub/setup/database/sql/002_add_comment_to_version_log_table.sql	2010-04-30 20:30:33 +0000
@@ -0,0 +1,6 @@
+BEGIN;
+INSERT INTO version_log ( note ) 
+	VALUES ('make SQL COMMENT on version_log table');
+
+COMMENT ON TABLE version_log IS 'Tracks schema and other metadata changes for MVHub app';
+COMMIT;

=== added file 'app-mvhub/setup/database/sql/003_add_empty_constraint_to_note.sql'
--- app-mvhub/setup/database/sql/003_add_empty_constraint_to_note.sql	1970-01-01 00:00:00 +0000
+++ app-mvhub/setup/database/sql/003_add_empty_constraint_to_note.sql	2010-04-30 20:30:33 +0000
@@ -0,0 +1,7 @@
+BEGIN;
+INSERT INTO version_log ( note ) 
+	VALUES ('Added a constraint to version_log.note to disallow empty strings');
+
+ALTER TABLE version_log ADD CONSTRAINT version_log_note CHECK ( note <> '');
+
+COMMIT;

=== modified file 'app-mvhub/setup/database/update_db.pl'
--- app-mvhub/setup/database/update_db.pl	2009-12-18 18:09:42 +0000
+++ app-mvhub/setup/database/update_db.pl	2010-04-30 20:30:33 +0000
@@ -1,6 +1,12 @@
 #!/usr/bin/perl 
 
+use strict;
+use warnings;
+
+use File::Basename;
+
 use MVHub::Utils::DB qw/get_dbh /;
+use MVHub::Utils::ConfigSimple qw/create_config_from/;
 
 BEGIN {
     use FindBin qw($Bin);
@@ -8,80 +14,96 @@
 }
 
 {    # main
-    my ( $dbh, $version, @scripts );
-
-    set_db_ENV_vars( $ENV{MV_CONFIG_FILE} );
-    $dbh = MVHub::Utils::DB::get_dbh( $ENV{MV_CONFIG_FILE} );
-
-    get_and_run_scripts( $dbh, 'schema' );
-    get_and_run_scripts( $dbh, 'data' );
+	my $cfg_filename = shift @ARGV || $ENV{MV_CONFIG_FILE};
+    my $dbh = MVHub::Utils::DB::get_dbh( $cfg_filename );
+	my $cfg = MVHub::Utils::ConfigSimple::create_config_from( $cfg_filename );
+	
+	set_db_ENV_vars( $cfg );
+
+    get_and_run_scripts( $dbh, $cfg);
 }
 
 sub get_and_run_scripts {
-    my ( $dbh, $type ) = @_;
-    $version = get_version( $dbh, "meta_${type}_version" );
-    my @sscripts = get_scripts( version => $version, dir => $type );
-    if ( !scalar @scripts ) {
-        print "no $type scripts after version: $version found\n";
+    my ( $dbh, $cfg ) = @_;
+    
+	my $version = get_version( $dbh );
+	my $path = $cfg->param("ABSOLUTE_PATH.setup_db_dir");
+    my @scripts = get_scripts( version => $version, path => $path );
+    
+	if ( !scalar @scripts ) {
+        print "no scripts after version: $version found\n";
     }
-    run_scripts(@scripts);
+    
+	run_scripts(@scripts);
 }
 
 sub set_db_ENV_vars {
-    my $config_file = shift;
+    my $cfg = shift;
 
     # so psql stops on error
     $ENV{ON_ERROR_STOP} = 1;
 
-    my $cfg = Config::Simple->new($config_file)
-        or die "failed to read file '$config-file'";
     $ENV{PGDATABASE} = $cfg->param('DATABASE.database_name');
-    $ENV{PGHOST}     = csl- $cfg->param('DATABASE.database_host');
+    $ENV{PGHOST}     = $cfg->param('DATABASE.database_host');
     $ENV{PGPASSWORD} = $cfg->param('DATABASE.database_magic_word');
     $ENV{PGUSER}     = $cfg->param('DATABASE.database_user');
 }
 
 sub get_version {
-    my ( $dbh, $table ) = @_;
-
-    my $sql     = "SELECT max(version) FROM $table;";
-    my $version = ( $dbh->selectrow_array($sql) )[0];
-
-    die "get_version failed"
-        if not defined $version;
+    my $dbh = shift;
+	my $version;
+	    
+    my $exist_sql = "SELECT 1 FROM information_schema.tables WHERE table_name='version_log' LIMIT 1";
+    my $table_exists = ( $dbh->selectrow_array($exist_sql) )[0];
+
+	if ($table_exists) {
+    	my $sql     = "SELECT max(version) FROM version_log;";
+    	$version = ( $dbh->selectrow_array($sql) )[0];
+	}
+    else { 
+    	$version = 0;
+    }
+  
     return $version;
 }
 
 sub get_scripts {
     my %args = @_;
-
-    my @raw_scripts = glob "$args{dir}/*.sql";
+	
+    my @raw_scripts = glob "$args{path}/*.sql";
     my @scripts;
 
-    foreach my $script (@raw_scripts) {
-
-        #  my @splits = split /_/, $script;
-        $script =~ /(\d+)/;
-        my $script_version = int $1;
-        print
-            "$args{dir} \$script_version: $script_version \$args{version}: $args{version}\n";
-        print "v>a:", $script_version > $args{version} ? 1 : 0, "\n";
-
-        if ( $script_version > $args{version} ) {
-            push @scripts, $script;
-        }
+    foreach my $script (sort @raw_scripts) {
+
+		if ($script =~ m#\/(\d{3})_[\w\-]+\.sql#) {
+			my $script_version = int $1;
+        
+			if ( $script_version > $args{'version'} ) {
+				push @scripts, $script;
+			}
+		}
+		else {
+			die "ERROR: '$script' does not conform to naming standard: nnn_word_description.sql\n";
+		}
     }
     return sort @scripts;
 }
 
 sub run_scripts {
     my @scripts = @_;
-
+	
     foreach my $script (@scripts) {
-        my $cmd = "psql $script";
-        ( system($cmd) == 0 )
-            or die "$cmd failed";
-        print "ran $script\n";
+    	my $filename = basename($script);
+    	print "Executing $filename...";
+        my $output = `psql -f $script 2>&1`;
+        if ($output =~ /COMMIT/) {
+        	print "SUCCESS\n";
+		}
+		elsif ($output =~ /ROLLBACK/) {
+			print "FAIL\n";
+			print "The following OUTPUT occured while processing $filename:\n";
+			die "$output\n\n****Processing $filename FAILED****\n";
+		}
     }
 
 }

=== modified file 'lib-mvhub/t/conf/all.conf'
--- lib-mvhub/t/conf/all.conf	2010-04-06 20:52:15 +0000
+++ lib-mvhub/t/conf/all.conf	2010-04-30 20:30:33 +0000
@@ -93,6 +93,7 @@
 reports_dir=reports/
 project_tools_dir=link-to-live-code/app-mvhub/project-tools/
 tmp_dir=tmp/
+setup_db_dir=link-to-live-code/app-mvhub/setup/database/sql/
 
 [COOKIES]
 # name of cookie used to store