-
Notifications
You must be signed in to change notification settings - Fork 0
/
police-data-portal.dmm
1 lines (1 loc) · 108 KB
/
police-data-portal.dmm
1
{"tables":{"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be":{"id":"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be","visible":true,"name":"Agency","x":752,"y":168,"desc":"Agency Information about Police / Sheriff Department","cols":[{"id":"711dab1c-6908-4c0e-bce3-da1db5da70e4","name":"id","datatype":"INTEGER","param":"15","pk":true,"nn":true,"comment":"","defaultValue":"","data":"","unsigned":true,"autoinc":true},{"id":"d726b309-a9ac-4202-bdd3-cfd109afedcd","name":"agency_type","datatype":"ENUM","param":0,"pk":false,"nn":true,"comment":"XWK_21 - AGENCY TYPE","defaultValue":"","data":"","enumrange":"['local-police-department', 'sheriffs-office', 'state-law-enforcement-agency', 'special-jurisdiction', 'constable-marshal', 'federal']","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"cad7523b-12fe-432d-9d16-5f6d2a342457","name":"agency_sub_type_1","datatype":"ENUM","param":0,"pk":false,"nn":true,"comment":"XWK_22 - AGENCY SUB-TYPE 1","defaultValue":"","data":"","enumrange":"['public-buildings-facilities', 'natural-resources-parks-and-recreation', 'transportation-systems-facilities', 'criminal-investigations', 'special-enforcement', 'not-applicable']","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"deedc8a0-d165-4866-acd8-fb9574e739ed","name":"agency_sub_type_2","datatype":"ENUM","param":0,"pk":false,"nn":false,"comment":"XWK_23 - AGENCY SUB-TYPE 2","defaultValue":"","data":"","enumrange":"['not-applicable']","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"e109833d-ef77-4f3c-89b5-4c130b1e32a7","name":"ori9","datatype":"STRING","param":"9","pk":false,"nn":true,"comment":"XWK_1 - Unique ORI9 of Agency","defaultValue":"","data":"AK0010100","enumrange":"","unique":true,"uniqueName":"ori9","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f04f767b-0dd4-4a46-bc33-625ccfbcc486","name":"ori9_imp","datatype":"BOOLEAN","param":"","pk":false,"nn":true,"comment":"XWK_2 - Flag: Imputed ORI9","defaultValue":"","data":"1","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"9c89a446-4e6f-4b13-a9b0-d60ccf6ce4d6","name":"ori7","datatype":"STRING","param":"7","pk":false,"nn":true,"comment":"XWK_3 - ORIGINATING AGENCY IDENTIFIER (7 CHARACTERS) FROM UCR FILES","defaultValue":"","data":"AK00101","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f69649c7-d78f-43bd-a27a-f3b93b7c200f","name":"ori7_imp","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_4 - Flag: Imputed ORI7","defaultValue":"","data":"1","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"4baae0fb-38ec-43f0-9193-ee598303eb1d","name":"ori_fbi","datatype":"STRING","param":"9","pk":false,"nn":false,"comment":"XWK_5 - ORI NUMBER ASSIGNED BY FBI","defaultValue":"","data":"AK00101","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"34043018-1b56-4ba1-89b6-374a55e4f8b3","name":"is_sub_agency","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_20 - AGENCY/ORI IS PART OF LARGER PARENT AGENCY","defaultValue":"","data":"1","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"22db2c84-5f62-4315-925d-e05b6bf1fad6","name":"government_id","datatype":"INTEGER","param":"9","pk":false,"nn":true,"comment":"XWK_24 - GOVERNMENT ID (CENSUS)","defaultValue":"","data":"22002001","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"0b04dc8b-d6b9-4119-a6e9-d41f3625a671","name":"agency_name","datatype":"STRING","param":"100","pk":false,"nn":true,"comment":"XWK_15 - AGENCY NAME","defaultValue":"","data":"ANCHORAGE POLICE DEPARTMENT","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"2c410202-7825-4110-9852-8044a7e506da","name":"address_name","datatype":"STRING","param":"100","pk":false,"nn":true,"comment":"XWK_26 - ADDRESS - NAME","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"c6dc0cc8-f6a0-4bda-a6c7-cdcd3cb26195","name":"address_street_1","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_27 - ADDRESS - STREET LINE 1","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"9bf5ae03-038a-4016-b748-4df43b480810","name":"address_street_2","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_28- ADDRESS - STREET LINE 2","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"9ee3d17c-b4b5-4305-84c8-35a066e5bbb0","name":"address_city","datatype":"STRING","param":"50","pk":false,"nn":false,"comment":"XWK_29 - ADDRESS - CITY","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"63bd178a-a597-4d76-a793-e4db9c428dd5","name":"address_state","datatype":"STRING","param":"2","pk":false,"nn":true,"comment":"XWK_30 - ADDRESS - STATE","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f4e295c0-b67d-45a5-8e78-d1fb2207d9dd","name":"address_zip_code\t","datatype":"STRING","param":"5","pk":false,"nn":false,"comment":"XWK_31 - ADDRESS - ZIP CODE","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"843cbd97-6617-4491-b438-62bba6e17fb7","name":"district","datatype":"INTEGER","param":"2","pk":false,"nn":false,"comment":"XWK_44 - CONGRESSIONAL DISTRICT 1 (AS OF 2010)","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ba119a62-e59d-49c1-8128-7883dc70ecf1","name":"districts","datatype":"STRING","param":"50","pk":false,"nn":false,"comment":"XWK_45 - CONGRESSIONAL DISTRICTS 2 THROUGH 18 (AS OF 2010)","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"b0dd1990-057e-4036-b986-4b6028e77412","name":"district_name","datatype":"STRING","param":"100","pk":false,"nn":true,"comment":"XWK_46 - FEDERAL JUDICIAL DISTRICT NAME","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"9fa33472-8caa-4574-a16c-52ba00a9c210","name":"fips_county_code","datatype":"STRING","param":"3","pk":false,"nn":true,"comment":"XWK_13 - FIPS COUNTY CODE","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"48e8d472-0d54-4fe9-a9e2-86aa247deaa4","name":"fips_place_code","datatype":"STRING","param":"5","pk":false,"nn":true,"comment":"XWK_11 - FIPS PLACE CODE","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"c2c2167a-70c5-4720-8faf-f83869301dce","name":"fips_state_code","datatype":"STRING","param":"2","pk":false,"nn":true,"comment":"XWK_12 - FIPS STATE CODE","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f378b29f-7c5c-449c-b091-e418d1e28e7c","name":"geo_county_name","datatype":"STRING","param":"100","pk":false,"nn":true,"comment":"XWK_18 - COUNTY NAME","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"b36af2e6-96e5-41f6-b0ac-c2bc084c81a5","name":"geo_state_name","datatype":"STRING","param":"100","pk":false,"nn":true,"comment":"XWK_17 - STATE NAME","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"4088f58c-3bc7-4ad4-9338-210e185a0ec6","name":"geo_latitude","datatype":"FLOAT","param":"15","pk":false,"nn":true,"comment":"XWK_42 - latitude","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"0f9e963a-cddb-4ccd-8a65-c7e302b62c8d","name":"geo_longitude","datatype":"FLOAT","param":"15","pk":false,"nn":true,"comment":"XWK_43 - longitude","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"26d4d4dd-0ac4-4a7b-af23-4714d30149ff","name":"census_name","datatype":"STRING","param":"100","pk":false,"nn":true,"comment":"XWK_25 - CENSUS NAME","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"535f8fdf-7e90-4cee-ba33-f2d1e95f1241","name":"census_population","datatype":"INTEGER","param":"15","pk":false,"nn":false,"comment":"XWK_39 - CENSUS POPULATION","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"8e1cc2c8-8fcc-412f-9a55-2102a75e5d6e","name":"csllea_agency_id","datatype":"INTEGER","param":"8","pk":false,"nn":false,"comment":"XWK_33 - CSLLEA 2008 AGENCY IDENTIFIER","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"1e040cb1-174f-494a-8fc7-de8540615370","name":"group_number","datatype":"STRING","param":"4","pk":false,"nn":false,"comment":"XWK_37 - GROUP NUMBER (AS OF 2012)","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"970db870-5cf7-4443-aeda-096309b85066","name":"leaic_subset_flag","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_40 - FLAG VARIABLE TO SUBSET THE LEAIC TO APPROXIMATE THE CSLLEA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"c360b2d0-cbe3-4173-9d6e-ea1cd6dd41f9","name":"lemas_files_id","datatype":"STRING","param":"16","pk":false,"nn":false,"comment":"XWK_34 - LEMAS FILES ID","defaultValue":"","data":"220080010260100","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"4f0784cf-da96-442e-8b45-9b0177001216","name":"reported_offenses","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"XWK_32 - ORI REPORTED 1 OR MORE OFFENSES 1985 - 2012","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"d3eda27b-7950-496e-9011-c98c3891189f","name":"source_csllea_2008","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_47 - SOURCE FILE FLAG: CSLLEA 2008","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"1138c608-aac4-4324-8658-9f1b556e2831","name":"source_ucr_2010","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_48 - SOURCE FILE FLAG: UCR 2010","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"acc1791c-e1a0-46b5-b811-d20937a409e3","name":"source_ucr_2011","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_49 - SOURCE FILE FLAG: UCR 2011","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"238037a1-14c1-43ce-9163-2ab26cae7460","name":"source_ucr_2012","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_50 - SOURCE FILE FLAG: UCR 2012","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"e882690b-5261-4d21-9135-6cf57baa83fc","name":"source_ncic_2012","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_51 - SOURCE FILE FLAG: NCIC 2012","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"b1688e90-4c63-43a4-a580-4d09552e5b85","name":"source_vendor_2012","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"XWK_50 - SOURCE FILE FLAG: VENDOR FILE 2012","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"5fc888eb-8554-4d29-a78d-5d95a908c2a2","name":"ucr_county_code","datatype":"INTEGER","param":"2","pk":false,"nn":false,"comment":"XWK_36 - UCR COUNTY (UCR CODING)","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"e88ac07b-bf89-4c2b-bf13-3faedfb7355c","name":"ucr_state_code","datatype":"INTEGER","param":"2","pk":false,"nn":false,"comment":"XWK_35 - UCR NUMERIC STATE CODE (UCR CODING)","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"c9c16e71-32bb-45c8-b759-32b1e0c58334","name":"ucr_population","datatype":"INTEGER","param":"15","pk":false,"nn":false,"comment":"XWK_38 - UCR TOTAL POPULATION (AS OF 2012)","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"2455ab25-9f8e-4022-a914-90413a95a0d6","name":"urban_name","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_19 - URBAN AREA/URBAN CLUSTER NAME","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ce0573d9-982d-4be4-9582-86f8397629e1","name":"urban_code","datatype":"INTEGER","param":"7","pk":false,"nn":true,"comment":"XWK_16 - URBAN AREA/URBAN CLUSTER CODE","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"af464d46-2e12-4a2d-bbc3-665a5ce24d56","name":"comments","datatype":"TEXT","param":0,"pk":false,"nn":false,"comment":"XWK_41 - COMMENTS - TYPICALLY LISTING INFORMATION ON MULTIJURISDICTIONAL","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false}],"relations":["6c81c7e5-2580-4cb4-b8f7-fff7d8b0f6ec","6141d52c-b324-4299-bbba-9b44150c5127","eb7776db-0752-41f3-a2fc-062e770e2201","912cee0d-1e4b-4d50-9c0b-ae9403ea68b6","708fb2b6-b68c-4305-b475-ecbea3b34ed7","a2fc7141-80d4-4ff6-b589-934daec67721","e0f62c0b-d054-4069-ba29-a11577b6005a"],"lines":[],"keys":[{"id":"8d368d9f-d439-4af9-9e33-b8bedfdd31f0","name":"Primary key","isPk":true,"using":"na","cols":[{"id":"9ac8ec6e-1fd1-4ad9-aa76-aaf7d9e398cb","colid":"711dab1c-6908-4c0e-bce3-da1db5da70e4"}]}],"indexes":[{"id":"ee859806-a347-4dcf-80b2-c8044c4f48bb","name":"address_city_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"ab1c5df0-ec7a-456f-8153-bb17780b0a86","colid":"9ee3d17c-b4b5-4305-84c8-35a066e5bbb0"}]},{"id":"fcec8bc1-06e7-4442-b861-74603f12ec8f","name":"address_state_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"333bdb17-89c5-4384-a777-8c04cdc67bbf","colid":"63bd178a-a597-4d76-a793-e4db9c428dd5"}]},{"id":"0c2f5d65-ddd1-4a33-96ca-15c88c7aac0f","name":"fips_county_code_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"d6075fee-dced-4cfa-8a19-61cf2b5df49f","colid":"9fa33472-8caa-4574-a16c-52ba00a9c210"}]},{"id":"9f15f6a0-da79-4376-af5d-7ecd4b88ddaf","name":"fips_place_code_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"497480e9-63c4-4986-b3f6-447a1bdb44b9","colid":"48e8d472-0d54-4fe9-a9e2-86aa247deaa4"}]},{"id":"9777931e-622a-441d-a38e-9fe2eea0cead","name":"fips_state_code_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"c0989e3a-7cc9-4793-9c8b-500a0fa2eea5","colid":"c2c2167a-70c5-4720-8faf-f83869301dce"}]},{"id":"a07a9590-9660-425e-97fd-5c0720e016bd","name":"geo_county_name_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"e68b4b9c-113f-4e9d-aaaa-fff38b0ad5c5","colid":"f378b29f-7c5c-449c-b091-e418d1e28e7c"}]},{"id":"b7c6092c-edf4-4a99-8ae5-c268fbcb79fa","name":"geo_state_name_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"be1b744a-ae72-453d-a392-c493634b0ec3","colid":"b36af2e6-96e5-41f6-b0ac-c2bc084c81a5"}]},{"id":"f735d182-9bf4-4b57-853c-b6297699b175","name":"agency_type_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"d27efafe-fba9-48a4-9b30-e45c643946f8","colid":"d726b309-a9ac-4202-bdd3-cfd109afedcd"}]},{"id":"daf2b18b-11ec-44f0-9ef8-6e486e9ccc97","name":"agency_sub_type_1_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"c7b99811-9d8f-4b11-956b-dde9b8b96312","colid":"cad7523b-12fe-432d-9d16-5f6d2a342457"}]},{"id":"7945f768-c2d9-434f-a0fa-69533445c87c","name":"agency_sub_type_2_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"121b1039-b3b8-41c1-b000-30ec6706edc4","colid":"deedc8a0-d165-4866-acd8-fb9574e739ed"}]}],"gHeight":880,"gWidth":311,"color":"#ffffff","background":"#03a9f4","resized":false,"embeddable":false,"freezeTableName":true,"timestamps":true,"tabletype":"InnoDB","paranoid":true,"version":false,"collation":"utf8_unicode_ci","charset":"utf8mb4","underscored":true,"tablename":"agency","singular":"agency","plural":"agencies"},"dc5e34d6-6a8b-4e88-ad4a-2c21be29f5f2":{"id":"dc5e34d6-6a8b-4e88-ad4a-2c21be29f5f2","visible":true,"name":"AnnualDeaths","x":1088,"y":168,"desc":"Officer Involved Annual Death Counts","cols":[{"id":"f251bd49-daa8-45d4-879d-55c1b27b46a1","name":"id","datatype":"INTEGER","param":"15","pk":true,"nn":true,"comment":"","defaultValue":"","data":"","autoinc":true,"unsigned":true},{"id":"71baff03-7b1d-4817-ab69-e11968a6e5bb","name":"agency_id","datatype":"INTEGER","param":"15","pk":false,"nn":true,"comment":"","defaultValue":"","data":"","fk":true,"ref":"Agency","unsigned":true},{"id":"10bc729a-ddcc-45c6-8f3f-9eb46ae02526","name":"source_year","datatype":"INTEGER","param":"4","pk":false,"nn":true,"comment":"XWK_6 - Year of merged data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"cc538bf2-27a4-4f3c-b769-1a59cfdbc69e","name":"source_name","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_7 - Data Source Name","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"2e8a83bc-0dfb-4da4-b38b-7652a4675057","name":"is_imputed","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"FE_1-29 Indicates Record Substitutes Missing Data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"false"},{"id":"24977d85-0e98-4ce8-a894-26c58f5b2836","name":"type","datatype":"ENUM","param":0,"pk":false,"nn":false,"comment":"FE_1-29 Type of Death","defaultValue":"","data":"'gunshot'","enumrange":"['asian-deaths', 'asphyxiated-or-restrained', 'beaten-or-bludgeoned', 'black-deaths', 'burned-or-smoke-inhalation', 'chemical-agent-or-pepper-spray', 'drowned', 'drug-overdose', 'fell-from-height', 'fell-from-height-or-drowned', 'gunshot', 'hispanic-deaths', 'imputed-race', 'intentional-use-of-force', 'justifiable-homicide', 'medical-emergency', 'medical-emergency-or-overdose', 'middle-eastern-deaths', 'native-american-deaths', 'officer-involved', 'other', 'other-or-undetermined', 'stabbed', 'suicide-by-police-deaths', 'suicide-deaths', 'tasered', 'undetermined', 'unknown-race-deaths', 'vehicle', 'white-deaths']","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"'undetermined'"},{"id":"853e847e-47db-4b6b-a776-2ec6473206f5","name":"death_count","datatype":"FLOAT","param":"15","pk":false,"nn":false,"comment":"FE_1-29 Number of Deaths","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"a0a66fdd-3d4a-4e93-8b57-a2d0144b6db9","name":"ethnicity","datatype":"ENUM","param":0,"pk":false,"nn":false,"comment":"FE_1-29 Ethnicity of Death","defaultValue":"","data":"'black'","enumrange":"['black', 'white', 'hispanic', 'asian', 'middle-eastern', 'native-american', 'unspecified']","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"'unspecified'"},{"id":"4d440795-6894-4bf6-a2c2-34e8a14eabd1","name":"suicides_omitted","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"FE_1-29 Indicates Record Subtracted Deaths by Suicide","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"0"},{"id":"1ef1be55-8737-4504-b817-2477e1de12c9","name":"justifiable_homicides","datatype":"INTEGER","param":0,"pk":false,"nn":false,"comment":"SHR_1 Count of Justifiable Homicides, SHR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false}],"relations":["6c81c7e5-2580-4cb4-b8f7-fff7d8b0f6ec"],"lines":[],"keys":[{"id":"51b1727d-acac-4793-8450-e87997423987","name":"Primary key","isPk":true,"using":"na","cols":[{"id":"3d362c4a-7058-49da-9c1c-981a17e80e71","colid":"f251bd49-daa8-45d4-879d-55c1b27b46a1"}]}],"indexes":[{"id":"ec6cff97-59d7-4389-a48c-375da6019df5","name":"annual_deaths_agency_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"dcaea7d8-3107-4981-aad5-ac6061eb46e7","colid":"71baff03-7b1d-4817-ab69-e11968a6e5bb"},{"id":"627aad2d-0268-452e-bdac-5e5e3d672425","colid":"10bc729a-ddcc-45c6-8f3f-9eb46ae02526"}]},{"id":"9fe1d04b-bc2a-40f2-bfb2-80b0e305aa41","name":"annual_deaths_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"be96cb24-af3b-4b4e-87d1-003d9ed66315","colid":"10bc729a-ddcc-45c6-8f3f-9eb46ae02526"}]},{"id":"1cc1f2d2-93e1-433a-988d-9592579e6abd","name":"annual_deaths_imputed_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"31d1b24a-bd50-4517-8ff8-748768484438","colid":"2e8a83bc-0dfb-4da4-b38b-7652a4675057"}]},{"id":"37aa16bf-7471-4fb5-b1bc-c2bf15b9e821","name":"annual_deaths_type_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"edb996be-f929-4d6c-bbdd-36beef97ac8a","colid":"24977d85-0e98-4ce8-a894-26c58f5b2836"}]},{"id":"347ab8c7-16af-450b-8782-c96bae619ffa","name":"annual_deaths_ethnicity_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"e623cda2-a28a-4008-b9a4-6438bb1e9e3a","colid":"a0a66fdd-3d4a-4e93-8b57-a2d0144b6db9"}]},{"id":"b1205761-9f91-40b8-9cdb-6b3e03053829","name":"annual_deaths_omitted_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"bba5bd1b-6f7b-4a16-ae3e-afc635ad75d1","colid":"4d440795-6894-4bf6-a2c2-34e8a14eabd1"}]}],"gHeight":214,"gWidth":239,"color":"#ffffff","background":"#607d8b","resized":false,"embeddable":false,"freezeTableName":true,"timestamps":true,"tabletype":"InnoDB","paranoid":true,"version":false,"collation":"utf8_unicode_ci","charset":"utf8mb4","underscored":true,"singular":"annual_death","plural":"annual_deaths","tablename":"annual_deaths"},"c55167f3-96f0-4535-a58a-4e8eaf737d03":{"id":"c55167f3-96f0-4535-a58a-4e8eaf737d03","visible":true,"name":"AnnualOfficerDeaths","x":1351,"y":168,"desc":"Officers Assaulted and Killed Annual Death Counts","cols":[{"id":"5fe629bc-c56a-41b5-856c-7f77e98c41ac","name":"id","datatype":"INTEGER","param":"15","pk":true,"nn":true,"comment":"","defaultValue":"","data":"","autoinc":true,"unsigned":true},{"id":"0aeb67b9-9504-4f2b-baaa-9dfc42c492f7","name":"agency_id","datatype":"INTEGER","param":"15","pk":false,"nn":true,"comment":"","defaultValue":"","data":"","fk":true,"ref":"Agency","unsigned":true},{"id":"446997c6-0b65-45ee-a73c-320073981828","name":"source_year","datatype":"INTEGER","param":"4","pk":false,"nn":true,"comment":"XWK_6 - Year of merged data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"fb8ae784-4e0f-4538-9324-05ad9b7c12a8","name":"source_name","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_7 - Data Source Name","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f5951b18-0b45-4c8e-8871-5be3939ca207","name":"group_code","datatype":"STRING","param":"2","pk":false,"nn":false,"comment":"LEO_1 Group, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"23560318-c261-49d8-bf0d-ca6fe1c6269e","name":"total_population","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"LEO_2 Total Population, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"6cd08950-8613-4dec-ab48-c7f616239c82","name":"total_employees","datatype":"FLOAT","param":"5","pk":false,"nn":false,"comment":"LEO_5 Total Employees, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"71d8f1af-7602-4795-87d9-717bacf0d041","name":"total_officers","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEO_6 Total Officers, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"776b6845-2535-4c93-a216-7d4980db5c3c","name":"male_officers","datatype":"FLOAT","param":"5","pk":false,"nn":false,"comment":"LEO_3 Male Officers, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"a433cbb3-224c-4e91-aaa7-fcc0596bab63","name":"female_officers","datatype":"FLOAT","param":"5","pk":false,"nn":false,"comment":"LEO_4 Female Officers, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"9f52f974-00f5-4cc0-b7c2-41f8301c00b5","name":"officer_rate_per_10k","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEO_7 Officer Rate per 10,000, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"e47ca7b7-3ae9-4cd7-8621-24d5dd6af4ca","name":"months_reported_assaults_with_injury","datatype":"FLOAT","param":"3","pk":false,"nn":false,"comment":"LEO_10 Number of Months Reported, Assaults with Injury, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"949c781f-8142-40d7-8b8b-c5f1f1d7988e","name":"months_reported_assaults_without_injury","datatype":"FLOAT","param":"3","pk":false,"nn":false,"comment":"LEO_11 Number of Months Reported, Assaults without Injury, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"17d4e38d-3acb-4d9f-ae72-718b6e126549","name":"annual_assaults_with_injury","datatype":"FLOAT","param":"7","pk":false,"nn":false,"comment":"LEO_8 Annual Number of Assaults With Injury, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"dbc4393d-0196-42f2-92fc-35ccaf8bec31","name":"annual_assaults_without_injury","datatype":"FLOAT","param":"7","pk":false,"nn":false,"comment":"LEO_9 Annual Number of Assaults Without Injury, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"95ecb3eb-4efd-4996-b6c8-3867b7169001","name":"annual_officers_killed_felony","datatype":"FLOAT","param":"3","pk":false,"nn":false,"comment":"LEO_12 Annual Number of Officers Killed, Felony, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"87e6e87b-e36f-41c6-beb0-e6b5c417b4d4","name":"annual_officers_killed_accident","datatype":"FLOAT","param":"3","pk":false,"nn":false,"comment":"LEO_13 Annual Number of Officers Killed, Accident, LEOKA","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false}],"relations":["6141d52c-b324-4299-bbba-9b44150c5127"],"lines":[],"keys":[{"id":"8c67b131-33ee-4bba-aaa6-42730e54bc68","name":"Primary key","isPk":true,"using":"na","cols":[{"id":"7e55e546-5886-44cf-a9b4-962a605904e9","colid":"5fe629bc-c56a-41b5-856c-7f77e98c41ac"}]}],"indexes":[{"id":"f8e42074-1904-44f6-9e82-dcd822001152","name":"annual_officer_deaths_agency_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"0128de93-1fba-470a-b9a3-1c7fb52fccf6","colid":"0aeb67b9-9504-4f2b-baaa-9dfc42c492f7"},{"id":"19d21b83-0e0e-4cc8-8101-f67c81f4a140","colid":"446997c6-0b65-45ee-a73c-320073981828"}]},{"id":"03f451db-dea9-4477-b90c-6b575b69a624","name":"annual_officer_deaths_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"01e89133-ecf3-4888-a716-f749a648b44a","colid":"446997c6-0b65-45ee-a73c-320073981828"}]}],"gHeight":340,"gWidth":419,"color":"#ffffff","background":"#607d8b","resized":false,"embeddable":false,"freezeTableName":true,"timestamps":true,"tabletype":"InnoDB","paranoid":true,"version":false,"collation":"utf8_unicode_ci","charset":"utf8mb4","underscored":true,"singular":"annual_officer_death","plural":"annual_officer_deaths","tablename":"annual_officer_deaths"},"e371513c-cc89-42e9-9756-8a39b1f1a764":{"id":"e371513c-cc89-42e9-9756-8a39b1f1a764","visible":true,"name":"Characteristics","x":1350,"y":522,"desc":"Police Department Characteristics","cols":[{"id":"a1943087-3e0f-4ec5-b1fa-dda90a0c0494","name":"id","datatype":"INTEGER","param":"15","pk":true,"nn":true,"comment":"","defaultValue":"","data":"","unsigned":true,"autoinc":true},{"id":"150aa1f0-5faa-4279-9dfe-5dd697af580d","name":"agency_id","datatype":"INTEGER","param":"15","pk":false,"nn":true,"comment":"","defaultValue":"","data":"","fk":true,"ref":"Agency","unsigned":true},{"id":"14b97e3e-1a2f-41d4-9585-1f0dab0019b9","name":"source_year","datatype":"INTEGER","param":"4","pk":false,"nn":true,"comment":"XWK_6 - Year of merged data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"2f7087a9-6337-4047-9cd6-285cf042a081","name":"source_name","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_7 - Data Source Name","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"bb919043-ddab-43b2-9831-b38fee2c30a1","name":"is_imputed","datatype":"BOOLEAN","param":0,"pk":false,"nn":true,"comment":"LEM_1-38 Indicates Imputed Data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":"false"},{"id":"266294d0-a1c7-4763-a13b-8e7651efa694","name":"incentives_education","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_3 Agency Educational Incentives, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false,"defaultvalue":""},{"id":"aa56e9cc-e0be-4a13-bc8b-941fb8846344","name":"incentives_tuition","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_4 Agency Tuition Incentives, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"fe1f8dd0-be64-465f-8fb3-b9c79929b057","name":"training_types","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_5 Count of Training Types, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"5d3f77f0-0ed4-43ba-a661-2d1e66fd9bb1","name":"training_types_normalized","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_6 Count of Training Types Normalized, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"db7fba6f-25e0-4fad-ae74-2e7ca4c023ee","name":"required_training_hours_all","datatype":"INTEGER","param":"4","pk":false,"nn":false,"comment":"LEM_7 Count of All Required Training Hours, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"70957fb4-ede9-4206-b37e-8e1b81f09661","name":"required_training_hours_recruits","datatype":"INTEGER","param":"4","pk":false,"nn":false,"comment":"LEM_8 Count of New Recruit Required Training Hours, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"7a3b9238-4f4e-4e27-8456-a52a33695a05","name":"minimum_education_requirement","datatype":"ENUM","param":"","pk":false,"nn":false,"comment":"LEM_9 Minimum Education Requirement, LEMAS","defaultValue":"","data":"","enumrange":"['four-year-college-degree','two-year-college-degree','some-college-but-no-degree','high-school-diploma-or-equivalent','no-formal-education']","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"6f6e0dbc-37d4-46ef-913d-2a7394272f92","name":"sworn_full_time_men","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_1 Count of Men FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"bc1545d9-2767-4899-9e45-941e55069ce6","name":"sworn_full_time_men_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_28 % Men FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f271b12b-ce0e-4a78-9d62-d0f9ec2d042d","name":"sworn_full_time_women","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_2 Count of Women FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"c0736dfe-aded-42ec-a2c3-cb4f8184e1cb","name":"sworn_full_time_women_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_27 % Women FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"98193d72-fdbb-476e-96de-456a4108f061","name":"sworn_full_time_black","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_11 Count Black FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"6ac5cfff-d61b-4308-af41-3bc283801cee","name":"sworn_full_time_black_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_20 % Black FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"180ebbee-c578-4107-a5e6-ccc4bd73665c","name":"sworn_full_time_white","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_10 Count White FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"b24e719e-e511-482e-8e74-28ef5a07c0d9","name":"sworn_full_time_white_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_19 % White FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"792bbf14-bb6e-4f02-b562-286e3f490252","name":"sworn_full_time_hispanic","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_12 Count Hispanic FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"552ac3ea-a1d4-4768-b5fe-d4902f9973bf","name":"sworn_full_time_hispanic_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_21 % Hispanic FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f3a2c8ac-6dec-46b2-8486-22afc9dc62fb","name":"sworn_full_time_indian","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_13 Count American Indian FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"755712d4-d6b0-487f-bd0c-b3c8348fcc69","name":"sworn_full_time_indian_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_22 % American Indian FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f7c9fbd9-a86a-4072-8ed3-990cdfb73dcf","name":"sworn_full_time_asian","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_14 Count Asian American FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"db00568d-b1db-45a5-8ed3-3057907deb98","name":"sworn_full_time_asian_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_23 % Asian American FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"a887b8b3-08a2-4db2-9b89-a4a4c0b9c3d5","name":"sworn_full_time_hawaiian","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_15 Count Native Hawaiian FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"bcfb27cf-b4f4-41ca-b58c-cd976ef7d7a6","name":"sworn_full_time_hawaiian_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_24 % Native Hawaiian FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"26e18ddd-f435-4c4e-a236-9c1b546a5ed2","name":"sworn_full_time_unreported","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_16 Count Unreported Race FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"dd2991de-fa25-4be4-b7ac-082e3df6a864","name":"sworn_full_time_unreported_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_26 % Unreported Race FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"2a014ddb-491e-4b54-9e28-6b1d8be0f9b8","name":"sworn_full_time_other","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_17 Count Other Race FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"3aa71b26-a1fc-4a35-9201-3aeaca2f04db","name":"sworn_full_time_other_percent","datatype":"INTEGER","param":"3","pk":false,"nn":false,"comment":"LEM_25 % Other Race FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"19736639-90b2-416b-a9ea-fb017d9e986e","name":"sworn_full_time_total","datatype":"INTEGER","param":"6","pk":false,"nn":false,"comment":"LEM_18 Count Total Pop FT Sworn, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"37feb5e5-3a84-4475-83fb-496318c85b50","name":"has_lethal_force_policy","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_29 Written Lethal Force Policy, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"64ce5552-8293-4cdb-b560-52b1f4382cda","name":"has_less_than_lethal_force_policy","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_30 Written Less than Lethal Force Policy, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"b858607b-0343-41da-bd58-190764b31043","name":"has_conduct_appearance_policy","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_31 Written Conduct/Appearance Policy, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"0ec4549c-0aba-41dd-b402-8c74eb2e638c","name":"has_off_duty_employee_policy","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_32 Written Off Duty Emp Policy, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"7a6720cb-e052-4dc7-ad35-a9b400d59ba8","name":"has_off_max_hours_policy","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_33 Written Off Max Hours Policy, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"746d3d46-0035-43e4-8e58-7b100642ec7d","name":"has_domestic_dispute_policy","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_36 Domestic Dispute Policy, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"28c21c54-c6e9-4c34-b369-a5b2c741206c","name":"has_civilian_board_for_excessive_force_complaints","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_37 Civilian Board for Excessive Force Complaints, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"14512abe-11e2-4999-8897-c11e505ec0fa","name":"has_independent_investigative_authority_board","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_38 Independent Investigative Authority for Board, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"15e2748b-766a-47f3-9d7a-d6377e634aaa","name":"pursuits_must_be_reviewed","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"LEM_35 Pursuits Must Be Reviewed, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"6b8f95f8-b141-48fb-b51f-c24918726147","name":"policy_pursuit","datatype":"INTEGER","param":"1","pk":false,"nn":false,"comment":"LEM_34 Description of Written Pursuit Policy, LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ee9a67bc-00fe-4008-a282-7630a9b2a6fb","name":"non_missing","datatype":"INTEGER","param":"1","pk":false,"nn":false,"comment":"LEM_39 Count of nonmissing LEMAS","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false}],"relations":["eb7776db-0752-41f3-a2fc-062e770e2201"],"lines":[],"keys":[{"id":"0aceebc4-fe8a-4a2a-9479-29daf75be24d","name":"Primary key","isPk":true,"using":"na","cols":[{"id":"387b64d8-6a98-41d3-8ece-07f0dd8ff7a9","colid":"a1943087-3e0f-4ec5-b1fa-dda90a0c0494"}]}],"indexes":[{"id":"506db14b-78ef-4e8a-8b80-bd0bd70ad073","name":"characteristics_agency_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"f19f4c69-6dd3-43cc-8634-e0864679dfa9","colid":"150aa1f0-5faa-4279-9dfe-5dd697af580d"},{"id":"a52575cb-512a-48fb-a46a-c232461ef869","colid":"14b97e3e-1a2f-41d4-9585-1f0dab0019b9"}]},{"id":"7459b7ce-77dc-4313-846b-f6855bd2c631","name":"characteristics_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"11967edb-cdfa-48cd-a12f-b83a04bccddb","colid":"14b97e3e-1a2f-41d4-9585-1f0dab0019b9"}]},{"id":"ad4a2bad-9527-4b97-b97f-6a32b15589c1","name":"characteristics_imputed_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"a4b97d1e-6968-4d76-9dd3-3725a83d9027","colid":"bb919043-ddab-43b2-9831-b38fee2c30a1"}]},{"id":"318e37c1-a10c-426a-8ad5-f0b7533201ba","name":"characteristics_education_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"ea277088-a8e6-426b-8b54-b35c88c04ba0","colid":"266294d0-a1c7-4763-a13b-8e7651efa694"}]},{"id":"2faaa293-813a-42ea-8eae-c118b272318d","name":"characteristics_tuition_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"914c1181-2699-4c9b-9d8a-01f19050d389","colid":"aa56e9cc-e0be-4a13-bc8b-941fb8846344"}]},{"id":"13be06a1-664e-4590-8ce6-d23e1149014f","name":"characteristics_lethal_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"60b4c026-47fd-4646-91a2-6aefbcb5e4dd","colid":"37feb5e5-3a84-4475-83fb-496318c85b50"}]},{"id":"5ba2f0a2-5a63-4efc-b0ad-f20fa521e90c","name":"characteristics_less_lethal_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"38ac3214-93df-4cfa-8019-567c5f383e48","colid":"64ce5552-8293-4cdb-b560-52b1f4382cda"}]},{"id":"306c9b19-d69b-417b-9c7b-76dbbe1e083e","name":"characteristics_conduct_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"9899bd3b-7236-4d37-b1e8-978f1bf208d3","colid":"b858607b-0343-41da-bd58-190764b31043"}]},{"id":"e5398095-1405-46dd-9032-c2ae736299d5","name":"characteristics_off_duty_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"25f1b2aa-9d8e-4b5d-9b63-2c6d048b2740","colid":"0ec4549c-0aba-41dd-b402-8c74eb2e638c"}]},{"id":"5ad9921d-cb7d-427a-8073-494128803bb6","name":"characteristics_off_max_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"fd33abda-c683-4d89-8583-a4a1ed843510","colid":"7a6720cb-e052-4dc7-ad35-a9b400d59ba8"}]},{"id":"b72f96f4-df98-4fdc-9a6f-e7bc866a64f5","name":"characteristics_domestic_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"96418067-c187-499f-ab98-59ee230d3a59","colid":"746d3d46-0035-43e4-8e58-7b100642ec7d"}]},{"id":"a4d03f50-050b-4e40-b450-19cba2243878","name":"characteristics_civilian_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"55676a50-c4f3-48f4-ad91-49d87f7f2515","colid":"28c21c54-c6e9-4c34-b369-a5b2c741206c"}]},{"id":"61aff84f-a009-4de1-bcb1-bbde39ed14da","name":"characteristics_independent_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"551a0868-9255-480b-a9c9-d73d03a2cfea","colid":"14512abe-11e2-4999-8897-c11e505ec0fa"}]},{"id":"2e37b822-a22a-4ee1-b038-f48dbb0b2055","name":"characteristics_pursuits_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"bda3de20-c73d-46a8-8028-0215849a8556","colid":"15e2748b-766a-47f3-9d7a-d6377e634aaa"}]},{"id":"64ba6297-9291-42a2-aa27-51508878f708","name":"characteristics_minimum_edu_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"283969ae-61dd-4d87-96b2-956e75dd6d29","colid":"7a3b9238-4f4e-4e27-8456-a52a33695a05"}]}],"gHeight":826,"gWidth":419,"color":"#ffffff","background":"#607d8b","resized":false,"embeddable":false,"freezeTableName":true,"timestamps":true,"tabletype":"InnoDB","paranoid":true,"version":false,"collation":"utf8_unicode_ci","charset":"utf8mb4","underscored":true,"singular":"characteristic","plural":"characteristics","tablename":"characteristics"},"e5aaea69-c11d-4b60-aa51-1a1af25a4915":{"id":"e5aaea69-c11d-4b60-aa51-1a1af25a4915","visible":true,"name":"Crimes","x":65,"y":168,"desc":"Crime Measures","cols":[{"id":"68d21ce0-7244-41ff-be3a-bb2eab761971","name":"id","datatype":"INTEGER","param":"15","pk":true,"nn":true,"comment":"","defaultValue":"","data":"","unsigned":true,"autoinc":true},{"id":"625eb932-cf07-4c5e-aeac-bc276468f14b","name":"agency_id","datatype":"INTEGER","param":"15","pk":false,"nn":true,"comment":"","defaultValue":"","data":"","fk":true,"ref":"Agency","unsigned":true},{"id":"a11f4486-11b2-4ab9-9459-3b98ebe0025c","name":"source_year","datatype":"INTEGER","param":"4","pk":false,"nn":true,"comment":"XWK_6 - Year of merged data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"79620218-454a-4f08-9f8e-02a192a7fbea","name":"source_name","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_7 - Data Source Name","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ed22679e-9081-4999-bfc4-9a71b064d6c3","name":"population","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_1 Total Population, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"9f3d6d57-69b1-42c2-84f1-6ae482bb7073","name":"annual_offenses","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_2 Annual Total of All Actual Offenses, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"80c076ef-e640-450e-96b6-adf3d005fd18","name":"annual_crime_rate","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"UCR_3 Annual Crime Rate, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"3fed2818-48b1-43fe-a246-625e9fa6717e","name":"annual_violent_crimes","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_4 Annual Total of Violent Crimes, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"226713bc-acaf-4b0a-9859-70b84e32b45e","name":"annual_violent_crime_rate","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"UCR_5 Annual Violent Crime Rate, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"9ce9650c-e03a-42f0-bbfe-1ced67ddb0c2","name":"annual_homicides","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_6 Annual Total of Homicides, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"b83ab8dd-4849-41e7-a954-a54b3e6fd847","name":"annual_homicide_rate","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"UCR_7 Annual Homicide Rate, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f1bded71-a069-4554-b62a-3d943171bf4c","name":"annual_officers_killed","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_8 Annual Number of Officers Killed by Felonious Acts, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"1c615d35-f8c1-49cd-be4a-a5a257c6a369","name":"annual_officers_killed_accident","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_9 Annual Number of Officers Killed by Accidental or Negligent Acts, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"dc7f9939-6e09-48e3-940f-22cab6c4c21b","name":"annual_officers_assaulted","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_10 Annual Number of Officers Assaulted, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"7e0c51a2-52e0-4195-b591-ea6a89667a7a","name":"annual_property_crimes","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_11 Annual Total of Property Crimes, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"62b19f65-8990-40db-8afb-356094f7e272","name":"annual_property_crime_rate","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"UCR_12 Annual Property Crime Rate, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"9b712717-db14-4c91-a98f-976de8bd9b3c","name":"month_last_reported","datatype":"INTEGER","param":"2","pk":false,"nn":false,"comment":"UCR_13 Month Last Reported, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"82a84e92-146e-4dd2-a4b2-c3184ee38cb5","name":"month_january","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_14 January: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"eddb8add-1d37-42d5-85b3-e6052c1e1eed","name":"month_february","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_15 February: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"16ab6e10-eac4-4dee-a949-136541b2276d","name":"month_march","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_16 March: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"d8b81f60-47ea-4170-9674-543bbc1a3b38","name":"month_april","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_17 April: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"3c078d95-b9d3-473d-a121-e610d13c3996","name":"month_may","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_18 May: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"6e4aac16-ddec-4d91-8e6b-d7ac46c6d715","name":"month_june","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_19 June: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"40f96be1-859c-4e0d-9f04-5f5a4d0a4e0b","name":"month_july","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_20 July: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"c256ce04-7f02-48aa-b4e7-e70c1479ab74","name":"month_august","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_21 August: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"27ef758b-b1a2-4854-a728-02d5775efd86","name":"month_september","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_22 September: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"b616b55d-9ead-4ed4-a026-d184d1a5a653","name":"month_october","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_23 October: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"b3ca8a93-2a7f-492a-a962-0f35e3f641d5","name":"month_november","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_24 November: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"57e041e2-13bf-4769-9ca9-78e36d12d1b9","name":"month_december","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_25 December: Month Included In, UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ee6b636e-6617-4622-a755-8c432985d9cf","name":"non_missing","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"UCR_26 Count of nonmissing UCR","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false}],"relations":["912cee0d-1e4b-4d50-9c0b-ae9403ea68b6"],"lines":[],"keys":[{"id":"c9fb6f5e-c224-4428-b4dc-e68d372ba3e3","name":"Primary key","isPk":true,"using":"na","cols":[{"id":"0df57886-6924-4f2f-9d46-b793948cb76c","colid":"68d21ce0-7244-41ff-be3a-bb2eab761971"}]}],"indexes":[{"id":"b42a9c9a-5eb7-4b97-b55b-8610fefbb21c","name":"crimes_agency_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"51a53ded-101e-4b3b-9030-151319efcb07","colid":"625eb932-cf07-4c5e-aeac-bc276468f14b"},{"id":"696e0ea7-b514-4e30-af5b-1643e3617cf3","colid":"a11f4486-11b2-4ab9-9459-3b98ebe0025c"}]},{"id":"f76b9d9f-ce15-43d6-b5e0-3b9002676a4a","name":"crimes_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"e8ea68c9-5802-4da4-b85e-d117b279bb18","colid":"a11f4486-11b2-4ab9-9459-3b98ebe0025c"}]}],"gHeight":574,"gWidth":317,"color":"#ffffff","background":"#607d8b","resized":false,"embeddable":false,"freezeTableName":true,"timestamps":true,"tabletype":"InnoDB","paranoid":true,"version":false,"collation":"utf8_unicode_ci","charset":"utf8mb4","underscored":true,"singular":"crime","plural":"crimes","tablename":"crimes"},"cf0ffe2e-ab7f-44b6-9047-8d10bdf046ec":{"id":"cf0ffe2e-ab7f-44b6-9047-8d10bdf046ec","visible":true,"name":"Gunshots","x":409,"y":168,"desc":"Gunshot Measures","cols":[{"id":"b46a9afa-745a-4cb5-b387-77f8903b67c6","name":"id","datatype":"INTEGER","param":"15","pk":true,"nn":true,"comment":"","defaultValue":"","data":"","autoinc":true,"unsigned":true},{"id":"896b428c-ed04-4846-8b3e-37de74b18aae","name":"agency_id","datatype":"INTEGER","param":"15","pk":false,"nn":true,"comment":"","defaultValue":"","data":"","fk":true,"ref":"Agency","unsigned":true},{"id":"45a2b6f7-56bb-4f63-aad1-d5d17d5f3abc","name":"source_year","datatype":"INTEGER","param":"4","pk":false,"nn":true,"comment":"XWK_6 - Year of merged data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"04f199cb-931d-40d1-979b-c7407bc8ef40","name":"source_name","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_7 - Data Source Name","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"2fe0f3f3-8981-482c-a488-6449d0822014","name":"shots_fired","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"VIC_3 Total Number of Shots Fired Count, Vice","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"94cd0aae-6aa4-4984-b78a-4a9db83284a1","name":"fatal_shootings","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"VIC_4 Fatal Shootings Count, Vice","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"a0885fe1-bfe7-4f2d-a015-10568f764e95","name":"possible_fatal_shootings","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"VIC_5 Unknown if Fatal Shootings Count, Vice","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"29dd11b9-82cb-46a1-9f8c-282d4e725d9e","name":"non_fatal_shootings","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"VIC_6 Nonfatal Shootings Count, Vice","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"7a2ea06d-8527-4e8c-8cb3-7d099814a7c3","name":"unarmed_shootings","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"VIC_7 Subject Unarmed Shootings Count, Vice","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"27ed061e-74a0-4756-92b1-273b911c093a","name":"possible_armed_shootings","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"VIC_8 Unknown if Subject Armed Shootings Count, Vice","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"93e5d1ca-271b-4010-b4a7-8a163047d28e","name":"armed_shootings","datatype":"INTEGER","param":"9","pk":false,"nn":false,"comment":"VIC_9 Subject Armed Shootings Count, Vice","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false}],"relations":["708fb2b6-b68c-4305-b475-ecbea3b34ed7"],"lines":[],"keys":[{"id":"ade49e99-e33c-43bc-8235-37858e67f6dd","name":"Primary key","isPk":true,"using":"na","cols":[{"id":"2a1ed58f-5928-4084-9ed9-c9fba4faf36e","colid":"b46a9afa-745a-4cb5-b387-77f8903b67c6"}]}],"indexes":[{"id":"87989093-dfd9-4f12-bc99-9859b32357b4","name":"gunshots_agency_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"78f4f611-af42-472d-8fb5-b191ed4ca6f4","colid":"896b428c-ed04-4846-8b3e-37de74b18aae"},{"id":"7b4139a1-ed71-447f-85ef-8037e38f570a","colid":"45a2b6f7-56bb-4f63-aad1-d5d17d5f3abc"}]},{"id":"0db0ee4a-8e6c-4c10-b66c-0b9cd267ae16","name":"gunshots_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"1e30a9ec-33e1-4d09-adcf-adab2855e60b","colid":"45a2b6f7-56bb-4f63-aad1-d5d17d5f3abc"}]}],"gHeight":232,"gWidth":317,"color":"#ffffff","background":"#607d8b","resized":false,"embeddable":false,"freezeTableName":true,"timestamps":true,"tabletype":"InnoDB","paranoid":true,"version":false,"collation":"utf8_unicode_ci","charset":"utf8mb4","singular":"gunshot","plural":"gunshots","tablename":"gunshots","underscored":true},"9599a46d-9bd5-48bd-94bf-bf7ebfa371e0":{"id":"9599a46d-9bd5-48bd-94bf-bf7ebfa371e0","visible":true,"name":"Demographics","x":65,"y":756,"desc":"Socio-Demographic Measures","cols":[{"id":"6bd0be33-0f55-4af8-a02b-4523ba5205e9","name":"id","datatype":"INTEGER","param":"15","pk":true,"nn":true,"comment":"","defaultValue":"","data":"","autoinc":true,"unsigned":true},{"id":"b5043494-388b-4528-b362-411606ac3f76","name":"agency_id","datatype":"INTEGER","param":"15","pk":false,"nn":true,"comment":"","defaultValue":"","data":"","fk":true,"ref":"Agency","unsigned":true},{"id":"0c69ac29-0787-4bc5-bef0-336005fab8d0","name":"source_year","datatype":"INTEGER","param":"4","pk":false,"nn":true,"comment":"XWK_6 - Year of merged data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ca5a4b99-4f2f-4a16-8e7d-6cfcefb59f82","name":"source_name","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_7 - Data Source Name","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f8e0c65a-13cc-402a-b22e-0128fa5dfe65","name":"is_normalized_place","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"CEN_1-26 Normalized Place Indicator","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"c5a45c35-30ea-40a0-b10d-f6aea2ff9798","name":"is_place","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"CEN_1-26 Place Indicator","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"27153555-90ec-4204-a515-350dfc08aaf8","name":"is_county","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"CEN_1-26 County Indicator","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"73697c38-bd11-4a6b-9cbe-8dac4abebb1c","name":"is_geo","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"CEN_1-26 Lowest Geographic Unit Indicator","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ba1bf0f4-19db-45c1-a07a-56de6c997bb2","name":"population","datatype":"INTEGER","param":"11","pk":false,"nn":false,"comment":"CEN_4 Place Population, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ece52749-337e-4d24-9c4a-6e08a704b5cc","name":"proportion_white","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_1 Proportion Non-Hispanic White, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"8dde259b-1969-45db-9b53-ec9f4b1c7f44","name":"proportion_black","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_2 Proportion Non-Hispanic Black, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"25205fac-ca4f-4729-8c4c-25be828875d3","name":"proportion_hispanic","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_3 Proportion Hispanic, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"3d32eebc-cb3d-4a8c-a569-5a3853589ebd","name":"proportion_minor","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_5 Proportion Age Less Than 18, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"d531c14d-4ba6-4349-9278-6389cf2ee707","name":"proportion_owner_occupied","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_6 Proportion Owner-Occupied Households, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"de06d538-af42-40d7-be40-804c5387711c","name":"proportion_foreign_born","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_7 Proportion Foreign-Born, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"d3c7f55c-3d52-419e-bd95-19e2bd7246c2","name":"proportion_unemployed","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_8 Proportion Unemployed, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"6ab982f0-355b-4f53-a56a-ae487622e408","name":"proportion_below_poverty","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_9 Proportion Below Poverty Line, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"1b5da63d-7669-4432-8daf-2856013b5a43","name":"proportion_receiving_welfare","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_10 Proportion Receiving Welfare, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"0607191e-5356-4752-b3c2-e3b519d92331","name":"proportion_head_by_women","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_11 Proportion of Families and Subfamilies Headed By Women w/ Children","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f39632c5-12a7-4e38-9469-51b8154219c5","name":"proportion_less_highschool","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_12 Proportion Age 25+ w/Less Than HS Degree, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"5c0a0e96-1fe2-40dd-8b9c-bb72012224a6","name":"proportion_highschool","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_13 Proportion Age 25+ w/HS Degree, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"f0212003-df1f-48a5-9f58-73db478c5b8a","name":"proportion_some_college","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_14 Proportion Age 25+ w/Some College, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"394da790-70b4-4d2b-ae12-c17f4783a75d","name":"proportion_college","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_15 Proportion Age 25+ w/College Degree, Census","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"1f86ce95-8d50-4481-ba58-f4506a726cd2","name":"rank_order_income_segregation","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_16 Rank Order Family Income Segregation","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"2281aad0-c719-4c7c-b738-e036d1bbd683","name":"index_dissimilarity_white_asian","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_23 Dissimilarity Index, White-Asian","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"b06155eb-aea0-47f0-a8d4-c8302472cda2","name":"index_dissimilarity_white_black","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_17 Dissimilarity Index, White-Black","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"2cebb563-1b7e-49c9-ad5b-3f13f4c958fc","name":"index_dissimilarity_white_hispanic","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_20 Dissimilarity Index, White-Hispanic","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"9bc8d2a8-350b-4d61-9c3f-d87a6f32441e","name":"index_info_theory_white_asian","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_25 Information Theory Index, White- Asian","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"4f2bd2ec-5554-4a2f-a06c-5758c2f2aba5","name":"index_info_theory_white_black","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_19 Information Theory Index, White-Black","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"620180e4-9b32-46ca-81af-c3873dc50cae","name":"index_info_theory_white_hispanic","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_22 Information Theory Index-White-Hispanic","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"71be5f9a-74bd-4ac4-832a-a3f02638738a","name":"index_isolation_white_asian","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_24 Isolation Index, White-Asian","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"ba5e33e8-d5eb-4d6c-8746-7ba0d6eeb89a","name":"index_isolation_white_black","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_18 Isolation Index, White-Black","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"0280e323-f0da-491b-baa2-54ad9a2ad364","name":"index_isolation_white_hispanic","datatype":"FLOAT","param":"9","pk":false,"nn":false,"comment":"CEN_21 Isolation Index, White-Hispanic","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"71491981-8bf0-4b5e-a51f-baf050c5cfe1","name":"geographic_level","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"CEN_26 Flag, Geographic Level","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false}],"relations":["a2fc7141-80d4-4ff6-b589-934daec67721"],"lines":[],"keys":[{"id":"a1fa59d6-f929-4bcb-bdd6-7b2d6d72c948","name":"Primary key","isPk":true,"using":"na","cols":[{"id":"6a7fdc02-db9e-4683-bc13-52999bdec051","colid":"6bd0be33-0f55-4af8-a02b-4523ba5205e9"}]}],"indexes":[{"id":"783fe919-e267-4f35-a35e-b3c8f345121c","name":"demographics_agency_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"d6767d6b-83e2-477c-a18e-94740703be48","colid":"b5043494-388b-4528-b362-411606ac3f76"},{"id":"170eb48f-2906-4f5f-b6d6-2ce4ad7a44cb","colid":"0c69ac29-0787-4bc5-bef0-336005fab8d0"}]},{"id":"66e5402f-23ce-4021-8c25-c53132682725","name":"demographics_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"21c08ae5-f4dc-4730-a61a-d2d34d9745a0","colid":"0c69ac29-0787-4bc5-bef0-336005fab8d0"}]},{"id":"4a1700ca-1cac-41a7-9580-e6219e0af2e4","name":"demographics_normalized_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"9b2e2701-3606-4b0d-885b-d40495f72ba2","colid":"f8e0c65a-13cc-402a-b22e-0128fa5dfe65"}]},{"id":"fd8b2a40-81d8-4c6b-b353-1296039bc595","name":"demographics_place_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"9f00e85d-69d8-4be8-8350-aae1a1b42155","colid":"c5a45c35-30ea-40a0-b10d-f6aea2ff9798"}]},{"id":"1bd16df9-ab1f-4e97-bbc2-b994087c39bd","name":"demographics_county_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"8df06183-05d8-4fba-abaa-3e8e4cb1d084","colid":"27153555-90ec-4204-a515-350dfc08aaf8"}]},{"id":"da4e059d-02e1-47a9-8679-bcaf2ea89dec","name":"demographics_geo_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"0b295814-1614-4b64-a00e-b1733922f863","colid":"73697c38-bd11-4a6b-9cbe-8dac4abebb1c"}]}],"gHeight":646,"gWidth":317,"color":"#ffffff","background":"#607d8b","resized":false,"embeddable":false,"freezeTableName":true,"timestamps":true,"tabletype":"InnoDB","paranoid":true,"version":false,"collation":"utf8_unicode_ci","charset":"utf8mb4","underscored":true,"singular":"demographic","plural":"demographics","tablename":"demographics"},"aef9d977-e737-4ba0-a720-d4d9a3feb25f":{"id":"aef9d977-e737-4ba0-a720-d4d9a3feb25f","visible":true,"name":"FirearmLaws","x":753,"y":1100,"desc":"Constructed Contextual Firearm Measures","cols":[{"id":"846a72bb-0a0c-46eb-b567-352485b84d96","name":"id","datatype":"INTEGER","param":"15","pk":true,"nn":true,"comment":"","defaultValue":"","data":"","autoinc":true,"unsigned":true},{"id":"e04c7aaf-4fbd-4a18-b982-3cf9bfac4dc7","name":"agency_id","datatype":"INTEGER","param":"15","pk":false,"nn":true,"comment":"","defaultValue":"","data":"","fk":true,"ref":"Agency","unsigned":true},{"id":"25006ab5-0c61-491b-b43c-92e11bfc78b1","name":"source_year","datatype":"INTEGER","param":"4","pk":false,"nn":true,"comment":"XWK_6 - Year of merged data","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"d6cf6a98-5bdf-4ab4-9d97-5a0abcc3a16a","name":"source_name","datatype":"STRING","param":"100","pk":false,"nn":false,"comment":"XWK_7 - Data Source Name","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"bdd4ae70-cd87-4e12-9fab-1147d6684da8","name":"state_firearm","datatype":"STRING","param":"50","pk":false,"nn":false,"comment":"SIE_1 - State, Siegel Firearm","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"49188858-2534-4559-97d1-b61d8001dbc0","name":"state_gun_ownership","datatype":"STRING","param":"50","pk":false,"nn":false,"comment":"SIE_7 - State, Siegel Gun Ownership","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"640b9900-b4a4-46df-874e-1c5636c9f85b","name":"violent_misdemeanor","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"SIE_2 - Firearm Law-Violent Misdemeanor, Siegel Firearm","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"59252fb8-6423-42d7-a90e-c6669404071c","name":"universal_background_check","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"SIE_3 - Firearm Law-Universal Background Check, Siegel Firearm","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"d6593e91-73c0-410c-b63d-22cd9c28dcac","name":"may_issue","datatype":"BOOLEAN","param":0,"pk":false,"nn":false,"comment":"SIE_4 - Firearm Law-May Issue, Siegel Firearm","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"c10d21d9-871e-4410-82b5-e883c2cf99ae","name":"count_of_three_laws","datatype":"INTEGER","param":"1","pk":false,"nn":false,"comment":"SIE_5 - Firearm Law-Count of Three Laws, Siegel Firearm","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"fecd356f-67e9-4c2a-9537-aff4b5d9a4bf","name":"count_of_three_laws_weighted","datatype":"FLOAT","param":"4","pk":false,"nn":false,"comment":"SIE_6 - Firearm Law-Weighted Count of Three Laws, Siegel Firearm","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"100641a3-2e29-4fb6-9e94-98abb4b20e02","name":"gun_ownership_proxy_original","datatype":"FLOAT","param":"3","pk":false,"nn":false,"comment":"SIE_8 - Gun Ownership Proxy, Original, Siegel Gun Ownership","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false},{"id":"32b0c856-4e9f-46b0-89e5-0d0543e9efe8","name":"gun_ownership_proxy_improved","datatype":"FLOAT","param":"3","pk":false,"nn":false,"comment":"SIE_9 - Gun Ownership Proxy, Improved, Siegel Gun Ownership","defaultValue":"","data":"","enumrange":"","unique":false,"uniqueName":"","autoinc":false,"collation":null,"charset":null,"binary":false,"zerofill":false,"unsigned":false}],"relations":["e0f62c0b-d054-4069-ba29-a11577b6005a"],"lines":[],"keys":[{"id":"dedd485a-9ffc-42ff-a8fb-0127c6e8478d","name":"Primary key","isPk":true,"using":"na","cols":[{"id":"f6d21601-df9f-4e27-a2d4-6eda8ec695ea","colid":"846a72bb-0a0c-46eb-b567-352485b84d96"}]}],"indexes":[{"id":"119d8be5-87be-4865-b0bc-bf35e8ab6ea9","name":"firearm_laws_agency_year_ix","unique":false,"fulltext":false,"using":"na","algorithm":"na","lockoption":"na","cols":[{"id":"323c1a69-f1d6-4345-94c0-5c108bb323ea","colid":"e04c7aaf-4fbd-4a18-b982-3cf9bfac4dc7"},{"id":"5551a8cb-86da-478a-8851-d2c9ad81d8a6","colid":"25006ab5-0c61-491b-b43c-92e11bfc78b1"}]},{"id":"ff802012-c709-46d1-b29d-2107afe06c68","name":"firearm_laws_year_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"93fb5354-b286-4c63-bc11-f570e5a314ef","colid":"25006ab5-0c61-491b-b43c-92e11bfc78b1"}]},{"id":"3f738e47-1dcb-4014-ba0d-9aaac91b2614","name":"firearm_laws_violent_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"c288c0ca-5f63-4393-9272-8895a4315be9","colid":"640b9900-b4a4-46df-874e-1c5636c9f85b"}]},{"id":"a29f1c82-4418-4dbb-847a-a7319014bc42","name":"firearm_laws_universal_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"7844b9fa-9f3b-41cb-b9ea-daf809a33908","colid":"59252fb8-6423-42d7-a90e-c6669404071c"}]},{"id":"51b240cd-2e4a-4ec9-83f2-665107456754","name":"firearm_laws_issue_ix","unique":false,"fulltext":false,"using":"BTREE","algorithm":"na","lockoption":"na","cols":[{"id":"a4b065b6-4057-4ef5-8958-9c54746342e3","colid":"d6593e91-73c0-410c-b63d-22cd9c28dcac"}]}],"gHeight":268,"gWidth":308,"color":"#ffffff","background":"#607d8b","resized":true,"embeddable":false,"freezeTableName":true,"timestamps":true,"tabletype":"InnoDB","paranoid":true,"version":false,"collation":"utf8_unicode_ci","charset":"utf8mb4","underscored":true,"singular":"firearm_law","plural":"firearm_laws","tablename":"firearm_laws"}},"relations":{"6c81c7e5-2580-4cb4-b8f7-fff7d8b0f6ec":{"id":"6c81c7e5-2580-4cb4-b8f7-fff7d8b0f6ec","visible":true,"name":"Agency-Deaths","desc":"","type":"identifying","parent_key":"8d368d9f-d439-4af9-9e33-b8bedfdd31f0","parent":"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be","child":"dc5e34d6-6a8b-4e88-ad4a-2c21be29f5f2","c_mp":"true","c_mch":"true","cols":[{"id":"413b2e2f-300e-49d9-95be-4343a3fa5c3e","parentcol":"711dab1c-6908-4c0e-bce3-da1db5da70e4","childcol":"71baff03-7b1d-4817-ab69-e11968a6e5bb"}],"orm_association_belongs":"na","orm_through_belongs":"","orm_alias_belongs":"","orm_constraints_belongs":"","orm_association_has":"hasOne","orm_through_has":"","orm_alias_has":"","orm_constraints_has":""},"6141d52c-b324-4299-bbba-9b44150c5127":{"id":"6141d52c-b324-4299-bbba-9b44150c5127","visible":true,"name":"Agency-AnnualOfficerDeaths","desc":"","type":"identifying","parent_key":"8d368d9f-d439-4af9-9e33-b8bedfdd31f0","parent":"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be","child":"c55167f3-96f0-4535-a58a-4e8eaf737d03","c_mp":"true","c_mch":"true","cols":[{"id":"4e1e04cd-df7f-44a9-83be-b5fc041f8ff2","parentcol":"711dab1c-6908-4c0e-bce3-da1db5da70e4","childcol":"0aeb67b9-9504-4f2b-baaa-9dfc42c492f7"}],"orm_association_belongs":"na","orm_through_belongs":"","orm_alias_belongs":"","orm_constraints_belongs":"","orm_association_has":"hasOne","orm_through_has":"","orm_alias_has":"","orm_constraints_has":""},"eb7776db-0752-41f3-a2fc-062e770e2201":{"id":"eb7776db-0752-41f3-a2fc-062e770e2201","visible":true,"name":"Agency-Characteristics","desc":"","type":"identifying","parent_key":"8d368d9f-d439-4af9-9e33-b8bedfdd31f0","parent":"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be","child":"e371513c-cc89-42e9-9756-8a39b1f1a764","c_mp":"true","c_mch":"true","cols":[{"id":"8dcbf9b4-1063-45ae-a730-026755152595","parentcol":"711dab1c-6908-4c0e-bce3-da1db5da70e4","childcol":"150aa1f0-5faa-4279-9dfe-5dd697af580d"}],"orm_association_belongs":"na","orm_through_belongs":"","orm_alias_belongs":"","orm_constraints_belongs":"","orm_association_has":"hasOne","orm_through_has":"","orm_alias_has":"","orm_constraints_has":""},"912cee0d-1e4b-4d50-9c0b-ae9403ea68b6":{"id":"912cee0d-1e4b-4d50-9c0b-ae9403ea68b6","visible":true,"name":"Agency-Crimes","desc":"","type":"identifying","parent_key":"8d368d9f-d439-4af9-9e33-b8bedfdd31f0","parent":"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be","child":"e5aaea69-c11d-4b60-aa51-1a1af25a4915","c_mp":"true","c_mch":"true","cols":[{"id":"8f79c8bd-fb45-4238-8823-a46ffdc09157","parentcol":"711dab1c-6908-4c0e-bce3-da1db5da70e4","childcol":"625eb932-cf07-4c5e-aeac-bc276468f14b"}],"orm_association_belongs":"na","orm_through_belongs":"","orm_alias_belongs":"","orm_constraints_belongs":"","orm_association_has":"hasOne","orm_through_has":"","orm_alias_has":"","orm_constraints_has":""},"708fb2b6-b68c-4305-b475-ecbea3b34ed7":{"id":"708fb2b6-b68c-4305-b475-ecbea3b34ed7","visible":true,"name":"Agency-Gunshots","desc":"","type":"identifying","parent_key":"8d368d9f-d439-4af9-9e33-b8bedfdd31f0","parent":"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be","child":"cf0ffe2e-ab7f-44b6-9047-8d10bdf046ec","c_mp":"true","c_mch":"true","cols":[{"id":"99d1d53e-2b84-4aa8-9e62-2fefc990f9f7","parentcol":"711dab1c-6908-4c0e-bce3-da1db5da70e4","childcol":"896b428c-ed04-4846-8b3e-37de74b18aae"}],"orm_association_belongs":"na","orm_through_belongs":"","orm_alias_belongs":"","orm_constraints_belongs":"","orm_association_has":"hasOne","orm_through_has":"","orm_alias_has":"","orm_constraints_has":""},"a2fc7141-80d4-4ff6-b589-934daec67721":{"id":"a2fc7141-80d4-4ff6-b589-934daec67721","visible":true,"name":"Agency-Demographics","desc":"","type":"identifying","parent_key":"8d368d9f-d439-4af9-9e33-b8bedfdd31f0","parent":"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be","child":"9599a46d-9bd5-48bd-94bf-bf7ebfa371e0","c_mp":"true","c_mch":"true","cols":[{"id":"101e8433-bbb9-45bb-8762-387db1336604","parentcol":"711dab1c-6908-4c0e-bce3-da1db5da70e4","childcol":"b5043494-388b-4528-b362-411606ac3f76"}],"orm_association_belongs":"na","orm_through_belongs":"","orm_alias_belongs":"","orm_constraints_belongs":"","orm_association_has":"hasOne","orm_through_has":"","orm_alias_has":"","orm_constraints_has":""},"e0f62c0b-d054-4069-ba29-a11577b6005a":{"id":"e0f62c0b-d054-4069-ba29-a11577b6005a","visible":true,"name":"Agency-FirearmLaws","desc":"","type":"identifying","parent_key":"8d368d9f-d439-4af9-9e33-b8bedfdd31f0","parent":"cb8ddaf4-0d7c-43b2-992a-1a1e2ad974be","child":"aef9d977-e737-4ba0-a720-d4d9a3feb25f","c_mp":"true","c_mch":"true","cols":[{"id":"5a739640-d028-42c9-b6c6-59a48ed492c9","parentcol":"711dab1c-6908-4c0e-bce3-da1db5da70e4","childcol":"e04c7aaf-4fbd-4a18-b982-3cf9bfac4dc7"}],"orm_association_belongs":"na","orm_through_belongs":"","orm_alias_belongs":"","orm_constraints_belongs":"","orm_association_has":"hasOne","orm_through_has":"","orm_alias_has":"","orm_constraints_has":""}},"notes":{"91a6b76e-f5d0-4efa-9fec-801960b9acf1":{"id":"91a6b76e-f5d0-4efa-9fec-801960b9acf1","visible":true,"name":"Logo","x":45,"y":30,"desc":"<p><img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgAAAAIACAYAAAD0eNT6AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAJR9JREFUeNrs3U+MXdWdJ/BLACfd2DOV0CCcaLofGkEWMcKGRU2ygPKmZ0FaMZpFUEsdyhIKEpvYm7CKsMWqZ2OzQaqRJYoZKQ2LCEcJi2ZDmcUQLwyFqFm0rShvEoER4E5NjDuOEel5v1f3QWHsqvveu/e+e+/5fKSn4o9ddp133+98z7nnnJtlAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACQohs0AaRnfmmtN/hyLP/Xw6cf39PXKpCWL2kCSK7zPzT48ubgdSB/vZn/N8AMANDBjn/v4Mtzg9fe6/yS1cHr4OnH96xqLRAAgPZ3/HODL08NXkVH+ccHr6ODILCu9UAAANrZ+S9mG/f658b8rdH5x9qAZa0IAgDQno5/IR/1L0z5rVby2YAVrQoCANDcjr+Xd/yLJX/r5TwI9LUyCABAczr+ce/zT8r6ABAAgIZ0/NHp/ygb/z7/pKLzfybCgCAAAgDQ/Y5fEAABgBZ2GLES/C2runX8ggBbXF+Lgy/3Dt7Hw1pDAKAbH+o4/GUx/9d+XqyXFWsdvyBAfm0t5tdWL//PUR8Oah0BgHZ/uKPTOLZFsV62srvR718vL8yLDe74r3VtLcf15dpq/LW1uEWojHMgjmspAYB2fsDjw/1cgV8axfp5e70b9d4tDL48mpW/na9urq12X1sH3TYUAGjfhzzOe391zFHjaj4rcNIU7kzes3ivDuQjsr0d+/FcW+28tuK92u/5EAIA3e78r/7Qn8w2pnB98Ot5v36UF+i5jv+4rq32XVtCgABAi5L+qyWOIPubRm59LVza+9TLi/KjHRztjzMr8Lxrq7Jra/OivjLeq/1mbwQAmv3hf7PCDsU07vThLArz9/KvfCZmBX7u2pr62qry9tHq4L3Zp7UFAJpZBDZv96vayqaCbfSm0xcGZjfSj2troaY/1vZAAYAGFoPY6ndoRn/86igQWO396X3XKMgpT++XeW3FbYIV96A/XcE/6vBndW3FsyCOuDQFAJpRFGLU/1xD/jrreRg4lUrRzkdiUZAfzNJYyDfLa+vkpmurn1CYfDD/2pRry/ZAAYCGjAhebXjRjkDwVv51te3TunmbR2G+Ny/KPVfiTPQ3XVurbZ99ym8XjTr8exvW4V/LfjN+AgCzHR1Ms91vloV7dVMo6DdxNLepII86+9FIn+Zaya+vt/JrrJGBM5816m3q7Pe2MEjaHigAMMPO6c2OjT5X86JyalMxz6os4nmImsvbMV5/k3/dm5nK74r1/NqKYPB/86/xWq+q89oUHrNNofHB/Jrq0rqQaMd9FmsKANTb+Ze5179tI7yri/tbW/z6/3iNdtK5c72QcHUg/X9b/J57r3EdLSTYds4IaKmbNEErPZelu7r8WgXW9jqmNXeNa2tBsxSyN69JD2uKdvmSJmjd6P85HR7QMAfy2oQAQEWd/2LW/qfDAd20mNcoWsIagHZ1/hI20HTOCBAAKLHzb+t2PyA9tgcKAJTU+feyje1+On+gTSFgn+eENJs1AM3u/KPTf0nnD7TMsHblNQwBgAmkutcfaL/RrUsEAMYc/ae81x/oSAiwPVAAYLzO/0hmux/QDYt5TaNhLAJsXucfHb/EDHSN7YECAFt0/guZe2ZAd3mEsADANTp/e/2BrnNGgADAVZ1/Fx/tC3At/cwjhBvBIsBmdP6v6vyBRESte9UZAQIAaT/aF0jT6BHCCADJjv492hdIlUcICwDJdv6Lmb3+QNo8QniGLAKcXecv+QJscEaAAJBE52+7H8Dn2R4oAHS+8+9lHu0LcL0Q4BHCNbIGoL7O36N9Aa7PI4QFgM7yaF+ArXmEsADQudG/vf4ABUOA7YECQFc6/yOZ7X4A4/AI4RpYBFht5x8dvyQLMBnbAwWAVnb+C5l7WQDT8ghhAaBVnb+9/gDlcEaAANCazt+jfQHK1c88Qrh0FgGW3/l7tC9AuaKmeoSwANBotvsBVMMjhAWAxo7+PdoXoFoeISwANK7zX8zs9Qeog0cIl8QiwHI6f4kUoF7OCBAAZtr52+4HMBu2BwoAM+v8e5lH+wLMOgR4hPCErAGYrPP3aF+A2fMIYQGgdh7tC9AMHiEsANQ2+u9lDvoBaJJeXpsZgzUAk4UAi/8SdPetX8l2fvnGbPfOm7Pdu3Z8+t/PXfhjdvHKn7PzF68MXh9rqBm47+u3fPYe7bhx+M8fXfkkO3vhsvel+ywGFACEgCYV4/t23zLV93jj/KXh11kW7+hMHuj9h8HP85eFf55Rp/Na/2J2qv+Hyv7uD90997kQci0nzrxfafs8dv/tW/7/eO9ePlvN0e0P9nYN35t4j+4avIq8L2+8+2/D9yTem4uDf5/E7l03D9r+q7Vcf1W2n84fAUAIqKxjeOz+20r9nhEIooC/fPb3lQaCXYPR4wODziV+hij2Zfy9X/6X9dIL+bN/19s2lPyX//F/Kn2ff/XDb237sz/xi35pf168H4/suTV76Jtzn47yJxFh4IW3/zV78e0LYweBCLfPfrdXy+eo7PbT+XO1mzTB5OLCG4SA/dnGdkCqnFXYvTGrEMEiCuPx//3ecKRd9qj68HfumKpzud7f+5F7bs2Ovf7eIMRc8mZOEMq+P2i/skJlvL/xvR6552vZscF1ZJTdWjr/KVkEWEIIGHw5qCXqDQP/87/9522noMcZWcaI+icL3yi1898spqlj5Hj423cMOzSKj7g33uvbSv/e8V7Hex4vWuegzl8AaEoIWBYC6hedwrTFO+4h/69BBzPtmoWiYiQbYUMI2F7MmkRoKuNWzFZi5kcIaF3nv6wZBAAhIHFRvOM16e+N0eXOmjvjmA146e/vGoYPri065EPfvqO2Py8WFVYdNND5CwDdDwEuzprFfftxR9TR+cbvm5UIHf/4t39tJuA6I/9JQ90kzl24nD3803O2Cjbfss6/XBYBlh8CDs4vrcU/LmqNrYvu9VZgjzsdvzNfJFZ021t0ujENP+7If7TFL3YjfP77fSm766++MvbfO0ac//hf/5OV3leNxCcZ+Y92iVzdvvGebDWyjwWAsaB00m2B1Nr5m2EVANoxKM02jqd0XPB1bLciftzteDFiLBoAotMdp/OPziW2jJ3qX9w2WIy7hXBjZ8Ptle/Zb4Nd+aK8omLEHu223b7+mO2JNo73ZrPjg2vwhcH7WrYIFWXMJsQ5AAyt5jUVAaAVswDr+fbA32TOCJhIFPQopPGKTmG7KeHocOO1XeGNEWbRkXp8r6dPvVN4697mv/Mj+ba1IkEjfl3V5xu0waExtmCOM3KPWZsfv/Lb4Xs/ChhPr7yzbaCbJgDY7lma0V5/ezUrYA1AhSEgLlwtMb0o9EU6x+1Oxht2Mt/eXejPjFsUP/jZrycu5DGyjKn9jwpOLZe1pbGtNk7YK5aVo/OO17jT9tHhx3sSr6o6f0qn8xcAWhsCnBFQ0mzAa/0/bN+J7Nx62n3j+Nztp+aj849OYtr7wmfz71MkBBT9u3VV0QB04swHUx3cE+9J2QdIURl7/QWA1oeA5czOgBJCwJ+nngGII2S3E511TBeXtSgsOpsYrRZR1xnzTRP3/h+86v78tcRaDGslkmHFvwDQGbGARZKt2FYj7ehkitz7jzPiy74XH9PNrxWYcq5z61uTxOK8Ivf+41YQSbDoTwDo1CxAzFnGrQD3siZUZIS41dTuAwV+fwSIFytYFR6KjFxHCxlTM3qU71YiQJm6T8KwVrrvLwB0LQRItROKkXGhR77+6ZOpOpl4al9V+8Gj8zpXoAOr60jiRgWAAj9z7JIgCYfd96+PbYD1hoDl+aW17w3+8YDWKCa20xU5GGZ0SM9Wo+vtxD3mKsWtgO2CTJGdDF0St2aKvDdtWrUfD3yaNkie+/Dy8KyMxJx0318A6Lq4FbCQJX4+QIzqtxr5xeEt9339LwvvC9+ugygyyrz6JLmybQSMrZ9qFz9zdiad6yBOUJx1MCv9Z/KMh0mMbpMiAHR6FiAOCYoL/aXUA0CZpn2me8wgVH0c7Fa3KLg+Z/Qn4WH3/etnDcBsQsDJzNbA0sQCsWlPXqtjgZlFbF8Uz1EQAJIXW/5WNIMAkJJYECjxTuncGPvs22D3zrTWANx161+4iNO2nlkcLQAkOAvgnldJnX+XnuR2/qMrib2Hf3Qhp82WPwEg2RAQtwJWtMT4XszP2i9rWv3uGhZu3W1x2BcUO+HxZg3VTSt5DWRGLAJsQALONp4ayDZioV6s9o9Ddcq+Lxy7DWJLWpWzCTu/fKM3cQICQKdrHwJA0rMA/fmltaODf3wqpZ87pu+362yjk994XRn++mlG+7GVbLutgLEFr8r95k3Yitg0RRZvtu1wpCd+2fc44O0djdqnGQQAsuz44PXo4NVL5QeOQ07qLJLDGYPd23c0VQaAIscZR9hJTbw3243yo+08wrcz+nnNY8asAWjGLEAsgjmqJWY70oynBe7aUc00fRxFXOSAmLYdelPKe1PgZ071SYkdHv1b+CcAsCkELGeeGFiZIk/ji3UA37/n1kr+/Mfuv63QSDjFPe9Fwlk8zMkiyk5YddyvAMC12Q9bkVhvUCQEPHLP10pfdBbT18UeeJPmoCjel48KLL489J07XMhqHAJAZ2cBVjLbAitT5IlyMQvw3//2r0u7FRCj1p8sfKO0v19Xw1mR+/sRoh67//ap/7xHKprlYVsrTvwTANiatQAViU6myBR73Kt/9u96U4eAu/PvU+SBRjH6T/nI29jaWUTcSpnmORIRxuLpkmW8v6htAgBmAVrk+OvnC/26CAEv/f1dw8V7k44yi3b+Mf1dtAPsqgg/cbhT0U48XuN04LvymZ1ReIjZhGneX4z+u8A2wOYm5QXNUM0sQNxzfqDAlrzovJ/9bm+4Sj06p+2mqaOTie8b09TjrCM4ceaDSkb/006Xxy2JOmcloh1iJ0aR0DR6nHQEp3g/r3emxOg9OfydO77wfUfvb/y5ZQaw7R51PV4wutKVtSFG/wIARWcB5pfWYkfAXq1Rvnh+QIz+dhYcQUYxHxX0CAPnPrz8uSNso7OP1yRFP77fCwVHvuMHgNum+v3xd6szAEQn/uNXfjfslIuINh+tr4i/69WHKMXBTkXek2in+LVP/vPvSjkJssxHXcfP1YEAsGr0LwAwnmcGr+c0QzUdTTxHoOgU/fXCwLTidMPodNjU4b17aRjQii6cLOt9Gd0S+Ief/drjh6upZTSQNQDNnQVYzjZOzKICcaxwhICPZvQkwXP5n9+lJxmWJUa8MS1ft6KLRBlL375/AYDJPK8JuhcCdP7bi3vyMRNQZ+io889TwxAA2I7zsmsIAQ//9FxtR/DGYsKYZtb5F+uUf1DDlLzOXw0TAGic/LzsZS1RrdGagOgEqupsImDEU+LiIUiMF9AiBMQtgbJnauL7PfnKb3X+1Vl25n+zWQTYfD8fvBY1Qz0jznjFKu7Yx39XCWfPxxa1F9YueDzslAEtbgnE7Ek8qyHen2mOa46O/4W3/3X4/czEVF67aLAbNEHzzS+t/SZr0aOC43CV7VZk173HfBJxkl/8LA8UPMt/1LnEdrRT/T9Uuo1uoxPcUXEg2vo92u6cgSr3sI+er1D0KYvxc8T78drgfZnmscIRPOp8MmGLzwGIxX93qt4CANMHgGODL4e0xGxt7Pff6HRHgSA6/JimDhvnAxhRziqs7fzyjdmuHV8aBIK/2Hg/LvxxeF6D92Umjg8CgAf/CACUEADiQKA3tQTQEvsGAcDjzQUASgoBrboNACQrTv7bpxmazy6A9jipCYAWWNEEAgDlcqAGoFZRGrcAWsRtAKDhrP43A0BFVjQBoEYhAKTHwRqAGoUAIF0DqFEIAJ2Xn6ttby3QRKvO/hcAkLABtQkBgJKd0gSA2oQAIGUDqE0IAF2X32PrawmgQfru/wsA1MNCQEBNQgBI0FuaAFCTEACkbQA1CQEgAX1NAKhJTMPDgFpqfmnt37UC0ASnH9+jLzEDgMQNqEUIAPjQAWoRAgClsucWUIsQABJk2w2gFiEAAAACQAr6mgBQixAAfOgA1CIEAABAAAAABAAAEAAAAAEAAApzEJAAAECC5jSBAAAACAAAgAAAAAgAAIAAAAAIABTQ0wSAWoQA4EMHoBYhAAAAAkAX3asJALUIASA9Tt8C1CIEgAT1NAGgFiEA+NABqEUIAF02v7S2VysAahICgMQNoCYhACRA2gbUJASABNl2A6hJCAAJ6mkCwAwA07hBE7TL/NJa7Ln9vZYAGuarpx/fs64ZzAAgaQNqEwIAJVrQBIDahACQngc1AaA2IQCkxzQboDYhAKQkP23LgzeAJppzIqAAQHUOaAJAjUIASI97bIAaRSmcA9AS9v8DLeE8ADMAlMzUGqBWIQAkyNQaoFYhAEjVAGoVAkCnzS+txQfK9j+gDebymoUAQAm+pwkANQsBID3SNKBmIQCkZH5pbTEz/Q+0y1xeuxAAmIKpNEDtonQOAmr26L83+PIbLQG01J2nH9/T1wxmABjfoiYA1DAEgPQ8qgkANQwBICH5PtqelgBarOdMAAGA8f1IEwBqGVWxCLCZo/8Y+Vv8B3SFxYBmACjoKU0AqGmYAUhr9D+Xj/4d/gN0xXo+C7CuKcwAcH0e/AN0zVzmeGABgG2ZKgPUNgSAlMwvrS1ktv4B3dTLaxwNcZMmaBTbZWBCD909lz30zfLunj3xi75GrabGrWgGAYDPj/5j5O8eGUxo964d2X27b9EQzXYgap0tgc3gFoDRP0CdFjWBAIAPBWCwgwCQrvmltej8bf0DUjCX1zwEACRiQM1DAEhv9L8w+LJXSwAJ2WtLoACA52UDah8CQHKj/15m8R+QpsW8BiIApPkB0ASAGogAkB4LYQA1EAEgJbb+AdgSKABIvgBqIQJAAqP/hczWP4BgS6AAkBTbXwDURAEgsdF/3Pdf1BIAn1rMayMCQKcd0gQAaqMAkB5TXQBqowCQkny7S09LAHxBz5ZAAUDCBVAjEQA6M/qPbX8LWgLguhbyWokA0CkOuwBQKwWAxEb/sb3lgJYA2NYBWwIFgC5ZzJz7D1CEs1IEgE4xpQWgZgoAKcnPuO5pCYDCep4PIABIsgBqJwJA60b/MfK3+A9gfAfyGooA0EqLmgBADRUA0uNUKwA1VABIiXP/Aabm+QACgOQKoJYiADR/9B8j/wUtATC1BYsBBYA2sX0FQE0VABK0qAkA1FQBICH5ghXn/gOUZ85iQAGgDSxYAVBbBYDERv+9zOI/gCpYDCgANJqFKgBqrACQIOf+A6ixAkBK5pfW4sLsaQmAyvTyWosA0CgWqACotQJAYqP/2PYnlQJU70BecxEAGmFREwCouQJAeqxMBVBzBYCUzC+t7c0s/gOoUy+vvQgAkiiA2osAUC+L/wDUXgEgJfl+VKtRAeo350wAAWCW7EcFUIMFgMRG//b+A8yWMwEEgNlceJoAQC0WANJj6glALRYAUpI/k3pBSwDM3EJekxnTTZpgIqacWmLXjhuzu/7qK6V9v3MfXs4uXvlEw0LzavJxzSAA1MGUU0tE5//sd8sbHDzxy372xruXNCyNsHvXzdlDd3+1tO/38tnfZ+cvftzWmiwACADVyqeaHEEJNCAA7Mgeu/+20r7fG+cvtTUA7I3afPrxPX1XRXHWAIzP9D+A2iwAJMj0P4DaLACkxPQ/QGPttRtAAKiSKSYANVoASJApJgA1WgBIiel/gMZzG0AAqISpJQC1WgBI0Pc0AYBaLQAkJH/c5IKWAGi8BY8IFgDKZEoJQM0WABL0oCYAULMFAGkSADVbAOiy+aW1hcEX95MA2mMur90IAFOxohRA7RYAEiRFAqjdAkBKnP4H0FpOBRQAJEgANRwBYDy2kgCo4QKA9AiAGi4AdNr80lrc++9pCYDW6uW1HAFAcgRQyxEAtubeEYBaLgBIjQCo5QJAp+X3jBz/C9B+c9YBCADjcLEAqOkCQILcMwJQ0wUAaREANV0AcLEAoKYLAN3iGdIAarsAICkCoLYLAIn4G00AoLYLAFIiAGq7AOAiAUBtFwC6yAmAAGq7AJASq0QB1HgBAAAQABIhHQKo8QIAACAApOBeTQCgxgsA6bFKFECNFwAAAAEgBQuaAECNFwAAAAEAABAAAAABoN3ml9Z6WgFArRcA0uOiAFDrBQAAQAAAAAQAAKDNbtIE0D2/+uG3SvteJ858MHi9r1HBDAAAIAAAAAIAACAAtElfEwCo9QJAYk4/vsdFAaDWCwAAgAAAAAgAAIAA0B0rmgBAjRcAAAABAAAQALrolCYAUOMFAABAAEjAqiYAUOMFgPSsawIANV4AkA4BUOMFgK47/fge6RBAjRcAErWiCQDUdgEgPRIigNouACToLU0AoLYLAOmxSARAbRcAXCQAqO0CQOedfnxPP3OvCKBL1vPajgAgKQKo6QIAX+SBEQBqugAgLQKgpgsALhYA1HQBoHvyxSJ9LQHQen0LAAWAca1oAgC1XABIj0UjAGq5ACA1AqCWCwCdZx0AQOu5/y8ASI4AajgCQHE/1wQAargAID0CoIYLAF13+vE98VCgk1oCoHVO5jUcAWBitpAAqN0CQIopUhMAqN0CQGLyLSTOkQZoj1Xb/7Z3kyYo5PnBa2/bf4iH7p7LHvrmXCnf69yHl7Njr7/nygCaWrMRAEoRU0nH2v5D7N61I7tv9y3eTSCFms023AIowG0AgNYw/S8AlO4ZTQCgVgsA6TGlBKBWCwCpcSgQQOMtO/xHAKiKlaUAzeXsfwGgslmAmAHoawmAxunnNRoBwCwAgNqMAFCeZU0AoDYLAInJ95e60AAa1Pnb+y8A1MVUE4CaLAAkOAuwkjkZEKAJVvOajABQG6dNAajFAkCCswDLmS2BALPUz2sxAkDtjmoCADVYAEhPHDrh2EmA+jmeXQCYnfzMafefAOr3jHP/BYBZO24WAKD20f9xzSAAmAUAMPpHADALAGD0jwBQ3yzAYS0BULnDRv8CQNNCwHLmXACAKtn3LwA01kFNAKDGCgDpzQKsDL6saAmA0q04818AkFAB1FYEgMbNAvQzK1QBynQ8r60IAI0X51O7WAGm18+c+S8AtGgWwLZAgHLY9icAtC4ExEMqPKgCYHIn81qKANA6sWhFcgUY33pm4Z8A0OJZABcwwIQDKFP/AkDbQ4BbAQDjMfUvAHQnyWZuBQAUYeZUAOjULIALGqDggMnUvwDQtRAQ01kOCAK4vuOm/gWArorDLFY1A8AXrGYO/BEAOjwLMLoVYHoL4DPD2mjqXwDoegiIlOuUQIDPHM5rIwJA50PAcmY9AEA4ntdEBIBkQkDMAki8QMpW81qIAJCc/ZmnBgJp6uc1EAEgyVmAWPDycGZRIJCWYe2z6E8ASD0EWBQIpMaiPwGAPAQsCwFAQp3/smYQAPgsBMSuAB8KoMuW81qHAMBVISAOCXIMJtBFJ/MahwDAdcQHxL0xoEtWMw9EEwDYdhYgVsXuFwKADnX++634FwAYLwT0tQbQYn2dvwDAZCHAGQFALV4+u5698e6lMr+lvf4CAFOEgNV8JsAHCKi083965Z2yO//99voLAAgBgM4fAQAhAND5IwBQWwh48e0L2bkLlzUmoPNHAEgpBFy88kn2xC/6ww8+kK7jr7+n80cAaHEI6E8aAuKDHwUASE98/l94+0KZ37Kv8xcAqDcE7MumOCwoCsAPfvbr7PzFjzUoJOCjmAH8ZekzgMNapPMXAKg3BEx9YuDZC5eHIeC1/kUNCh0Wa3/i9l/J+/yd8CcA0IAQMPEDhOKWwI9f+W325OAVIwSgWyLgR+d/ttwFwCd1/gIADQgBg1ecGLg8zfc5NSgSD//0nNkA6JATZz4YBvyL5Yb7eKSvE/4EABoUBOJJW0en+R6j2YC4T2htALTX6H7/iTPvl/2tj3qkrwBAM0PAkayER27GfcKH/+nscPTgtgC0yxvnLw1n80q+3x8O5jUGAYCGhoDlbGOHwNTTczF6iELyYrlbhoCKRGiP+/0lT/lHLdmX1xYEABoeAqbeJjgSheTY6+8NZwQcIATNVOGUv21+AgAtDAH9bModApvFmoA4QOTTWwN/+rNGhgaILX7/8LNfVzHlP1rp39fK3XSTJuh0CBg+j3t+ae3I4OtTZQWBCkYZwCSd/4cbnX8FjrrfbwaAbgSB+CDHVkFz+NAhF8tfpDscNOj8BQC6FQJiOq+UdQFAJ43u95/UFAIA3QsB/WxjXcCy1gA2iZrgfn9irAFILwTEFN/B+aW1U4OvxwavOa0CyYp6cNgWPzMApBUElrMpHyYEtNroYT46fzMAJBgChvf85pfWYibgkBaBZBwffP4PawYzAAgCUQjsEoDuG63y1/kjAPBpCIiVv3dmJR0cBDTO8DNulT8jbgGwOQSMDg6K2wFxcJAFgtCNUX8c7HNcU2AGgO2CQBSKODNgRWtAq8VneJ/OHzMAjBMC+oMv+80GgFE/ZgBIezbAfUNoh5NG/ZgBoMzZgFgbcGDw9TmzAdDYUf9Bi/wwA0AVQWC0U8DIApolPpNW+GMGgEpDwPDo0PmlteezjaOEF7QKzMxKtnGUrxM9EQCoLQgMjxEdBIHFzDMFoG7O8GdqbgEwbRCIAuS2ANRnNN2v88cMADMPAaPbAs9kG4sEF7QKlG4l21jk19cUCAA0LQhEYYrbAhEA4rbAXq0CU4vbbTHdv6IpEABoehCIQrUvXx8Qhwj1tAqMLQL1UVP9VMUaAKoMAlG44hCho5knDUJR6/lnZp/OHzMAtDkERDE7Mr+0FguXRscK1+ajP32SfXTlk2znjhu9GbRBdPzH888NmAGgG0Fg8DqSbewYqG1Uc/bC5ezhn57LTpz5YBgEYDsvn13PHv6ns3X/sfGZiJX9R3T+mAGgq0GgP/hycH5p7Wg+G7BY9Z95cdDxnzjzfvbi2xey799za/bIPV8zI8AXvHH+Uvb0yjvZ+Ysf193xH7WyHwEAQaDGIPDQ3XPZ7l03ezN0/MMZojfevaTjRwCAGQWBWs4QGAWBeEUIeOz+2wWBBMVI/+lT79Td8a9k9vIjAMAXgsDoDIGnspoOE4r7vfESBNLq+CP8xftec8d/1F5+BAC4fhCIArmSB4FHsxpuDQgCOv4KLQ9ez+v4EQBg/CBQ2xoBQaCbzl24nL3w9oVZdPzu8SMAwBRBIAroQUGAcb3Wv5i9sHbB4j4QABAEpg8CNFuc9fDyv6wPO37b+WBrN2gC2mgQBHp1BoGRXTtuHO4iaLpf/fBbpX2v2CIX986bLmZpPvrTn+t+f3T8mAGAGc4IRAj40eA1V/Wfe9Fpgo1V44g/FhPEo6+XdfwIADDbILD5WQO1BAGSNOr4ndWPAAANCgLrggA6fhAAEAQiCBzINtYJ9LQME+hnG0/nO6njRwCAdgWB5XgNwsCiIMC4Hf/gGlrWFAgA0O4wIAig4wcBAEFAEEDHDwIAKQeBWCMQiwUXtEqSVgavZwbXw0lNgQAAaQWBKPwn634CIY3o+D2ZDwFAEyAIfO4JhIKAjh8EABAE0PGDAAApBoHnMosF22p18Dqs4wcBACYJAnfaNdA6/cyqfhAAoIQgEB2J7YM6fhAAIPEgcCgPAp410Azrecd/XFNAcV/SBDB2EIiO5s5s45x4Z8TPuOOP90LnD2YAoK4QsPmhQ8cGr0WtUqvlbGOBnwAGAgDMLAgcHASBGInGjoEFrVKplWjvQbv3NQUIANCEIBAd0v5862DMCOzVKqWypQ8EAGh0EIgOal++YyCCgIWC01nPO/5lTQHlsggQqgkC0WHFQkGL0yY3XGyp8wczANC2EDAcvc4vrT2TWR8wjpXMfX4QAKADQSA6sv3544fjtkBPq1xTtNNhj+eFergFAPUFgejY9mUbe9f5vGiTfTp/MAMAXQ0Bo/MDljO3BcJKZrofBABIKAhEhze6LRBBoNTdAh9d+STbuePG0r5XBdbzjt+IH2bkBk0AszUIAdH5x7MFDpX1PXcNOv/v33Nr9sg9X5s4CJy/+HF2/PXz2an+xbJ/5Fjdf9QpfiAAABtBYCEr+RCh3btuzg5/e3f2QG/XWL/vxbcvZCfOfJBdLHf07zAfEACALYLAkXxGoDQPDgLATxa+se1sQEz3//iV32VvvHup7B8rRvxHvLsgAABbh4BeVvIiwZgNiBBw3+5brvn/3zh/KXvyn39X9qg/RvsW+YEAAIwZBA7lswGlLRJ87P7bB6/bPvffYrr/xJn3y/yrr+ejfichggAANGU24L6v35L95MFvDP/5yVd+m529cNmoHwQAIIXZgF35eoASp/yN+kEAANoyG2DUDwIAkOhsgFE/CACA2QCjfhAAgBYEgSNZyecGFGBfPwgAQANCwN58NmBvxX/Uaj7qX9Xq0G4eBwwdkHfI+7ONc/arEt97v84fzAAAzZwNWBh8eSkrb4FgLPR72Bn+IAAAzQ8Bc3kIWJjyW63knb8n94EAALQoCMR2wWMT/vbDtveBAAC0NwTszWcDegV/Sz8f9bvXDx1mESB0XN6R7xu8lgv88vg1+3T+YAYA6NZswGK2cUvg6gWCcY8/pvyXtRIIAEA3Q8DVZwbY2w8CAJBICJjLQ0CWd/5W+QMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJCA/y/AAI/lB0aIIF7TAAAAAElFTkSuQmCC\"></p>","gHeight":125,"gWidth":121,"color":"#000000","background":"transparent","resized":true,"lines":[]},"488b00e1-89d4-4e51-bf45-3cf4a4f09bc2":{"id":"488b00e1-89d4-4e51-bf45-3cf4a4f09bc2","visible":true,"name":"VersionInfo","x":163,"y":33,"desc":"<h1>Police Data Portal</h1><p><strong>Version:</strong> pre-1.0.0</p><p><strong>Last Updated:</strong> May 8, 2021</p><p><strong>Maintained By: </strong>Peter Schmalfeldt</p>","gHeight":119,"gWidth":282,"color":"#555555","background":"transparent","resized":true,"lines":[]}},"lines":{},"model":{"name":"Police Data Portal","id":"d55c64f9-7e87-4025-a961-aa0e6e04f7c3","desc":"ORM Schema for Police Data Portal","path":"","type":"SEQUELIZE","version":1,"keysgraphics":false,"linegraphics":"basic","zoom":100,"parentTableInFkCols":true,"caseConvention":"under","replaceSpace":"_","color":"#03a9f4","background":"#ffffff","sideSelections":true,"isDirty":true,"storedin":{"major":2,"minor":2,"extra":3},"def_freezeTableName":true,"def_timestamps":true,"def_paranoid":true,"def_tabletype":"na","def_collation":"","def_charset":"","def_cols":[],"def_coltopk":true,"def_version":false,"def_underscored":true,"filePath":"/Volumes/Storage/Projects/FatalEncounters/repos/pdp-orm-schema/police-data-portal.dmm","lastSaved":"Sun May 09 2021 18:18:09 GMT-0400 (Eastern Daylight Time)","gen_fk_seq":true,"writeFileParam":true,"description":"ORM Schema for Police Data Portal","linecolor":"#cccccc"},"otherObjects":{}}