Split (1)

train · 100M rows

listing_id stringlengths 9 36	city stringclasses 40 values	state stringclasses 25 values	zip_code stringlengths 5 5	property_type stringclasses 5 values	bedrooms int32 0 6	bathrooms float32 0 6	square_footage int64 0 5.72k	lot_size_sqft int64 0 220k	year_built int32 1.9k 2.02k	condition stringclasses 4 values	garage_spaces int32 0 3	hoa_fee_monthly int64 0 649	listing_price int64 27k 14.2M	price_per_sqft float64 0 1.85k	days_on_market int64 1 208	listing_status stringclasses 4 values
listing_100	Sacramento	CA	19330	single_family	6	4.5	2,619	3,005	1,999	fair	2	0	748,000	285.61	64	pending
listing_101	Atlanta	GA	46068	single_family	6	3.5	2,765	9,138	1,986	good	1	0	635,000	229.66	89	active
listing_102	New York	NY	41474	condo	5	4.5	3,197	338	1,955	excellent	2	149	2,985,000	933.69	11	sold
listing_103	Orlando	FL	83625	townhouse	5	3.5	3,253	5,555	1,942	excellent	2	200	1,033,000	317.55	75	pending
listing_104	Cleveland	OH	82048	multi_family	6	4	3,632	17,340	1,914	good	3	301	386,000	106.28	54	active
listing_105	Miami	FL	77338	single_family	2	1	1,430	15,294	1,933	excellent	0	0	598,000	418.18	89	active
listing_106	Memphis	TN	83314	single_family	2	1.5	2,021	7,925	1,961	good	3	0	302,000	149.43	36	active
listing_107	Raleigh	NC	56254	multi_family	3	1.5	1,484	2,932	1,938	good	2	186	337,000	227.09	6	sold
listing_108	Tampa	FL	97856	single_family	6	3.5	4,269	18,697	1,941	fair	0	0	1,011,000	236.82	57	sold
listing_109	Sacramento	CA	66882	land	0	0	0	14,154	1,949	fair	0	0	217,000	0	46	off_market
listing_110	Minneapolis	MN	89126	townhouse	2	1.5	2,195	7,786	1,934	good	0	216	514,000	234.17	27	sold
listing_111	Washington	DC	15694	single_family	3	2.5	2,290	17,247	1,901	fair	1	0	876,000	382.53	56	sold
listing_112	Dallas	TX	71535	single_family	4	3.5	2,695	7,168	1,975	good	3	0	689,000	255.66	37	sold
listing_113	Portland	OR	79700	single_family	1	1	1,220	6,641	2,002	needs_work	0	0	400,000	327.87	59	sold
listing_114	Chicago	IL	55201	condo	3	2	2,681	472	1,976	good	2	125	904,000	337.19	50	sold
listing_115	New York	NY	29400	townhouse	2	1	1,302	5,173	1,980	good	1	148	1,016,000	780.34	83	pending
listing_116	San Diego	CA	43997	multi_family	6	3	2,935	2,322	1,942	good	3	422	1,728,000	588.76	64	sold
listing_117	San Diego	CA	79965	single_family	6	5.5	3,068	7,876	1,931	good	0	0	1,698,000	553.46	3	off_market
listing_118	Indianapolis	IN	23184	townhouse	2	2	1,638	17,322	2,018	excellent	0	203	391,000	238.71	31	active
listing_119	San Jose	CA	32444	townhouse	3	2.5	1,883	16,031	1,913	excellent	1	215	1,616,000	858.2	112	off_market
listing_120	Oklahoma City	OK	69720	townhouse	1	1	863	4,265	1,920	fair	3	272	126,000	146	103	pending
listing_121	Dallas	TX	55661	single_family	1	1	931	12,716	1,947	excellent	2	278	269,000	288.94	74	pending
listing_122	Philadelphia	PA	62810	single_family	5	4	2,123	14,879	1,998	good	1	0	539,000	253.89	24	pending
listing_123	Chicago	IL	76904	single_family	6	4	3,161	3,679	1,969	good	3	0	761,000	240.75	87	active
listing_124	Atlanta	GA	39165	single_family	5	4	4,195	14,991	2,017	needs_work	0	0	1,008,000	240.29	105	active
listing_125	Sacramento	CA	49554	townhouse	6	5.5	4,938	16,727	1,986	excellent	0	64	2,427,000	491.49	112	active
listing_126	Indianapolis	IN	69508	single_family	2	1	1,549	14,648	2,007	good	0	0	315,000	203.36	39	active
listing_127	Austin	TX	98829	single_family	2	1.5	1,943	8,116	1,923	good	3	0	668,000	343.8	68	sold
listing_128	Atlanta	GA	17466	condo	6	5.5	3,428	76	1,911	good	1	266	1,088,000	317.39	23	sold
listing_129	Denver	CO	51599	multi_family	2	1.5	1,585	18,295	2,017	excellent	2	634	630,000	397.48	33	sold
listing_130	Seattle	WA	92383	land	0	0	0	213,283	1,963	good	0	0	4,666,000	0	72	active
listing_131	Chicago	IL	60083	single_family	3	2.5	2,310	15,898	1,933	fair	3	205	613,000	265.37	76	active
listing_132	Charlotte	NC	87325	multi_family	5	2.5	3,127	8,165	1,936	good	1	112	583,000	186.44	57	sold
listing_133	San Francisco	CA	94638	single_family	3	2.5	2,173	11,386	2,024	fair	2	0	1,814,000	834.79	66	pending
listing_134	Washington	DC	67025	condo	4	3	2,992	139	1,980	good	2	483	1,879,000	628.01	4	off_market
listing_135	Seattle	WA	49854	single_family	3	2	2,091	14,791	2,008	needs_work	3	0	788,000	376.85	123	sold
listing_136	Minneapolis	MN	72468	single_family	3	2	2,246	5,281	1,951	fair	1	0	385,000	171.42	72	off_market
listing_137	Austin	TX	61269	single_family	2	1.5	1,230	7,283	1,995	good	1	248	472,000	383.74	111	active
listing_138	Boston	MA	79401	single_family	3	2	1,933	15,134	2,012	needs_work	2	279	839,000	434.04	91	off_market
listing_139	Pittsburgh	PA	15021	multi_family	2	2	1,980	7,944	2,015	excellent	3	303	321,000	162.12	17	active
listing_140	Kansas City	MO	20524	townhouse	5	4.5	2,380	4,091	1,952	excellent	3	577	524,000	220.17	36	active
listing_141	Cincinnati	OH	98680	single_family	1	1	1,009	4,066	1,996	fair	1	263	178,000	176.41	84	pending
listing_142	Dallas	TX	56890	single_family	5	2.5	4,068	13,475	1,905	good	3	136	904,000	222.22	90	pending
listing_143	Seattle	WA	10140	single_family	4	3.5	2,626	13,493	2,006	good	0	0	1,459,000	555.6	91	active
listing_144	Miami	FL	85545	single_family	3	2	1,976	8,552	1,952	fair	0	33	640,000	323.89	18	sold
listing_145	San Francisco	CA	57022	single_family	6	3.5	3,984	13,635	2,004	good	2	0	3,821,000	959.09	14	pending
listing_146	Buffalo	NY	40960	single_family	3	2	2,524	10,160	2,015	needs_work	1	72	345,000	136.69	92	off_market
listing_147	Charlotte	NC	80752	townhouse	6	5	2,914	7,065	1,900	excellent	3	356	706,000	242.28	53	active
listing_148	Washington	DC	76667	condo	2	2	1,687	78	2,002	needs_work	3	429	775,000	459.4	110	active
listing_149	Milwaukee	WI	53988	condo	2	2	1,235	377	1,968	needs_work	3	421	183,000	148.18	46	sold
listing_150	Seattle	WA	59328	single_family	1	1	913	2,589	2,005	good	0	109	412,000	451.26	70	active
listing_151	New York	NY	67450	townhouse	1	1	1,064	19,863	1,916	fair	0	60	634,000	595.86	61	active
listing_152	Oklahoma City	OK	99670	single_family	4	2	2,613	4,925	2,006	good	1	0	373,000	142.75	79	pending
listing_153	Salt Lake City	UT	45784	single_family	1	1	1,029	3,955	1,950	excellent	0	263	345,000	335.28	10	off_market
listing_154	Chicago	IL	32986	condo	5	3.5	1,990	454	1,903	good	2	193	602,000	302.51	30	active
listing_155	San Francisco	CA	14327	single_family	3	2.5	2,132	18,678	1,992	excellent	3	0	2,605,000	1,221.86	18	active
listing_156	Tampa	FL	21377	single_family	5	2.5	2,273	11,932	1,906	good	2	0	505,000	222.17	10	active
listing_157	Detroit	MI	90087	townhouse	2	1.5	1,400	13,234	1,900	good	1	113	193,000	137.86	21	sold
listing_158	Las Vegas	NV	24042	single_family	3	2	1,845	17,359	1,909	excellent	2	0	593,000	321.41	22	sold
listing_159	Houston	TX	31572	single_family	1	1	909	15,298	2,000	good	0	0	189,000	207.92	34	sold
listing_160	San Francisco	CA	61736	townhouse	3	3	1,922	2,853	1,968	needs_work	1	74	1,369,000	712.28	56	active
listing_161	Phoenix	AZ	93189	condo	2	1.5	1,070	533	1,932	good	2	202	343,000	320.56	109	active
listing_162	Houston	TX	47706	single_family	3	2.5	2,268	12,265	2,017	good	1	240	619,000	272.93	24	sold
listing_163	Houston	TX	34467	single_family	5	3.5	2,145	18,824	2,013	good	0	164	506,000	235.9	27	sold
listing_164	Phoenix	AZ	74419	single_family	2	1.5	1,825	6,643	1,997	excellent	3	0	591,000	323.84	33	sold
listing_165	New York	NY	78530	condo	3	1.5	1,852	171	1,964	good	3	266	1,806,000	975.16	109	off_market
listing_166	Charlotte	NC	54951	single_family	1	1	748	17,490	1,980	good	2	0	205,000	274.06	78	pending
listing_167	Minneapolis	MN	91304	townhouse	4	2	1,634	6,693	1,944	excellent	2	65	459,000	280.91	37	sold
listing_168	New York	NY	97358	single_family	1	1	925	19,997	2,010	good	3	0	859,000	928.65	67	sold
listing_169	Austin	TX	82024	condo	4	3	2,592	96	1,950	good	1	533	1,223,000	471.84	29	sold
listing_170	Atlanta	GA	83369	condo	6	4	2,393	579	1,977	good	2	399	745,000	311.32	5	sold
listing_171	Dallas	TX	80254	single_family	3	2	1,770	10,332	1,974	good	0	0	457,000	258.19	31	active
listing_172	Salt Lake City	UT	77200	condo	2	1	1,111	271	1,965	excellent	3	359	405,000	364.54	110	active
listing_173	Atlanta	GA	16945	townhouse	3	2.5	2,106	10,607	1,967	fair	2	625	462,000	219.37	41	pending
listing_174	Orlando	FL	39278	condo	4	3	3,057	222	1,969	fair	0	352	610,000	199.54	12	off_market
listing_175	Memphis	TN	50153	single_family	6	3.5	3,483	4,197	2,008	good	1	0	557,000	159.92	109	active
listing_176	Pittsburgh	PA	69493	townhouse	5	3.5	1,758	7,675	1,957	fair	0	503	237,000	134.81	25	sold
listing_177	Houston	TX	73741	single_family	5	4.5	2,248	13,084	1,964	needs_work	0	0	352,000	156.58	180	active
listing_178	Tampa	FL	67830	single_family	1	1	882	4,755	1,967	good	1	0	226,000	256.24	43	sold
listing_179	Minneapolis	MN	76244	single_family	5	4.5	2,161	14,457	1,928	good	0	0	519,000	240.17	48	sold
listing_180	Cleveland	OH	54132	multi_family	6	3	3,671	4,145	1,980	good	0	403	467,000	127.21	18	sold
listing_181	Sacramento	CA	19085	single_family	2	1	1,049	6,456	1,902	good	0	0	362,000	345.09	30	sold
listing_182	Milwaukee	WI	42605	townhouse	2	2	1,558	12,651	1,942	fair	2	488	267,000	171.37	113	pending
listing_183	New York	NY	86921	land	0	0	0	168,163	1,996	excellent	0	0	6,296,000	0	59	active
listing_184	Memphis	TN	52105	condo	1	1	1,113	155	1,964	fair	0	93	155,000	139.26	11	active
listing_185	Austin	TX	57960	townhouse	5	2.5	1,969	16,407	1,952	needs_work	2	211	562,000	285.42	169	active
listing_186	New York	NY	50380	condo	4	3	3,503	364	1,903	good	3	125	2,179,000	622.04	54	pending
listing_187	Atlanta	GA	72730	single_family	6	5.5	4,135	18,905	1,924	excellent	3	0	1,276,000	308.59	44	active
listing_188	Miami	FL	83946	single_family	3	2.5	1,856	3,027	2,006	good	0	0	914,000	492.46	77	pending
listing_189	Pittsburgh	PA	72278	condo	4	4	2,369	77	1,963	good	1	447	471,000	198.82	66	active
listing_190	Indianapolis	IN	72714	townhouse	4	2.5	2,381	6,881	1,923	fair	3	582	347,000	145.74	15	active
listing_191	Los Angeles	CA	31437	multi_family	3	2	1,444	10,173	1,951	fair	3	113	742,000	513.85	76	active
listing_192	Chicago	IL	34463	single_family	6	5	3,875	7,615	1,931	good	0	0	966,000	249.29	10	sold
listing_193	Sacramento	CA	66308	single_family	3	2.5	1,408	8,308	1,943	good	1	0	577,000	409.8	32	sold
listing_194	Denver	CO	46596	single_family	5	2.5	2,347	12,442	1,985	fair	0	216	821,000	349.81	96	pending
listing_195	Austin	TX	91671	single_family	1	1	814	3,114	1,903	fair	2	0	239,000	293.61	52	active
listing_196	Charlotte	NC	43909	single_family	4	3.5	2,017	8,377	1,929	good	1	0	450,000	223.1	5	sold
listing_197	Los Angeles	CA	90990	single_family	5	3	2,195	4,095	1,971	good	0	0	1,498,000	682.46	23	sold
listing_198	Seattle	WA	21950	land	0	0	0	195,874	1,970	needs_work	0	0	2,964,000	0	67	sold
listing_199	Austin	TX	89486	single_family	3	2.5	1,581	10,463	1,970	fair	1	0	460,000	290.96	11	sold

Subsets and Splits

No community queries yet

The top public SQL queries from the community will appear here once available.