aphis_reports

Custom SQL query

Tables

_embeddings_citation_inspection

rowid, emb_text_embedding_3_small_512

Many rows

citation_inspection

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

Many rows

citations

rowid, hash_id, code, kind, repeat, desc, narrative

Many rows

inspections

web_certNumber, web_certType, web_city, web_critical, web_customerNumber, web_direct, web_inspectionDate, web_legalName, web_nonCritical, web_reportLink, web_siteName, web_state, web_teachableMoments, web_zip, hash_id, discovered, pdf_insp_id, pdf_layout, pdf_customer_id, pdf_customer_name, pdf_customer_addr, pdf_certificate, pdf_site_id, pdf_site_name, pdf_insp_type, pdf_date, pdf_report_date, pdf_animals_total, doccloud_url, licenseType, customer_state, lat, lng

Many rows

... and 5 hidden tables