This data as json
| rowid | cbsacode | metrodivisioncode | csacode | cbsatitle | metropolitanmicropolitanstatis | metropolitandivisiontitle | csatitle | countycountyequivalent | statename | fipsstatecode | fipscountycode | centraloutlyingcounty |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 335 | 28180 | Kapaa, HI | Micropolitan Statistical Area | Kauai County | Hawaii | 15 | 7 | Central |