akil_311_complaints
ChatGPTSearch NYC 311 service requests for quality-of-life and service issues such as noise, heat/hot water, street conditions, sanitation, rodents, illegal parking, and other complaints. Jurisdiction: NYC. Accepts: keyword, complaint type, borough, BBL, ZIP, community district, council district, status, created-date range. Returns: complaint type, descriptor, incident address, raw status plus interpreted workflow status, derived complaint category, agency, created/closed dates, resolution text, borough, ZIP, community board, council district, BBL when available. Connects to: property search, HPD complaints, HPD violations, rodent inspections, community needs, point-to-districts, nearby records, constituent services. Coverage: NYC 311 service request records. Interpretation note: 311 service requests are public reports and agency work-order signals, not proof that a condition occurred, was verified, violated law, or was fully remediated. Metric note: Raw complaint volume is not normalized by population, building size, housing units, reporting access, or time window; compare similar properties and geographies.
akil_acris_transactions
ChatGPTSearch recorded deed, mortgage, assignment, satisfaction, lease, agreement, and transfer documents linked to a parcel or party. Jurisdiction: NYC. Accepts: BBL, borough, document type, party name, recorded date range, amount range. Returns: raw ACRIS doc_type, interpreted document type/category, CRFN/document identifiers, recorded date, document amount, amount caveat, party-role labels, party names, BBL, parcel address, borough/block/lot, property type, easement flag when available. Connects to: property search, property sales, title check, property report, property ownership, property assessment, tax exemptions/abatements. Coverage: NYC City Register ACRIS real property records mirrored from NYC Open Data; the mirror starts in 2005. For BBL searches, the lot's documents recorded before 2005 are fetched live from NYC Open Data ACRIS and labeled as such; searches without a BBL cover 2005 onward. BBL searches also read the lot's personal-property filings (UCC financing statements and federal liens) live from ACRIS personal-property records and list them in their own section with their own count and page (offset/limit apply to each family), never mixed with deeds, mortgages or ownership changes; each keeps its raw doc type, City Register link, collateral type and any earlier filing it references. If that read fails, the answer says personal-property coverage is partial and keeps the real-property results. INTERPRETATION NOTES: For property-specific title/deed questions, prefer BBL search over partyName search. partyName searches without a BBL must include a tight recorded-date window because ACRIS parties is a very large source. Newly recorded deeds or mortgages can appear in City Register before NYC Open Data and Akil's mirror catch up; if a recent sale is expected but absent, treat it as an open verification item and check City Register directly. Recorded document amounts are not the same as market value; use property sales/assessment tools for valuation context. Assignment documents are not new borrower debt by themselves; satisfaction/release documents are not new debt or new sale events. Identity note: recorded party names, grantor/grantee roles, parcel BBL, and owner text are recording fields, not beneficial ownership or current control by themselves.
akil_agency_rules
ChatGPTSearch NYC agency proposed/adopted rules, rulemaking notices, and public comment periods. Jurisdiction: NYC. Accepts: keyword, agency, noticeType, dueBefore, dueAfter, limit. Returns: agency, rule title, notice type, publication/start/end dates, event date, location, and description when available. Connects to: public hearings, council legislation, land use search, agency budget, and official directory. Coverage: NYC City Record rulemaking and agency-rule notices. Note: Proposed rules and scheduled hearings may change; only adopted/effective rules should be described as legally final.
akil_agency_staffing
ChatGPTSummarize an NYC agency's payroll: headcount, base salary, overtime and title mix, including teacher and school-staff pay. Jurisdiction: NYC. Use for: Summarizing agency staffing, base salary, overtime, gross pay, and title mix from public payroll records. Accepts: agency, fiscalYear, limit, offset. Returns: the matched payroll employer(s); for one fiscal year (the requested one, else the latest) payroll records, records active on June 30 with the full leave-status breakdown, average/min/max base salary, total gross paid, overtime totals and top titles by payroll records; plus a fiscal-year breakdown of all years when no fiscalYear is given. Connects to: akil_payroll_search, akil_expense_budget, akil_budget_changes, akil_spending_trends, akil_official_directory. Coverage: NYC Citywide Payroll records. Note: Counts are payroll records (one per person, job and fiscal year), not unique people; records active on June 30 are the closest to a headcount. The agency is matched to exact payroll employer names (an alias such as 'DFTA', an exact payroll name such as 'DEPT OF ED PEDAGOGICAL', or a partial name found in only one employer) and unrelated agencies are never combined; title names are payroll titles and may differ from working titles. The Department of Education is split across several payroll employers with different pay bases (pedagogical/annual, per-session, hourly); DOE queries return a per-slice breakdown and slice figures must not be averaged together.
akil_alcohol_proximity_summary
ChatGPTParcel-centered alcohol-license proximity checks for restaurants, bars, wine bars, cafes, nightlife, SLA due diligence, and small-business opening prechecks after an address has been resolved to a BBL. Jurisdiction: NYC + NYS. ROUTING: Use after akil_property_search resolves the BBL and before generic radius scans for alcohol-focused concepts. Accepts: BBL and optional refresh flag. Returns: active NYS SLA license counts within 50, 200, and 500 feet, on-premises/full-liquor/wine-beer class buckets, nearest active license, top nearby license sample, cache freshness, and SLA measurement caveats. Connects to: akil_business_location_context, akil_nys_liquor_licenses, akil_sla_pending_licenses, akil_311_complaints, akil_property_search, akil_nearby. Coverage: NYC PLUTO parcel points joined to NYS SLA active liquor-license geocodes. Note: Distances are diligence signals, not official SLA 200-foot or 500-foot legal measurements.
akil_audit_history
ChatGPTSearch Federal Audit Clearinghouse Single Audit summaries for organizations that received or spent federal funds. Jurisdiction: Federal (NY-relevant). Accepts: organization name, EIN, fiscal/audit year, state, pagination. Returns: raw FAC auditee/report rows with auditee name, EIN/report identifiers when available, fiscal year, federal expenditure, auditor/audit type, material weakness indicators, significant deficiency indicators, questioned costs, finding counts, going-concern context, identity caveats, and compliance summary. Connects to: federal audit findings, compliance flags, nonprofit profile, org lookup, entity verification, organization intelligence, funding profile, top recipients. Coverage: Federal Audit Clearinghouse records relevant to New York organizations. Note: Material weaknesses and questioned costs are audit findings, not automatic proof of fraud or final disallowed costs. No returned FAC rows means no Single Audit row was found in this source, not that the organization has never been audited.
akil_borough_president_funding
ChatGPTReview Borough President capital awards and office funding, contracts, budget lines, initiatives, and officeholder context by borough, recipient/vendor, fiscal year, or Borough President name. Jurisdiction: NYC. Accepts: borough, searchVendor, fiscalYear, bp, limit, offset. Returns: capital awards the Borough President gave to organizations and projects (with coverage by borough), officeholder history, borough summary, year trend, initiatives, contracts, budget lines, and data notes when available. Connects to: akil_capital_projects, akil_vendor_payments, akil_spending_trends, akil_budget_changes, akil_top_recipients, akil_org_intelligence. Coverage: capital awards only where the Borough President published a list, on NYC Open Data or as a PDF on the office's site (Bronx FY2023–FY2024 and FY2026–FY2027, Brooklyn FY2015–FY2021, Manhattan FY2014–FY2018 and FY2023–FY2026 with FY2024 and FY2026 public schools only) plus the Borough President share of Cultural Affairs capital awards FY2018–FY2025 (borough not listed); Queens and Staten Island publish no list. Office budget, contract, and initiative records for all five offices. Note: Amounts can represent allocations or contract values; use vendor payments to verify disbursement timing.
akil_boundary_activity_summary
ChatGPTProduce a bounded public-record activity packet for a selected map boundary before deciding which atomic tools to drill into. Jurisdiction: NYC. ROUTING: Use after a user selects a council district, community district, precinct, borough, neighborhood, ZIP, or other supported boundary and asks what is happening there. Accepts: boundaryType (any of the 12 resolve_boundary layers for spatial counts; the 311 pre-aggregate and facts dossier exist only for council_district, community_district, borough, precinct, nta, zip_code, and school_district for facts; aliases such as zip or cd are normalized), boundaryId, optional topic, months, and limit. Returns: time-windowed 311 pre-aggregate where available, selected spatial record counts, source limitations, anchors, and recommended next checks. Connects to: boundary facts, boundary shape, geo count, geo query, geo trend, 311 complaints, housing violations, restaurant inspections, crime/safety, evictions, rodent inspections. Coverage: NYC boundary layers and geocoded public records. Metric note: This is a routing/context packet; source counts use different freshness, windows, geocoding coverage, and reporting semantics, so do not compare them as normalized rates.
akil_boundary_facts
ChatGPTGet identity, representative, and overlap facts for a NYC administrative boundary. Jurisdiction: NYC + NYS. Accepts: boundaryType (exactly these: council_district, community_district, borough, precinct, nta, zip_code, school_district; aliases such as zip, zipcode, cd, or council are normalized; senate, assembly, congressional, census tract, and health area layers have no facts dossier and are rejected), boundaryId. Returns: boundary name, parent borough, area, neighborhoods, centroid, representatives, and overlapping boundaries grouped by type. Connects to: boundary shape, geo count, geo query, council member profile, council district briefing, capital projects, and council funding tools. Coverage: NYC boundary layers plus selected NYC, NYS, and federal representative records. Note: This is boundary metadata and representation context, not a record search inside the boundary.
akil_boundary_shape
ChatGPTReturn map-ready GeoJSON for a named NYC boundary so an AI client or app can draw, highlight, or fit the area. Jurisdiction: NYC. Accepts: boundaryType (any of the 12 resolve_boundary layers; aliases such as zip or cd are normalized), boundaryId (ID or name). Returns: GeoJSON polygon/multipolygon, centroid, bounding box, area, canonical boundary type, boundary label. Connects to: geo query for records inside the boundary, geo count for totals, polygon stats, point-to-districts, boundary facts, council/district tools, map artifacts. Coverage: NYC boundary layers including council districts, community districts, precincts, boroughs, NTAs, ZIPs, census tracts, school districts, health areas, and state/federal districts.
akil_bp_ulurp_recommendations
ChatGPTFind Borough President recommendations on ULURP applications. Jurisdiction: NYC. Accepts: keyword, borough, recommendation, ulurpNumber, limit. Returns: project name, borough, ULURP number, recommendation, recommendation date, community board, council district, and PDF URL when available. Connects to: land use search, council legislation, community profile, property search, and construction pipeline. Coverage: Manhattan and Brooklyn Borough President recommendation records currently available. Note: Borough President recommendations are advisory; City Planning Commission and City Council make the binding land-use decisions.
akil_brownfield_sites
ChatGPTFind Office of Environmental Remediation brownfield cleanup program sites by borough, BBL, cleanup class, cleanup phase, council district, or keyword. Jurisdiction: NYC. Accepts: borough, bbl, class, phase, councilDistrict, keyword, limit, offset. Returns: project/site name, address, BBL when available, borough, program type, class, phase, status, council district, community district, coordinates, site type, cleanup level, certification date, and description. Connects to: akil_property_search, akil_nearby, akil_building_permits, akil_re_property_report, akil_environmental_data, akil_land_use_search. Coverage: NYC OER brownfield cleanup program records. Note: Active means cleanup or remediation is in progress; completed sites have been remediated; proximity to a brownfield is not the same as a property-level contamination finding.
akil_budget_changes
ChatGPTFind agency budget lines where modified budget amounts differ materially from adopted amounts within the same fiscal year. Jurisdiction: NYC. Accepts: agency, fiscalYear, limit, offset. Returns: agency, budget line, fiscal year, adopted amount, modified amount, change amount, change percentage, and result counts. Connects to: akil_expense_budget, akil_spending_by_category, akil_spending_trends, akil_agency_staffing, akil_budget_proposal, akil_budget_comparison. Coverage: NYC agency budget records derived from public budget data. Note: A midyear increase or decrease can reflect planned adjustments, new federal/state funding, savings, emergency needs, or accounting changes.
akil_budget_comparison
ChatGPTCompare Mayor and City Council budget positions for the same fiscal year, agency, or category. Jurisdiction: NYC. Accepts: fiscalYear, agency, category, limit, offset. Returns: agency or item label, category, Mayor amount, Council amount, difference, and position notes when available. Connects to: akil_budget_proposal, akil_budget_measures, akil_budget_changes, akil_expense_budget, akil_spending_by_category, akil_agency_staffing. Coverage: NYC budget-position records from public budget-cycle documents. Note: These are proposal positions, not actual expenditures; use expense budget and spending tools to compare enacted budget authority with payments.
akil_budget_measures
ChatGPTSearch individual gap-closing measures, revenue enhancements, efficiency savings, restorations, reserve actions, and other budget-cycle proposals. Jurisdiction: NYC. Accepts: source, fiscalYear, category, keyword, limit, offset. Returns: category totals, source, category, description, fiscal-year amounts, total amount, assumptions, risks, and counterpart critique when available. Connects to: akil_budget_proposal, akil_budget_comparison, akil_budget_changes, akil_expense_budget, akil_spending_trends. Coverage: NYC budget-cycle measure records from public Mayor and Council documents. Note: Measures are proposals or assumptions until adopted and implemented; do not treat projected savings or revenues as realized results.
akil_budget_proposal
ChatGPTFind budget proposal documents and high-level fiscal positions from the Mayor, City Council, or Comptroller by source, fiscal year, proposal type, or keyword. Jurisdiction: NYC. Accepts: source, fiscalYear, proposalType, keyword, limit, offset. Returns: proposal title, source, type, fiscal year, release date, total revenue and expenditure when available, count of budget positions, count of gap-closing measures, document link, and summary. Connects to: akil_budget_comparison, akil_budget_measures, akil_budget_changes, akil_expense_budget, akil_spending_trends. Coverage: NYC budget proposal and response documents. Note: Proposals are negotiating positions and should not be described as enacted or committed spending unless the proposal type is adopted.
akil_building_permits
ChatGPTFind DOB building permit records for new buildings, alterations, demolitions, construction work, and permit status at a property or across an area. Jurisdiction: NYC. Accepts: address/keyword, borough, BBL, job type, permit status, work type, ZIP, council district, date range, owner name. Returns: permit number, job number, raw and interpreted job type, raw and interpreted permit/work type, permit status, address, applicant, owner, filing/issuance dates, council district. Connects to: DOB NOW job filings, DOB NOW approved permits, certificate of occupancy, DOB violations, property records, business-opening workflows. Coverage: NYC Department of Buildings permit records.
akil_building_violation_record
ChatGPTGet a compact building enforcement and condition summary for one NYC tax lot before deeper property diligence. Jurisdiction: NYC. Accepts: bbl. Returns: HPD violation counts by class plus interpreted current-status open/resolved/unknown counts, DOB violation summary, OATH hearing count plus interpreted hearing-status open/resolved/unknown counts and balance, recent 311 service-request count, executed evictions, HPD litigations and harassment findings, vacate orders, lien sale appearances, landmark status, nearest brownfield record, property charges balance, and provenance by source. Connects to: akil_hpd_violations, akil_building_violations, akil_enforcement_hearings, akil_311_complaints, akil_evictions, akil_hpd_litigations, akil_vacate_orders, akil_property_charges, akil_tax_lien_sales, akil_re_property_report, akil_re_owner_portfolio. Coverage: NYC building, enforcement, housing, finance, landmark, and environmental records keyed to BBL. Note: Counts are not normalized by unit count or building size, total enforcement rows are not the same as open compliance risk, and 311 service requests are public reports/work-order signals, not verified violations. Use interpreted status fields and atomic tools for details. This is not a code-compliance, title, tax, or engineering opinion.
akil_building_violations
ChatGPTSearch DOB building violation records for construction, building code, safety, permit, equipment, and administrative issues. Jurisdiction: NYC. Accepts: keyword, BBL, borough, violation type, category, block, lot, violation-date lower bound, pagination. Returns: violation number, address, borough/block/lot, raw and interpreted violation type/category/status where verified, issue/disposition dates, respondent, penalty amount, description/comments when available. Connects to: property search, DOB complaints, building permits, DOB NOW permits, OATH/enforcement hearings, HPD violations, certificate of occupancy, property report. Coverage: NYC DOB violation records. Note: DOB violations are different from HPD housing violations; review status and violation type before comparing counts.
akil_business_licenses
ChatGPTCheck active, expired, renewed, suspended, or surrendered NYC business licenses for DCWP-regulated industries. Jurisdiction: NYC. Accepts: business name, address/keyword, borough, category, license status, ZIP, BBL. Returns: business name, license number, license type/category, raw and interpreted license status, address, contact phone when available, creation/expiration dates, BBL. Connects to: DCWP license applications, restaurant inspections, SLA pending licenses, M/WBE records, organization lookup, DOB permits. Coverage: NYC Department of Consumer and Worker Protection business license records. Note: DCWP license status is a source-record signal, not legal advice or a full operating clearance. Identity note: legal name, DBA/business name, licensee or applicant, premises address, BBL/BIN, and license/application ID are separate anchors.
akil_business_location_context
ChatGPTCreate a public-record context packet for a proposed local business or regulated use at a specific address, BBL, BIN, or map point. Jurisdiction: NYC + NYS. ROUTING: Use this after an address/BBL is resolved for restaurant/cafe, alcohol, tobacco/vape, cannabis, sidewalk cafe, mobile vending, storefront, permit, zoning, and pre-lease public-record questions. Accepts: address, BBL, BIN, lat/lon, ZIP, borough, businessType, dateAfter, dateBefore, includeHistorical, radiusMeters, limit. Returns: property anchors, raw building class, interpreted property type, parcel zoning/land-use evidence, occupancy, DOB filings/permits, DCWP/SLA/OCM/license/inspection candidate records, reading notes, source limitations, and next checks. Connects to: property search, parcel land-use evidence, zoning tax lots, DCP zoning features, certificate of occupancy, DOB NOW filings, DCWP inspections/charges/licenses, restaurant inspections, SLA, OCM, tobacco, sidewalk cafe, point-to-districts. Coverage: NYC and NYS public records relevant to NYC local business location screening. Note: This is a public-record screen, not approval, eligibility, zoning, code, legal, architectural, or permitting advice. Date-heavy location checks default to a recent diligence window when dates are omitted.
akil_campaign_bundlers
ChatGPTFind reported campaign intermediaries who bundled or delivered contributions for NYC candidates. Jurisdiction: NYC. Accepts: candidate name, election cycle, minimum bundled total, pagination. Returns: intermediary name, contribution count, total bundled amount, first and last contribution dates, and total result count when available. Connects to: campaign finance, CFB public funds, council member profile, lobbying by agency/member, public-filing name matches. Coverage: NYC Campaign Finance Board intermediary and contribution records. Note: Bundled totals are contributions delivered through an intermediary, not necessarily the intermediary's personal donations.
akil_campaign_finance
ChatGPTSearch NYC Campaign Finance Board contribution records, expenditure records, or candidate-level financial profiles. Jurisdiction: NYC. Accepts: type (contributions, expenditures, candidate_profile), contributor, payee, candidate, candidate ID, election cycle, contributor entity type, expenditure purpose, amount range, pagination. Returns: donor/contributor records, payee and expenditure records, or candidate financial summary with fundraising, spending, and matching-fund context when available. Connects to: campaign bundlers, CFB public funds, council member profile, lobbying tools, capital projects, funding profile, legal defense trusts, ethics records. Coverage: NYC Campaign Finance Board records across city election cycles. Note: Contributor search is name-based; results do not establish company influence or a person's political beliefs. Identity note: candidate/person name, campaign committee or filer, contributor/donor, payee/vendor, employer, and intermediary are separate source roles and should not be merged by name alone.
akil_capital_projects
ChatGPTSearch Council-funded capital projects such as schools, parks, libraries, cultural facilities, housing, infrastructure, equipment, and facility improvements. Jurisdiction: NYC. Accepts: title, fiscalYear, borough, sponsor, district, county, state, limit, offset. Returns: project title, project ID, amount, fiscal year, borough, sponsor, parsed Council district anchors, raw source district/group code, budget line, description, borough totals, and sponsor totals when available. Connects to: akil_council_funding_trace, akil_council_discretionary_awards, akil_council_recipient_funding, akil_public_money_trace, akil_cb_budget_requests, akil_building_permits, akil_land_use_search, akil_property_search, akil_top_recipients, akil_budget_changes. Coverage: NYC Council capital project commitments/allocations only, from the Council's own capital lists: its current-year capital file (the newest budget year and its out-years) and the NYC Open Data copy for earlier years. Capital is a separate budget from Council discretionary expense awards (akil_council_discretionary_awards). Important: For broad questions like "how much did the Council give this organization?", prefer akil_council_funding_trace first, or use this alongside canonical Council discretionary tools and public-money trace, then report segmented totals. Filter semantics: sponsor filters match comma-separated sponsor tokens exactly with full-name/last-name expansion; district filters use parsed validated district codes plus current sponsor-to-district mapping. Raw source district/group codes are still shown for provenance. Identity note: project ID can repeat across fiscal years/scopes and even within one list; do not dedupe or merge rows by project ID alone. A row whose fiscal year is later than its list year is money a list planned for a later year; later lists rarely repeat it.
akil_cb_budget_requests
ChatGPTSearch community board budget priority requests and city agency responses by keyword, borough, board, agency, response text, or publication. Jurisdiction: NYC. Accepts: keyword, borough, board, agency, response, publication, limit, offset. Returns: request text, borough, community board, priority, responsible agency, explanation, city response, publication, and source metadata. Connects to: akil_community_profile, akil_community_needs, akil_capital_projects, akil_budget_changes, akil_expense_budget, akil_spending_by_category. Coverage: NYC community board budget request records. Note: These are requests and agency responses, not approved appropriations or disbursements.
akil_certificate_of_occupancy
ChatGPTCheck Certificates of Occupancy that establish a building's legal occupancy status, certificate type, issue date, dwelling-unit count, and related DOB job information. Jurisdiction: NYC. Accepts: borough, BBL, address, block, lot, job type, application status, issue type, source, keyword, issue date range. Returns: job number, raw and interpreted job type, BIN, BBL, address, issue date, issue type, raw application status, dwelling units, stories, source. Connects to: building permits, DOB NOW approved permits, property records, DOB violations, vacate orders, business-opening workflows. Coverage: NYC Department of Buildings certificate of occupancy records.
akil_cfb_financial_summaries
ChatGPTView candidate-level campaign finance totals by election cycle, including net contributions, expenditures, public matching funds, contribution counts, small-dollar metrics, and office sought. Jurisdiction: NYC. Accepts: keyword, candidate name, election cycle, office, result limit. Returns: candidate name/ID, election cycle, office, net contributions, net expenditures, matching-eligible amount, public funds paid, small-dollar totals, contribution counts, contribution limit, outstanding bills, and status flags. Connects to: campaign finance records, CFB public funds, campaign bundlers, council member profile, lobbying tools. Coverage: NYC Campaign Finance Board candidate financial summaries. Note: This is a candidate summary; use campaign finance for individual donor or expenditure records.
akil_cfb_public_funds
ChatGPTSearch NYC Campaign Finance Board public matching-fund payments to city candidates by candidate, election cycle, office, or amount range. Jurisdiction: NYC. Accepts: candidate name, election cycle, office, minimum/maximum total payment, pagination. Returns: candidate name, election, office, early/primary/general/runoff payment amounts, total public funds paid, record counts, and source metadata. Connects to: campaign finance contributions/expenditures, CFB financial summaries, campaign bundlers, council member profile, lobbying tools. Coverage: NYC Campaign Finance Board public funds records. Note: Public funds are paid in stages and eligibility rules changed by cycle; use election context when comparing candidates.
akil_checkbook_contracts
ChatGPTSearch NYC Checkbook contract registrations, awards, and agreement records by vendor, agency, contract ID, award method, industry, fiscal year, date range, or amount range. Jurisdiction: NYC. Accepts: vendor, agency, contract ID, award method, industry, fiscal year, start/end date filters, minimum/maximum amount, pagination. Returns: contract ID, vendor, agency, current amount, original amount, award method, industry, contract dates, fiscal year. Connects to: vendor payments, funding profile, contract amendments, expiring contracts, sole-source contracts, procurement search, organization lookup. Coverage: NYC Comptroller Checkbook contract records. Note: A registered contract does not prove payment; use vendor payments for disbursements.
akil_coib_policymakers
ChatGPTCheck NYC Conflicts of Interest Board policymaker designations for city employees who must file annual financial disclosure. Jurisdiction: NYC. Accepts: keyword, agency, calendar year, result limit. Returns: employee name, agency, title, calendar year, designation month, and source metadata. Connects to: ethics enforcement, official directory, payroll search, agency staffing, legal conflict scan. Coverage: NYC COIB policymaker designation records. Note: A policymaker designation is a disclosure requirement, not an allegation of misconduct.
akil_compare_scopes
ChatGPTCompare the same dataset count across 2 to 10 boundaries of the same type. Jurisdiction: NYC. Accepts: boundaryType (one of council_district, community_district, precinct, senate_district, assembly_district, congressional_district, school_district, borough, nta, zip_code, census_tract, health_area; aliases such as zip or cd are normalized), ids, dataset (the same canonical keys as geo count; aliases such as 311 are normalized). Returns: ranked comparison table with boundary labels, canonical dataset key and boundary type, counts, deltas versus the highest-count scope, and approximate/error notes when available. Connects to: geo count, geo trend, geo query, boundary facts, community needs, and district briefing. Coverage: NYC geocoded datasets inside supported boundary layers. Metric note: Counts use records with valid coordinates and are raw totals, not normalized rates; use population, unit count, area, or time-window context before describing a scope as worse or better.
akil_compensation
ChatGPTNYC published pay rules: DOE teacher (UFT) and principal/assistant principal/administrator (CSA) salary schedules plus prevailing and living wage schedules, resolved by the date a rate was in force. Jurisdiction: NYC. ROUTING: Use this for published pay RULES — what a contract or schedule REQUIRES to be paid; use akil_payroll_search for what individual city employees were ACTUALLY paid, and never add the two together. Use for: DOE-UFT teacher salary steps/lanes/longevity (contract vintages May 2021 through Sept 2026, collection doe-uft-teacher-salary-2021-2027), DOE-CSA schedules for principals, assistant principals, supervisors, directors, education administrators and CSE chairpersons (2023-2028 vintages, collection doe-csa-salary-2023-2028), NYC Comptroller prevailing wage (Labor Law 220 construction trades), building service (Labor Law 230), and living wage schedules (Admin Code 6-109/6-130/6-134), looked up by trade classification, by step and salary lane or years of service, or by the date a rate was in force. Accepts: catalog, records or documents view; collectionId, period, asOf date, titleCode, differential, keyword, limit, offset. Returns: classification or salary step and lane, union local, wage rate and supplemental benefit per hour or annual salary, the printed effective-date range, source URL and SHA, plus preserved overtime and cross-reference notes. Connects to: akil_payroll_search, akil_agency_staffing, akil_procurement_search, akil_checkbook_contracts, akil_capital_projects. Coverage: teacher schedule 2021-2027 vintages; CSA schedules 2023-2028 vintages; prevailing/living wage 2026-2027 schedule year at first publication; check the catalog for available years. Records require a collectionId plus either an exact period or an asOf date. Notes: schedule rates are not gross pay; the selected salary lane already includes its differential, while per-session and overtime may be separate where the contract permits; teacher +L step rows (e.g. 8B+L15) and CSA 'YR. Long.' rows already include the longevity increment, so never add the separately listed increment amounts on top (CSA additive increments such as 22-year longevity and EA service differentials are the labeled exception: those are paid on top and are not full salaries); a classification may carry several rate windows inside one schedule year; effective-date ends are the inclusive printed last day (DOE schedule end dates are derived from the next printed vintage and disclosed as such); overtime and cross-reference notes carry no rate and a blank is not zero; a date falling between vintages returns an explicit no-rule-in-force answer rather than a zero. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_compliance_flags
ChatGPTScreen audited organizations for Single Audit compliance indicators such as material weaknesses, going-concern opinions, high questioned costs, or high finding counts. Jurisdiction: Federal (NY-relevant). Accepts: state, EIN, fiscal year, flag type, minimum questioned-cost threshold, pagination. Returns: raw Federal Audit Clearinghouse auditee rows with auditee name, EIN, fiscal year, federal expenditure, material weakness flag, questioned costs, finding count, going-concern flag, identity caveats, and source metadata. Connects to: audit history, federal audit findings, nonprofit profile, org lookup, entity verification, organization intelligence, funding profile. Coverage: Federal Audit Clearinghouse audit records relevant to New York organizations. Note: This is a due-diligence screen; a flag is not proof of fraud, current misconduct, or final disallowed costs. Follow up with audit history and findings before characterizing severity.
akil_comptroller_audits
ChatGPTFind NYC Comptroller audit reports by agency, keyword, audit title, audit number, or issue-date range. Jurisdiction: NYC. Accepts: keyword, agency, issue-date range, pagination. Returns: audit title, audit number, audited agency/agencies, issue date, library number, and source metadata. Connects to: agency spending, budget changes, vendor payments, procurement/contracts, federal audit history, compliance flags, official directory. Coverage: NYC Comptroller published audit report index. Note: This index identifies reports; full findings and recommendations may live in the linked report documents.
akil_comptroller_data
ChatGPTReview the Comptroller office's own budget and contract activity by vendor, fiscal year, Comptroller name, or data type. Jurisdiction: NYC. Accepts: searchVendor, fiscalYear, comptroller, dataType, limit, offset. Returns: officeholder history, year trend, contracts, budget lines, contract method, contract period, and data notes when available. Connects to: akil_vendor_payments, akil_spending_trends, akil_budget_changes, akil_expense_budget, akil_top_recipients, akil_comptroller_audits. Coverage: NYC Comptroller office budget and contract records. Note: This is the Comptroller office's own activity, separate from citywide Checkbook data that the Comptroller publishes.
akil_condo_comparable_income
ChatGPTDOF condo comparable rental income records used in assessment methodology, including estimated income, expenses, NOI, and comparable rentals. Jurisdiction: NYC. Accepts: bbl, address, boroBlockLot, condoSection, neighborhood, buildingClassification, minUnits, maxUnits, reportYear, keyword, limit, offset. Returns: BBL, condo section, address, neighborhood, building classification, units, gross square feet, report year, estimated gross income, expenses, NOI, market value fields, and comparable rental references. Connects to: property assessment, condo units, property sales, tax exemptions, property ownership, and co-op comparable income. Coverage: NYC DOF condo comparable rental income records. Note: These are DOF estimates for assessment purposes, not actual rent rolls, common charges, or sale prices.
akil_condo_units
ChatGPTMap condominium base BBLs to individual unit BBLs and unit identifiers. Jurisdiction: NYC. Accepts: condoBaseBbl, unitBbl, condoNumber, unitBoro, effectiveTaxYear, keyword, limit, offset. Returns: base BBL, unit BBL, condo number, unit designation, floor/model fields, borough code, effective tax year, and lot flags when available. Connects to: property assessment, property sales, ACRIS transactions, tax exemptions, condo comparable income, and property search. Coverage: NYC DOF digital tax map condominium unit records. Note: Use the unit BBL for unit-level sales, deeds, assessments, and exemptions; the base BBL describes the building or complex.
akil_constituent_services
ChatGPTNYC Council constituent service/casework records by council district, complaint type, borough, ZIP, community board, keyword, or date range. Jurisdiction: NYC. Accepts: keyword, councilDistrict, complaintType, borough, zip, communityBoard, dateAfter, dateBefore, limit. Returns: complaint type, descriptor, open/close dates, borough, ZIP, council district, community board, account, and case key when available. Connects to: 311 complaints, council member profile, community needs, community profile, and council legislation. Coverage: NYC Council constituent service records. Note: These are council office casework records, not general 311 service requests, and they do not include constituent names or contact details.
akil_contract_amendments
ChatGPTFind contracts where the current registered amount is materially higher than the original amount. Jurisdiction: NYC. Accepts: agency, fiscalYear, minAmendmentPercent, limit, offset. Returns: vendor, agency, original amount, current amount, amendment percentage, fiscal year, and result counts. Connects to: akil_checkbook_contracts, akil_vendor_payments, akil_procurement_search, akil_spending_trends, akil_sole_source_contracts, akil_comptroller_audits. Coverage: NYC Comptroller Checkbook contract records. Note: A contract increase can reflect an option, scope change, extension, emergency need, or inflation adjustment; it is not by itself evidence of a problem.
akil_coop_comparable_income
ChatGPTDOF co-op comparable rental income records used in assessment methodology, including estimated income, expenses, NOI, and comparable rentals. Jurisdiction: NYC. Accepts: bbl, address, boroBlockLot, neighborhood, buildingClassification, minUnits, maxUnits, reportYear, keyword, limit, offset. Returns: BBL, address, neighborhood, building classification, units, gross square feet, report year, estimated gross income, expenses, NOI, market value fields, and comparable rental references. Connects to: property assessment, property sales, tax exemptions, property ownership, and condo comparable income. Coverage: NYC DOF co-op comparable rental income records. Note: These are DOF estimates for assessment purposes; they are not co-op financial statements, maintenance charges, or actual shareholder sale values.
akil_council_award_detail
ChatGPTInspect one Council discretionary award by canonical award ID, MOCS ID, or source record ID. Jurisdiction: NYC. Accepts: awardId. Returns: canonical award fields plus every underlying provenance source row, including RND and MOCS tracker rows when both exist, and per-field member/district attribution basis. Connects to: council discretionary awards, member funding summary, recipient funding, public money trace. Coverage: Council discretionary/Reso A expense allocations. Note: Use this detail tool to distinguish true source duplicates from legitimate distinct same-org awards with different MOCS IDs, and to verify whether member/district came from source rows or derived attribution.
akil_council_bill_detail
ChatGPTLook up one NYC Council bill/file with metadata and action history. Jurisdiction: NYC. Accepts: matterFile. Returns: bill metadata, title, sponsors, committee/body, status, introduced/passed/enacted dates, enactment number, action rows, source IDs, and source metadata. Connects to: council legislation search, council vote detail, member legislation summary, council member voting record. Coverage: NYC Council Legistar legislation and vote-history records. Note: Filed or committee status is not enactment; use actions and roll-call details before inferring legislative movement.
akil_council_caucus_search
ChatGPTSearch Council caucus memberships by district or caucus-name keyword. Jurisdiction: NYC. Accepts: district, caucusName, limit. Returns: caucus name, member name, council district, grouped membership counts, and total matches. Connects to: council member overview, council district briefing, council committee search, council staff search, and council member profile. Coverage: NYC Council caucus membership records. Note: Some caucus names include leadership text in the label; treat it as source text unless structured role fields are added.
akil_council_committee_search
ChatGPTSearch Council committee assignments by district, committee name, or role. Jurisdiction: NYC. Accepts: district, committeeName, role, limit. Returns: committee name, member name, council district, role, count, and role breakdown when available. Connects to: council member overview, council district briefing, council caucus search, council legislation, council votes, and council member profile. Coverage: NYC Council committee assignment records. Note: Role values are assignment labels such as Member, Chair, Vice-Chair, or Co-Chair. Identity note: council member, sponsor, committee role, vote actor, staff contact, candidate, and constituent are separate civic roles.
akil_council_constituent_service_summary
ChatGPTSummarize NYC Council constituent-service/casework records for one Council district. Jurisdiction: NYC. Accepts: councilDistrict, dateAfter, dateBefore, complaintType, limit. Returns: total/open/closed cases, top complaint types, descriptors, ZIPs, sample rows, normalized Council account, and source metadata. Connects to: constituent services search, 311 complaints, community needs, council member lookup, district funding. Coverage: NYC Council constituent service records. Note: These are council office casework records, not all 311 service requests, and they exclude constituent personal details.
akil_council_discretionary_awards
ChatGPTSearch canonical NYC Council discretionary expense awards by member, district, fiscal year, recipient, purpose/category, agency, or source. Jurisdiction: NYC. Accepts: memberName, councilDistrict, fiscalYear, orgName, purposeQuery, agency, sourceKey, districtAttributionMode, limit, offset. Returns: one row per canonical award with MOCS ID or conservative fallback ID, source provenance rows, canonical totals, raw duplicate diagnostics, per-field member/district attribution basis, and source metadata. Connects to: council award detail, council member funding summary, recipient funding, district funding, capital projects, public money trace. Coverage: Council discretionary/Reso A expense allocations only. Important: For broad questions like "how much did the Council give this organization?", do not answer from this tool alone; also query akil_capital_projects and akil_public_money_trace and report segmented totals. Attribution note: each row labels how its member and district were assigned (the award's own row, the member's district that fiscal year, or unattributed). District: the Council's lists name the designating member, not a district, so Akil uses that member's district in that fiscal year; Speaker, delegation and citywide awards have no single district and never match a district filter. Note: Canonical totals dedupe cross-source RND/MOCS rows by MOCS ID plus a conservative fallback for unambiguous RND slug twins; they are allocations, not verified payments.
akil_council_district_briefing
ChatGPTPeople-side briefing for a Council district, focused on the elected member, offices, committees, caucuses, and staff. Jurisdiction: NYC. Accepts: district. Returns: member name, biography, neighborhoods, district and legislative office contacts, committee assignments, caucus memberships, staff directory, and section provenance. Connects to: council member overview, council committee search, council caucus search, council staff search, council member profile, council member voting record, and place-side district briefing. Coverage: NYC Council district/member profile records for 51 districts. Note: This is not the place/funding briefing; use akil_gr_district_briefing for demographics, community indicators, funding, and capital projects. Staff and contact records can lag official source pages.
akil_council_district_funding
ChatGPTReview canonical Council discretionary funding attributed to one Council district, optionally by fiscal year or purpose/category. Jurisdiction: NYC. Accepts: councilDistrict, fiscalYear, purposeQuery, districtAttributionMode, limit, offset. Returns: canonical award rows, district totals, category/member breakdowns, source provenance indicators, per-field member/district attribution basis, and source metadata. Connects to: council member lookup, member funding summary, recipient funding, constituent service summary, capital projects. Coverage: Council discretionary/Reso A expense allocations. Attribution note: the Council's lists name the designating member, not a district, so a district's awards are those of the member who held it in that fiscal year; Speaker, delegation and citywide awards have no single district and never match. Derived rows are labeled and should not be treated as native award-source geography. Note: District funding is expense allocations only; capital projects and casework are separate record types.
akil_council_funding_trace
ChatGPTBroad recipient questions such as "how much did the Council give/fund/allocate/invest in this organization, hospital, library, school, park, museum, nonprofit, facility, or recipient?" This is the composite Council recipient funding trace: it fans out across canonical Council discretionary/Reso A expense awards and Council capital commitments, keeps those record types segmented, and points to public money trace for contracts/payments/grants. Jurisdiction: NYC. Accepts: orgName, capitalKeyword, fiscalYear, memberName, councilDistrict, districtAttributionMode, limit. Returns: segmented Council discretionary expense total, segmented Council capital commitment total, sample rows from each segment, source caveats, per-field discretionary member/district attribution basis, and recommended next tools. Routing: use this before a single atomic funding tool for broad Council recipient totals. Do not present a single unqualified grand total; capital commitments, expense allocations, contracts, and payments are different record types. District: the Council's lists name the designating member, not a district, so Akil uses that member's district in that fiscal year.
akil_council_initiatives
ChatGPTSearch named City Council initiative funding programs such as CASA, Parks Equity, cultural programs, sanitation cleanup, senior services, and other block initiatives. Jurisdiction: NYC. Accepts: name, fiscalYear, agency, limit, offset. Returns: initiative name, total funding, award count, administering agency, fiscal year, top recipients, sponsors, and source metadata. Connects to: akil_top_recipients, akil_funding_profile, akil_org_intelligence, akil_capital_projects, akil_budget_changes, akil_spending_trends. Coverage: NYC Council initiative funding records. Note: This tool summarizes top recipients for an initiative; use a more specific funding/profile tool for full organization-level follow-up.
akil_council_legislation
ChatGPTSearch NYC Council bills and resolutions by keyword, file number, sponsor, committee, status, type, or introduction date range. Jurisdiction: NYC. Accepts: keyword, matter type, matter status, matter file, sponsor, committee, intro-date range, pagination. Returns: bill/file number, title, type, status, de-duplicated sponsor list, committee/body, introduced/passed/enacted dates, enactment number, sponsor-filter semantics, and source metadata. Connects to: council votes, council member voting record, council member profile, lobbying by subject, who lobbies member/agency, campaign finance, agency rules. Coverage: NYC Council legislation records. Note: The sponsor filter matches any listed sponsor/co-sponsor string in the current Legistar sponsor field; lead-vs-cosponsor role rows are not yet modeled as separate source-role rows. Filed or committee status does not mean a bill is likely to pass; use vote and action history for movement.
akil_council_member_funding_summary
ChatGPTCanonical Council discretionary funding totals for one Council member and optional fiscal year. Jurisdiction: NYC. Accepts: memberName, fiscalYear, limit, offset. Returns: one-row-per-MOCS-award totals, category/year breakdowns, top awards, raw source duplicate diagnostics, per-field member/district attribution basis, and source metadata. Connects to: council discretionary awards, award detail, recipient funding, district funding, council member profile. Coverage: Council discretionary/Reso A expense allocations. Attribution note: Member matching uses source-native member names where available; district values on rows may be source-native or derived from the current member overview and are labeled per row. Note: This is the canonical source for member discretionary funding headlines; do not mix with capital projects, contracts, payments, campaign finance, or lobbying amounts.
akil_council_member_legislation_summary
ChatGPTSummarize legislation sponsored by one NYC Council member. Jurisdiction: NYC. Accepts: memberName, matterStatus, matterType, introDateAfter, introDateBefore, limit, offset. Returns: sponsored bill count, status/type breakdowns, recent bill rows, matter files, source IDs, and source metadata. Connects to: council bill detail, council legislation, council votes, council member profile. Coverage: NYC Council Legistar legislation records. Note: Most filed bills do not become law; preserve status and enacted dates.
akil_council_member_lookup
ChatGPTLook up NYC Council member identity by member name or Council district. Jurisdiction: NYC. Accepts: memberName, councilDistrict, limit. Returns: district, member name, slug, email, office phones/addresses, neighborhoods, committee/caucus/staff counts, source URL, and source metadata. Connects to: council member overview, staff search, committee search, caucus search, member funding summary, legislation summary. Coverage: Current Council member profile/contact records. Note: This is identity/context; use funding, legislation, votes, and casework atomics for activity records.
akil_council_member_overview
ChatGPTStatic Council member profile and office contact lookup by district. Jurisdiction: NYC. Accepts: district. Returns: member name, neighborhoods, email, district office, legislative office, biography, committee count, caucus count, staff count, and staff-quality note when available. Connects to: council district briefing, council committee search, council caucus search, council staff search, council member profile, council voting record, and point-to-districts. Coverage: NYC Council member overview records for 51 districts. Note: This is profile/contact data only; use council member profile for funding, sponsorship, voting, and activity metrics.
akil_council_member_profile
ChatGPTBroad NYC Council member identity/context preview across office context, canonical discretionary funding preview rows, capital project preview rows, and sponsored-legislation preview rows. Jurisdiction: NYC. ROUTING: Do NOT use this as the authoritative answer for funding totals, capital attribution, legislation status, or voting questions. For broad Council funding questions use akil_council_funding_trace; for canonical member discretionary expense totals use akil_council_member_funding_summary; for capital attribution and parsed district tokens use akil_capital_projects; for legislation status breakdown use akil_council_member_legislation_summary plus akil_council_bill_detail; for roll-call positions use akil_council_member_voting_record plus akil_council_vote_detail. Accepts: council member name, optional fiscal year, pagination. Returns: member name and preview sections only. Coverage: NYC Council profile context, funding preview, capital preview, and legislation preview. Note: Profile sections are separate record types and may be partial; never sum discretionary expense, capital, contracts, payments, campaign finance, or lobbying into one headline.
akil_council_member_voting_record
ChatGPTView an individual NYC Council member's roll-call voting summary and recent vote records. Jurisdiction: NYC. Accepts: council member name, optional vote value, optional event item ID, pagination. Returns: total votes, affirmative/negative/other counts and percentages, recent vote values, vote event item IDs, current-profile name-resolution basis, incomplete-coverage status, and source metadata. Connects to: council legislation for bill details, council votes for bill action timelines, council member profile, council member overview, council member resolver. Coverage: NYC Council roll-call vote records. Note: Many votes are procedural or unanimous; compare vote context before drawing conclusions from percentages. If a current member has zero mirrored rows, the tool must label that as incomplete mirror coverage, not proof of no votes.
akil_council_raw_source_records
ChatGPTInspect raw/provenance Council source rows behind Akil's derived anchors and canonical Council tools. Jurisdiction: NYC. Accepts: sourceType, memberName, councilDistrict, fiscalYear, keyword, anchorId, limit, offset. Returns: source-native rows, source keys, inferred anchors, and a raw/unreconciled evidence note. ROUTING: Use when users ask how Akil knows, want public-source evidence, or need to inspect RND/MOCS/Legistar/profile fan-out before relying on a canonical answer. Coverage: Council profile, Legistar legislation/actions/roll-calls, committee/caucus/staff records, and RND/MOCS Council award rows. These are NYC Council source records; inferred anchors are candidate links, not independently verified identities.
akil_council_recipient_funding
ChatGPTFind canonical Council discretionary awards received by an organization, optionally filtered by fiscal year, member, or district. Jurisdiction: NYC. Accepts: orgName, fiscalYear, memberName, councilDistrict, districtAttributionMode, limit, offset. Returns: canonical award rows, recipient totals, year/member breakdowns, source provenance indicators, per-field member/district attribution basis, and source metadata. Connects to: award detail, member funding summary, district funding, capital projects, org intelligence, public money trace. Coverage: Council discretionary/Reso A expense allocations only. Important: For broad questions like "how much did the Council give this organization?", do not answer from this tool alone; also query akil_capital_projects and akil_public_money_trace and report segmented totals. Attribution note: Member/district fields are attribution-scoped and may be source-native, derived, or unattributed per row. District: the Council's lists name the designating member, not a district, so Akil uses that member's district in that fiscal year; Speaker, delegation and citywide awards have no single district and never match a district filter. Note: Same recipient and amount may be legitimate distinct awards when MOCS IDs differ.
akil_council_resolve_award
ChatGPTResolve a Council discretionary funding award into Akil's canonical MOCS-ID-or-fallback funding_award_anchor before award detail, member funding, recipient funding, or public-money workflows. Jurisdiction: NYC. Accepts: awardId, memberName, orgName, fiscalYear, limit. Returns: best award anchor, alternates, MOCS/canonical IDs, source-row diagnostics, per-field member/district attribution basis, confidence, caveats, and recommended next tools. ROUTING: Use when users give a MOCS ID, award ID, recipient/member/FY combination, or need to inspect duplicate RND/MOCS fan-out. Coverage: Derived from canonical_council_awards. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_council_resolve_bill
ChatGPTResolve a NYC Council bill, introduction, resolution, file number, keyword, or sponsor into Akil's derived bill/policy anchors before bill detail, vote, or member legislation workflows. Jurisdiction: NYC. Accepts: matterFile, keyword, sponsor, limit. Returns: best bill anchor, alternates, sponsor names, native Legistar IDs, confidence, caveats, and recommended next tools. ROUTING: Use when users mention an Intro/Res number or ask to verify bill identity. Coverage: Derived from NYC Council Legistar legislation and action-history rows. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_council_resolve_district
ChatGPTResolve a NYC Council district or member name into Akil's derived district/place/office anchors before district funding, district briefing, spatial, casework, or local-context workflows. Jurisdiction: NYC. Accepts: councilDistrict, memberName, limit. Returns: best district anchor, current member/office anchor, aliases, confidence, caveats, and recommended next tools. ROUTING: Use after address-to-district lookup or when a user gives a district number. Coverage: Current Council profile district context; use spatial boundary tools for geometry and historical boundary questions. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_council_resolve_member
ChatGPTResolve a NYC Council member name or district into Akil's derived Council person/office/district anchors before funding, legislation, voting, lobbying, or district workflows. Jurisdiction: NYC. Accepts: memberName, councilDistrict, limit. Returns: best anchor match, alternates, aliases, native IDs, confidence, caveats, and recommended next tools. ROUTING: Use before canonical Council tools when the user gives a name, last name, or district and you need a stable anchor. Coverage: Derived from Council member profile records, legislation sponsor strings, and roll-call vote rows. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_council_resolve_recipient
ChatGPTResolve a Council discretionary funding recipient into Akil's derived organization_anchor before recipient funding, award detail, public-money trace, nonprofit, or vendor workflows. Jurisdiction: NYC. Accepts: orgName, ein, fiscalYear, limit. Returns: best recipient anchor, alternates, confidence, canonical award counts/totals, caveats, and recommended next tools. ROUTING: Use before cross-source organization questions when the Council recipient name may have aliases or source-row variants. Coverage: Derived from canonical Council awards; EIN-backed matches are stronger than name-only matches. Attribution note: Use recipient funding or award detail to inspect per-award member/district attribution basis. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_council_staff_search
ChatGPTSearch Council member staff directories by district, council member, or staff name. Jurisdiction: NYC. Accepts: district, memberName, staffName, limit. Returns: staff name, title, email, phone, council district, member name, district counts, and source metadata when available. Connects to: council member overview, council district briefing, council committee search, council caucus search, and council member profile. Coverage: NYC Council staff directory records for 51 districts. Note: Staff titles come from public Council pages and may be partial for some districts; treat contact fields as directory records, not guaranteed current contact availability.
akil_council_vote_detail
ChatGPTInspect one NYC Council roll-call vote event by EventItemId with member-level votes. Jurisdiction: NYC. Accepts: eventItemId. Returns: total, affirmative, negative, other counts, each member vote, source IDs, and source metadata. Connects to: council votes, council legislation, bill detail, member voting record. Coverage: NYC Council roll-call vote records. Note: Many votes are procedural; pair this with bill/action context before interpreting policy meaning.
akil_council_votes
ChatGPTSearch NYC Council bill action and vote-history timelines by bill file, keyword, body, action name, passed flag, or action-date range. Jurisdiction: NYC. Accepts: matter file, keyword, action body, action name, passed-only flag, date range, pagination. Returns: grouped action timeline by bill, action date, body, action name, passed/failed flag, mover name, and source metadata. Connects to: council legislation for bill title/sponsors/status, council member voting record for individual yes/no votes, council member profile, lobbying tools. Coverage: NYC Council vote-history and action records. Note: This is bill/action history; use council member voting record for individual member votes.
akil_crime_data
ChatGPTSearch NYPD complaint records by offense, law category, precinct, borough, date range, or keyword. Jurisdiction: NYC. Accepts: keyword, borough, precinct, offenseType, lawCategory, dateAfter, dateBefore, limit, offset. Returns: complaint offense, law category, precinct, borough, premises type, complaint date, and incident details when available. Connects to: community needs, community profile, nearby records, shootings, and enforcement hearings. Coverage: NYPD complaint records. Metric note: NYPD complaint rows are reported/recorded incidents, not all crime or safety conditions; raw complaint counts are not per-capita rates and recent records may lag reporting.
akil_dcwp_charges
ChatGPTCheck DCWP charges, notices of hearing, cure flags, outcomes, and charge text for regulated local businesses. Jurisdiction: NYC. ROUTING: Use akil_dcwp_inspections for inspection events; use this tool for enforcement charge details and outcomes. Accepts: business name, keyword, category, outcome, cured flag, address anchors, BBL, BIN, borough, ZIP, council/community district, date range, lat/lon/radius. Returns: charge record, NOH number, inspection anchors, charge text/count, raw and interpreted cured flag, raw and interpreted outcome, guilty count, address and district anchors when matched to an inspection. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations. Note: DCWP charge outcome and cure flags are source signals, not the full enforcement/legal record by themselves.
akil_dcwp_inspections
ChatGPTCheck DCWP inspection history for licensed and regulated local businesses, including tobacco, electronic cigarette, grocery, retail, salons, laundries, parking, and other storefront activities. Jurisdiction: NYC. ROUTING: Use akil_dcwp_charges for charge/outcome records from inspections; use akil_business_licenses for issued DCWP licenses. Accepts: business name, keyword, category, inspection type/status, address anchors, BBL, BIN, borough, ZIP, council/community district, date range, lat/lon/radius. Returns: inspection number, certificate, business, category, raw and interpreted inspection status, date, address, BBL, BIN, district anchors, and map points when available. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations. Note: DCWP inspection status is an inspection-event signal, not blanket compliance clearance.
akil_dcwp_license_applications
ChatGPTCheck NYC consumer/business license application status for businesses such as cafes, restaurants, salons, dealers, laundries, employment agencies, and other DCWP-regulated activities. Jurisdiction: NYC. Accepts: business name, DBA, application ID, license number, license type/category, status, address, BBL, BIN, borough, ZIP, submission date range. Returns: raw and interpreted application status, license/application identifiers, business name/DBA, category/type, submitted/closed dates, address, BBL, BIN. Connects to: business licenses, restaurant inspections, SLA pending licenses, DOB permits, M/WBE records, organization lookup. Coverage: NYC Department of Consumer and Worker Protection license application records. Note: DCWP application status is a source workflow signal, not an issued license or full operating clearance.
akil_dob_complaints
ChatGPTSearch public-reported construction and building-safety complaints filed with DOB, including illegal work, work without permit, unsafe conditions, and illegal conversions. Jurisdiction: NYC. Accepts: keyword, BBL, BIN, borough, complaint category, status, entered-date range. Returns: complaint number, complaint category/description, status, date entered, inspection date, address, BIN/BBL, disposition code, borough/community board when available. Connects to: property search, building violations, building permits, DOB NOW permits, enforcement hearings, certificate of occupancy, nearby records. Coverage: NYC DOB complaint records. Note: A complaint is not a confirmed violation; connect to DOB violations and hearings for outcomes.
akil_dob_now_all_approved_permits
ChatGPTConfirm issued or approved DOB NOW permits across permit records, including renovations, build-outs, job filings, and trade work. Jurisdiction: NYC. Accepts: address/keyword, BBL, BIN, borough, ZIP, job filing number, work permit number, work type, approved/issued date range. Returns: work permit, job filing number, raw and interpreted work type, filing reason, issued/approved dates, address, BBL, BIN, estimated cost, floor, job description. Connects to: DOB NOW Build job filings, DOB NOW Build approved permits, building permits, certificate of occupancy, property records, business licensing workflows. Coverage: NYC DOB NOW approved permit records.
akil_dob_now_build_approved_permits
ChatGPTConfirm DOB NOW Build permits that were issued or signed off for construction, renovation, fit-out, plumbing, sprinkler, and other building work. Jurisdiction: NYC. Accepts: address/keyword, BBL, BIN, borough, ZIP, job filing number, work permit number, permit status, work type, owner, applicant license. Returns: raw and interpreted permit status where verified, work permit, job filing number, raw and interpreted work type, filing reason, address, BBL, BIN, owner, applicant, estimated cost, job description. Connects to: DOB NOW Build job filings, DOB NOW all approved permits, building permits, certificate of occupancy, property records. Coverage: NYC DOB NOW Build approved permit records.
akil_dob_now_build_job_filings
ChatGPTCheck DOB NOW Build job/application filing status before or around permit issuance, including plan exam, filing status, job type, owner, and applicant-license lookups. Jurisdiction: NYC. Accepts: address/keyword, BBL, BIN, borough, ZIP, job filing number, filing status, job type, owner, applicant license, filing date range. Returns: job filing number, raw and interpreted filing status where verified, raw and interpreted job type, filing/current-status dates, address, BBL, BIN, owner, applicant license, initial cost, proposed units, construction floor area. Connects to: DOB NOW Build approved permits, DOB NOW all approved permits, building permits, certificate of occupancy, property records. Coverage: NYC DOB NOW Build job filing records.
akil_eligibility_check
ChatGPTPreflight-check whether a provided organization profile appears to meet the stated requirements for one funding opportunity. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: grantId or opportunityNumber, orgName, orgType, budgetSize, state, city, focusAreas, populationsServed, certifications, yearsOperating. Returns: preflight eligibility signal, confidence, requirement-by-requirement statuses, missing information, gaps, and recommendation. Connects to: akil_grant_details, akil_extract_requirements, akil_match_grants, akil_search_grants, akil_org_lookup, akil_org_intelligence, akil_mwbe_search. Coverage: Requirement text from public funding opportunity records relevant to New York-based organizations. Note: This is not an official eligibility determination; UNCLEAR means more organization or source information is needed, not that the organization is ineligible.
akil_enforcement_hearings
ChatGPTSearch OATH Hearings Division Case Status records (NYC Open Data jz4z-kudi) across building, fire, health, sanitation, transportation, and other regulatory enforcement matters. Jurisdiction: NYC. Accepts: keyword, borough, bbl, block, lot, respondentName, issuingAgency, hearingStatus, violationType, dateAfter, dateBefore, limit, offset. Returns: respondent, issuing agency, raw hearing status plus interpreted lifecycle/open-signal, charge description, reported penalty/balance field, violation date, hearing date, location, and source metadata. Connects to: akil_building_violations, akil_business_licenses, akil_building_violation_record, akil_311_complaints, akil_property_search. Coverage: OATH Hearings Division Case Status (jz4z-kudi), not DOB ECB Violations (6bgk-3dad). Note: Pending, default, paid, written-off, appeal, and adjudicated statuses mean different things; reported penalty/balance fields can include contested, imposed, paid, or unresolved amounts and are not a standalone ECB balance_due reconciliation.
akil_entity_verification
ChatGPTVerify the entity thread before organization, nonprofit, vendor, certification, audit, funding, payment, or due-diligence synthesis. Jurisdiction: NYC + NYS + Federal (NY-relevant). ROUTING: Use this first when a user asks broadly about an organization, nonprofit, vendor, DBA, company, or EIN. Accepts: entityName, EIN, address, entityTypeHint, includeCandidateMatches. Returns: confirmed records, candidate matches, no-row findings, source limitations, anchors, identity-contract caveats, and recommended next checks. Connects to: akil_org_lookup, akil_nonprofit_profile, akil_nonprofit_registry, akil_audit_history, akil_mwbe_search, akil_funding_profile, akil_vendor_payments, akil_business_licenses. Coverage: NYC, NYS, and federal public records relevant to New York organizations. Note: This is a verification packet, not a narrative brief; no returned row is not proof the underlying fact is false. Name-only rows are candidates until confirmed by EIN, exact legal name/DBA, stable source ID, address, license/application ID, vendor/contract ID, or source record ID.
akil_environmental_data
ChatGPTNeighborhood-scale environmental monitoring, especially air quality indicators such as PM2.5, ozone, nitrogen dioxide, and sulfur dioxide. Jurisdiction: NYC. Accepts: keyword, type, geoType, geoPlace, indicatorId, year, limit, offset. Returns: indicator name, measure, value, geography type, geography place, time period, and start date when available. Connects to: community profile, community needs, brownfield sites, services by type, and grants search. Coverage: NYC Community Air Survey style neighborhood measurements. Note: These are ambient area measurements, not building-specific contamination findings or real-time readings.
akil_ethics_enforcement
ChatGPTSearch NYC Conflicts of Interest Board enforcement actions involving public servants, agencies, fines, settlements, and case identifiers. Jurisdiction: NYC. Accepts: keyword, agency, case-date range, pagination. Returns: case name/number, respondent or case label when available, agency, fine amount, case date, and source metadata. Connects to: COIB policymakers, official directory, payroll search, campaign finance, legal defense trusts, legal conflict scan. Coverage: NYC COIB enforcement records. Note: Fine size and case type matter; small late-filing penalties should not be treated the same as substantive conflicts of interest.
akil_evictions
ChatGPTSearch executed City Marshal evictions by borough, BBL, community board, council district, residential/commercial type, ZIP, keyword, or execution date range. Jurisdiction: NYC. Accepts: borough, bbl, communityBoard, councilDistrict, residentialCommercial, zip, keyword, dateAfter, dateBefore, limit, offset. Returns: eviction address, apartment when available, executed date, residential/commercial indicator, marshal, ejectment type, BBL, council/community district, ZIP, court index, and docket. Connects to: akil_hpd_litigations, akil_hpd_violations, akil_building_violation_record, akil_property_ownership, akil_re_owner_portfolio. Coverage: NYC City Marshal executed eviction records. Note: These are completed removals, not filings or pending cases; commercial and residential records can both appear.
akil_expense_budget
ChatGPTSearch expense budget line items by agency, fiscal year, personal-services/other-than-personal-services indicator, unit, budget code, object code, or keyword. Jurisdiction: NYC. Accepts: agency, fiscalYear, psOtps, unitName, budgetCode, keyword, limit, offset. Returns: agency, fiscal year, unit of appropriation, budget code, object code, PS/OTPS indicator, adopted amount, modified amount, financial plan amount, and publication date. Connects to: akil_budget_changes, akil_spending_by_category, akil_spending_trends, akil_agency_staffing, akil_budget_proposal, akil_budget_comparison. Coverage: NYC expense budget line-item records from the latest publication per agency and fiscal year. Note: This is budget authority, not actual spending; use spending tools for payments and vendor disbursements.
akil_expiring_contracts
ChatGPTFind contracts approaching their end date for rebid planning, renewal monitoring, or agency procurement-cycle research. Jurisdiction: NYC. Accepts: expiringWithinDays, agency, limit, offset. Returns: vendor, agency, current amount, end date, days until expiration, industry, and result counts. Connects to: akil_procurement_search, akil_checkbook_contracts, akil_vendor_payments, akil_sole_source_contracts, akil_spending_trends, akil_contract_amendments. Coverage: NYC Comptroller Checkbook contract records. Note: Default window is 180 days; an expiring contract is not automatically an open opportunity because the agency may rebid, extend, or end the work.
akil_facades_compliance
ChatGPTCheck Local Law 11 facade filing and safety status for buildings by BBL, address, BIN, borough, current status, keyword, or inspection cycle. Jurisdiction: NYC. Accepts: bbl, address, bin, borough, currentStatus, keyword, cycle, limit, offset. Returns: BIN, address, current facade status, filing status, cycle, TR6 number, penalties when available, BBL, and source metadata. Connects to: akil_building_violations, akil_building_violation_record, akil_building_permits, akil_property_search, akil_re_property_report. Coverage: NYC DOB facade inspection compliance filings. Note: This applies mainly to buildings over six stories; SWARMP means repair/maintenance is required, while Unsafe indicates an immediate facade hazard or protective measures.
akil_federal_audit_findings
ChatGPTDrill into individual Federal Audit Clearinghouse finding source rows within a Single Audit after identifying a report ID or audit year. Jurisdiction: Federal (NY-relevant). Accepts: report ID, audit year, material-weakness flag, questioned-costs flag, repeat-finding flag, result limit. Returns: report ID, audit year, auditee UEI, finding reference number, requirement type, award reference, material weakness/significant deficiency/questioned cost/repeat finding flags, reusable anchors, interpretation notes, and source metadata. Connects to: audit history for auditee name and overall audit status, compliance flags, nonprofit profile, organization intelligence, funding profile. Coverage: Federal Audit Clearinghouse finding-level records relevant to New York organizations. Note: Findings are pieces of a larger audit; use audit history for organization-level context. Cross-domain caveat: audit findings are raw provenance records and should not be described as fraud findings, final disallowances, or proof of total organization risk without the full report context.
akil_fin_distressed_signals
ChatGPTScan public-record property condition and financial stress indicators by borough or community district. Jurisdiction: NYC. Accepts: borough, communityDistrict, minScore, limit, offset. Returns: BBL, address, indicator score, HPD class counts, DOB unresolved counts, recent 311 counts, tax benefit expiration indicator, tax lien count, vacate order count, eviction count, owner text, units, building class, assessed value, and district fields. Connects to: building violation record, tax cliff scan, property charges, tax lien sales, vacate orders, evictions, HPD violations, DOB violations, and property report. Coverage: NYC parcel, HPD, DOB, 311, DOF, lien, vacate, and eviction indicators. Note: Scores are raw indicators and are not normalized by building size or unit count; review per-property records before drawing conclusions. For broad borough scans, narrow to a communityDistrict when possible because the full composite scan is intentionally response-budget guarded.
akil_foundation_recipients
ChatGPTFind organizations that received grants from a specific private foundation. Jurisdiction: Federal (NY-relevant). Accepts: funderEin, funderName, recipientKeyword, limit, offset. Returns: recipient name, recipient location, grant amount, purpose text, tax period, total shown amount, and result counts. Connects to: foundation search, nonprofit profile, nonprofit registry, organization intelligence, funding profile, and audit history. Coverage: IRS 990-PF private foundation grant records. Note: 990-PF grant data usually lags by one to two years; each row is a filing line item, not a lifetime relationship total.
akil_foundation_search
ChatGPTSearch private-foundation grant records by recipient keyword, purpose text, category, amount range, or filing year. Jurisdiction: Federal (NY-relevant). Accepts: keyword, category, minAmount, maxAmount, filingYear, limit, offset. Returns: recipient name, foundation name, grant amount, purpose, filing year, and source metadata. Connects to: foundation recipients, nonprofit profile, nonprofit search, funding profile, search grants, and organization lookup. Coverage: IRS 990-PF private foundation grant records. Note: Foundation priorities can change after the filing year; use this as historical grant evidence, not a guarantee of current funding interest.
akil_funder_profile
ChatGPTProfile a funding agency's posted opportunity history and current open opportunities. Jurisdiction: NYC + NYS + Federal. Accepts: name or acronym. Returns: resolved agency name, acronym, total opportunities, active opportunities, typical award floor/ceiling, focus areas, website, and metadata. Connects to: search grants, funding landscape, grant deadlines, spending trends, budget changes, top recipients, and vendor payments. Coverage: posted opportunity records from federal, NYC, and NYS funding sources where agency metadata is available. Note: Historical posting frequency and award ranges do not guarantee future schedules or award amounts.
akil_funding_landscape
ChatGPTSummarize currently posted open funding opportunities for a topic, not historical awards or contracts. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: focusArea, state, geography. Returns: active opportunity count, total posted award ceiling, geography breakdown, top funders, and filter metadata. Connects to: search grants, match grants, grant details, top recipients, vendor payments, capital projects, foundation recipients, and funding profile. Coverage: public posted opportunity records relevant to New York-based organizations. Note: Total posted funding is a sum of opportunity ceilings and should not be treated as actual spending, awarded money, or realistic expected award value.
akil_funding_profile
ChatGPTBuild an organization-level government funding profile across awards, council allocations, NYC payments, audits, lobbying, and M/WBE certification signals. Jurisdiction: NYC + NYS + Federal (NY-relevant). Accepts: organization name, optional EIN, optional agency filter. Returns: organization summary, award records, council funding records, payment records, audit records, lobbying records, M/WBE registry candidate records, source counts, and funding totals when available. Connects to: org lookup, vendor payments, checkbook contracts, top recipients, nonprofit profile, audit history, M/WBE search, lobbying tools. Coverage: NYC, NYS, and federal award, payment, audit, lobbying, and certification records relevant to New York. Note: Awards and contract registrations are not the same as actual payments; use vendor payments to verify disbursements. M/WBE rows are NYC SBS registry name-search candidates unless exact legal name or DBA is verified.
akil_geo_corridor
ChatGPTFind records along a line between two known coordinate points, such as a block, avenue segment, transit corridor, or route. Jurisdiction: NYC. Accepts: lat1, lon1, lat2, lon2, bufferMeters, dataset (canonical Akil dataset key; aliases such as 311 are normalized), limit. Returns: matching records ordered by distance from the corridor center line, corridor length, buffer size, canonical dataset key, and source dataset label. Connects to: property search or geo resolve for endpoint coordinates, point-to-districts, geo query, nearby records, and geo trend. Coverage: NYC geocoded datasets that support corridor search. Note: Resolve addresses/intersections to coordinates first; do not estimate coordinates from memory.
akil_geo_count
ChatGPTCount geocoded records from one NYC dataset inside a named administrative boundary without returning every record. Jurisdiction: NYC. Accepts: boundaryType (any of the 12 resolve_boundary layers; aliases such as zip or cd are normalized), boundaryId, dataset (canonical Akil dataset key; aliases such as 311 are normalized). Returns: total count, approximate flag/note when applicable, boundary label, canonical dataset key, dataset label. Connects to: geo query for records, geo trend for time series, compare scopes, boundary facts, boundary shape, map heatmaps. Coverage: NYC boundary layers and geocoded datasets. Metric note: Counts include only records with usable coordinates/boundary joins; raw counts are not rates or risk rankings without denominators.
akil_geo_hotspot
ChatGPTFind spatial clusters or hotspots in a selected NYC dataset within an optional boundary. Jurisdiction: NYC. Accepts: dataset (only the 9 cluster-enabled keys: shootings, motor_vehicle_collisions, hpd_violations, complaints_311, evictions, rodent_inspections, nypd_complaints, hpd_complaints, dob_violations; aliases such as 311 are normalized), boundaryType (any of the 12 resolve_boundary layers; aliases such as zip or cd are normalized), boundaryId, epsMeters, minPoints. Returns: ranked clusters with point counts, centroid latitude/longitude, and the canonical dataset key. Connects to: nearby records, point-to-districts, geo query, geo count, geo trend, and boundary shape. Coverage: NYC geocoded records for shootings, crashes, HPD/DOB violations, 311, evictions, rodent inspections, NYPD complaints, and HPD complaints. Metric note: Hotspots are algorithmic clusters over geocoded records, not official designations, causal findings, or normalized risk rankings.
akil_geo_polygon
ChatGPTReturn individual records from one geocoded NYC dataset inside a user-drawn or known GeoJSON polygon. Jurisdiction: NYC. Accepts: polygonGeoJSON (Polygon/MultiPolygon in longitude-latitude order), dataset (canonical Akil dataset key; aliases such as 311 are normalized), limit, maxAreaSqKm. Returns: matching records, polygon area, canonical dataset key, dataset label, dataset-specific anchors such as BBL/address/coordinates when available. Connects to: polygon stats, boundary shape, nearby records, geo query, property search, map artifacts. Coverage: NYC geocoded datasets. Note: Polygon coordinates should come from a map, geocoder, or boundary tool; do not guess irregular NYC shapes.
akil_geo_polygon_stats
ChatGPTAggregate records inside a user-drawn or known GeoJSON polygon for counts, breakdowns, and numeric sums. Jurisdiction: NYC. Accepts: polygonGeoJSON (Polygon/MultiPolygon in longitude-latitude order), dataset (canonical Akil dataset key; aliases such as 311 are normalized), groupByColumn, sumColumn, limit, maxAreaSqKm. Returns: total count, optional grouped breakdown, optional sum, polygon area, canonical dataset key, dataset label. Connects to: geo polygon for records, boundary shape, geo count, geo trend, map charts and summary cards. Coverage: NYC geocoded datasets. Note: Use this when the user asks how many, what breakdown, or total amount in a drawn area.
akil_geo_query
ChatGPTReturn individual records from one geocoded NYC dataset inside a named boundary such as council district, community district, precinct, borough, NTA, ZIP, census tract, school district, or health area. Jurisdiction: NYC. Accepts: boundaryType (any of the 12 resolve_boundary layers; aliases such as zip or cd are normalized), boundaryId, dataset (canonical Akil dataset key; aliases such as 311 are normalized), limit, orderBy (newest|none). Returns: records from the selected dataset, newest-first by the dataset's event date by default, canonical dataset key, with dataset-specific fields and anchors such as BBL, address, coordinates, event/date identifiers when available. Connects to: geo count, geo trend, boundary shape, point-to-districts, nearby records, property search, HPD/DOB/311/crime/eviction/rodent tools. Coverage: NYC boundary layers and geocoded datasets. Metric note: Returned records are a capped page of geocoded rows, not the total source universe; use geo count/trend for totals.
akil_geo_resolve
ChatGPTValidate a boundary identifier (council district, community district, NTA, ZIP and more) and get its metadata before spatial queries. Jurisdiction: NYC. Use for: Validating a boundary identifier and retrieving boundary metadata before a spatial query. Accepts: boundaryType (any of the 12 resolve_boundary layers: council_district, community_district, precinct, senate_district, assembly_district, congressional_district, school_district, borough, nta, zip_code, census_tract, health_area; aliases such as zip or cd are normalized), boundaryId. Returns: canonical boundary type, boundary ID, display label, centroid latitude/longitude, and area. Connects to: geo query, geo count, geo trend, boundary shape, point-to-districts, and compare scopes. Coverage: NYC administrative and statistical boundary layers. Note: Use point-to-districts when starting from coordinates; use this tool when you already have a boundary type and ID.
akil_geo_trend
ChatGPTCount records from one dataset inside one boundary over time by month, quarter, or year. Jurisdiction: NYC. Accepts: boundaryType (any of the 12 resolve_boundary layers; aliases such as zip or cd are normalized), boundaryId, dataset (only the 11 time-enabled keys: hpd_violations, complaints_311, nypd_complaints, evictions, dob_permits, dob_violations, shootings, motor_vehicle_collisions, restaurant_inspections, rodent_inspections, hpd_complaints; aliases such as 311 are normalized), interval, startDate, endDate. Returns: time series rows with period, count, complete/in-progress status, total records, canonical dataset key, and dataset label. Connects to: geo count, geo query, geo hotspot, compare scopes, community needs, and boundary facts. Coverage: NYC time-enabled geocoded datasets including 311, HPD, NYPD, DOB, evictions, shootings, crashes, restaurant inspections, rodents, and HPD complaints. Metric note: Trend buckets depend on date field/window and geocoded coverage; in-progress periods should not be read as completed declines.
akil_get_shelter_census
ChatGPTGet daily New York City Department of Homeless Services shelter census counts by date range. Jurisdiction: NYC. Accepts: dateAfter, dateBefore, limit, offset. Returns: census date, total individuals, adults, children, single adults, family counts, and summary statistics when available. Connects to: shelter trends, services by type, community needs, community profile, and grant searches for housing or homelessness programs. Coverage: NYC DHS shelter census snapshots. Metric note: This returns aggregate shelter counts, not locations, individual residents, eligibility decisions or a provider directory; counts are daily point-in-time DHS shelter snapshots and exclude people outside DHS shelter settings.
akil_gr_district_briefing
ChatGPTPlace-side briefing for a council district, community district, borough, or council-member geography. Jurisdiction: NYC. Accepts: district, borough, communityDistrict, councilMember, fiscalYear, limit, offset. Returns: community demographics, community needs indicators when the scope supports them, canonical Council discretionary funding records, capital projects, and source sections found. Connects to: community profile, community needs, council member profile, council district funding, council member funding summary, capital projects, vendor payments, and public-money trace. Coverage: NYC council districts, community districts, demographics, community indicators, canonical Council discretionary funding (MOCS-ID plus conservative fallback-deduped), and capital project records. Note: This is about place conditions and funding into a district; use council member tools for staff, bio, committees, caucuses, sponsorships, and votes. Council districts and community districts do not share the same boundaries. Funding totals come from the canonical Council funding layer (canonical_council_awards); this is a briefing/orchestrator, not a raw award aggregation — use akil_council_district_funding, akil_council_member_funding_summary, or akil_council_raw_source_records for dedicated answers.
akil_grant_deadlines
ChatGPTBuild a deadline calendar of open funding opportunities closing within a requested lookahead window. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: daysAhead, geography, limit, offset. Returns: opportunities sorted by close date with title, agency, opportunity number, deadline, award ceiling when available, geography, status, and source link. Connects to: akil_search_grants, akil_grant_details, akil_match_grants, akil_rolling_grants, akil_recently_changed_grants, akil_eligibility_check. Coverage: Public funding opportunity records relevant to New York-based organizations, defaulting to NYC and NYS when geography is omitted. Note: Default lookahead is 30 days; max lookahead is 365 days; rolling opportunities may have no fixed close date.
akil_grant_details
ChatGPTRetrieve the full record for one funding opportunity after it appears in search, match, deadline, or rolling-deadline results. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: id or opportunityNumber. Returns: title, agency, opportunity number, status, dates, award floor/ceiling, total funding when available, eligibility text, description, contact details, classification fields, and source links. Connects to: akil_search_grants, akil_extract_requirements, akil_eligibility_check, akil_similar_grants, akil_grant_diff, akil_funder_profile. Coverage: Public funding opportunity records relevant to New York-based organizations. Note: Deadlines and eligibility text come from source postings and should be checked against the current opportunity record before applying.
akil_grant_diff
ChatGPTCompare the current version of a funding opportunity to a prior version or to a provided previous opportunity record. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: grantId or opportunityNumber, optional previousGrantId. Returns: current and previous version labels, summary, and field-level changes for deadline, funding, eligibility, requirements, and other tracked fields when available. Connects to: akil_recently_changed_grants, akil_grant_details, akil_search_grants, akil_extract_requirements, akil_eligibility_check. Coverage: Versioned public funding opportunity records relevant to New York-based organizations. Note: If no prior version exists, the response can only show the current record.
akil_housing_data
ChatGPTDetailed HPD-financed affordable housing development records by borough, community district, developer, program group, county, or state. Jurisdiction: NYC. Accepts: borough, communityDistrict, developer, programGroup, county, state, limit, offset. Returns: project name, address, borough, total units, affordable units, program group, building type, developer, and completion/status fields when available. Connects to: housing search, building permits, community profile, community needs, capital projects, and property search. Coverage: HPD affordable housing development records. Note: This is HPD-financed affordable housing only; it does not represent all market-rate or privately financed development.
akil_housing_search
ChatGPTFast keyword or borough search across HPD-financed affordable housing developments. Jurisdiction: NYC. Accepts: keyword, borough, limit, offset. Returns: project name, developer, borough, unit count, program group, and project status when available. Connects to: housing data, building permits, community profile, community needs, capital projects, and property search. Coverage: HPD affordable housing development records. Note: Same underlying coverage as the detailed housing tool, with a simpler search surface for quick discovery.
akil_hpd_complaints
ChatGPTSearch tenant-reported housing complaints filed with HPD, including heat/hot water, plumbing, paint/plaster, pests, water leaks, and other housing conditions. Jurisdiction: NYC. Accepts: keyword, BBL, borough, community district, complaint type, status, received-date range. Returns: complaint ID with each reported problem (problem ID, category/type/code, problem status), complaint status, received/closed dates, address, ZIP, BBL, borough, community district when available, plus complaint counts by status and problem counts by category. Connects to: property search, HPD violations, 311 complaints, property ownership, building violation record, evictions, rodent inspections, nearby records. Coverage: NYC HPD housing complaint records. Note: Complaints are reports, not findings; use HPD violations for inspector-confirmed code violations. One complaint can list several problems: complaint counts and problem counts differ.
akil_hpd_litigations
ChatGPTSearch HPD Housing Litigation Division cases by borough code, BBL, block/lot, building ID, case type, case status, harassment finding, respondent, council district, keyword, or case-open date range. Jurisdiction: NYC. Accepts: boroid, bbl, block, lot, buildingId, casetype, casestatus, findingofharassment, respondent, councilDistrict, keyword, dateAfter, dateBefore, limit, offset. Returns: litigation ID, case type, status, respondent, open/judgment dates, harassment finding, penalty, address, BBL, building ID, apartment, and districts. Connects to: akil_hpd_violations, akil_hpd_complaints, akil_evictions, akil_building_violation_record, akil_property_ownership. Coverage: NYC HPD Housing Litigation records. Note: No Harassment means harassment was not found; After Inquest or After Trial means a harassment finding was recorded.
akil_hpd_violations
ChatGPTFind inspector-issued housing code violations for residential buildings, including Class A, Class B, and Class C violations. Jurisdiction: NYC. Accepts: keyword, BBL, borough, community district, violation class, status, inspection-date range. Returns: violation ID/order number, BBL/address, violation class, raw current_status plus interpreted lifecycle/open-signal, inspection/approved dates, description, registration/building identifiers when available. Connects to: property search, HPD complaints, DOB building violations, building violation record, property ownership, evictions, vacate orders, nearby records. Coverage: NYC HPD housing violation records. Note: Class C is immediately hazardous; open/current status matters more than lifetime totals. INTERPRETATION: current_status is HPD workflow state; dismissed/closed rows should not be treated as open compliance items.
akil_land_use_search
ChatGPTSearch ZAP/ULURP land-use and zoning projects by applicant, borough, status, community district, project type, keyword, or certification date range. Jurisdiction: NYC. ROUTING: Use for land-use applications, public-review projects, rezonings, and ULURP/ZAP context; do not use this as the first tool for parcel zoning. For an address or BBL zoning question, resolve BBL with akil_property_search and then use akil_parcel_land_use_evidence. Accepts: keyword, applicant, borough, status, communityDistrict, ulurpType, certifiedAfter, certifiedBefore, limit, offset. Returns: project name/ID, applicant, applicant type, status, milestone, borough, community district, ULURP/CEQR numbers, actions, filing/certification/completion dates, and project brief when available. EMITS ANCHORS: projectId, ULURP number, CEQR number, applicant, borough, communityDistrict. CHAIN TO: akil_parcel_land_use_evidence, akil_zoning_tax_lots, akil_zoning_features, akil_bp_ulurp_recommendations, akil_public_hearings, akil_property_search, akil_org_lookup. Coverage: NYC DCP ZAP/ULURP project records. Note: Early-stage land-use applications can change or be withdrawn; completed status does not by itself reveal approval outcome.
akil_landmarks
ChatGPTCheck whether a property, address, historic district, architect, or landmark name appears in NYC Landmarks Preservation Commission records. Jurisdiction: NYC. Accepts: boroughId, bbl, lmType, histDistr, status, keyword, dateAfter, dateBefore, limit, offset. Returns: landmark name, LP number, type, address, BBL, borough, historic district, status, designation date, calendar date, architect, style, building type, year built, block/lot, and districts. Connects to: akil_property_search, akil_building_permits, akil_re_property_report, akil_certificate_of_occupancy, akil_land_use_search. Coverage: NYC LPC designated and calendared landmark records. Note: DESIGNATED records create legal review requirements; CALENDARED records indicate consideration and should not be treated as final designation.
akil_legal_defense_trusts
ChatGPTSearch legal defense trust disclosures for elected officials or candidates, including trust registrations, contributions, expenditures, counterparties, amounts, purposes, and dates. Jurisdiction: NYC. Accepts: keyword, trust name, record type, counterparty, result limit. Returns: trust name, record type, record name, counterparty, amount, purpose, date, location, and source metadata. Connects to: campaign finance, ethics enforcement, CFB financial summaries, council member profile, legal conflict scan. Coverage: NYC legal defense trust disclosure records. Note: Legal defense trusts are separate from campaign committees and do not include underlying legal-case details.
akil_lobbying_by_subject
ChatGPTSearch lobbying registrations by policy topic, issue, activity text, or subject area across city and state lobbying records. Jurisdiction: NYC + NYS. Accepts: subject keyword, optional reporting year, pagination. Returns: lobbyist or lobbying firm, client, subject/activity text, reported compensation when available, reporting year, and source metadata. Connects to: who lobbies agency, who lobbies council member, organization lookup, campaign finance, council legislation, agency rules, public hearings. Coverage: NYC eLobbyist and NYS lobbying registration records relevant to New York. Note: Subject text is self-reported and may vary by filer; use broad keywords for discovery. Identity note: lobbying client, principal lobbyist or firm, individual lobbyist, party lobbied, and subject text are separate source roles.
akil_match_grants
ChatGPTRank open funding opportunities against an organization profile, mission, geography, populations served, certifications, budget size, or business sector. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: mission, focusAreas, geography, budgetMin, budgetMax, orgName, orgType, budgetSize, populationsServed, certifications, state, city, naicsCode, limit. Returns: ranked opportunities with fit score, match reasons, deadlines, award amounts, geography, categories, and possible fit concerns. Connects to: akil_search_grants, akil_grant_details, akil_eligibility_check, akil_extract_requirements, akil_org_lookup, akil_org_intelligence, akil_funding_profile. Coverage: Open public funding opportunity records relevant to New York-based organizations. Note: Match scores are directional discovery aids, not eligibility determinations.
akil_mayor_data
ChatGPTReview Mayor's Office funding, contracts, budget lines, sub-office activity, and mayoral officeholder context by vendor, fiscal year, mayor, sub-office, or data type. Jurisdiction: NYC. Accepts: searchVendor, fiscalYear, mayor, subOffice, dataType, limit, offset. Returns: officeholder history, sub-office summary, year trend, contracts, budget lines, contract period, award method, and data notes when available. Connects to: akil_vendor_payments, akil_spending_trends, akil_budget_changes, akil_expense_budget, akil_top_recipients, akil_org_intelligence. Coverage: NYC Mayor's Office budget and contract records. Note: This is office-level activity, not all spending directed by city agencies under a mayoral administration.
akil_mobile_food_vending
ChatGPTCheck raw mobile food vending hearing, violation, penalty, and compliance records for food carts, vendors, popups, and street-food due diligence. Jurisdiction: NYC. ROUTING: Source records are mostly borough-level and do not provide exact addresses; use restaurant/DCWP/property tools for premises-specific checks. Accepts: vendor/respondent keyword, borough, hearing status/result, compliance status, date range. Returns: ticket number, respondent name, borough, violation/hearing dates, charge text, penalty/payment fields, hearing result, and compliance status. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations. Note: these are raw enforcement/hearing records, not a premises-specific vending license roster or legal siting clearance.
akil_motor_vehicle_collisions
ChatGPTSearch traffic crash incidents by borough, ZIP, contributing factor, keyword, date range, or fatal-only filter. Jurisdiction: NYC. Accepts: borough, zip, contributingFactor, keyword, dateAfter, dateBefore, fatalOnly, limit, offset. Returns: collision ID, date, location, injuries and fatalities by person type, contributing factors, vehicle types, borough, and ZIP when available. Connects to: nearby records, community needs, crime data, geo query, and geo count. Coverage: NYPD motor vehicle collision records. Note: Each row is one crash incident, not one person or vehicle; location fields may be incomplete for highways or older records.
akil_mwbe_search
ChatGPTFind or checking NYC-certified M/WBE vendors by business name, DBA, industry, specialization, certification type, borough, county, or state. Jurisdiction: NYC. Accepts: keyword, certification type, borough, county, state, pagination. Returns: organization name, DBA, certification type, ethnicity category when listed, industry sector, NAICS codes, business description, city/state, borough. Connects to: org lookup, funding profile, vendor payments, checkbook contracts, procurement search, business licenses. Coverage: NYC Small Business Services M/WBE certification records. Note: Absence from this registry means no matching NYC SBS certification record was found; it is not a statement about ownership. NYC SBS excludes not-for-profit organizations from M/WBE certification eligibility. Regulatory note: Certification rows are source-registry signals, not proof of capacity, endorsement, award eligibility, or contract award.
akil_nearby
ChatGPTFind geocoded records within a radius of a known point for property context, site diligence, neighborhood conditions, and map views. Jurisdiction: NYC. Accepts: lat, lon (decimal degrees), radiusMeters, tableName (canonical Akil dataset key, one of the 15 nearby-enabled tables; aliases such as 311 are normalized), limit. Returns: matching records from the selected collection ordered by distance, distance in meters, canonical dataset key, and dataset-specific anchors such as BBL, address, or event IDs when available. Connects to: property search for address-to-coordinate resolution, point-to-districts, property report, HPD/DOB/311/crime/eviction/rodent/brownfield tools, map views. Coverage: NYC geocoded datasets. Note: Results include only records with usable coordinates; broaden radius or change dataset if results are sparse.
akil_neighborhood_composition
ChatGPTACS 2020-2024 5-year composition estimates for one NYC neighborhood (2020 NTA): race/Hispanic origin, age including under-18 population, poverty including under-18 poverty, and income — every value with its published margin of error. Jurisdiction: NYC. ROUTING: Use this for what a NEIGHBORHOOD'S residents look like; use akil_community_profile for community-district profiles, akil_school_briefing for one school including its school-vs-neighborhood side-by-side, and akil_point_to_districts to turn coordinates into an NTA code first. Accepts: nta (2020 NTA code like BK0201, or a neighborhood name to search), lat/lon (resolved to the containing NTA), category or variable for the full variable list beyond the headline profile, view=catalog, limit, offset. Returns: headline composition profile — total population, under 18, the mutually exclusive race/Hispanic-origin groups, population below poverty overall and under 18, median household income — each as estimate, margin of error (90 percent confidence), percent, percent MOE and coefficient of variation exactly as DCP published them, plus access to all 237 profile variables. Connects to: akil_school_briefing, akil_community_profile, akil_point_to_districts, akil_community_needs, akil_school_search. Coverage: 262 2020-vintage NTAs, ACS 2020-2024 5-year estimates (DCP Population FactFinder processing). Notes: these are survey estimates of residents with MOEs — not counts, not school enrollment, and never a ranking or sort key; composition is context and no conclusion about a school or neighborhood follows from composition alone; blank published cells are null, not zero; small-area MOEs can be large — check MOE and CV before treating two areas as different; 2010-vintage NTA codes (for example in the LCGMS school directory) do not match 2020 codes. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_nonprofit_profile
ChatGPTView IRS 990 financial profile records for a specific nonprofit or filtered nonprofit set by name, EIN, keyword, state, NTEE code, or revenue range. Jurisdiction: Federal (NY-relevant). Accepts: organization name, EIN, keyword, state, NTEE code, minimum/maximum revenue, pagination. Returns: organization name, EIN, location, NTEE code, filing year, revenue, expenses, assets, executive compensation when available, and source metadata. Connects to: org lookup, nonprofit search, funding profile, audit history, organization intelligence, top recipients, grant matching. Coverage: IRS 990 nonprofit profile and financial records. Note: Use EIN for the cleanest match when the user knows it.
akil_nonprofit_registry
ChatGPTSearch New York State nonprofit registration/corporate filing records by organization name, county, or status. Jurisdiction: NYS. Accepts: name, county, status, limit, offset. Returns: raw NYS DOS source rows with organization name, DOS ID, entity type, county, filing date, identity caveats, result counts, and source metadata when available. Connects to: entity verification, nonprofit profile, nonprofit search, organization intelligence, organization lookup, audit history, compliance flags, and funding profile. Coverage: New York State Department of State nonprofit registry records. Note: State registration is a legal filing record; it does not prove current program activity, IRS tax-exempt status, 501(c)(3) status, or financial condition. Do not merge NYS DOS rows with IRS, award, payment, license, or lobbying rows by name alone.
akil_nonprofit_search
ChatGPTFind tax-exempt organizations by name, mission keywords, NTEE classification, location, IRS subsection, or revenue range. Jurisdiction: Federal (NY-relevant). Accepts: keyword, NTEE code, state, city, revenue minimum/maximum, subsection, pagination. Returns: raw IRS 990 nonprofit profile rows with EIN, name, city/state, NTEE code, subsection, revenue, expenses, assets, executive compensation when available, latest filing year, ruling date, identity caveats, and source metadata. Connects to: org lookup, entity verification, nonprofit profile, audit history, funding profile, grant search/matching, organization intelligence. Coverage: IRS 990 nonprofit profile records focused on New York and nearby organizations. Note: IRS 990 data can lag because of filing and processing timelines; show the filing year with financial figures. Name-only matches are candidates until confirmed by EIN or exact legal/source identity.
akil_nycha_developments
ChatGPTNYCHA public housing development directory lookup by borough, community district, council district, program, senior-development flag, or development-name keyword. Jurisdiction: NYC. Accepts: borough, communityDistrict, councilDistrict, program, seniorDevelopment, keyword, limit, offset. Returns: development name, program, apartment count, population, buildings, stories, address fields, borough, political districts, completion fields, rent fields, and senior flag when available. Connects to: community profile, community needs, capital projects, 311 complaints, and HPD violations. Coverage: NYC NYCHA development directory records. Note: NYCHA records generally do not provide BBL-level or apartment-level data, so use district/address anchors instead.
akil_nys_abo_procurement
ChatGPTSearch Authorities Budget Office procurement contracts for IDAs, local development corporations, and local authorities. Jurisdiction: NYS. Accepts: source, searchKeyword, authority, vendor, fiscalYear, procurementType, minAmount, limit. Returns: vendor, authority, procurement description, contract amount, fiscal-year spending, procurement type, award process, award date, vendor location, and counts. Connects to: state authority procurement, MTA procurement, SUCF contracts, OGS vendor payments, contractor registry, DBE certifications, and NYS entity profile. Coverage: NYS ABO IDA, LDC, and local authority procurement records. Regulatory note: Authority procurement rows are source-reported authority contract records, not endorsements, performance ratings, responsibility determinations, proof of current work, or proof money was paid unless the row has an expended/payment field.
akil_nys_active_corps
ChatGPTResolve New York corporate and LLC registration source rows by entity name, DOS ID, county, or entity type. Jurisdiction: NYS. Accepts: entityName, dosId, county, entityType, limit. Returns: current entity name, DOS ID, entity type, filing date, county, jurisdiction, service address, result counts, reusable anchors, interpretation notes, and metadata. Connects to: NYS entity profile, contractor registry, DBE certifications, campaign finance contributions, lobbying clients, nonprofit registry, and organization lookup. Coverage: New York Department of State active corporations registry. Note: At least one filter is required; use legal-name variants and native DOS IDs before treating a miss as meaningful. Cross-domain caveat: corporation rows are raw provenance records, not proof that a similarly named NYC vendor, nonprofit, lobbying client, property owner, or campaign actor is the same entity.
akil_nys_attorney_registry
ChatGPTSearch New York attorney registration source rows by exact last name, first-name prefix, keyword, status, year admitted, judicial department, or law school. Jurisdiction: NYS. Accepts: searchKeyword, lastName, firstName, status, yearAdmitted, judicialDepartment, lawSchool, limit. Returns: attorney name, registration number, status, year admitted, judicial department, law school, next registration, reusable anchors, interpretation notes, and source metadata. Connects to: official directory, NYS active corporations, NYS entity profile, lobbying clients, campaign finance contributions, and legal connection scan. Coverage: NYS Unified Court System attorney registration records. Note: Status is a registration field; verify disciplinary details through official court records where needed. Regulatory note: Attorney registration rows are raw provenance source-status signals, not proof of availability, competence, endorsement, legal advice, or complete disciplinary history.
akil_nys_authority_salaries
ChatGPTSearch employee compensation records at New York state authorities by authority, title, last name, fiscal year, salary, or total compensation. Jurisdiction: NYS. Accepts: searchKeyword, authority, lastName, title, fiscalYearEnd, minSalary, minTotalComp, limit. Returns: employee name, title, authority, fiscal year end, base salary, overtime, extra pay, bonus, total compensation, counts, and metadata. Connects to: state authority procurement, MTA procurement, ABO procurement, official directory, payroll search, and agency staffing. Coverage: NYS Authorities Budget Office compensation records. Regulatory note: Authority salary rows are compensation records for a source fiscal period, not full employment history, current employment, misconduct/performance signals, or proof of procurement influence.
akil_nys_cdbg_contracts
ChatGPTSearch NYS Community Development Block Grant contracts by recipient, project year, status, type, county, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, recipient, year, status, projectType, county, limit. Returns: recipient, recipient type, contract amount, project name, project type, project year, county, status, counts, and metadata. Connects to: search grants, funding landscape, NYSCA grants, state authority procurement, CDBG-related district analysis, and nonprofit profile. Coverage: NYS Homes and Community Renewal CDBG contract records. Note: These are state-administered CDBG contract records, not all federal CDBG activity or all NYC funding.
akil_nys_cf_contributions
ChatGPTSearch donations to New York State candidates and political committees by donor, filer, committee, year, contributor type, location, amount, or date. Jurisdiction: NYS. Accepts: searchKeyword, filerId, contributor, candidateCommittee, electionYear, contributorType, state, city, minAmount, dateAfter, dateBefore, limit. Returns: donor, receiving committee, amount, contributor type, election year, date, donor location, filing label, counts, and metadata. Connects to: NYS campaign finance filers, NYS campaign expenditures, NYS active corporations, NYS entity profile, lobbying clients, and NYC campaign finance. Coverage: NYS Board of Elections campaign contribution records. Note: NYC CFB records are separate; use the NYC campaign finance tool for city races.
akil_nys_cf_expenditures
ChatGPTSearch New York State campaign expenditure source rows by payee, filer, committee, year, state, amount, or date. Jurisdiction: NYS. Accepts: searchKeyword, filerId, payee, candidateCommittee, electionYear, state, minAmount, dateAfter, dateBefore, limit. Returns: spending committee, payee, amount, payment type, purpose text, election year, date, payee location, reusable anchors, counts, interpretation notes, and metadata. Connects to: NYS campaign finance filers, NYS campaign contributions, NYS active corporations, NYS entity profile, lobbying clients, and NYC campaign finance. Coverage: NYS Board of Elections campaign expenditure records. Note: Expenditure purpose text comes from filings and may be broad or abbreviated. Cross-domain caveat: payee/vendor names, candidate committees, filers, treasurers, and corporate entities are separate roles unless filer IDs, legal names, addresses, or source record IDs connect them.
akil_nys_cf_filers
ChatGPTLook up New York State campaign finance filer source rows for candidates, committees, PACs, treasurers, county, and committee type. Jurisdiction: NYS. Accepts: searchKeyword, status, filerType, committeeType, county, limit. Returns: filer name, filer ID, filer type, committee type, status, county, municipality/subdivision, treasurer, reusable anchors, interpretation notes, counts, and metadata. Connects to: NYS campaign contributions, NYS campaign expenditures, NYS district intel, lobbying clients, active corporations, and NYC campaign finance. Coverage: NYS Board of Elections filer registry. Note: Use native filer ID for precise contribution and expenditure searches. Cross-domain caveat: filer, candidate, committee, treasurer, donor, and payee are separate source roles and should not be merged by name alone.
akil_nys_child_care
ChatGPTSearch regulated child care programs by facility, provider, program type, county, city, status, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, facilityName, providerName, programType, county, city, status, limit. Returns: facility name, provider name, program type, status, facility ID, city, county, phone, and capacity fields when available. Connects to: services by type, school search, nonprofit search, grant search, and NYS child welfare programs. Coverage: New York State OCFS child care program records. Note: Capacity and status fields are administrative records and do not guarantee current openings.
akil_nys_child_welfare
ChatGPTSearch OCFS-funded child welfare and community service program records by agency, program type, funding source, city, minimum funding, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, agency, programType, fundingSource, city, minFunding, limit. Returns: funded agency, funding level, program type, funding source, contract number, contract dates, city, state, and ZIP when available. Connects to: child care programs, mental health programs, nonprofit search, funding profile, award history, and grant search. Coverage: New York State OCFS child welfare and community service funding records. Note: Funding records show program support and contracts; they are not a live directory of service availability.
akil_nys_contractor_registry
ChatGPTCheck New York contractor registry records, debarment flags, wage assessments, labor/tax violations, safety violations, M/WBE ownership, and registration status. Jurisdiction: NYS. Accepts: searchKeyword, businessName, businessType, status, city, debarredOnly, wageViolationOnly, mwbeOnly, limit. Returns: business name, DBA, certificate number, business type, status, location, worker compensation flag, compliance flags, counts, and metadata. Connects to: NYS entity profile, active corporations, DBE certifications, state authority procurement, MTA procurement, SUCF contracts, and vendor comparison profile. Coverage: NYS Department of Labor contractor registry. Note: Flags are registry indicators and should be checked against official records before making a legal conclusion. Regulatory note: Contractor registry rows and compliance flags are public source indicators, not final legal conclusions, responsibility determinations, or full procurement clearance.
akil_nys_dbe_certifications
ChatGPTSearch New York Disadvantaged Business Enterprise certification records by company, commodity code, location, county, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, companyName, commodityCode, city, state, county, limit. Returns: company name, business description, address, county, phone, email, commodity codes, counts, and metadata. Connects to: M/WBE search, contractor registry, NYS entity profile, active corporations, state authority procurement, MTA procurement, and vendor comparison profile. Coverage: NYS DOT Unified Certification Program DBE records. Note: DBE and NYC M/WBE are related but distinct certification programs. Regulatory note: DBE certification rows are source-registry signals, not proof of capacity, endorsement, award eligibility, or contract award.
akil_nys_dec_permits
ChatGPTSearch New York environmental permit applications by applicant, facility, permit type, status, municipality, keyword, or received date. Jurisdiction: NYS. Accepts: searchKeyword, applicant, facility, permitType, status, townOrCity, dateAfter, limit. Returns: applicant, facility, application ID, permit type, status, description, municipality, received/effective dates, SEQRA class/determination, counts, and metadata. Connects to: brownfield sites, environmental data, land use search, property search, business licenses, and NYS entity profile. Coverage: NYS Department of Environmental Conservation DART permit records. Regulatory note: DEC permit application rows are source permit-application records, not environmental clearance, contamination findings, cleanup completion, legal advice, or approval under unrelated programs.
akil_nys_district_intel
ChatGPTRetrieve NYSCA arts grant records tagged with a specified New York State Senate or Assembly district. Read-only. Accepts senateDistrict, assemblyDistrict and limit. Returns grantee, grant year, project, program, city, county and source-reported amount, grouped separately by requested district type. Subtotals cover only displayed records; the same grant may appear in both district sections. Reports unavailable queries separately from searches with no matches. Coverage is limited to district-tagged NYSCA arts grants; this is not a complete district spending profile, constituent profile or political-targeting tool. Use akil_nys_nysca_grants for further grant searches.
akil_nys_dot_highway_permits
ChatGPTSearch New York State DOT highway work permits by applicant, county, municipality, route, permit type, fiscal year, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, applicant, county, municipality, route, permitType, fiscalYear, limit. Returns: applicant, permit number, work description, permit type, route, municipality, county, region, approval date, expiration date, fiscal year, counts, and metadata. Connects to: DEC permits, construction pipeline, state authority procurement, contractor registry, active corporations, and property search. Coverage: NYS DOT state highway work permit records. Regulatory note: DOT highway work permit rows cover state-highway work permissions only; they are not local street permits, NYC DOB permits, proof that work occurred, proof of completion, traffic-control clearance, or site-safety clearance.
akil_nys_entity_profile
ChatGPTCross-reference a New York entity name across state campaign finance, state-authority procurement, NYSCA grants, contractor registry, and DBE certification candidate records. Jurisdiction: NYS. Accepts: entityName, limit. Returns: sectioned matches for contributions, expenditures, state authority contracts, NYSCA grants, contractor registry records, DBE registry candidate records, counts, omitted-section notes when a source is slow, and metadata. Connects to: NYS active corporations, NYS lobbying clients, NYS campaign finance tools, state authority procurement, NYSCA grants, contractor registry, DBE certifications, and NYC organization intelligence. Coverage: selected NYS public records keyed by organization/entity name. Note: Name matching is string-based; use legal-name and alias searches before treating absence as meaningful. Sections are candidate matches until source identifiers confirm the entity.
akil_nys_liquor_licenses
ChatGPTCheck active liquor licenses for restaurants, bars, cafes, grocery stores, wholesalers, and other alcohol-selling premises. Jurisdiction: NYS. Accepts: legal/business name, license class/description, city, county, ZIP, active-only flag. Returns: raw and interpreted active SLA license class/type, legal name, premises address, city, county, permit/license ID, original issue date, and expiration date. Connects to: SLA pending licenses, restaurant inspections, business licenses, DCWP license applications, organization lookup. Coverage: New York State Liquor Authority active license records. Note: Active-feed membership, class/type, and expiration date are source-record signals, not legal advice or blanket operating clearance.
akil_nys_lobbying_clients
ChatGPTSearch New York lobbying client semiannual filings by client, lobbyist, subject, government body, or reporting year. Jurisdiction: NYS. Accepts: clientName, lobbyistName, subject, governmentBody, reportingYear, limit. Returns: client, reporting year/period, principal lobbyist, compensation, subjects, government body, focus type, counts, and metadata. Connects to: NYS lobbying drilldown, active corporations, NYS entity profile, campaign finance contributions, public corporation lobbying, who lobbies agency, and who lobbies member. Coverage: NYS Commission on Ethics and Lobbying in Government client semiannual filing records. Note: At least one filter is required; use drilldown for tighter per-period detail. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_nys_lobbying_drilldown
ChatGPTPer-filing lobbying detail after a client, lobbyist, individual lobbyist, party lobbied, year, or period has been identified. Jurisdiction: NYS. ROUTING: Use akil_nys_lobbying_clients first for client semiannual summaries; use this for guarded live bimonthly detail. Accepts: clientName, lobbyistName, individualLobbyist, partyLobbied, reportingYear, reportingPeriod, limit. Returns: client, reporting year/period, principal lobbyist, individual lobbyist, party lobbied, subjects, compensation, expenses, counts, source provenance, and metadata. Connects to: NYS lobbying clients, open-data discovery, active corporations, NYS entity profile, campaign finance contributions, public corporation lobbying, who lobbies agency, and who lobbies member. Coverage: NYS lobbying bimonthly disclosure records. Note: reportingYear and a name/party filter are required because the dataset is very large. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_nys_master_contract_vars
ChatGPTLook up New York master-contract value-added resellers by prime vendor, reseller, master contract ID, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, masterContractVendor, varVendor, masterContractId, limit. Returns: master contract vendor, master contract ID, reseller vendor, reseller ID, contract description, counts, and metadata. Connects to: OGS vendor payments, state authority procurement, MTA procurement, contractor registry, active corporations, and NYS entity profile. Coverage: NYS master contract value-added reseller records. Regulatory note: Master-contract VAR rows identify authorized reseller or prime-vendor relationships, not purchase orders, agency use, payments, exclusivity, or endorsement.
akil_nys_mh_programs
ChatGPTSearch OMH-licensed mental health programs by sponsor, program type, category, county, region, population served, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, sponsorName, programType, programCategory, county, region, populations, limit. Returns: sponsor, agency, program name, facility name, program type/category, populations served, operating-certificate indicator, county, and region. Connects to: nonprofit search, funding profile, grant search, services by type, and child welfare programs. Coverage: New York State OMH mental health program records. Note: This identifies licensed programs and service categories; it does not confirm appointment availability or payer acceptance.
akil_nys_mta_procurement
ChatGPTSearch MTA procurement contracts by vendor, fiscal year, procurement type, M/WBE flag, amount, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, vendor, fiscalYear, procurementType, mwbeOnly, minAmount, limit. Returns: vendor, procurement description, contract amount, procurement type, status, begin/end dates, M/WBE indicator, counts, and metadata. Connects to: state authority procurement, ABO procurement, SUCF contracts, OGS payments, contractor registry, DBE certifications, and NYS entity profile. Coverage: MTA procurement contract records. Regulatory note: MTA procurement rows are source-reported contract records, not endorsements, performance ratings, responsibility determinations, proof of current work, or proof money was paid unless the row has an expended/payment field.
akil_nys_nysca_grants
ChatGPTSearch NYSCA arts grant award source rows by grantee, year, program, county, legislative district, amount, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, grantee, year, program, county, senateDistrict, assemblyDistrict, minAmount, limit. Returns: grantee, grant amount, year, program, category, project title, city, county, senate district, assembly district, reusable anchors, counts, interpretation notes, and metadata. Connects to: NYS district intel, funding landscape, search grants, nonprofit profile, NYS entity profile, and campaign finance tools. Coverage: New York State Council on the Arts grant award records. Note: District filters are useful for state legislative analysis but do not imply legislator sponsorship. Cross-domain caveat: NYSCA grant awards are raw provenance award/allocation records, not contracts, payments, future eligibility, or proof that a similarly named NYC recipient is the same legal entity.
akil_nys_ogs_vendor_payments
ChatGPTSearch New York OGS Design and Construction vendor payments by vendor, contract number, fiscal year, service type, county, amount, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, vendor, contractNumber, fiscalYear, serviceType, county, minAmount, limit. Returns: vendor, payment amount, fiscal year, quarter, contract number, service type, county, counts, and metadata. Connects to: state authority procurement, MTA procurement, ABO procurement, SUCF contracts, contractor registry, active corporations, and NYS entity profile. Coverage: NYS Office of General Services vendor payment records. Regulatory note: Vendor payment rows are disbursement records, not contract ceilings, award allocations, full project budgets, or proof of total vendor relationship by themselves.
akil_nys_public_corp_lobbying
ChatGPTSearch lobbying disclosures filed by New York public corporations and public benefit corporations. Jurisdiction: NYS. Accepts: searchKeyword, name, reportingYear, reportingPeriod, governmentLevel, limit. Returns: public corporation name, reporting year/period, business nature, in-house lobbyist, government level, lobbying type, compensation, expenses, subjects, counts, and metadata. Connects to: NYS lobbying clients, NYS lobbying drilldown, state authority procurement, MTA procurement, official directory, and who lobbies agency/member. Coverage: NYS public corporation lobbying disclosure records. Note: This covers public-corporation filings; use NYS lobbying clients for private-sector lobbying filings.
akil_nys_re_appraisers
ChatGPTSearch New York licensed real estate appraisers by name, business, county, license type, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, name, businessName, county, licenseType, limit. Returns: applicant name, license type, UID, business name, business address, county, certification date, expiration date, counts, and metadata. Connects to: NYS real estate licensees, NYS real estate offices, property search, comparable sales, owner portfolio, and active corporations. Coverage: NYS Department of State real estate appraiser license records. Note: Use expiration date and license type before describing current authorization. Regulatory note: Appraiser rows are source-status signals, not proof of current availability, competence, endorsement, valuation quality, or full legal clearance.
akil_nys_re_licensees
ChatGPTSearch New York licensed real estate salespersons and associate brokers by holder name, business, license type, city, county, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, holderName, businessName, licenseType, city, county, limit. Returns: license holder name, license type, license number, brokerage/business, business address, expiration date, counts, and metadata. Connects to: NYS real estate offices, NYS real estate appraisers, property search, owner portfolio, active corporations, and business licenses. Coverage: NYS Department of State real estate salesperson and broker license records. Note: Use real estate offices for firm-level searches and appraisers for appraisal credentials. Regulatory note: A licensee row is a source-status signal, not proof of current availability, endorsement, brokerage identity by name alone, or full legal clearance.
akil_nys_re_offices
ChatGPTSearch licensed New York real estate offices and brokerages by business name, city, county, license type, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, businessName, city, county, licenseType, limit. Returns: business name, license type, license number, address, city, state, ZIP, county, counts, and metadata. Connects to: NYS real estate licensees, NYS real estate appraisers, active corporations, property search, owner portfolio, and business licenses. Coverage: NYS Department of State real estate office/brokerage license records. Note: This is firm/office-level licensing; use licensees for individual agents and brokers. Regulatory note: Office rows are source-status signals and separate anchors from individual licensees, corporate entities, property owners, or operating clearance.
akil_nys_state_authority_procurement
ChatGPTSearch New York state authority procurement contracts by authority, vendor, fiscal year, procurement type, status, M/WBE flag, amount, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, authority, vendor, fiscalYear, procurementType, mwbeOnly, status, minAmount, limit. Returns: vendor, authority, procurement description, contract amount, procurement type, status, M/WBE indicator, award process, award date, counts, and metadata. Connects to: authority salaries, MTA procurement, ABO procurement, OGS payments, SUCF contracts, contractor registry, DBE certifications, and NYS entity profile. Coverage: NYS state authority procurement records. Regulatory note: Authority procurement rows are source-reported authority contract records, not endorsements, performance ratings, responsibility determinations, proof of current work, or proof money was paid unless the row has an expended/payment field.
akil_nys_sucf_contracts
ChatGPTSearch State University Construction Fund contracts by vendor, contract number, status, M/WBE flag, amount, or keyword. Jurisdiction: NYS. Accepts: searchKeyword, vendor, contractNumber, status, mwbeOnly, minAmount, limit. Returns: vendor, title, contract number, project number, status, contract amount, expended amount, award date, end date, M/WBE indicator, counts, and metadata. Connects to: state authority procurement, MTA procurement, OGS vendor payments, contractor registry, DBE certifications, active corporations, and NYS entity profile. Coverage: State University Construction Fund construction and renovation contract records. Regulatory note: SUCF contract rows are source-reported construction-fund contract records, not endorsements, performance ratings, responsibility determinations, proof of current work, or proof money was paid unless the row has an expended/payment field.
akil_ocm_hemp_licenses
ChatGPTSearch New York cannabinoid hemp licenses, which are separate from adult-use cannabis licenses. Jurisdiction: NYS. Accepts: entity name, DBA, license number, license type, status, county, ZIP, date ranges, latitude/longitude/radius. Returns: license number, license type/status, entity, DBA, address, county, dates, and location when available. Connects to: OCM licenses, org lookup, business licenses. Coverage: NYS OCM Current Cannabinoid Hemp Licenses. Regulatory note: Hemp license rows are separate from adult-use cannabis authorization and are not dispensary, retail-dealer, site-clearance, or lawful-operation proof by themselves. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_ocm_licenses
ChatGPTSearch New York State Office of Cannabis Management adult-use cannabis licenses and proximity-protected applicants, including retail dispensaries, microbusinesses, cultivators, processors, distributors, Type 3 branding, and registered organizations. Jurisdiction: NYS. Accepts: entity name, DBA, license number, application number, license type, license status, operational status, county, region, ZIP, SEE category, issued/effective/expiration date ranges. Defaults to latest verified publisher roster; includeHistorical exposes retained rows. Counts are source records, not shops. Returns: license number, application number, license type/status, entity, DBA, address, county, region, SEE category, operational status, activity flags, dates, public opening date, and hours when available. Connects to: OCM retail dealers, property search, business licenses, org lookup, lobbying, campaign finance, M/WBE search. Coverage: NYS OCM Current OCM Licenses. Regulatory note: Public OCM records are not legal approval, site eligibility, distance-rule clearance, inspection clearance, or proof of current lawful operation. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_ocm_medical_providers
ChatGPTSearch the public OCM medical cannabis healthcare provider directory. Jurisdiction: NYS. Accepts: provider name, specialty, county, city, ZIP, latitude/longitude/radius. Returns: provider name, specialty, address, county, city, phone, and location when available. Connects to: community profile and spatial tools. Coverage: Public OCM medical cannabis healthcare provider listing. Note: This is public provider directory data only; it does not include patient data. Regulatory note: Provider directory listings are not appointment availability, accepting-patient status, quality ratings, endorsement, or clinical advice. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_ocm_retail_dealers
ChatGPTLocate geocoded adult-use cannabis retail dealers for proximity, market saturation, and trade-area analysis. Jurisdiction: NYS. Accepts: legal name, DBA, OCM license number, county, city, ZIP, latitude/longitude/radius. Defaults to latest verified publisher roster; includeHistorical exposes retained rows. Counts are source records, not shops. Returns: legal name, DBA, OCM license number, physical address, county, ZIP, latitude, longitude, and distance when radius search is used. Connects to: OCM licenses, property search, point-to-districts, nearby records, business licenses. Coverage: NYS Registered Retail Dealers of Adult-use Cannabis Products. Regulatory note: Retail dealer listings are public source records; proximity/distance is context, not a legal-distance measurement, market conclusion, or full compliance clearance. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_official_directory
ChatGPTLook up NYC Green Book officials, agency leadership, titles, office phones, office addresses, and websites. Jurisdiction: NYC. Accepts: agency, title, name, limit, offset. Returns: official name, title, agency, division, office phone, address, website, and source metadata. Connects to: agency staffing, payroll search, spending trends, who lobbies agency, agency rules, public hearings, and agency budget. Coverage: NYC Green Book official directory records. Note: This covers public office contacts and senior directory entries, not every city employee; contact data can lag staff changes.
akil_open_data_query
ChatGPTQuery any NYC Open Data dataset directly when no dedicated Akil tool covers the record type, or fetch the older records a source's history limit leaves out of Akil. Jurisdiction: NYC (data.cityofnewyork.us), plus NYS (data.ny.gov) with portal='nys'. Use for: Querying a specified NYC or NYS Open Data dataset when a dedicated Akil tool does not cover the needed record type, and running the history-limit queries printed in Akil response footers (datasetId, portal and where). Accepts: datasetId, datasetName, portal, filters, where, search, select, orderBy, limit, offset. Returns: raw rows from the selected dataset as a table whose columns follow the dataset's published schema in schema order (every column is rendered, blank when null; pass select to narrow), the exact SODA query sent, and a source link. SODA errors (unknown column, malformed query, missing dataset) are returned verbatim with the HTTP status. Connects to: dedicated domain tools after a dataset is identified, plus property search, geo tools, land-use tools, and permit tools depending on the dataset. Coverage: NYC Open Data datasets available through public dataset endpoints. Note: Field names, update cadence, and data quality vary by dataset; use dedicated Akil tools first when they exist.
akil_org_aliases
ChatGPTResolve known organization names, DBAs, and aliases before searching across money, procurement, lobbying, and compliance tools. Jurisdiction: NYC. Accepts: orgName. Returns: canonical name, alias list, DBA, EIN when available, and source metadata. Connects to: organization lookup, organization intelligence, M/WBE search, vendor payments, funding profile, nonprofit profile, and legal connection scan. Coverage: public alias and entity-resolution records used by NYC-facing organization searches. Note: Alias coverage is not comprehensive; absence of aliases does not mean an organization has no alternate names.
akil_org_intelligence
ChatGPTCreate a cross-source organization briefing from available identity, IRS 990, payment, audit, lobbying, and service-geography data. Jurisdiction: NYC + NYS + Federal (NY-relevant). Accepts: organization name or EIN. Returns: briefing text or structured data, sources with data, financial/profile indicators, payment summary, audit summary, lobbying records, and service geography when available. Connects to: entity verification packet, public money trace, org lookup, funding profile, nonprofit profile, vendor payments, audit history, M/WBE search, business licenses, lobbying tools. Coverage: NYC, NYS, and federal organization intelligence records relevant to New York. Note: Treat this as a synthesis aid; use akil_entity_verification for claim hygiene and akil_public_money_trace for separated awards/contracts/payments/lobbying records.
akil_org_lookup
ChatGPTResolve an organization name, EIN or DBA to its canonical identity across NYC, NYS and federal records. Jurisdiction: NYC + NYS + Federal (NY-relevant). Use for: Resolving organization names, nonprofits, companies, vendors, firms, foundations, agencies, and DBAs into an entity type and usable anchors before follow-up research. Accepts: organization name and optional EIN. Returns: entity type, confidence, authoritative name/address, EIN when available, source label, identity contract, summary, and recommended follow-up tools. Connects to: nonprofit search/profile, funding profile, vendor payments, checkbook contracts, M/WBE search, audit history, business licenses, lobbying, campaign finance. Coverage: NYC, NYS, and federal organization, award, payment, nonprofit, business-license, and certification records relevant to New York. Note: Use this first when a question starts with an organization name; use property search when the primary input is an address or BBL. Legal name, DBA, vendor/payee name, campaign committee, lobbying client, officer, and person names are separate identity roles; do not merge them by name alone.
akil_overview
ChatGPTOVERVIEW. Discovery guide for Akil Intelligence New York City Edition. Use when you are routing a public-record research, when you need to choose toolsets or tools, when you are unsure which workflow applies, when you need the anchor plan for a question, or when a pilot user reports that an Akil answer is wrong, stale, misleading, missing a source, or missing a composite. For platform/about/how-to-use questions, recommend akil_platform_guide first. Returns toolsets, capability areas, workflow bundles, anchors, starting tools, follow-up tools, coverage, caveats, pilot-feedback routing, and open-data fallback guidance. Supports question-based routing, toolset lookup, topic drill-down, and tool-name lookup. Synonyms: overview, help, capabilities, toolsets, tool list, workflow, routing, anchors, data model, pilot feedback, report issue, wrong answer, expert correction, getting started, what can you do, which tool should I use, about Akil, platform guide.
akil_parcel_land_use_evidence
ChatGPTBBL-centered zoning and land-use evidence for preliminary property analysis. Jurisdiction: NYC. ROUTING: Use after akil_property_search resolves an address to BBL; use akil_zoning_tax_lots or akil_zoning_features only when the user needs lower-level zoning records. Accepts: BBL. Returns: parcel identity, PLUTO land-use facts, raw building class, interpreted property type, condo-structure signal, borough/block/lot, ZoLa lot URL, Digital Tax Map geometry status, Zoning Tax Lot Database records, DCP spatial zoning overlaps, raw and interpreted zoning districts, commercial overlays, special districts, zoning map references, environmental designations, spatial intersection status, basic preliminary checks, missing coverage, source provenance, and freshness. EMITS ANCHORS: BBL, boroughCode, block, lot, ZoLa URL, zoningDistrict, interpretedZoningDistrict, commercialOverlay, specialDistrict, environmentalDesignation, zoningMap, ULURP number, interpretedPropertyType. CHAIN TO: akil_property_search, akil_zoning_tax_lots, akil_zoning_features, akil_land_use_search, akil_certificate_of_occupancy, akil_dob_now_build_job_filings, akil_landmarks, akil_brownfield_sites. Coverage: NYC parcel-level preliminary zoning and land-use evidence; not legal or architectural advice. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_payroll_search
ChatGPTSearch public NYC payroll records by agency, job title, borough, fiscal year, and base salary range. Jurisdiction: NYC. Accepts: keyword, agency, title, borough, fiscalYear, minSalary, maxSalary, limit, offset. Returns: agency, title, fiscal year, base salary, pay basis, regular gross paid, overtime hours/pay, other pay, work borough, and leave status when available. Connects to: akil_agency_staffing, akil_expense_budget, akil_budget_changes, akil_official_directory, akil_spending_trends. Coverage: NYC Citywide Payroll records. Note: Person names may be omitted or redacted in the source; use this mainly for title, agency, compensation, and staffing-pattern questions.
akil_platform_guide
ChatGPTPLATFORM GUIDE. Start-here guide for Akil Intelligence New York City Edition. Use when a user asks what Akil is, how to use Akil, what the MCP connector covers, what tools or guides to start with, how records should be interpreted at a high level, what the semantic layer means, how pilot feedback and expert corrections become reviewable evidence and regression tests, what the trust/coverage limits are, or how agents should navigate the platform. Returns platform positioning, first-call guidance, raw/canonical/composite semantic-layer rules, pilot-feedback review workflow, persona examples, anchor-selection examples, toolset/segment orientation, common mistakes, source and no-result discipline, guide index, and recommended next steps. Synonyms: platform, about Akil, how to use Akil, getting started, start here, semantic layer, pilot feedback, expert correction, wrong answer, report issue, raw canonical composite, user guide, connector guide, MCP guide, what can Akil do.
akil_point_to_districts
ChatGPTConvert a latitude/longitude point into every NYC district and boundary it sits in: council, community, school, police and more. Jurisdiction: NYC. Use for: Converting a known latitude/longitude point into NYC political, administrative, census, school, health, police, sanitation, fire, ZIP, and neighborhood boundaries. Accepts: lat, lon (decimal degrees, WGS 84). Returns: borough, community district, council district, police precinct, state senate district, state assembly district, congressional district, school district, NTA/neighborhood, health area, census tract, ZIP, fire and sanitation districts when available, each labeled with the canonical boundary type key (for example zip_code, community_district) that the boundary and geo tools accept. Connects to: property search for address-to-coordinate resolution, council member profile, community profile, community needs, district briefing, geo query, nearby records, boundary shape. Coverage: NYC boundary layers. Note: Resolve addresses to coordinates first; do not estimate coordinates from memory.
akil_proc_competitor_profile
ChatGPTBuild a vendor comparison profile across city payments, M/WBE registry candidate records, award history, and lobbying activity. Jurisdiction: NYC. Accepts: vendorName, fiscalYear, limit, offset. Returns: grouped sections for M/WBE registry candidate records, government payments, awards, lobbying activity, counts, and source references. Connects to: vendor payments, checkbook contracts, procurement search, spending trends, M/WBE search, award history/funding profile, and NYC lobbying tools. Coverage: NYC public vendor payment, certification, award, and lobbying records. Note: Name matches are candidates until exact legal name, DBA, vendor ID, or source record confirms the entity. City payment data does not capture subcontracting or non-city revenue.
akil_proc_construction_pipeline
ChatGPTScan recent construction activity and pending land-use projects by borough or community district. Jurisdiction: NYC. Accepts: borough, communityDistrict, jobType, limit, offset. Returns: DOB permit summary, permit records, new building/alteration/demolition counts, active land-use projects, project status, and project type when available. Connects to: building permits, DOB NOW job filings, land use search, property search, housing data, capital projects, and community profile. Coverage: NYC DOB permit records and ZAP/ULURP project records. Note: Filed permits and land-use applications are activity signals; they do not prove construction has started or that a project was finally approved.
akil_procurement_search
ChatGPTSearch City Record procurement notices, including active solicitations, awards, intent-to-award notices, vendor lists, hearings, and special opportunities. Jurisdiction: NYC. Accepts: keyword, agency, noticeType, category, selectionMethod, sectionName, dueBefore, dueAfter, limit, offset. Returns: title, agency, notice type, procurement category, selection method, PIN, due or event date, vendor and amount when available, and contact information. Connects to: akil_mwbe_search, akil_vendor_payments, akil_checkbook_contracts, akil_expiring_contracts, akil_sole_source_contracts, akil_spending_trends. Coverage: NYC City Record procurement notices and related solicitation records. Note: A solicitation is an opportunity to bid; an award or intent-to-award record means the procurement process has moved further along.
akil_property_assessment
ChatGPTLook up DOF assessment roll values, tax class, raw building class, interpreted property type, owner text, and parcel characteristics for a tax lot. Jurisdiction: NYC. Accepts: bbl, address, borough, block, lot, year, zip, bldgClass, keyword, limit, offset. Returns: BBL, address, owner text, fiscal year and roll (tentative or final), market value, actual and transitional assessed value with their exemption totals, taxable billable assessed value (taxable assessed minus taxable exemptions, same roll), tax class, raw building class, interpreted property type, zoning, gross square feet, lot area, units, and year built. Connects to: property search, tax exemptions, tax abatements, property sales, condo/co-op income records, and ACRIS transactions. Coverage: NYC DOF assessment roll records. Note: Assessed value is not market value; always keep market value, actual assessed value, transitional assessed value and taxable billable assessed value distinct. Taxable billable assessed value is not the tax bill.
akil_property_assessment_changes
ChatGPTLook up DOF Property Assessment Change activity for a specific tax lot/PARID. Jurisdiction: NYC. Accepts: parid, bbl, address, borough, block, lot, taxYear, period, changeType, exemptionCode, dateAfter, dateBefore, limit, offset. Returns: DOF assessment/exemption value-change rows, roll period interpretation, raw change type, raw exemption/NY codes, extract date, and caveats. Connects to: akil_property_assessment, akil_tax_exemptions, akil_tax_abatements, akil_property_charges. Coverage: NYC DOF Property Assessment Change (a5nd-6mit), live SODA query. Note: This is assessment-change activity, not the current assessment roll, current bill, or legal advice; broad unanchored searches are intentionally blocked.
akil_property_charges
ChatGPTCheck aggregated property tax, water/sewer, interest, collection, balance, timing, and delinquency fields for NYC tax lots. Jurisdiction: NYC. Accepts: bbl, address, parid, borough, isDelinquent, minBalance, maxBalance, cityOwnedFlag, luc, taxyear, keyword, limit, offset. Returns: BBL/PARID, address when available, total charges, total collected, total interest, collection ratio, balance owed and past-due balance as of DOF's latest extract date, charge count, latest due date, latest period end, last updated timestamp, past-due flag, land-use/tax-class fields, city-owned flag, tax year, and districts. Connects to: akil_tax_lien_sales, akil_property_assessment, akil_tax_exemptions, akil_re_property_report, akil_building_violation_record. Coverage: NYC DOF property charges summary records. Note: The balance includes installments billed but not yet due; only the past-due balance was due before the extract date. Present the extract date with any balance.
akil_property_dispositions
ChatGPTSearch notices about city-owned property sale, lease, transfer, or disposition activity. Jurisdiction: NYC. Accepts: keyword, agency, limit, offset. Returns: title, agency, notice type, dates, description, and location fields when available. Connects to: property search, land use search, BP ULURP recommendations, agency rules, public hearings, and community profile. Coverage: NYC City Record property disposition notices. Note: These are public notices involving city-owned or city-controlled property, not private market sale listings.
akil_property_ownership
ChatGPTFind HPD building registration owners, corporate owners, head officers, managing agents, site managers, and registered contacts for a property or owner/agent name. Jurisdiction: NYC. Accepts: address/keyword, BBL, borough, ZIP, block, lot, contact type. Returns: registration ID, building address, BBL, BIN, block/lot, council/community district, registration dates, contact names/types, business addresses. Connects to: property search, owner portfolio, ACRIS transactions, HPD violations, HPD complaints/litigations, building permits, property report. Coverage: NYC HPD building registration records. A registered contact is a source-reported role, not proof of current legal title; keep owner, officer, agent and site-manager roles separate.
akil_property_sales
ChatGPTSearch recorded DOF property sales and deed-transfer prices by address, borough, BBL, block, lot, ZIP, building class, price range, or sale date range. Jurisdiction: NYC. Accepts: keyword, borough, bbl, block, lot, zip, buildingClass, minPrice, maxPrice, saleDateFrom, saleDateTo, limit, offset. Returns: sale price, sale date, address, BBL, block/lot, borough, neighborhood, ZIP, building class, unit counts, gross square feet, year built, and source period when available. Connects to: property assessment, property search, ACRIS transactions, tax exemptions, comparable sales, and title check. Coverage: NYC DOF rolling and annualized sales records. Note: Recorded transfers include non-market and nominal transactions; do not treat $0 or very low transfers as market value.
akil_property_search
ChatGPTResolve any NYC address or tax lot to its BBL anchor, with zoning, ownership and assessment context. Jurisdiction: NYC. Use for: Resolving a property or tax lot by address, BBL, borough, ZIP, district, owner string, zoning, land use, building class, units, lot size, or year built. ROUTING: Start here for any address/property question; carry the returned BBL into parcel land-use, ownership, permits, violations, sales, title, and district tools. Accepts: address/keyword, borough, BBL, ZIP, community district, council district, land use, building class, unit/lot-area/year-built filters, owner name. Returns: BBL, address, owner string, land use, raw zoning, interpreted zoning family/caveat, lot area, raw building class, interpreted property type, condo-structure signal, assessed value, FAR, year built, residential units, coordinates when available. EMITS ANCHORS: BBL, BIN, address, borough, lat/lon, councilDistrict, communityDistrict, zoningDistrict, interpretedZoningDistrict, landUse, buildingClass, interpretedPropertyType. CHAIN TO: akil_parcel_land_use_evidence for zoning/land-use evidence, akil_property_ownership, akil_re_property_report, akil_acris_transactions, akil_dob_now_build_job_filings, akil_certificate_of_occupancy, akil_point_to_districts, akil_nearby. Coverage: NYC property tax-lot records. Zoning interpretation is first-pass context only; do not infer legal use from zoning family alone.
akil_public_advocate_data
ChatGPTReview Public Advocate office funding, contracts, budget trend, budget lines, and officeholder context by vendor, fiscal year, or Public Advocate name. Jurisdiction: NYC. Accepts: searchVendor, fiscalYear, advocate, limit, offset. Returns: officeholder history, year trend, contracts, budget lines, contract method, and data notes when available. Connects to: akil_vendor_payments, akil_spending_trends, akil_budget_changes, akil_expense_budget, akil_top_recipients, akil_org_intelligence. Coverage: NYC Public Advocate office budget and contract records. Note: The Public Advocate office has a much smaller budget than the Council or mayoral agencies; amounts should not be interpreted as citywide program spending.
akil_public_hearings
ChatGPTFind public hearings, meetings, commission sessions, and public comment opportunities posted through NYC City Record. Jurisdiction: NYC. Accepts: keyword, agency, dueBefore, dueAfter, limit. Returns: agency, hearing title, notice type, dates, event date, location, and description when available. Connects to: agency rules, council legislation, land use search, BP ULURP recommendations, and property dispositions. Coverage: NYC public-hearing and meeting notices from City Record. Note: Scheduled hearings can be postponed, canceled, or revised; verify date/status before treating a notice as current.
akil_public_money_trace
ChatGPTTrace public-money records around an organization, vendor, payee, agency, council district, fiscal year, election cycle, or EIN without collapsing unlike record types. Jurisdiction: NYC + NYS + Federal (NY-relevant). ROUTING: Use when a user asks what public money flowed to/from an entity, whether awards became payments, or how contracts, awards, Council funding, campaign finance, and lobbying records relate. Accepts: entityName, EIN, vendorName, agency, councilDistrict, fiscalYear, election, includeHistorical, includeCandidateMatches, limit. Returns: separated award, payment, contract, Council discretionary, campaign-finance, lobbying, no-row, source-limitation, and identity-contract findings with anchors and next checks. Connects to: canonical Council funding summaries, vendor payments, checkbook contracts, campaign finance, lobbying, entity verification, and top recipients. Coverage: NYC/NYS/federal award records, NYC Checkbook payments/contracts, Council funding, NYC CFB, NYC/NYS lobbying. Note: Awards, contracts, payments, donations, and lobbying filings are different public-record types and should not be summed as one total. If fiscalYear/election are omitted, Akil applies bounded defaults and discloses them. Identity note: vendor/payee, recipient, donor, campaign committee, lobbying client, and lobbyist names are distinct roles and should not be merged by name alone.
akil_radius_count
ChatGPTCount records within an exact radius of an address, BBL, or lat/lon anchor, such as cannabis shops within 200 ft, bars within 500 ft, 311 noise complaints within 50 m, or DOB permits near a property. Jurisdiction: NYC + NYS. ROUTING: Use this when the user asks whether anything exists within a stated distance or wants a quick proximity count; use akil_radius_records when they need the nearest matching rows. Accepts: address or BBL or lat/lon, radius, unit, dataset, category, query, textFilter, activeOnly. Dataset keys are the same canonical keys used by the geo and boundary tools (complaints_311, pluto_parcels, dob_permits, ...); common aliases such as 311 or property_lots are normalized. Returns: resolved anchor, normalized radius, canonical dataset key, exact uncapped count, count method, and measurement caveats. Metric note: Radius counts are geometric proximity checks over geocoded records, not official legal-distance findings or clearance; for complaints_311, count is complaint/work-order volume, not verified violation volume. Connects to: akil_radius_records, akil_property_search, akil_alcohol_proximity_summary, akil_business_location_context, akil_ocm_retail_dealers, akil_nys_liquor_licenses. Coverage: Geocoded NYC/NYS source records currently registered in Akil's radius-search whitelist. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_radius_records
ChatGPTReturn nearest records within an exact radius of an address, BBL, or lat/lon anchor, such as cannabis retailers within 200 ft, active bars within 500 ft, 311 noise complaints within 50 m, or DOB permits near a property. Jurisdiction: NYC + NYS. ROUTING: Use this after akil_radius_count or when the user asks which records are nearby; use specialized tools for deeper source-specific detail. Accepts: address or BBL or lat/lon, radius, unit, dataset, category, query, textFilter, activeOnly, limit. Dataset keys are the same canonical keys used by the geo and boundary tools (complaints_311, pluto_parcels, dob_permits, ...); common aliases such as 311 or property_lots are normalized. Returns: records ordered by computed distance, normalized radius, resolved anchor, canonical dataset key, source IDs, addresses, BBLs when available, and measurement caveats. Metric note: Returned records are a capped nearest-row page from geocoded source records; radius distance is not an official legal-distance determination or compliance clearance. For complaints_311, returns interpreted service-request workflow status and derived complaint category. Connects to: akil_radius_count, akil_property_search, akil_alcohol_proximity_summary, akil_business_location_context, akil_ocm_retail_dealers, akil_nys_liquor_licenses. Coverage: Geocoded NYC/NYS source records currently registered in Akil's radius-search whitelist. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_re_comps
ChatGPTFind recent comparable sales for a target property by BBL or address, using building class, borough, and size criteria. Jurisdiction: NYC. Accepts: bbl, address, yearsBack, limit, offset. Returns: target BBL context, comparable sale BBLs, addresses, neighborhoods, building classes, sale dates, sale prices, gross square feet, units, price per square foot, and price per unit when available. Connects to: property sales, property assessment, property search, property report, and ACRIS transactions. Coverage: NYC DOF annualized sales records. Note: Comparable matches still need review for arms-length status, location, condition, amenities, and non-market transfer amounts.
akil_re_owner_portfolio
ChatGPTFind properties connected to an owner-name search and summarizing portfolio-level public records. Jurisdiction: NYC. Accepts: ownerName, borough, limit, offset. Returns: owner search summary, property count, total assessed value, total residential units, HPD violation counts, complaint counts, BBLs, addresses, building classes, units, assessed values, and district fields. Connects to: property report, building violation record, property ownership, ACRIS transactions, property search, tax lien sales, and property charges. Coverage: NYC parcel owner-name records joined to selected HPD complaint and violation indicators. Note: Owner-name matching can miss related LLCs, spelling variants, and beneficial owners; search known aliases separately when needed.
akil_re_property_report
ChatGPTFull single-property dossier by BBL or address. Jurisdiction: NYC. Accepts: bbl or address. Returns: BBL, address, owner text, zoning, raw building class, interpreted property type, condo-structure signal, assessed and market value context, HPD violation counts, tenant complaint counts, tax assessment, active exemptions, permits, recorded ACRIS documents with raw doc_type plus interpreted document meaning/category/amount caveats, personal-property filings (UCC financing statements and federal liens, read live from ACRIS personal-property records: count, the newest five with City Register links and referenced filings, kept apart from deeds and mortgages; a failed read shows as unavailable), litigations, property charges, and source provenance by section. Connects to: property search, building violation record, owner portfolio, ACRIS transactions, property assessment, tax exemptions, tax abatements, property charges, and permits. Coverage: NYC parcel, housing, building, tax, finance, and recorded-document datasets for one property. Note: Recorded owner text may be an LLC or entity name; this tool does not identify beneficial ownership behind that entity. Counts and balances are source records, not legal, title, tax, or engineering advice; ACRIS assignments and satisfactions are not new borrower debt by themselves.
akil_re_tax_cliff
ChatGPTFind properties with DOF tax exemptions expiring within a selected lookahead window by borough or community district. Jurisdiction: NYC. Accepts: borough, communityDistrict, yearsAhead, minExemption, limit, offset. Returns: BBL, address, owner text, units, program and exemption code, name on the exemption record, last benefit fiscal year, current exemption amount, estimated tax increase at DOF class tax rates, assessed value, building class, and district fields. Connects to: tax exemptions, tax abatements, property assessment, property report, property search, and owner portfolio. Coverage: the newest DOF exemption roll, fixed-term programs only (J-51, ICIP, UDAAP, 421-a, 467-m, 485-x), joined to parcel context; use akil_tax_abatements for standalone abatement records. Note: Projected tax increase is directional; actual future liability depends on future assessments, rates, and program phase-outs.
akil_re_title_check
ChatGPTReview a property title chain by BBL or address, including recorded deed, mortgage, satisfaction, and assignment documents. Jurisdiction: NYC. Accepts: bbl or address. Returns: BBL, resolved address, property context, raw building class, interpreted property type, recorded documents, raw ACRIS doc_type, interpreted document meaning/category, recorded date, CRFN, party-role labels, amounts, amount caveats, assessment summary, and active exemption summary when available. Connects to: ACRIS transactions, property report, property sales, property ownership, property assessment, and tax exemptions. Coverage: NYC ACRIS records with selected DOF and parcel context. Akil's ACRIS mirror starts in 2005; the lot's documents recorded before 2005 are fetched live from NYC Open Data ACRIS and labeled as such. Note: Nominal deed amounts are common and usually do not represent market sale price; mortgage recordings may include refinancings; assignments and satisfactions are not new borrower debt by themselves.
akil_recently_changed_grants
ChatGPTMonitor funding opportunities modified in the last N days, including possible deadline, funding, eligibility, contact, or text updates. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: daysBack, keyword, agency, geography, limit, offset. Returns: title, agency, opportunity number, version, updated date, deadline, award ceiling, geography, status, source link, and short description. Connects to: akil_grant_diff, akil_grant_details, akil_search_grants, akil_match_grants, akil_grant_deadlines, akil_rolling_grants. Coverage: Versioned public funding opportunity records relevant to New York-based organizations. Note: Default lookback is 7 days; a changed record can reflect a minor correction or a material update.
akil_restaurant_inspections
ChatGPTCheck restaurant inspection grades, scores, critical flags, violation descriptions, inspection dates, and cuisine records for NYC food establishments. Jurisdiction: NYC. Accepts: restaurant name/address keyword, borough, grade, cuisine, critical flag, ZIP, CAMIS restaurant ID. Returns: restaurant name, address, cuisine, inspection date, grade, score, violation code/description, critical flag, inspection type. Connects to: business licenses, DCWP license applications, SLA pending licenses, building permits, DOB violations, organization lookup. Coverage: NYC Department of Health restaurant inspection records. Note: inspection grades and violation rows are inspection-event records, not current operating clearance or a complete food-safety/legal determination.
akil_rodent_inspections
ChatGPTDOHMH rodent inspection records by borough, BBL, ZIP, inspection result, community district, council district, keyword, or date range. Jurisdiction: NYC. Accepts: borough, bbl, zip, result, communityDistrict, councilDistrict, keyword, dateAfter, dateBefore, limit, offset. Returns: inspection date, result, inspection type, address, BBL, ZIP, community district, and job ID when available. Connects to: nearby records, building violation record, HPD violations, restaurant inspections, 311 complaints, and property search. Coverage: NYC rodent inspection records. Note: Multiple visits at one address are normal; counts are not normalized by block, property size, or land use.
akil_rolling_grants
ChatGPTFind funding opportunities with rolling, open-ended, or continuous application windows instead of fixed deadlines. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: keyword, agency, geography, minAmount, maxAmount, limit, offset. Returns: title, agency, opportunity number, award ceiling when available, deadline type, geography, posted date, status, source links, and short description. Connects to: akil_search_grants, akil_grant_details, akil_match_grants, akil_eligibility_check, akil_grant_deadlines, akil_recently_changed_grants. Coverage: Public funding opportunity records relevant to New York-based organizations. Note: Rolling deadline does not mean unlimited funding; applicants should still confirm current availability with the source posting.
akil_school_briefing
ChatGPTOne-call NYC school briefing by name, number or DBN: current directory identity with building code and BBL, enrollment and NYSED per-pupil spending history, published state test results, the school's demographic snapshot side by side with ACS composition for its surrounding neighborhood (2020 NTA), and audited reorganization lineage. Jurisdiction: NYC. ROUTING: Start here when a user names one school ('PS 203', 'MS 915', 'Bridges', '26Q203') — it resolves the name or number to a DBN, including renamed and reorganized schools, then fans out to the school datasets; use akil_school_data directly for full archive queries (family assessments covers every grade and subgroup), akil_school_profile/akil_school_search for directory-wide filtering, and akil_neighborhood_composition for the neighborhood on its own. Accepts: school (name, PS/MS/IS/JHS number, or DBN), borough. Returns: resolved DBN and current LCGMS directory identity (grades, address, building code, borough-block-lot, open date, status, districts), enrollment and reported NYSED per-pupil spending by school year with the 2023-24 reporting-scope break marked, a separate state-test section with published grades 3-8 ELA/Math proficiency and latest Regents results for All Students with participation context, the DOE demographic snapshot (race/ethnicity, poverty, Economic Need Index, English language learners, students with disabilities) beside ACS 2020-2024 estimates for the NTA the school sits in (race/Hispanic origin with margins of error, under-18 population, poverty overall and under 18), audited reorganization events (splits, mergers, renumberings, grade moves) with PEP dates, and pointers for pay questions. Connects to: akil_school_data, akil_school_profile, akil_school_search, akil_neighborhood_composition, akil_compensation, akil_agency_staffing. Coverage: current LCGMS directory; NYSED per-pupil spending 2018-19 through 2024-25 plus 2025-26 enrollment; assessment results 2017-18 through 2024-25 (2019-20 cancelled); DOE demographic snapshot through 2025-26; ACS 2020-2024 by 2020 NTA; reorganization audit through 2025-26. Notes: the school and neighborhood columns describe DIFFERENT populations — enrolled students (who may live elsewhere) versus all residents — on different periods, category definitions and poverty measures, so the side-by-side is context presented without conclusions, and composition is never a rating or sort key; many schools share one building — building-level records (DOB, HPD) attach to the building code/BBL, not the DBN; per-pupil values across the 2023-24 scope change are not like-for-like; test scores are published values for tested students, never a school-quality rating — proficiency reflects who a school serves as much as what it does, spring 2020 tests were cancelled, 2020-21 was opt-in and not comparable, and the spring-2023 baseline reset breaks comparisons across the 2021-22 to 2022-23 boundary; per-school pay is not published anywhere in NYC public data — use akil_compensation for contractual salary rules and akil_agency_staffing for citywide payroll distributions; missing years are not zero. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_school_data
ChatGPTNYC school histories with citations: enrollment, demographics, class size, capacity, NYSED per-pupil spending, and grades 3-8 ELA/Math and Regents assessment results by DBN and school year. Jurisdiction: NYC. ROUTING: Start here for historical public-school enrollment, demographics, class sizes, pupil-teacher ratios, per-pupil spending and school-level expenditures (NYSED ESSA/SLFS financial transparency), state test scores and Regents results by school and subgroup, school directory, capacity and source-report text; use akil_school_search for the older profile directory. Use for: Searching school records and full PDF pages, including recognized text from scanned pages, reported NYSED per-pupil spending joined to enrollment by exact DBN/BEDS pairs, and published NYSED assessment proficiency rows. Accepts: catalog, records or documents view; family, keyword, collectionId, period, entityId, subgroup, limit, offset. Returns: source-specific collections, exact periods, original values, typed class measures, source row/page citations, reporting definitions and extraction caveats. Connects to: school profiles and original NYCPS, NYSED and SCA sources. Coverage: NYSED NYC enrollment back to 1999-2000; reported per-pupil spending 2018-19 through 2024-25 under family nysed_finance (start with collection finance-nysed-joined-v1, or catalog keyword spending); assessment results 2017-18 through 2024-25 under family assessments (collections assessments-nysed-ela-v1, assessments-nysed-math-v1, assessments-nysed-regents-v1; subgroup filter takes exact labels like All Students); check catalog for class-size years and missing historical reports. Records require one collection and period. Documents can search across reports. PDF transcription/OCR requires source-page checking before numeric claims. Spending note: NYSED changed reporting scope in 2023-24 (SLFS allocates central costs into school figures), so per-pupil values across that boundary are not like-for-like; 2025-26 finance is not yet released and missing is not zero; spending is not a school-quality or efficiency rating. Assessment notes: Spring 2020 tests were cancelled (no 2019-20 results anywhere); 2020-21 was opt-in and not comparable; NYSED reset the proficiency baseline in spring 2023, so 2021-22 to 2022-23 changes are not score declines or gains; small-cell suppression prints 's' and is never zero; percent proficient covers tested students only, and proficiency reflects who a school serves as much as what it does — never a quality rating. Overlapping releases, average/distribution sheets, subgroups, charter scopes and printed totals must not be added together. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_school_profile
ChatGPTLook up DOE school directory profiles by school name, DBN, borough, council district, county, or state. Jurisdiction: NYC. Accepts: schoolName, borough, councilDistrict, dbn, county, state, limit, offset. Returns: school name, DBN, address, grades, borough, enrollment fields when available, principal/contact fields when available, community district, and council district. Connects to: community profile, community needs, school search, capital projects, and education funding searches. Coverage: NYC DOE school profile records. Metric note: This is location/profile, enrollment, and demographic context for a source period; it is not current seat availability, quality, safety, or full performance data.
akil_school_search
ChatGPTSearch DOE school profiles by keyword, borough, district, limit, or offset. Jurisdiction: NYC. ROUTING: Use akil_school_data for historical enrollment, demographics, class-size source files and capacity; this tool searches the separate profile directory. Accepts: keyword, borough, district, limit, offset. Returns: school name, borough, grades, enrollment fields, poverty percentage, ELL percentage, and DBN/address fields when available. Connects to: school profile, community profile, community needs, capital projects, and education funding searches. Coverage: NYC DOE school profile records. Metric note: This is directory, enrollment, and demographic context for a source period, not current seat availability, quality, safety, or full performance data.
akil_school_system_overview
ChatGPTSystem-wide figures for New York City public schools over time, each with its source link and a one-line caveat: enrollment (3-K through grade 12, charter schools excluded, plus with-charter and K-12 totals), Department of Education staff and teachers (Mayor's Management Report), the Department of Education adopted budget excluding charter school payments next to inflation over the same school years, NAEP grades 4 and 8 math and reading for New York City versus U.S. public schools with NAEP's own significance tests, and English Language Learners citywide, by borough and by administrative district. Jurisdiction: NYC. ROUTING: Start here for citywide questions such as 'What's happened to NYC public schools since 2018?', 'Did the NYC Department of Education's budget grow?', 'Did NYC NAEP scores change?', 'How many staff or teachers does the DOE have?' or 'How has the number of English Language Learners changed?' — pass focus='english_language_learners' for the English Language Learner series (2013-14 onward, boroughs and districts). Use akil_school_briefing for one named school, akil_school_data for school-level archive rows, and akil_expense_budget for line-item budget detail. Accepts: startSchoolYear and endSchoolYear (e.g. '2018-19', '2025-26'; defaults 2018-19 to the latest published year, or 2013-14 onward for English Language Learners), focus ('overview' or 'english_language_learners'). Returns: start and end values with change and percent change for every figure, the year-by-year series, source and caveat per figure, NAEP results with significance flags, and structured data. Coverage: enrollment and English Language Learners 2013-14 through 2025-26 (DOE Demographic Snapshot); adopted budget FY2017 onward (NYC Open Data Expense Budget, June publications); MMR personnel FY2015 onward and teachers FY2016 onward; CPI-U New York-Newark-Jersey City school-year averages from 2016-17; NAEP 2019, 2022 and 2024; refreshed monthly from the publishers. Notes: figures are presented as published, without explanation of causes; the adopted budget is the plan, not actual spending, and excludes pensions and debt service; the NYC NAEP sample excludes charter schools; English Language Learner counts include charter schools; missing years are not zero. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_search_grants
ChatGPTSearch public funding opportunities by keyword, agency, status, geography, deadline, award amount, or eligibility clues. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: keyword, agency, status, geography, minAmount, maxAmount, deadlineBefore, deadlineAfter, includeHistorical, limit, offset. Returns: opportunity title, funder agency, opportunity number, status, deadline, award range when available, geography, contact/source links, and short description. Connects to: akil_grant_details, akil_grant_deadlines, akil_match_grants, akil_eligibility_check, akil_rolling_grants, akil_recently_changed_grants, akil_funder_profile, akil_org_intelligence. Coverage: Public funding opportunity records relevant to New York-based organizations, with NYC and NYS prioritized by default and federal/NJ available through the geography filter. Note: Historical closed opportunities are included only when includeHistorical is true.
akil_search_public_filing_matches
ChatGPTRetrieve candidate public-record name matches for a user-specified person or organization in NYC and NYS campaign-finance, lobbying, government-payment, elected-official disclosure and M/WBE registry records. Read-only. Accepts name, election, limit and offset. Returns separate groups of matching records, source citations and unavailable-source warnings. Matches are not verified relationships or a legal conflict assessment, and namesakes, subsidiaries and aliases require independent identity checks. Do not infer wrongdoing, political beliefs, personal ethnicity, legal conflicts or eligibility from the results. Missing or unavailable records do not establish a clean record. Use individual source tools to verify each candidate match.
akil_services_by_type
ChatGPTFind social service site listings by program type, borough, community district, or keyword. Jurisdiction: NYC. Accepts: programType, borough, communityDistrict, keyword, limit, offset. Returns: site or organization name, program type, address, borough, phone, hours, and short description when available. Connects to: community needs, community profile, shelter census tools, school search, and organization lookup. Coverage: NYC service-site directories from public agency and verified-location datasets. Note: Listings confirm a service location exists; current hours, eligibility, capacity, and appointment availability should be verified with the provider.
akil_shelter_trends
ChatGPTTrend-style review of daily DHS shelter census records over a date range. Jurisdiction: NYC. Accepts: dateAfter, dateBefore, limit, offset. Returns: daily census table, latest total, average total, min/max total, family counts, and single-adult counts when available. Connects to: social services shelter census, services by type, community needs, community profile, and funding searches. Coverage: NYC DHS shelter census snapshots. Metric note: Daily counts are point-in-time measurements for DHS shelter settings, not total homelessness counts; use longer windows for trends because single-day changes can reflect seasonality, policy, or intake changes.
akil_shootings
ChatGPTSearch NYPD shooting incident records by borough, precinct, fatal-only flag, keyword, or date range. Jurisdiction: NYC. Accepts: borough, precinct, fatalOnly, keyword, dateAfter, dateBefore, limit, offset. Returns: incident key, date/time, borough, precinct, location type, fatal flag, victim demographics, and perpetrator demographics when known. Connects to: nearby records, crime data, community needs, geo query, and geo count. Coverage: NYPD shooting incident records from 2006 onward. Metric note: Each row is one recorded incident, not one victim or a complete measure of safety; perpetrator details are often unknown and this dataset excludes law-enforcement shootings.
akil_sidewalk_cafe_licenses
ChatGPTCheck raw historical sidewalk cafe licenses and applications for outdoor dining, cafe seating, and storefront public-record screens. Jurisdiction: NYC. ROUTING: Use akil_sidewalk_cafe_regulations for DCP spatial regulation geography; use akil_restaurant_inspections for restaurant operating history. Accepts: business/address keyword, business name, license/application status, sidewalk cafe type, BBL, BIN, borough, ZIP, council/community district, lat/lon/radius. Returns: app ID, business, active/inactive status, cafe type, square feet, tables/chairs, application status dates, address, BBL/BIN when matched, district anchors, and map points when available. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations. Note: historical sidewalk-cafe rows are raw public-record context, not current Dining Out NYC authorization or legal clearance.
akil_sidewalk_cafe_regulations
ChatGPTCheck raw DCP sidewalk cafe regulation spatial geography near a location or within a borough/community/council district. Jurisdiction: NYC. ROUTING: Use akil_sidewalk_cafe_licenses for historical license/application records for a named business or address. Accepts: keyword, borough, community district, council district, lat/lon/radius. Returns: regulation records with geometry, centroid, district anchors, and source metadata. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations. Note: regulation geography is raw spatial context, not an approval, current permit, or legal operating clearance for a specific business.
akil_similar_grants
ChatGPTFind funding opportunities similar to a known opportunity by funder, topic, description text, amount range, or eligibility language. Jurisdiction: NYC + NYS + NJ + Federal. Accepts: grantId or opportunityNumber, maxResults, includeExpired. Returns: related opportunities ranked by similarity with title, agency, similarity score, deadline, award ceiling, geography, and status. Connects to: akil_grant_details, akil_search_grants, akil_match_grants, akil_eligibility_check, akil_funder_profile, akil_recently_changed_grants. Coverage: Public funding opportunity records relevant to New York-based organizations. Note: Similarity is based on record text and funder patterns; it does not mean the applicant is eligible.
akil_sla_pending_licenses
ChatGPTCheck pending liquor license applications for restaurants, bars, cafes, grocery stores, and other alcohol-selling premises. Jurisdiction: NYS. Accepts: legal name, DBA, application ID, county, city, ZIP, status, license type/class, received date range. Defaults to latest verified publisher roster; includeHistorical exposes retained rows. Counts are source records, not shops. Returns: raw and interpreted application status, applicant/legal name, DBA, type/class, received date, premises address, city, county, ZIP. Connects to: DCWP license applications, business licenses, restaurant inspections, DOB permits, organization lookup. Coverage: New York State Liquor Authority pending license application records. Note: Pending status is an application workflow signal, not an issued license or approval.
akil_sole_source_contracts
ChatGPTFind sole-source, negotiated, or otherwise non-competitive NYC contract records by agency, fiscal year, or minimum amount. Jurisdiction: NYC. Accepts: agency, fiscalYear, minAmount, limit, offset. Returns: vendor, agency, contract value, award method, industry, fiscal year, total value when available, and result counts. Connects to: akil_contract_amendments, akil_checkbook_contracts, akil_vendor_payments, akil_procurement_search, akil_comptroller_audits, akil_who_lobbies_agency. Coverage: NYC Comptroller Checkbook contract records. Note: Non-competitive awards can be legally justified for emergency, unique-provider, government-to-government, or extension contexts.
akil_source_health
ChatGPTCheck the live freshness and integrity status of Akil's ingested data sources — which sources are current, which are flagged stale, when each portal last updated, and how far local data reaches ('Akil through'). Jurisdiction: NYC + NYS + NJ + Federal (Akil platform meta). ROUTING: Use this when a user questions whether Akil's data is up to date, before treating an absence of recent records as meaningful, or to audit source coverage; NOT for querying the civic data itself. Accepts: staleOnly, limit. Returns: per-source status (STALE/OK/UNMEASURED), portal max event date, local max event date, last successful sync, cadence, record counts, and stale reasons from the daily freshness tripwire. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_speaker_funding
ChatGPTSearch Council Speaker discretionary funding, Speaker initiatives, funded organizations, administering agencies, and Speaker profile context. Jurisdiction: NYC. Accepts: orgName, fiscalYear, speakerName, agency, limit, offset. Returns: Speaker profile, yearly funding trend, individual awards, initiative block grants, agency breakdown, award amount, fiscal year, organization name, EIN when available, status, and source metadata. Connects to: akil_council_initiatives, akil_capital_projects, akil_top_recipients, akil_org_intelligence, akil_vendor_payments, akil_spending_trends. Coverage: NYC Council Speaker discretionary and initiative funding records. Note: Speaker allocations are often citywide program commitments; use payment tools to verify disbursement timing.
akil_spending_by_category
ChatGPTBreak actual NYC vendor payment spending into expense categories for an agency and/or fiscal year. Jurisdiction: NYC. Accepts: agency, fiscalYear, limit, offset. Returns: expense category, transaction count, total amount, average amount, minimum amount, maximum amount, grand total when available, and source metadata. Connects to: akil_spending_trends, akil_vendor_payments, akil_checkbook_contracts, akil_expense_budget, akil_budget_changes, akil_agency_staffing. Coverage: NYC Comptroller Checkbook payment records. Note: These are payment categories, not budget line items; category labels can vary across agencies.
akil_spending_trends
ChatGPTSummarize year-by-year actual vendor payment trends for an agency or vendor/payee. Jurisdiction: NYC. Accepts: agency, vendor, limit. Returns: fiscal year, transaction count, total amount, average amount, and source metadata. Connects to: akil_vendor_payments, akil_spending_by_category, akil_checkbook_contracts, akil_budget_changes, akil_expense_budget, akil_agency_staffing. Coverage: NYC Comptroller Checkbook payment records. Note: This is actual payment activity, not adopted or modified budget authority; payment timing can vary because contracts and reimbursements may span fiscal years.
akil_tax_abatements
ChatGPTCheck property tax abatements that reduce the tax bill, including 421-a/421-g, J-51, CERP, ICIP, solar, and related programs. Jurisdiction: NYC. Accepts: bbl, address, borough, block, lot, taxYr, tcCode, appStat, keyword, expiringBeforeYear, minAmount, limit, offset. Returns: BBL, tax year, abatement code/subcode, applied abatement amount, net taxes, application status, case number, benefit period, tenant fields, assessed value, and district fields when available. Connects to: tax exemptions, property assessment, property sales, property ownership, property search, and tax cliff scan. Coverage: NYC DOF abatement detail records. Note: An abatement is a direct tax-bill reduction; expiration dates should be read with program phase-out rules in mind.
akil_tax_exemptions
ChatGPTCheck property tax exemptions that reduce assessed value, including senior, veteran, disability, religious, government, ICIP, J-51, and related records. Jurisdiction: NYC. Accepts: bbl, address, borough, block, lot, year, exmpCode, status, keyword, expiringBeforeYear, limit, offset. Returns: BBL, fiscal year and roll (tentative or final), DOF program description with the exemption code and NYS code, name on the exemption record, status, DOF's actual, transitional and billing exemption amounts, prior-year amount, benefit start, duration, building class, tax class, and district fields when available. Connects to: property assessment, tax abatements, property search, property ownership, ACRIS transactions, and tax cliff scan. Coverage: NYC DOF exemption detail records. Note: Exemptions reduce assessed value; abatements reduce the actual tax bill, so use the abatement tool for direct tax-bill reductions. An exemption record is a property-tax filing, not a verified personal profile; do not infer a named person's age, disability, veteran status or religion from the benefit code.
akil_tax_lien_sales
ChatGPTFind properties that appeared on NYC DOF tax lien sale eligibility lists by borough, BBL, community board, council district, cycle, building class, ZIP, water-debt flag, keyword, or list-date range. Jurisdiction: NYC. Accepts: borough, bbl, communityBoard, councilDistrict, cycle, buildingClass, zip, waterDebtOnly, keyword, dateAfter, dateBefore, limit, offset. Returns: address, BBL, borough, cycle, building/tax class, community board, council district, ZIP, water-debt flag, sale/list date when available, and source metadata. Connects to: akil_property_charges, akil_property_assessment, akil_building_violation_record, akil_property_ownership, akil_re_property_report. Coverage: NYC DOF tax lien sale eligibility list records. Note: This is a list appearance, not proof that a lien was sold or that the property is currently delinquent.
akil_tobacco_license_caps
ChatGPTCheck raw tobacco retail dealer and electronic cigarette retail dealer license caps, active counts, and available slots by community district. Jurisdiction: NYC. ROUTING: Use akil_tobacco_retail_licenses for individual tobacco/vape license records near an address. Accepts: borough, community district, keyword, data-as-of date. Returns: community district cap, active count, available count, e-cig cap/count/available values, and source date. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations. Note: cap availability is raw community-district context, not approval of a specific application or proof a slot is currently available.
akil_tobacco_retail_licenses
ChatGPTFind tobacco retail dealer, electronic cigarette dealer, and other tobacco product license records for smoke-shop, vape, bodega, and regulated-location checks. Jurisdiction: NYC. ROUTING: Use akil_tobacco_license_caps for community-district cap/saturation context; use akil_dcwp_license_applications for pending or historical applications. Accepts: business/address keyword, status, license category, BBL, BIN, borough, ZIP, council/community district, lat/lon/radius. Returns: license number, business, category, status, issue/expiration dates, address, BBL, BIN, district anchors, and map points when available. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations. Note: license rows are source-record signals, not legal advice or full operating clearance by themselves.
akil_top_recipients
ChatGPTRank organizations by total government award amount across funding sources, fiscal years, agencies, geographies, or categories. Jurisdiction: NYC + NYS + Federal. Accepts: sourceKey, fiscalYear, geography, agency, category, limit, offset. Returns: organization name, award count, total amount, earliest and latest fiscal year, source keys, and ranking. Connects to: akil_funding_profile, akil_org_intelligence, akil_nonprofit_profile, akil_vendor_payments, akil_checkbook_contracts, akil_search_grants, akil_council_recipient_funding. Coverage: Aggregated public award records including NYC discretionary funding, NYC contracts, DCLA, ESD, and federal award data. Note: Rankings use award amounts, not actual payment timing; use vendor payments to verify disbursements.
akil_vacate_orders
ChatGPTSearch HPD vacate orders by borough short name, BBL, building ID, primary reason, vacate type, council district, keyword, or effective-date range. Jurisdiction: NYC. Accepts: boroShortName, bbl, buildingId, primaryVacateReason, vacateType, councilDistrict, keyword, dateAfter, dateBefore, limit, offset. Returns: address, primary and secondary reason when available, partial/entire building scope, effective date, rescind date, active status, units vacated, building ID, BBL, ZIP, and districts. Connects to: akil_hpd_violations, akil_hpd_litigations, akil_building_violation_record, akil_building_violations, akil_property_ownership. Coverage: NYC HPD vacate order records. Note: A null rescind date usually means the order remains active; partial vacates and entire-building vacates should not be interpreted the same way.
akil_vendor_payments
ChatGPTSearch actual NYC Checkbook payments and disbursements to a vendor or payee across agencies and fiscal years. Jurisdiction: NYC. Accepts: vendor/payee name, optional agency, optional fiscal year, pagination. Returns: payee name, agency, check amount, issue date, expense category, fiscal year, and total paid when available. Connects to: org lookup, funding profile, checkbook contracts, spending by category, contract amendments, expiring contracts, procurement search. Coverage: NYC Comptroller Checkbook payment records. Note: Payments are disbursements, not contract registrations or award allocations; payroll records are separate.
akil_who_lobbies_agency
ChatGPTFind organizations, clients, and lobbying firms that reported lobbying activity targeting a specific NYC agency or agency acronym. Jurisdiction: NYC. Accepts: agency name/acronym, optional year, pagination. Returns: client names, lobbying firms, reported compensation, registration counts, and agency-resolution notes when available. Connects to: lobbying by subject, who lobbies council member, agency spending, budget changes, procurement/contracts, organization lookup, campaign finance. Coverage: NYC eLobbyist records. Note: Listed targets can be broad; a registration does not prove direct contact with a specific official.
akil_who_lobbies_member
ChatGPTFind organizations, clients, and lobbying firms that reported lobbying activity targeting a specific NYC Council member. Jurisdiction: NYC. Accepts: council member name, optional year, pagination. Returns: clients, industries, lobbying firms, reported compensation, registration counts, and source metadata. Connects to: council member profile, campaign finance, campaign bundlers, capital projects, council legislation, lobbying by subject. Coverage: NYC eLobbyist records. Note: Broad registrations may list many council members; use subject, client, and year context before inferring targeted activity.
akil_zoning_features
ChatGPTAtomic DCP zoning-feature metadata lookup for zoning districts, commercial overlays, special districts/subdistricts, limited-height districts, zoning-map amendments, MIH, and IH areas. Jurisdiction: NYC. ROUTING: Use this when the user asks what a zoning feature/code is or wants rows for a known feature; use akil_parcel_land_use_evidence when the user has an address or BBL. Accepts: sourceKey, layerKey, featureCode, limit. Returns: feature label/code/name, interpreted zoning feature family/caveats, layer, source key, borough code, zoning map, status, effective date, and source object ID. EMITS ANCHORS: sourceKey, layerKey, featureCode, zoningMap. CHAIN TO: akil_parcel_land_use_evidence, akil_zoning_tax_lots, akil_land_use_search. Coverage: NYC DCP zoning spatial feature metadata; not a parcel eligibility or legal-use determination. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
akil_zoning_tax_lots
ChatGPTAtomic Zoning Tax Lot Database search by BBL, borough code, zoning district, or special district. Jurisdiction: NYC. ROUTING: Use this when the user needs raw ZTLDB rows; use akil_parcel_land_use_evidence for the BBL-centered composite evidence packet, and akil_zoning_features for DCP zoning-feature metadata. Accepts: BBL, boroughCode, zoningDistrict, specialDistrict, limit. Returns: ZTLDB tax-lot rows with BBL, borough/block/lot, raw zoning districts, interpreted zoning family/context/caveats, special district, zoning map reference, and update timestamp. EMITS ANCHORS: BBL, boroughCode, block, lot, zoningDistrict, specialDistrict, zoningMap. CHAIN TO: akil_parcel_land_use_evidence, akil_property_search, akil_zoning_features, akil_land_use_search. Coverage: NYC Zoning Tax Lot Database; preliminary public-record evidence only, not legal or architectural advice. Coverage limited to New York City, New York State, New Jersey, and Federal data relevant to NY-based organizations.
