Check and download NBM data
Check_and_download_NBM_data.Rmd
This example shows a basic workflow:
- First, you can inspect what releases are available:
release <- get_nbm_release() # get the available releases
release
## filing_type_id filing_type filing_subtype
## 1 100018 Biannual December 31, 2024
## 2 100011 Biannual December 31, 2023
## 3 100015 Biannual June 30, 2024
## 4 100007 Biannual June 30, 2023
## process_uuid enable_bfm_link
## 1 edfc573d-55f1-4ae1-9a94-e28d9a49b7ba TRUE
## 2 9ffd78e2-69a1-4bc7-b085-b88fcf5dff61 TRUE
## 3 093b7ff5-d76c-4a12-a1d9-20756e889098 TRUE
## 4 1e2412e9-4f16-4349-8c0d-ab18eefbe5cb TRUE
## enable_challenge_download
## 1 TRUE
## 2 TRUE
## 3 TRUE
## 4 TRUE
- Second, you can check what files are available:
nbm <- get_nbm_available() # get what data is available
# if we are interested in "Fixed Broadband" / "Nationwide" / released "June 30, 2023"
nbm_filter <- nbm[which(nbm$release == "June 30, 2023" &
nbm$data_type == "Fixed Broadband" &
nbm$data_category == "Nationwide"), ]
rownames(nbm_filter) <- NULL
# or
nbm_dplyr_filter <- nbm |> dplyr::filter(release == "June 30, 2023" &
data_type == "Fixed Broadband" &
data_category == "Nationwide")
all.equal(nbm_filter, nbm_dplyr_filter)
## [1] TRUE
#> [1] TRUE
head(nbm_filter)
## id release data_type technology_code state_fips provider_id
## 1 931714 June 30, 2023 Fixed Broadband 0 01 <NA>
## 2 931715 June 30, 2023 Fixed Broadband 0 04 <NA>
## 3 931716 June 30, 2023 Fixed Broadband 0 06 <NA>
## 4 931717 June 30, 2023 Fixed Broadband 0 12 <NA>
## 5 931718 June 30, 2023 Fixed Broadband 0 17 <NA>
## 6 931719 June 30, 2023 Fixed Broadband 0 18 <NA>
## file_name file_type data_category
## 1 bdc_01_Other_fixed_broadband_J23_10feb2025 csv Nationwide
## 2 bdc_04_Other_fixed_broadband_J23_10feb2025 csv Nationwide
## 3 bdc_06_Other_fixed_broadband_J23_10feb2025 csv Nationwide
## 4 bdc_12_Other_fixed_broadband_J23_10feb2025 csv Nationwide
## 5 bdc_17_Other_fixed_broadband_J23_10feb2025 csv Nationwide
## 6 bdc_18_Other_fixed_broadband_J23_10feb2025 csv Nationwide