Water Quality

Insights into Water Quality: An In-depth Examination

@kaggle.sukhmandeepsinghbrar_water_quality

Table List

1 table(48.15 MB)

Water Quality 1

@kaggle.sukhmandeepsinghbrar_water_quality.water_quality_1

48.15 MB
1259444 rows
25 columns

sample_id Sample ID	grab_id Grab ID	profile_id Profile ID	sample_number Sample Number	collect_datetime Collect DateTime	depth_m Depth (m)	site_type Site Type	area Area	locator Locator	site Site	parameter Parameter	value Value	units Units	qualityid QualityId	lab_qualifier Lab Qualifier	mdl MDL	rdl RDL	text_value Text Value	sample_info Sample Info	steward_note Steward Note	method Method	date_analyzed Date Analyzed	data_source Data Source
16316	16316	10702	9209019	04/13/1992 12:00:00 AM	1	Streams and Rivers	Pipers	KSHZ06	Pipers Creek mouth	Total Phosphorus	0.07	mg/L	2	nan			.070\|\|King County Nstream Database/B53311	nan	nan	none		KCEL
8937	8937	37688	7915489	06/20/1979 12:00:00 AM	1	Streams and Rivers	Crisp	0321	Crisp Creek mouth at SE Green Valley Rd	Nitrite + Nitrate Nitrogen	0.727	mg/L	2	nan			.727\|\|King County Nstream Database/RS2	nan	nan	nan		KCEL
137745	137745	54368	L58228-1	06/25/2013 08:09:00 AM	1	Large Lakes	Lake Union/Ship Canal	0512	Ship Canal above locks	Temperature	18.9	deg C	2	nan			nan	nan	nan	HYDROLAB	Tue Jun 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	KCEL
131816	131816	50605	L55068-6	02/13/2012 09:38:00 AM	1	Large Lakes	Lake Union/Ship Canal	0540	Ship Canal near Montlake Bridge	Orthophosphate Phosphorus	0.00724	mg/L	2	nan	0.002	0.005	nan	nan	nan	SM4500-P-F	Wed Feb 15 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	KCEL
82325	82325	43896	L52933-87	03/30/2011 02:36:00 PM	4.2	Large Lakes	Lake Washington	0804	Lake Washington north end	Temperature	8.94	deg C	2	nan			nan	nan	nan	HYDROLAB		KCEL
60091	60091	42106	L29749-54	09/02/2003 01:44:00 PM	1	Large Lakes	Lake Washington	0852	Lake Washington Madison Park	Temperature	21.9	deg C	2	nan			nan	nan	nan	nan		KCEL
156539		68254	L70197-1	06/12/2018 08:55:00 AM		Streams and Rivers	Idylwood	A620	Idylwood Creek mouth at Idylwood Park	Orthophosphate Phosphorus	0.0832	mg/L	2	nan	0.0005	0.002	nan	nan	nan	SM4500-P-F	Thu Jun 14 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	KCEL
64045	64045	41210	L47565-69	03/09/2009 12:50:00 PM	18	Large Lakes	Lake Washington	0852	Lake Washington Madison Park	Conductivity Field	97.3	umhos/cm	2	nan	0.5	10	nan	nan	nan	HYDROLAB (SOP 205V4)		KCEL
41265	41265	40681	L48174-26	05/27/2009 10:18:00 AM	1	Large Lakes	Lake Sammamish	0611	Lake Sammamish mid-lake north	Conductivity Field	104	umhos/cm	2	nan	0.5	10	nan	nan	nan	HYDROLAB		KCEL
22772		19978	L19003-1	10/12/2000 09:42:00 AM		Streams and Rivers	Longfellow	C370	Longfellow Creek at SW Yancy St	Storm Or Non-Storm		none	2	nan			N	nan	nan	NONE		KCEL


CREATE TABLE water_quality_1 (
  "sample_id" BIGINT,
  "grab_id" DOUBLE,
  "profile_id" BIGINT,
  "sample_number" VARCHAR,
  "collect_datetime" VARCHAR,
  "depth_m" DOUBLE,
  "site_type" VARCHAR,
  "area" VARCHAR,
  "locator" VARCHAR,
  "site" VARCHAR,
  "parameter" VARCHAR,
  "value" DOUBLE,
  "units" VARCHAR,
  "qualityid" BIGINT,
  "lab_qualifier" VARCHAR,
  "mdl" DOUBLE,
  "rdl" DOUBLE,
  "text_value" VARCHAR,
  "sample_info" VARCHAR,
  "steward_note" VARCHAR,
  "replicates" DOUBLE,
  "replicate_of" DOUBLE,
  "method" VARCHAR,
  "date_analyzed" TIMESTAMP,
  "data_source" VARCHAR
);