query
a pythonic query language
Sign in or create a new account.


Parameters:
Date, DateChecked, Death, DeathIncrease, Fips, Hash, Hospitalized, HospitalizedCumulative, HospitalizedCurrently, HospitalizedIncrease, InIcuCumulative, InIcuCurrently, Negative, NegativeIncrease, OnVentilatorCumulative, OnVentilatorCurrently, Pending, PosNeg, Positive, PositiveIncrease, Recovered, State, Total, TotalTestResults, TotalTestResultsIncrease

The PyQL query format is: fields @ conditions.
  fields is a field or a comma delimited list of fields.
 conditions is a condition or an and delimited list of conditions.

Both fields and conditions are made up of terms.
A term is a valid Python expression in a name space made up of: database parameters; any imported python modules; PyQL Aggregators such as Average (A), Sum (S), and Replace (R); and other domain specific terms.

About the Covid19 USA DatabaseSample Queries
This database was downloaded from the https://covidtracking.com/. Parameters are accesible with CamelCaseCompletion, Positve Results vs Number of tests in small multiples.

Deaths from Covid19 vs Date with state flag icons.

Number of Deaths in each US State with flag icons

Log New Deaths for Each State (small multiples).

Log Confirmed Cases for Each State (small multiples).

Flag Icons by WhoIsHostingThis.com