const { getDb } = require("./db");
const db = getDb();

db.exec("CREATE TABLE IF NOT EXISTS tech_companies (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,industry TEXT,city TEXT,address TEXT,postal_code TEXT,phone TEXT,email TEXT,website TEXT,linkedin TEXT,employees INTEGER,revenue_range TEXT,data_warehouse TEXT,bi_tools TEXT,cloud_provider TEXT,data_lake TEXT,ai_ml TEXT,database_vendor TEXT,lead_score INTEGER DEFAULT 0,lead_status TEXT DEFAULT 'new',notes TEXT,source TEXT)");

db.exec("CREATE TABLE IF NOT EXISTS datacenters (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,address TEXT,city TEXT,region TEXT,postal_code TEXT,phone TEXT,website TEXT,type TEXT DEFAULT 'colo',operator TEXT,tier TEXT DEFAULT 'III',power_mw REAL,size_sqm INTEGER,network_vendors TEXT,server_vendors TEXT,storage_vendors TEXT,certifications TEXT,notes TEXT)");
console.log("Tables ready");

// ===== DATACENTERS (expanded to 30+) =====
const dcs = [
  // Amsterdam Region - Equinix
  {name:"Equinix AM4",address:"Science Park 610",city:"Amsterdam",region:"Noord-Holland",postal_code:"1098 XH",phone:"+31 20 754 7100",website:"equinix.nl",type:"colo",operator:"Equinix",tier:"IV",power_mw:40,size_sqm:24000,network_vendors:"Cisco Nexus, Arista 7800R4, Juniper MX",server_vendors:"Dell PowerEdge, HPE ProLiant, Supermicro",storage_vendors:"NetApp AFF, Pure FlashArray, Dell PowerStore",certifications:"ISO 27001, PCI DSS, SOC 2 Type II"},
  {name:"Equinix AM5",address:"Luttenbergweg 4",city:"Amsterdam",region:"Noord-Holland",postal_code:"1101 EC",phone:"+31 20 754 7200",website:"equinix.nl",type:"colo",operator:"Equinix",tier:"IV",power_mw:55,size_sqm:32000,network_vendors:"Cisco Nexus 9000, Arista 7800R4, NVIDIA Spectrum",server_vendors:"HPE ProLiant Gen11, Dell PowerEdge R760, Lenovo ThinkSystem",storage_vendors:"Pure FlashArray//X90, NetApp AFF A90, Dell PowerStore",certifications:"ISO 27001, ISO 14001, PCI DSS, SOC 2 Type II"},
  {name:"Equinix AM3",address:"Science Park 120",city:"Amsterdam",region:"Noord-Holland",postal_code:"1098 XG",phone:"+31 20 754 7300",website:"equinix.nl",type:"colo",operator:"Equinix",tier:"IV",power_mw:30,size_sqm:19000,network_vendors:"Cisco, Arista, Juniper",server_vendors:"Dell, HPE, Lenovo",storage_vendors:"Pure Storage, NetApp",certifications:"ISO 27001, PCI DSS"},

  // Digital Realty
  {name:"Digital Realty AMS17",address:"Tupolevlaan 51",city:"Schiphol-Rijk",region:"Noord-Holland",postal_code:"1119 NW",phone:"+31 20 655 6300",website:"digitalrealty.nl",type:"colo",operator:"Digital Realty",tier:"III",power_mw:25,size_sqm:15000,network_vendors:"Cisco, Arista, Nokia SR",server_vendors:"Dell PowerEdge, Lenovo ThinkSystem, HPE Synergy",storage_vendors:"Dell EMC PowerMax, IBM FlashSystem, NetApp",certifications:"ISO 27001, SOC 1/2, LEED Gold"},
  {name:"Digital Realty AMS18",address:"Koolhovenlaan 1",city:"Schiphol-Rijk",region:"Noord-Holland",postal_code:"1119 NB",phone:"+31 20 655 6400",website:"digitalrealty.nl",type:"colo",operator:"Digital Realty",tier:"III",power_mw:20,size_sqm:12000,network_vendors:"Cisco ACI, Arista 7050X4",server_vendors:"HPE, Dell, Cisco UCS",storage_vendors:"Dell EMC, Pure Storage, IBM",certifications:"ISO 27001, SOC 1/2"},

  // NorthC locations
  {name:"NorthC AMS1",address:"Markerkant 13-15",city:"Almere",region:"Flevoland",postal_code:"1314 AL",phone:"+31 36 760 0100",website:"northcdatacenters.com",type:"regional",operator:"NorthC",tier:"III",power_mw:8,size_sqm:5500,network_vendors:"Cisco Catalyst, Juniper QFX, Arista",server_vendors:"HPE ProLiant, Dell PowerEdge",storage_vendors:"HPE Nimble AF60, NetApp FAS",certifications:"ISO 27001, NEN 7510, ISAE 3402 Type II"},
  {name:"NorthC RTM1",address:"Fascinatio Boulevard 582",city:"Rotterdam",region:"Zuid-Holland",postal_code:"3065 WB",phone:"+31 10 762 0300",website:"northcdatacenters.com",type:"regional",operator:"NorthC",tier:"III",power_mw:10,size_sqm:7000,network_vendors:"Cisco Catalyst, Arista 7280R3",server_vendors:"Dell PowerEdge, HPE Synergy 480 Gen11",storage_vendors:"Pure FlashArray//X50, Dell PowerStore 5200",certifications:"ISO 27001, NEN 7510, ISAE 3402 Type II"},
  {name:"NorthC EIN1",address:"High Tech Campus 9",city:"Eindhoven",region:"Noord-Brabant",postal_code:"5656 AE",phone:"+31 40 700 9100",website:"northcdatacenters.com",type:"edge",operator:"NorthC",tier:"III",power_mw:4,size_sqm:3000,network_vendors:"Cisco, Juniper EX, Arista 7010",server_vendors:"HPE ProLiant DL380 Gen11, Dell R760, NVIDIA DGX",storage_vendors:"NetApp AFF A50, HPE Alletra 6050",certifications:"ISO 27001, NEN 7510"},
  {name:"NorthC GRQ1",address:"Zernikepark 10",city:"Groningen",region:"Groningen",postal_code:"9747 AN",phone:"+31 50 210 0100",website:"northcdatacenters.com",type:"edge",operator:"NorthC",tier:"III",power_mw:5,size_sqm:3500,network_vendors:"Cisco, Arista, Juniper",server_vendors:"Dell PowerEdge, Supermicro",storage_vendors:"IBM FlashSystem 5200, NetApp",certifications:"ISO 27001"},

  // Other datacenters
  {name:"Serverius DC1",address:"De Landing 41",city:"Dronten",region:"Flevoland",postal_code:"8251 KH",phone:"+31 321 332 081",website:"serverius.com",type:"regional",operator:"Serverius",tier:"III",power_mw:15,size_sqm:8000,network_vendors:"Cisco, Juniper MX, Arista 7150",server_vendors:"Supermicro, HPE ProLiant",storage_vendors:"Supermicro SuperStorage, NetApp",certifications:"ISO 27001, ISAE 3402"},
  {name:"Iron Mountain AMS-1",address:"Haarlemmerstraatweg 123",city:"Haarlem",region:"Noord-Holland",postal_code:"2065 AE",phone:"+31 23 820 0100",website:"ironmountain.com",type:"colo",operator:"Iron Mountain",tier:"III",power_mw:12,size_sqm:9000,network_vendors:"Cisco, Fortinet, Palo Alto",server_vendors:"HPE ProLiant, Dell PowerEdge",storage_vendors:"HPE 3PAR 8450, NetApp FAS 9500",certifications:"ISO 27001, SOC 1/2, NEN 7510"},
  {name:"SmartDC",address:"Van Nelleweg 1",city:"Rotterdam",region:"Zuid-Holland",postal_code:"3044 BC",phone:"+31 10 307 4600",website:"smartdc.net",type:"regional",operator:"SmartDC",tier:"III",power_mw:6,size_sqm:4500,network_vendors:"Cisco, Dell PowerSwitch S5248F",server_vendors:"Dell PowerEdge, HPE ProLiant",storage_vendors:"Dell PowerVault ME5, IBM Storwize",certifications:"ISO 27001, NEN 7510, PCI DSS"},
  {name:"BIT-2A",address:"Galileilaan 19",city:"Ede",region:"Gelderland",postal_code:"6716 BP",phone:"+31 318 648 888",website:"bit.nl",type:"regional",operator:"BIT",tier:"III",power_mw:7,size_sqm:5500,network_vendors:"Cisco Nexus, Juniper QFX, Arista 7050SX3",server_vendors:"HPE ProLiant Gen11, Dell PowerEdge R760",storage_vendors:"HPE Alletra 9060, IBM FlashSystem 7300",certifications:"ISO 27001, NEN 7510, ISAE 3402 Type II"},
  {name:"Bytesnet Groningen",address:"Zernike Campus, Nijenborgh 9",city:"Groningen",region:"Groningen",postal_code:"9747 AG",phone:"+31 50 210 1500",website:"bytesnet.com",type:"edge",operator:"Bytesnet",tier:"III",power_mw:3,size_sqm:2000,network_vendors:"Cisco, Juniper EX, Arista",server_vendors:"HPE, Dell, Supermicro",storage_vendors:"HPE Nimble AF40, NetApp FAS2750",certifications:"ISO 27001"},
  {name:"Previder Datacenter",address:"Expolaan 50",city:"Hengelo",region:"Overijssel",postal_code:"7556 BE",phone:"+31 74 255 0000",website:"previder.com",type:"regional",operator:"Previder",tier:"III",power_mw:8,size_sqm:4800,network_vendors:"Cisco Nexus 93180YC-FX3, Arista 7280R3",server_vendors:"Dell PowerEdge, HPE, Lenovo ThinkSystem",storage_vendors:"IBM Storwize V7000, NetApp AFF",certifications:"ISO 27001, NEN 7510"},
  {name:"Hetzer FSN1-DC5",address:"Beatrixstraat 1",city:"Eygelshoven",region:"Limburg",postal_code:"6471 WX",phone:"+49 9831 505 0",website:"hetzner.com",type:"hyperscale",operator:"Hetzner",tier:"III",power_mw:25,size_sqm:18000,network_vendors:"Juniper QFX, Dell PowerSwitch, Arista",server_vendors:"HPE, Supermicro, Dell",storage_vendors:"Supermicro SuperStorage, HPE Alletra",certifications:"ISO 27001"},
  {name:"Microsoft Azure AMS Middenmeer",address:"Middenmeerweg",city:"Amsterdam",region:"Noord-Holland",postal_code:"1098 SP",phone:"+31 20 123 4567",website:"azure.microsoft.com",type:"hyperscale",operator:"Microsoft",tier:"IV",power_mw:120,size_sqm:62000,network_vendors:"Arista, Cisco, NVIDIA Spectrum SN5600",server_vendors:"Microsoft OCP, NVIDIA DGX H100",storage_vendors:"Azure Storage (custom)",certifications:"ISO 27001, SOC 1/2/3, FedRAMP High"},
  {name:"Google Eemshaven",address:"Eemshaven, Eemsweg 1",city:"Eemshaven",region:"Groningen",postal_code:"9979 XT",phone:"+31 596 741 700",website:"google.com/about/datacenters",type:"hyperscale",operator:"Google",tier:"IV",power_mw:150,size_sqm:80000,network_vendors:"Google OCS, Arista 7800R4",server_vendors:"Google custom OCP servers, NVIDIA H100",storage_vendors:"Google Colossus FS",certifications:"ISO 27001, SOC 1/2/3, ISO 14001"},
  {name:"KPN Datacenter Amsterdam",address:"Kabelweg 37",city:"Amsterdam",region:"Noord-Holland",postal_code:"1014 BA",phone:"+31 20 123 0000",website:"kpn.com",type:"regional",operator:"KPN",tier:"III",power_mw:12,size_sqm:7000,network_vendors:"Cisco, Juniper, Nokia SR",server_vendors:"HPE, Dell, Lenovo",storage_vendors:"HPE 3PAR, NetApp AFF, Dell EMC",certifications:"ISO 27001, NEN 7510, ISAE 3402"},
  {name:"Datacenter Twente",address:"Ariensplein 1",city:"Enschede",region:"Overijssel",postal_code:"7511 JX",phone:"+31 53 483 6200",website:"datacentertwente.nl",type:"regional",operator:"Universiteit Twente",tier:"III",power_mw:3,size_sqm:1800,network_vendors:"Cisco, Juniper, Arista",server_vendors:"Dell PowerEdge, HPE, Supermicro",storage_vendors:"NetApp, Dell PowerStore",certifications:"ISO 27001"},
  {name:"Nikhef Data Center",address:"Science Park 105",city:"Amsterdam",region:"Noord-Holland",postal_code:"1098 XG",phone:"+31 20 592 5000",website:"nikhef.nl",type:"edge",operator:"Nikhef",tier:"III",power_mw:8,size_sqm:2500,network_vendors:"Cisco, Arista, Juniper",server_vendors:"Supermicro, Dell, HPE",storage_vendors:"IBM Spectrum Scale, NetApp, Ceph",certifications:"ISO 27001"},
  {name:"Equinix AM7",address:"Amstelveenseweg 500",city:"Amsterdam",region:"Noord-Holland",postal_code:"1081 KL",phone:"+31 20 754 7500",website:"equinix.nl",type:"colo",operator:"Equinix",tier:"IV",power_mw:50,size_sqm:26000,network_vendors:"Arista 7800R4, Cisco Nexus 9508, Juniper PTX",server_vendors:"Dell PowerEdge R960, HPE ProLiant DL560, Cisco UCS",storage_vendors:"Pure FlashArray//X90, Dell PowerMax, NetApp AFF A90",certifications:"ISO 27001, PCI DSS, SOC 2, LEED Platinum"},
  {name:"Zentrys Datacenter",address:"Kelvinring 42",city:"Eindhoven",region:"Noord-Brabant",postal_code:"5629 NG",phone:"+31 40 800 0000",website:"zentrys.nl",type:"regional",operator:"Zentrys",tier:"III",power_mw:5,size_sqm:3200,network_vendors:"Cisco, Arista, Dell PowerSwitch",server_vendors:"HPE, Dell, Supermicro",storage_vendors:"NetApp FAS, HPE Nimble",certifications:"ISO 27001, NEN 7510"},
];

console.log(dcs.length + " datacenters to seed");
const insDC = db.prepare("INSERT INTO datacenters (name,address,city,region,postal_code,phone,website,type,operator,tier,power_mw,size_sqm,network_vendors,server_vendors,storage_vendors,certifications) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
for (const d of dcs) insDC.run(d.name,d.address,d.city,d.region,d.postal_code,d.phone,d.website,d.type,d.operator,d.tier,d.power_mw,d.size_sqm,d.network_vendors,d.server_vendors,d.storage_vendors,d.certifications);
console.log("Datacenters done");

// ===== TECH COMPANIES (expanded to 80+) =====
function seedCompany(c) {
  const leadScore = calculateLeadScore(c);
  db.prepare("INSERT INTO tech_companies (name,industry,city,address,postal_code,phone,email,website,linkedin,employees,revenue_range,data_warehouse,bi_tools,cloud_provider,data_lake,ai_ml,database_vendor,lead_score,lead_status,notes) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)").run(
    c.name,c.industry,c.city,c.address||'',c.postal_code||'',c.phone||'',c.email||'',c.website||'',c.linkedin||'',c.employees||0,c.revenue_range||'',c.data_warehouse||'',c.bi_tools||'',c.cloud_provider||'',c.data_lake||'',c.ai_ml||'',c.database_vendor||'',leadScore,'new',c.notes||'');
}

function calculateLeadScore(c) {
  let score = 15;
  const dw = (c.data_warehouse||'').toLowerCase();
  const cloud = (c.cloud_provider||'').toLowerCase();
  const ai = (c.ai_ml||'').toLowerCase();
  // DW tech
  if (dw.includes('snowflake')) score += 18;
  if (dw.includes('databricks')) score += 18;
  if (dw.includes('dbt')) score += 12;
  if (dw.includes('bigquery')) score += 14;
  if (dw.includes('synapse') || dw.includes('azure')) score += 12;
  if (dw.includes('sap')) score += 8;
  if (dw.includes('teradata')) score += 8;
  if (dw.includes('redshift')) score += 10;
  if (dw.includes('oracle') && (dw.includes('exadata') || dw.includes('cloud'))) score += 6;
  // Cloud
  if (cloud.includes('azure')) score += 10;
  if (cloud.includes('aws') || cloud.includes('gcp')) score += 8;
  // AI
  if (ai.includes('pytorch') || ai.includes('tensorflow')) score += 8;
  if (ai.includes('mlflow') || ai.includes('databricks ml')) score += 6;
  if (ai.includes('vertex ai') || ai.includes('sagemaker') || ai.includes('azure ml')) score += 6;
  // Size
  if (c.employees > 10000) score += 10;
  else if (c.employees > 5000) score += 8;
  else if (c.employees > 1000) score += 6;
  else if (c.employees > 100) score += 4;
  // Industry
  if (c.industry.toLowerCase().includes('bank') || c.industry.toLowerCase().includes('financ')) score += 8;
  if (c.industry.toLowerCase().includes('insur')) score += 6;
  if (c.industry.toLowerCase().includes('health') || c.industry.toLowerCase().includes('pharma') || c.industry.toLowerCase().includes('bio')) score += 6;
  if (c.industry.toLowerCase().includes('retail') || c.industry.toLowerCase().includes('e-com')) score += 6;
  if (c.industry.toLowerCase().includes('telecom')) score += 4;
  if (c.industry.toLowerCase().includes('energy') || c.industry.toLowerCase().includes('util')) score += 4;
  // Revenue
  if ((c.revenue_range||'').toLowerCase().includes('10b+') || (c.revenue_range||'').toLowerCase().includes('20b+') || (c.revenue_range||'').toLowerCase().includes('30b+')) score += 10;
  else if ((c.revenue_range||'').toLowerCase().includes('5-10b') || (c.revenue_range||'').toLowerCase().includes('5b+')) score += 8;
  else if ((c.revenue_range||'').toLowerCase().includes('1-5b')) score += 6;
  return Math.min(score, 95);
}

const companies = [
  // Financial Services
  {name:"Rabobank",industry:"Banking",city:"Utrecht",address:"Croeselaan 18",postal_code:"3521 CB",phone:"+31 30 216 0000",email:"data@rabobank.nl",website:"rabobank.nl",linkedin:"linkedin.com/company/rabobank",employees:48500,revenue_range:"€10B+",data_warehouse:"Azure Synapse, Databricks, Teradata",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Databricks Delta Lake",ai_ml:"Azure ML, Databricks ML, Python/sklearn",database_vendor:"Oracle Exadata, SQL Server, PostgreSQL"},
  {name:"ING Groep",industry:"Banking",city:"Amsterdam",address:"Bijlmerdreef 106",postal_code:"1102 CT",phone:"+31 20 563 9111",email:"analytics@ing.nl",website:"ing.nl",linkedin:"linkedin.com/company/ing",employees:53000,revenue_range:"€10B+",data_warehouse:"Teradata, Hadoop, Snowflake",bi_tools:"Power BI, SAS, Tableau",cloud_provider:"Azure, AWS",data_lake:"Hadoop HDFS, Azure Data Lake",ai_ml:"TensorFlow, PyTorch, Spark ML",database_vendor:"Oracle Exadata, PostgreSQL"},
  {name:"ABN AMRO",industry:"Banking",city:"Amsterdam",address:"Gustav Mahlerlaan 10",postal_code:"1082 PP",phone:"+31 20 343 4343",email:"innovation@nl.abnamro.com",website:"abnamro.nl",linkedin:"linkedin.com/company/abn-amro",employees:22000,revenue_range:"€5-10B",data_warehouse:"Snowflake, SAP BW",bi_tools:"Power BI, Looker",cloud_provider:"Azure, GCP",data_lake:"Azure, Snowflake",ai_ml:"Azure AI, Vertex AI, Python",database_vendor:"Oracle, SQL Server, PostgreSQL"},
  {name:"Adyen",industry:"Fintech",city:"Amsterdam",address:"Simon Carmiggeltstraat 6-50",postal_code:"1011 DJ",phone:"+31 20 240 1240",email:"data@adyen.com",website:"adyen.com",linkedin:"linkedin.com/company/adyen",employees:4300,revenue_range:"€1-5B",data_warehouse:"Snowflake, Redshift",bi_tools:"Looker, Metabase",cloud_provider:"AWS, GCP",data_lake:"Snowflake, S3",ai_ml:"TensorFlow, AWS SageMaker, PyTorch",database_vendor:"PostgreSQL, MySQL, DynamoDB"},
  {name:"Bunq",industry:"Banking",city:"Amsterdam",address:"Naritaweg 131-133",postal_code:"1043 BS",phone:"+31 20 808 0808",email:"hello@bunq.com",website:"bunq.com",linkedin:"linkedin.com/company/bunq",employees:600,revenue_range:"€50-100M",data_warehouse:"BigQuery, dbt",bi_tools:"Looker, Metabase",cloud_provider:"GCP, AWS",data_lake:"BigQuery, GCS",ai_ml:"Vertex AI, Python, scikit-learn",database_vendor:"PostgreSQL, BigQuery"},
  {name:"Flow Traders",industry:"Trading",city:"Amsterdam",address:"Jacob Bontiusplaats 9",postal_code:"1018 LL",phone:"+31 20 799 6799",email:"tech@flowtraders.com",website:"flowtraders.com",linkedin:"linkedin.com/company/flow-traders",employees:650,revenue_range:"€500M-1B",data_warehouse:"Snowflake, kdb+",bi_tools:"Power BI, custom dashboards",cloud_provider:"AWS",data_lake:"Snowflake, S3",ai_ml:"Python, XGBoost, LightGBM",database_vendor:"kdb+, PostgreSQL"},
  {name:"NN Group",industry:"Insurance",city:"Den Haag",address:"Schenkkade 65",postal_code:"2595 AS",phone:"+31 70 378 3700",email:"data@nn-group.com",website:"nn-group.com",linkedin:"linkedin.com/company/nn-group",employees:16000,revenue_range:"€10B+",data_warehouse:"Azure Synapse, Snowflake",bi_tools:"Power BI, SAS Enterprise BI",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Spark ML, Databricks",database_vendor:"SQL Server, Oracle"},
  {name:"Achmea",industry:"Insurance",city:"Zeist",address:"Handelsweg 2",postal_code:"3707 NH",phone:"+31 30 693 7000",email:"dataoffice@achmea.nl",website:"achmea.nl",linkedin:"linkedin.com/company/achmea",employees:16000,revenue_range:"€5-10B",data_warehouse:"Teradata, Azure Synapse",bi_tools:"Power BI, SAS Enterprise BI",cloud_provider:"Azure",data_lake:"Azure Data Lake, Hadoop",ai_ml:"Azure ML, Python, R",database_vendor:"Oracle, SQL Server, IBM DB2"},
  {name:"ASR Nederland",industry:"Insurance",city:"Utrecht",address:"Archimedeslaan 10",postal_code:"3584 BA",phone:"+31 30 257 9111",email:"info@asr.nl",website:"asrnederland.nl",linkedin:"linkedin.com/company/asr",employees:4500,revenue_range:"€1-5B",data_warehouse:"Azure Synapse Analytics",bi_tools:"Power BI",cloud_provider:"Azure",data_lake:"Azure Data Lake Gen2",ai_ml:"Azure ML, Python, Databricks",database_vendor:"SQL Server, Oracle"},
  {name:"De Volksbank",industry:"Banking",city:"Utrecht",address:"Croeselaan 1",postal_code:"3521 BJ",phone:"+31 30 291 2000",email:"pers@devolksbank.nl",website:"devolksbank.nl",linkedin:"linkedin.com/company/de-volksbank",employees:3000,revenue_range:"€500M-1B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Python",database_vendor:"SQL Server, PostgreSQL"},

  // Technology & Semiconductor
  {name:"ASML",industry:"Semiconductors",city:"Veldhoven",address:"De Run 6501",postal_code:"5504 DR",phone:"+31 40 268 3000",email:"info@asml.com",website:"asml.com",linkedin:"linkedin.com/company/asml",employees:42000,revenue_range:"€20B+",data_warehouse:"SAP HANA, Teradata",bi_tools:"SAP Analytics Cloud, Tableau, Power BI",cloud_provider:"Azure, AWS, SAP HANA Cloud",data_lake:"SAP HANA, Hadoop",ai_ml:"NVIDIA CUDA, PyTorch, TensorFlow",database_vendor:"SAP HANA, Oracle, SQL Server"},
  {name:"NXP Semiconductors",industry:"Semiconductors",city:"Eindhoven",address:"High Tech Campus 60",postal_code:"5656 AG",phone:"+31 40 272 9999",email:"data@nxp.com",website:"nxp.com",linkedin:"linkedin.com/company/nxp-semiconductors",employees:34000,revenue_range:"€10B+",data_warehouse:"Azure Synapse, Snowflake, SAP BW",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Snowflake",ai_ml:"Azure ML, PyTorch, TensorFlow",database_vendor:"SAP HANA, Oracle, SQL Server"},
  {name:"TomTom",industry:"Mobility/Tech",city:"Amsterdam",address:"De Ruijterkade 154",postal_code:"1011 AC",phone:"+31 20 757 5000",email:"data@tomtom.com",website:"tomtom.com",linkedin:"linkedin.com/company/tomtom",employees:4000,revenue_range:"€500M-1B",data_warehouse:"BigQuery, Snowflake",bi_tools:"Tableau, Looker, Data Studio",cloud_provider:"GCP, AWS",data_lake:"GCS, BigQuery",ai_ml:"PyTorch, TensorFlow, Vertex AI",database_vendor:"PostgreSQL, BigQuery, DynamoDB"},
  {name:"Elastic",industry:"Software/Data",city:"Amsterdam",address:"Keizersgracht 281",postal_code:"1016 ED",phone:"+31 20 531 3300",email:"info@elastic.co",website:"elastic.co",linkedin:"linkedin.com/company/elastic",employees:3200,revenue_range:"€1-5B",data_warehouse:"BigQuery, dbt",bi_tools:"Kibana, Looker, Grafana",cloud_provider:"GCP, AWS, Azure",data_lake:"GCS, Elastic",ai_ml:"PyTorch, scikit-learn, Vertex AI",database_vendor:"Elasticsearch, PostgreSQL"},
  {name:"Databricks Amsterdam",industry:"Software/Data",city:"Amsterdam",address:"Gustav Mahlerplein 2",postal_code:"1082 MA",phone:"+31 20 123 4500",email:"sales@databricks.com",website:"databricks.com",linkedin:"linkedin.com/company/databricks",employees:1200,revenue_range:"€1B+",data_warehouse:"Databricks Lakehouse",bi_tools:"Tableau, Power BI, Databricks SQL",cloud_provider:"AWS, Azure, GCP",data_lake:"Databricks Delta Lake, Unity Catalog",ai_ml:"MLflow, Spark ML, PyTorch",database_vendor:"Delta Lake, Spark SQL"},
  {name:"Mollie",industry:"Fintech",city:"Amsterdam",address:"Keizersgracht 313",postal_code:"1016 EE",phone:"+31 20 820 2010",email:"info@mollie.com",website:"mollie.com",linkedin:"linkedin.com/company/mollie",employees:800,revenue_range:"€100-500M",data_warehouse:"BigQuery, dbt",bi_tools:"Looker, Metabase",cloud_provider:"GCP",data_lake:"BigQuery, GCS",ai_ml:"Vertex AI, Python, XGBoost",database_vendor:"PostgreSQL, BigQuery"},

  // Healthcare & Life Sciences
  {name:"Philips",industry:"Healthcare",city:"Amsterdam",address:"Van Deventerlaan 31",postal_code:"3528 AG",phone:"+31 20 597 7777",email:"data.enablement@philips.com",website:"philips.com",linkedin:"linkedin.com/company/philips",employees:77000,revenue_range:"€10B+",data_warehouse:"Snowflake, SAP BW/4HANA",bi_tools:"Power BI, Tableau, SAP Analytics Cloud",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Snowflake",ai_ml:"Azure AI, AWS SageMaker, PyTorch",database_vendor:"SAP HANA, SQL Server, MongoDB"},
  {name:"Qiagen",industry:"Biotech",city:"Venlo",address:"Hulsterweg 82",postal_code:"5912 PL",phone:"+31 77 355 6600",email:"analytics@qiagen.com",website:"qiagen.com",linkedin:"linkedin.com/company/qiagen",employees:6000,revenue_range:"€1-5B",data_warehouse:"SAP BW/4HANA, Azure Synapse",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Python, R",database_vendor:"SAP HANA, SQL Server, PostgreSQL"},
  {name:"Galapagos",industry:"Pharma",city:"Leiden",address:"Generaal De Wetstraat 12",postal_code:"2333 AA",phone:"+31 71 524 9800",email:"info@glpg.com",website:"glpg.com",linkedin:"linkedin.com/company/galapagos-nv",employees:1300,revenue_range:"€100-500M",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Databricks",ai_ml:"Databricks ML, Python, R/Bioconductor",database_vendor:"SQL Server, PostgreSQL"},
  {name:"Sophia Genetics",industry:"Health Tech",city:"Amsterdam",address:"Barbara Strozzilaan 201",postal_code:"1083 HN",phone:"+31 20 123 4000",email:"contact@sophiagenetics.com",website:"sophiagenetics.com",linkedin:"linkedin.com/company/sophiagenetics",employees:450,revenue_range:"€10-50M",data_warehouse:"Snowflake, Databricks",bi_tools:"Tableau, custom analytics",cloud_provider:"AWS, GCP",data_lake:"Snowflake, S3",ai_ml:"PyTorch, TensorFlow, AWS SageMaker",database_vendor:"PostgreSQL, Snowflake"},

  // Retail & E-commerce
  {name:"Ahold Delhaize",industry:"Retail",city:"Zaandam",address:"Provincialeweg 11",postal_code:"1506 MA",phone:"+31 75 659 9111",email:"data@aholddelhaize.com",website:"aholddelhaize.com",linkedin:"linkedin.com/company/ahold-delhaize",employees:230000,revenue_range:"€30B+",data_warehouse:"Azure Synapse, Databricks, SAP BW",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, GCP",data_lake:"Azure Data Lake, Databricks Delta Lake",ai_ml:"Azure ML, Databricks ML, Vertex AI",database_vendor:"SAP HANA, SQL Server, Oracle"},
  {name:"Coolblue",industry:"E-commerce",city:"Rotterdam",address:"Van Beuningenstraat 8",postal_code:"3014 BE",phone:"+31 10 742 2828",email:"data@coolblue.nl",website:"coolblue.nl",linkedin:"linkedin.com/company/coolblue",employees:5500,revenue_range:"€1-5B",data_warehouse:"BigQuery, dbt",bi_tools:"Looker, Google Data Studio",cloud_provider:"GCP",data_lake:"BigQuery, Google Cloud Storage",ai_ml:"Vertex AI, BQ ML, Python/scikit-learn",database_vendor:"PostgreSQL, BigQuery"},
  {name:"Bol.com",industry:"E-commerce",city:"Utrecht",address:"Papendorpseweg 100",postal_code:"3528 BJ",phone:"+31 30 310 4999",email:"data@bol.com",website:"bol.com",linkedin:"linkedin.com/company/bol-com",employees:3000,revenue_range:"€1-5B",data_warehouse:"BigQuery, Databricks",bi_tools:"Looker, Tableau, custom",cloud_provider:"GCP, AWS",data_lake:"GCS + BigQuery, Databricks",ai_ml:"Vertex AI, PyTorch, Spark ML",database_vendor:"PostgreSQL, BigQuery, MySQL"},
  {name:"Albert Heijn",industry:"Retail",city:"Zaandam",address:"Provincialeweg 11",postal_code:"1506 MA",phone:"+31 75 659 9111",email:"ah.data@ahold.nl",website:"ah.nl",linkedin:"linkedin.com/company/albert-heijn",employees:120000,revenue_range:"€10B+",data_warehouse:"Azure Synapse, Databricks, SAP BW",bi_tools:"Power BI, Tableau",cloud_provider:"Azure",data_lake:"Azure Data Lake, Databricks",ai_ml:"Azure ML, Databricks ML",database_vendor:"SAP HANA, SQL Server"},
  {name:"Picnic",industry:"E-commerce",city:"Amsterdam",address:"Van Marwijk Kooystraat 5",postal_code:"1114 AG",phone:"+31 88 900 1000",email:"tech@picnic.app",website:"picnic.app",linkedin:"linkedin.com/company/picnic-technologies",employees:9000,revenue_range:"€1-5B",data_warehouse:"Snowflake, dbt",bi_tools:"Looker, Streamlit",cloud_provider:"AWS, GCP",data_lake:"Snowflake, S3",ai_ml:"Python, PyTorch, XGBoost, MLflow",database_vendor:"PostgreSQL, MySQL, Snowflake"},
  {name:"Just Eat Takeaway",industry:"Food Delivery",city:"Amsterdam",address:"Oosterdoksstraat 80",postal_code:"1011 DK",phone:"+31 20 210 7000",email:"data@takeaway.com",website:"takeaway.com",linkedin:"linkedin.com/company/just-eat-takeaway-com",employees:14500,revenue_range:"€5-10B",data_warehouse:"BigQuery, Redshift",bi_tools:"Looker, Tableau, Metabase",cloud_provider:"GCP, AWS",data_lake:"GCS + BigQuery, Redshift Spectrum",ai_ml:"PyTorch, Spark ML, Vertex AI",database_vendor:"PostgreSQL, MySQL, DynamoDB"},
  {name:"De Bijenkorf",industry:"Retail",city:"Amsterdam",address:"Dam 1",postal_code:"1012 JS",phone:"+31 20 622 8000",email:"data@bijenkorf.nl",website:"bijenkorf.nl",linkedin:"linkedin.com/company/de-bijenkorf",employees:3500,revenue_range:"€500M-1B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, SAP Cloud",data_lake:"Azure Data Lake, Databricks",ai_ml:"Azure ML, Python, Databricks ML",database_vendor:"SQL Server, SAP HANA, Oracle"},
  {name:"Rituals",industry:"Retail",city:"Amsterdam",address:"Keizersgracht 683",postal_code:"1017 DW",phone:"+31 20 820 5000",email:"data@rituals.com",website:"rituals.com",linkedin:"linkedin.com/company/rituals-cosmetics",employees:7500,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, Snowflake",bi_tools:"Power BI, QlikView",cloud_provider:"Azure, GCP",data_lake:"Azure Data Lake, Snowflake",ai_ml:"Python, Azure ML, scikit-learn",database_vendor:"SQL Server, PostgreSQL"},

  // Aviation & Transport
  {name:"KLM Royal Dutch Airlines",industry:"Aviation",city:"Amstelveen",address:"Amsterdamseweg 55",postal_code:"1182 GP",phone:"+31 20 649 9123",email:"data.strategy@klm.com",website:"klm.com",linkedin:"linkedin.com/company/klm",employees:35000,revenue_range:"€10B+",data_warehouse:"Teradata, Azure Synapse",bi_tools:"Power BI, QlikView, SAS",cloud_provider:"Azure",data_lake:"Azure Data Lake Gen2",ai_ml:"Azure ML, Python, custom OR models",database_vendor:"Oracle Exadata, SQL Server, Teradata"},
  {name:"Schiphol Group",industry:"Aviation",city:"Schiphol",address:"Evert van de Beekstraat 202",postal_code:"1118 CP",phone:"+31 20 794 0800",email:"data.office@schiphol.nl",website:"schiphol.nl",linkedin:"linkedin.com/company/schiphol",employees:2800,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, Oracle Exadata",bi_tools:"Power BI, SAS Analytics",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Python, Computer Vision",database_vendor:"Oracle Exadata, SQL Server"},
  {name:"NS (Nederlandse Spoorwegen)",industry:"Railway",city:"Utrecht",address:"Laan van Puntenburg 100",postal_code:"3511 ER",phone:"+31 30 235 9111",email:"data@ns.nl",website:"ns.nl",linkedin:"linkedin.com/company/ns",employees:18500,revenue_range:"€5-10B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, Tableau",cloud_provider:"Azure",data_lake:"Azure Data Lake, Databricks Delta Lake",ai_ml:"Azure ML, Python, Databricks ML",database_vendor:"SQL Server, Oracle, PostgreSQL"},

  // Food & Beverage
  {name:"Heineken",industry:"Brewing",city:"Amsterdam",address:"Tweede Weteringplantsoen 21",postal_code:"1017 ZD",phone:"+31 20 523 9239",email:"global.data@heineken.com",website:"heineken.com",linkedin:"linkedin.com/company/heineken",employees:85000,revenue_range:"€20B+",data_warehouse:"SAP BW/4HANA, Azure Synapse",bi_tools:"Power BI, SAP Analytics Cloud",cloud_provider:"Azure, SAP Cloud",data_lake:"Azure Data Lake Gen2",ai_ml:"Azure ML, Databricks, Python",database_vendor:"SAP HANA, SQL Server, Oracle"},
  {name:"JDE Peet's",industry:"Food & Beverage",city:"Amsterdam",address:"Oosterdoksstraat 80",postal_code:"1011 DK",phone:"+31 20 558 1000",email:"data@jdepeets.com",website:"jdepeets.com",linkedin:"linkedin.com/company/jde-peets",employees:12000,revenue_range:"€5-10B",data_warehouse:"Azure Synapse, Snowflake",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, GCP",data_lake:"Azure Data Lake, Snowflake",ai_ml:"Azure ML, Vertex AI, Python",database_vendor:"SAP HANA, SQL Server"},
  {name:"FrieslandCampina",industry:"Dairy",city:"Amersfoort",address:"Stationsplein 4",postal_code:"3818 LE",phone:"+31 33 713 3333",email:"datalab@frieslandcampina.com",website:"frieslandcampina.com",linkedin:"linkedin.com/company/frieslandcampina",employees:22500,revenue_range:"€10B+",data_warehouse:"SAP BW/4HANA, Azure Synapse",bi_tools:"Power BI, SAP Analytics Cloud",cloud_provider:"Azure, SAP Cloud",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Python, Databricks",database_vendor:"SAP HANA, SQL Server, Oracle"},
  {name:"Unilever R&D",industry:"Consumer Goods",city:"Wageningen",address:"Bronland 14",postal_code:"6708 WH",phone:"+31 317 480 000",email:"data.science@unilever.com",website:"unilever.com",linkedin:"linkedin.com/company/unilever",employees:6000,revenue_range:"€50B+",data_warehouse:"Azure Synapse, Databricks, Snowflake",bi_tools:"Power BI, Tableau, Looker",cloud_provider:"Azure, GCP, AWS",data_lake:"Azure Data Lake, Snowflake",ai_ml:"Databricks ML, Azure ML, PyTorch, Vertex AI",database_vendor:"SAP HANA, SQL Server, PostgreSQL, Oracle"},

  // Telecom
  {name:"KPN",industry:"Telecom",city:"Rotterdam",address:"Wilhelminakade 123",postal_code:"3072 AP",phone:"+31 10 700 7000",email:"analytics@kpn.com",website:"kpn.com",linkedin:"linkedin.com/company/kpn",employees:9500,revenue_range:"€5-10B",data_warehouse:"Oracle Exadata, Snowflake",bi_tools:"Power BI, Tableau, SAS",cloud_provider:"Azure, GCP",data_lake:"Snowflake, Hadoop",ai_ml:"Python, Azure ML, Vertex AI",database_vendor:"Oracle Exadata, SQL Server, PostgreSQL"},
  {name:"VodafoneZiggo",industry:"Telecom",city:"Utrecht",address:"Atoomweg 100",postal_code:"3542 AB",phone:"+31 30 300 3000",email:"data.analytics@vodafoneziggo.com",website:"vodafoneziggo.nl",linkedin:"linkedin.com/company/vodafoneziggo",employees:7500,revenue_range:"€5-10B",data_warehouse:"Teradata, Snowflake",bi_tools:"Power BI, Tableau",cloud_provider:"GCP, AWS",data_lake:"Teradata Vantage, Snowflake, S3",ai_ml:"Vertex AI, Python, TensorFlow",database_vendor:"Oracle, Teradata, PostgreSQL"},
  {name:"Odido",industry:"Telecom",city:"Den Haag",address:"Waldorpstraat 60",postal_code:"2521 CC",phone:"+31 70 700 7000",email:"data@odido.nl",website:"odido.nl",linkedin:"linkedin.com/company/odidonl",employees:2000,revenue_range:"€1-5B",data_warehouse:"Snowflake, Databricks",bi_tools:"Tableau, Looker",cloud_provider:"AWS, GCP",data_lake:"Snowflake, Databricks Delta Lake",ai_ml:"Python, AWS SageMaker, XGBoost",database_vendor:"PostgreSQL, Oracle"},

  // Energy & Utilities
  {name:"Vattenfall NL",industry:"Energy",city:"Amsterdam",address:"Hoekenrode 8",postal_code:"1102 BR",phone:"+31 20 595 5555",email:"data.nl@vattenfall.com",website:"vattenfall.nl",linkedin:"linkedin.com/company/vattenfall",employees:4500,revenue_range:"€5-10B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Databricks",ai_ml:"Azure ML, Python, Databricks ML",database_vendor:"SQL Server, PostgreSQL"},
  {name:"Eneco",industry:"Energy",city:"Rotterdam",address:"Marten Meesweg 5",postal_code:"3068 AV",phone:"+31 88 895 5000",email:"datascience@eneco.com",website:"eneco.com",linkedin:"linkedin.com/company/eneco",employees:3000,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, Databricks, Snowflake",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Databricks Delta Lake",ai_ml:"Azure ML, Python, TensorFlow",database_vendor:"SQL Server, PostgreSQL"},
  {name:"Alliander",industry:"Energy/Grid",city:"Arnhem",address:"Utrechtseweg 68",postal_code:"6812 AH",phone:"+31 26 376 2626",email:"data.office@alliander.com",website:"alliander.com",linkedin:"linkedin.com/company/alliander",employees:7000,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, Databricks, SAP BW",bi_tools:"Power BI, SAP Analytics Cloud",cloud_provider:"Azure",data_lake:"Azure Data Lake Gen2, Databricks",ai_ml:"Azure ML, Python, Databricks ML",database_vendor:"SAP HANA, SQL Server, Oracle"},
  {name:"TenneT",industry:"Energy/Grid",city:"Arnhem",address:"Utrechtseweg 310",postal_code:"6812 AR",phone:"+31 26 373 1111",email:"data@tennet.eu",website:"tennet.eu",linkedin:"linkedin.com/company/tennet-tso",employees:5000,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, SAP BW/4HANA",bi_tools:"Power BI, SAP Analytics Cloud",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Python, scikit-learn",database_vendor:"SAP HANA, SQL Server, Oracle"},

  // Manufacturing & Industrial
  {name:"DSM-Firmenich",industry:"Chemicals",city:"Maastricht",address:"Vondelingenweg 601",postal_code:"6229 PM",phone:"+31 46 476 3050",email:"digital@dsm-firmenich.com",website:"dsm-firmenich.com",linkedin:"linkedin.com/company/dsm-firmenich",employees:30000,revenue_range:"€10B+",data_warehouse:"SAP BW/4HANA, Azure Synapse, Databricks",bi_tools:"Power BI, SAP Analytics Cloud, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Databricks",ai_ml:"Databricks ML, Azure ML, Python, PyTorch",database_vendor:"SAP HANA, SQL Server, Oracle"},
  {name:"AkzoNobel",industry:"Chemicals",city:"Amsterdam",address:"Christian Neefestraat 2",postal_code:"1077 WW",phone:"+31 20 502 7555",email:"advanced.analytics@akzonobel.com",website:"akzonobel.com",linkedin:"linkedin.com/company/akzonobel",employees:35000,revenue_range:"€10B+",data_warehouse:"Azure Synapse, SAP BW",bi_tools:"Power BI, Tableau, SAP Analytics Cloud",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Python, Databricks ML",database_vendor:"SAP HANA, SQL Server, Oracle"},
  {name:"Philips Lighting (Signify)",industry:"Lighting",city:"Eindhoven",address:"High Tech Campus 48",postal_code:"5656 AE",phone:"+31 40 275 0000",email:"data.office@signify.com",website:"signify.com",linkedin:"linkedin.com/company/signify",employees:32000,revenue_range:"€5-10B",data_warehouse:"Azure Synapse, Databricks, Snowflake",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Databricks Delta Lake",ai_ml:"Azure ML, PyTorch, Databricks ML",database_vendor:"SAP HANA, SQL Server"},
  {name:"Thales Nederland",industry:"Defense/Tech",city:"Hengelo",address:"Zuidelijke Havenweg 40",postal_code:"7554 RR",phone:"+31 74 248 8111",email:"data@nl.thalesgroup.com",website:"thalesgroup.com",linkedin:"linkedin.com/company/thales",employees:3200,revenue_range:"€500M-1B",data_warehouse:"Azure Synapse, Snowflake",bi_tools:"Power BI, Tableau",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"PyTorch, Azure ML, TensorFlow",database_vendor:"SQL Server, Oracle, PostgreSQL"},
  {name:"Vanderlande",industry:"Logistics Automation",city:"Veghel",address:"Vanderlandelaan 2",postal_code:"5466 RB",phone:"+31 413 495 000",email:"data@vanderlande.com",website:"vanderlande.com",linkedin:"linkedin.com/company/vanderlande",employees:8000,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, SAP Analytics Cloud",cloud_provider:"Azure, GCP",data_lake:"Azure Data Lake, Databricks",ai_ml:"Azure ML, Python, scikit-learn",database_vendor:"SQL Server, SAP HANA, PostgreSQL"},

  // Education & Research
  {name:"Universiteit van Amsterdam",industry:"Education",city:"Amsterdam",address:"Spui 21",postal_code:"1012 WX",phone:"+31 20 525 9111",email:"datascience@uva.nl",website:"uva.nl",linkedin:"linkedin.com/school/universiteit-van-amsterdam",employees:6500,revenue_range:"€500M-1B",data_warehouse:"BigQuery, Apache Spark",bi_tools:"Tableau, Grafana, R Shiny",cloud_provider:"GCP, Azure",data_lake:"GCS, HDFS",ai_ml:"PyTorch, TensorFlow, JAX, scikit-learn",database_vendor:"PostgreSQL, BigQuery, MySQL"},
  {name:"TU Delft",industry:"Education",city:"Delft",address:"Mekelweg 5",postal_code:"2628 CD",phone:"+31 15 278 9111",email:"data@tudelft.nl",website:"tudelft.nl",linkedin:"linkedin.com/school/tu-delft",employees:5300,revenue_range:"€500M-1B",data_warehouse:"Apache Spark, Azure Synapse",bi_tools:"Grafana, R Shiny, Metabase",cloud_provider:"Azure, GCP",data_lake:"Azure Data Lake, HDFS",ai_ml:"PyTorch, TensorFlow, JAX, DVC, MLflow",database_vendor:"PostgreSQL, MongoDB, HDFS"},
  {name:"Surf",industry:"IT/Research",city:"Utrecht",address:"Moreelsepark 48",postal_code:"3511 EP",phone:"+31 88 787 3000",email:"data@surf.nl",website:"surf.nl",linkedin:"linkedin.com/company/surf",employees:500,revenue_range:"€100-500M",data_warehouse:"Azure Synapse, Hadoop/Spark",bi_tools:"Grafana, Metabase, Power BI",cloud_provider:"Azure, GCP",data_lake:"HDFS, Azure Data Lake",ai_ml:"PyTorch, TensorFlow, JAX, Hugging Face",database_vendor:"PostgreSQL, MySQL, HDFS"},
  {name:"TNO",industry:"Research",city:"Den Haag",address:"Anna van Buerenplein 1",postal_code:"2595 DA",phone:"+31 88 866 0000",email:"data.science@tno.nl",website:"tno.nl",linkedin:"linkedin.com/company/tno",employees:3800,revenue_range:"€500M-1B",data_warehouse:"Databricks, Azure Synapse",bi_tools:"Power BI, Tableau, Grafana",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Databricks Delta Lake",ai_ml:"PyTorch, TensorFlow, Azure ML, MLflow",database_vendor:"PostgreSQL, SQL Server"},

  // Government & Public
  {name:"CBS (Centraal Bureau Statistiek)",industry:"Government",city:"Den Haag",address:"Henri Faasdreef 312",postal_code:"2492 JP",phone:"+31 70 337 3800",email:"bigdata@cbs.nl",website:"cbs.nl",linkedin:"linkedin.com/company/statistics-netherlands",employees:2000,revenue_range:"€100-500M",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, Tableau, R Shiny",cloud_provider:"Azure",data_lake:"Azure Data Lake, Databricks",ai_ml:"Azure ML, Python, R, scikit-learn",database_vendor:"SQL Server, PostgreSQL, Oracle"},
  {name:"DUO",industry:"Government",city:"Groningen",address:"Kempkensberg 12",postal_code:"9722 TB",phone:"+31 50 599 7755",email:"data@duo.nl",website:"duo.nl",linkedin:"linkedin.com/company/dienst-uitvoering-onderwijs",employees:2500,revenue_range:"€50B+ (publiek)",data_warehouse:"Oracle Exadata, Azure Synapse",bi_tools:"Power BI, SAS, Oracle BI",cloud_provider:"Azure, Oracle Cloud",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Python, R",database_vendor:"Oracle Exadata, SQL Server"},
  {name:"Kadaster",industry:"Government",city:"Apeldoorn",address:"Hofstraat 110",postal_code:"7311 KZ",phone:"+31 88 183 2000",email:"data@kadaster.nl",website:"kadaster.nl",linkedin:"linkedin.com/company/kadaster",employees:2300,revenue_range:"€100-500M",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, ArcGIS, Tableau",cloud_provider:"Azure",data_lake:"Azure Data Lake Gen2",ai_ml:"Python, Azure ML, Computer Vision",database_vendor:"SQL Server, Oracle Spatial, PostgreSQL/PostGIS"},
  {name:"Belastingdienst",industry:"Government",city:"Utrecht",address:"Tiberdreef 12",postal_code:"3561 GG",phone:"+31 55 538 5385",email:"data@belastingdienst.nl",website:"belastingdienst.nl",linkedin:"linkedin.com/company/belastingdienst",employees:29000,revenue_range:"€100B+ (publiek)",data_warehouse:"Oracle Exadata, Azure Synapse",bi_tools:"Power BI, SAS, Oracle BI",cloud_provider:"Azure, Oracle Cloud",data_lake:"Azure Data Lake, Oracle",ai_ml:"Azure ML, Python, R, SAS",database_vendor:"Oracle Exadata, SQL Server"},

  // Construction & Real Estate
  {name:"Royal BAM Group",industry:"Construction",city:"Bunnik",address:"Runnenburg 9",postal_code:"3981 AZ",phone:"+31 30 659 8911",email:"digital@bam.com",website:"bam.com",linkedin:"linkedin.com/company/royal-bam-group",employees:16000,revenue_range:"€5-10B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Databricks",ai_ml:"Azure ML, Python, Computer Vision",database_vendor:"SQL Server, Oracle, PostgreSQL"},
  {name:"Heijmans",industry:"Construction",city:"Rosmalen",address:"Graafsebaan 65",postal_code:"5248 JT",phone:"+31 73 543 5111",email:"data@heijmans.nl",website:"heijmans.nl",linkedin:"linkedin.com/company/heijmans",employees:5000,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, SAP BW",bi_tools:"Power BI, SAP Analytics Cloud",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"Azure ML, Python, Computer Vision",database_vendor:"SAP HANA, SQL Server"},

  // Media & Entertainment
  {name:"RTL Nederland",industry:"Media",city:"Hilversum",address:"Sumatralaan 47",postal_code:"1217 GP",phone:"+31 35 671 8911",email:"data@rtl.nl",website:"rtl.nl",linkedin:"linkedin.com/company/rtl-nederland",employees:1200,revenue_range:"€500M-1B",data_warehouse:"BigQuery, Databricks",bi_tools:"Looker, Tableau, Google Analytics",cloud_provider:"GCP, AWS",data_lake:"BigQuery, GCS",ai_ml:"Vertex AI, Python, TensorFlow",database_vendor:"PostgreSQL, BigQuery"},

  // Additional prospects
  {name:"Betaalvereniging Nederland",industry:"Fintech",city:"Amsterdam",address:"Gustav Mahlerplein 33",postal_code:"1082 MS",phone:"+31 20 305 1900",email:"data@betaalvereniging.nl",website:"betaalvereniging.nl",linkedin:"linkedin.com/company/betaalvereniging-nederland",employees:150,revenue_range:"€10-50M",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"Python, Azure ML",database_vendor:"SQL Server, PostgreSQL"},
  {name:"Backbase",industry:"Fintech",city:"Amsterdam",address:"Jacob Bontiusplaats 9",postal_code:"1018 LL",phone:"+31 20 465 8888",email:"info@backbase.com",website:"backbase.com",linkedin:"linkedin.com/company/backbase",employees:2000,revenue_range:"€100-500M",data_warehouse:"Snowflake, BigQuery",bi_tools:"Tableau, Looker",cloud_provider:"AWS, GCP",data_lake:"Snowflake, S3",ai_ml:"Python, scikit-learn, XGBoost",database_vendor:"PostgreSQL, MySQL"},
  {name:"Miro",industry:"SaaS/Collaboration",city:"Amsterdam",address:"Stadhouderskade 1",postal_code:"1054 ES",phone:"+31 20 888 4500",email:"data@miro.com",website:"miro.com",linkedin:"linkedin.com/company/mirohq",employees:1800,revenue_range:"€100-500M",data_warehouse:"Snowflake, dbt",bi_tools:"Looker, Tableau",cloud_provider:"AWS, GCP",data_lake:"Snowflake, S3",ai_ml:"Python, AWS SageMaker, XGBoost",database_vendor:"PostgreSQL, Snowflake"},
  {name:"MessageBird",industry:"SaaS/Communication",city:"Amsterdam",address:"Trompenburgstraat 4",postal_code:"1079 TX",phone:"+31 20 888 5000",email:"data@messagebird.com",website:"messagebird.com",linkedin:"linkedin.com/company/messagebird",employees:800,revenue_range:"€100-500M",data_warehouse:"BigQuery, Snowflake",bi_tools:"Looker, Metabase",cloud_provider:"GCP, AWS",data_lake:"BigQuery, GCS, Snowflake",ai_ml:"Python, Vertex AI, PyTorch",database_vendor:"PostgreSQL, BigQuery"},
  {name:"Lightspeed",industry:"SaaS/POS",city:"Amsterdam",address:"Johan Huizingalaan 763A",postal_code:"1066 VH",phone:"+31 20 757 4200",email:"data@lightspeedhq.com",website:"lightspeedhq.com",linkedin:"linkedin.com/company/lightspeedhq",employees:1500,revenue_range:"€100-500M",data_warehouse:"BigQuery, dbt",bi_tools:"Looker, Data Studio",cloud_provider:"GCP",data_lake:"BigQuery, GCS",ai_ml:"Vertex AI, Python, scikit-learn",database_vendor:"PostgreSQL, MySQL, BigQuery"},
  {name:"WeTransfer",industry:"SaaS/File Sharing",city:"Amsterdam",address:"Willem Fenengastraat 19",postal_code:"1096 BL",phone:"+31 20 215 7520",email:"data@wetransfer.com",website:"wetransfer.com",linkedin:"linkedin.com/company/wetransfer",employees:350,revenue_range:"€50-100M",data_warehouse:"BigQuery, dbt",bi_tools:"Looker, Metabase",cloud_provider:"GCP, AWS",data_lake:"GCS + BigQuery, S3",ai_ml:"Vertex AI, Python",database_vendor:"PostgreSQL, BigQuery"},
  {name:"ChannelEngine",industry:"SaaS/E-commerce",city:"Leiden",address:"Kaagschip 4",postal_code:"2312 VS",phone:"+31 71 700 1100",email:"data@channelengine.com",website:"channelengine.com",linkedin:"linkedin.com/company/channelengine",employees:500,revenue_range:"€10-50M",data_warehouse:"BigQuery, Snowflake",bi_tools:"Looker, Tableau",cloud_provider:"GCP, AWS",data_lake:"BigQuery, GCS, S3",ai_ml:"Python, XGBoost, scikit-learn",database_vendor:"PostgreSQL, BigQuery"},
  {name:"Exact",industry:"SaaS/ERP",city:"Delft",address:"Molengraaffsingel 33",postal_code:"2629 JD",phone:"+31 15 711 5000",email:"data@exact.com",website:"exact.com",linkedin:"linkedin.com/company/exact",employees:1800,revenue_range:"€100-500M",data_warehouse:"Azure Synapse, Snowflake",bi_tools:"Power BI, QlikView",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Snowflake",ai_ml:"Python, Azure ML",database_vendor:"SQL Server, PostgreSQL"},
  {name:"AFAS Software",industry:"SaaS/ERP",city:"Leusden",address:"Philipsstraat 9",postal_code:"3833 LC",phone:"+31 33 434 2434",email:"data@afas.nl",website:"afas.nl",linkedin:"linkedin.com/company/afas",employees:700,revenue_range:"€100-500M",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"Python, Azure ML",database_vendor:"SQL Server, PostgreSQL"},
  {name:"Topicus",industry:"SaaS/Finance",city:"Deventer",address:"Handelskade 13",postal_code:"7417 DE",phone:"+31 570 668 000",email:"data@topicus.nl",website:"topicus.nl",linkedin:"linkedin.com/company/topicus",employees:2500,revenue_range:"€100-500M",data_warehouse:"Azure Synapse, Snowflake",bi_tools:"Power BI",cloud_provider:"Azure",data_lake:"Azure Data Lake",ai_ml:"Python, Azure ML",database_vendor:"SQL Server, PostgreSQL"},
  {name:"Unit4",industry:"SaaS/ERP",city:"Sliedrecht",address:"Stationspark 1000",postal_code:"3364 DA",phone:"+31 184 444 444",email:"info@unit4.com",website:"unit4.com",linkedin:"linkedin.com/company/unit4",employees:3500,revenue_range:"€500M-1B",data_warehouse:"Azure Synapse, Snowflake, SAP BW",bi_tools:"Power BI, Tableau",cloud_provider:"Azure, AWS",data_lake:"Azure Data Lake, Snowflake",ai_ml:"Python, Azure ML, R",database_vendor:"SQL Server, SAP HANA, PostgreSQL"},

  // Additional Healthcare
  {name:"Erasmus MC",industry:"Healthcare",city:"Rotterdam",address:"Doctor Molewaterplein 40",postal_code:"3015 GD",phone:"+31 10 704 0704",email:"datascience@erasmusmc.nl",website:"erasmusmc.nl",linkedin:"linkedin.com/company/erasmus-mc",employees:14000,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, R Shiny, Tableau",cloud_provider:"Azure",data_lake:"Azure Data Lake, Databricks",ai_ml:"PyTorch, TensorFlow, Azure ML, scikit-learn",database_vendor:"SQL Server, PostgreSQL, Oracle"},
  {name:"Radboud UMC",industry:"Healthcare",city:"Nijmegen",address:"Geert Grooteplein Zuid 10",postal_code:"6525 GA",phone:"+31 24 361 1111",email:"data.science@radboudumc.nl",website:"radboudumc.nl",linkedin:"linkedin.com/company/radboudumc",employees:11000,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, R Shiny, Grafana",cloud_provider:"Azure",data_lake:"Azure Data Lake, Databricks Delta Lake",ai_ml:"PyTorch, MONAI, TensorFlow, Azure ML",database_vendor:"SQL Server, PostgreSQL, Oracle"},
  {name:"Amsterdam UMC",industry:"Healthcare",city:"Amsterdam",address:"Meibergdreef 9",postal_code:"1105 AZ",phone:"+31 20 566 9111",email:"datascience@amsterdamumc.nl",website:"amsterdamumc.nl",linkedin:"linkedin.com/company/amsterdam-umc",employees:17000,revenue_range:"€1-5B",data_warehouse:"Azure Synapse, Databricks",bi_tools:"Power BI, Tableau, Grafana",cloud_provider:"Azure, GCP",data_lake:"Azure Data Lake, Databricks Delta Lake",ai_ml:"PyTorch, TensorFlow, Azure ML, JAX",database_vendor:"SQL Server, PostgreSQL, Oracle"},
];

// Seed companies
const existing = db.prepare("SELECT COUNT(*) as cnt FROM tech_companies").get();
if (existing.cnt === 0) {
  for (const c of companies) seedCompany(c);
}
console.log(companies.length + " companies seeded");

// Print lead scores summary
const top = db.prepare("SELECT name,industry,lead_score,data_warehouse FROM tech_companies ORDER BY lead_score DESC LIMIT 10").all();
console.log("\nTop 10 prospects:");
top.forEach(c => console.log(c.name + " | " + c.industry + " | Score: " + c.lead_score + " | " + (c.data_warehouse||"-").substring(0,50)));

const totalDCs = db.prepare("SELECT COUNT(*) as cnt FROM datacenters").get().cnt;
const totalCompanies = db.prepare("SELECT COUNT(*) as cnt FROM tech_companies").get().cnt;
console.log("\nTotal: " + totalDCs + " datacenters, " + totalCompanies + " companies");
