SELECT v.* from sn_victim as v WHERE v.publish=1 AND  1=1  AND (v.victim_date between 1577816100 AND 1609438500)  group by state_id,country_idarray(23) {
  [0]=>
  array(14) {
    ["id"]=>
    string(3) "523"
    ["victim_date"]=>
    string(10) "1583259300"
    ["country_id"]=>
    string(1) "3"
    ["state_id"]=>
    string(1) "0"
    ["name"]=>
    string(61) "Nepal: Journalist threatened for reporting bribe- negotiation"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "6"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(214) "Ajayababu Shiwakoti, the general secretary of the Nepal Press Union (NPU), received threats for his reporting on an alleged bribery scandal involving Nepal’s minister of communications and information technology."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(82) "https://samsn.ifj.org/nepal-journalist-threatened-for-reporting-bribe-negotiation/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 15:18:16"
    ["publish"]=>
    string(1) "1"
  }
  [1]=>
  array(14) {
    ["id"]=>
    string(3) "526"
    ["victim_date"]=>
    string(10) "1583086500"
    ["country_id"]=>
    string(1) "5"
    ["state_id"]=>
    string(1) "0"
    ["name"]=>
    string(45) "Pakistan: Exiled Pakistani journalist missing"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "10"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(106) "Sajid Hussain, a Pakistani journalist granted political asylum in Sweden in 2017, is reported as missing. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(67) "https://samsn.ifj.org/pakistan-exiled-pakistani-journalist-missing/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 15:32:08"
    ["publish"]=>
    string(1) "1"
  }
  [2]=>
  array(14) {
    ["id"]=>
    string(3) "510"
    ["victim_date"]=>
    string(10) "1585592100"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(1) "0"
    ["name"]=>
    string(82) "India: Supreme Court orders media to only publish official information on Covid-19"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "17"
    ["target_id"]=>
    string(1) "5"
    ["headline"]=>
    string(201) "The Supreme Court of India ordered media to only refer to, publish and broadcast the official version of the information on the health crisis, citing a need to avoid inaccuracies and widespread panic. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(104) "https://samsn.ifj.org/india-supreme-court-orders-media-to-only-publish-official-information-on-covid-19/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 14:59:07"
    ["publish"]=>
    string(1) "1"
  }
  [3]=>
  array(14) {
    ["id"]=>
    string(3) "504"
    ["victim_date"]=>
    string(10) "1583432100"
    ["country_id"]=>
    string(1) "9"
    ["state_id"]=>
    string(1) "1"
    ["name"]=>
    string(66) "Afghanistan: Television journalists wounded in deadly Kabul attack"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "7"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(66) "Afghanistan: Television journalists wounded in deadly Kabul attack"
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(88) "https://samsn.ifj.org/afghanistan-television-journalists-wounded-in-deadly-kabul-attack/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 14:48:36"
    ["publish"]=>
    string(1) "1"
  }
  [4]=>
  array(14) {
    ["id"]=>
    string(3) "507"
    ["victim_date"]=>
    string(10) "1583864100"
    ["country_id"]=>
    string(1) "8"
    ["state_id"]=>
    string(2) "13"
    ["name"]=>
    string(68) "Bangladesh: Journalist goes missing amidst controversial accusations"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "10"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(171) "Shafiqul Islam Kajol, a photographer and editor of Pakkhakal Shafiqul  is reported missing after being accused by the ruling Awami League of publishing false information. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(90) "https://samsn.ifj.org/bangladesh-journalist-goes-missing-amidst-controversial-accusations/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 14:52:58"
    ["publish"]=>
    string(1) "1"
  }
  [5]=>
  array(14) {
    ["id"]=>
    string(3) "544"
    ["victim_date"]=>
    string(10) "1589307300"
    ["country_id"]=>
    string(1) "8"
    ["state_id"]=>
    string(2) "14"
    ["name"]=>
    string(68) "Bangladesh: Daily newspaper staff charged under Digital Security Act"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "3"
    ["target_id"]=>
    string(1) "3"
    ["headline"]=>
    string(252) "Maqbool Hossain’s nephew, Sabuj Hossain filed a case at Gangni Police Station in Gangni Upazila against Meherpur Pratidin publisher Emon Ahmed, editor Yadul Momin, and joint editor Al Amin on May 13 for the newspaper’s report on a property dispute."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(90) "https://samsn.ifj.org/bangladesh-daily-newspaper-staff-charged-under-digital-security-act/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 06:16:33"
    ["publish"]=>
    string(1) "1"
  }
  [6]=>
  array(14) {
    ["id"]=>
    string(3) "506"
    ["victim_date"]=>
    string(10) "1584036900"
    ["country_id"]=>
    string(1) "8"
    ["state_id"]=>
    string(2) "16"
    ["name"]=>
    string(52) "Bangladesh: Journalist convicted after midnight raid"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "17"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(134) "Kurigram based journalist, Ariful Islam was arrested at midnight on March 13 and sentenced within a few hours by a “mobile court”."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(74) "https://samsn.ifj.org/bangladesh-journalist-convicted-after-midnight-raid/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 14:52:11"
    ["publish"]=>
    string(1) "1"
  }
  [7]=>
  array(14) {
    ["id"]=>
    string(3) "545"
    ["victim_date"]=>
    string(10) "1588616100"
    ["country_id"]=>
    string(1) "8"
    ["state_id"]=>
    string(2) "17"
    ["name"]=>
    string(122) "Bangladesh: Editor of Haorancholer Katha and district correspondent of SATV, Mohammad Mahtab Uddin Talukder, was arrested "
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "8"
    ["target_id"]=>
    string(1) "5"
    ["headline"]=>
    string(255) "On May 5, editor of Haorancholer Katha and district correspondent of SATV, Mohammad Mahtab Uddin Talukder, was arrested at his residence over his Facebook post that allegedly spread false information about Member of Parliament (MP), Mouzzam Hossain Ratan."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(76) "https://samsn.ifj.org/bangladesh-five-journalists-arrested-within-five-days/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 06:18:54"
    ["publish"]=>
    string(1) "1"
  }
  [8]=>
  array(14) {
    ["id"]=>
    string(3) "558"
    ["victim_date"]=>
    string(10) "1587147300"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "19"
    ["name"]=>
    string(59) "India: Online abuse hurled at associate editor, Tongam Rina"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "15"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(154) "Tongam Rina, the associate editor of The Arunachal Times has been the target of online trolling, and threats of physical violence in several online posts."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(80) "https://samsn.ifj.org/india-online-abuse-hurled-at-associate-editor-tongam-rina/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 06:57:56"
    ["publish"]=>
    string(1) "1"
  }
  [9]=>
  array(14) {
    ["id"]=>
    string(3) "561"
    ["victim_date"]=>
    string(10) "1589134500"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "24"
    ["name"]=>
    string(35) "India: Editor Dhaval Patel detained"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "8"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(157) "Dhaval Patel, editor and owner of Gujarati website, Face of Nation was detained by Ahmedabad Crime Branch on May 11 following an FIR being filed against him."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(82) "https://samsn.ifj.org/india-face-of-nations-editor-arrested-under-sedition-charge/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 07:02:55"
    ["publish"]=>
    string(1) "1"
  }
  [10]=>
  array(14) {
    ["id"]=>
    string(3) "563"
    ["victim_date"]=>
    string(10) "1587924900"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "26"
    ["name"]=>
    string(49) "India: Police issue FIR's against six journalists"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "3"
    ["target_id"]=>
    string(1) "3"
    ["headline"]=>
    string(196) "A detailed report in Newslaundry reveals since lockdown FIRs were filed against six journalists in Himachal Pradesh for their questioning the authorities’ preparedness to meet pandemic challenge"
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(68) "https://samsn.ifj.org/iju-concerned-over-govts-clampdown-on-journos/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 07:08:21"
    ["publish"]=>
    string(1) "1"
  }
  [11]=>
  array(14) {
    ["id"]=>
    string(3) "512"
    ["victim_date"]=>
    string(10) "1584900900"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "27"
    ["name"]=>
    string(59) "India: Kashmir unable to access COVID-19 information online"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "14"
    ["target_id"]=>
    string(1) "5"
    ["headline"]=>
    string(167) "More than eight million people living in Kashmir are unable to access reliable health information about COVID- 19 as the seven month long internet shutdown continues. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(81) "https://samsn.ifj.org/india-kashmir-unable-to-access-covid-19-information-online/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 15:05:48"
    ["publish"]=>
    string(1) "1"
  }
  [12]=>
  array(14) {
    ["id"]=>
    string(3) "552"
    ["victim_date"]=>
    string(10) "1586801700"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "32"
    ["name"]=>
    string(46) "India: Times of India sacks eighteen employees"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "4"
    ["target_id"]=>
    string(1) "3"
    ["headline"]=>
    string(175) "The Times of India sacked all its employees in the Sunday Magazine team – including nine employees from the Times of India, six from Times Life and three of Speaking Tree.  "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(93) "https://samsn.ifj.org/india-multiple-media-outlets-lay-off-staff-and-cut-pay-during-covid-19/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 06:49:45"
    ["publish"]=>
    string(1) "1"
  }
  [13]=>
  array(14) {
    ["id"]=>
    string(3) "568"
    ["victim_date"]=>
    string(10) "1590084900"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "38"
    ["name"]=>
    string(49) "India: Journalist beaten at Mohali police station"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "7"
    ["target_id"]=>
    string(1) "5"
    ["headline"]=>
    string(138) "Journalist Major Singh Punjabi from the Rozana Pehredar newspaper was severely beaten on May 22 by officers at the Mohali police station. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(94) "https://samsn.ifj.org/india-government-intensifies-clampdown-to-media-over-covid-19-reporting/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 07:16:57"
    ["publish"]=>
    string(1) "1"
  }
  [14]=>
  array(14) {
    ["id"]=>
    string(3) "513"
    ["victim_date"]=>
    string(10) "1583172900"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "41"
    ["name"]=>
    string(66) "India: Two men arrested for brutal attack on Tamil Nadu journalist"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "7"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(141) "Two men have been arrested for a brutal assault on journalist M Karthi who sustained serious head injuries an attack in Sivakasi on March 3. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(88) "https://samsn.ifj.org/india-two-men-arrested-for-brutal-attack-on-tamil-nadu-journalist/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 15:06:56"
    ["publish"]=>
    string(1) "1"
  }
  [15]=>
  array(14) {
    ["id"]=>
    string(3) "551"
    ["victim_date"]=>
    string(10) "1586974500"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "44"
    ["name"]=>
    string(82) "India: News Nations Network laid off 15 staff in the English-language digital team"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "4"
    ["target_id"]=>
    string(1) "3"
    ["headline"]=>
    string(118) "News Nations Network laid off 15 staff in the English-language digital team on April 10 without notice of termination."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(93) "https://samsn.ifj.org/india-multiple-media-outlets-lay-off-staff-and-cut-pay-during-covid-19/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 06:47:14"
    ["publish"]=>
    string(1) "1"
  }
  [16]=>
  array(14) {
    ["id"]=>
    string(3) "567"
    ["victim_date"]=>
    string(10) "1590862500"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "46"
    ["name"]=>
    string(67) "India: The Telegraph lays off 35 employees after Covid-19 pressures"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "4"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(167) "Kolkata-based English daily The Telegraph announced the shutdown of its Guwahati edition, asking staff to resign by May 31, citing the economic pressures of Covid-19. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(89) "https://samsn.ifj.org/india-the-telegraph-lays-off-35-employees-after-covid-19-pressures/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 07:15:21"
    ["publish"]=>
    string(1) "1"
  }
  [17]=>
  array(14) {
    ["id"]=>
    string(3) "503"
    ["victim_date"]=>
    string(10) "1581790500"
    ["country_id"]=>
    string(1) "5"
    ["state_id"]=>
    string(2) "48"
    ["name"]=>
    string(63) "Pakistan: Killed journalist found strangled in irrigation canal"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "11"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(186) "Aziz Memon, a journalist with Kawish Television Network (KTN) TV and Sindhi-language Daily Kawish was found dead in an irrigation waterway in Mehrabpur in Southern Sindh on February 16. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(85) "https://samsn.ifj.org/pakistan-killed-journalist-found-strangled-in-irrigation-canal/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-03-30 05:06:50"
    ["publish"]=>
    string(1) "1"
  }
  [18]=>
  array(14) {
    ["id"]=>
    string(3) "532"
    ["victim_date"]=>
    string(10) "1582740900"
    ["country_id"]=>
    string(1) "5"
    ["state_id"]=>
    string(2) "49"
    ["name"]=>
    string(61) "Pakistan : Anti-Taliban journalist gunned down in Swat Valley"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "11"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(162) "Javedullah Khan, the bureau chief for Urdu language newspaper Ausaf, was gunned down on February 25 in Matta, 40-kilometres northwest of Pakistan’s Swat Valley."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(82) "https://samsn.ifj.org/pakistan-anti-taliban-journalist-gunned-down-in-swat-valley/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 15:39:04"
    ["publish"]=>
    string(1) "1"
  }
  [19]=>
  array(14) {
    ["id"]=>
    string(3) "527"
    ["victim_date"]=>
    string(10) "1579716900"
    ["country_id"]=>
    string(1) "5"
    ["state_id"]=>
    string(2) "51"
    ["name"]=>
    string(60) "Pakistan: Journalist granted bail after two months in prison"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "8"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(192) "Azhar-ul Haq Wahid, a reporter with Channel Five TV and the newspaper Khabrain was released on bail after more than two months in jail for criticising the Pakistani government on social media."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(82) "https://samsn.ifj.org/pakistan-journalist-granted-bail-after-two-months-in-prison/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 15:33:33"
    ["publish"]=>
    string(1) "1"
  }
  [20]=>
  array(14) {
    ["id"]=>
    string(3) "539"
    ["victim_date"]=>
    string(10) "1578593700"
    ["country_id"]=>
    string(1) "2"
    ["state_id"]=>
    string(2) "68"
    ["name"]=>
    string(69) "Sri Lanka: Police refuse to file death threat complaint by journalist"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "3"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(140) "Mulleriyawa Police in the Central Province of Sri Lanka refused on January 10 to record the death threat complaint of a court correspondent."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(91) "https://samsn.ifj.org/sri-lanka-police-refuse-to-file-death-threat-complaint-by-journalist/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 15:48:22"
    ["publish"]=>
    string(1) "1"
  }
  [21]=>
  array(14) {
    ["id"]=>
    string(3) "538"
    ["victim_date"]=>
    string(10) "1579716900"
    ["country_id"]=>
    string(1) "2"
    ["state_id"]=>
    string(2) "69"
    ["name"]=>
    string(50) "Sri Lanka: Tamil journalists receive death threats"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "6"
    ["target_id"]=>
    string(1) "3"
    ["headline"]=>
    string(173) "Leaflets threatening to kill seven Tamil journalists were left at the Batticaloa Press Club and a nearby bus stop in Batticaloa, a city in the Eastern Province of Sri Lanka."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(72) "https://samsn.ifj.org/sri-lanka-tamil-journalists-receive-death-threats/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-04-03 15:47:36"
    ["publish"]=>
    string(1) "1"
  }
  [22]=>
  array(14) {
    ["id"]=>
    string(3) "542"
    ["victim_date"]=>
    string(10) "1588961700"
    ["country_id"]=>
    string(1) "9"
    ["state_id"]=>
    string(2) "92"
    ["name"]=>
    string(53) "Afghanistan: Journalist shot dead in police crossfire"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "11"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(189) "Volunteer radio presenter at Voice of Ghor Radio, Ahmad Khan Nawid, 19, was shot during a clash between police and protestors over the unfair distribution of food aid in the Ghor province. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(75) "https://samsn.ifj.org/afghanistan-journalist-shot-dead-in-police-crossfire/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2020-06-19 06:11:48"
    ["publish"]=>
    string(1) "1"
  }
}