{"app":"Vigil — India Red Flag Tracker","description":"Credit ratings, insider trading, pledge data, SAST disclosures, encumbrance events, surveillance flags, and related party transactions for Indian listed companies. All data sourced from NSE (National Stock Exchange of India).","base_url":"/vigil/v1","endpoints":{"catalog":{"path":"/vigil/v1/","description":"This catalog — lists all endpoints, tables, and columns"},"tables":{"path":"/vigil/v1/tables","description":"All table names with row counts, data range, and last sync time"},"companies":{"path":"/vigil/v1/companies","description":"Unique list of all companies with symbol, name, and ISIN","example":"/vigil/v1/companies"},"company_lookup":{"path":"/vigil/v1/company/{symbol}","description":"All data for a single company across all tables, with per-table record counts","example":"/vigil/v1/company/RELIANCE","params":{"tables":"Optional. Comma-separated table names to include (default: all)"}},"table_data":{"path":"/vigil/v1/data/{table_name}","description":"Paginated JSON data from a single table","example":"/vigil/v1/data/credit_ratings?limit=1000&offset=0","params":{"limit":"Rows per page (default: 1000, max: 5000)","offset":"Row offset for pagination (default: 0)"}},"download":{"path":"/vigil/v1/download/{table_name}","description":"Download full table as a pre-generated file","example":"/vigil/v1/download/credit_ratings?format=csv","params":{"format":"File format: csv, tsv, sqlite (each returned as a .zip archive, Content-Type application/zip), csv.gz, tsv.gz, sqlite.gz (gzip), or parquet (uncompressed). Note: bare csv/tsv/sqlite are ZIP, the .gz variants are gzip. See /vigil/v1/downloads/manifest for the authoritative file list."}},"download_all":{"path":"/vigil/v1/download/all","description":"Download all tables in a single gzipped SQLite file","example":"/vigil/v1/download/all?format=sqlite","params":{"format":"File format: sqlite (returned as .zip) or sqlite.gz (gzip). Other formats are rejected with 400."}},"freshness":{"path":"/vigil/v1/freshness","description":"Data freshness — last sync time and record count per table"}},"tables":{"credit_ratings":{"description":"NSE Centralised Rating Database — instrument-level credit ratings from all agencies (CRISIL, ICRA, CARE, India Ratings, Acuite, Brickwork, Infomerics). ~10K records from Jan 2024.","columns":["record_id","app_id","company_name","isin","equity_isin","nse_symbol","instrument_type","instrument_name","rating_agency","credit_rating","rating_action","date_of_rating","outlook","credit_rating_earlier","rating_action_earlier","outlook_earlier","date_of_rating_earlier","broadcast_datetime","signatory_name","designation","place","verify_status","match_method","listing_status","source_month","xbrl_url","red_flag_reason"]},"insider_trading":{"description":"NSE PIT (Prohibition of Insider Trading) disclosures — promoter, director, and KMP buy/sell/pledge transactions. ~31K records from Feb 2024.","columns":["did","pid","symbol","company","regulation","acq_name","person_category","transaction_type","sec_type","no_of_securities","sec_value","before_shares","before_pct","after_shares","after_pct","acq_mode","acq_from_date","acq_to_date","intimation_date","broadcast_datetime","exchange","xbrl_url"]},"pledge_data":{"description":"NSE promoter pledge/encumbrance snapshot — current pledge levels for ~1,500 listed companies. Snapshot-based (latest quarter only).","columns":["record_id","com_name","nse_symbol","shp_quarter","tot_issued_shares","tot_promoter_holding","perc_promoter_holding","tot_public_holding","encumbered_shares","perc_encumbered_promoter","perc_encumbered_total","num_shares_pledged","tot_demat_shares","shares_collateral","nbfc_promo_share","nbfc_non_promo_share","perc_shares_pledged","broadcast_dt","disclosure_from_date","disclosure_to_date","comp_broadcast_date","pledge_value_cr","sec_pledge_value_cr","sync_date"]},"sast_disclosures":{"description":"NSE SAST Reg 29 disclosures — substantial acquisition/sale of shares and takeover code filings. ~10K records from Jan 2024.","columns":["application_no","symbol","company","acquirer_name","acquirer_date","acq_sale_type","acquisition_mode","acq_type","promoter_type","reg_type","shares_acquired","shares_sold","shares_after","pct_acquired","pct_acquired_diluted","pct_sold","pct_sold_diluted","pct_after","pct_after_diluted","remarks","filing_url","broadcast_datetime","broadcast_time","sys_time","time_difference","isin","listing_status"]},"encumbrance_events":{"description":"NSE SAST Reg 31/32 encumbrance events — promoter share pledge creation, release, and invocation. ~1,400 records from Jan 2024.","columns":["id","seq_id","symbol","company_name","promoter_name","event_type","encumbrance_type","event_date_from","event_date_to","reporting_date","broadcast_datetime","pre_event_shares","pre_event_pct","event_shares","event_pct","post_event_encumb_shares","post_event_encumb_pct","entity_in_favor","reason","lender_name","filing_url","source_api"]},"surveillance_flags":{"description":"NSE surveillance flags — ASM, GSM, ESM, IRP, ICA, and other regulatory flags. Snapshot-based (~400 flagged companies).","columns":["symbol","series","gsm_stage","long_term_asm_stage","short_term_asm_stage","esm_stage","is_irp","is_ica","is_loss_making","is_encumbered_50pct","is_pledge_flagged","is_bz_sz","is_listing_fee_default","sync_date"]},"rpt_transactions":{"description":"Related Party Transactions from XBRL filings — half-yearly RPT data for Nifty Total Market companies. ~250K records.","columns":["record_id","seq_num","txn_number","symbol","company_name","period_end_date","broadcast_date","audited","filing_type_sub","entity_name","counter_party","relationship","transaction_type","other_details","approved_value","amount_during_period","outstanding_balance","audit_committee_remarks","loan_nature","loan_interest_rate","loan_tenure","loan_secured","loan_purpose","entity_pan","counter_party_pan","source","xbrl_url","rel_group","broadcast_date_parsed","period_end_date_parsed"]}},"rate_limit":"30 requests per minute per IP (downloads: 10 per minute)","source":"https://vigil.tigzig.com"}