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