mysql> call StateProfile('44'); +---------+--------+--------+-----------+--------------------+---------------------------------+---------+--------+-------+-------------+------------+-------------+-----------+------------+-------+ | Country | FIPSst | FIPSco | FIPScosub | Domain | Name | POP | HUO | MTT | Land_sqmi | Water_sqmi | Total_sqmi | Lat | Lon | stTZO | +---------+--------+--------+-----------+--------------------+---------------------------------+---------+--------+-------+-------------+------------+-------------+-----------+------------+-------+ | 539 | * | * | * | @539/ | United States | NULL | NULL | 0.594 | 2954841.845 | 165584.602 | 3120426.447 | 39.828175 | -98.579500 | * | | 539 | 44 | * | * | @539/44/ | Rhode Island | 1052567 | 413600 | 0.540 | 1033.815 | 511.072 | 1544.887 | 41.635825 | -71.450838 | * | | 539 | 44 | 001 | * | @539/44/001/ | Bristol County | 49875 | 19150 | 0.596 | 24.164 | 20.586 | 44.750 | 41.705271 | -71.285053 | -5.00 | | 539 | 44 | 001 | 05140 | @539/44/001/#05140 | Barrington town | NULL | NULL | NULL | 8.215 | 7.217 | 15.432 | 41.733037 | -71.319676 | @ | | 539 | 44 | 001 | 09280 | @539/44/001/#09280 | Bristol town | NULL | NULL | NULL | 9.825 | 10.781 | 20.606 | 41.675730 | -71.273331 | @ | | 539 | 44 | 001 | 73760 | @539/44/001/#73760 | Warren town | NULL | NULL | NULL | 6.124 | 2.588 | 8.712 | 41.724959 | -71.258373 | @ | | 539 | 44 | 003 | * | @539/44/003/ | Kent County | 166158 | 68645 | 0.561 | 168.528 | 19.595 | 188.123 | 41.677750 | -71.576314 | -5.00 | | 539 | 44 | 003 | 18640 | @539/44/003/#18640 | Coventry town | NULL | NULL | NULL | 59.045 | 3.355 | 62.400 | 41.698209 | -71.661946 | @ | | 539 | 44 | 003 | 22240 | @539/44/003/#22240 | East Greenwich town | NULL | NULL | NULL | 16.393 | 0.250 | 16.643 | 41.635469 | -71.505053 | @ | | 539 | 44 | 003 | 74300 | @539/44/003/#74300 | Warwick city | NULL | NULL | NULL | 35.045 | 14.756 | 49.801 | 41.700757 | -71.420334 | @ | | 539 | 44 | 003 | 77720 | @539/44/003/#77720 | West Greenwich town | NULL | NULL | NULL | 50.259 | 1.007 | 51.266 | 41.637104 | -71.678369 | @ | | 539 | 44 | 003 | 78440 | @539/44/003/#78440 | West Warwick town | NULL | NULL | NULL | 7.786 | 0.228 | 8.014 | 41.679006 | -71.518688 | @ | | 539 | 44 | 005 | * | @539/44/005/ | Newport County | 82888 | 34911 | 0.483 | 102.386 | 211.208 | 313.594 | 41.502732 | -71.284063 | -5.00 | | 539 | 44 | 005 | 00000 | @539/44/005/#00000 | County subdivisions not defined | NULL | NULL | NULL | 0.000 | 127.622 | 127.622 | 41.410279 | -71.302719 | @ | | 539 | 44 | 005 | 36820 | @539/44/005/#36820 | Jamestown town | NULL | NULL | NULL | 9.448 | 25.874 | 35.322 | 41.519730 | -71.371076 | @ | | 539 | 44 | 005 | 42400 | @539/44/005/#42400 | Little Compton town | NULL | NULL | NULL | 20.522 | 8.278 | 28.800 | 41.503720 | -71.166383 | @ | | 539 | 44 | 005 | 45460 | @539/44/005/#45460 | Middletown town | NULL | NULL | NULL | 12.716 | 2.081 | 14.797 | 41.518611 | -71.281685 | @ | | 539 | 44 | 005 | 49960 | @539/44/005/#49960 | Newport city | NULL | NULL | NULL | 7.674 | 3.718 | 11.392 | 41.476335 | -71.321635 | @ | | 539 | 44 | 005 | 57880 | @539/44/005/#57880 | Portsmouth town | NULL | NULL | NULL | 22.981 | 36.353 | 59.334 | 41.607613 | -71.305405 | @ | | 539 | 44 | 005 | 70880 | @539/44/005/#70880 | Tiverton town | NULL | NULL | NULL | 29.045 | 7.283 | 36.328 | 41.610138 | -71.180471 | @ | | 539 | 44 | 007 | * | @539/44/007/ | Providence County | 626667 | 241717 | 0.530 | 409.502 | 26.154 | 435.656 | 41.870488 | -71.578242 | -5.00 | | 539 | 44 | 007 | 11800 | @539/44/007/#11800 | Burrillville town | NULL | NULL | NULL | 55.035 | 2.091 | 57.126 | 41.970291 | -71.698660 | @ | | 539 | 44 | 007 | 14140 | @539/44/007/#14140 | Central Falls city | NULL | NULL | NULL | 1.198 | 0.077 | 1.275 | 41.890064 | -71.393481 | @ | | 539 | 44 | 007 | 19180 | @539/44/007/#19180 | Cranston city | NULL | NULL | NULL | 28.339 | 1.601 | 29.940 | 41.769734 | -71.485049 | @ | | 539 | 44 | 007 | 20080 | @539/44/007/#20080 | Cumberland town | NULL | NULL | NULL | 26.447 | 1.809 | 28.256 | 41.967599 | -71.420477 | @ | | 539 | 44 | 007 | 22960 | @539/44/007/#22960 | East Providence city | NULL | NULL | NULL | 13.241 | 3.313 | 16.554 | 41.799956 | -71.356584 | @ | | 539 | 44 | 007 | 27460 | @539/44/007/#27460 | Foster town | NULL | NULL | NULL | 50.798 | 1.095 | 51.893 | 41.788784 | -71.734934 | @ | | 539 | 44 | 007 | 30340 | @539/44/007/#30340 | Glocester town | NULL | NULL | NULL | 54.180 | 2.662 | 56.842 | 41.891181 | -71.690111 | @ | | 539 | 44 | 007 | 37720 | @539/44/007/#37720 | Johnston town | NULL | NULL | NULL | 23.430 | 0.884 | 24.314 | 41.827440 | -71.519879 | @ | | 539 | 44 | 007 | 41500 | @539/44/007/#41500 | Lincoln town | NULL | NULL | NULL | 18.120 | 0.831 | 18.951 | 41.918213 | -71.451576 | @ | | 539 | 44 | 007 | 51760 | @539/44/007/#51760 | North Providence town | NULL | NULL | NULL | 5.619 | 0.135 | 5.754 | 41.861587 | -71.456879 | @ | | 539 | 44 | 007 | 52480 | @539/44/007/#52480 | North Smithfield town | NULL | NULL | NULL | 23.804 | 0.938 | 24.742 | 41.975186 | -71.544069 | @ | | 539 | 44 | 007 | 54640 | @539/44/007/#54640 | Pawtucket city | NULL | NULL | NULL | 8.682 | 0.290 | 8.972 | 41.874368 | -71.375678 | @ | | 539 | 44 | 007 | 59000 | @539/44/007/#59000 | Providence city | NULL | NULL | NULL | 18.400 | 2.168 | 20.568 | 41.823056 | -71.418780 | @ | | 539 | 44 | 007 | 64220 | @539/44/007/#64220 | Scituate town | NULL | NULL | NULL | 48.164 | 6.609 | 54.773 | 41.803463 | -71.628538 | @ | | 539 | 44 | 007 | 66200 | @539/44/007/#66200 | Smithfield town | NULL | NULL | NULL | 26.306 | 1.456 | 27.762 | 41.901241 | -71.531060 | @ | | 539 | 44 | 007 | 80780 | @539/44/007/#80780 | Woonsocket city | NULL | NULL | NULL | 7.739 | 0.194 | 7.933 | 42.001706 | -71.499949 | @ | | 539 | 44 | 009 | * | @539/44/009/ | Washington County | 126979 | 49177 | 0.570 | 329.235 | 233.529 | 562.764 | 41.401162 | -71.617612 | -5.00 | | 539 | 44 | 009 | 14500 | @539/44/009/#14500 | Charlestown town | NULL | NULL | NULL | 36.446 | 22.889 | 59.335 | 41.371371 | -71.680336 | @ | | 539 | 44 | 009 | 25300 | @539/44/009/#25300 | Exeter town | NULL | NULL | NULL | 57.466 | 0.924 | 58.390 | 41.570210 | -71.626993 | @ | | 539 | 44 | 009 | 35380 | @539/44/009/#35380 | Hopkinton town | NULL | NULL | NULL | 42.950 | 1.303 | 44.253 | 41.479072 | -71.757934 | @ | | 539 | 44 | 009 | 48340 | @539/44/009/#48340 | Narragansett town | NULL | NULL | NULL | 13.893 | 23.882 | 37.775 | 41.400430 | -71.486804 | @ | | 539 | 44 | 009 | 50500 | @539/44/009/#50500 | New Shoreham town | NULL | NULL | NULL | 9.082 | 100.426 | 109.508 | 41.194014 | -71.572562 | @ | | 539 | 44 | 009 | 51580 | @539/44/009/#51580 | North Kingstown town | NULL | NULL | NULL | 43.139 | 15.309 | 58.448 | 41.574102 | -71.453868 | @ | | 539 | 44 | 009 | 61160 | @539/44/009/#61160 | Richmond town | NULL | NULL | NULL | 40.293 | 0.432 | 40.725 | 41.494707 | -71.669310 | @ | | 539 | 44 | 009 | 67460 | @539/44/009/#67460 | South Kingstown town | NULL | NULL | NULL | 56.446 | 23.312 | 79.758 | 41.410844 | -71.547470 | @ | | 539 | 44 | 009 | 77000 | @539/44/009/#77000 | Westerly town | NULL | NULL | NULL | 29.520 | 45.051 | 74.571 | 41.328337 | -71.784681 | @ | +---------+--------+--------+-----------+--------------------+---------------------------------+---------+--------+-------+-------------+------------+-------------+-----------+------------+-------+ 47 rows in set (0.29 sec) Query OK, 0 rows affected (0.29 sec) mysql> exit