fivethirtyeight: us-weather-history/KNYC: 365 rows

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

365 rows

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
101	101	2014-10-9	62	55	68	52	66	37	86	2000	1916	0.0	0.15	7.33
102	102	2014-10-10	58	52	64	52	66	35	91	1888	1939	0.0	0.16	2.16
103	103	2014-10-11	55	50	60	51	65	34	85	1964	1949	0.33	0.15	3.06
104	104	2014-10-12	56	48	63	51	65	35	86	1876	1954	0.0	0.14	4.26
105	105	2014-10-13	59	52	65	51	65	33	87	1875	1954	0.05	0.14	2.75
106	106	2014-10-14	70	63	76	50	64	37	84	1988	1920	0.0	0.15	1.76
107	107	2014-10-15	73	69	77	50	64	32	84	1876	1956	0.69	0.14	1.7
108	108	2014-10-16	66	61	71	50	64	34	87	1876	1897	1.11	0.14	2.15
109	109	2014-10-17	65	59	71	50	63	33	90	1886	1938	0.0	0.14	2.28
110	110	2014-10-18	63	56	70	49	63	35	82	1974	1928	0.0	0.14	2.45
111	111	2014-10-19	50	44	56	49	63	30	83	1940	1963	0.0	0.14	4.35
112	112	2014-10-20	51	42	60	49	62	31	80	1974	1969	0.0	0.14	2.78
113	113	2014-10-21	61	55	67	48	62	32	84	1974	1920	0.11	0.14	2.17
114	114	2014-10-22	54	50	58	48	62	30	88	1940	1979	1.51	0.15	1.51
115	115	2014-10-23	52	50	53	48	61	32	85	1969	1947	0.61	0.14	2.97
116	116	2014-10-24	57	51	63	48	61	31	79	1969	2001	0.0	0.14	2.51
117	117	2014-10-25	59	50	67	47	61	29	79	1879	1963	0.01	0.15	3.3
118	118	2014-10-26	58	53	63	47	61	30	78	1879	1964	0.0	0.13	3.4
119	119	2014-10-27	56	48	63	47	60	28	82	1936	1963	0.0	0.14	1.88
120	120	2014-10-28	63	53	72	47	60	29	83	1976	1919	0.0	0.13	2.49
121	121	2014-10-29	62	51	72	46	60	31	78	1925	1971	0.0	0.14	3.67
122	122	2014-10-30	53	47	59	46	59	31	82	1925	1961	0.0	0.13	1.64
123	123	2014-10-31	50	45	55	46	59	29	81	1925	1946	0.05	0.14	2.41
124	124	2014-11-1	45	42	47	46	59	30	84	1885	1950	0.35	0.14	1.69
125	125	2014-11-2	45	41	48	45	58	30	83	1887	1950	0.0	0.14	1.7
126	126	2014-11-3	50	39	61	45	58	28	79	1875	2003	0.0	0.13	2.6
127	127	2014-11-4	61	53	68	45	58	25	78	1879	1975	0.0	0.13	1.44
128	128	2014-11-5	60	56	64	45	57	23	78	1879	1961	0.0	0.13	1.94
129	129	2014-11-6	53	48	57	44	57	27	74	1879	1948	0.37	0.14	1.47
130	130	2014-11-7	47	40	53	44	57	29	78	1930	1938	0.0	0.13	2.96
131	131	2014-11-8	42	36	48	44	57	29	76	1886	1975	0.0	0.12	7.4
132	132	2014-11-9	52	46	57	44	56	24	75	1976	1975	0.0	0.13	3.65
133	133	2014-11-10	53	44	61	43	56	27	73	1914	1985	0.0	0.13	1.7
134	134	2014-11-11	57	49	64	43	56	28	74	1933	1949	0.0	0.12	1.41
135	135	2014-11-12	56	47	65	43	55	26	76	1926	1879	0.0	0.12	2.39
136	136	2014-11-13	42	36	48	43	55	22	73	1873	1931	0.2	0.13	2.06
137	137	2014-11-14	39	35	42	42	55	20	72	1905	1993	0.06	0.13	2.23
138	138	2014-11-15	38	33	42	42	54	20	80	1967	1993	0.0	0.13	2.43
139	139	2014-11-16	40	35	45	42	54	17	72	1933	1928	0.03	0.13	2.39
140	140	2014-11-17	46	40	52	41	53	19	71	1933	1953	1.54	0.14	1.54
141	141	2014-11-18	35	24	45	41	53	18	73	1936	1928	0.0	0.14	1.24
142	142	2014-11-19	29	22	36	41	53	18	72	1936	1921	0.0	0.14	1.95
143	143	2014-11-20	38	31	45	40	52	20	77	1873	1985	0.0	0.13	3.37
144	144	2014-11-21	33	28	37	40	52	16	74	1879	1900	0.0	0.14	1.33
145	145	2014-11-22	36	28	44	40	52	13	72	1880	1931	0.0	0.14	2.03
146	146	2014-11-23	50	43	57	40	51	14	72	1880	1931	0.0	0.14	1.84
147	147	2014-11-24	61	53	69	39	51	14	73	1880	1979	0.7	0.14	1.95
148	148	2014-11-25	60	51	68	39	50	19	73	1938	1979	0.0	0.13	1.36
149	149	2014-11-26	43	34	51	39	50	16	67	1938	1946	1.24	0.14	1.91
150	150	2014-11-27	36	34	38	38	50	12	72	1932	1896	0.02	0.13	2.15
151	151	2014-11-28	33	29	37	38	49	15	70	1930	2011	0.0	0.14	2.14
152	152	2014-11-29	36	27	45	38	49	15	69	1872	1990	0.0	0.14	2.01
153	153	2014-11-30	50	45	55	37	49	7	70	1875	1991	0.0	0.15	1.11
154	154	2014-12-1	54	42	65	37	48	9	70	1875	2006	0.09	0.14	1.72
155	155	2014-12-2	39	35	43	37	48	12	66	1875	1970	0.08	0.14	2.16
156	156	2014-12-3	44	41	46	36	47	9	69	1976	1998	0.06	0.15	1.63
157	157	2014-12-4	41	37	45	36	47	10	74	1882	1998	0.0	0.14	1.84
158	158	2014-12-5	39	34	44	35	47	11	70	1926	2001	0.51	0.14	1.28
159	159	2014-12-6	45	39	50	35	46	11	71	1871	2001	1.22	0.13	1.6
160	160	2014-12-7	36	30	42	35	46	10	75	1926	1998	0.04	0.14	1.98
161	161	2014-12-8	31	24	37	34	45	10	65	1882	1927	0.0	0.14	1.54
162	162	2014-12-9	39	36	42	34	45	7	66	1876	1966	2.54	0.13	2.54
163	163	2014-12-10	36	32	40	34	45	3	70	1876	1946	0.08	0.14	1.62
164	164	2014-12-11	35	31	38	33	44	6	64	1880	1879	0.01	0.14	2.41
165	165	2014-12-12	35	32	38	33	44	5	68	1988	1931	0.0	0.13	1.6
166	166	2014-12-13	39	34	44	33	44	8	64	1960	1923	0.0	0.13	3.03
167	167	2014-12-14	42	38	46	32	43	12	67	1976	1881	0.0	0.13	2.22
168	168	2014-12-15	43	37	48	32	43	6	67	1874	2008	0.0	0.13	1.34
169	169	2014-12-16	44	38	49	32	43	7	63	1876	1971	0.2	0.12	2.25
170	170	2014-12-17	48	42	54	32	42	1	62	1919	2000	0.02	0.13	2.28
171	171	2014-12-18	40	37	42	31	42	-1	63	1919	1984	0.0	0.12	1.3
172	172	2014-12-19	35	31	38	31	42	-1	58	1884	1931	0.0	0.12	1.58
173	173	2014-12-20	32	30	33	31	42	-4	60	1942	2002	0.0	0.12	1.82
174	174	2014-12-21	34	31	36	30	41	-1	65	1942	2013	0.0	0.13	2.49
175	175	2014-12-22	40	35	44	30	41	2	71	1872	2013	0.04	0.12	2.18
176	176	2014-12-23	45	43	46	30	41	-1	66	1883	1990	0.16	0.13	1.61
177	177	2014-12-24	51	44	58	30	41	6	63	1983	1996	0.8	0.13	1.42
178	178	2014-12-25	53	44	62	29	40	-1	64	1980	1982	0.09	0.13	1.3
179	179	2014-12-26	45	40	50	29	40	3	63	1914	1982	0.0	0.12	1.66
180	180	2014-12-27	50	44	55	29	40	6	63	1872	1949	0.0	0.12	2.14
181	181	2014-12-28	49	43	54	29	40	8	65	1917	1982	0.1	0.12	1.35
182	182	2014-12-29	39	34	44	28	39	-6	70	1917	1984	0.0	0.11	2.52
183	183	2014-12-30	31	28	34	28	39	-13	65	1917	1984	0.0	0.12	1.69
184	184	2014-12-31	30	27	32	28	39	-7	63	1917	1965	0.0	0.11	2.31
185	185	2015-1-1	33	27	39	28	39	-4	62	1918	1966	0.0	0.12	2.05
186	186	2015-1-2	39	35	42	28	39	2	68	1918	1876	0.0	0.12	1.92
187	187	2015-1-3	38	33	42	28	39	-4	64	1879	2000	0.71	0.12	2.42
188	188	2015-1-4	49	41	56	27	39	-3	66	1918	1950	0.3	0.12	2.73
189	189	2015-1-5	35	21	49	27	38	-4	64	1904	1993	0.0	0.12	1.5
190	190	2015-1-6	21	19	22	27	38	-2	72	1896	2007	0.05	0.13	1.65
191	191	2015-1-7	16	9	23	27	38	4	64	2014	1907	0.0	0.12	2.67
192	192	2015-1-8	15	8	21	27	38	2	65	1968	1998	0.0	0.11	1.25
193	193	2015-1-9	26	19	33	27	38	-1	64	1968	1937	0.07	0.13	1.42
194	194	2015-1-10	20	16	23	27	38	-6	60	1875	1876	0.0	0.12	1.72
195	195	2015-1-11	28	18	37	27	38	3	63	1968	1975	0.0	0.12	1.46
196	196	2015-1-12	37	35	39	27	38	2	64	1981	1890	0.36	0.13	2.35
197	197	2015-1-13	27	17	36	27	38	-3	68	1914	1932	0.0	0.12	1.44
198	198	2015-1-14	24	16	32	27	38	-5	70	1914	1932	0.0	0.12	2.06
199	199	2015-1-15	30	25	35	27	38	0	67	1957	1932	0.0	0.13	1.27
200	200	2015-1-16	32	20	43	27	38	1	58	2004	1995	0.0	0.12	1.44

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

365 rows

Advanced export