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

7.86 MB
363048 rows
4 columns


CREATE TABLE asn_ipv4 (
  "n_1_0_0_0" VARCHAR,
  "n_1_0_0_255" VARCHAR,
  "n_13335" BIGINT,
  "cloudflare_inc" VARCHAR
);

Dbip City Ipv4

@kaggle.joebeachcapital_global_ip_dataset_by_location_2023.dbip_city_ipv4

59.52 MB
3182049 rows
10 columns


CREATE TABLE dbip_city_ipv4 (
  "n_1_0_0_0" VARCHAR,
  "n_1_0_0_255" VARCHAR,
  "au" VARCHAR,
  "queensland" VARCHAR,
  "unnamed_4" VARCHAR,
  "south_brisbane" VARCHAR,
  "unnamed_6" VARCHAR,
  "n__27_4767" DOUBLE,
  "n_153_017" DOUBLE,
  "unnamed_9" VARCHAR
);

Geolite2 City Ipv4

@kaggle.joebeachcapital_global_ip_dataset_by_location_2023.geolite2_city_ipv4

61.05 MB
2823585 rows
10 columns


CREATE TABLE geolite2_city_ipv4 (
  "n_1_0_0_0" VARCHAR,
  "n_1_0_0_127" VARCHAR,
  "au" VARCHAR,
  "victoria" VARCHAR,
  "unnamed_4" VARCHAR,
  "moondarra" VARCHAR,
  "n_3825" VARCHAR,
  "n__38_0248" DOUBLE,
  "n_146_3710" DOUBLE,
  "australia_melbourne" VARCHAR
);

Geo Whois Asn Country Ipv4

@kaggle.joebeachcapital_global_ip_dataset_by_location_2023.geo_whois_asn_country_ipv4

2.78 MB
241715 rows
3 columns


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