{"meldingen":[{"id":"22950352","melding":"A1 Hofwijckstraat SGRAVH : 15113","tekstmelding":"Ambulance met spoed naar Hofwijckstraat, 'S-Gravenhage","dienstid":"3","regioid":"25","dienst":"Ambulance","regio":"Haaglanden","plaats":"2515RN  's-gravenhage","postcode":"2515RN","straat":"Hofwijckstraat","datum":"07-11","tijd":"02:31 - 02:33","lat":"52.07112","lon":"4.32448","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1520013","omschrijving":"Ambulance 13, RAV Haaglanden"},{"capcode":"2029576","omschrijving":"???"}],"capstring":"1520013: Ambulance 13, RAV Haaglanden\n2029576: ???","details":"","subitems":[{"id":"22950356","melding":"A1 AMBU 17992 Hofwijckstraat 's-Gravenhage SGRAVH bon 158069","tekstmelding":"Lifeliner met spoed naar Hofwijckstraat, 'S-Gravenhage","dienstid":"5","regioid":"10","dienst":"Lifeliner","regio":"Rotterdam-Rijnmond","plaats":"2515RN  's-gravenhage","postcode":"2515RN","straat":"Hofwijckstraat","datum":"07-11","tijd":"02:33","lat":"52.07112","lon":"4.32448","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420059","omschrijving":"Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"},{"capcode":"2029582","omschrijving":"???"}],"capstring":"1420059: Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )\n2029582: ???","details":""}]},{"id":"22950221","melding":"A1 13991 Lange Jansstraat 3512 Utrecht 112449 regio 9","tekstmelding":"Lifeliner met spoed naar Lange Jansstraat, Utrecht","dienstid":"5","regioid":"1","dienst":"Lifeliner","regio":"Amsterdam-Amstelland","plaats":"3512BA  Utrecht","postcode":"3512BA","straat":"Lange jansstraat","datum":"07-11","tijd":"01:12","lat":"52.09334","lon":"5.11987","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"120901","omschrijving":"Traumaheli LifeLiner 1 - MMT [LifeLiner 1]"}],"capstring":"120901: Traumaheli LifeLiner 1 - MMT [LifeLiner 1]","details":""},{"id":"22949966","melding":"A1 AMBU 17152 Prinsenlaan 3067TX Rotterdam ROTTDM bon 158020","tekstmelding":"Ambulance met spoed naar Prinsenlaan, Rotterdam","dienstid":"3","regioid":"10","dienst":"Ambulance","regio":"Rotterdam-Rijnmond","plaats":"3067TX  Rotterdam","postcode":"3067TX","straat":"Prinsenlaan","datum":"06-11","tijd":"22:56 - 23:02","lat":"51.94012","lon":"4.55016","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420052","omschrijving":"Ambulance 17-152 \/ VRR - AZRR"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"},{"capcode":"2029583","omschrijving":"???"}],"capstring":"1420052: Ambulance 17-152 \/ VRR - AZRR\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )\n2029583: ???","details":"","subitems":[{"id":"22949993","melding":"A0 AMBU 17875 Prinsenlaan 3067TX Rotterdam ROTTDM bon 158024","tekstmelding":"Ambulance met gepaste spoed naar Prinsenlaan, Rotterdam","dienstid":"3","regioid":"10","dienst":"Ambulance","regio":"Rotterdam-Rijnmond","plaats":"3067TX  Rotterdam","postcode":"3067TX","straat":"Prinsenlaan","datum":"06-11","tijd":"23:08","lat":"51.94012","lon":"4.55016","prio1":"0","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420875","omschrijving":"???"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"},{"capcode":"2029577","omschrijving":"???"}],"capstring":"1420875: ???\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )\n2029577: ???","details":""},{"id":"22949980","melding":"A0 AMBU 17992 Prinsenlaan 3067TX Rotterdam ROTTDM bon 158023","tekstmelding":"Lifeliner met gepaste spoed naar Prinsenlaan, Rotterdam","dienstid":"5","regioid":"10","dienst":"Lifeliner","regio":"Rotterdam-Rijnmond","plaats":"3067TX  Rotterdam","postcode":"3067TX","straat":"Prinsenlaan","datum":"06-11","tijd":"23:03","lat":"51.94012","lon":"4.55016","prio1":"0","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420059","omschrijving":"Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"},{"capcode":"2029575","omschrijving":"???"}],"capstring":"1420059: Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )\n2029575: ???","details":""},{"id":"22949976","melding":"A0 AMBU 17114 Prinsenlaan 3067TX Rotterdam ROTTDM bon 158022","tekstmelding":"Ambulance met gepaste spoed naar Prinsenlaan, Rotterdam","dienstid":"3","regioid":"10","dienst":"Ambulance","regio":"Rotterdam-Rijnmond","plaats":"3067TX  Rotterdam","postcode":"3067TX","straat":"Prinsenlaan","datum":"06-11","tijd":"23:02","lat":"51.94012","lon":"4.55016","prio1":"0","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420014","omschrijving":"Ambulance 17-114 \/ VRR - AZRR"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"}],"capstring":"1420014: Ambulance 17-114 \/ VRR - AZRR\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )","details":""}]},{"id":"22949898","melding":"A1 Ambu 08993 - Heideweg Hooglanderveen Rit 337515","tekstmelding":"Lifeliner met spoed naar Heideweg, Hooglanderveen","dienstid":"5","regioid":"13","dienst":"Lifeliner","regio":"Gelderland-Zuid","plaats":"3829BA  Hooglanderveen","postcode":"3829BA","straat":"Heideweg","datum":"06-11","tijd":"22:26","lat":"52.18965","lon":"5.42637","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"923993","omschrijving":"Traumaheli Lifeliner 3 - MMT [LifeLiner 3]"}],"capstring":"923993: Traumaheli Lifeliner 3 - MMT [LifeLiner 3]","details":""},{"id":"22949883","melding":"A0 (Inzet AED) (dia: ja) 12158 12151 Rit 158927 158928 Poelven Castricum","tekstmelding":"Ambulance met gepaste spoed naar Poelven, Castricum","dienstid":"3","regioid":"9","dienst":"Ambulance","regio":"Kennemerland","plaats":"1901HD  Castricum","postcode":"1901HD","straat":"Poelven","datum":"06-11","tijd":"22:23 - 22:24","lat":"52.55381","lon":"4.65663","prio1":"0","brandinfo":null,"grip":"0","capcodes":[{"capcode":"126151","omschrijving":"Witte Kruis, ambulance 151 (Reserve)"},{"capcode":"126158","omschrijving":"Witte Kruis, ambulance 158 \/ Velsen"},{"capcode":"126999","omschrijving":"Monitorcode"}],"capstring":"126151: Witte Kruis, ambulance 151 (Reserve)\n126158: Witte Kruis, ambulance 158 \/ Velsen\n126999: Monitorcode","details":"","subitems":[{"id":"22949886","melding":"A0 (DIA) 13991 Poelven 1901 Castricum 112421 regio 10","tekstmelding":"Lifeliner met gepaste spoed naar Poelven, Castricum","dienstid":"5","regioid":"1","dienst":"Lifeliner","regio":"Amsterdam-Amstelland","plaats":"1901HD  Castricum","postcode":"1901HD","straat":"Poelven","datum":"06-11","tijd":"22:24","lat":"52.55381","lon":"4.65663","prio1":"0","brandinfo":null,"grip":"0","capcodes":[{"capcode":"120901","omschrijving":"Traumaheli LifeLiner 1 - MMT [LifeLiner 1]"}],"capstring":"120901: Traumaheli LifeLiner 1 - MMT [LifeLiner 1]","details":""}]},{"id":"22949836","melding":"A1 (MMT) 13991 Stadhouder 3232 Brielle 112415","tekstmelding":"Lifeliner met spoed naar Stadhouder, Brielle","dienstid":"5","regioid":"1","dienst":"Lifeliner","regio":"Amsterdam-Amstelland","plaats":"3232  Brielle","postcode":"3232","straat":"Stadhouder","datum":"06-11","tijd":"22:04","lat":"0.00000","lon":"0.00000","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"120901","omschrijving":"Traumaheli LifeLiner 1 - MMT [LifeLiner 1]"}],"capstring":"120901: Traumaheli LifeLiner 1 - MMT [LifeLiner 1]","details":""},{"id":"22949812","melding":"A1 AMBU 17117 Stadhouder 3232PT Brielle BRIELL bon 158008","tekstmelding":"Ambulance met spoed naar Stadhouder, Brielle","dienstid":"3","regioid":"10","dienst":"Ambulance","regio":"Rotterdam-Rijnmond","plaats":"3232PT  Brielle","postcode":"3232PT","straat":"Stadhouder","datum":"06-11","tijd":"21:53 - 22:01","lat":"51.89225","lon":"4.17861","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420017","omschrijving":"Ambulance 17-117 \/ VRR - AZRR"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"}],"capstring":"1420017: Ambulance 17-117 \/ VRR - AZRR\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )","details":"","subitems":[{"id":"22949832","melding":"A1 AMBU 17992 Stadhouder 3232PT Brielle BRIELL bon 158011","tekstmelding":"Lifeliner met spoed naar Stadhouder, Brielle","dienstid":"5","regioid":"10","dienst":"Lifeliner","regio":"Rotterdam-Rijnmond","plaats":"3232PT  Brielle","postcode":"3232PT","straat":"Stadhouder","datum":"06-11","tijd":"22:01","lat":"51.89225","lon":"4.17861","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420059","omschrijving":"Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"}],"capstring":"1420059: Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )","details":""}]},{"id":"22949771","melding":"A1 Regulus WADDXV : 16150","tekstmelding":"Ambulance met spoed naar Regulus, Waddinxveen","dienstid":"3","regioid":"5","dienst":"Ambulance","regio":"Hollands Midden","plaats":"2743MD  Waddinxveen","postcode":"2743MD","straat":"Regulus","datum":"06-11","tijd":"21:33 - 21:34","lat":"52.03327","lon":"4.63016","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1523150","omschrijving":"Ambulance voertuig 16-150"},{"capcode":"2029575","omschrijving":"???"}],"capstring":"1523150: Ambulance voertuig 16-150\n2029575: ???","details":"","subitems":[{"id":"22949782","melding":"A1 Regulus WADDXV : 16157","tekstmelding":"Ambulance met spoed naar Regulus, Waddinxveen","dienstid":"3","regioid":"5","dienst":"Ambulance","regio":"Hollands Midden","plaats":"2743MD  Waddinxveen","postcode":"2743MD","straat":"Regulus","datum":"06-11","tijd":"21:38","lat":"52.03327","lon":"4.63016","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1523157","omschrijving":"Ambulance voertuig 16-157"}],"capstring":"1523157: Ambulance voertuig 16-157","details":""},{"id":"22949772","melding":"A1 (DIA: ja) AMBU 17992 Regulus 2743MD Waddinxveen WADDXV bon 158004","tekstmelding":"Lifeliner met spoed naar Regulus, Waddinxveen","dienstid":"5","regioid":"10","dienst":"Lifeliner","regio":"Rotterdam-Rijnmond","plaats":"2743MD  Waddinxveen","postcode":"2743MD","straat":"Regulus","datum":"06-11","tijd":"21:34","lat":"52.03327","lon":"4.63016","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420059","omschrijving":"Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"},{"capcode":"2029576","omschrijving":"???"}],"capstring":"1420059: Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )\n2029576: ???","details":""}]},{"id":"22949536","melding":"A2 (DIA: ja) AMBU 17170 Seringenhof 3121AV Schiedam SCHIDM bon 157980","tekstmelding":"Ambulance met gepaste spoed naar Seringenhof, Schiedam","dienstid":"3","regioid":"10","dienst":"Ambulance","regio":"Rotterdam-Rijnmond","plaats":"3121AV  Schiedam","postcode":"3121AV","straat":"Seringenhof","datum":"06-11","tijd":"20:16 - 20:26","lat":"51.93162","lon":"4.37646","prio1":"0","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420070","omschrijving":"Ambulance 17-170 \/ VRR - AZRR"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"},{"capcode":"2029581","omschrijving":"???"}],"capstring":"1420070: Ambulance 17-170 \/ VRR - AZRR\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )\n2029581: ???","details":"","subitems":[{"id":"22949576","melding":"A1 (DIA: ja) AMBU 17992 Seringenhof 3121AV Schiedam SCHIDM bon 157985","tekstmelding":"Lifeliner met spoed naar Seringenhof, Schiedam","dienstid":"5","regioid":"10","dienst":"Lifeliner","regio":"Rotterdam-Rijnmond","plaats":"3121AV  Schiedam","postcode":"3121AV","straat":"Seringenhof","datum":"06-11","tijd":"20:26","lat":"51.93162","lon":"4.37646","prio1":"1","brandinfo":null,"grip":"0","capcodes":[{"capcode":"1420059","omschrijving":"Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]"},{"capcode":"1420999","omschrijving":"MKA Rotterdam-Rijnmond ( Monitorcode )"},{"capcode":"2029578","omschrijving":"???"}],"capstring":"1420059: Traumaheli LifeLiner 2 - MMT 90.1 \/ VRR - AZRR [LifeLiner 2]\n1420999: MKA Rotterdam-Rijnmond ( Monitorcode )\n2029578: ???","details":""}]},{"id":"22949513","melding":"P 1 BMD-01 Reanimatie Markerkant 15 Almere 254135 254131","tekstmelding":"Brandweer met spoed naar Markerkant 15, Almere, voor een hulpverlening","dienstid":"2","regioid":"27","dienst":"Brandweer","regio":"Flevoland","plaats":"1314AT  Almere","postcode":"1314AT","straat":"Markerkant 15","datum":"06-11","tijd":"20:10 - 20:11","lat":"52.38062","lon":"5.21653","prio1":"1","brandinfo":"hulpverlening","grip":"0","capcodes":[{"capcode":"700001","omschrijving":"Monitorcode Brandweer"},{"capcode":"700140","omschrijving":"Dagdienst \/ Almere-Haven"},{"capcode":"700160","omschrijving":"Beroepsgroep \/ Almere-Stad"},{"capcode":"701101","omschrijving":"Kazernealarm \/ Almere-Stad"}],"capstring":"700001: Monitorcode Brandweer\n700140: Dagdienst \/ Almere-Haven\n700160: Beroepsgroep \/ Almere-Stad\n701101: Kazernealarm \/ Almere-Stad","details":"Type: hulpverlening","subitems":[{"id":"22949521","melding":"A0 13901 Markerkant 15 Almere 112393","tekstmelding":"Lifeliner met gepaste spoed naar Markerkant 15, Almere","dienstid":"5","regioid":"1","dienst":"Lifeliner","regio":"Amsterdam-Amstelland","plaats":"1314AT  Almere","postcode":"1314AT","straat":"Markerkant 15","datum":"06-11","tijd":"20:11","lat":"52.38062","lon":"5.21653","prio1":"0","brandinfo":null,"grip":"0","capcodes":[{"capcode":"120901","omschrijving":"Traumaheli LifeLiner 1 - MMT [LifeLiner 1]"},{"capcode":"120999","omschrijving":"RAVAA - Lichtkrant"},{"capcode":"2029579","omschrijving":"???"}],"capstring":"120901: Traumaheli LifeLiner 1 - MMT [LifeLiner 1]\n120999: RAVAA - Lichtkrant\n2029579: ???","details":""}]}],"sql":"select m.* from vwmeldingen m  join betrokkenonderdelen xx on xx.idmelding = m.idmelding join capcodes xy on xy.idcapcode = xx.idonderdeel and capcode in (1404932, 1404925, 1404926, 1404939, 1404300) where  m.iddienst != 5 and m.dmeldmoment > now() - interval '14 day' union all  select m.* from vwmeldingen m  where m.iddienst = 5 and m.dmeldmoment > now() - interval '14 day' order by idmelding desc limit 20","high_id":"22950536","prev_high_id":-1}