-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathimport_batch_3.sql
More file actions
57 lines (57 loc) · 10.1 KB
/
import_batch_3.sql
File metadata and controls
57 lines (57 loc) · 10.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
INSERT INTO documents (title, description, document_url, document_type, category, language) VALUES
('B 1778-1', 'Water Programs Emergency and Imminent Community Water Assistance Grants Project Selection Criteria (1/27/14)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1778-1.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1778-2', 'Water Programs Emergency and Imminent Community Water Assistance Grants Transmittal Memorandum to Request Funds (1/27/14)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1778-2.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-1', 'Water and Waste Project Selection Criteria', 'https://www.rd.usda.gov/media/file/download/uwp-rb-01.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-10', 'Letter For Use In Informing Private Lender of Agency''s Commitment (3-20-00)', 'https://www.rd.usda.gov/media/file/download/uwp-rb-10.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-10a', 'Letter For Use In Informing Private Lender of Agency''s Commitment (Bonds) (Revised 3-20-00)', 'https://www.rd.usda.gov/media/file/download/uwp-rb-10a.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-11', 'Water and Waste Loan/Grant Docket', 'https://www.rd.usda.gov/media/file/download/uwp-rb-11.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-12', 'Grant Agreement (Revised 1-27-14)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1780-12.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-17', 'Review Guide for Water and Waste Audit Reports (Revised 4-21-00)', 'https://www.rd.usda.gov/media/file/download/uwp-rb-17.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-18', 'Daily Inspection Report', 'https://www.rd.usda.gov/media/file/download/uwp-rb-18.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-19', 'Water And Waste Letter Of Conditions', 'https://www.rd.usda.gov/media/file/download/uwp-rb-19.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-2', 'Preliminary Engineering Reports for the Water and Waste Disposal Program (4/4/13)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1780-2.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-20', 'Bylaws', 'https://www.rd.usda.gov/media/file/download/uwp-rb-20.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-22', 'Eligibility Certification', 'https://www.rd.usda.gov/media/file/download/uwp-rb-22.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-23', 'Project Management Agreement Between The Regional Commission and RUS', 'https://www.rd.usda.gov/media/file/download/uwp-rb-23.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-24', 'Public Works Assisted By An Agency Loan (EDA)', 'https://www.rd.usda.gov/media/file/download/uwp-rb-24.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-25', 'Construction of Public Works and Development Facilities (EDA)', 'https://www.rd.usda.gov/media/file/download/uwp-rb-25.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-26', 'Guidance for the Use of Engineers Joint Contract Documents Committee (EJCDC) Bidding and Contract Documents on Water and Waste Disposal Projects with Rural Utilities Service Financial Assistance (Revised 5/10/24)', 'https://www.rd.usda.gov/media/file/download/uwp-rb-26.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-27', 'Loan Resolution (Public Bodies)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1780-27.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-28', 'Loan Resolution Security Agreement (Revised 2-15-00)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1780-28.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-29', '2020 Poverty Guidelines (3-24-21)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1780-29.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-32', 'Memorandum of Agreement between the Appalachian Regional Commission and the Rural Utilities Service', 'https://www.rd.usda.gov/media/file/download/uwp-rb-32.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-33', 'Guidance for Conducting Value Engineering Studies for Water and Waste Projects (Effective 3-21-2005)', 'https://www.rd.usda.gov/media/file/download/uwp-valueengbulletin.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-34', 'Guidance for Using the Competitive Sealed Bids Process for the Water and Waste Disposal Program (Effective 9-5-2013)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1780-34.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-35', 'Guidance for the Implementation of American Iron and Steel (AIS) Requirements with Rural Utilities Service Financial Assistance (Effective 8-30-2017)', 'https://www.rd.usda.gov/media/file/download/uwp-bulletin-1780-35.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-6', 'Water And Waste Processing Checklist (Revised 8-7-2025)', 'https://www.rd.usda.gov/media/file/download/uwp-rb-06.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-7', 'Legal Services Agreement', 'https://www.rd.usda.gov/media/file/download/uwp-rb-07.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-8', 'Minimum Suggested Contents of Management Agreements', 'https://www.rd.usda.gov/media/file/download/uwp-rb-08.pdf', 'Bulletins', 'Utilities', 'en'),
('B 1780-9', 'Water Users Agreement', 'https://www.rd.usda.gov/media/file/download/uwp-rb-09.pdf', 'Bulletins', 'Utilities', 'en'),
('HB-1-3550 Direct Single Family Housing Loans and Grants - Field Office Handbook', 'Consolidated version (large document may take long to load)', 'https://www.rd.usda.gov/media/file/download/hb-1-3550-consolidated.pdf', 'Handbooks', 'Housing', 'en'),
('HB-1-3555 SFH Guaranteed Loan Program Technical Handbook', 'Consolidated version (large document may take long to load)', 'https://www.rd.usda.gov/media/file/download/hb-1-3555-consolidated.pdf', 'Handbooks', 'Housing', 'en'),
('HB-1-3560 MFH Loan Origination Handbook', 'Consolidated version (large document may take long to load)', 'https://www.rd.usda.gov/media/file/download/usda-rd-hb-1-3560-consolidated.pdf', 'Handbooks', 'Housing', 'en'),
('HB-1-3565 Guaranteed Rural Rental Housing Program Origination and Servicing Handbook', 'Table of Contents', 'https://www.rd.usda.gov/media/file/download/3565-1toc.pdf', 'Handbooks', 'Housing', 'en'),
('HB-2-3550 Direct Single Family Housing Loans and Grants - Servicing Office Handbook', 'Table of Contents', 'https://www.rd.usda.gov/media/file/download/3550-2toc.pdf', 'Handbooks', 'Housing', 'en'),
('HB-2-3560 MFH Asset Management Handbook', 'Consolidated version (large document may take long to load)', 'https://www.rd.usda.gov/media/file/download/usda-rd-hb-2-3560-consolidated.pdf', 'Handbooks', 'Housing', 'en'),
('HB-3-3560 MFH Project Servicing Handbook', 'Consolidated version (large document may take long to load)', 'https://www.rd.usda.gov/media/file/download/usda-rd-hb-3-3560-consolidated.pdf', 'Handbooks', 'Housing', 'en'),
('Multifamily Housing Rental Assistance Program', NULL, 'Provides rental assistance payments paid directly to the owners of USDA-financed Rural Rental or Farm Labor Housing projects on behalf of eligible tenants who cannot afford to pay their full rent', 'Program Matrix', 'General', 'en'),
('Multifamily Housing Tenant Voucher Program', NULL, 'Rent vouchers can be used to supplement rent payments at a former USDA-financed property, or at any nonsubsidized rental unit in the United States that meets USDA standards and agrees to accept the voucher', 'Program Matrix', 'General', 'en'),
('Off-Farm Labor Housing Direct Loans and Grants', NULL, 'Provides affordable financing to develop housing for farm workers. Funds can be used to buy or improve land, for new construction, to rehabilitate
existing rental housing in lower-income areas, or to purchase household furnishings.', 'Program Matrix', 'General', 'en'),
('Off-Farm Labor Housing Technical Assistance Grants', NULL, 'Provides funds for applicants of USDA RD Farm Labor Housing loans and grants.
Funds can be used to pay for technical assistance during the application process, loan
underwriting and closing, and to
offset certain transaction costs.', 'Program Matrix', 'General', 'en'),
('On-Farm Labor Housing Loans', NULL, 'Provides financing to develop
or rehabilitate rental housing for lower-income domestic, migrant, and seasonal farm laborers', 'Program Matrix', 'General', 'en'),
('Community Facilities Direct Loans,
Grants and Loan
Guarantees', NULL, 'Provides funds to improve, construct, develop, or finance essential community facilities for rural communities such
as hospitals, clinics, nursing homes, certain schools, child care centers, fire and rescue, public safety facilities, libraries, and town halls', 'Program Matrix', 'General', 'en'),
('Community Facilities Technical Assistance and Training Grants', NULL, 'Award grants to identify and plan for community facility needs. Grant funds can be used to identify public and private financial resources, prepare reports, surveys, and applications, and to improve the operational and financial management of existing community facilities', 'Program Matrix', 'General', 'en'),
('Rural Community Development Initiative Grants', NULL, 'Facilitates housing, community facilities, and community
and economic development projects. Grant funds can be used to support subgrantee trainings on homeownership or minority entrepreneur education, provide technical assistance on strategic plan development, help research and identify additional funding resources, prepare boards
of directors, and create training tools including videos, workbooks, or guides.', 'Program Matrix', 'General', 'en'),
('Tribal College Initiative Grants', NULL, 'Funds capital improvements to educational facilities and for cultural projects at 1994 Land Grant Institutions (Tribal Colleges). Funds can be used for infrastructure development or upgrades, along with equipment purchases for schools, libraries, and dormitories.', 'Program Matrix', 'General', 'en'),
('Agriculture Innovation Center Program', NULL, 'Funds technical assistance for agriculture innovation centers to develop and market value-added agricultural products. Funds can be used for center operations, development, marketing, financial or engineering services, and to connect producers to distribution and processing facilities.', 'Program Matrix', 'General', 'en'),
('BioPreferred Program', NULL, 'Helps provide new markets for farm commodities by increasing the purchase and use of biobased products.', 'Program Matrix', 'General', 'en');