Standard Metropolitan Areas Dataset

#Standard Metropolitan Areas Dataset

@kaggle.suyashpratapsingh_standard_metropolitan_areas_dataset

Table List

1 table(12.05 KB)

Standard Metropolitan Areas Dataset

@kaggle.suyashpratapsingh_standard_metropolitan_areas_dataset.standard_metropolitan_areas_dataset

12.05 KB
99 rows
10 columns

land_area Land Area	percent_city Percent City	percent_senior Percent Senior	physicians Physicians	hospital_beds Hospital Beds	graduates Graduates	work_force Work Force	income Income	region Region	crime_rate Crime Rate
1384	78.1	12.3	25627	69678	50.1	4083.9	72100	1	75.55
3719	43.9	9.4	13326	43292	53.9	3305.9	54542	2	56.03
3553	37.4	10.7	9724	33731	50.6	2066.3	33216	1	41.32
3916	29.9	8.8	6402	24167	52.2	1966.7	32906	2	67.38
2480	31.5	10.5	8502	16751	66.1	1514.5	26573	4	80.19
2815	23.1	6.7	7340	16941	68.3	1541.9	25663	3	58.48
8360	46.3	8.2	4047	14347	53.6	1321.2	18350	3	72.25
6794	60.1	6.3	4562	14333	51.7	1272.7	18221	3	64.88
3049	19.5	12.1	4005	21149	53.4	967.5	15826	1	30.51
4647	31.5	9.2	3916	12815	65.1	1032.2	14542	2	55.3


CREATE TABLE standard_metropolitan_areas_dataset (
  "land_area" BIGINT,
  "percent_city" DOUBLE,
  "percent_senior" DOUBLE,
  "physicians" BIGINT,
  "hospital_beds" BIGINT,
  "graduates" DOUBLE,
  "work_force" DOUBLE,
  "income" BIGINT,
  "region" BIGINT,
  "crime_rate" DOUBLE
);