{"schema_version":"mostlyright-public-table-preview.v1","dataset":{"id":"3c90c9a2-9e58-401b-8685-1c56c3216edf","slug":"us-weather-reports-and-daily-highs-in-20-cities","title":"US Weather Reports and Daily Highs in 20 Cities","publisher_handle":"mostlyrightmd","url":"https://mostlyright.md/datasets/us-weather-reports-and-daily-highs-in-20-cities"},"table":{"id":"f290a279-c39c-4bc7-8e04-974e0bcd480a","slug":"reports-ksfo","title":"reports_ksfo","license":"CC-BY-4.0","url":"https://mostlyright.md/datasets/us-weather-reports-and-daily-highs-in-20-cities/tables?table=reports-ksfo"},"version":{"id":"97238273-943e-51e2-b54a-145eaa2a41b5","label":null,"released_at":"2026-10-16T04:06:10.177Z","content_digest":null},"columns":[{"name":"station","type":"string"},{"name":"event_time_utc","type":"timestamp_utc"},{"name":"observation_type","type":"string"},{"name":"local_standard_date","type":"date"},{"name":"temp_f","type":"decimal"},{"name":"dewpoint_f","type":"decimal"},{"name":"relative_humidity_pct","type":"decimal"},{"name":"wind_direction_degrees","type":"decimal"},{"name":"wind_speed_kt","type":"decimal"},{"name":"wind_gust_kt","type":"decimal"},{"name":"altimeter_inhg","type":"decimal"},{"name":"sea_level_pressure_hpa","type":"decimal"},{"name":"sky_cover_1","type":"string"},{"name":"sky_base_1_ft","type":"decimal"},{"name":"sky_cover_2","type":"string"},{"name":"sky_base_2_ft","type":"decimal"},{"name":"sky_cover_3","type":"string"},{"name":"sky_base_3_ft","type":"decimal"},{"name":"sky_cover_4","type":"string"},{"name":"sky_base_4_ft","type":"decimal"},{"name":"visibility_miles","type":"decimal"},{"name":"weather_codes","type":"string"},{"name":"precipitation_in_1h","type":"decimal"},{"name":"peak_wind_gust_kt","type":"decimal"},{"name":"peak_wind_direction_degrees","type":"decimal"},{"name":"peak_wind_time","type":"string"},{"name":"snow_depth_inches","type":"decimal"},{"name":"raw_metar","type":"string"},{"name":"cli_product","type":"string"},{"name":"cli_high_f","type":"integer"},{"name":"cli_low_f","type":"integer"},{"name":"cli_report_type","type":"string"}],"rows":[["KSFO","2020-01-01T00:00:00.000000Z","SPECI","2019-12-31","56.00","49.00","77.29","100.00","4.00",null,null,"1019.50",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"METAR SFO 010000Z AUTO 10004KT 13/09 RMK AO2 SLP195 T01330094 IEM_GHCNH",null,null,null,null],["KSFO","2020-01-01T00:56:00.000000Z","METAR","2019-12-31","55.00","44.00","66.61","320.00","3.00",null,"30.120","1019.80","FEW","17000.00","SCT","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 010056Z 32003KT 10SM FEW170 SCT200 13/07 A3012 RMK AO2 SLP198 T01280067",null,null,null,null],["KSFO","2020-01-01T01:56:00.000000Z","METAR","2019-12-31","54.00","49.00","82.82","290.00","7.00",null,"30.120","1020.10","FEW","6000.00","SCT","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 010156Z 29007KT 10SM FEW060 SCT200 12/09 A3012 RMK AO2 SLP201 T01220094",null,null,null,null],["KSFO","2020-01-01T02:56:00.000000Z","METAR","2019-12-31","53.00","48.00","82.76","280.00","8.00",null,"30.120","1020.00","FEW","17000.00","SCT","20000.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 010256Z 28008KT 9SM FEW170 SCT200 12/09 A3012 RMK AO2 SLP200 T01170089 51005",null,null,null,null],["KSFO","2020-01-01T03:56:00.000000Z","METAR","2019-12-31","53.00","47.00","79.40","290.00","9.00",null,"30.140","1020.60","FEW","18000.00","SCT","20000.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 010356Z 29009KT 9SM FEW180 SCT200 12/08 A3014 RMK AO2 SLP206 T01170083",null,null,null,null],["KSFO","2020-01-01T04:56:00.000000Z","METAR","2019-12-31","53.00","49.00","85.59","260.00","10.00",null,"30.140","1020.70","FEW","18000.00","SCT","20000.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 010456Z 26010KT 9SM FEW180 SCT200 12/09 A3014 RMK AO2 SLP207 T01170094",null,null,null,null],["KSFO","2020-01-01T05:56:00.000000Z","METAR","2019-12-31","54.00","49.00","82.82","290.00","9.00",null,"30.160","1021.20","FEW","1000.00","SCT","20000.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 010556Z 29009KT 9SM FEW010 SCT200 12/09 A3016 RMK AO2 SLP212 T01220094 10139 20111 51011",null,null,null,null],["KSFO","2020-01-01T06:56:00.000000Z","METAR","2019-12-31","51.00","47.00","85.48","160.00","5.00",null,"30.140","1020.60","FEW","800.00","SCT","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 010656Z 16005KT 10SM FEW008 SCT200 11/08 A3014 RMK AO2 SLP206 T01060083",null,null,null,null],["KSFO","2020-01-01T07:56:00.000000Z","METAR","2019-12-31","52.00","47.00","82.68","290.00","7.00",null,"30.150","1021.10","FEW","800.00","FEW","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 010756Z 29007KT 10SM FEW008 FEW200 11/08 A3015 RMK AO2 SLP211 T01110083 401390050",null,null,null,null],["KSFO","2020-01-01T08:56:00.000000Z","METAR","2020-01-01","52.00","48.00","86.17","270.00","8.00",null,"30.160","1021.30","FEW","800.00","FEW","1600.00","SCT","20000.00",null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 010856Z 27008KT 9SM FEW008 FEW016 SCT200 11/09 A3016 RMK AO2 SLP213 T01110089 53002","CLISFO","59","47","final"],["KSFO","2020-01-01T09:56:00.000000Z","METAR","2020-01-01","50.00","48.00","92.80","280.00","9.00",null,"30.170","1021.70","FEW","800.00","SCT","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 010956Z 28009KT 10SM FEW008 SCT200 10/09 A3017 RMK AO2 SLP217 T01000089","CLISFO","59","47","final"],["KSFO","2020-01-01T10:56:00.000000Z","METAR","2020-01-01","49.00","47.00","92.77","200.00","5.00",null,"30.140","1020.50","BKN","800.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011056Z 20005KT 10SM BKN008 BKN200 09/08 A3014 RMK AO2 SLP205 T00940083","CLISFO","59","47","final"],["KSFO","2020-01-01T11:41:00.000000Z","SPECI","2020-01-01","50.00","47.00","89.04","130.00","6.00",null,"30.140",null,"FEW","800.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011141Z 13006KT 10SM FEW008 BKN200 10/08 A3014 RMK AO2 T01000083","CLISFO","59","47","final"],["KSFO","2020-01-01T11:56:00.000000Z","METAR","2020-01-01","50.00","47.00","89.04","120.00","5.00",null,"30.130","1020.40","FEW","800.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011156Z 12005KT 10SM FEW008 BKN200 10/08 A3013 RMK AO2 SLP204 T01000083 10128 20094 58009","CLISFO","59","47","final"],["KSFO","2020-01-01T12:56:00.000000Z","METAR","2020-01-01","50.00","45.00","82.86","190.00","4.00",null,"30.140","1020.60","FEW","800.00","SCT","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011256Z 19004KT 10SM FEW008 SCT200 10/07 A3014 RMK AO2 SLP206 T01000072","CLISFO","59","47","final"],["KSFO","2020-01-01T13:56:00.000000Z","METAR","2020-01-01","47.00","45.00","93.06","290.00","3.00",null,"30.140","1020.50","FEW","800.00","FEW","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011356Z 29003KT 10SM FEW008 FEW200 08/07 A3014 RMK AO2 SLP205 T00830072","CLISFO","59","47","final"],["KSFO","2020-01-01T14:35:00.000000Z","SPECI","2020-01-01","50.00","46.00","86.06","260.00","6.00",null,"30.160",null,"FEW","600.00","BKN","1100.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011435Z 26006KT 10SM FEW006 BKN011 10/08 A3016 RMK AO2 T01000078 IEM_GHCNH","CLISFO","59","47","final"],["KSFO","2020-01-01T14:44:00.000000Z","SPECI","2020-01-01","52.00","48.00","86.17","260.00","5.00",null,"30.160",null,"FEW","600.00","SCT","1100.00","BKN","20000.00",null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011444Z 26005KT 10SM FEW006 SCT011 BKN200 11/09 A3016 RMK AO2 T01110089","CLISFO","59","47","final"],["KSFO","2020-01-01T14:56:00.000000Z","METAR","2020-01-01","53.00","49.00","85.59","280.00","10.00",null,"30.160","1021.30","FEW","600.00","SCT","1100.00","BKN","20000.00",null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011456Z 28010KT 10SM FEW006 SCT011 BKN200 12/09 A3016 RMK AO2 SLP213 T01170094 53009","CLISFO","59","47","final"],["KSFO","2020-01-01T15:18:00.000000Z","SPECI","2020-01-01","52.00","50.00","92.86","290.00","10.00",null,"30.150",null,"FEW","600.00","BKN","800.00","OVC","20000.00",null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 011518Z 29010KT 10SM FEW006 BKN008 OVC200 11/10 A3015 RMK AO2 T01110100","CLISFO","59","47","final"],["KSFO","2020-01-01T15:56:00.000000Z","METAR","2020-01-01","53.00","51.00","92.89","280.00","7.00",null,"30.140","1020.50","FEW","600.00","BKN","700.00","OVC","20000.00",null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 011556Z 28007KT 9SM FEW006 BKN007 OVC200 12/11 A3014 RMK AO2 SLP205 T01170106","CLISFO","59","47","final"],["KSFO","2020-01-01T16:56:00.000000Z","METAR","2020-01-01","55.00","51.00","86.66","280.00","11.00",null,"30.140","1020.70","FEW","600.00","BKN","700.00","OVC","20000.00",null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 011656Z 28011KT 9SM FEW006 BKN007 OVC200 13/11 A3014 RMK AO2 SLP207 T01280106","CLISFO","59","47","final"],["KSFO","2020-01-01T17:56:00.000000Z","METAR","2020-01-01","55.00","51.00","86.66","290.00","13.00","21.00","30.190","1022.20","FEW","600.00","BKN","800.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 011756Z 29013G21KT 9SM FEW006 BKN008 13/11 A3019 RMK AO2 SLP222 T01280106 10133 20083 53009","CLISFO","59","47","final"],["KSFO","2020-01-01T18:56:00.000000Z","METAR","2020-01-01","56.00","52.00","86.71","290.00","14.00",null,"30.170","1021.50","FEW","600.00","BKN","800.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 011856Z 29014KT 9SM FEW006 BKN008 13/11 A3017 RMK AO2 SLP215 T01330111","CLISFO","59","47","final"],["KSFO","2020-01-01T19:56:00.000000Z","METAR","2020-01-01","55.00","52.00","89.59","290.00","13.00",null,"30.160","1021.40","FEW","500.00","BKN","700.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 011956Z 29013KT 9SM FEW005 BKN007 13/11 A3016 RMK AO2 PRESFR SLP214 T01280111","CLISFO","59","47","final"],["KSFO","2020-01-01T20:56:00.000000Z","METAR","2020-01-01","55.00","52.00","89.59","270.00","18.00",null,"30.150","1020.80","BKN","600.00",null,null,null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 012056Z 27018KT 9SM BKN006 13/11 A3015 RMK AO2 SLP208 T01280111 56014","CLISFO","59","47","final"],["KSFO","2020-01-01T21:56:00.000000Z","METAR","2020-01-01","58.00","52.00","80.67","290.00","12.00",null,"30.140","1020.40","SCT","600.00","BKN","1000.00","BKN","20000.00",null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 012156Z 29012KT 9SM SCT006 BKN010 BKN200 14/11 A3014 RMK AO2 SLP204 T01440111","CLISFO","59","47","final"],["KSFO","2020-01-01T22:56:00.000000Z","METAR","2020-01-01","56.00","52.00","86.71","280.00","15.00",null,"30.110","1019.50","FEW","600.00","BKN","900.00","BKN","20000.00",null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 012256Z 28015KT 9SM FEW006 BKN009 BKN200 13/11 A3011 RMK AO2 SLP195 T01330111","CLISFO","59","47","final"],["KSFO","2020-01-01T23:56:00.000000Z","METAR","2020-01-01","55.00","53.00","93.29","280.00","19.00",null,"30.100","1019.20","SCT","600.00","BKN","800.00","OVC","20000.00",null,null,"9.00",null,"0.000","28.00","270.00","2020-01-01 23:32",null,"KSFO 012356Z 28019KT 9SM SCT006 BKN008 OVC200 13/12 A3010 RMK AO2 PK WND 27028/2332 SLP192 T01280117 10150 20128 56015","CLISFO","59","47","final"],["KSFO","2020-01-02T00:56:00.000000Z","METAR","2020-01-01","56.00","53.00","90.29","280.00","15.00",null,"30.090","1019.00","SCT","400.00","BKN","600.00","OVC","800.00",null,null,"7.00",null,"0.000","26.00","270.00","2020-01-02 00:28",null,"KSFO 020056Z 28015KT 7SM SCT004 BKN006 OVC008 13/12 A3009 RMK AO2 PK WND 27026/0028 SLP190 T01330117","CLISFO","59","47","final"],["KSFO","2020-01-02T01:56:00.000000Z","METAR","2020-01-01","55.00","52.00","89.59","270.00","19.00","24.00","30.090","1018.80","SCT","500.00","BKN","700.00","OVC","900.00",null,null,"7.00",null,"0.000","30.00","280.00","2020-01-02 01:43",null,"KSFO 020156Z 27019G24KT 7SM SCT005 BKN007 OVC009 13/11 A3009 RMK AO2 PK WND 28030/0143 SLP188 T01280111","CLISFO","59","47","final"],["KSFO","2020-01-02T02:56:00.000000Z","METAR","2020-01-01","55.00","52.00","89.59","270.00","15.00","22.00","30.090","1018.80","SCT","600.00","BKN","800.00","OVC","1000.00",null,null,"8.00",null,"0.000","26.00","270.00","2020-01-02 02:01",null,"KSFO 020256Z 27015G22KT 8SM SCT006 BKN008 OVC010 13/11 A3009 RMK AO2 PK WND 27026/0201 SLP188 T01280111 56005","CLISFO","59","47","final"],["KSFO","2020-01-02T03:56:00.000000Z","METAR","2020-01-01","55.00","51.00","86.66","280.00","22.00",null,"30.110","1019.50","SCT","700.00","BKN","900.00","BKN","1100.00",null,null,"8.00",null,"0.000",null,null,null,null,"KSFO 020356Z 28022KT 8SM SCT007 BKN009 BKN011 13/11 A3011 RMK AO2 SLP195 T01280106","CLISFO","59","47","final"],["KSFO","2020-01-02T04:56:00.000000Z","METAR","2020-01-01","55.00","51.00","86.66","280.00","16.00","23.00","30.110","1019.60","SCT","700.00","BKN","900.00","BKN","1100.00",null,null,"8.00",null,"0.000","26.00","280.00","2020-01-02 03:58",null,"KSFO 020456Z 28016G23KT 8SM SCT007 BKN009 BKN011 13/11 A3011 RMK AO2 PK WND 28026/0358 SLP196 T01280106","CLISFO","59","47","final"],["KSFO","2020-01-02T05:47:00.000000Z","SPECI","2020-01-01","53.00","50.00","89.18","270.00","20.00",null,"30.100",null,"FEW","600.00","SCT","800.00","SCT","20000.00",null,null,"8.00",null,"0.000",null,null,null,null,"KSFO 020547Z 27020KT 8SM FEW006 SCT008 SCT200 12/10 A3010 RMK AO2 T01170100","CLISFO","59","47","final"],["KSFO","2020-01-02T05:56:00.000000Z","METAR","2020-01-01","53.00","50.00","89.18","280.00","20.00",null,"30.100","1019.30","FEW","600.00","SCT","800.00","SCT","20000.00",null,null,"8.00",null,"0.000",null,null,null,null,"KSFO 020556Z 28020KT 8SM FEW006 SCT008 SCT200 12/10 A3010 RMK AO2 SLP193 T01170100 10133 20117 50006","CLISFO","59","47","final"],["KSFO","2020-01-02T06:48:00.000000Z","SPECI","2020-01-01","54.00","50.00","86.29","280.00","14.00",null,"30.130",null,"FEW","600.00","BKN","800.00","BKN","20000.00",null,null,"10.00",null,"0.000","26.00","280.00","2020-01-02 06:05",null,"KSFO 020648Z 28014KT 10SM FEW006 BKN008 BKN200 12/10 A3013 RMK AO2 PK WND 28026/0605 T01220100","CLISFO","59","47","final"],["KSFO","2020-01-02T06:56:00.000000Z","METAR","2020-01-01","55.00","50.00","83.20","290.00","14.00",null,"30.130","1020.20","FEW","600.00","BKN","800.00","BKN","20000.00",null,null,"10.00",null,"0.000","26.00","280.00","2020-01-02 06:05",null,"KSFO 020656Z 29014KT 10SM FEW006 BKN008 BKN200 13/10 A3013 RMK AO2 PK WND 28026/0605 SLP202 T01280100","CLISFO","59","47","final"],["KSFO","2020-01-02T07:56:00.000000Z","METAR","2020-01-01","53.00","50.00","89.18","280.00","13.00",null,"30.130","1020.30","FEW","500.00","SCT","700.00","BKN","20000.00",null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 020756Z 28013KT 10SM FEW005 SCT007 BKN200 12/10 A3013 RMK AO2 SLP203 T01170100 401500083","CLISFO","59","47","final"],["KSFO","2020-01-02T08:56:00.000000Z","METAR","2020-01-02","53.00","49.00","85.59","280.00","11.00",null,"30.100","1019.30","FEW","700.00","FEW","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 020856Z 28011KT 10SM FEW007 FEW200 12/09 A3010 RMK AO2 SLP193 T01170094 58001","CLISFO","61","49","final"],["KSFO","2020-01-02T09:56:00.000000Z","METAR","2020-01-02","53.00","49.00","85.59","290.00","10.00",null,"30.110","1019.50","FEW","700.00","FEW","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 020956Z 29010KT 10SM FEW007 FEW200 12/09 A3011 RMK AO2 SLP195 T01170094","CLISFO","61","49","final"],["KSFO","2020-01-02T10:56:00.000000Z","METAR","2020-01-02","53.00","49.00","85.59","280.00","9.00",null,"30.110","1019.70","FEW","900.00","FEW","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 021056Z 28009KT 10SM FEW009 FEW200 12/09 A3011 RMK AO2 SLP197 T01170094","CLISFO","61","49","final"],["KSFO","2020-01-02T11:56:00.000000Z","METAR","2020-01-02","52.00","48.00","86.17","310.00","4.00",null,"30.100","1019.30","FEW","300.00","FEW","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 021156Z 31004KT 10SM FEW003 FEW200 11/09 A3010 RMK AO2 SLP193 T01110089 10128 20111 50001","CLISFO","61","49","final"],["KSFO","2020-01-02T12:56:00.000000Z","METAR","2020-01-02","49.00","47.00","92.77","290.00","5.00",null,"30.120","1019.90","FEW","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 021256Z 29005KT 10SM FEW200 09/08 A3012 RMK AO2 SLP199 T00940083","CLISFO","61","49","final"],["KSFO","2020-01-02T13:56:00.000000Z","METAR","2020-01-02","50.00","46.00","86.06","280.00","5.00",null,"30.120","1019.90","FEW","300.00","FEW","20000.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 021356Z 28005KT 9SM FEW003 FEW200 10/08 A3012 RMK AO2 SLP199 T01000078","CLISFO","61","49","final"],["KSFO","2020-01-02T14:56:00.000000Z","METAR","2020-01-02","50.00","46.00","86.06","260.00","5.00",null,"30.130","1020.10","FEW","20000.00",null,null,null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 021456Z 26005KT 9SM FEW200 10/08 A3013 RMK AO2 SLP201 T01000078 51007","CLISFO","61","49","final"],["KSFO","2020-01-02T15:09:00.000000Z","SPECI","2020-01-02","50.00","45.00","82.86","250.00","5.00",null,"30.120",null,"FEW","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 021509Z 25005KT 10SM FEW200 10/07 A3012 RMK AO2 T01000072","CLISFO","61","49","final"],["KSFO","2020-01-02T15:56:00.000000Z","METAR","2020-01-02","50.00","45.00","82.86","280.00","6.00",null,"30.140","1020.40","FEW","100.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 021556Z 28006KT 10SM FEW001 BKN200 10/07 A3014 RMK AO2 SLP204 T01000072","CLISFO","61","49","final"],["KSFO","2020-01-02T16:56:00.000000Z","METAR","2020-01-02","55.00","48.00","77.21","50.00","3.00",null,"30.160","1021.20","FEW","100.00","BKN","20000.00",null,null,null,null,"4.00","HZ","0.000",null,null,null,null,"KSFO 021656Z 05003KT 4SM HZ FEW001 BKN200 13/09 A3016 RMK AO2 SLP212 T01280089","CLISFO","61","49","final"],["KSFO","2020-01-02T17:12:00.000000Z","SPECI","2020-01-02","52.00","49.00","89.13","100.00","5.00",null,"30.160",null,"FEW","100.00","BKN","20000.00",null,null,null,null,"1.75","BR","0.000",null,null,null,null,"KSFO 021712Z 10005KT 1 3/4SM BR FEW001 BKN200 11/09 A3016 RMK AO2 T01110094","CLISFO","61","49","final"],["KSFO","2020-01-02T17:28:00.000000Z","SPECI","2020-01-02","50.00","48.00","92.80","100.00","4.00",null,"30.170",null,"SCT","200.00","BKN","20000.00",null,null,null,null,"2.00","BR","0.000",null,null,null,null,"KSFO 021728Z 10004KT 2SM BR SCT002 BKN200 10/09 A3017 RMK AO2 T01000089","CLISFO","61","49","final"],["KSFO","2020-01-02T17:36:00.000000Z","SPECI","2020-01-02","50.00","48.00","92.80","90.00","4.00",null,"30.170",null,"SCT","200.00","BKN","20000.00",null,null,null,null,"3.00","BR","0.000",null,null,null,null,"KSFO 021736Z 09004KT 3SM BR SCT002 BKN200 10/09 A3017 RMK AO2 T01000089","CLISFO","61","49","final"],["KSFO","2020-01-02T17:39:00.000000Z","SPECI","2020-01-02","50.00","49.00","95.98","80.00","4.00",null,"30.170",null,"SCT","200.00","BKN","20000.00",null,null,null,null,"6.00","BR","0.000",null,null,null,null,"KSFO 021739Z 08004KT 6SM BR SCT002 BKN200 10/09 A3017 RMK AO2 T01000094","CLISFO","61","49","final"],["KSFO","2020-01-02T17:56:00.000000Z","METAR","2020-01-02","52.00","49.00","89.13","0.00","0.00",null,"30.170","1021.70","FEW","100.00","BKN","20000.00",null,null,null,null,"6.00","BR","0.000",null,null,null,null,"KSFO 021756Z 00000KT 6SM BR FEW001 BKN200 11/09 A3017 RMK AO2 SLP217 T01110094 10128 20094 53016","CLISFO","61","49","final"],["KSFO","2020-01-02T18:56:00.000000Z","METAR","2020-01-02","53.00","49.00","85.59","80.00","4.00",null,"30.170","1021.80","FEW","100.00","BKN","20000.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 021856Z 08004KT 9SM FEW001 BKN200 12/09 A3017 RMK AO2 SLP218 T01170094","CLISFO","61","49","final"],["KSFO","2020-01-02T19:56:00.000000Z","METAR","2020-01-02","55.00","48.00","77.21","70.00","3.00",null,"30.140","1020.70","FEW","100.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 021956Z 07003KT 10SM FEW001 BKN200 13/09 A3014 RMK AO2 SLP207 T01280089","CLISFO","61","49","final"],["KSFO","2020-01-02T20:56:00.000000Z","METAR","2020-01-02","55.00","47.00","74.08","60.00","3.00",null,"30.120","1019.80","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 022056Z 06003KT 10SM BKN200 13/08 A3012 RMK AO2 SLP198 T01280083 58019","CLISFO","61","49","final"],["KSFO","2020-01-02T21:56:00.000000Z","METAR","2020-01-02","57.00","47.00","68.90","30.00","3.00",null,"30.100","1019.30","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 022156Z 03003KT 10SM BKN200 14/08 A3010 RMK AO2 SLP193 T01390083","CLISFO","61","49","final"],["KSFO","2020-01-02T22:56:00.000000Z","METAR","2020-01-02","59.00","45.00","59.67","0.00","0.00",null,"30.100","1019.10","FEW","17000.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 022256Z 00000KT 10SM FEW170 BKN200 15/07 A3010 RMK AO2 SLP191 T01500072","CLISFO","61","49","final"],["KSFO","2020-01-02T23:56:00.000000Z","METAR","2020-01-02","60.00","48.00","64.26","280.00","10.00",null,"30.110","1019.40","FEW","17000.00","SCT","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 022356Z 28010KT 10SM FEW170 SCT200 16/09 A3011 RMK AO2 SLP194 T01560089 10161 20111 55003","CLISFO","61","49","final"],["KSFO","2020-01-03T00:56:00.000000Z","METAR","2020-01-02","55.00","48.00","77.21","280.00","11.00",null,"30.120","1019.80","SCT","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 030056Z 28011KT 10SM SCT200 13/09 A3012 RMK AO2 SLP198 T01280089","CLISFO","61","49","final"],["KSFO","2020-01-03T01:56:00.000000Z","METAR","2020-01-02","56.00","48.00","74.72","280.00","8.00",null,"30.120","1019.90","FEW","18000.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 030156Z 28008KT 10SM FEW180 BKN200 13/09 A3012 RMK AO2 SLP199 T01330089","CLISFO","61","49","final"],["KSFO","2020-01-03T02:56:00.000000Z","METAR","2020-01-02","53.00","48.00","82.76","290.00","9.00",null,"30.130","1020.10","FEW","18000.00","SCT","20000.00",null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 030256Z 29009KT 9SM FEW180 SCT200 12/09 A3013 RMK AO2 SLP201 T01170089 51006","CLISFO","61","49","final"],["KSFO","2020-01-03T03:56:00.000000Z","METAR","2020-01-02","53.00","48.00","82.76","280.00","5.00",null,"30.150","1020.80","FEW","18000.00","SCT","20000.00",null,null,null,null,"8.00",null,"0.000",null,null,null,null,"KSFO 030356Z 28005KT 8SM FEW180 SCT200 12/09 A3015 RMK AO2 SLP208 T01170089","CLISFO","61","49","final"],["KSFO","2020-01-03T04:56:00.000000Z","METAR","2020-01-02","53.00","46.00","76.75","280.00","4.00",null,"30.160","1021.20","SCT","20000.00",null,null,null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 030456Z 28004KT 9SM SCT200 12/08 A3016 RMK AO2 SLP212 T01170078","CLISFO","61","49","final"],["KSFO","2020-01-03T05:56:00.000000Z","METAR","2020-01-02","53.00","45.00","73.89","190.00","3.00",null,"30.170","1021.70","SCT","20000.00",null,null,null,null,null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 030556Z 19003KT 9SM SCT200 12/07 A3017 RMK AO2 SLP217 T01170072 10156 20111 51016","CLISFO","61","49","final"],["KSFO","2020-01-03T06:56:00.000000Z","METAR","2020-01-02","50.00","44.00","80.06","0.00","0.00",null,"30.170","1021.60","FEW","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 030656Z 00000KT 10SM FEW200 10/07 A3017 RMK AO2 SLP216 T01000067","CLISFO","61","49","final"],["KSFO","2020-01-03T07:56:00.000000Z","METAR","2020-01-02","52.00","46.00","79.92","0.00","0.00",null,"30.170","1021.40","SCT","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 030756Z 00000KT 10SM SCT200 11/08 A3017 RMK AO2 SLP214 T01110078 401610094","CLISFO","61","49","final"],["KSFO","2020-01-03T08:56:00.000000Z","METAR","2020-01-03","50.00","43.00","76.76","0.00","0.00",null,"30.160","1021.40","SCT","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 030856Z 00000KT 10SM SCT200 10/06 A3016 RMK AO2 SLP214 T01000061 56003","CLISFO","58","44","final"],["KSFO","2020-01-03T09:56:00.000000Z","METAR","2020-01-03","47.00","42.00","83.28","0.00","0.00",null,"30.170","1021.60","FEW","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 030956Z 00000KT 10SM FEW200 08/06 A3017 RMK AO2 SLP216 T00830056","CLISFO","58","44","final"],["KSFO","2020-01-03T10:56:00.000000Z","METAR","2020-01-03","47.00","43.00","86.21","0.00","0.00",null,"30.170","1021.60","FEW","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031056Z 00000KT 10SM FEW200 08/06 A3017 RMK AO2 SLP216 T00830061","CLISFO","58","44","final"],["KSFO","2020-01-03T11:56:00.000000Z","METAR","2020-01-03","48.00","42.00","79.91","0.00","0.00",null,"30.170","1021.60","FEW","500.00","FEW","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031156Z 00000KT 10SM FEW005 FEW200 09/06 A3017 RMK AO2 SLP216 T00890056 10117 20083 50002","CLISFO","58","44","final"],["KSFO","2020-01-03T12:56:00.000000Z","METAR","2020-01-03","45.00","41.00","85.77","0.00","0.00",null,"30.180","1021.80","FEW","400.00","FEW","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031256Z 00000KT 10SM FEW004 FEW200 07/05 A3018 RMK AO2 SLP218 T00720050","CLISFO","58","44","final"],["KSFO","2020-01-03T13:56:00.000000Z","METAR","2020-01-03","47.00","43.00","86.21","0.00","0.00",null,"30.170","1021.60","FEW","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031356Z 00000KT 10SM FEW200 08/06 A3017 RMK AO2 SLP216 T00830061","CLISFO","58","44","final"],["KSFO","2020-01-03T14:56:00.000000Z","METAR","2020-01-03","50.00","47.00","89.04","40.00","5.00",null,"30.180","1022.00","FEW","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031456Z 04005KT 10SM FEW200 10/08 A3018 RMK AO2 SLP220 T01000083 53004","CLISFO","58","44","final"],["KSFO","2020-01-03T15:56:00.000000Z","METAR","2020-01-03","47.00","43.00","86.21","150.00","3.00",null,"30.190","1022.30","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031556Z 15003KT 10SM BKN200 08/06 A3019 RMK AO2 SLP223 T00830061","CLISFO","58","44","final"],["KSFO","2020-01-03T16:56:00.000000Z","METAR","2020-01-03","51.00","45.00","79.54","0.00","0.00",null,"30.220","1023.40","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031656Z 00000KT 10SM BKN200 11/07 A3022 RMK AO2 SLP234 T01060072","CLISFO","58","44","final"],["KSFO","2020-01-03T17:56:00.000000Z","METAR","2020-01-03","53.00","46.00","76.75","0.00","0.00",null,"30.250","1024.20","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031756Z 00000KT 10SM BKN200 12/08 A3025 RMK AO2 SLP242 T01170078 10117 20067 53022","CLISFO","58","44","final"],["KSFO","2020-01-03T18:56:00.000000Z","METAR","2020-01-03","53.00","46.00","76.75","10.00","3.00",null,"30.240","1023.90","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031856Z 01003KT 10SM BKN200 12/08 A3024 RMK AO2 SLP239 T01170078","CLISFO","58","44","final"],["KSFO","2020-01-03T19:56:00.000000Z","METAR","2020-01-03","55.00","47.00","74.08","40.00","5.00",null,"30.220","1023.20","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 031956Z 04005KT 10SM BKN200 13/08 A3022 RMK AO2 SLP232 T01280083","CLISFO","58","44","final"],["KSFO","2020-01-03T20:56:00.000000Z","METAR","2020-01-03","55.00","46.00","71.60","40.00","5.00",null,"30.200","1022.60","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 032056Z 04005KT 10SM BKN200 13/08 A3020 RMK AO2 SLP226 T01280078 58016","CLISFO","58","44","final"],["KSFO","2020-01-03T21:56:00.000000Z","METAR","2020-01-03","56.00","47.00","71.69","360.00","4.00",null,"30.190","1022.40","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 032156Z 36004KT 10SM BKN200 13/08 A3019 RMK AO2 SLP224 T01330083","CLISFO","58","44","final"],["KSFO","2020-01-03T22:56:00.000000Z","METAR","2020-01-03","57.00","45.00","64.12","0.00","0.00",null,"30.200","1022.50","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 032256Z 00000KT 10SM BKN200 14/07 A3020 RMK AO2 SLP225 T01390072","CLISFO","58","44","final"],["KSFO","2020-01-03T23:56:00.000000Z","METAR","2020-01-03","55.00","48.00","77.21","360.00","5.00",null,"30.200","1022.60","BKN","20000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 032356Z 36005KT 10SM BKN200 13/09 A3020 RMK AO2 SLP226 T01280089 10144 20111 55001","CLISFO","58","44","final"],["KSFO","2020-01-04T00:56:00.000000Z","METAR","2020-01-03","55.00","47.00","74.08","360.00","3.00",null,"30.200","1022.70","FEW","18000.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040056Z 36003KT 10SM FEW180 BKN200 13/08 A3020 RMK AO2 SLP227 T01280083","CLISFO","58","44","final"],["KSFO","2020-01-04T01:56:00.000000Z","METAR","2020-01-03","53.00","48.00","82.76","0.00","0.00",null,"30.200","1022.80","SCT","18000.00","BKN","20000.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040156Z 00000KT 10SM SCT180 BKN200 12/09 A3020 RMK AO2 SLP228 T01170089","CLISFO","58","44","final"],["KSFO","2020-01-04T02:56:00.000000Z","METAR","2020-01-03","54.00","45.00","71.50","0.00","0.00",null,"30.220","1023.20","SCT","18000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040256Z 00000KT 10SM SCT180 12/07 A3022 RMK AO2 SLP232 T01220072 53007","CLISFO","58","44","final"],["KSFO","2020-01-04T03:56:00.000000Z","METAR","2020-01-03","55.00","44.00","66.61","190.00","9.00",null,"30.230","1023.60","FEW","18000.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040356Z 19009KT 10SM FEW180 13/07 A3023 RMK AO2 SLP236 T01280067","CLISFO","58","44","final"],["KSFO","2020-01-04T04:56:00.000000Z","METAR","2020-01-03","56.00","46.00","69.30","130.00","11.00",null,"30.250","1024.30","CLR",null,null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040456Z 13011KT 10SM CLR 13/08 A3025 RMK AO2 SLP243 T01330078","CLISFO","58","44","final"],["KSFO","2020-01-04T05:56:00.000000Z","METAR","2020-01-03","56.00","48.00","74.72","150.00","7.00",null,"30.270","1024.90","FEW","1500.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040556Z 15007KT 10SM FEW015 13/09 A3027 RMK AO2 SLP249 T01330089 10144 20111 53017","CLISFO","58","44","final"],["KSFO","2020-01-04T06:56:00.000000Z","METAR","2020-01-03","55.00","48.00","77.21","150.00","8.00",null,"30.280","1025.20","FEW","1200.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040656Z 15008KT 10SM FEW012 13/09 A3028 RMK AO2 SLP252 T01280089","CLISFO","58","44","final"],["KSFO","2020-01-04T07:56:00.000000Z","METAR","2020-01-03","54.00","46.00","74.26","130.00","8.00",null,"30.260","1024.80","FEW","1300.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040756Z 13008KT 10SM FEW013 12/08 A3026 RMK AO2 SLP248 T01220078 401440067","CLISFO","58","44","final"],["KSFO","2020-01-04T08:56:00.000000Z","METAR","2020-01-04","52.00","43.00","71.28",null,"3.00",null,"30.280","1025.20","FEW","1500.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040856Z VRB03KT 10SM FEW015 11/06 A3028 RMK AO2 SLP252 T01110061 53002","CLISFO","59","49","final"],["KSFO","2020-01-04T09:56:00.000000Z","METAR","2020-01-04","53.00","46.00","76.75","330.00","4.00",null,"30.300","1025.90","FEW","1500.00",null,null,null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 040956Z 33004KT 10SM FEW015 12/08 A3030 RMK AO2 SLP259 T01170078","CLISFO","59","49","final"],["KSFO","2020-01-04T10:56:00.000000Z","METAR","2020-01-04","53.00","46.00","76.75",null,"4.00",null,"30.290","1025.70","FEW","1300.00","SCT","1600.00",null,null,null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 041056Z VRB04KT 10SM FEW013 SCT016 12/08 A3029 RMK AO2 SLP257 T01170078","CLISFO","59","49","final"],["KSFO","2020-01-04T11:56:00.000000Z","METAR","2020-01-04","54.00","46.00","74.26","190.00","11.00",null,"30.290","1025.80","FEW","1500.00","SCT","5000.00","SCT","11000.00",null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 041156Z 19011KT 10SM FEW015 SCT050 SCT110 12/08 A3029 RMK AO2 SLP258 T01220078 10133 20100 51006","CLISFO","59","49","final"],["KSFO","2020-01-04T12:56:00.000000Z","METAR","2020-01-04","53.00","47.00","79.40","160.00","9.00",null,"30.300","1025.90","FEW","2000.00","BKN","3000.00","OVC","4000.00",null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 041256Z 16009KT 10SM FEW020 BKN030 OVC040 12/08 A3030 RMK AO2 SLP259 T01170083","CLISFO","59","49","final"],["KSFO","2020-01-04T13:22:00.000000Z","SPECI","2020-01-04","52.00","48.00","86.17","160.00","10.00",null,"30.310",null,"BKN","2100.00","BKN","2800.00","OVC","3800.00",null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 041322Z 16010KT 10SM BKN021 BKN028 OVC038 11/09 A3031 RMK AO2 T01110089","CLISFO","59","49","final"],["KSFO","2020-01-04T13:56:00.000000Z","METAR","2020-01-04","53.00","48.00","82.76","150.00","9.00",null,"30.320","1026.80","FEW","1800.00","BKN","2100.00","OVC","2600.00",null,null,"10.00",null,"0.000",null,null,null,null,"KSFO 041356Z 15009KT 10SM FEW018 BKN021 OVC026 12/09 A3032 RMK AO2 SLP268 T01170089","CLISFO","59","49","final"],["KSFO","2020-01-04T14:56:00.000000Z","METAR","2020-01-04","52.00","48.00","86.17","210.00","11.00",null,"30.340","1027.30","FEW","1800.00","SCT","2600.00","BKN","6000.00",null,null,"9.00",null,"0.000",null,null,null,null,"KSFO 041456Z 21011KT 9SM FEW018 SCT026 BKN060 11/09 A3034 RMK AO2 SLP273 T01110089 53016","CLISFO","59","49","final"]],"row_count_in_preview":100,"total_row_count":66286,"preview_truncated":true,"limits":{"rows":100,"columns":256},"citation":{"dataset_url":"https://mostlyright.md/datasets/us-weather-reports-and-daily-highs-in-20-cities","table_url":"https://mostlyright.md/datasets/us-weather-reports-and-daily-highs-in-20-cities/tables?table=reports-ksfo","table_version_id":"97238273-943e-51e2-b54a-145eaa2a41b5","content_digest":null}}