Schools in US

Addresses, Phone Numbers and Grades of Schools in United States

Data Structure

city [14,180]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ state (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(100)
+ title (100%)
varchar(255)
+ slug (100%)
school [121,845]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ state_slug (100%)
bigint(20) unsigned
+ state_id (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(200)
+ title (100%)
varchar(200)
+ address (98.9%)
varchar(30)
+ phone (99.4%)
varchar(25)
+ grades (100%)
varchar(255)
+ nature (100%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ education (98%)
varchar(255)
+ address (98%)
varchar(255)
+ postcode_state (98%)
varchar(255)
+ phone (98%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

This schools directory database contains 121,845 schools located in 14,180 cities from 51 states in the United States. In table school, each record is comprised of school address, phone number, school grades, state, city and the nature of school (charter, private and public).

Data Profile

Size 62.62M
Tables 3
Last Commit 2016-12-07 00:08:06

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:08:06 62.62M 3 25 136076
2016-09-07 01:09:08 62.62M 3 25 136076

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 14,180 .001 14.18
school 121,845 .001 121.845
state 51 .001 0.051
Total Credits 136.076 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.