bayareametro-gov/county-to-cbsa-mapping-for-large-metros-r2dj-sisx
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 2 years ago
Indexed 1 hour ago

County to CBSA Mapping for Large Metros

Data contains counties in the following list of CBSAS (per OMB Mar 2020 definition):

Bay Area CBSAs:

San Francisco-Oakland-Berkeley, CA

San Jose-Sunnyvale-Santa Clara, CA

Napa, CA

Santa Rosa-Petaluma, CA

Other CBSAs:

Los Angeles-Long Beach-Anaheim, CA

Washington-Arlington-Alexandria, DC-VA-MD-WV

Denver-Aurora-Lakewood, CO

Detroit-Warren-Dearborn, MI

Philadelphia-Camden-Wilmington, PA-NJ-DE-MD

Boston-Cambridge-Newton, MA-NH

New York-Newark-Jersey City, NY-NJ-PA

Phoenix-Mesa-Chandler, AZ

Houston-The Woodlands-Sugar Land, TX

Seattle-Tacoma-Bellevue, WA

Atlanta-Sandy Springs-Alpharetta, GA

Chicago-Naperville-Elgin, IL-IN-WI

Austin-Round Rock-Georgetown, TX

Dallas-Fort Worth-Arlington, TX

Miami-Fort Lauderdale-Pompano Beach, FL

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/county-to-cbsa-mapping-for-large-metros-r2dj-sisx\".\"county_to_cbsa_mapping_for_large_metros\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • county_to_cbsa_mapping_for_large_metros