Semantic search

citation_inspection

Table actions

2 rows where hash_id = "f24261d8450f480f"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

***The IACUC does not have an appropriate non-affiliated member on the committee. The non-affiliated member has ties to the organization that would not allow for an unbiased view of the care and treatment of animals used for research. The Chief Executive Officer must appoint a non-affiliated member to the IACUC that will provide representation from the general community on the care and treatment of animals. Correct by June 30, 2014.

rowid 118
desc INSTITUTIONAL ANIMAL CARE AND USE COMMITTEE (IACUC).
web_siteName MID-ATLANTIC STATES VETERINARY CLINIC
kind  
Incident hash_id f24261d8450f480f
web_inspectionDate 2014-05-15
code 2.31(b)(3)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 0.0
web_certType Class R - Research Facility
pdf_customer_id 84.0
pdf_customer_name Mid-Atlantic States Veterinary Clinic
pdf_customer_addr P O Box 5407 Annapolis, MD 21403
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470610-aphis-inspection-73141808465937
lat 38.9359831
lng -76.4910093

***Records of IACUC protocol reviews and meeting minutes were not available for review at the time of inspection. All IACUC records should be available for review by an APHIS official at the time of inspection in accordance with the standards of the Animal Welfare Act. A method to ensure records are available for review at the time of an inspection must be established to ensure that the facility is providing proper oversight of activity involving the use of animals. Correct by the next inspection. An exit briefing was conducted with the Executive Director.

rowid 119
desc RECORDKEEPING REQUIREMENTS.
web_siteName MID-ATLANTIC STATES VETERINARY CLINIC
kind  
Incident hash_id f24261d8450f480f
web_inspectionDate 2014-05-15
code 2.35(f)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 0.0
web_certType Class R - Research Facility
pdf_customer_id 84.0
pdf_customer_name Mid-Atlantic States Veterinary Clinic
pdf_customer_addr P O Box 5407 Annapolis, MD 21403
customer_state MD
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23470610-aphis-inspection-73141808465937
lat 38.9359831
lng -76.4910093

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "citation_inspection" (
   [rowid] INTEGER PRIMARY KEY,
   [narrative] TEXT,
   [desc] TEXT,
   [web_siteName] TEXT,
   [kind] TEXT,
   [hash_id] TEXT REFERENCES [inspections]([hash_id]),
   [web_inspectionDate] TEXT,
   [code] TEXT,
   [repeat] INTEGER,
   [pdf_insp_type] TEXT,
   [pdf_animals_total] FLOAT,
   [web_certType] TEXT,
   [pdf_customer_id] FLOAT,
   [pdf_customer_name] TEXT,
   [pdf_customer_addr] TEXT,
   [customer_state] TEXT,
   [pdf_site_id] TEXT,
   [doccloud_url] TEXT
, lat double precision, lng double precision);