DataError on pyctd.update() #25
Description
Getting the following error on pyctd.update():
DataError Traceback (most recent call last)
<ipython-input-7-0bd0285b3ed5> in <module>()
----> 1 pyctd.update()
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in update(connection, urls, force_download)
451 """
452 db = DbManager(connection)
--> 453 db.db_import(urls=urls, force_download=force_download)
454 db.session.close()
455
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in db_import(self, urls, force_download)
177 self.download_urls(urls=urls, force_download=force_download)
178 self.create_all()
--> 179 self.import_tables()
180 self.session.close()
181
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in import_tables(self, only_tables, exclude_tables)
233 if exclude_tables is not None and table.name in exclude_tables:
234 continue
--> 235 self.import_table(table)
236
237 @classmethod
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in import_table(self, table)
289 )
290
--> 291 self.import_table_in_db(file_path, use_columns_with_index, column_names_in_db, table)
292
293 for column_in_file, column_in_one2many_table in table.one_to_many:
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pyctd/manager/database.pyc in import_table_in_db(self, file_path, use_columns_with_index, column_names_in_db, table)
391
392 table_with_prefix = defaults.TABLE_PREFIX + table.name
--> 393 chunk.to_sql(name=table_with_prefix, if_exists='append', con=self.engine)
394
395 del chunks
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/core/generic.pyc in to_sql(self, name, con, schema, if_exists, index, index_label, chunksize, dtype, method)
2529 sql.to_sql(self, name, con, schema=schema, if_exists=if_exists,
2530 index=index, index_label=index_label, chunksize=chunksize,
-> 2531 dtype=dtype, method=method)
2532
2533 def to_pickle(self, path, compression='infer',
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/io/sql.pyc in to_sql(frame, name, con, schema, if_exists, index, index_label, chunksize, dtype, method)
458 pandas_sql.to_sql(frame, name, if_exists=if_exists, index=index,
459 index_label=index_label, schema=schema,
--> 460 chunksize=chunksize, dtype=dtype, method=method)
461
462
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/io/sql.pyc in to_sql(self, frame, name, if_exists, index, index_label, schema, chunksize, dtype, method)
1172 schema=schema, dtype=dtype)
1173 table.create()
-> 1174 table.insert(chunksize, method=method)
1175 if (not name.isdigit() and not name.islower()):
1176 # check for potentially case sensitivity issues (GH7815)
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/io/sql.pyc in insert(self, chunksize, method)
684
685 chunk_iter = zip(*[arr[start_i:end_i] for arr in data_list])
--> 686 exec_insert(conn, keys, chunk_iter)
687
688 def _query_iterator(self, result, chunksize, columns, coerce_float=True,
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pandas/io/sql.pyc in _execute_insert(self, conn, keys, data_iter)
597 """
598 data = [dict(zip(keys, row)) for row in data_iter]
--> 599 conn.execute(self.table.insert(), data)
600
601 def _execute_insert_multi(self, conn, keys, data_iter):
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in execute(self, object_, *multiparams, **params)
986 raise exc.ObjectNotExecutableError(object_)
987 else:
--> 988 return meth(self, multiparams, params)
989
990 def _execute_function(self, func, multiparams, params):
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/sql/elements.pyc in _execute_on_connection(self, connection, multiparams, params)
285 def _execute_on_connection(self, connection, multiparams, params):
286 if self.supports_execution:
--> 287 return connection._execute_clauseelement(self, multiparams, params)
288 else:
289 raise exc.ObjectNotExecutableError(self)
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_clauseelement(self, elem, multiparams, params)
1105 distilled_params,
1106 compiled_sql,
-> 1107 distilled_params,
1108 )
1109 if self._has_events or self.engine._has_events:
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args)
1246 except BaseException as e:
1247 self._handle_dbapi_exception(
-> 1248 e, statement, parameters, cursor, context
1249 )
1250
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _handle_dbapi_exception(self, e, statement, parameters, cursor, context)
1464 util.raise_from_cause(newraise, exc_info)
1465 elif should_wrap:
-> 1466 util.raise_from_cause(sqlalchemy_exception, exc_info)
1467 else:
1468 util.reraise(*exc_info)
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/util/compat.pyc in raise_from_cause(exception, exc_info)
396 exc_type, exc_value, exc_tb = exc_info
397 cause = exc_value if exc_value is not exception else None
--> 398 reraise(type(exception), exception, tb=exc_tb, cause=cause)
399
400
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args)
1222 if not evt_handled:
1223 self.dialect.do_executemany(
-> 1224 cursor, statement, parameters, context
1225 )
1226 elif not parameters and context.no_parameters:
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyc in do_executemany(self, cursor, statement, parameters, context)
130
131 def do_executemany(self, cursor, statement, parameters, context=None):
--> 132 rowcount = cursor.executemany(statement, parameters)
133 if context is not None:
134 context._rowcount = rowcount
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/cursors.pyc in executemany(self, query, args)
195 return self._do_execute_many(q_prefix, q_values, q_postfix, args,
196 self.max_stmt_length,
--> 197 self._get_db().encoding)
198
199 self.rowcount = sum(self.execute(query, arg) for arg in args)
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/cursors.pyc in _do_execute_many(self, prefix, values, postfix, args, max_stmt_length, encoding)
227 v = v.encode(encoding, 'surrogateescape')
228 if len(sql) + len(v) + len(postfix) + 1 > max_stmt_length:
--> 229 rows += self.execute(sql + postfix)
230 sql = bytearray(prefix)
231 else:
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/cursors.pyc in execute(self, query, args)
168 query = self.mogrify(query, args)
169
--> 170 result = self._query(query)
171 self._executed = query
172 return result
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/cursors.pyc in _query(self, q)
326 self._last_executed = q
327 self._clear_result()
--> 328 conn.query(q)
329 self._do_get_result()
330 return self.rowcount
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/connections.pyc in query(self, sql, unbuffered)
515 sql = sql.encode(self.encoding, 'surrogateescape')
516 self._execute_command(COMMAND.COM_QUERY, sql)
--> 517 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
518 return self._affected_rows
519
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/connections.pyc in _read_query_result(self, unbuffered)
730 else:
731 result = MySQLResult(self)
--> 732 result.read()
733 self._result = result
734 if result.server_status is not None:
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/connections.pyc in read(self)
1073 def read(self):
1074 try:
-> 1075 first_packet = self.connection._read_packet()
1076
1077 if first_packet.is_ok_packet():
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/connections.pyc in _read_packet(self, packet_type)
682
683 packet = packet_type(buff, self.encoding)
--> 684 packet.check_error()
685 return packet
686
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/protocol.pyc in check_error(self)
218 errno = self.read_uint16()
219 if DEBUG: print("errno =", errno)
--> 220 err.raise_mysql_exception(self._data)
221
222 def dump(self):
/Volumes/MacHD/anaconda3/envs/SC/lib/python2.7/site-packages/pymysql/err.pyc in raise_mysql_exception(data)
107 errval = data[3:].decode('utf-8', 'replace')
108 errorclass = error_map.get(errno, InternalError)
--> 109 raise errorclass(errno, errval)
DataError: (pymysql.err.DataError) (1264, u"Out of range value for column 'number_of_receptors' at row 1520")
[SQL: INSERT INTO pyctd_exposure_event (id, stressor_source_category, stressor_source_details, number_of_stressor_samples, stress_or_notes, number_of_receptors, receptors, receptor_notes, smoking_status, age, age_units_of_measurement, age_qualifier, sex, race, methods, detection_limit, detection_limit_uom, detection_frequency, medium, exposure_marker, exposure_marker_id, marker_level, marker_units_of_measurement, marker_measurement_statistic, assay_notes, study_countries, state_or_province, city_town_region_area, exposure_event_notes, outcome_relationship, phenotype_name, phenotype_id, phenotype_action_degree_type, anatomy, exposure_outcome_notes, reference, associated_study_titles, enrollment_start_year, enrollment_end_year, study_factors, chemical__id, disease__id) VALUES (%(id)s, %(stressor_source_category)s, %(stressor_source_details)s, %(number_of_stressor_samples)s, %(stress_or_notes)s, %(number_of_receptors)s, %(receptors)s, %(receptor_notes)s, %(smoking_status)s, %(age)s, %(age_units_of_measurement)s, %(age_qualifier)s, %(sex)s, %(race)s, %(methods)s, %(detection_limit)s, %(detection_limit_uom)s, %(detection_frequency)s, %(medium)s, %(exposure_marker)s, %(exposure_marker_id)s, %(marker_level)s, %(marker_units_of_measurement)s, %(marker_measurement_statistic)s, %(assay_notes)s, %(study_countries)s, %(state_or_province)s, %(city_town_region_area)s, %(exposure_event_notes)s, %(outcome_relationship)s, %(phenotype_name)s, %(phenotype_id)s, %(phenotype_action_degree_type)s, %(anatomy)s, %(exposure_outcome_notes)s, %(reference)s, %(associated_study_titles)s, %(enrollment_start_year)s, %(enrollment_end_year)s, %(study_factors)s, %(chemical__id)s, %(disease__id)s)]
[parameters: ({'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '10th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 1, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '25th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 2, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '50th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 3, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '75th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 4, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '90th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 5, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.04', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '95th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 6, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.04', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 63.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '99th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 7, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'February 2001', 'marker_level': '0.04', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '1.1', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'}, {'number_of_receptors': 78.0, 'anatomy': None, 'methods': 'gas chromatography mass spectrometry', 'reference': 15743726.0, 'marker_units_of_measurement': 'nanograms per milliliter', 'number_of_stressor_samples': None, 'marker_measurement_statistic': '10th percentile', 'age_units_of_measurement': 'years', 'associated_study_titles': 'The School Health Initiative: Environment, Learning, Disease (SHIELD)', 'study_factors': None, 'id': 8, 'enrollment_start_year': 2001.0, 'city_town_region_area': 'Minneapolis', 'receptor_notes': None, 'enrollment_end_year': 2001.0, 'smoking_status': 'Non-smoker', 'receptors': 'Children', 'exposure_marker': '1,1,1-trichloroethane', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United States', 'medium': 'blood', 'age_qualifier': 'range', 'exposure_marker_id': 'C024566', 'phenotype_id': None, 'exposure_event_notes': 'May 2001', 'marker_level': '0.03', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': 'Minnesota', 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Commercial product|Dietary|Environmental', 'detection_limit': '0.024', 'detection_frequency': '2.2', 'chemical__id': 745, 'race': 'American Indian 3 | Asian 6 | Black 63 | Hispanic 20 | White 7', 'assay_notes': None, 'age': '6-10', 'detection_limit_uom': 'nanograms per milliliter'} ... displaying 10 of 142715 total bound parameter sets ... {'number_of_receptors': 132.0, 'anatomy': None, 'methods': 'inductively coupled plasma mass spectrometry', 'reference': 25151427.0, 'marker_units_of_measurement': None, 'number_of_stressor_samples': None, 'marker_measurement_statistic': 'median', 'age_units_of_measurement': None, 'associated_study_titles': None, 'study_factors': None, 'id': 142714, 'enrollment_start_year': None, 'city_town_region_area': 'Buxton Derbyshire', 'receptor_notes': 'Adults, occupationally unexposed', 'enrollment_end_year': None, 'smoking_status': None, 'receptors': 'Study subjects', 'exposure_marker': 'Zirconium', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United Kingdom', 'medium': 'urine', 'age_qualifier': None, 'exposure_marker_id': 'D015040', 'phenotype_id': None, 'exposure_event_notes': None, 'marker_level': '<LOQ', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': None, 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Environmental', 'detection_limit': '0.945', 'detection_frequency': '4.0', 'chemical__id': 170653, 'race': None, 'assay_notes': 'LOQ = three times the standard deviation of all blank samples run throughout analyses multiplied by dilution factor of urine sample (varied from 10 to 20)', 'age': None, 'detection_limit_uom': 'micrograms per liter'}, {'number_of_receptors': 132.0, 'anatomy': None, 'methods': 'inductively coupled plasma mass spectrometry', 'reference': 25151427.0, 'marker_units_of_measurement': None, 'number_of_stressor_samples': None, 'marker_measurement_statistic': 'median', 'age_units_of_measurement': None, 'associated_study_titles': None, 'study_factors': None, 'id': 142715, 'enrollment_start_year': None, 'city_town_region_area': 'Buxton Derbyshire', 'receptor_notes': 'Adults, occupationally unexposed', 'enrollment_end_year': None, 'smoking_status': None, 'receptors': 'Study subjects', 'exposure_marker': 'Zirconium', 'phenotype_action_degree_type': None, 'disease__id': None, 'stress_or_notes': None, 'stressor_source_details': None, 'study_countries': 'United Kingdom', 'medium': 'urine', 'age_qualifier': None, 'exposure_marker_id': 'D015040', 'phenotype_id': None, 'exposure_event_notes': None, 'marker_level': '<LOQ', 'exposure_outcome_notes': None, 'sex': 'Both Males and Females', 'state_or_province': None, 'phenotype_name': None, 'outcome_relationship': None, 'stressor_source_category': 'Environmental', 'detection_limit': '0.945', 'detection_frequency': '4.0', 'chemical__id': 170653, 'race': None, 'assay_notes': 'LOQ = three times the standard deviation of all blank samples run throughout analyses multiplied by dilution factor of urine sample (varied from 10 to 20)', 'age': None, 'detection_limit_uom': 'micrograms per liter'})]
(Background on this error at: http://sqlalche.me/e/9h9h)