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         100007    Biannual     June 30, 2023
## 2         100011    Biannual December 31, 2023
## 3         100000    Biannual     June 30, 2022
## 4         100006    Biannual December 31, 2022
##                           process_uuid enable_bfm_link
## 1 c9257b94-8221-4c96-afa6-103fcd95770d            TRUE
## 2 c73bff56-2d5a-4721-b895-d71d7db2cf7f            TRUE
## 3 7b81911a-c0cb-4be6-8e6c-63a32e8bf917            TRUE
## 4 b842d204-ba21-4cbd-9b22-11f62a5f490d            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 785375 June 30, 2023 Fixed Broadband               0         01        <NA>
## 2 785376 June 30, 2023 Fixed Broadband               0         04        <NA>
## 3 785377 June 30, 2023 Fixed Broadband               0         06        <NA>
## 4 785378 June 30, 2023 Fixed Broadband               0         12        <NA>
## 5 785379 June 30, 2023 Fixed Broadband               0         17        <NA>
## 6 785380 June 30, 2023 Fixed Broadband               0         18        <NA>
##                                    file_name file_type data_category
## 1 bdc_01_Other_fixed_broadband_J23_01nov2024       csv    Nationwide
## 2 bdc_04_Other_fixed_broadband_J23_01nov2024       csv    Nationwide
## 3 bdc_06_Other_fixed_broadband_J23_01nov2024       csv    Nationwide
## 4 bdc_12_Other_fixed_broadband_J23_01nov2024       csv    Nationwide
## 5 bdc_17_Other_fixed_broadband_J23_01nov2024       csv    Nationwide
## 6 bdc_18_Other_fixed_broadband_J23_01nov2024       csv    Nationwide