?$select=count(*)
$group=upper(offender_race)&$select=upper(offender_race),count(*)
Dates need to be enclosed in quotes:
?$where=expiration_date>'2020-01-01T00:00:00'
Concatenate columns in $select:
| $select=*, primary_county_lat | "," | primary_county_long AS coordinates |
?naicgroupname=HEALTH CARE %26 SOCIAL ASSISTANCE (I)