Skip to contents

The check_ip() function subsets rows of data, retaining rows that have IP addresses from outside the specified country. The function is written to work with data from Qualtrics surveys.

Usage

check_ip(
  x,
  id_col = "ResponseId",
  ip_col = "IPAddress",
  rename = TRUE,
  country = "US",
  include_na = FALSE,
  keep = FALSE,
  quiet = FALSE,
  print = TRUE
)

Arguments

x

Data frame or tibble (preferably imported from Qualtrics using {qualtRics}).

id_col

Column name for unique row ID (e.g., participant).

ip_col

Column name for IP addresses.

rename

Logical indicating whether to rename columns (using rename_columns())

country

Two-letter abbreviation of country to check (default is "US").

include_na

Logical indicating whether to include rows with NA in IP address column in the output list of potentially excluded data.

keep

Logical indicating whether to keep or remove exclusion column.

quiet

Logical indicating whether to print message to console.

print

Logical indicating whether to print returned tibble to console.

Value

An object of the same type as x that includes the rows with IP addresses outside of the specified country. For a function that marks these rows, use mark_ip(). For a function that excludes these rows, use exclude_ip().

Details

To record this information in your Qualtrics survey, you must ensure that Anonymize responses is disabled.

Default column names are set based on output from the qualtRics::fetch_survey(). The function uses iptools::country_ranges() to assign IP addresses to specific countries using ISO 3166-1 alpha-2 country codes.

The function outputs to console a message about the number of rows with IP addresses outside of the specified country. If there are NAs for IP addresses (likely due to including preview data---see check_preview()), it will print a message alerting to the number of rows with NAs.

Note

This function requires internet connectivity as it uses the iptools::country_ranges() function, which pulls daily updated data from https://www.iwik.org/ipcountry/. It only updates the data once per session, as it caches the results for future work during the session.

See also

Other ip functions: exclude_ip(), mark_ip()

Other check functions: check_duplicates(), check_duration(), check_location(), check_preview(), check_progress(), check_resolution()

Examples

# Check for IP addresses outside of the US
data(qualtrics_text)
check_ip(qualtrics_text)
#>  2 out of 100 rows had NA values for IP addresses (check for preview data with 'check_preview()').
#>  4 out of 100 rows had IP address outside of US.
#>             StartDate             EndDate     Status   IPAddress Progress
#> 1 2020-12-11 16:59:08 2020-12-11 17:02:05 IP Address 84.56.189.0      100
#> 2 2020-12-11 17:09:18 2020-12-11 17:16:57 IP Address 31.252.29.0      100
#> 3 2020-12-17 15:47:37 2020-12-17 15:51:33 IP Address 89.167.14.0      100
#> 4 2020-12-17 15:49:28 2020-12-17 15:55:06 IP Address  2.246.67.0       44
#>   Duration (in seconds) Finished        RecordedDate        ResponseId
#> 1                    54     TRUE 2020-12-11 17:02:05 R_2RQ5kfCKKHudpj3
#> 2                   229     TRUE 2020-12-11 17:16:57 R_XUU5qhep0Xe1GyW
#> 3                   297     TRUE 2020-12-17 15:51:33 R_bEHQBqkV97IcXfD
#> 4                   355    FALSE 2020-12-17 15:55:06 R_UfSQq1VXYkVcxdJ
#>   LocationLatitude LocationLongitude UserLanguage Browser      Version
#> 1         43.23353         -77.55959           EN  Chrome 87.0.4280.88
#> 2         33.87347        -117.92215           EN  Chrome 87.0.4280.88
#> 3         35.39816         -78.81702           EN  Chrome 87.0.4280.88
#> 4         37.79058        -121.96737           EN  Chrome 87.0.4280.67
#>   Operating System Resolution
#> 1  Windows NT 10.0   1600x900
#> 2  Windows NT 10.0   1366x768
#> 3        Macintosh   1280x800
#> 4        Macintosh   1280x800

# Remove preview data first
qualtrics_text %>%
  exclude_preview() %>%
  check_ip()
#>  2 out of 100 preview rows were excluded, leaving 98 rows.
#>  4 out of 98 rows had IP address outside of US.
#>             StartDate             EndDate     Status   IPAddress Progress
#> 1 2020-12-11 16:59:08 2020-12-11 17:02:05 IP Address 84.56.189.0      100
#> 2 2020-12-11 17:09:18 2020-12-11 17:16:57 IP Address 31.252.29.0      100
#> 3 2020-12-17 15:47:37 2020-12-17 15:51:33 IP Address 89.167.14.0      100
#> 4 2020-12-17 15:49:28 2020-12-17 15:55:06 IP Address  2.246.67.0       44
#>   Duration (in seconds) Finished        RecordedDate        ResponseId
#> 1                    54     TRUE 2020-12-11 17:02:05 R_2RQ5kfCKKHudpj3
#> 2                   229     TRUE 2020-12-11 17:16:57 R_XUU5qhep0Xe1GyW
#> 3                   297     TRUE 2020-12-17 15:51:33 R_bEHQBqkV97IcXfD
#> 4                   355    FALSE 2020-12-17 15:55:06 R_UfSQq1VXYkVcxdJ
#>   LocationLatitude LocationLongitude UserLanguage Browser      Version
#> 1         43.23353         -77.55959           EN  Chrome 87.0.4280.88
#> 2         33.87347        -117.92215           EN  Chrome 87.0.4280.88
#> 3         35.39816         -78.81702           EN  Chrome 87.0.4280.88
#> 4         37.79058        -121.96737           EN  Chrome 87.0.4280.67
#>   Operating System Resolution
#> 1  Windows NT 10.0   1600x900
#> 2  Windows NT 10.0   1366x768
#> 3        Macintosh   1280x800
#> 4        Macintosh   1280x800

# Check for IP addresses outside of Germany
qualtrics_text %>%
  exclude_preview() %>%
  check_ip(country = "DE")
#>  2 out of 100 preview rows were excluded, leaving 98 rows.
#>  98 out of 98 rows had IP address outside of DE.
#>              StartDate             EndDate     Status     IPAddress Progress
#> 1  2020-12-11 12:17:22 2020-12-11 12:21:41 IP Address    73.23.43.0      100
#> 2  2020-12-11 12:17:41 2020-12-11 12:22:07 IP Address  16.140.105.0      100
#> 3  2020-12-11 12:19:45 2020-12-11 12:23:16 IP Address  107.57.244.0      100
#> 4  2020-12-11 12:37:51 2020-12-11 12:43:09 IP Address  15.232.167.0      100
#> 5  2020-12-11 12:41:23 2020-12-11 12:44:37 IP Address   24.195.91.0      100
#> 6  2020-12-11 12:37:04 2020-12-11 12:45:50 IP Address   98.75.201.0      100
#> 7  2020-12-11 12:55:35 2020-12-11 12:59:24 IP Address  51.113.171.0      100
#> 8  2020-12-11 13:22:34 2020-12-11 13:35:19 IP Address  17.163.199.0      100
#> 9  2020-12-11 16:59:08 2020-12-11 17:02:05 IP Address   84.56.189.0      100
#> 10 2020-12-11 17:02:00 2020-12-11 17:03:30 IP Address   70.203.63.0      100
#> 11 2020-12-11 17:01:32 2020-12-11 17:09:41 IP Address   33.185.89.0      100
#> 12 2020-12-11 17:05:21 2020-12-11 17:16:27 IP Address  40.222.151.0      100
#> 13 2020-12-11 17:09:18 2020-12-11 17:16:57 IP Address   31.252.29.0      100
#> 14 2020-12-11 17:29:18 2020-12-11 17:34:04 IP Address   64.71.222.0      100
#> 15 2020-12-11 17:34:23 2020-12-11 17:38:04 IP Address   13.139.19.0      100
#> 16 2020-12-11 17:36:12 2020-12-11 17:46:47 IP Address   45.16.214.0      100
#> 17 2020-12-11 17:46:05 2020-12-11 17:52:10 IP Address   76.193.55.0      100
#> 18 2020-12-11 18:01:26 2020-12-11 18:07:19 IP Address  33.129.208.0      100
#> 19 2020-12-17 15:40:59 2020-12-17 15:42:56 IP Address  32.235.180.0      100
#> 20 2020-12-17 15:40:42 2020-12-17 15:43:13 IP Address  23.235.165.0      100
#> 21 2020-12-17 15:40:53 2020-12-17 15:43:25 IP Address    22.51.31.0       99
#> 22 2020-12-17 15:40:52 2020-12-17 15:43:39 IP Address  32.164.134.0      100
#> 23 2020-12-17 15:41:17 2020-12-17 15:43:53 IP Address    34.29.29.0      100
#> 24 2020-12-17 15:41:41 2020-12-17 15:44:08 IP Address  33.171.228.0      100
#> 25 2020-12-17 15:41:05 2020-12-17 15:44:26 IP Address    12.76.83.0      100
#> 26 2020-12-17 15:42:13 2020-12-17 15:44:39 IP Address 107.101.170.0      100
#> 27 2020-12-17 15:42:26 2020-12-17 15:45:01 IP Address  20.217.173.0      100
#> 28 2020-12-17 15:41:01 2020-12-17 15:45:07 IP Address   28.160.55.0      100
#> 29 2020-12-17 15:41:36 2020-12-17 15:45:08 IP Address  69.163.151.0      100
#> 30 2020-12-17 15:41:14 2020-12-17 15:45:19 IP Address    48.46.53.0      100
#> 31 2020-12-17 15:40:46 2020-12-17 15:45:20 IP Address   26.195.73.0      100
#> 32 2020-12-17 15:41:17 2020-12-17 15:45:42 IP Address   24.195.91.0      100
#> 33 2020-12-17 15:42:24 2020-12-17 15:45:47 IP Address   35.98.203.0      100
#> 34 2020-12-17 15:40:50 2020-12-17 15:46:03 IP Address    71.49.49.0      100
#> 35 2020-12-17 15:40:31 2020-12-17 15:46:16 IP Address   44.19.138.0      100
#> 36 2020-12-17 15:40:57 2020-12-17 15:46:19 IP Address  99.120.178.0      100
#> 37 2020-12-17 15:40:56 2020-12-17 15:46:23 IP Address  71.146.112.0        1
#> 38 2020-12-17 15:42:47 2020-12-17 15:46:26 IP Address   55.73.114.0      100
#> 39 2020-12-17 15:41:22 2020-12-17 15:46:29 IP Address   67.49.133.0      100
#> 40 2020-12-17 15:41:52 2020-12-17 15:46:37 IP Address    15.223.0.0       13
#> 41 2020-12-17 15:41:41 2020-12-17 15:46:42 IP Address  104.210.32.0      100
#> 42 2020-12-17 15:41:27 2020-12-17 15:46:45 IP Address   19.127.87.0       48
#> 43 2020-12-17 15:44:48 2020-12-17 15:46:55 IP Address    72.240.1.0      100
#> 44 2020-12-17 15:41:00 2020-12-17 15:47:08 IP Address 104.243.207.0      100
#> 45 2020-12-17 15:41:25 2020-12-17 15:47:19 IP Address  21.225.119.0      100
#> 46 2020-12-17 15:45:08 2020-12-17 15:47:24 IP Address  16.123.176.0      100
#> 47 2020-12-17 15:41:54 2020-12-17 15:47:24 IP Address   97.10.196.0      100
#> 48 2020-12-17 15:41:00 2020-12-17 15:47:29 IP Address  44.236.187.0      100
#> 49 2020-12-17 15:41:49 2020-12-17 15:47:48 IP Address  38.210.187.0      100
#> 50 2020-12-17 15:44:30 2020-12-17 15:47:57 IP Address    48.17.71.0      100
#> 51 2020-12-17 15:42:18 2020-12-17 15:48:00 IP Address   55.73.114.0      100
#> 52 2020-12-17 15:42:41 2020-12-17 15:48:02 IP Address   6.146.172.0      100
#> 53 2020-12-17 15:43:51 2020-12-17 15:48:19 IP Address   16.136.53.0      100
#> 54 2020-12-17 15:43:54 2020-12-17 15:48:20 IP Address    33.30.59.0      100
#> 55 2020-12-17 15:43:06 2020-12-17 15:48:21 IP Address    66.124.7.0      100
#> 56 2020-12-17 15:42:22 2020-12-17 15:48:38 IP Address   56.195.10.0      100
#> 57 2020-12-17 15:44:32 2020-12-17 15:48:45 IP Address    6.20.135.0      100
#> 58 2020-12-17 15:40:57 2020-12-17 15:48:56 IP Address    6.79.107.0      100
#> 59 2020-12-17 15:46:46 2020-12-17 15:49:02 IP Address  21.134.217.0      100
#> 60 2020-12-17 15:45:41 2020-12-17 15:49:07 IP Address    20.244.6.0      100
#> 61 2020-12-17 15:40:52 2020-12-17 15:49:08 IP Address    99.29.49.0      100
#> 62 2020-12-17 15:44:30 2020-12-17 15:49:22 IP Address  104.41.163.0      100
#> 63 2020-12-17 15:46:56 2020-12-17 15:49:23 IP Address  28.221.112.0      100
#> 64 2020-12-17 15:46:41 2020-12-17 15:49:25 IP Address    47.80.53.0      100
#> 65 2020-12-17 15:41:27 2020-12-17 15:49:47 IP Address  65.159.184.0      100
#> 66 2020-12-17 15:47:34 2020-12-17 15:49:52 IP Address    56.12.83.0      100
#> 67 2020-12-17 15:42:18 2020-12-17 15:50:03 IP Address   16.206.29.0      100
#> 68 2020-12-17 15:42:45 2020-12-17 15:50:13 IP Address    26.236.1.0      100
#> 69 2020-12-17 15:44:11 2020-12-17 15:50:25 IP Address  32.188.104.0      100
#> 70 2020-12-17 15:48:15 2020-12-17 15:50:28 IP Address   38.67.178.0      100
#> 71 2020-12-17 15:41:04 2020-12-17 15:50:31 IP Address    6.10.127.0      100
#> 72 2020-12-17 15:48:12 2020-12-17 15:50:50 IP Address   19.45.134.0      100
#> 73 2020-12-17 15:47:37 2020-12-17 15:51:33 IP Address   89.167.14.0      100
#> 74 2020-12-17 15:44:56 2020-12-17 15:51:34 IP Address   12.40.231.0      100
#> 75 2020-12-17 15:46:51 2020-12-17 15:51:38 IP Address    22.51.31.0      100
#> 76 2020-12-17 15:45:51 2020-12-17 15:51:48 IP Address   3.145.255.0      100
#> 77 2020-12-17 15:49:42 2020-12-17 15:51:50 IP Address  40.146.247.0        5
#> 78 2020-12-17 15:46:16 2020-12-17 15:51:50 IP Address   52.94.218.0      100
#> 79 2020-12-17 15:48:36 2020-12-17 15:52:01 IP Address  12.247.210.0      100
#> 80 2020-12-17 15:46:39 2020-12-17 15:52:20 IP Address  76.149.164.0      100
#> 81 2020-12-17 15:45:45 2020-12-17 15:52:23 IP Address   55.85.168.0      100
#> 82 2020-12-17 15:45:14 2020-12-17 15:52:24 IP Address 108.246.109.0      100
#> 83 2020-12-17 15:48:56 2020-12-17 15:52:24 IP Address    35.188.6.0      100
#> 84 2020-12-17 15:41:37 2020-12-17 15:52:39 IP Address    74.20.82.0      100
#> 85 2020-12-17 15:49:09 2020-12-17 15:52:41 IP Address  104.55.125.0      100
#> 86 2020-12-17 15:46:50 2020-12-17 15:53:41 IP Address    52.24.57.0      100
#> 87 2020-12-17 15:48:53 2020-12-17 15:53:48 IP Address    22.51.31.0      100
#> 88 2020-12-17 15:49:06 2020-12-17 15:53:54 IP Address    3.240.10.0      100
#> 89 2020-12-17 15:44:31 2020-12-17 15:54:06 IP Address   38.64.190.0      100
#> 90 2020-12-17 15:48:48 2020-12-17 15:54:12 IP Address  54.232.129.0      100
#> 91 2020-12-17 15:51:16 2020-12-17 15:54:28 IP Address   66.215.26.0      100
#> 92 2020-12-17 15:48:37 2020-12-17 15:55:03 IP Address  98.211.119.0      100
#> 93 2020-12-17 15:50:06 2020-12-17 15:55:03 IP Address   70.38.187.0      100
#> 94 2020-12-17 15:49:28 2020-12-17 15:55:06 IP Address    2.246.67.0       44
#> 95 2020-12-17 15:50:21 2020-12-17 15:55:14 IP Address    38.82.71.0      100
#> 96 2020-12-17 15:50:01 2020-12-17 15:55:16 IP Address   66.215.75.0      100
#> 97 2020-12-17 15:47:42 2020-12-17 15:55:23 IP Address    100.26.8.0      100
#> 98 2020-12-17 15:45:16 2020-12-17 15:55:43 IP Address  67.133.227.0      100
#>    Duration (in seconds) Finished        RecordedDate        ResponseId
#> 1                    651     TRUE 2020-12-11 12:21:42 R_fbYBeNscosfzN9L
#> 2                    409     TRUE 2020-12-11 12:22:07 R_yyG1HGXOMNPfWDn
#> 3                    140     TRUE 2020-12-11 12:23:16 R_9dnzH1VI9mf8gle
#> 4                    213     TRUE 2020-12-11 12:43:09 R_1BoPF5igdMw536H
#> 5                    177     TRUE 2020-12-11 12:44:37 R_LAt58JGEyKNWZlB
#> 6                    662     TRUE 2020-12-11 12:45:51 R_6OZ4weICjHVtEkg
#> 7                    296     TRUE 2020-12-11 12:59:24 R_Y27gVhACEH3aUUE
#> 8                    277     TRUE 2020-12-11 13:35:19 R_ed0N9zgbymHSLLd
#> 9                     54     TRUE 2020-12-11 17:02:05 R_2RQ5kfCKKHudpj3
#> 10                   432     TRUE 2020-12-11 17:03:30 R_EGB3bwfPkaisVrs
#> 11                   103     TRUE 2020-12-11 17:09:41 R_pSKmDMG6TiZ0aGN
#> 12                   496     TRUE 2020-12-11 17:16:28 R_EDEYKveWY04MZi3
#> 13                   229     TRUE 2020-12-11 17:16:57 R_XUU5qhep0Xe1GyW
#> 14                   313     TRUE 2020-12-11 17:34:05 R_rCUKbrfaQBx0xf5
#> 15                   321     TRUE 2020-12-11 17:38:04 R_wCVncc0srj4P4A9
#> 16                   299     TRUE 2020-12-11 17:46:48 R_fWk2dUmxcSiN3EJ
#> 17                   320     TRUE 2020-12-11 17:52:10 R_yR2DWsoC62ftmmd
#> 18                   356     TRUE 2020-12-11 18:07:19 R_9FGBBxoszIYuM6z
#> 19                   280     TRUE 2020-12-17 15:42:56 R_R1dUIcQVU8CgOQs
#> 20                   434     TRUE 2020-12-17 15:43:13 R_tX5NknhjAYsnwLD
#> 21                   879    FALSE 2020-12-17 15:43:25 R_AkQyJypPyjgribz
#> 22                   375     TRUE 2020-12-17 15:43:39 R_H5MqcQoWznreNBt
#> 23                   163     TRUE 2020-12-17 15:43:54 R_y0u8c7Zoa5hu7JR
#> 24                   364     TRUE 2020-12-17 15:44:08 R_zSfDR6JuUPHVgfG
#> 25                   470     TRUE 2020-12-17 15:44:26 R_aPsQjtqUx8QyZMw
#> 26                   259     TRUE 2020-12-17 15:44:39 R_f6zeQUfBcLcuW0d
#> 27                   489     TRUE 2020-12-17 15:45:01 R_4ApQtflpravDDnu
#> 28                   283     TRUE 2020-12-17 15:45:07 R_8WYXfpBtVXCyuqK
#> 29                   301     TRUE 2020-12-17 15:45:08 R_P2EXpXCEoPMSxFB
#> 30                   559     TRUE 2020-12-17 15:45:19 R_vscdIaEwQJtBmR9
#> 31                   341     TRUE 2020-12-17 15:45:21 R_RCLqTKWdIen8A1Z
#> 32                   521     TRUE 2020-12-17 15:45:42 R_GNVaLC9Sb2ZDzQP
#> 33                   181     TRUE 2020-12-17 15:45:48 R_D6ZNSIORUWkzxos
#> 34                   217     TRUE 2020-12-17 15:46:03 R_otvyHTl6FXMLzgd
#> 35                   320     TRUE 2020-12-17 15:46:16 R_iUeOCrJmNsXtsXC
#> 36                   333     TRUE 2020-12-17 15:46:20 R_HfnAAjNF7JovJbG
#> 37                   627    FALSE 2020-12-17 15:46:23 R_1cvaTAoXO7XW1vi
#> 38                   236     TRUE 2020-12-17 15:46:26 R_7UzegytocfkyrWC
#> 39                   212     TRUE 2020-12-17 15:46:29 R_LqmsoBPL27xOIi3
#> 40                    40    FALSE 2020-12-17 15:46:37 R_Dx6w74UfhnGhAmj
#> 41                   264     TRUE 2020-12-17 15:46:42 R_6RYnN4LYlDniV2D
#> 42                    74    FALSE 2020-12-17 15:46:46 R_ewyyOOPADLGo9xZ
#> 43                   158     TRUE 2020-12-17 15:46:56 R_i7HCAU0w51Aa4MD
#> 44                   511     TRUE 2020-12-17 15:47:08 R_LH01951CWD0EpLv
#> 45                   181     TRUE 2020-12-17 15:47:19 R_0nj60jONOwpqZLC
#> 46                   286     TRUE 2020-12-17 15:47:24 R_o08jpNIfDT6cOdA
#> 47                   380     TRUE 2020-12-17 15:47:24 R_9bLdiaLyyfUlM7q
#> 48                   459     TRUE 2020-12-17 15:47:29 R_Mn4JCJqe0NwOKpQ
#> 49                   368     TRUE 2020-12-17 15:47:48 R_N2k3PNtEAjRI2El
#> 50                   339     TRUE 2020-12-17 15:47:58 R_hEJfTQuUySzm9Ef
#> 51                   526     TRUE 2020-12-17 15:48:00 R_NiK6d3RgjuJh1OI
#> 52                   394     TRUE 2020-12-17 15:48:02 R_uCdD9sfSqOQ418r
#> 53                   191     TRUE 2020-12-17 15:48:20 R_VokcYzvEcINQMWt
#> 54                   543     TRUE 2020-12-17 15:48:20 R_GCi4SP33Y2O3Zsy
#> 55                   210     TRUE 2020-12-17 15:48:22 R_uGam8XPGH3sJ3jH
#> 56                   225     TRUE 2020-12-17 15:48:38 R_eFwD4iFzNUTkfpW
#> 57                   632     TRUE 2020-12-17 15:48:45 R_YizuQ0gOXYXzgYg
#> 58                   397     TRUE 2020-12-17 15:48:56 R_8ezIj0X0p2lJuCQ
#> 59                    72     TRUE 2020-12-17 15:49:02 R_PKKUJ04DtpTEire
#> 60                   314     TRUE 2020-12-17 15:49:08 R_7lRNLskxLI4PI5f
#> 61                   234     TRUE 2020-12-17 15:49:09 R_M8PpmDiJ7vXS9vO
#> 62                   166     TRUE 2020-12-17 15:49:22 R_m4feVX6kV1hDKyG
#> 63                   641     TRUE 2020-12-17 15:49:24 R_ZBg4KsT1piDqN5Y
#> 64                   255     TRUE 2020-12-17 15:49:25 R_Tvk5uhVcSrNuCHa
#> 65                   205     TRUE 2020-12-17 15:49:48 R_3CW5AYZbsBMxA3n
#> 66                   136     TRUE 2020-12-17 15:49:52 R_eW74UodPpyCM0NY
#> 67                   566     TRUE 2020-12-17 15:50:04 R_DUMc8sVzlLpu3xE
#> 68                   159     TRUE 2020-12-17 15:50:13 R_omYa7FkDOGFV6zK
#> 69                   201     TRUE 2020-12-17 15:50:26 R_UIfPuGrPFYRUF3b
#> 70                   429     TRUE 2020-12-17 15:50:28 R_gGVBhajYEJQ62KN
#> 71                   161     TRUE 2020-12-17 15:50:31 R_seijWfHRUbFPOm0
#> 72                   385     TRUE 2020-12-17 15:50:50 R_qpTsaJuwHs6Cc8b
#> 73                   297     TRUE 2020-12-17 15:51:33 R_bEHQBqkV97IcXfD
#> 74                   548     TRUE 2020-12-17 15:51:34 R_p8QkyTuxS9RYVWU
#> 75                   872     TRUE 2020-12-17 15:51:39 R_Gbz5en48KgnCXT7
#> 76                   348     TRUE 2020-12-17 15:51:49 R_SG9duhsoysmQrZf
#> 77                   307    FALSE 2020-12-17 15:51:50 R_HFKclPO5wWGNsFs
#> 78                   185     TRUE 2020-12-17 15:51:50 R_5T43AwvQXtF96Hq
#> 79                   199     TRUE 2020-12-17 15:52:01 R_QdGXTRC6C6dg0xq
#> 80                   373     TRUE 2020-12-17 15:52:20 R_sJcbtpActYeyDwl
#> 81                   194     TRUE 2020-12-17 15:52:23 R_DoG50QcwJRIPs99
#> 82                   267     TRUE 2020-12-17 15:52:24 R_CDpEjKb1UgP1KiY
#> 83                   175     TRUE 2020-12-17 15:52:25 R_CegS8uh09zOvT6y
#> 84                   483     TRUE 2020-12-17 15:52:39 R_cUxV8jJ9yOsYsKa
#> 85                   404     TRUE 2020-12-17 15:52:41 R_GWjtLqPIuuKgRZC
#> 86                   339     TRUE 2020-12-17 15:53:41 R_et8rmjaxZ4F0MqM
#> 87                   246     TRUE 2020-12-17 15:53:48 R_AJfrQqClQNvWIch
#> 88                   293     TRUE 2020-12-17 15:53:55 R_KiVCN59xWUnZyLw
#> 89                   312     TRUE 2020-12-17 15:54:07 R_uu1aNgZJKe3i8oI
#> 90                   149     TRUE 2020-12-17 15:54:12 R_Kc9BGXO793zEqHM
#> 91                   285     TRUE 2020-12-17 15:54:28 R_SwoiAKU1uTqAjZH
#> 92                   518     TRUE 2020-12-17 15:55:03 R_oTn6oGRmfWcIM1m
#> 93                   267     TRUE 2020-12-17 15:55:04 R_Qbx9mK1iPLJzc4r
#> 94                   355    FALSE 2020-12-17 15:55:06 R_UfSQq1VXYkVcxdJ
#> 95                   703     TRUE 2020-12-17 15:55:15 R_ZYQSiMjNqYEVHN4
#> 96                   525     TRUE 2020-12-17 15:55:16 R_I8rAyEeHD7f3bHi
#> 97                   147     TRUE 2020-12-17 15:55:23 R_OvEVgjfLzfiZ8lB
#> 98                   154     TRUE 2020-12-17 15:55:43 R_iEgZWF5bmgsCZvG
#>    LocationLatitude LocationLongitude UserLanguage       Browser       Version
#> 1          34.03852        -118.25739           EN        Chrome  87.0.4280.88
#> 2          44.96581         -93.07187           EN        Chrome  87.0.4280.88
#> 3          27.98064         -82.78531           EN        Chrome  87.0.4280.88
#> 4          29.76499         -95.36156           EN        Chrome  87.0.4280.88
#> 5          40.33554         -75.92698           EN        Chrome 86.0.4240.198
#> 6          29.41433         -98.50342           EN          Edge   84.0.522.52
#> 7          40.69746         -74.02277           EN        Chrome  87.0.4280.88
#> 8          33.41401        -111.55062           EN       Firefox          83.0
#> 9          43.23353         -77.55959           EN        Chrome  87.0.4280.88
#> 10         39.95853         -75.15760           EN          Edge   84.0.522.52
#> 11         41.72026         -87.74872           EN       Firefox          84.0
#> 12         43.60660        -116.39702           EN        Chrome 84.0.4147.136
#> 13         33.87347        -117.92215           EN        Chrome  87.0.4280.88
#> 14         38.30621         -85.80354           EN        Chrome  87.0.4280.88
#> 15         39.94426         -75.17187           EN        Chrome  87.0.4280.88
#> 16         30.44958         -84.26941           EN        Chrome  87.0.4280.88
#> 17         36.87392         -89.59066           EN        Chrome 86.0.4240.199
#> 18         38.86740         -77.11789           EN        Chrome  87.0.4280.88
#> 19         42.91094         -87.86027           EN        Chrome  87.0.4280.88
#> 20         42.48020         -71.28746           EN        Chrome  87.0.4280.88
#> 21         37.28265        -120.50248           EN        Chrome  87.0.4280.88
#> 22         45.50412        -122.78665           EN        Chrome  87.0.4280.88
#> 23         43.07659         -89.41012           EN        Chrome  87.0.4280.88
#> 24         31.21322         -85.40050           EN        Chrome  87.0.4280.88
#> 25         39.02141         -87.72310           EN        Chrome  87.0.4280.88
#> 26         42.43382        -123.33358           EN       Firefox          84.0
#> 27         43.18294         -85.24739           EN        Chrome  88.0.4324.27
#> 28         43.36813        -124.21626           EN        Chrome  87.0.4280.88
#> 29         37.32957        -122.02562           EN          Edge   84.0.522.52
#> 30         37.32346        -122.03172           EN        Chrome  87.0.4280.88
#> 31         42.25303         -71.00212           EN        Chrome  87.0.4280.88
#> 32         40.33554         -75.92698           EN        Chrome  87.0.4280.88
#> 33         43.01740         -83.68259           EN        Chrome  87.0.4280.88
#> 34         42.71054         -73.74890           EN        Chrome  87.0.4280.88
#> 35         42.33122         -77.65774           EN        Chrome  87.0.4280.88
#> 36         34.04487        -118.25104           EN        Chrome 87.0.4280.109
#> 37         34.03605        -117.04066           EN          <NA>          <NA>
#> 38         28.56411         -81.54902           EN        Chrome  87.0.4280.88
#> 39         29.76568         -95.36087           EN        Chrome  87.0.4280.88
#> 40         34.77804         -84.96198           DE        Chrome  83.0.4103.61
#> 41         35.91814         -88.77264           EN        Chrome  87.0.4280.88
#> 42         33.66715        -117.82543           EN        Chrome  87.0.4280.88
#> 43         41.85443         -87.64565           EN        Chrome  87.0.4280.88
#> 44         34.50406         -82.64951           EN        Chrome  87.0.4280.88
#> 45         40.87077         -73.96697           EN        Chrome  87.0.4280.88
#> 46         34.08441        -117.44287           EN        Chrome  87.0.4280.88
#> 47               NA                NA           EN        Chrome  87.0.4280.88
#> 48         38.90370         -77.02778           EN        Chrome  87.0.4280.88
#> 49         48.85205         -95.75681           EN        Chrome  87.0.4280.88
#> 50         40.71187         -74.00837           EN Chrome iPhone  87.0.4280.77
#> 51         28.56411         -81.54902           EN        Chrome  87.0.4280.88
#> 52         39.61266         -86.10765           EN        Chrome  87.0.4280.88
#> 53         34.08953        -117.62469           EN        Chrome  87.0.4280.88
#> 54         45.51576        -122.68390           EN        Chrome  87.0.4280.88
#> 55         39.92034         -75.12523           EN        Chrome  87.0.4280.88
#> 56         40.35586         -74.68112           EN        Chrome  87.0.4280.88
#> 57         39.62145        -104.94657           EN        Chrome  87.0.4280.88
#> 58         45.50412        -122.78665           EN        Chrome  87.0.4280.88
#> 59         34.76243         -96.69044           EN        Chrome  87.0.4280.88
#> 60         30.22021         -92.02372           EN        Chrome  87.0.4280.88
#> 61         40.70961         -74.01063           EN        Chrome 87.0.4280.109
#> 62         39.26736         -76.79828           EN       Firefox          83.0
#> 63         44.31560         -69.77450           EN        Chrome  87.0.4280.88
#> 64         45.52602        -122.67364           EN          Edge   88.0.705.18
#> 65         33.67348        -111.94295           EN        Chrome  87.0.4280.88
#> 66         45.48118        -122.80960           EN        Chrome  87.0.4280.88
#> 67         36.16582        -115.14638           EN        Chrome  86.0.4240.75
#> 68         30.43275         -84.28624           EN        Chrome  87.0.4280.88
#> 69         41.85307         -87.64701           EN        Chrome  87.0.4280.88
#> 70         32.23909        -110.90913           EN          Edge   87.0.664.66
#> 71         41.10140         -73.96800           EN        Chrome  87.0.4280.88
#> 72         41.86902         -87.63458           EN        Chrome  87.0.4280.88
#> 73         35.39816         -78.81702           EN        Chrome  87.0.4280.88
#> 74         32.92666         -96.75124           EN        Chrome  87.0.4280.88
#> 75         37.28265        -120.50248           EN       Firefox          83.0
#> 76         39.46953         -87.41108           EN        Chrome  87.0.4280.88
#> 77         29.29882         -81.04289           EN       Firefox          81.0
#> 78         36.15678        -115.15541           EN        Chrome  87.0.4280.88
#> 79         35.92692         -88.76387           EN        Chrome 87.0.4280.101
#> 80         30.29587         -81.39196           EN        Chrome  87.0.4280.88
#> 81         39.27688         -76.62569           EN        Chrome  87.0.4280.88
#> 82         33.44272        -112.07971           EN       Firefox          83.0
#> 83         42.28207         -85.59687           EN        Chrome  87.0.4280.88
#> 84         39.63179         -79.95364           EN        Chrome  87.0.4280.88
#> 85         41.44980         -82.18540           EN        Chrome 87.0.4280.101
#> 86         35.47588         -97.50811           EN        Chrome  87.0.4280.88
#> 87         37.28265        -120.50248           EN          Edge   84.0.522.52
#> 88         35.22907         -80.84116           EN        Chrome  87.0.4280.88
#> 89         39.18626         -85.93656           EN        Chrome 86.0.4240.111
#> 90         45.50412        -122.78665           EN        Chrome  87.0.4280.88
#> 91         43.06228         -88.40227           EN        Chrome  87.0.4280.88
#> 92         40.39747         -79.81181           EN        Chrome  88.0.4324.41
#> 93         31.81687         -86.63048           EN       Firefox          84.0
#> 94         37.79058        -121.96737           EN        Chrome  87.0.4280.67
#> 95         39.29035         -76.61222           EN          Edge   84.0.522.52
#> 96         37.44174        -122.14316           EN        Chrome  87.0.4280.88
#> 97         38.34822         -81.63422           EN        Safari        14.0.1
#> 98         28.30875         -81.41260           EN        Chrome  87.0.4280.88
#>           Operating System Resolution
#> 1          Windows NT 10.0   1366x768
#> 2          Windows NT 10.0   1536x864
#> 3          Windows NT 10.0   1536x864
#> 4          Windows NT 10.0   1366x768
#> 5                Macintosh   1280x800
#> 6          Windows NT 10.0  1920x1080
#> 7          Windows NT 10.0   1440x900
#> 8          Windows NT 10.0   1440x900
#> 9          Windows NT 10.0   1600x900
#> 10         Windows NT 10.0  1680x1050
#> 11         Windows NT 10.0   1600x900
#> 12 CrOS armv7l 13099.110.0   1366x768
#> 13         Windows NT 10.0   1366x768
#> 14         Windows NT 10.0   1536x864
#> 15         Windows NT 10.0   1440x900
#> 16         Windows NT 10.0  1920x1080
#> 17 CrOS x86_64 13421.102.0   1138x640
#> 18         Windows NT 10.0   1536x864
#> 19               Macintosh   1440x900
#> 20         Windows NT 10.0  1920x1080
#> 21         Windows NT 10.0   1366x768
#> 22         Windows NT 10.0  1920x1080
#> 23         Windows NT 10.0   1366x768
#> 24         Windows NT 10.0   1600x900
#> 25         Windows NT 10.0   1366x768
#> 26                  Ubuntu   1280x800
#> 27         Windows NT 10.0  1901x1070
#> 28         Windows NT 10.0  1920x1080
#> 29         Windows NT 10.0  1920x1080
#> 30         Windows NT 10.0   1366x768
#> 31         Windows NT 10.0  1920x1080
#> 32          Windows NT 6.1   1366x768
#> 33         Windows NT 10.0   1360x768
#> 34         Windows NT 10.0  1920x1080
#> 35         Windows NT 10.0   1423x800
#> 36  CrOS x86_64 13505.73.0   1280x850
#> 37                    <NA>       <NA>
#> 38         Windows NT 10.0  1920x1080
#> 39         Windows NT 10.0  1920x1080
#> 40         Windows NT 10.0   1366x768
#> 41         Windows NT 10.0   1280x720
#> 42         Windows NT 10.0   1188x668
#> 43         Windows NT 10.0   1280x720
#> 44         Windows NT 10.0   1600x900
#> 45         Windows NT 10.0   1366x768
#> 46         Windows NT 10.0  1920x1080
#> 47         Windows NT 10.0   1536x864
#> 48         Windows NT 10.0  1920x1080
#> 49         Windows NT 10.0  1920x1080
#> 50                  iPhone    375x667
#> 51         Windows NT 10.0   1536x864
#> 52  CrOS x86_64 13505.63.0   1366x768
#> 53         Windows NT 10.0   1536x864
#> 54         Windows NT 10.0  1920x1080
#> 55  CrOS x86_64 13505.63.0   1366x768
#> 56         Windows NT 10.0   1536x864
#> 57          Windows NT 6.3  1920x1080
#> 58         Windows NT 10.0   1536x864
#> 59         Windows NT 10.0   1368x912
#> 60         Windows NT 10.0   1366x768
#> 61  CrOS x86_64 13505.73.0   1366x768
#> 62         Windows NT 10.0  2560x1440
#> 63         Windows NT 10.0   1366x768
#> 64         Windows NT 10.0   1360x768
#> 65         Windows NT 10.0   1280x720
#> 66         Windows NT 10.0   1366x768
#> 67         Windows NT 10.0   1536x864
#> 68         Windows NT 10.0  1920x1080
#> 69         Windows NT 10.0  2560x1440
#> 70         Windows NT 10.0  1920x1080
#> 71         Windows NT 10.0   1600x900
#> 72         Windows NT 10.0  1920x1080
#> 73               Macintosh   1280x800
#> 74         Windows NT 10.0   1280x720
#> 75         Windows NT 10.0   1440x960
#> 76         Windows NT 10.0  1280x1024
#> 77         Windows NT 10.0   1366x768
#> 78         Windows NT 10.0  1920x1080
#> 79              Android 10    360x740
#> 80         Windows NT 10.0   1536x864
#> 81  CrOS x86_64 13505.63.0   1366x768
#> 82         Windows NT 10.0  1920x1080
#> 83         Windows NT 10.0   1188x668
#> 84         Windows NT 10.0  1920x1080
#> 85               Android 9    360x740
#> 86  CrOS x86_64 13505.63.0   1366x768
#> 87         Windows NT 10.0  1920x1080
#> 88         Windows NT 10.0  2560x1440
#> 89         Windows NT 10.0  3440x1440
#> 90         Windows NT 10.0  1920x1080
#> 91         Windows NT 10.0   1366x768
#> 92         Windows NT 10.0   1366x768
#> 93                  Ubuntu   1280x800
#> 94               Macintosh   1280x800
#> 95         Windows NT 10.0   1536x864
#> 96         Windows NT 10.0   1366x768
#> 97               Macintosh   834x1194
#> 98            Linux x86_64  1920x1080

# Do not print rows to console
qualtrics_text %>%
  exclude_preview() %>%
  check_ip(print = FALSE)
#>  2 out of 100 preview rows were excluded, leaving 98 rows.
#>  4 out of 98 rows had IP address outside of US.

# Do not print message to console
qualtrics_text %>%
  exclude_preview() %>%
  check_ip(quiet = TRUE)
#>  2 out of 100 preview rows were excluded, leaving 98 rows.
#>             StartDate             EndDate     Status   IPAddress Progress
#> 1 2020-12-11 16:59:08 2020-12-11 17:02:05 IP Address 84.56.189.0      100
#> 2 2020-12-11 17:09:18 2020-12-11 17:16:57 IP Address 31.252.29.0      100
#> 3 2020-12-17 15:47:37 2020-12-17 15:51:33 IP Address 89.167.14.0      100
#> 4 2020-12-17 15:49:28 2020-12-17 15:55:06 IP Address  2.246.67.0       44
#>   Duration (in seconds) Finished        RecordedDate        ResponseId
#> 1                    54     TRUE 2020-12-11 17:02:05 R_2RQ5kfCKKHudpj3
#> 2                   229     TRUE 2020-12-11 17:16:57 R_XUU5qhep0Xe1GyW
#> 3                   297     TRUE 2020-12-17 15:51:33 R_bEHQBqkV97IcXfD
#> 4                   355    FALSE 2020-12-17 15:55:06 R_UfSQq1VXYkVcxdJ
#>   LocationLatitude LocationLongitude UserLanguage Browser      Version
#> 1         43.23353         -77.55959           EN  Chrome 87.0.4280.88
#> 2         33.87347        -117.92215           EN  Chrome 87.0.4280.88
#> 3         35.39816         -78.81702           EN  Chrome 87.0.4280.88
#> 4         37.79058        -121.96737           EN  Chrome 87.0.4280.67
#>   Operating System Resolution
#> 1  Windows NT 10.0   1600x900
#> 2  Windows NT 10.0   1366x768
#> 3        Macintosh   1280x800
#> 4        Macintosh   1280x800