{"generated_at": "2026-11-11T06:47:50-06:00 (America/Chicago)", "source": {"name": "SAM.gov Contract Opportunities \u2014 public bulk CSV (Data Services, datagov extract)", "url": "https://sam.gov/api/prod/fileextractservices/v1/api/download/Contract%20Opportunities/datagov/ContractOpportunitiesFullCSV.csv?privacy=Public", "attribution": "Data: SAM.gov (U.S. General Services Administration). Original notices at sam.gov."}, "file": {"path": "/workspace/subscription-venture/data/raw/ContractOpportunitiesFullCSV.csv", "bytes": 220915521, "mb": 220.9, "sha256": "1c36b0497fe75d2c0303ea66e4a0e8c9870d5ce37779ddd74e45e17f540c9833", "content_length_header": 220915521, "byte_count_matches_header": true, "http_status": 200, "etag": "\"0257206118ebe9482b80da2b24f1e441-27\"", "server_last_modified": "Wed, 11 Nov 2026 04:30:18 GMT", "x_amz_meta_lastmodifieddate": "2026-11-10", "fetched_at_utc": "2026-11-11T12:47:45+00:00"}, "snapshot_age_hours_at_ingest": 8.3, "snapshot_file_generated_local": "2026-11-10T22:30-06:00 (America/Chicago)", "parse": {"columns": 47, "records_read": 72013, "records_ok": 72013, "parse_errors_wrong_field_count": 0, "duplicate_or_blank_notice_id": 0, "lines_decoded_with_cp1252_fallback": 11668, "unparsed_posted_dates": 0, "quarantine_file": "/workspace/subscription-venture/data/sam_quarantine.json"}, "posted_date_range": {"earliest": "2008-03-05", "latest": "2026-11-10", "note": "Rows with very old posted dates are still flagged Active in the extract; many have passed deadlines, which the app filters out."}, "active_field_values": {"Yes": 72013}, "counts_by_notice_type_all_rows": {"Combined Synopsis/Solicitation": 21744, "Solicitation": 19469, "Award Notice": 11995, "Presolicitation": 7029, "Sources Sought": 5265, "Special Notice": 5127, "Modification/Amendment/Cancel": 648, "Justification": 633, "Justification and Approval (J&A)": 81, "Sale of Surplus Property": 13, "Consolidate/(Substantially) Bundle": 9}, "place_of_performance_country_all_rows": {"(blank)": 50010, "USA": 20642, "JPN": 208, "DEU": 126, "ITA": 59, "GTM": 59, "GBR": 49, "GAB": 44, "KOR": 43, "TUR": 37, "PHL": 36, "ZAF": 36, "CAN": 29, "ESP": 28, "SGP": 28, "PER": 25, "CYP": 23, "BHR": 20, "MEX": 20, "DNK": 20, "FRA": 19, "BEL": 17, "ALB": 17, "SEN": 15, "SAU": 14}, "us_location_basis_all_rows": {"country_usa": 20627, "state_given_country_blank": 21, "us_zip_country_blank (inferred U.S. from a valid U.S. ZIP)": 2495, "non_us (excluded)": 1376, "no_location (no Pop fields at all; office not used)": 39707, "parsed_from_pop_address_text (state/ZIP/city recovered from PopStreetAddress)": 6434, "unknown_country (some Pop text but not resolvable to U.S.)": 1353}, "missing_worksite_location": {"rows_with_no_pop_fields": 39707, "rate_of_all_rows": 0.5514, "rows_without_mappable_point": 46259, "rate_without_mappable_point_of_stored_rows": 0.6549, "note": "'No Pop fields' rows have only a contracting-office address, which is NOT used as the worksite. Mappable points are Census ZIP/city centers, never jobsite pins; SAM provides no coordinates."}, "stored_rows_us_or_unknown": 70637, "location_precision_stored_rows": {"none": 44266, "zip": 19418, "city": 4801, "state": 1993, "multi": 121, "conflict": 38}, "counts_by_pop_state_stored_rows": {"(no worksite location)": 41060, "(state not given)": 3209, "VA": 1879, "CA": 1519, "TX": 1308, "MD": 1260, "FL": 1241, "DC": 1142, "OK": 1082, "NY": 1045, "WA": 1034, "PA": 798, "IL": 677, "NC": 662, "GA": 585, "OH": 573, "SC": 556, "AL": 515, "CO": 509, "MO": 435, "AZ": 419, "IN": 406, "LA": 406, "MI": 372, "NJ": 363, "NM": 350, "UT": 347, "KY": 340, "VA (state inferred from ZIP)": 304, "WI": 267, "MA": 232, "KS": 226, "OR": 209, "AK": 209, "HI": 207, "NY (state inferred from ZIP)": 199, "TN": 195, "ID": 193, "MS": 182, "CA (state inferred from ZIP)": 174, "TX (state inferred from ZIP)": 165, "GA (state inferred from ZIP)": 164, "SD": 158, "MN": 151, "OK (state inferred from ZIP)": 149, "WV": 147, "NV": 147, "PR": 146, "CT": 143, "ME": 133, "NJ (state inferred from ZIP)": 133, "AR": 129, "ND": 125, "FL (state inferred from ZIP)": 118, "RI": 116, "MT": 109, "SC (state inferred from ZIP)": 108, "AR (state inferred from ZIP)": 88, "MI (state inferred from ZIP)": 85, "MO (state inferred from ZIP)": 82, "NE": 78, "KY (state inferred from ZIP)": 76, "WY": 75, "MD (state inferred from ZIP)": 74, "DE": 73, "GU": 62, "IA": 62, "PA (state inferred from ZIP)": 51, "AL (state inferred from ZIP)": 50, "WA (state inferred from ZIP)": 48, "AZ (state inferred from ZIP)": 43, "WI (state inferred from ZIP)": 43, "VT": 38, "KS (state inferred from ZIP)": 38, "IL (state inferred from ZIP)": 37, "CO (state inferred from ZIP)": 36, "NH": 35, "NC (state inferred from ZIP)": 35, "NM (state inferred from ZIP)": 32, "NE (state inferred from ZIP)": 27, "IN (state inferred from ZIP)": 26, "HI (state inferred from ZIP)": 26, "OR (state inferred from ZIP)": 23, "OH (state inferred from ZIP)": 22, "MA (state inferred from ZIP)": 22, "LA (state inferred from ZIP)": 22, "UT (state inferred from ZIP)": 21, "IA (state inferred from ZIP)": 20, "PR (state inferred from ZIP)": 19, "DE (state inferred from ZIP)": 18, "MN (state inferred from ZIP)": 17, "RI (state inferred from ZIP)": 16, "MS (state inferred from ZIP)": 13, "ND (state inferred from ZIP)": 13, "DC (state inferred from ZIP)": 12, "WV (state inferred from ZIP)": 10, "NV (state inferred from ZIP)": 6, "ME (state inferred from ZIP)": 6, "AK (state inferred from ZIP)": 6, "SD (state inferred from ZIP)": 5, "AS": 4, "MP": 3, "WY (state inferred from ZIP)": 3, "VI": 2, "TN (state inferred from ZIP)": 2, "CT (state inferred from ZIP)": 1, "NH (state inferred from ZIP)": 1}, "counts_by_stage_stored_rows": {"open": 40608, "upcoming": 13060, "award": 11909, "other": 5029, "canceled": 31}, "deadline_already_passed_stored_rows": 48726, "deadline_passed_rate": 0.6898, "archive_date_passed_stored_rows": 9055, "trade_matches_stored_rows (before stage/expiry filters)": {"carpentry_framing:high": 1, "carpentry_framing:medium": 98, "concrete_masonry:high": 39, "concrete_masonry:low": 2, "concrete_masonry:medium": 324, "demolition:high": 72, "demolition:low": 8, "demolition:medium": 871, "drywall_interiors:high": 2, "drywall_interiors:medium": 89, "electrical:high": 751, "electrical:low": 29, "electrical:medium": 1693, "fire_protection:high": 277, "fire_protection:low": 89, "fire_protection:medium": 888, "flooring:high": 108, "flooring:medium": 149, "hvac:high": 920, "hvac:low": 316, "hvac:medium": 1062, "landscaping:high": 260, "landscaping:low": 1, "landscaping:medium": 453, "painting:high": 40, "painting:low": 12, "painting:medium": 89, "plumbing:high": 284, "plumbing:low": 190, "plumbing:medium": 778, "roofing:high": 207, "roofing:low": 7, "roofing:medium": 241}, "trade_rules_version": "trade-rules-v2-beta (2026-11-07)", "gazetteer_vintage": "2025", "change_vs_previous_snapshot": {"new_in_this_snapshot": 1421, "unchanged": 69166, "changed_since_last_snapshot": 50}, "build_seconds": 259.0}