Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `institute_performances` ORDER BY `num_collaborative_project_publications` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id institute_id year total_staffs total_budget total_score score_by_staff score_by_budget weighted_score percentage_research_projects_completed_on_time num_national_international_collaborative_projects total_num_degrees_guided grant_received_other_than_CCRAS num_national_international_programs_organized num_policies_regulations_contributed has_accreditation_other_than_statutory num_awards_received total_num_startups_incubated num_commissioned_reports_prepared num_new_research_fields_impacting_society num_technologies_targeted_to_sdg_national_programs num_reports_new_designs_products facilities_opened_for_testing patient_services_footfall_drug_testing average_bed_occupancy num_speciality_opds num_copyrights_trademarks_patents num_technologies_transferred_domestic_international num_new_products_services_in_market num_publications_in_peer_reviewed_journals num_citations_in_last_three_years num_collaborative_project_publications Descending Ascending 1 percentage_publications_in_indexed_journals num_books_ebooks_monographs num_audio_visual_materials_produced adopted_digital_technologies_ai website_is_accessible_and_secure percentage_budget_returned_unutilized percentage_budget_on_rnd_to_overall_budget total_annual_earnings percentage_permanent_scientists_contractual_researchers percentage_young_women_scientists_researchers support_for_women_young_scientists_training num_scientists_deputed_for_training num_skill_development_programs num_training_workshops_cmes num_persons_attended_skill_development_training num_officers_trained_in_advanced_areas num_iec_awareness_programs num_hindi_activities num_swachata_action_plan num_days_weeks_celebrations celebrates_national_international_days conducts_regular_review_meetings completed_activities_as_per_calendar total_count status created_at updated_at percentage_research_projects_completed_on_time_page_no num_national_international_collaborative_projects_page_no total_num_degrees_guided_page_no grant_received_other_than_CCRAS_page_no num_national_international_programs_organized_page_no num_policies_regulations_contributed_page_no has_accreditation_other_than_statutory_page_no num_awards_received_page_no total_num_startups_incubated_page_no num_commissioned_reports_prepared_page_no num_new_research_fields_impacting_society_page_no num_technologies_targeted_to_sdg_national_programs_page_no num_reports_new_designs_products_page_no facilities_opened_for_testing_page_no patient_services_footfall_drug_testing_page_no average_bed_occupancy_page_no num_speciality_opds_page_no num_copyrights_trademarks_patents_page_no num_technologies_transferred_domestic_international_page_no num_new_products_services_in_market_page_no num_publications_in_peer_reviewed_journals_page_no num_citations_in_last_three_years_page_no num_collaborative_project_publications_page_no percentage_publications_in_indexed_journals_page_no num_books_ebooks_monographs_page_no num_audio_visual_materials_produced_page_no adopted_digital_technologies_ai_page_no website_is_accessible_and_secure_page_no percentage_budget_returned_unutilized_page_no percentage_budget_on_rnd_to_overall_budget_page_no total_annual_earnings_page_no percentage_permanent_scientists_contractual_researchers_page_no percentage_young_women_scientists_researchers_page_no support_for_women_young_scientists_training_page_no num_scientists_deputed_for_training_page_no num_skill_development_programs_page_no num_training_workshops_cmes_page_no num_persons_attended_skill_development_training_page_no num_officers_trained_in_advanced_areas_page_no num_iec_awareness_programs_page_no num_hindi_activities_page_no num_swachata_action_plan_page_no num_days_weeks_celebrations_page_no celebrates_national_international_days_page_no conducts_regular_review_meetings_page_no completed_activities_as_per_calendar_page_no
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 14
14 9 2025 106 12.48 65.50 0.62 5.25 0.05 2.00 3.00 2.00 2.00 2.00 2.00 4.00 0.50 0.00 0.50 3.00 0.50 1.00 2.00 2.00 1.00 2.00 1.00 0.00 0.00 3.00 3.00 2.00 1.50 3.00 2.00 1.00 1.00 3.00 1.00 1.00 0.50 1.00 1.00 1.00 1.00 2.00 1.00 0.00 1.00 0.00 0.00 1.00 1.00 1.00 2.00 65.50 active 2025-08-08 13:15:25 2025-08-08 13:15:25 9 10 6 337 7 6, 323 6, 12, 169, 322 37 Got approval to set up an Incubation centre at CAR... 9,22, 97 6 13 13, 272, 273 11, 13 8 8 4 27,336 NULL NULL 5, 30,31 5 32, 33, 182 5 36,37 13, 171 13 6 6 5 5 6 5 5 5,7 7, 169,170 7,169,170 7 NULL 8 NULL NULL 7, 307-311 307, 310 Not mentioned in the Annual Report but meeting reg... 307-311
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 6
6 8 2024 136 6.66 56.00 0.41 8.41 0.06 2.00 3.00 1.00 1.00 2.00 0.00 4.00 2.00 0.00 0.00 0.00 0.00 0.00 2.00 3.00 1.00 1.00 0.00 0.00 0.00 5.00 3.00 1.00 2.00 4.00 2.00 0.00 0.00 2.00 1.00 0.50 0.50 0.50 1.00 1.00 0.00 1.00 0.50 0.00 1.00 2.00 2.00 1.00 1.00 1.00 1.00 56.00 active 2025-02-11 12:26:57 2025-02-11 12:26:57 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 10
10 14 2024 62 4.14 39.75 0.64 9.60 0.15 2.00 2.00 0.00 0.00 0.00 0.00 2.00 0.50 0.00 0.50 2.00 1.00 0.50 0.50 2.00 0.50 1.00 0.00 0.00 0.00 1.00 3.00 1.00 2.00 0.00 2.00 1.00 0.00 3.00 1.00 0.50 0.25 0.25 1.00 0.50 0.50 2.00 0.25 0.00 1.00 0.00 0.00 1.00 1.00 1.00 2.00 39.75 active 2025-03-03 06:23:32 2025-03-03 06:23:32 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 12
12 19 2025 146 9.22 36.40 0.25 3.95 0.03 2.00 2.00 0.00 1.00 0.50 0.00 4.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.00 1.00 0.00 0.00 0.00 0.00 5.00 3.00 1.00 2.00 1.00 0.00 0.00 0.00 3.00 1.00 1.00 0.50 0.00 0.00 0.00 0.20 1.00 0.20 0.00 0.50 0.00 0.00 1.00 1.00 1.00 1.00 36.40 active 2025-08-07 12:09:18 2025-08-07 12:09:18 6 48,180,181 NULL 164 14,15 NULL 19, 158, 183 NULL NULL NULL NULL NULL NULL NULL 52 63 NULL NULL NULL NULL 6-10 6-10 9 6-10 11 NULL NULL NULL 3 3 3 1 NULL NULL NULL 207-208 15 207-208 NULL 18-19 NULL NULL 208 208 208 208
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 13
13 23 2025 52 13.28 25.50 0.49 1.92 0.04 0.00 1.00 0.00 1.00 0.00 0.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.00 0.00 0.00 0.00 0.00 0.00 1.00 2.00 1.00 2.00 0.00 0.00 0.00 0.00 3.00 1.00 0.50 0.50 0.25 0.00 0.00 1.00 0.00 0.25 0.00 1.00 0.00 0.00 1.00 1.00 1.00 2.00 25.50 active 2025-08-08 12:38:27 2025-08-08 12:38:27 10 94 NULL 94 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 39 NULL 53 NULL NULL NULL 11 NULL 11 11 NULL NULL NULL NULL 7-8 NULL 6 3-5 NULL NULL NULL 13 NULL NULL NULL 15-16 NULL NULL 13 13 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 15
15 23 2024 52 13.56 26.20 0.50 1.93 0.04 2.00 1.00 0.00 1.00 0.50 0.00 0.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.00 0.00 0.00 0.00 0.00 0.00 1.00 0.00 1.00 2.00 1.00 0.00 0.00 0.00 3.00 1.00 0.50 0.50 1.00 0.00 0.00 1.00 0.00 0.20 0.00 1.00 0.00 0.00 1.00 1.00 1.00 2.00 26.20 active 2025-08-08 13:42:14 2025-08-08 13:42:14 16-17 94 NULL 94 20 NULL NULL NULL NULL NULL NULL NULL NULL NULL 56 NULL 63 NULL NULL NULL 18 NULL NULL NULL 19 NULL NULL NULL 13-14 NULL 12 9-11 NULL NULL NULL 104 NULL NULL NULL 25-26 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 1
1 3 2024 133 7.89 72.50 0.55 9.19 0.07 2.00 3.00 1.00 1.00 2.00 0.50 4.00 2.00 1.00 0.50 3.00 0.50 0.50 2.00 3.00 1.00 2.00 1.00 1.00 1.00 5.00 3.00 0.00 2.00 3.00 2.00 1.00 0.00 3.00 1.00 3.00 0.50 1.00 1.00 1.00 1.00 2.00 1.00 1.00 1.00 2.00 1.00 1.00 1.00 1.00 2.00 72.50 active 2025-02-10 05:33:42 2025-02-10 05:33:42 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 2
2 4 2024 78 4.41 63.50 0.81 14.40 0.18 2.00 2.00 3.00 1.00 2.00 2.00 5.00 0.50 0.00 2.00 3.00 0.50 0.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 5.00 3.00 0.00 2.00 4.00 2.00 1.00 0.00 3.00 1.00 2.00 1.00 1.00 1.00 0.00 0.25 2.00 0.25 0.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00 63.50 active 2025-02-10 06:37:17 2025-02-10 06:37:17 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 3
3 5 2024 136 8.57 59.75 0.44 6.97 0.05 2.00 3.00 3.00 0.00 0.50 0.00 2.00 1.00 0.00 2.00 3.00 0.00 0.00 2.00 3.00 1.00 2.00 1.00 0.00 0.00 3.00 3.00 0.00 1.00 3.00 2.00 0.00 1.00 3.00 1.00 0.50 0.50 1.00 1.00 1.00 0.25 2.00 1.00 0.00 1.00 2.00 2.00 1.00 1.00 1.00 2.00 59.75 active 2025-02-11 12:15:21 2025-02-11 12:15:21 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 4
4 6 2024 87 4.42 59.00 0.68 13.35 0.15 2.00 2.00 3.00 1.00 2.00 0.00 4.00 2.00 0.00 0.00 0.00 0.00 0.00 2.00 2.00 0.50 1.00 0.00 0.00 0.00 5.00 3.00 0.00 2.00 4.00 2.00 1.00 0.00 3.00 1.00 0.50 0.50 0.50 1.00 0.50 1.00 2.00 0.50 0.00 1.00 2.00 2.00 1.00 1.00 1.00 2.00 59.00 active 2025-02-11 12:19:48 2025-02-11 12:19:48 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 7
7 12 2024 101 4.95 48.25 0.48 9.75 0.10 2.00 3.00 3.00 0.00 2.00 0.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.00 0.50 1.00 0.00 0.00 0.00 5.00 3.00 0.00 2.00 4.00 2.00 0.00 0.00 3.00 1.00 0.00 0.25 0.25 0.25 0.00 0.00 1.00 0.00 0.00 1.00 2.00 2.00 1.00 1.00 1.00 2.00 48.25 active 2025-02-13 06:05:52 2025-02-13 06:05:52 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 9
9 13 2024 36 2.40 42.75 1.19 17.81 0.49 2.00 3.00 0.00 0.00 0.50 0.00 1.00 1.00 0.00 2.00 3.00 0.00 0.00 2.00 3.00 1.00 1.00 0.00 0.00 0.00 1.00 3.00 0.00 2.00 0.00 2.00 0.00 0.00 3.00 1.00 0.50 0.50 1.00 1.00 1.00 0.25 1.00 1.00 0.00 1.00 2.00 2.00 1.00 0.00 1.00 2.00 42.75 active 2025-02-15 16:56:25 2025-02-15 18:30:57 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 11
11 31 2024 37 2.86 20.75 0.56 7.26 0.20 2.00 0.00 0.00 1.00 0.50 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 1.00 0.00 0.00 3.00 1.00 0.00 0.50 1.00 1.00 0.00 0.00 0.50 0.25 0.00 1.00 0.00 0.00 1.00 1.00 0.00 2.00 20.75 active 2025-08-06 15:32:38 2025-08-06 15:32:38 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 16
16 16 2025 17 5.36 24.75 1.46 4.62 0.27 2.00 0.00 0.00 0.00 0.00 0.00 3.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 3.00 2.00 1.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 3.00 0.25 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.50 1.00 0.00 0.00 1.00 1.00 1.00 2.00 24.75 active 2025-08-08 15:13:28 2025-08-08 15:13:28 6 NULL NULL NULL NULL NULL 176, 215 228 NULL NULL NULL NULL NULL NULL 116 126 127,133 NULL NULL NULL 11 NULL NULL NULL NULL NULL NULL NULL 3 3 NULL NULL NULL NULL NULL NULL NULL 0 15-25 26-27 NULL NULL 172-173 172-173 172-173 172-173
Edit Edit Copy Copy Delete Delete
DELETE FROM institute_performances WHERE `institute_performances`.`id` = 17
17 26 2025 18 6.08 45.83 2.55 7.54 0.42 2.00 2.00 3.00 0.00 0.50 0.00 4.00 0.00 0.00 0.00 3.00 0.00 0.00 2.00 3.00 0.33 0.00 0.00 0.00 0.00 4.00 3.00 0.00 2.00 1.00 0.00 0.00 0.00 3.00 1.00 0.50 1.00 0.50 1.00 0.50 1.00 0.50 0.00 1.00 1.00 0.00 0.00 1.00 1.00 1.00 2.00 45.83 active 2025-08-08 15:29:27 2025-08-08 15:29:27 5-7 5-7 4 0 13 0 96 0 0 0 96 0 0 4 4 0 0 0 0 0 8-10 8-12 0 8-12 11 0 0 0 4 5-7 4 1-3 1-3 14 16 13 13 0 4 97-112 NULL NULL 97-133 97-133 134-138 96-134
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query