Skip to content

Commit 243203f

Browse files
marmouremarmoure
committed
[feature] building up the schema again from scratch acording the section 11,4,1 in the bitag report
1 parent 1771908 commit 243203f

File tree

4 files changed

+680
-0
lines changed

4 files changed

+680
-0
lines changed

‎src/main/resources/schemas/sample.csv‎

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
date_published,regulator_name,regulator_version_number,connection_type,fcc_registration_number,unique_plan_identifier,network_technology_type,provider_name,service_plan_name,bandwidth_download_units,bandwidth_download_marketed_low,bandwidth_download_marketed_high,bandwidth_download_typical_low,bandwidth_download_typical_high,bandwidth_upload_units,bandwidth_upload_marketed_low,bandwidth_upload_marketed_high,bandwidth_upload_typical_low,bandwidth_upload_typical_high,latency_idle_low,latency_idle_high,currency,price_type,price_details,price_recurring,fee_introductory,fee_introductory_description,contract_required,contract_details,contract_terms_uri,fee_one_time_amount,fee_one_time_details,fee_recurring,fee_recurring_description,fee_pass_through_recurring,fee_pass_through_recurring_description,fee_early_termination,fee_early_termination_description,government_taxes,policy_data_usage,fee_data_usage,fee_data_usage_description,uri_data_usage,restrictions_apply,restrictions_description,uri_policy_network_management,uri_policy_privacy,uri_customer_support,customer_support_phone,country_code,asn,uri_policy_additional_terms,language,digital_signature
2+
2025-01-15,FCC,1,fixed,0005937974,F0005937974TIER1,50,Xfinity Internet,Extreme 500,Mbps,2,2,2,2,Mbps,2,2,2,2,2,2,USD,Pre-Paid,Requires activation of one new device.,100,10.32,only for new customers,No,Contract is 1 year.,https://example.com/contract-terms/internet/,29,Professional installation fee of $100 required.,," Monthly device rental."," $12.99"," Emergency services cost recovery fee",0," $100 charged if service is terminated before the end of one year.",Included,Yes,,,https://example.com/data-usage/internet/,Yes,Site survey required,https://example.com/network-management/internet/,https://example.com/privacy/internet/,https://example.com/support.html,18005551212,USA,,,,
3+
2025-11-02,,1,mobile,0003768165,F0005937974ABCD12341234,500,T-Mobile,Turbo 5G Plus,Mbps,75,75,75,75,Mbps,75,75,75,75,75,75,USD,Post-Paid,Price covers first 1 GB of data transferred. Data transfer billed at $1 per GB thereafter.,100,10.32,only for new customers,No,Valid for first 3 months.,https://example.com/internet-contract/,29.99,Shipping fee of $20 for sending equipment.,9,Cloud storage fee.,$10,State regulatory assessment fee,100,$25,Varies,Yes,1,$1 per GB after the first 1 TB.,https://example.com/datausagepolicies,Yes,Qualified for a low-income offering,https://example.com/networkpolicies,https://example.com/privacy-policies/,https://example.com/support/internet/,18885551212,CAN,,,,
4+
2025-06-06,FCC,99,satellite,0005937974,F0005937974ABCDEFGHIJ12345,500,Google Fiber,Fiber 2G,Gbps,500,500,500,500,Gbps,500,500,500,500,500,500,USD,Volume-Based,For new customers only.,100,10.32,only for new customers,Yes,"Contract must be digitally signed within 7 days of
5+
installation.",https://example.com/legal/terms/contracts.html,399.00,"$10
6+
device provisioning fee.
7+
",9.99," Streaming video package; Sports package.",$4.99,"Local franchise fee for Main
8+
Street USA;Local franchise fee for Gotham City
9+
",9.99,"$10 for every month
10+
remaining in contract term.",Not Applicable,No,,"No fee but bitrates are reduced to 100 Mbps after 10 GB of
11+
usage.",https://example.com/data-usage.html,No,"Mobile service only available to existing
12+
customers of wireline service",https://example.com/network-management.html,https://example.com/privacypolicy.html,https://example.com/support,12675551212,JPN,,,,
13+
2025-06-06,FCC,,something,,,0,randomeValue,,kbps,1,1,1,1,kbps,1,1,1,1,1,1,USD,Other,Requires activation of one new device.,100,10.32,only for new customers,No,,,,,12.99,,,,0,,Included,No,143.32,$2 per GB during peak times and $1 per GB during off-peak times.,,Yes,,,,,,,,,,

‎src/main/resources/schemas/schema.csvs‎

Lines changed: 56 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,56 @@
1+
version 1.1
2+
@totalColumns 54
3+
date_published: xDate
4+
regulator_name: empty or upperCase
5+
regulator_version_number: empty or range(1, 99)
6+
connection_type: notEmpty
7+
fcc_registration_number: empty or range(0, 9999999999)
8+
unique_plan_identifier: empty or regex("^[FM][0-9]{1,10}[A-Z0-9]{1,15}$")
9+
network_technology_type: range(0, 999)
10+
provider_name: length(1,100)
11+
service_plan_name: empty or length(0,100)
12+
bandwidth_download_units: length(4)
13+
bandwidth_download_marketed_low: empty or range(1,999)
14+
bandwidth_download_marketed_high: empty or range(1,999)
15+
bandwidth_download_typical_low: range(1,999)
16+
bandwidth_download_typical_high: range(1,999)
17+
bandwidth_upload_units: length(4)
18+
bandwidth_upload_marketed_low: empty or range(1,999)
19+
bandwidth_upload_marketed_high: empty or range(1,999)
20+
bandwidth_upload_typical_low: range(1,999)
21+
bandwidth_upload_typical_high: range(1,999)
22+
latency_idle_low: range(0,1000)
23+
latency_idle_high: range(0,1000)
24+
currency: empty or regex("^[A-Z]{3}$")
25+
price_type: any("Pre-Paid", "Post-Paid", "Volume-Based", "Per-Line", "Per-Device", "Per-Location", "Per-Organization", "Per-Person", "Per-Time", "Other")
26+
price_details: empty or length(0, 500)
27+
price_recurring: notEmpty and range(0, 9999999999) // TODO: this needs to limit decimal places to 2
28+
fee_introductory: empty or range(0, 9999999999) // TODO: this needs to limit decimal places to 2
29+
fee_introductory_description: empty or length(0, 500)
30+
contract_required: any("Yes", "No")
31+
contract_details: empty or length(0, 500)
32+
contract_terms_uri: empty or uri
33+
fee_one_time_amount: empty or range(0, 9999999999) // TODO: this needs to limit decimal places to 2
34+
fee_one_time_details: empty or length(0, 500)
35+
fee_recurring: empty or range(0, 9999999999) // TODO: this needs to limit decimal places to 2
36+
fee_recurring_description: empty or length(0, 500)
37+
fee_pass_through_recurring: empty or length(0, 500) // TODO: the decription is a string but it's a number
38+
fee_pass_through_recurring_description: empty or length(0, 500)
39+
fee_early_termination: range(0, 9999999999) // TODO: the decription is a string but it's a number, also needs to be limited to 2 decimal places
40+
fee_early_termination_description: empty or length(0, 500)
41+
government_taxes: any("Included", "Varies", "Not Applicable")
42+
policy_data_usage: any("Yes", "No")
43+
fee_data_usage: empty or range(0, 9999999999) // TODO: the decription is a string but it's a number, also needs to be limited to 2 decimal places
44+
fee_data_usage_description: empty or length(0, 500)
45+
uri_data_usage: empty or uri
46+
restrictions_apply: any("Yes", "No")
47+
restrictions_description: empty or length(0, 500)
48+
uri_policy_network_management: empty or uri
49+
uri_policy_privacy: empty or uri
50+
uri_customer_support: empty or uri
51+
customer_support_phone: empty or regex("^[0-9]{7,15}$") // TODO: min length for phone number is 7
52+
country_code: empty or regex("^[A-Z]{3}$") @optional
53+
asn: empty or length(0,4294967295) @optional
54+
uri_policy_additional_terms: empty or uri @optional
55+
language: empty or length(3) @optional
56+
digital_signature: empty or length(0, 500) @optional

‎src/main/resources/schemas/schema.json‎

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
{
2+
"id": "schema",
3+
"name": "schema",
4+
"version": "1.1.0",
5+
"date": "2026-03-20",
6+
"description": "Broadband Labels schema"
7+
}

0 commit comments

Comments
 (0)