From a 2-row sample across 5 columns.
| demo_variable | num_peop_test | num_peop_pos | percent_positive | test_rate |
|---|---|---|---|---|
| SexA_Female | 1715864 | 574768 | 0.335 | 39369.325 |
| SexB_Male | 1343902 | 466225 | 0.347 | 33779.631 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
demo_variable | categorical | Sex of patient (SexA_female; SexB_male) reported to the Health Department. Due to the small number of cases among transgender and gender-nonconforming people, data on these cases are not included in this table at this time | 0% | SexB_MaleSexA_Femaleof 2 |
num_peop_test | categorical | Cumulative count of people tested with an antibody test by sex (demo_variable) | 0% | 13439021715864of 2 |
num_peop_pos | categorical | Cumulative count of people with a positive result on an antibody test by sex (demo_variable). People are considered positive if they ever received a positive antibody result, regardless of whether they have received negative results as well | 0% | 574768466225of 2 |
percent_positive | categorical |
GET /api/datasets/bhau-5xgs GET /api/datasets/bhau-5xgs/quality GET /api/datasets/bhau-5xgs/related GET /api/columns?dataset=bhau-5xgs
test_ratenum_peop_testnum_peop_pos+2num_peop_testnum_peop_pospercent_positivetest_ratenum_peop_testnum_peop_pos+2test_ratenum_peop_testnum_peop_pos+2| Cumulative percentage of people ever tested for COVID-19 with an antibody test who tested positive by sex (demo_variable) |
| 0% |
0.3350.347of 2 |
test_rate | categorical | Cumulative rate of antibody testing per 100,000 people by sex (demo_variable) | 0% | 33779.63139369.325of 2 |