censys | Python code to query the Censys public scan database | Chat library

I'd like to use JQ to grab only the sub-records that match an if-then statement. When I use

jq 'if .services[].banner == "FQMDAAICCg==" then .services[].port else empty end

it grabs all of the ports for the record. (there are multiple services under each record and I want to restrict my then statement to only the services scope where I actually found the if condition).

How do I just get the port, banner, etc. for the specific service underneath the record which hit my condition?

example:

I need to make a query for a dataset provided by a public project. I created my own project and added their dataset to my project. There is a table named: domain_public. When I make query to this table I get this error:

I don't know how to ask questions about my current problem so I think, that is why I couldn't find the right answer. So please let me tell you what my problem is.

I am trying to do a simple internet port scanner by using Zmap and Zgrab like Shodan.io,like censys.io etc.

I need to store the data inside of the ElasticSearch(because I want to learn how to use it).

In this case;

I have created a JSON architecture to use it in ElasticSearch such as

I have access to the following project's dataset. The data get updated daily. The table ends with the date and we can query any snapshot by specifying the date. When I query 20180828 table, I get this error:

I added a public database that uses standard sql. It appears as follows:

I add #standardsql in addition I changed that from the settings. The query looks like:

We're using the Text-finder Plugin in our installation. I created a job that runs the testssh.sh script that tests for SSL vulnerability and it produces an output like...

I am one Week into BQ now (for my Master Thesis) and after many hours of reading docs I am now hanging at this point:

I use the censys Datasets and want to count the number of hosts with ports open in country 'AT', 'DE', 'CH'. So far I got it working for each country itself. But so save Costs (maybe) I want to count it for all 3 countries at once. Or when I can't save costs with this approach I can stay with my first solution and iterate over it for every country.

Currently working for one Country at a time: