noaa_stations

Table actions

3 rows where good = 0, level = 2 and refStationId = 9416841

✎ View and edit SQL

This data as json, CSV (advanced)

stationId ▼ lat lon refStationId stationType parentGeoGroupId seq geoGroupId geoGroupName level geoGroupType abbrev good
9417624 39.6333 -123.783 9416841 S 1450 15   Westport 2     0
TWC0771 38.95 -123.73333333333005 9416841 S 1450 11   Point Arena 2     0
TWC0777 39.3 -123.8 9416841 S 1450 13   Mendocino, Mendocino Bay 2     0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [noaa_stations] (
   [stationId] TEXT PRIMARY KEY,
   [lat] FLOAT,
   [lon] FLOAT,
   [refStationId] TEXT,
   [stationType] TEXT,
   [parentGeoGroupId] TEXT,
   [seq] TEXT,
   [geoGroupId] TEXT,
   [geoGroupName] TEXT,
   [level] TEXT,
   [geoGroupType] TEXT,
   [abbrev] TEXT
, [good] INTEGER);