--- a
+++ b/scripts/ctrpscrape.java
@@ -0,0 +1,68 @@
+import java.util.*;
+import java.io.*;
+import java.net.*;
+public class ctrpscrape {
+  public static void main(String[] args) throws Exception {
+    Scanner in = new Scanner(new File("fullctrpids.csv"));
+    PrintWriter out = new PrintWriter(new File("ctrpinds.csv"));
+    String useless = in.nextLine();
+    int count = 0;
+    while(in.hasNext()) {
+      System.out.println(count);
+      count++;
+      String id = in.nextLine();
+      String source = getURLSource("https://clinicaltrialsapi.cancer.gov/v1/clinical-trials?nct_id=" + id);
+      int index = source.indexOf("display_order");
+      if (index > 0) {
+        ArrayList<Integer> indices = new ArrayList<Integer>();
+        ArrayList<Integer> startinds = new ArrayList<Integer>();
+        ArrayList<Integer> endinds = new ArrayList<Integer>();
+        ArrayList<Integer> indinds = new ArrayList<Integer>();
+        while (index > 0) {
+          indices.add(index);
+          startinds.add(source.indexOf("description", index));
+          endinds.add(source.indexOf("}", index));
+          indinds.add(source.indexOf("inclusion_indicator", index));
+          index = source.indexOf("display_order", index+1);
+        }
+        ArrayList<String> strings = new ArrayList<String>();
+        ArrayList<Boolean> ind = new ArrayList<Boolean>();
+        for (int i = 0; i < startinds.size(); i++) strings.add(source.substring(startinds.get(i) + 14, endinds.get(i)-1).replaceAll("\"", "").replaceAll("\r\n", "").replaceAll("\n\r", ""));
+        for (int i = 0; i < indinds.size(); i++) {
+          if (source.charAt(indinds.get(i) + 21) == 't') ind.add(true);
+          else ind.add(false);
+        }
+        out.print(id + ",");
+        for (int i = 0; i < strings.size(); i++) {
+          out.print("\"" + strings.get(i) + "\"," + ind.get(i));
+          if (i < strings.size() - 1) out.print(",");
+        }
+        out.println();
+      }
+    }
+    in.close();
+    out.close();
+  }
+  public static String getURLSource(String url) throws IOException
+    {
+        URL urlObject = new URL(url);
+        URLConnection urlConnection = urlObject.openConnection();
+        urlConnection.setRequestProperty("User-Agent", "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.95 Safari/537.11");
+        try {
+        return toString(urlConnection.getInputStream());}catch(Exception e) {return "";}
+    }
+  private static String toString(InputStream inputStream) throws IOException
+    {
+        try (BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream, "UTF-8")))
+        {
+            String inputLine;
+            StringBuilder stringBuilder = new StringBuilder();
+            while ((inputLine = bufferedReader.readLine()) != null)
+            {
+                stringBuilder.append(inputLine);
+            }
+
+            return stringBuilder.toString();
+        }
+    }
+}