fivethirtyeight: us-weather-history/KNYC: 65 rows where average

This table contains data and code behind the story What 12 Months Of Record-Setting Temperatures Looks Like Across The U.S..

Code

Code file	Description
`wunderground_scraper.py`	Downloads weather data web pages from Weather Underground
`wunderground_parser.py`	Parses the weather data from Weather Underground into a flat CSV file
`visualize_weather.py`	Creates the visualization of the weather data

Data

Column	Description
`date`	The date of the weather record, formatted YYYY-M-D
`actual_mean_temp`	The measured average temperature for that day
`actual_min_temp`	The measured minimum temperature for that day
`actual_max_temp`	The measured maximum temperature for that day
`average_min_temp`	The average minimum temperature on that day since 1880
`average_max_temp`	The average maximum temperature on that day since 1880
`record_min_temp`	The lowest ever temperature on that day since 1880
`record_max_temp`	The highest ever temperature on that day since 1880
`record_min_temp_year`	The year that the lowest ever temperature occurred
`record_max_temp_year`	The year that the highest ever temperature occurred
`actual_precipitation`	The measured amount of rain or snow for that day
`average_precipitation`	The average amount of rain or snow on that day since 1880
`record_precipitation`	The highest amount of rain or snow on that day since 1880

Source: Weather Underground

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

65 rows where average_precipitation = "0.15"

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid ▼	date	actual_mean_temp	actual_min_temp	actual_max_temp	average_min_temp	average_max_temp	record_min_temp	record_max_temp	record_min_temp_year	record_max_temp_year	actual_precipitation	average_precipitation	record_precipitation
10	10	2014-7-10	78	72	83	69	84	55	102	1890	1993	0.0	0.15	1.79
11	11	2014-7-11	79	71	86	69	84	57	98	1898	1988	0.0	0.15	1.94
12	12	2014-7-12	78	71	85	69	84	57	99	1926	1966	0.0	0.15	2.68
15	15	2014-7-15	79	72	86	69	84	57	102	1930	1995	1.3	0.15	2.33
17	17	2014-7-17	74	67	81	69	84	57	100	1892	1953	0.0	0.15	3.13
18	18	2014-7-18	73	64	81	69	84	57	101	1925	1953	0.0	0.15	1.76
20	20	2014-7-20	72	66	78	69	84	55	101	1890	1980	0.0	0.15	1.97
21	21	2014-7-21	76	67	85	69	84	55	104	1890	1977	0.0	0.15	2.26
23	23	2014-7-23	80	72	88	69	84	58	100	1890	2011	0.19	0.15	2.41
24	24	2014-7-24	75	70	80	69	84	56	97	1893	1999	0.0	0.15	3.75
25	25	2014-7-25	74	66	82	69	84	57	97	1953	1999	0.0	0.15	1.64
38	38	2014-8-7	75	66	83	69	84	57	104	1994	1918	0.0	0.15	2.18
39	39	2014-8-8	74	65	83	69	84	54	99	1903	2001	0.0	0.15	2.6
40	40	2014-8-9	77	66	87	69	84	57	103	1989	2001	0.0	0.15	4.1
45	45	2014-8-14	70	63	77	68	83	54	99	1964	1988	0.0	0.15	5.81
47	47	2014-8-16	71	63	78	68	83	55	96	1880	1944	0.0	0.15	4.8
50	50	2014-8-19	73	63	83	68	83	55	94	1924	2002	0.0	0.15	2.53
52	52	2014-8-21	74	65	83	68	82	53	96	1922	1955	0.35	0.15	4.19
77	77	2014-9-15	63	55	71	61	76	45	92	1913	1927	0.0	0.15	4.16
78	78	2014-9-16	64	58	70	61	75	47	93	1966	1915	0.37	0.15	5.02
79	79	2014-9-17	64	55	73	61	75	45	93	1986	1991	0.0	0.15	3.37
80	80	2014-9-18	67	57	76	60	75	44	91	1990	1891	0.0	0.15	3.92
81	81	2014-9-19	60	54	66	60	74	44	94	1929	1983	0.0	0.15	4.3
82	82	2014-9-20	66	57	75	59	74	44	93	1993	1983	0.0	0.15	2.32
83	83	2014-9-21	71	67	75	59	73	40	95	1871	1895	0.15	0.15	5.54
84	84	2014-9-22	63	55	71	59	73	41	95	1904	1914	0.0	0.15	2.34
86	86	2014-9-24	65	58	71	58	72	40	89	1963	1959	0.0	0.15	2.26
88	88	2014-9-26	68	58	77	57	71	42	91	1940	1970	0.0	0.15	2.34
89	89	2014-9-27	72	60	83	57	71	41	90	1957	1933	0.0	0.15	3.13
93	93	2014-10-1	63	61	65	55	69	36	88	1947	1927	0.02	0.15	4.98
97	97	2014-10-5	54	46	61	54	68	35	94	1881	1941	0.0	0.15	1.99
99	99	2014-10-7	67	63	71	53	67	39	88	1999	1944	0.06	0.15	4.09
101	101	2014-10-9	62	55	68	52	66	37	86	2000	1916	0.0	0.15	7.33
103	103	2014-10-11	55	50	60	51	65	34	85	1964	1949	0.33	0.15	3.06
106	106	2014-10-14	70	63	76	50	64	37	84	1988	1920	0.0	0.15	1.76
114	114	2014-10-22	54	50	58	48	62	30	88	1940	1979	1.51	0.15	1.51
117	117	2014-10-25	59	50	67	47	61	29	79	1879	1963	0.01	0.15	3.3
153	153	2014-11-30	50	45	55	37	49	7	70	1875	1991	0.0	0.15	1.11
156	156	2014-12-3	44	41	46	36	47	9	69	1976	1998	0.06	0.15	1.63
260	260	2015-3-17	46	34	57	35	50	9	75	1916	1945	0.02	0.15	1.42
262	262	2015-3-19	36	29	43	36	51	8	76	1967	1918	0.0	0.15	2.19
263	263	2015-3-20	34	29	38	36	51	11	83	1885	1945	0.4	0.15	1.93
264	264	2015-3-21	38	29	47	37	51	10	84	1885	1921	0.0	0.15	2.37
265	265	2015-3-22	36	28	43	37	52	12	78	1885	2012	0.0	0.15	3.44
267	267	2015-3-24	36	26	45	37	52	12	76	1888	1988	0.0	0.15	2.05
268	268	2015-3-25	42	34	49	38	53	13	79	1878	1963	0.05	0.15	4.25
269	269	2015-3-26	52	42	62	38	53	20	76	1960	1922	0.32	0.15	1.42
271	271	2015-3-28	33	26	40	39	54	13	84	1923	1945	0.0	0.15	2.98
272	272	2015-3-29	36	25	46	39	54	10	86	1923	1945	0.0	0.15	2.03
274	274	2015-3-31	41	35	47	40	55	14	86	1923	1998	0.17	0.15	2.2
280	280	2015-4-6	53	42	63	42	58	21	79	1982	1947	0.0	0.15	2.52
282	282	2015-4-8	41	37	45	42	58	25	90	1982	1991	0.0	0.15	1.93
289	289	2015-4-15	62	51	72	45	61	28	87	1943	1941	0.0	0.15	7.57
291	291	2015-4-17	63	55	71	45	62	28	96	1875	2002	0.08	0.15	1.29
293	293	2015-4-19	56	48	64	46	63	21	92	1875	1976	0.0	0.15	1.96
302	302	2015-4-28	61	50	71	49	66	34	90	1934	1990	0.0	0.15	2.74
326	326	2015-5-22	65	55	74	56	72	44	96	1990	1941	0.0	0.15	1.25
327	327	2015-5-23	60	49	70	56	73	43	94	1963	1964	0.0	0.15	2.7
328	328	2015-5-24	69	56	81	56	73	39	93	1963	1975	0.0	0.15	2.07
329	329	2015-5-25	75	64	85	57	73	41	95	1925	1880	0.0	0.15	0.86
330	330	2015-5-26	78	67	88	57	74	42	95	1967	1880	0.0	0.15	1.28
334	334	2015-5-30	76	67	85	58	75	42	97	1884	1987	0.0	0.15	2.19
335	335	2015-5-31	72	57	87	59	75	46	96	1938	1939	1.46	0.15	3.13
350	350	2015-6-15	74	64	83	64	79	48	96	1933	1994	0.57	0.15	1.13
351	351	2015-6-16	72	65	79	64	80	52	97	1927	1891	0.27	0.15	1.31

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "us-weather-history/KNYC" (
"date" TEXT,
  "actual_mean_temp" INTEGER,
  "actual_min_temp" INTEGER,
  "actual_max_temp" INTEGER,
  "average_min_temp" INTEGER,
  "average_max_temp" INTEGER,
  "record_min_temp" INTEGER,
  "record_max_temp" INTEGER,
  "record_min_temp_year" INTEGER,
  "record_max_temp_year" INTEGER,
  "actual_precipitation" REAL,
  "average_precipitation" REAL,
  "record_precipitation" REAL
);

U.S. Weather History: KNYC.csv

Code

Data

65 rows where average_precipitation = "0.15"

Advanced export