LRN Database Download

Full LRN Database. Delivered Daily.

Download the complete NPAC-sourced LRN database as MySQL dump, CSV, or TSV. 400M+ NANP records with daily deltas. Automated delivery to your S3 or SFTP.

Start Download AccessNeed Real-Time? See Replication
400M+
NANP Records
Daily
Snapshot Refresh
Flat
Rate Pricing
aws s3 cp s3://sipsmart-lrn/latest/ .
Downloading: lrn_full_20260227.sql.gz
✓ lrn_full_20260227.sql.gz (3.9 GB)
✓ lrn_delta_20260227_1200.csv.gz (48 MB)
✓ Download complete. 400,218,447 records.

Infrastructure-Grade

Everything You Need in One Download

Full NPAC coverage, multiple formats, automated delivery — no manual steps.

📦

MySQL Snapshot Export

Full database exported as MySQL dump, compressed with gzip. Importable to any MySQL 5.7+ or MariaDB 10.3+ instance in minutes.

📄

Flat File Formats

Available as CSV, TSV, or pipe-delimited flat file for import into non-MySQL databases or custom processing pipelines.

🔄

Daily Delta Files

After initial full download, receive daily delta files containing only the changes — porting events, new activations, deactivations.

🤖

Automated Delivery

Database snapshots delivered automatically to your S3 bucket, SFTP server, or via direct download link. No manual steps required.

📊

400M+ NANP Records

Full NANP coverage including all active CONUS, Alaska, Hawaii, Puerto Rico, and US territories in service-area formats.

💰

Flat-Rate Pricing

No per-record fees. Pay a flat monthly subscription for unlimited database downloads and daily deltas.

Start Free — 1,000 Lookups Included

Available Formats

Download vs Replication — Which Is Right?

📦 Database Download

  • ✓ Daily snapshot + delta files
  • ✓ MySQL, CSV, TSV, pipe-delimited
  • ✓ S3, SFTP, or HTTP delivery
  • ✓ Simple flat-rate subscription
  • ✗ Up to 24h data lag
  • ✗ Manual import required

Best for: analytics, compliance reporting, list scrubbing workflows

🔄 Live Replication

  • ✓ Changes replicated within seconds
  • ✓ Native MySQL binlog protocol
  • ✓ Automated continuous sync
  • ✓ No manual import steps
  • ✓ Zero per-query fees

Best for: real-time call routing, high-volume dialers

Learn About Replication

Simple, Predictable Pricing

No Surprises. Ever.

We charge less than legacy providers and publish our prices openly. No setup fees, no hidden costs, no annual lock-in required.

API Access
$0.0001
per LRN dip
  • ✓ Real-time lookup
  • ✓ Sub-10ms Ohio cluster
  • ✓ 99.99% SLA
  • ✓ 1,000 free requests
Most Popular
Database Replication
Custom
flat-rate pricing, no per-query fees
  • ✓ Full NPAC-sourced database
  • ✓ MySQL binlog replication
  • ✓ Automated provisioning
  • ✓ Dedicated support

🛡 Pricing Guarantee

We will match or beat any competitor's published price for equivalent LRN lookup volume. Contact us with a quote.

Get Started Free

FAQ

LRN Database Download FAQ

Have another question? Email us at support@sipsmart.io

  • The full NPAC LRN database is approximately 15–20 GB as a MySQL InnoDB dump (compressed ~4 GB). As a flat CSV file it's approximately 8 GB uncompressed (2 GB gzip). Daily delta files average 50–200 MB depending on porting activity.
  • Full snapshots are generated daily. Delta files are generated every 4 hours capturing all NPAC porting events processed since the last delta. For real-time porting updates, consider our replication service instead.
  • AWS S3 bucket delivery (most popular), SFTP push, direct HTTPS download link, or our API endpoint for programmatic retrieval. S3 and SFTP support scheduled automatic delivery.

Download the Full LRN Database

400M+ NANP records. Daily snapshots. Automated S3/SFTP delivery. Flat-rate pricing.

Start Download AccessView Pricing

1,000 free lookups included • No credit card required • Instant provisioning