{"columns":[{"name":"op","type":"string"},{"name":"id","type":"int32"},{"name":"company_id","type":"int32"},{"name":"street_address","type":"string"},{"name":"street_address_2","type":"string"},{"name":"city","type":"string"},{"name":"state","type":"string"},{"name":"zip_code","type":"string"},{"name":"phone_number","type":"string"},{"name":"mobile_number","type":"string"},{"name":"lat","type":"string"},{"name":"lng","type":"string"},{"name":"primary","type":"int8"},{"name":"created_at","type":"string"},{"name":"updated_at","type":"string"},{"name":"yelp_link","type":"string"},{"name":"yelp_testimonials_fetched_at","type":"string"},{"name":"city_rating_updated_at","type":"string"},{"name":"google_rating_updated_at","type":"string"},{"name":"foursquare_id","type":"string"},{"name":"bookings_per_time_slot","type":"int32"},{"name":"time_zone","type":"string"},{"name":"deleted_at","type":"string"},{"name":"geocode_partial_match","type":"int8"},{"name":"geocode_match_types","type":"string"},{"name":"mobile_only","type":"int8"},{"name":"data","type":"string"},{"name":"description","type":"string"},{"name":"original_calapi_id","type":"int32"},{"name":"friendemic_id","type":"string"},{"name":"ada_accessible","type":"int8"},{"name":"canonical_yelp_id","type":"string"},{"name":"calapi_source_id","type":"int32"},{"name":"internal_notifications","type":"int8"},{"name":"my_quickbooks_merchant_id","type":"int32"},{"name":"nickname","type":"string"},{"name":"country","type":"string"},{"name":"external_id","type":"string"},{"name":"require_meal_break","type":"int8"},{"name":"meal_break_duration","type":"int32"},{"name":"meal_break_after_x_worked_time","type":"int32"},{"name":"meal_break_before_x_worked_time","type":"int32"},{"name":"not_bookable","type":"int8"},{"name":"website","type":"string"},{"name":"external_entity_id","type":"string"},{"name":"client_credits_before_tax","type":"int8"},{"name":"tax_id_number","type":"string"},{"name":"royalty_charge_account_id","type":"int32"}],"n_rows":4,"rows_kept":4,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"parquet-cpp-arrow version 17.0.0","schema":{"fields":[{"name":"op","type":"string","nullable":true,"metadata":null,"children":null},{"name":"id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"company_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"street_address","type":"string","nullable":true,"metadata":null,"children":null},{"name":"street_address_2","type":"string","nullable":true,"metadata":null,"children":null},{"name":"city","type":"string","nullable":true,"metadata":null,"children":null},{"name":"state","type":"string","nullable":true,"metadata":null,"children":null},{"name":"zip_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"phone_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"mobile_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"lat","type":"string","nullable":true,"metadata":null,"children":null},{"name":"lng","type":"string","nullable":true,"metadata":null,"children":null},{"name":"primary","type":"int8","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"string","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"string","nullable":true,"metadata":null,"children":null},{"name":"yelp_link","type":"string","nullable":true,"metadata":null,"children":null},{"name":"yelp_testimonials_fetched_at","type":"string","nullable":true,"metadata":null,"children":null},{"name":"city_rating_updated_at","type":"string","nullable":true,"metadata":null,"children":null},{"name":"google_rating_updated_at","type":"string","nullable":true,"metadata":null,"children":null},{"name":"foursquare_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bookings_per_time_slot","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"time_zone","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"string","nullable":true,"metadata":null,"children":null},{"name":"geocode_partial_match","type":"int8","nullable":true,"metadata":null,"children":null},{"name":"geocode_match_types","type":"string","nullable":true,"metadata":null,"children":null},{"name":"mobile_only","type":"int8","nullable":true,"metadata":null,"children":null},{"name":"data","type":"string","nullable":true,"metadata":null,"children":null},{"name":"description","type":"string","nullable":true,"metadata":null,"children":null},{"name":"original_calapi_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"friendemic_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ada_accessible","type":"int8","nullable":true,"metadata":null,"children":null},{"name":"canonical_yelp_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"calapi_source_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"internal_notifications","type":"int8","nullable":true,"metadata":null,"children":null},{"name":"my_quickbooks_merchant_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"nickname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"country","type":"string","nullable":true,"metadata":null,"children":null},{"name":"external_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"require_meal_break","type":"int8","nullable":true,"metadata":null,"children":null},{"name":"meal_break_duration","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"meal_break_after_x_worked_time","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"meal_break_before_x_worked_time","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"not_bookable","type":"int8","nullable":true,"metadata":null,"children":null},{"name":"website","type":"string","nullable":true,"metadata":null,"children":null},{"name":"external_entity_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"client_credits_before_tax","type":"int8","nullable":true,"metadata":null,"children":null},{"name":"tax_id_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"royalty_charge_account_id","type":"int32","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional binary field_id=-1 op (String);\n  optional int32 field_id=-1 id;\n  optional int32 field_id=-1 company_id;\n  optional binary field_id=-1 street_address (String);\n  optional binary field_id=-1 street_address_2 (String);\n  optional binary field_id=-1 city (String);\n  optional binary field_id=-1 state (String);\n  optional binary field_id=-1 zip_code (String);\n  optional binary field_id=-1 phone_number (String);\n  optional binary field_id=-1 mobile_number (String);\n  optional binary field_id=-1 lat (String);\n  optional binary field_id=-1 lng (String);\n  optional int32 field_id=-1 primary (Int(bitWidth=8, isSigned=true));\n  optional binary field_id=-1 created_at (String);\n  optional binary field_id=-1 updated_at (String);\n  optional binary field_id=-1 yelp_link (String);\n  optional binary field_id=-1 yelp_testimonials_fetched_at (String);\n  optional binary field_id=-1 city_rating_updated_at (String);\n  optional binary field_id=-1 google_rating_updated_at (String);\n  optional binary field_id=-1 foursquare_id (String);\n  optional int32 field_id=-1 bookings_per_time_slot;\n  optional binary field_id=-1 time_zone (String);\n  optional binary field_id=-1 deleted_at (String);\n  optional int32 field_id=-1 geocode_partial_match (Int(bitWidth=8, isSigned=true));\n  optional binary field_id=-1 geocode_match_types (String);\n  optional int32 field_id=-1 mobile_only (Int(bitWidth=8, isSigned=true));\n  optional binary field_id=-1 data (String);\n  optional binary field_id=-1 description (String);\n  optional int32 field_id=-1 original_calapi_id;\n  optional binary field_id=-1 friendemic_id (String);\n  optional int32 field_id=-1 ada_accessible (Int(bitWidth=8, isSigned=true));\n  optional binary field_id=-1 canonical_yelp_id (String);\n  optional int32 field_id=-1 calapi_source_id;\n  optional int32 field_id=-1 internal_notifications (Int(bitWidth=8, isSigned=true));\n  optional int32 field_id=-1 my_quickbooks_merchant_id;\n  optional binary field_id=-1 nickname (String);\n  optional binary field_id=-1 country (String);\n  optional binary field_id=-1 external_id (String);\n  optional int32 field_id=-1 require_meal_break (Int(bitWidth=8, isSigned=true));\n  optional int32 field_id=-1 meal_break_duration;\n  optional int32 field_id=-1 meal_break_after_x_worked_time;\n  optional int32 field_id=-1 meal_break_before_x_worked_time;\n  optional int32 field_id=-1 not_bookable (Int(bitWidth=8, isSigned=true));\n  optional binary field_id=-1 website (String);\n  optional binary field_id=-1 external_entity_id (String);\n  optional int32 field_id=-1 client_credits_before_tax (Int(bitWidth=8, isSigned=true));\n  optional binary field_id=-1 tax_id_number (String);\n  optional int32 field_id=-1 royalty_charge_account_id;\n}\n"},"kv_metadata":[]}
[null,157264,142027,"23 Template Street",null,"Nome","AK","95051",null,null,"64.50059089999999","-165.4086406",null,"2023-08-21 13:37:06","2023-08-21 13:37:06",null,"2012-10-10 17:13:23","2012-12-25 17:40:47","2012-12-25 17:40:48",null,null,"America/Los_Angeles",null,1,"locality, political",0,"---\nbusiness_hours: []\n",null,null,null,null,null,null,1,null,"Template","US",null,null,null,null,null,0,null,null,0,null,null]
[null,156881,141656,"4593 W 1st St","","Nome","AK","99762",null,null,"64.4987608","-165.4105974",null,"2023-06-21 22:42:13","2023-06-21 22:42:13",null,"2012-10-10 17:13:23","2012-12-25 17:40:47","2012-12-25 17:40:48",null,null,"America/Nome",null,null,"route",0,null,null,null,null,null,null,null,1,null,"Parent User Management","US",null,null,null,null,null,0,null,null,0,null,null]
[null,156908,141681,"nome",null,"Nome","AK","95051","(555) 555-5555",null,"64.50059089999999","-165.4086406",null,"2023-06-26 20:37:57","2023-06-26 20:37:57",null,"2012-10-10 17:13:23","2012-12-25 17:40:47","2012-12-25 17:40:48",null,null,"America/Los_Angeles","2023-06-26 21:06:17",null,"locality, political",0,"---\nbusiness_hours: []\n",null,null,null,null,null,null,1,null,null,"US",null,null,null,null,null,0,null,null,0,null,null]
["U",156885,141660,"2270 E Williams Field Rd","Ste. 114","Gilbert","AZ","85295","(480) 550-9581",null,"33.311467","-111.7418797",null,"2023-06-22 13:20:40","2024-10-29 05:42:38",null,"2012-10-10 17:13:23","2012-12-25 17:40:47","2012-12-25 17:40:48",null,null,"America/Phoenix",null,null,"subpremise",0,"---\nbusiness_hours: []\nfacebook_page: https://www.facebook.com/sparkledogcare/\ntwitter_username: https://twitter.com/sparkledogcare\nlinkedin_url: https://www.linkedin.com/company/sparkledogcare\ngoogle_page: https://goo.gl/maps/aQDiDiL7G2kUEPzf6\ninstagram_url: https://instagram.com/sparkledogcare\nyelp_page: https://www.yelp.com/biz/sparkle-gilbert\n","",null,null,null,null,null,1,null,"SanTan Village","US","US48001",null,null,null,null,0,"https://www.sparkledogcare.com/",null,0,null,null]