(for ((i=7; $i<170; i++)) ; do cut -d, -f$i-$i bar.txt ; (tail +3 $wfile | cut -d, -f$i-$i | egrep '^[ 9\.\+\-]+$' | sort -u) ; done) | more IDENTIFICATION: Identification header IDENTIFICATION WIND CEILING VISIBILITY TEMP DEWPT SLP PRECIP PRECIP PRECIP PRECIP PCPHST SNOW SNOWFALL SNOWFALL SNOWFALL SNOWFALL WX-A PSWX-M PSWX-M PSWX-A PSWX-A RUNWAY SKY CONDITION SUN GRND EXT TEMP EXT TEMP PRESSURE PRES CHG WXV WXV WXV WXV WXV WXV WXV WX-M WX-M WX-M WX-M WX-M WX-M WX-M WND-SUPP WND-SUPP WND-SUPP GUST Name USAF NCDC Date HrMn I Type Dir Q I Spd Q Hgt Q I I Visby Q I Q Temp Q Dewpt Q Slp Q Pr Amt I Q Pr Amt I Q Pr Amt I Q Pr Amt I Q D C Q Dpth I Q Wteq I Q Pr Amt I Q Pr Amt I Q Pr Amt I Q Pr Amt I Q Wx Q C Q Pr Q C Q Pr Q C Q Pr Q C Q Pr Q Dr C Rvr Q Cv Op Q Cl Q Lo Q Hgt Q Mi Q Hi Q Dur Q Cd Q Pr I Temp Q Pr I Temp Q Alt Q Stp Q T Q 3Hr Q 24Hr Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q Wx Q T Pr Spd Q T Pr Spd Q T Pr Spd Q Spd Q CHICAGO OHARE INTL AP ,999999,94846,19700101,0000,E, SAO,020,5,N, 2.6,5,00610,4,9,N,012800,5,9,9, -1.7,4, -3.9,5,1018.8,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,06,06,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 993.6,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9, ,9, ,9, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, 123456789012345678901234567890 123456 12345 12345678 1235 1 12345 123 1 12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345 CHICAGO OHARE INTL AP ,999999,94846,19700207,0900,E, SAO,190,5,N, 3.6,5,02438,4,9,N,009600,5,9,9, 0.0,4, -2.2,5,1027.8,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9,1002.4,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5, ,9, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700207,1200,E, SAO,200,5,N, 5.2,5,00183,4,9,N,006400,5,9,9, -0.6,4, -2.2,5,1026.1,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9,1000.7,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700207,1500,E, SAO,160,5,N, 3.1,5,00091,4,9,N,001300,5,9,9, 0.0,4, -1.1,5,1024.7,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 999.3,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,56,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700207,1800,E, SAO,170,5,N, 2.1,5,00091,4,9,N,000800,5,9,9, 2.2,4, 0.6,5,1023.6,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 998.3,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700207,2100,E, SAO,190,5,N, 2.1,5,00091,4,9,N,004000,5,9,9, 2.8,4, 0.6,5,1021.9,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 996.6,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700208,0000,E, SAO,999,5,9, 0.0,5,00122,4,9,N,002400,5,9,9, 2.8,4, 0.6,5,1022.2,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 997.0,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700208,0300,E, SAO,999,5,9, 0.0,5,00091,4,9,N,001300,5,9,9, 2.2,4, 0.6,5,1023.0,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 997.6,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,51,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700208,0600,E, SAO,999,5,9, 0.0,5,00122,4,9,N,001600,5,9,9, 2.2,4, 0.6,5,1022.2,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 997.0,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700208,0900,E, SAO,999,5,9, 0.0,5,00091,4,9,N,003200,5,9,9, 2.2,4, 0.6,5,1021.4,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 996.3,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,61,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700208,1200,E, SAO,070,5,N, 1.5,5,00030,4,9,N,000400,5,9,9, 2.2,4, 1.1,5,1020.7,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 995.6,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,51,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700208,1500,E, SAO,120,5,N, 1.5,5,00152,4,9,N,001300,5,9,9, 2.2,4, 0.6,5,1020.3,4,01, 0.3,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 995.3,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,61,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700208,1800,E, SAO,010,5,N, 1.5,5,00122,4,9,N,001300,5,9,9, 1.7,4, 1.1,5,1018.7,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 993.6,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,71,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700208,2100,E, SAO,040,5,N, 4.1,5,00122,4,9,N,002400,5,9,9, 2.2,4, 0.6,5,1017.3,4,01, 0.3,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 992.2,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,61,5,71,5, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700209,0000,E, SAO,030,5,N, 3.1,5,00091,4,9,N,001600,5,9,9, 1.1,4, 0.0,5,1018.3,4,01, 0.8,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 993.2,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,71,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700209,0300,E, SAO,030,5,N, 5.2,5,00091,4,9,N,001600,5,9,9, 1.1,4, 0.0,5,1018.7,4,01, 0.5,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 993.6,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,71,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700209,0600,E, SAO,030,5,N, 5.7,5,00122,4,9,N,002000,5,9,9, 1.1,4, -0.6,5,1018.7,4,01, 0.3,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 993.6,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,04,5,45,5,71,5, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700209,0900,E, SAO,030,5,N, 6.7,5,00335,4,9,N,009600,5,9,9, 1.1,4, -1.1,5,1018.7,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 993.6,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9,71,5, ,9, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, CHICAGO OHARE INTL AP ,999999,94846,19700209,1200,E, SAO,020,5,N, 7.2,5,00427,4,9,N,019200,5,9,9, 1.1,4, -1.7,5,1020.1,4,01, 0.0,9,5,99,999.9,9,9,99,999.9,9,9,99,999.9,9,9,9,9,9, 9999,9,9,99999.9,9,9,99,999,9,9,99,999,9,9,99,999,9,9,99,999,9,9, ,9, ,9,99,9, ,9,99,9, ,9,99,9, ,9,99,9,99,U,9999,9,08,08,5,99,9,99,9,99999,9,99,9,99,9,9999,9,99,9,99.9,9, 999.9,9,99.9,9, 999.9,9,9999.9,9, 994.9,4,9,9,99.9,9, 99.9,9,99,9,99,9,99,9,99,9,99,9,99,9,99,9, ,9, ,9, ,9, ,9, ,9, ,9, ,9,9,99,999.9,9,9,99,999.9,9,9,99,999.9,9,999.9,9, Primary key is id_USAF id_NCDC datetime Tables: id_USAF id_NCDC name lat/lng other ids ... id_USAF id_NCDC history id_USAF id_NCDC datetime observed id_USAF id_NCDC datetime precipitation id_USAF id_NCDC datetime wind id_USAF id_NCDC datetime cloud id_USAF id_NCDC datetime visibility id_USAF id_NCDC datetime pressure id_USAF id_NCDC datetime temperature / dewpoint FIELD LEN TYPE NULL UNIT DESC name 30 str id_USAF 6 id 999999 id This identifier includes all surface reporting stations, including ships, buoys, etc. id_NCDC 5 id 99999 id This identifier includes all surface reporting stations. date 8 YYYYMMDD date The date of a GEOPHYSICAL-POINT-OBSERVATION hrmn 4 HHMM time The time of a GEOPHYSICAL-POINT-OBSERVATION based on Coordinated Universal Time Code (UTC). Comprised of integer values 0-9 in the format HHMM. HH is restricted to values 00-23; MM is restricted to values 00-59. type_source 1 CHAR(1) 9 -- Source or combination of sources used in creating the observation. type_report 5 CHAR(5) 99999 -- The code that denotes the type of geophysical surface observation. wind_dir 3 u 999 deg The angle, measured in a clockwise direction, between true north and the direction from which the wind is blowing. wind_dir_q 1 q 9 *q* The code that denotes a quality status of a reported WIND-OBSERVATION direction angle. wind_obs 1 CHAR(1) 9 -- The code that denotes the character of the WIND-OBSERVATION. wind_speed 4 u 999.9 m/s The rate of horizontal travel of air past a fixed point. wind_speed_q 1 q 9 *q* The code that denotes a quality status of a reported WIND-OBSERVATION speed rate cloud_ceil_height 5 u 99999 m The height above ground level (AGL) of the lowest cloud or obscuring phenomena layer aloft with 5/8 or more summation total sky cover, which may be predominantly opaque, or the vertical visibility into a surface-based obstruction. cloud_ceil_height_q 1 q 9 *q* The code that denotes a quality status of a reported ceiling height dimension. cloud_ceil_method 1 CHAR(1) 9 -- The code that denotes the method used to determine the ceiling. cloud_ceil_CAVOK 1 NY 9 bool SKY-CONDITION-OBSERVATION CAVOK code vis_dist 6 u 999999 m The horizontal distance at which an object can be seen and identified. vis_dist_q 1 q 9 *q* The code that denotes a quality status of a reported distance of a visibility observation. vis_variable_flag 1 NV 9 bool The code that denotes whether or not the reported visibility is variable. vis_variable_flag_q 1 q 9 *q* The code that denotes a quality status of a reported VISIBILITY-OBSERVATION variability code. temp 5 i 999.9 deg C The temperature of the air in degrees Celsius. temp_q 1 q 9 *q* The code that denotes a quality status of an AIR-TEMPERATURE-OBSERVATION. temp_dewpt 5 i 999.9 deg C The temperature to which a given parcel of air must be cooled at constant pressure and water vapor content in order for saturation to occur. temp_dewpt_q 1 q 9 *q* The code that denotes a quality status of the reported dew point temperature. press_sealvl 5 u 9999.9 HPa The air pressure relative to Mean Sea Level (MSL). press_sealvl_q 1 q 9 *q* The code that denotes a quality status of the sea level pressure of an ATMOSPHERIC-PRESSURE-OBSERVATION. precip_lq1_period 2 u 99 hours The quantity of time over which the LIQUID-PRECIPITATION was measured. precip_lq1_depth 4 u 999.9 mm The depth of LIQUID-PRECIPITATION that is measured at the time of an observation. Unit:Millimeters precip_lq1_trace_fl 1 129 9 bool The code that denotes whether a LIQUID-PRECIPITATION amount was a trace 1: Measurement impossible or inaccurate 2: Trace 9: ???? precip_lq1_q 1 q 9 *q* The code that denotes a quality status of the reported LIQUID-PRECIPITATION data. precip_lq2_period 2 u 99 hours The quantity of time over which the LIQUID-PRECIPITATION was measured. precip_lq2_depth 4 u 999.9 mm The depth of LIQUID-PRECIPITATION that is measured at the time of an observation. Unit:Millimeters precip_lq2_trace_fl 1 129 9 bool The code that denotes whether a LIQUID-PRECIPITATION amount was a trace 1: Measurement impossible or inaccurate 2: Trace 9: ???? precip_lq2_q 1 q 9 *q* The code that denotes a quality status of the reported LIQUID-PRECIPITATION data. precip_lq3_period 2 u 99 hours The quantity of time over which the LIQUID-PRECIPITATION was measured. precip_lq3_depth 4 u 999.9 mm The depth of LIQUID-PRECIPITATION that is measured at the time of an observation. Unit:Millimeters precip_lq3_trace_fl 1 129 9 bool The code that denotes whether a LIQUID-PRECIPITATION amount was a trace 1: Measurement impossible or inaccurate 2: Trace 9: ???? precip_lq3_q 1 q 9 *q* The code that denotes a quality status of the reported LIQUID-PRECIPITATION data. precip_lq4_period 2 u 99 hours The quantity of time over which the LIQUID-PRECIPITATION was measured. precip_lq4_depth 4 u 999.9 mm The depth of LIQUID-PRECIPITATION that is measured at the time of an observation. Unit:Millimeters precip_lq4_trace_fl 1 129 9 bool The code that denotes whether a LIQUID-PRECIPITATION amount was a trace 1: Measurement impossible or inaccurate 2: Trace 9: ???? precip_lq4_q 1 q 9 *q* The code that denotes a quality status of the reported LIQUID-PRECIPITATION data. precip_hist_dur 1 u 9 -- The code that denotes the duration of precipitation. precip_hist_contin 1 IC 9 bool The code that denotes whether precipitation is continuous (true) or intermittent (false). precip_hist_q 1 q 9 *q* The code that denotes a quality status of the reported PRECIPITATION duration/characteristic. snow_depth 4 u 9999 cm The depth of snow and ice on the ground. snow_depth_cond 1 123 9 -- The code that denotes specific conditions associated with the measurement 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace snow_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-DEPTH data. snow_depth_weq 6 u 99999.9 mm The depth of the liquid content of solid precipitation that has accumulated on the ground. snow_depth_weq_tr 1 12 9 -- The code that denotes specific conditions associated with the measurement of the SNOW-DEPTH. 1: Measurement impossible or inaccurate 2: Trace snow_depth_weq_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-DEPTH equivalent water condition. precip_sn1_period 2 u 99 hours The quantity of time over which the SNOW-ACCUMULATION was measured. precip_sn1_depth 3 u 999 cm The depth of a SNOW-ACCUMULATION. Unit:Millimeters precip_sn1_cond 1 1239 9 -- The code that denotes specific conditions associated with the measurement of the depth of a SNOW-ACCUMULATION. 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace 9: ????? precip_sn1_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-ACCUMULATION. precip_sn2_period 2 u 99 hours The quantity of time over which the SNOW-ACCUMULATION was measured. precip_sn2_depth 3 u 999 cm The depth of a SNOW-ACCUMULATION. Unit:Millimeters precip_sn2_cond 1 1239 9 -- The code that denotes specific conditions associated with the measurement of the depth of a SNOW-ACCUMULATION. 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace 9: ????? precip_sn2_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-ACCUMULATION. precip_sn3_period 2 u 99 hours The quantity of time over which the SNOW-ACCUMULATION was measured. precip_sn3_depth 3 u 999 cm The depth of a SNOW-ACCUMULATION. Unit:Millimeters precip_sn3_cond 1 1239 9 -- The code that denotes specific conditions associated with the measurement of the depth of a SNOW-ACCUMULATION. 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace 9: ????? precip_sn3_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-ACCUMULATION. precip_sn4_period 2 u 99 hours The quantity of time over which the SNOW-ACCUMULATION was measured. precip_sn4_depth 3 u 999 cm The depth of a SNOW-ACCUMULATION. Unit:Millimeters precip_sn4_cond 1 1239 9 -- The code that denotes specific conditions associated with the measurement of the depth of a SNOW-ACCUMULATION. 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace 9: ????? precip_sn4_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-ACCUMULATION. wea_pr_a_obs 2 u 99 -- The code that denotes a specific type of weather reported by an automated device. wea_pr_a_obs_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from an automated station. wea_pa_m_obs_1 1 i 9 -- The code that denotes a specific type of past weather observed manually. wea_pa_m_obs_1_q 1 q 9 *q* The code that denotes a quality status of a reported past weather observation from a manual station. wea_pa_m_obs_1_time 2 u 99 hours The quantity of time over which a PAST-WEATHER-OBSERVATION occurred. wea_pa_m_obs_1_time_q 1 q 9 *q* The code that denotes a quality status of a reported past weather period. wea_pa_m_obs_2 1 i 9 -- The code that denotes a specific type of past weather observed manually. wea_pa_m_obs_2_q 1 q 9 *q* The code that denotes a quality status of a reported past weather observation from a manual station. wea_pa_m_obs_2_time 2 u 99 hours The quantity of time over which a PAST-WEATHER-OBSERVATION occurred. wea_pa_m_obs_2_time_q 1 q 9 *q* The code that denotes a quality status of a reported past weather period. wea_pa_a_obs_1 1 i 9 -- The code that denotes a specific type of past weather reported by an automated device. wea_pa_a_obs_1_q 1 q 9 *q* The code that denotes a quality status of a reported past weather observation wea_pa_a_obs_1_time 2 u 99 hours The quantity of time over which a PAST-WEATHER-OBSERVATION occurred. wea_pa_a_obs_1_time_q 1 q 9 *q* The code that denotes a quality status of a reported past weather period. wea_pa_a_obs_2 1 i 9 -- The code that denotes a specific type of past weather reported by an automated device. wea_pa_a_obs_2_q 1 q 9 *q* The code that denotes a quality status of a reported past weather observation wea_pa_a_obs_2_time 2 u 99 hours The quantity of time over which a PAST-WEATHER-OBSERVATION occurred. wea_pa_a_obs_2_time_q 1 q 9 *q* The code that denotes a quality status of a reported past weather period. vis_runway_dir 2 u 99 deg/10 The angle as measured from magnetic north to the runway along which the visibility is observed. Unit:Tens of degrees vis_runway_lrc 1 LRCU 9 -- The code that denotes the left, right or center runway as the one to which the visibility applies. L = left C = center R = right U = unknown vis_runway_dist 4 u 9999 m The dimension of the horizontal distance that can be seen along the runway. Unit:Meters vis_runway_dist_q 1 q 9 *q* The code that denotes a quality status of the reported RUNWAY-VISUAL-RANGE-OBSERVATION. cloud_cover_total 2 99 (frac) The code that denotes the fraction of the total celestial dome covered by clouds or other obscuring phenomena. SKY-CONDITION-OBSERVATION total coverage code cloud_cover_opaque 2 99 -- The code that denotes the fraction of the total celestial dome covered by opaque clouds or other obscuring phenomena. cloud_cover_total_q 1 q 9 *q* The code that denotes a quality status of a reported total sky coverage code. cloud_cover_low 2 99 (frac) The code that represents the fraction of the celestial dome covered by all low clouds present. If no low clouds are present; the code denotes the fraction covered by all middle level clouds present. cloud_cover_low_q 1 q 9 *q* The code that denotes a quality status of a reported total lowest cloud cover code. cloud_low_type 2 99 -- The code that denotes a type of low cloud. cloud_low_type_q 1 q 9 *q* The code that denotes a quality status of a reported low cloud type. cloud_low_height 5 1 99999 m The height, above ground level (AGL), of the base of the lowest cloud. cloud_low_height_q 1 q 9 *q* The code that denotes a quality status of a lowest cloud base height. cloud_mid_type 2 99 -- The code that denotes a type of middle level cloud. cloud_mid_type_q 1 q 9 *q* The code that denotes a quality status of a reported mid cloud type. cloud_hi_type 2 99 -- The code that denotes a type of high cloud. cloud_hi_type_q 1 q 9 *q* The code that denotes a quality status of a reported high cloud type. sunshine_time 4 1 9999 min The quantity of time sunshine occurred over the reporting period. sunshine_time_q 1 q 9 *q* The code that denotes a quality status of the reported SUNSHINE-OBSERVATION sunshine duration. groundcond 2 99 -- The code that denotes a type of Ground condition groundcond_q 1 q 9 *q* The code that denotes a quality status of the reported GROUND-SURFACE-OBSERVATION code. temp_minmax1_period 3 10 99.9 hrs The quantity of time over which temperatures were sampled to determine the EXTREME-AIR-TEMPERATURE. temp_minmax1_minmax 1 NM 9 bool The code that denotes an EXTREME-AIR-TEMPERATURE as a maximum or a minimum. N: Minimum temperature M: Maximum temperature temp_minmax1_temp 5 10 999.9 deg C The temperature of the high or low air temperature for a given period. temp_minmax1_q 1 q 9 *q* The code that denotes a quality status of the reported EXTREME-AIR-TEMPERATURE temperature. temp_minmax2_period 3 10 999 hrs The quantity of time over which temperatures were sampled to determine the EXTREME-AIR-TEMPERATURE. temp_minmax2_minmax 1 NM 9 bool The code that denotes an EXTREME-AIR-TEMPERATURE as a maximum or a minimum. N: Minimum temperature M: Maximum temperature temp_minmax2_temp 5 10 999.9 deg C The temperature of the high or low air temperature for a given period. temp_minmax2_q 1 q 9 *q* The code that denotes a quality status of the reported EXTREME-AIR-TEMPERATURE temperature. press_altim 5 10 9999.9 HPa The pressure value to which an aircraft altimeter is set so that it will indicate the altitude relative to mean sea level of an aircraft on the ground at the location for which the value was determined. press_altim_q 1 q 9 *q* The code that denotes a quality status of an altimeter setting rate. press_atmos 5 10 9999.9 HPa The atmospheric pressure at the observation point. press_atmos_q 1 q 9 *q* The code that denotes a quality status of the station pressure of an ATMOSPHERIC-PRESSURE-OBSERVATION. press_chg_3hr_obs 1 9 -- The code that denotes the characteristics of an ATMOSPHERIC-PRESSURE-CHANGE that occurs over a period of three hours. press_chg_3hr_obs_q 1 q 9 *q* The code that denotes a quality status of the tendency of an ATMOSPHERIC-PRESSURE-CHANGE. press_chg_3hr_del 3 10 99.9 HPa The absolute value of the quantity of change in atmospheric pressure measured at the beginning and end of a three hour period. press_chg_3hr_del_q 1 q 9 *q* The code that denotes the quality status of the three hour quantity for an ATMOPSHERIC-PRESSURE-CHANGE. press_chg_24hr_del 4 10 99.9 HPa The quantity of change in atmospheric pressure measured at the beginning and end of a twenty four hour period. press_chg_24hr_del_q 1 q 9 *q* The code that denotes a quality status of a reported twenty four hour ATMOSPHERIC-PRESSURE-CHANGE. wea_pr_v_obs_1 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_1_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_2 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_2_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_3 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_3_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_4 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_4_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_5 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_5_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_6 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_6_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_7 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_7_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_m_obs_1 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_1_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_2 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_2_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_3 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_3_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_4 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_4_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_5 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_5_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_6 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_6_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_7 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_7_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wind_supp1_obs 1 9 -- The code that denotes a type of SUPPLEMENTARY-WIND-OBSERVATION. wind_supp1_period 2 99 hrs The quantity of time over which a SUPPLEMENTARY-WIND-OBSERVATION occurred. wind_supp1_speed 4 10 999.9 m/s The rate of horizontal speed of air reported in the SUPPLEMENTARY-WIND-OBSERVATION. wind_supp1_speed_q 1 q 9 *q* The code that denotes a quality status of the reported SUPPLEMENTARY-WIND-OBSERVATION speed rate. wind_supp2_obs 1 9 -- The code that denotes a type of SUPPLEMENTARY-WIND-OBSERVATION. wind_supp2_period 2 99 hrs The quantity of time over which a SUPPLEMENTARY-WIND-OBSERVATION occurred. wind_supp2_speed 4 10 999.9 m/s The rate of horizontal speed of air reported in the SUPPLEMENTARY-WIND-OBSERVATION. wind_supp2_speed_q 1 q 9 *q* The code that denotes a quality status of the reported SUPPLEMENTARY-WIND-OBSERVATION speed rate. wind_supp3_obs 1 9 -- The code that denotes a type of SUPPLEMENTARY-WIND-OBSERVATION. wind_supp3_period 2 99 hrs The quantity of time over which a SUPPLEMENTARY-WIND-OBSERVATION occurred. wind_supp3_speed 4 10 999.9 m/s The rate of horizontal speed of air reported in the SUPPLEMENTARY-WIND-OBSERVATION. wind_supp3_speed_q 1 q 9 *q* The code that denotes a quality status of the reported SUPPLEMENTARY-WIND-OBSERVATION speed rate. wind_gust_speed 4 10 999.9 m/s The rate of speed of a wind gust. wind_gust_speed_q 1 q 9 *q* The code that denotes a quality status of a reported WIND-GUST-OBSERVATION speed rate. junk cloud vis sunshine press temp wind precip snow groundcond wea id_USAF 6 id 999999 id This identifier includes all surface reporting stations, including ships, buoys, etc. id_NCDC 5 id id This identifier includes all surface reporting stations. name 30 str Weather Station name lat lng ... ... county state .... id_USAF 6 id 999999 id This identifier includes all surface reporting stations, including ships, buoys, etc. id_NCDC 5 id id This identifier includes all surface reporting stations. history id_USAF 6 id 999999 id This identifier includes all surface reporting stations, including ships, buoys, etc. id_NCDC 5 id id This identifier includes all surface reporting stations. datetime press_altim 5 10 99999 HPa The pressure value to which an aircraft altimeter is set so that it will indicate the altitude relative to mean sea level of an aircraft on the ground at the location for which the value was determined. press_atmos 5 10 99999 HPa The atmospheric pressure at the observation point. press_chg_24hr_de l 4 10 +999 HPa The quantity of change in atmospheric pressure measured at the beginning and end of a twenty four hour period. press_chg_3hr_del 3 10 999 HPa The absolute value of the quantity of change in atmospheric pressure measured at the beginning and end of a three hour period. press_chg_3hr_obs 1 9 -- The code that denotes the characteristics of an ATMOSPHERIC-PRESSURE-CHANGE that occurs over a period of three hours. press_sealvl 5 u 99999 HPa The air pressure relative to Mean Sea Level (MSL). temp 5 i +9999 deg C The temperature of the air in degrees Celsius. temp_dewpt 5 i +9999 deg C The temperature to which a given parcel of air must be cooled at constant pressure and water vapor content in order for saturation to occur. temp_minmax1_minmax 1 NM 9 bool The code that denotes an EXTREME-AIR-TEMPERATURE as a maximum or a minimum. N: Minimum temperature M: Maximum temperature temp_minmax1_period 3 10 999 hrs The quantity of time over which temperatures were sampled to determine the EXTREME-AIR-TEMPERATURE. temp_minmax1_temp 5 10 +9999 deg C The temperature of the high or low air temperature for a given period. temp_minmax2_minmax 1 NM 9 bool The code that denotes an EXTREME-AIR-TEMPERATURE as a maximum or a minimum. N: Minimum temperature M: Maximum temperature temp_minmax2_period 3 10 999 hrs The quantity of time over which temperatures were sampled to determine the EXTREME-AIR-TEMPERATURE. temp_minmax2_temp 5 10 +9999 deg C The temperature of the high or low air temperature for a given period. wind_dir 3 u 999 deg The angle, measured in a clockwise direction, between true north and the direction from which the wind is blowing. wind_gust_speed 4 10 9999 m/s The rate of speed of a wind gust. wind_obs 1 CHAR(1) -- The code that denotes the character of the WIND-OBSERVATION. wind_speed 4 u 9999 m/s The rate of horizontal travel of air past a fixed point. wind_supp1_obs 1 9 -- The code that denotes a type of SUPPLEMENTARY-WIND-OBSERVATION. wind_supp1_period 2 99 hrs The quantity of time over which a SUPPLEMENTARY-WIND-OBSERVATION occurred. wind_supp1_speed 4 10 9999 m/s The rate of horizontal speed of air reported in the SUPPLEMENTARY-WIND-OBSERVATION. wind_supp2_obs 1 9 -- The code that denotes a type of SUPPLEMENTARY-WIND-OBSERVATION. wind_supp2_period 2 99 hrs The quantity of time over which a SUPPLEMENTARY-WIND-OBSERVATION occurred. wind_supp2_speed 4 10 9999 m/s The rate of horizontal speed of air reported in the SUPPLEMENTARY-WIND-OBSERVATION. wind_supp3_obs 1 9 -- The code that denotes a type of SUPPLEMENTARY-WIND-OBSERVATION. wind_supp3_period 2 99 hrs The quantity of time over which a SUPPLEMENTARY-WIND-OBSERVATION occurred. wind_supp3_speed 4 10 9999 m/s The rate of horizontal speed of air reported in the SUPPLEMENTARY-WIND-OBSERVATION. id_USAF 6 id 999999 id This identifier includes all surface reporting stations, including ships, buoys, etc. id_NCDC 5 id id This identifier includes all surface reporting stations. datetime precip_hist_contin 1 IC 9 bool The code that denotes whether precipitation is continuous (true) or intermittent (false). precip_hist_dur 1 9 -- The code that denotes the duration of precipitation. precip_lq1_depth 4 u 9999 mm The depth of LIQUID-PRECIPITATION that is measured at the time of an observation. Unit:Millimeters precip_lq1_period 2 u 99 hours The quantity of time over which the LIQUID-PRECIPITATION was measured. precip_lq1_trace_fl 1 129 bool The code that denotes whether a LIQUID-PRECIPITATION amount was a trace 1: Measurement impossible or inaccurate 2: Trace 9: ???? precip_lq2_depth 4 u 9999 mm The depth of LIQUID-PRECIPITATION that is measured at the time of an observation. Unit:Millimeters precip_lq2_period 2 u 99 hours The quantity of time over which the LIQUID-PRECIPITATION was measured. precip_lq2_trace_fl 1 129 bool The code that denotes whether a LIQUID-PRECIPITATION amount was a trace 1: Measurement impossible or inaccurate 2: Trace 9: ???? precip_lq3_depth 4 u 9999 mm The depth of LIQUID-PRECIPITATION that is measured at the time of an observation. Unit:Millimeters precip_lq3_period 2 u 99 hours The quantity of time over which the LIQUID-PRECIPITATION was measured. precip_lq3_trace_fl 1 129 bool The code that denotes whether a LIQUID-PRECIPITATION amount was a trace 1: Measurement impossible or inaccurate 2: Trace 9: ???? precip_lq4_depth 4 u 9999 mm The depth of LIQUID-PRECIPITATION that is measured at the time of an observation. Unit:Millimeters precip_lq4_period 2 u 99 hours The quantity of time over which the LIQUID-PRECIPITATION was measured. precip_lq4_trace_fl 1 129 bool The code that denotes whether a LIQUID-PRECIPITATION amount was a trace 1: Measurement impossible or inaccurate 2: Trace 9: ???? precip_sn1_cond 1 1239 -- The code that denotes specific conditions associated with the measurement of the depth of a SNOW-ACCUMULATION. 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace 9: ????? precip_sn1_depth 3 u 9999 cm The depth of a SNOW-ACCUMULATION. Unit:Millimeters precip_sn1_period 2 u 99 hours The quantity of time over which the SNOW-ACCUMULATION was measured. precip_sn2_cond 1 1239 -- The code that denotes specific conditions associated with the measurement of the depth of a SNOW-ACCUMULATION. 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace 9: ????? precip_sn2_depth 3 u 9999 cm The depth of a SNOW-ACCUMULATION. Unit:Millimeters precip_sn2_period 2 u 99 hours The quantity of time over which the SNOW-ACCUMULATION was measured. precip_sn3_cond 1 1239 -- The code that denotes specific conditions associated with the measurement of the depth of a SNOW-ACCUMULATION. 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace 9: ????? precip_sn3_depth 3 u 9999 cm The depth of a SNOW-ACCUMULATION. Unit:Millimeters precip_sn3_period 2 u 99 hours The quantity of time over which the SNOW-ACCUMULATION was measured. precip_sn4_cond 1 1239 -- The code that denotes specific conditions associated with the measurement of the depth of a SNOW-ACCUMULATION. 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace 9: ????? precip_sn4_depth 3 u 9999 cm The depth of a SNOW-ACCUMULATION. Unit:Millimeters precip_sn4_period 2 u 99 hours The quantity of time over which the SNOW-ACCUMULATION was measured. snow_depth 4 u 9999 cm The depth of snow and ice on the ground. snow_depth_obs 1 123 9 -- The code that denotes specific conditions associated with the measurement 1: Measurement impossible or inaccurate 2: Snow cover not continuous 3: Trace snow_depth_weq 6 u mm The depth of the liquid content of solid precipitation that has accumulated on the ground. snow_depth_weq_tr 1 -- The code that denotes specific conditions associated with the measurement of the SNOW-DEPTH. 1: Measurement impossible or inaccurate 2: Trace groundcond 2 99 -- The code that denotes a type of Ground condition id_USAF 6 id 999999 id This identifier includes all surface reporting stations, including ships, buoys, etc. id_NCDC 5 id id This identifier includes all surface reporting stations. datetime cloud_ceil_CAVOK 1 NY bool SKY-CONDITION-OBSERVATION CAVOK code cloud_ceil_height 5 99999 m The height above ground level (AGL) of the lowest cloud or obscuring phenomena layer aloft with 5/8 or more summation total sky cover, which may be predominantly opaque, or the vertical visibility into a surface-based obstruction. cloud_ceil_method 1 CHAR(1) 9 -- The code that denotes the method used to determine the ceiling. cloud_cover_low 2 99 (frac) The code that represents the fraction of the celestial dome covered by all low clouds present. If no low clouds are present; the code denotes the fraction covered by all middle level clouds present. cloud_cover_opaque 2 99 -- The code that denotes the fraction of the total celestial dome covered by opaque clouds or other obscuring phenomena. cloud_cover_total 2 99 (frac) The code that denotes the fraction of the total celestial dome covered by clouds or other obscuring phenomena. SKY-CONDITION-OBSERVATION total coverage code cloud_hi_type 2 99 -- The code that denotes a type of high cloud. cloud_low_height 5 1 99999 m The height, above ground level (AGL), of the base of the lowest cloud. cloud_low_type 2 99 -- The code that denotes a type of low cloud. cloud_mid_type 2 99 -- The code that denotes a type of middle level cloud. vis_dist 6 u 999999 m The horizontal distance at which an object can be seen and identified. vis_runway_dir 2 u 99 deg/10 The angle as measured from magnetic north to the runway along which the visibility is observed. Unit:Tens of degrees vis_runway_dist 4 u m The dimension of the horizontal distance that can be seen along the runway. Unit:Meters vis_runway_lrc 1 LRCU -- The code that denotes the left, right or center runway as the one to which the visibility applies. L = left C = center R = right U = unknown vis_variable_flag 1 NV bool The code that denotes whether or not the reported visibility is variable. sunshine_time 4 1 9999 min The quantity of time sunshine occurred over the reporting period. id_USAF 6 id 999999 id This identifier includes all surface reporting stations, including ships, buoys, etc. id_NCDC 5 id 99999 id This identifier includes all surface reporting stations. datetime wea_pa_a_obs_1 1 i 9 -- The code that denotes a specific type of past weather reported by an automated device. wea_pa_a_obs_1_time 2 u 99 hours The quantity of time over which a PAST-WEATHER-OBSERVATION occurred. wea_pa_a_obs_2 1 i 9 -- The code that denotes a specific type of past weather reported by an automated device. wea_pa_a_obs_2_time 2 u 99 hours The quantity of time over which a PAST-WEATHER-OBSERVATION occurred. wea_pa_m_obs_1 1 i 9 -- The code that denotes a specific type of past weather observed manually. wea_pa_m_obs_1_time 2 u 99 hours The quantity of time over which a PAST-WEATHER-OBSERVATION occurred. wea_pa_m_obs_2 1 i 9 -- The code that denotes a specific type of past weather observed manually. wea_pa_m_obs_2_time 2 u 99 hours The quantity of time over which a PAST-WEATHER-OBSERVATION occurred. wea_pr_a_obs 2 u 99 -- The code that denotes a specific type of weather reported by an automated device. wea_pr_m_obs_1 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_2 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_3 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_4 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_5 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_6 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_m_obs_7 2 u 99 -- The code that denotes a specific type of weather observed manually. wea_pr_v_obs_1 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_2 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_3 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_4 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_5 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_6 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. wea_pr_v_obs_7 2 99 -- The code that denotes a specific type of weather observed between 5 and 10 statute miles of the station at the time of observation. Observed at selected stations from July 1, 1996 to present. id_USAF 6 id 999999 id This identifier includes all surface reporting stations, including ships, buoys, etc. id_NCDC 5 id id This identifier includes all surface reporting stations. datetime type_source 1 CHAR(1) 9 -- Source or combination of sources used in creating the observation. type_report 5 CHAR(5) 99999 -- The code that denotes the type of geophysical surface observation. wind_dir_q 1 q 9 *q* The code that denotes a quality status of a reported WIND-OBSERVATION direction angle. wind_speed_q 1 q 9 *q* The code that denotes a quality status of a reported WIND-OBSERVATION speed rate cloud_ceil_height_q 1 q 9 *q* The code that denotes a quality status of a reported ceiling height dimension. vis_dist_q 1 q 9 *q* The code that denotes a quality status of a reported distance of a visibility observation. vis_variable_flag_q 1 q 9 *q* The code that denotes a quality status of a reported VISIBILITY-OBSERVATION variability code. temp_q 1 q 9 *q* The code that denotes a quality status of an AIR-TEMPERATURE-OBSERVATION. temp_dewpt_q 1 q 9 *q* The code that denotes a quality status of the reported dew point temperature. press_sealvl_q 1 q 9 *q* The code that denotes a quality status of the sea level pressure of an ATMOSPHERIC-PRESSURE-OBSERVATION. precip_lq1_q 1 q 9 *q* The code that denotes a quality status of the reported LIQUID-PRECIPITATION data. precip_lq2_q 1 q 9 *q* The code that denotes a quality status of the reported LIQUID-PRECIPITATION data. precip_lq3_q 1 q 9 *q* The code that denotes a quality status of the reported LIQUID-PRECIPITATION data. precip_lq4_q 1 q 9 *q* The code that denotes a quality status of the reported LIQUID-PRECIPITATION data. precip_hist_q 1 q 9 *q* The code that denotes a quality status of the reported PRECIPITATION duration/characteristic. snow_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-DEPTH data. snow_depth_weq_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-DEPTH equivalent water condition. precip_sn1_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-ACCUMULATION. precip_sn2_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-ACCUMULATION. precip_sn3_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-ACCUMULATION. precip_sn4_depth_q 1 q 9 *q* The code that denotes a quality status of the reported SNOW-ACCUMULATION. wea_pr_a_obs_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from an automated station. wea_pa_m_obs_1_q 1 q 9 *q* The code that denotes a quality status of a reported past weather observation from a manual station. wea_pa_m_obs_1_time_q 1 q 9 *q* The code that denotes a quality status of a reported past weather period. wea_pa_m_obs_2_q 1 q 9 *q* The code that denotes a quality status of a reported past weather observation from a manual station. wea_pa_m_obs_2_time_q 1 q 9 *q* The code that denotes a quality status of a reported past weather period. wea_pa_a_obs_1_q 1 q 9 *q* The code that denotes a quality status of a reported past weather observation wea_pa_a_obs_1_time_q 1 q 9 *q* The code that denotes a quality status of a reported past weather period. wea_pa_a_obs_2_q 1 q 9 *q* The code that denotes a quality status of a reported past weather observation wea_pa_a_obs_2_time_q 1 q 9 *q* The code that denotes a quality status of a reported past weather period. vis_runway_dist_q 1 q 9 *q* The code that denotes a quality status of the reported RUNWAY-VISUAL-RANGE-OBSERVATION. cloud_cover_total_q 1 q 9 *q* The code that denotes a quality status of a reported total sky coverage code. cloud_cover_low_q 1 q 9 *q* The code that denotes a quality status of a reported total lowest cloud cover code. cloud_low_type_q 1 q 9 *q* The code that denotes a quality status of a reported low cloud type. cloud_low_height_q 1 q 9 *q* The code that denotes a quality status of a lowest cloud base height. cloud_mid_type_q 1 q 9 *q* The code that denotes a quality status of a reported mid cloud type. cloud_hi_type_q 1 q 9 *q* The code that denotes a quality status of a reported high cloud type. sunshine_time_q 1 q 9 *q* The code that denotes a quality status of the reported SUNSHINE-OBSERVATION sunshine duration. groundcond_q 1 q 9 *q* The code that denotes a quality status of the reported GROUND-SURFACE-OBSERVATION code. temp_minmax1_q 1 q 9 *q* The code that denotes a quality status of the reported EXTREME-AIR-TEMPERATURE temperature. temp_minmax2_q 1 q 9 *q* The code that denotes a quality status of the reported EXTREME-AIR-TEMPERATURE temperature. press_altim_q 1 q 9 *q* The code that denotes a quality status of an altimeter setting rate. press_atmos_q 1 q 9 *q* The code that denotes a quality status of the station pressure of an ATMOSPHERIC-PRESSURE-OBSERVATION. press_chg_3hr_obs_q 1 q 9 *q* The code that denotes a quality status of the tendency of an ATMOSPHERIC-PRESSURE-CHANGE. press_chg_3hr_del_q 1 q 9 *q* The code that denotes a quality status of the three hour quantity for an ATMOPSHERIC-PRESSURE-CHANGE. press_chg_24hr_del_q 1 q 9 *q* The code that denotes a quality status of a reported twenty four hour ATMOSPHERIC-PRESSURE-CHANGE. wea_pr_v_obs_1_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_2_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_3_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_4_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_5_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_6_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_v_obs_7_q 1 q 9 *q* The code that denotes a quality status of a reported present weather in vicinity observation from a station. wea_pr_m_obs_1_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_2_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_3_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_4_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_5_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_6_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wea_pr_m_obs_7_q 1 q 9 *q* The code that denotes a quality status of a reported present weather observation from a manual station. wind_supp1_speed_q 1 q 9 *q* The code that denotes a quality status of the reported SUPPLEMENTARY-WIND-OBSERVATION speed rate. wind_supp2_speed_q 1 q 9 *q* The code that denotes a quality status of the reported SUPPLEMENTARY-WIND-OBSERVATION speed rate. wind_supp3_speed_q 1 q 9 *q* The code that denotes a quality status of the reported SUPPLEMENTARY-WIND-OBSERVATION speed rate. wind_gust_speed_q 1 q 9 *q* The code that denotes a quality status of a reported WIND-GUST-OBSERVATION speed rate. name id_USAF id_NCDC date hrmn type_source type_report wind_dir wind_dir_q wind_obs wind_speed wind_speed_q cloud_ceil_height cloud_ceil_height_q cloud_ceil_method cloud_ceil_CAVOK vis_dist vis_dist_q vis_var vis_var_q temp temp_q temp_dewpt temp_dewpt_q press_sealvl press_sealvl_q precip_lq1_period precip_lq1_depth precip_lq1_trace_fl precip_lq1_q precip_lq2_period precip_lq2_depth precip_lq2_trace_fl precip_lq2_q precip_lq3_period precip_lq3_depth precip_lq3_trace_fl precip_lq3_q precip_lq4_period precip_lq4_depth precip_lq4_trace_fl precip_lq4_q precip_hist_dur precip_hist_contin precip_hist_q snow_depth snow_depth_cond snow_depth_q snow_depth_weq snow_depth_weq_tr snow_depth_weq_q precip_sn1_period precip_sn1_depth precip_sn1_cond precip_sn1_depth_q precip_sn2_period precip_sn2_depth precip_sn2_cond precip_sn2_depth_q precip_sn3_period precip_sn3_depth precip_sn3_cond precip_sn3_depth_q precip_sn4_period precip_sn4_depth precip_sn4_cond precip_sn4_depth_q wea_pr_a_obs wea_pr_a_obs_q wea_pa_m_obs_1 wea_pa_m_obs_1_q wea_pa_m_obs_1_time wea_pa_m_obs_1_time_q wea_pa_m_obs_2 wea_pa_m_obs_2_q wea_pa_m_obs_2_time wea_pa_m_obs_2_time_q wea_pa_a_obs_1 wea_pa_a_obs_1_q wea_pa_a_obs_1_time wea_pa_a_obs_1_time_q wea_pa_a_obs_2 wea_pa_a_obs_2_q wea_pa_a_obs_2_time wea_pa_a_obs_2_time_q vis_runway_dir vis_runway_lrc vis_runway_dist vis_runway_dist_q cloud_cover_total cloud_cover_opaque cloud_cover_total_q cloud_cover_low cloud_cover_low_q cloud_low_type cloud_low_type_q cloud_low_height cloud_low_height_q cloud_mid_type cloud_mid_type_q cloud_hi_type cloud_hi_type_q sunshine_time sunshine_time_q groundcond groundcond_q temp_minmax1_period temp_minmax1_minmax temp_minmax1_temp temp_minmax1_q temp_minmax2_period temp_minmax2_minmax temp_minmax2_temp temp_minmax2_q press_altim press_altim_q press_atmos press_atmos_q press_chg_3hr_obs press_chg_3hr_obs_q press_chg_3hr_del press_chg_3hr_del_q press_chg_24hr_del press_chg_24hr_del_q wea_pr_v_obs_1 wea_pr_v_obs_1_q wea_pr_v_obs_2 wea_pr_v_obs_2_q wea_pr_v_obs_3 wea_pr_v_obs_3_q wea_pr_v_obs_4 wea_pr_v_obs_4_q wea_pr_v_obs_5 wea_pr_v_obs_5_q wea_pr_v_obs_6 wea_pr_v_obs_6_q wea_pr_v_obs_7 wea_pr_v_obs_7_q wea_pr_m_obs_1 wea_pr_m_obs_1_q wea_pr_m_obs_2 wea_pr_m_obs_2_q wea_pr_m_obs_3 wea_pr_m_obs_3_q wea_pr_m_obs_4 wea_pr_m_obs_4_q wea_pr_m_obs_5 wea_pr_m_obs_5_q wea_pr_m_obs_6 wea_pr_m_obs_6_q wea_pr_m_obs_7 wea_pr_m_obs_7_q wind_supp1_obs wind_supp1_period wind_supp1_speed wind_supp1_speed_q wind_supp2_obs wind_supp2_period wind_supp2_speed wind_supp2_speed_q wind_supp3_obs wind_supp3_period wind_supp3_speed wind_supp3_speed_q wind_gust_speed wind_gust_speed_q junk '', '999999', '99999', '99999999', '9999', '9', '99999', '999', '9', '9', '999.9', '9', '99999', '9', '9', '9', '999999', '9', '9', '9', '999.9', '9', '999.9', '9', '9999.9', '9', '99', '999.9', '9', '9', '99', '999.9', '9', '9', '99', '999.9', '9', '9', '99', '999.9', '9', '9', '9', '9', '9', '9999', '9', '9', '99999.9', '9', '9', '99', '999', '9', '9', '99', '999', '9', '9', '99', '999', '9', '9', '99', '999', '9', '9', '99', '9', '9', '9', '99', '9', '9', '9', '99', '9', '9', '9', '99', '9', '9', '9', '99', '9', '99', '9', '9999', '9', '99', '99', '9', '99', '9', '99', '9', '99999', '9', '99', '9', '99', '9', '9999', '9', '99', '9', '99.9', '9', '999.9', '9', '999', '9', '999.9', '9', '9999.9', '9', '9999.9', '9', '9', '9', '99.9', '9', '99.9', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '99', '9', '9', '99', '999.9', '9', '9', '99', '999.9', '9', '9', '99', '999.9', '9', '999.9', '9',