30:T10dd, # Active standard licence endorse ## ${Active_standard_licence_endorse[0].A} https://www.firearmssafetyauthority.govt.nz/manage-and-apply/licensing/endorsements https://christchurchattack.royalcommission.nz/the-report/part-5-the-terrorist/the-firearms-licensing-process/ **B Endorsement** – to possess up to 12 pistols and use for target shooting and to be an active member of an approved pistol club recognised by the Commissioner of New Zealand Police. **C Endorsement** – either: - collector endorsement to collect pistols or restricted weapons; - heirloom/memento endorsement to own pistols or restricted weapons with special significance as an heirloom or memento; - theatrical endorsement to own pistols and restricted weapons for theatrical purposes; or - museum endorsement to collect pistols or restricted weapons. **E Endorsement** – to possess military style semi-automatic firearms. **F Endorsement** – to own pistols and restricted weapons for hire or sale, including as an employee of a dealer. Usually issued alongside an E Endorsement to enable dealing in military style semi-automatics as well. 1. Pistol target shooting endorsement is a **B** Endorsement 2. Dealer employee endorsement is a D Endorsement/Licence 3. Pest control endorsement is a P Endorsement 4. Bona fide collector endorsement is an **C** Endorsement 5. Memento and heirloom endorsement is an **C** Endorsement H? 6. Broadcaster, theatrical, living history, and theatrical armourer endorsements are a **C** Endorsement 7. MSSA (Military Style Semi-Automatic) is an **E** Endorsement. Replaced with a P endorsement. Pistols or restricted weapons for hire or sale (**F** endorsement – dealers)

Licences
A	Standard firearms licence – allows a person to have and use, without supervision, any type of firearm (except pistols, military style semi-automatic firearms and restricted weapons).
D	Dealer’s firearms licence – allows a person to sell and make firearms and airguns. Valid for one year and can only be used for one place of business.
V	Visitor’s firearms licence – allows a person visiting New Zealand for less than 12 months to use firearms for hunting or competitions in New Zealand and to apply to have endorsements to use controlled firearms.

A, B, D, E licences. The E no longer exists, # wikipedia

Endorsement	Use
B	Allows the holder to possess and use pistols. Issued only to bona fide members of pistol clubs. Weapons held under a "B" endorsement may only be fired at an approved pistol range, and are subject to strict controls on carriage away from the owner's home.
C	Allows the holder to possess and use pistols and restricted weapons. Issued only to bona fide collectors, to people for whom a particular weapon has a special significance (e.g. as an heirloom), to museum curators, and to theatre, film and TV production armourers. Weapons held under a "C" endorsement may not be fired with live ammunition, though blanks may be fired for film, TV and theatre purposes.
D, F	Special endorsements for firearms dealers.

--- ${Active_standard_licence_endorse[1].A} A: "Residence District" B: "Endorsements" D: "Residence District" E: "B Endorsement" 1 F: "C Endorsement" 2 G: "F Endorsement" 3 H: "L Endorsement" 4 I: "M Endorsement" 5 J: "P Endorsement" 6 K: "T Endorsement" 7 L: "Total Endorsements" 31:[{"id":"3220498dfaa3fa78cce78f61b1fbb806caef4a19313a9e13fab60492da7a82515ec2df2db7c3ec83b4201d97cd35eb66543d3eb4f74622e078ab02af03aa97f4","href":"https://static.observableusercontent.com/files/3220498dfaa3fa78cce78f61b1fbb806caef4a19313a9e13fab60492da7a82515ec2df2db7c3ec83b4201d97cd35eb66543d3eb4f74622e078ab02af03aa97f4","name":"firearms-information-summary-1mar2023.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1679287229494.377,"size":33176},{"id":"4de411a1c620a35a42c483e4f018403bad3baf9ce02b6c25d0742bd4b223edb9995a2f2233c7f721766ffc08b9d45dcb6379f552a261e1e00edb5722a5eded4b","href":"https://static.observableusercontent.com/files/4de411a1c620a35a42c483e4f018403bad3baf9ce02b6c25d0742bd4b223edb9995a2f2233c7f721766ffc08b9d45dcb6379f552a261e1e00edb5722a5eded4b","name":"image.png","type":"image/png","lastModified":1681356373972.413,"size":314444}] 2e:{"title":"NZ firearms","cells":[{"id":980,"value":"# NZ firearms\n\n## Firearms Information Summary as at 1 Mar 2023\n\nhttps://www.police.govt.nz/about-us/publication/firearms-data\n\nTypes of firearms licences. \n\n- Standard firearms licence is an A category licence\n- Standard dealer’s licence is a D category licence\n- Pistol target shooting endorsement is a B category endorsement\n- Dealer employee endorsement is a F category endorsement\n- Pest control endorsement is a P category endorsement or Pest category endorsement\n- Bona fide collector endorsement is a C category endorsement\n- Memento and heirloom endorsement is a C category endorsement\n- Broadcaster, theatrical and theatrical armourer endorsements are a T category endorsement\n- Living history is an L category endorsement\n- MSSA (Military Style Semi-Automatic) is an E category endorsement.","pinned":false,"hidden":false,"mode":"md"},{"id":0,"value":"\n # sheetNames:\n 0. \"Summary\"\n 1. \"Active licences by type\"\n 2. \"Active endorsements by type\"\n 3. \"Active licence holders - Curren\"\n 4. \"Active licence holders - Gender\"\n 5. \"Active licence holders - Ethnic\"\n 6. \"Active standard licences by Dis\"\n 7. \"Active standard licence endorse\"\n 8. \"Stolen firearms by calendar yea\"\n 9. \"Firearms violence offences as p\"\n 10. \"Licences revoked by year\"\n 11. \"Licences in Progress\"\n 12. \"Endorsements in Progress\"\n 13. \"Licences processed by year\"\n\n![image.png](${await FileAttachment(\"image.png\").url()})","pinned":false,"hidden":false,"mode":"md"},{"id":254,"value":"# ${Summary[0].A}\n\n${Summary[1].A} \n \n${Summary[3].B}","pinned":false,"hidden":false,"mode":"md"},{"id":457,"value":"# ${Active_licences_by_type[0].A}\n\n${Active_licences_by_type[1].A}\n\n A: \"Licence Type\" \n B: \"Licences\"","pinned":false,"hidden":false,"mode":"md"},{"id":602,"value":"Activelicencesbytype = Active_licences_by_type","pinned":true,"hidden":false,"mode":"ojs"},{"id":461,"value":"# ${Active_endorsements_by_type[0].A}\n\n${Active_endorsements_by_type[1].A}\n\n A: \"Endorsement Type\" \n B: \"Endorsements\" \n C: \"Unique People\" \n E: \"Endorsement Summary\" \n F: \"Endorsements\" \n G: \"Unique People\" ","pinned":false,"hidden":false,"mode":"md"},{"id":546,"value":"Activeendorsementsbytype = Active_endorsements_by_type","pinned":true,"hidden":false,"mode":"ojs"},{"id":464,"value":"# ${Active_licence_holders_Curren[0].A}\n\n${Active_licence_holders_Curren[0].A}\n\n A: \"Age Group\" \n B: \"Visitor\" \n C: \"First time licence holder\" \n D: \"Has held a licence previously\" \n E: \"People\" ","pinned":false,"hidden":false,"mode":"md"},{"id":186,"value":"ActivelicenceholdersCurrentAge = Active_licence_holders_Curren","pinned":true,"hidden":false,"mode":"ojs"},{"id":466,"value":"# ${Active_licence_holders_Ethnic[0].A}\n\n A: \"Ethnicity\" \n B: \"Visitor\" \n C: \"First time licence holder\" \n D: \"Has held a licence previously\" \n E: \"People\" ","pinned":false,"hidden":false,"mode":"md"},{"id":188,"value":"ActivelicenceholdersEthnicity = Active_licence_holders_Ethnic","pinned":true,"hidden":false,"mode":"ojs"},{"id":467,"value":"# ${Active_licence_holders_Gender[0].A}\n\n A: \"Gender\" \n B: \"Visitor\" \n C: \"First time licence holder\" \n D: \"Has held a licence previously\" \n E: \"People\" ","pinned":false,"hidden":false,"mode":"md"},{"id":190,"value":"ActivelicenceholdersGender = Active_licence_holders_Gender","pinned":true,"hidden":false,"mode":"ojs"},{"id":469,"value":"$30","pinned":false,"hidden":false,"mode":"md"},{"id":194,"value":"Activestandardlicenceendorse = Active_standard_licence_endorse","pinned":true,"hidden":false,"mode":"ojs"},{"id":468,"value":"\n# ${Active_standard_licences_by_Dis[0].A}\n\n${Active_standard_licences_by_Dis[1].A}\n\n A: \"Residence District\" \n B: \"Licences\"\n","pinned":false,"hidden":false,"mode":"md"},{"id":196,"value":"ActivestandardlicencesbyDistrict = Active_standard_licences_by_Dis","pinned":true,"hidden":false,"mode":"ojs"},{"id":474,"value":"\n# ${Endorsements_in_Progress[0].A}\n\n${Endorsements_in_Progress[1].A}\n\n\n B: \"Collector\" \n C: \"Collector\" \n D: \"Dealer Employee\" \n E: \"Dealer Employee\" \n F: \"Dealer Endorsements\" \n G: \"Dealer Endorsements\" \n H: \"Memento/Heirloom\" \n I: \"Memento/Heirloom\" \n J: \"Memento/Heirloom\" \n K: \"Museum\" \n L: \"Other\" \n M: \"Pest Control\" \n N: \"Pest Control\" \n O: \"Posess Prohibited Ammunition\" \n P: \"Posess Prohibited Ammunition\" \n Q: \"Target Pistol\" \n R: \"Target Pistol\" \n S: \"Theatrical\" \n T: \"Theatrical\" \n \n A: \"Months in Progress\" \n B: \"New\" \n C: \"Renewal\" \n D: \"New\" \n E: \"Renewal\" \n F: \"New\" \n G: \"Renewal\" \n H: \"New\" \n I: \"New\" \n J: \"Renewal\" \n K: \"New\" \n L: \"New\" \n M: \"New\" \n N: \"Renewal\" \n O: \"New\" \n P: \"Renewal\" \n Q: \"New\"\n R: \"Renewal\" \n S: \"New\" \n T: \"Renewal\" \n U: \"Total Applications\" \n\n${Endorsements_in_Progress[37].A}\n","pinned":false,"hidden":false,"mode":"md"},{"id":200,"value":"EndorsementsinProgress = Endorsements_in_Progress","pinned":true,"hidden":false,"mode":"ojs"},{"id":471,"value":"# ${Firearms_violence_offences_as_p[0].A}\n\n${Firearms_violence_offences_as_p[1].A}\n\n\nFirearms-related offences as proportion of all offences in the Violence Category\n\nA: \"Year\" \n B: \"MURDER\" \n C: \"MANSLAUGHTER\" \n D: \"ATTEMPTED MURDER\" \n E: \"AGGRAVATED ROBBERY\" \n F: \"ROBBERY\" \n G: \"GRIEVOUS ASSAULTS\" \n H: \"SERIOUS ASSAULTS\" \n I: \"MINOR ASSAULTS\" \n J: \"INTIMIDATION AND THREATS\" \n K: \"Firearms-related offences proportion by Year\" \n\n **To get a number, I have to find the number of violence offences for each year and then use the percentage given in this table.\n Violent offences was not included in this dataset.**\n","pinned":false,"hidden":false,"mode":"md"},{"id":202,"value":"Firearmsviolenceoffencesasproportionofallviolenceoffences = Firearms_violence_offences_as_p","pinned":true,"hidden":false,"mode":"ojs"},{"id":475,"value":"\n# ${Licences_processed_by_year[0].A}\n ${Licences_processed_by_year[1].A}\n\nA: \"Calendar Year\" \nB: \"Processed Licence Applications\"\n","pinned":false,"hidden":false,"mode":"md"},{"id":204,"value":"Licencesprocessedbyyear = Licences_processed_by_year","pinned":true,"hidden":false,"mode":"ojs"},{"id":473,"value":"\n# ${Licences_in_Progress[0].A}\n\n${Licences_in_Progress[1].A}\n\n B: \"A-Standard\" \n C: \"A-Standard\" \n D: \"D-Dealer\" \n E: \"D-Dealer\" \n\n A: \"Months in Progress\" \n B: \"New\" \n C: \"Renewal\" \n D: \"New\" \n E: \"Renewal\" \n F: \"Total Applications\" \n\n ${Licences_in_Progress[39].A}","pinned":false,"hidden":false,"mode":"md"},{"id":206,"value":"LicencesinProgress = Licences_in_Progress","pinned":true,"hidden":false,"mode":"ojs"},{"id":472,"value":"\n# ${Licences_revoked_by_year[0].A}\n\n${Licences_revoked_by_year[1].A}\n\n A: \"Calendar year\" \n B: \"Revoked Licences\"","pinned":false,"hidden":false,"mode":"md"},{"id":210,"value":"Licencesrevokedbyyear = Licences_revoked_by_year","pinned":true,"hidden":false,"mode":"ojs"},{"id":470,"value":"\n# ${Stolen_firearms_by_calendar_yea[0].A}\n${Stolen_firearms_by_calendar_yea[1].A}\n\n A: \"Year of occurrence\" \n B: \"Stolen Firearms\" \n C: \"Occurrences where firearms were reported stolen\" ","pinned":false,"hidden":false,"mode":"md"},{"id":212,"value":"Stolenfirearmsbycalendaryear = Stolen_firearms_by_calendar_yea","pinned":true,"hidden":false,"mode":"ojs"},{"id":875,"value":"---\n# data sheets","pinned":false,"hidden":false,"mode":"md"},{"id":3,"value":"firearmsInformationSummary1mar2023 = FileAttachment(\"firearms-information-summary-1mar2023.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":7,"value":"Summary = firearmsInformationSummary1mar2023.sheet(\"Summary\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":115,"value":"\nActive_endorsements_by_type = firearmsInformationSummary1mar2023.sheet(\"Active endorsements by type\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":117,"value":"\nActive_licence_holders_Curren = firearmsInformationSummary1mar2023.sheet(\"Active licence holders - Curren\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":119,"value":"\nActive_licence_holders_Gender = firearmsInformationSummary1mar2023.sheet(\"Active licence holders - Gender\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":135,"value":"\nActive_licence_holders_Ethnic = firearmsInformationSummary1mar2023.sheet(\"Active licence holders - Ethnic\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":36,"value":"Active_licences_by_type = firearmsInformationSummary1mar2023.sheet(\"Active licences by type\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":121,"value":"\nActive_standard_licences_by_Dis = firearmsInformationSummary1mar2023.sheet(\"Active standard licences by Dis\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":133,"value":"\nActive_standard_licence_endorse = firearmsInformationSummary1mar2023.sheet(\"Active standard licence endorse\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":123,"value":"\nStolen_firearms_by_calendar_yea = firearmsInformationSummary1mar2023.sheet(\"Stolen firearms by calendar yea\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":131,"value":"\nFirearms_violence_offences_as_p = firearmsInformationSummary1mar2023.sheet(\"Firearms violence offences as p\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":125,"value":"\nLicences_revoked_by_year = firearmsInformationSummary1mar2023.sheet(\"Licences revoked by year\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":129,"value":"\nLicences_in_Progress = firearmsInformationSummary1mar2023.sheet(\"Licences in Progress\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":127,"value":"\nEndorsements_in_Progress = firearmsInformationSummary1mar2023.sheet(\"Endorsements in Progress\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":38,"value":"\nLicences_processed_by_year = firearmsInformationSummary1mar2023.sheet(\"Licences processed by year\")","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}