Skip to contents

This example shows a basic workflow:

  1. 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
  1. 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