Get Selected JSON data
I have a JSON data like this:
[{
"RM_Name": "Name1",
"Division": "Division1",
"RM_Phone": "Phone1",
"RC_Name": "Name2",
"RC_Phone": "Phone2",
"States_Covered": "State1,State2, State3, State4 (all firms)",
"Latitude": 46.6797995,
"Longitude": -110.044783,
"Coordinates": "46.6797995,-110.044783"
}, {
"RM_Name": "Name3",
"Division": "Division1",
"RM_Phone": "Phone3",
"RC_Name": "Name4",
"RC_Phone": "Phone4",
"States_Covered": "State5- Upstate ex Region1 (BD, FP)",
"Latitude": 40.7056308,
"Longitude": -73.9780035,
"Coordinates": "40.7056308,-73.9780035"
}, {
"RM_Name": "Name5",
"Division": "Division1",
"RM_Phone": "Phone5",
"RC_Name": "Name6",
"RC_Phone": "Phone6",
"States_Covered": "State6, State5 - Upstate, State7 - ex metro Region2 (FI), State7 - Central, West (all firms)",
"Latitude": 41.5178234,
"Longitude": -72.757507,
"Coordinates": "41.5178234,-72.757507"
}, {
"RM_Name": "Name7",
"Division": "Division1",
"RM_Phone": "Phone7",
"RC_Name": "Name8",
"RC_Phone": "Phone8",
"States_Covered": "State8 - East, State9 - South (FP)",
"Latitude": 40.9945928,
"Longitude": -77.6046984,
"Coordinates": "40.9945928,-77.6046984"
}, {
"RM_Name": "Name9",
"Division": "Division1",
"RM_Phone": "Phone9",
"RC_Name": "Name10",
"RC_Phone": "Phone10",
"States_Covered": "State9 (FI), State9 - Region3 (all firms), State5 - Region4 (FI,RIA)/Region5 (FI,BD)/Region1 (all firms)",
"Latitude": 40.1430241,
"Longitude": -74.7311156,
"Coordinates": "40.1430241,-74.7311156"
}, {
"RM_Name": "Name11",
"Division": "Division1",
"RM_Phone": "Phone11",
"RC_Name": "Name12",
"RC_Phone": "Phone12",
"States_Covered": "State7 - East (all firms)",
"Latitude": 42.0629399,
"Longitude": -71.718067,
"Coordinates": "42.0629399,-71.718067"
}, {
"RM_Name": "Name13",
"Division": "Division1",
"RM_Phone": "Phone13",
"RC_Name": "Name14",
"RC_Phone": "Phone14",
"States_Covered": "State9, State8 East",
"Latitude": 40.1430241,
"Longitude": -74.7311156,
"Coordinates": "40.1430241,-74.7311156"
}, {
"RM_Name": "Name15",
"Division": "Division1",
"RM_Phone": "Phone15",
"RC_Name": "Name16",
"RC_Phone": "Phone16",
"States_Covered": "State10,State8 - West (all firms), State11 - Region6 (BD, FI)",
"Latitude": 38.0033854,
"Longitude": -79.7715309,
"Coordinates": "38.0033854,-79.7715309"
}, {
"RM_Name": "Name17",
"Division": "Division1",
"RM_Phone": "Phone17",
"RC_Name": "Name12",
"RC_Phone": "Phone18",
"States_Covered": "State12 - (all firms)",
"Latitude": 44.9700413,
"Longitude": -86.4158049,
"Coordinates": "44.9700413,-86.4158049"
}, {
"RM_Name": "Name19",
"Division": "Division1",
"RM_Phone": "Phone19",
"RC_Name": "Name20",
"RC_Phone": "Phone20",
"States_Covered": "Region4",
"Latitude": 40.7056308,
"Longitude": -73.9780035,
"Coordinates": "40.7056308,-73.9780035"
}, {
"RM_Name": "Name21",
"Division": "Division1",
"RM_Phone": "Phone21",
"RC_Name": "Name20",
"RC_Phone": "Phone22",
"States_Covered": "Region4",
"Latitude": 40.7056308,
"Longitude": -73.9780035,
"Coordinates": "40.7056308,-73.9780035"
}, {
"RM_Name": "Name23",
"Division": "Division1",
"RM_Phone": "Phone23",
"RC_Name": "Name4",
"RC_Phone": "Phone24",
"States_Covered": "State9 - North ex Region3, State5 - Region4 (FP)",
"Latitude": 40.1430241,
"Longitude": -74.7311156,
"Coordinates": "40.1430241,-74.7311156"
}, {
"RM_Name": "Name25",
"Division": "Division1",
"RM_Phone": "Phone25",
"RC_Name": "Name26",
"RC_Phone": "Phone26",
"States_Covered": "State5 - LI and Outer Boroughs (FI), LI Planners",
"Latitude": 40.7056308,
"Longitude": -73.9780035,
"Coordinates": "40.7056308,-73.9780035"
}, {
"RM_Name": "Name27",
"Division": "Division1",
"RM_Phone": "Phone27",
"RC_Name": "Name26",
"RC_Phone": "Phone28",
"States_Covered": "State11 - Region7 and South (all firms), State13 - Region8 (all firms)",
"Latitude": 40.1903624,
"Longitude": -82.6692524,
"Coordinates": "40.1903624,-82.6692524"
}, {
"RM_Name": "Name29",
"Division": "Division1",
"RM_Phone": "Phone29",
"RC_Name": "Name2",
"RC_Phone": "Phone30",
"States_Covered": "State11 - North of Region7 ex Region6 (all firms), Region6 (FP)",
"Latitude": 40.1903624,
"Longitude": -82.6692524,
"Coordinates": "40.1903624,-82.6692524"
}, {
"RM_Name": "Name31",
"Division": "Division2",
"RM_Phone": "Phone31",
"RC_Name": "Name32",
"RC_Phone": "Phone32",
"States_Covered": "State14 - North (FP)",
"Latitude": 27.975728,
"Longitude": -83.8330166,
"Coordinates": "27.975728,-83.8330166"
}, {
"RM_Name": "Name33",
"Division": "Division2",
"RM_Phone": "Phone33",
"RC_Name": "Name34",
"RC_Phone": "Phone34",
"States_Covered": "State15, State16, State13 - ex Region8 (all firms), State17 - Region9 (by firm)",
"Latitude": 35.8304544,
"Longitude": -85.9785989,
"Coordinates": "35.8304544,-85.9785989"
}, {
"RM_Name": "Name35",
"Division": "Division2",
"RM_Phone": "Phone35",
"RC_Name": "Name36",
"RC_Phone": "Phone36",
"States_Covered": "State18 - ex coast, State19, State20 - Region10 to Region11 (all firms)",
"Latitude": 35.2145629,
"Longitude": -79.8912675,
"Coordinates": "35.2145629,-79.8912675"
}, {
"RM_Name": "Name37",
"Division": "Division2",
"RM_Phone": "Phone37",
"RC_Name": "Name34",
"RC_Phone": "Phone38",
"States_Covered": "State14 - South, Territory1, Territory2 (all firms)",
"Latitude": 27.975728,
"Longitude": -83.8330166,
"Coordinates": "27.975728,-83.8330166"
}, {
"RM_Name": "Name39",
"Division": "Division2",
"RM_Phone": "Phone39",
"RC_Name": "Name40",
"RC_Phone": "Phone40",
"States_Covered": "State21 (all firms), State20 (BD, RIA)",
"Latitude": 32.6010277,
"Longitude": -86.6807364,
"Coordinates": "32.6010277,-86.6807364"
}, {
"RM_Name": "Name41",
"Division": "Division2",
"RM_Phone": "Phone41",
"RC_Name": "Name42",
"RC_Phone": "Phone42",
"States_Covered": "State22 - Region12 (BD, FP) Region13 Region14 and Region15 (FP, FI)",
"Latitude": 31.1693363,
"Longitude": -100.0768425,
"Coordinates": "31.1693363,-100.0768425"
}, {
"RM_Name": "Name43",
"Division": "Division2",
"RM_Phone": "Phone43",
"RC_Name": "Name44",
"RC_Phone": "Phone44",
"States_Covered": "State22 - Southeast (BD), State23, State24 - South (all firms)",
"Latitude": 31.1693363,
"Longitude": -100.0768425,
"Coordinates": "31.1693363,-100.0768425"
}, {
"RM_Name": "Name45",
"Division": "Division2",
"RM_Phone": "Phone45",
"RC_Name": "Name36",
"RC_Phone": "Phone46",
"States_Covered": "State25 - ex Region16 metro (all firms), State18 - Coast, State26 (ex Region17), State25, Region16 (FI), State15 - northeastern corner (all firms)",
"Latitude": 38.0033854,
"Longitude": -79.7715309,
"Coordinates": "38.0033854,-79.7715309"
}, {
"RM_Name": "Name47",
"Division": "Division2",
"RM_Phone": "Phone47",
"RC_Name": "Name32",
"RC_Phone": "Phone48",
"States_Covered": "State14 - North (BD, FI)",
"Latitude": 27.975728,
"Longitude": -83.8330166,
"Coordinates": "27.975728,-83.8330166"
}, {
"RM_Name": "Name49",
"Division": "Division2",
"RM_Phone": "Phone49",
"RC_Name": "Name50",
"RC_Phone": "Phone50",
"States_Covered": "State26, Region16 - Metro, State25 - Region18 (BD, FA), Region17 (FI)",
"Latitude": 38.8058411,
"Longitude": -77.2684162,
"Coordinates": "38.8058411,-77.2684162"
}, {
"RM_Name": "Name51",
"Division": "Division2",
"RM_Phone": "Phone51",
"RC_Name": "Name42",
"RC_Phone": "Phone52",
"States_Covered": "State27, State22 - by city (all firms)",
"Latitude": 35.3097654,
"Longitude": -98.7165585,
"Coordinates": "35.3097654,-98.7165585"
}, {
"RM_Name": "Name53",
"Division": "Division3",
"RM_Phone": "Phone53",
"RC_Name": "Name54",
"RC_Phone": "Phone54",
"States_Covered": "State16, State17, State28 - South(all firms)",
"Latitude": 34.7519275,
"Longitude": -92.1323668,
"Coordinates": "34.7519275,-92.1323668"
}, {
"RM_Name": "Name55",
"Division": "Division3",
"RM_Phone": "Phone55",
"RC_Name": "Name56",
"RC_Phone": "Phone56",
"States_Covered": "State28 - Region19 Metro (BD)",
"Latitude": 35.20105,
"Longitude": -91.831833,
"Coordinates": "35.20105,-91.831833"
}, {
"RM_Name": "Name57",
"Division": "Division3",
"RM_Phone": "Phone57",
"RC_Name": "Name58",
"RC_Phone": "Phone58",
"States_Covered": "State29, State30 (All Firms)",
"Latitude": 46.7248,
"Longitude": -94.680176,
"Coordinates": "46.7248,-94.680176"
}, {
"RM_Name": "Name59",
"Division": "Division3",
"RM_Phone": "Phone59",
"RC_Name": "Name60",
"RC_Phone": "Phone60",
"States_Covered": "State28 - Region19 Metro (FI, FP)",
"Latitude": 39.7408263,
"Longitude": -89.503508,
"Coordinates": "39.7408263,-89.503508"
}, {
"RM_Name": "Name61",
"Division": "Division3",
"RM_Phone": "Phone61",
"RC_Name": "Name54",
"RC_Phone": "Phone62",
"States_Covered": "State31 (all firms), Upper Peninsula of State12",
"Latitude": 44.7862909,
"Longitude": -89.8267157,
"Coordinates": "44.7862909,-89.8267157"
}, {
"RM_Name": "Name63",
"Division": "Division3",
"RM_Phone": "Phone63",
"RC_Name": "Name60",
"RC_Phone": "Phone64",
"States_Covered": "State32 (all firms), State28 - Region19 Metro (By Firm)",
"Latitude": 39.7662195,
"Longitude": -86.441277,
"Coordinates": "39.7662195,-86.441277"
}, {
"RM_Name": "Name65",
"Division": "Division3",
"RM_Phone": "Phone65",
"RC_Name": "Name66",
"RC_Phone": "Phone66",
"States_Covered": "State33, State34, State35, State36, State17 - Region20 (all firms)",
"Latitude": 41.9383166,
"Longitude": -93.39108,
"Coordinates": "41.9383166,-93.39108"
}, {
"RM_Name": "Name67",
"Division": "Division3",
"RM_Phone": "Phone67",
"RC_Name": "Name68",
"RC_Phone": "Phone68",
"States_Covered": "State37, State38, State39 (all firms)",
"Latitude": -24.4400201,
"Longitude": 120.9620539,
"Coordinates": "(-)24.4400201,120.9620539"
}, {
"RM_Name": "Name69",
"Division": "Division3",
"RM_Phone": "Phone69",
"RC_Name": "Name70",
"RC_Phone": "Phone70",
"States_Covered": "State40, State41 - Region21 (all firms), N. State42 (BD & FI), Region22 (FI)",
"Latitude": 61.3025006,
"Longitude": -158.7696247,
"Coordinates": "61.3025006,-158.7696247"
}, {
"RM_Name": "Name71",
"Division": "Division3",
"RM_Phone": "Phone71",
"RC_Name": "Name72",
"RC_Phone": "Phone72",
"States_Covered": "N.State42 (FP), Region22 (BD & FP)",
"Latitude": 37.2718745,
"Longitude": -119.2704153,
"Coordinates": "37.2718745,-119.2704153"
}, {
"RM_Name": "Name73",
"Division": "Division3",
"RM_Phone": "Phone73",
"RC_Name": "Name70",
"RC_Phone": "Phone74",
"States_Covered": "State42 - Region23 (all firms)",
"Latitude": 37.2718745,
"Longitude": -119.2704153,
"Coordinates": "37.2718745,-119.2704153"
}, {
"RM_Name": "Name75",
"Division": "Division3",
"RM_Phone": "Phone75",
"RC_Name": "Name72",
"RC_Phone": "Phone76",
"States_Covered": "N. State42 (BD & FI), Region22 (FI)",
"Latitude": 37.2718745,
"Longitude": -119.2704153,
"Coordinates": "37.2718745,-119.2704153"
}, {
"RM_Name": "Name77",
"Division": "Division3",
"RM_Phone": "Phone77",
"RC_Name": "Name68",
"RC_Phone": "Phone78",
"States_Covered": "State43, State44, State45, State1 (all firms)",
"Latitude": 38.997934,
"Longitude": -105.550567,
"Coordinates": "38.997934,-105.550567"
}, {
"RM_Name": "Name79",
"Division": "Division3",
"RM_Phone": "Phone79",
"RC_Name": "Desk1",
"RC_Phone": "Phone80",
"States_Covered": "State42 - North Region24 to Region25, State46 (all firms)",
"Latitude": 37.2718745,
"Longitude": -119.2704153,
"Coordinates": "37.2718745,-119.2704153"
}, {
"RM_Name": "Name81",
"Division": "Division3",
"RM_Phone": "Phone81",
"RC_Name": "Name82",
"RC_Phone": "Phone82",
"States_Covered": "State42 - Region27 to Region23 (all firms)",
"Latitude": 37.2718745,
"Longitude": -119.2704153,
"Coordinates": "37.2718745,-119.2704153"
}, {
"RM_Name": "Name83",
"Division": "Division3",
"RM_Phone": "Phone83",
"RC_Name": "Name84",
"RC_Phone": "Phone84",
"States_Covered": "State42 - Downtown Region24, Region26, South Bay & Inland Empire (All Firms)",
"Latitude": 37.2718745,
"Longitude": -119.2704153,
"Coordinates": "37.2718745,-119.2704153"
}]
$.getJSON('/path/to/data.js', function (data) {
$.each(data, function (i, item) {
var rm_name = item.RM_Name, division = item.Division, rm_phone = item.RM_Phone, rc_name = item.RC_Name, rc_phone = item.RC_Phone, states = item.States_Covered;
});
});
The code above lets me get the data for all, How can I modify this code so I can have them grouped or something similar. sorry if there is no fiddle yet.Thanks.