Official JSON

{
   "state": {
        "stateName": "Andhra Pradesh"
    },
    "institutionDetails": {
        "type": "state",
        "name": "Police Training College, Ananthapuramu",
        "nameAndAddress": "Police Training College, Cantonment, Vizianagaram, Andhra Pradesh-535003",
        "yearOfInception": 1908
    },
    "headOfOrganization": {
        "rankDesignation": "SP./Principal",
        "contactNo": "9121109333",
        "emailId": "[email protected]",
        "faxNo": "NA"
   },
  "trainingCapacity": {
    "gosDySPAndAbove": 20,
    "ngosAsiToInsp": 50,
    "orsCtToHC": 600,
    "total": 670
  },
  "officersTrainedFY2022_23": {
    "gosDySPAndAbove": 1,
    "ngosAsiToInsp": 531,
    "orsCtToHC": 1446,
    "total": 1978
  },
  "campusAreaAcres": "57.37 Acres",
  "nosOfClassroomsWithCapacity": "12 (each 60) Total 720",
  "conferenceHallRoomWithCapacity": "1 Hall/60 Capacity",
  "auditoriumWithCapacity": "2 Auditoriums (1 - 250 Nos., 2 - 500 Nos.)",
  "computerRoomWithNosOfComputers": "2 Computer Rooms (1 - 24 Nos., 2 - 36 Nos.) Total - 60 computers",
  "miniFSL": "NA",
  "libraryWithNosOfBooks": "1 No (8192)",
  "simulatorAreaForMockExercise": "NA",
  "sandModelRoom": {
    "traditional": "NA",
    "digital3D": "NA"
  },
  "paradeGroundWithArea": "5 Parade Grounds available 1) A Ground-2.26 Acres, 2) B1 ground-2.07 Acres, 3) B2- ground-1.46 Acres, 4) C-Ground -3.81 Acres Hockey ground- 1.26 Acres. Total- 10.86 Acres",
  "totalParadeGroundArea": "10.86 Acres",
  "gymnasium": "1 No. 4000 Sqfts.",
  "firingRange": {
    "long": "NA",
    "short": "NA",
    "underground": "NA",
    "baffie": "NA",
    "indoor": "NA",
    "sats": "NA"
  },
  "swimmingPoolDimensions": "1 swimming pool (Length - 25mtrs, Breadth - 15mtrs)",
  "stadiumWithSeatingCapacity": "1 No. 6500 with Hand chairs",
  "stableWithNosOfHorses": "NA",
  "residentialAccommodation": {
    "staff": "Principal - 1, Vice-principal - 1, Inspectors - 4 Nos., Sub-inspectors - 10, Hc/PC - 20, Old quarter - 01, TOTAL - 37",
    "trainee": "46 Barracks with 700 Capacity"
  },
  "facilityAvailableAtTrainingInstitution": {
    "canteen": "NA",
    "cybercafe": "NA",
    "dispensaryMIroom": "1",
    "postOffice": "NA",
    "bankATM": "NA",
    "creche": "NA"
  },
  "areaOfExpertiseOrUSP": "DSP & SCTSIs., Induction Training and Inservice Courses",
  "website": "<http://aptraining.org/>",
  "eLearningPortalEnabled": "No",
  "videoConferenceFacility": "NA",
  "studioForDevelopingAVContent": "NA"
}

Excel JSON

{
  "state": "Andhra Pradesh",
  
  "institution_type": "state",
  "institution_name": "Police Training College, Ananthapuramu",
  "institution_nameAndAddress": "Police Training College, Cantonment, Vizianagaram, Andhra Pradesh-535003",
  "institution_yearOfInception": 1908,
  
  "headOfOrganization_rankDesignation": "SP./Principal",
  "headOfOrganization_contactNo": "9121109333",
  "headOfOrganization_emailID": "[email protected]",
  "headOfOrganization_faxNo": "NA",
  
  "trainingCapacity_gosDySPAndAbove": 20,
  "trainingCapacity_ngosAsiToInsp": 50,
  "trainingCapacity_orsCtToHC": 600,
  "trainingCapacity_total": 670,
  
  "officersTrainedFY2022_23_gosDySPAndAbove": 1,
  "officersTrainedFY2022_23_ngosAsiToInsp": 531,
  "officersTrainedFY2022_23_orsCtToHC": 1446,
  "officersTrainedFY2022_23_total": 1978,
  
  "campusAreaAcres": "57.37 Acres",
  "nosOfClassroomsWithCapacity": "12 (each 60) Total 720",
  "conferenceHallRoomWithCapacity": "1 Hall/60 Capacity",
  "auditoriumWithCapacity": "2 Auditoriums (1 - 250 Nos., 2 - 500 Nos.)",
  "computerRoomWithNosOfComputers": "2 Computer Rooms (1 - 24 Nos., 2 - 36 Nos.) Total - 60 computers",
  "miniFSL": "NA",
  "libraryWithNosOfBooks": "1 No (8192)",
  "simulatorAreaForMockExercise": "NA",
  
  "sandModelRoom_traditional": "NA",
  "sandModelRoom_digital3D": "NA",
  
  "paradeGroundWithArea": "5 Parade Grounds available 1) A Ground-2.26 Acres, 2) B1 ground-2.07 Acres, 3) B2- ground-1.46 Acres, 4) C-Ground -3.81 Acres Hockey ground- 1.26 Acres. Total- 10.86 Acres",
  "totalParadeGroundArea": "10.86 Acres",
  "gymnasium": "1 No. 4000 Sqfts.",
  
  "firingRange_long": "NA",
  "firingRange_short": "NA",
  "firingRange_underground": "NA",
  "firingRange_baffie": "NA",
  "firingRange_indoor": "NA",
  "firingRange_sats": "NA",
  
  "swimmingPoolDimensions": "1 swimming pool (Length - 25mtrs, Breadth - 15mtrs)",
  "stadiumWithSeatingCapacity": "1 No. 6500 with Hand chairs",
  "stableWithNosOfHorses": "NA",
  "residentialAccommodation_staff": "Principal - 1, Vice-principal - 1, Inspectors - 4 Nos., Sub-inspectors - 10, Hc/PC - 20, Old quarter - 01, TOTAL - 37",
  "residentialAccommodation_trainee": "46 Barracks with 700 Capacity",
  
  "facilityAvailableAtTrainingInstitution_canteen": "NA",
  "facilityAvailableAtTrainingInstitution_cybercafe": "NA",
  "facilityAvailableAtTrainingInstitution_dispensaryMIroom": "1",
  "facilityAvailableAtTrainingInstitution_postOffice": "NA",
  "facilityAvailableAtTrainingInstitution_bankATM": "NA",
  "facilityAvailableAtTrainingInstitution_creche": "NA",
  
  "areaOfExpertiseOrUSP": "DSP & SCTSIs., Induction Training and Inservice Courses",
  "website": "<http://aptraining.org/>",
  "eLearningPortalEnabled": "No",
  "videoConferenceFacility": "NA",
  "studioForDevelopingAVContent": "NA"
}

Generative AI Reference to choose from MongoDB vs SQL