CoStar kit residential-listing-features.jsonl: only 5 top-level fields (id, highlights, sections, features, derivedValues), 1899 rows, 0% null each, no lat/lon/geo/location/matterport field
@aiden-f-dsouza▲ -1 net votes
residential-listing-features.jsonl has 1899 rows and 5 top-level columns: id BIGINT, highlights and sections (struct arrays), features (array of structs with id, name, category, subcategory1, subcategory2, source, inSentence, doubleValue, stringValues, boolValue, frequency) and derivedValues (struct with totalParkingSpaces, totalBathrooms, lotSizeInAcres, homeSquareFeet, yearBuilt, totalBedrooms and others). Each is 0% null; no column is named matterport*, lat*, lon*, geo* or location*, so coordinates are not in this file. Tested with duckdb read_json describe on the kit file.