Table: geography_crosswalk , mssa_name like J*

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  *

census_tract aland county mssa_id mssa_name mssa_type rn_area_id rn_area_name
06037910001 73640270 Los Angeles 77.3 Juniper Hills/Littlerock/Longview/Pearblossom/Valyermo Rural 55 Palmdale/Lancaster Area
06037910002 72486339 Los Angeles 77.3 Juniper Hills/Littlerock/Longview/Pearblossom/Valyermo Rural 55 Palmdale/Lancaster Area
06037911001 373223746 Los Angeles 77.3 Juniper Hills/Littlerock/Longview/Pearblossom/Valyermo Rural 55 Palmdale/Lancaster Area
06071010410 57127610 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 61 Twentynine Palms/Yucca Valley Area
06071010411 54020380 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 61 Twentynine Palms/Yucca Valley Area
06071010412 27559191 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 61 Twentynine Palms/Yucca Valley Area
06071010413 57784377 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 61 Twentynine Palms/Yucca Valley Area
06071010417 52197146 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 70 Indio/Cathedral City Area
06071010419 65424543 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 61 Twentynine Palms/Yucca Valley Area
06071010420 97382827 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 61 Twentynine Palms/Yucca Valley Area
06071010423 290392033 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 61 Twentynine Palms/Yucca Valley Area
06071010424 1678537691 San Bernardino 144.2 Joshua Tree/Landers/Morongo Valley/Rimrock/Yucca Valley Rural 61 Twentynine Palms/Yucca Valley Area
06105000200 1940993107 Trinity 223 Junction City/Salyer Frontier 6 Redding/Red Bluff Area