Name: Global IP Dataset By Location 2023
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Global IP Dataset By Location 2023

Dataset of IP ranges in csv format with Country, ASN, City, Country Code. IP range in ipv4 format.

If you need postcode or timezone, geolite2-city is the one.
If you need city data with CC-BY License, dbip-city is the one.
If you need country database with Public Domain, we recommend geo-whois-asn-country database.
If you need asn database, we recommend asn database.

Tables

Asn Ipv4

@kaggle.joebeachcapital_global_ip_dataset_by_location_2023.asn_ipv4

8.24 MB
363,048 rows
4 columns

CREATE TABLE asn_ipv4 (
  "n_1_0_0_0" VARCHAR  -- 1.0.0.0,
  "n_1_0_0_255" VARCHAR  -- 1.0.0.255,
  "n_13335" BIGINT  -- 13335,
  "cloudflare_inc" VARCHAR  -- Cloudflare, Inc.
);

Dbip City Ipv4

@kaggle.joebeachcapital_global_ip_dataset_by_location_2023.dbip_city_ipv4

62.41 MB
3,182,049 rows
10 columns

CREATE TABLE dbip_city_ipv4 (
  "n_1_0_0_0" VARCHAR  -- 1.0.0.0,
  "n_1_0_0_255" VARCHAR  -- 1.0.0.255,
  "au" VARCHAR,
  "queensland" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "south_brisbane" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "n__27_4767" DOUBLE  -- -27.4767,
  "n_153_017" DOUBLE  -- 153.017,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Geolite2 City Ipv4

@kaggle.joebeachcapital_global_ip_dataset_by_location_2023.geolite2_city_ipv4

64.02 MB
2,823,585 rows
10 columns

CREATE TABLE geolite2_city_ipv4 (
  "n_1_0_0_0" VARCHAR  -- 1.0.0.0,
  "n_1_0_0_127" VARCHAR  -- 1.0.0.127,
  "au" VARCHAR,
  "victoria" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "moondarra" VARCHAR,
  "n_3825" VARCHAR  -- 3825,
  "n__38_0248" DOUBLE  -- -38.0248,
  "n_146_3710" DOUBLE  -- 146.3710,
  "australia_melbourne" VARCHAR
);

Geo Whois Asn Country Ipv4

@kaggle.joebeachcapital_global_ip_dataset_by_location_2023.geo_whois_asn_country_ipv4

2.91 MB
241,715 rows
3 columns

CREATE TABLE geo_whois_asn_country_ipv4 (
  "n_1_0_0_0" VARCHAR  -- 1.0.0.0,
  "n_1_0_0_255" VARCHAR  -- 1.0.0.255,
  "au" VARCHAR
);