title: How should I be reading Census API data into R
body: <p>I am working to read Census data into R using the agency's API, but I'm struggling to get it to read in the right format.</p>
  <p>The URL that I'm trying to read in: <a href="https://api.census.gov/data/timeseries/eits/mwts?get=data_type_code,time_slot_id,seasonally_adj,category_code,cell_value,error_data&amp;time=2012" rel="nofollow noreferrer">https://api.census.gov/data/timeseries/eits/mwts?get=data_type_code,time_slot_id,seasonally_adj,category_code,cell_value,error_data&amp;time=2012</a></p>
  <p>And the format of that data if you just look at it in the web browser:</p>
  <p><a href="https://i.stack.imgur.com/rw4T9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rw4T9.png" alt="enter image description here" /></a></p>
  <p>The closest I've gotten is with this series of code:</p>
  <pre><code>library(jsonlite)
  data &lt;- url(&quot;https://api.census.gov/data/timeseries/eits/mwts? get=data_type_code,time_slot_id,seasonally_adj,category_code,cell_value,error_data&amp;time=2012&quot;)
      
      
  datanew &lt;- fromJSON(data)
  </code></pre>
  <p>But as you can see that's still not in a good dataframe format.</p>
  <p><a href="https://i.stack.imgur.com/73iTT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/73iTT.png" alt="enter image description here" /></a></p>
  <p>Is there an easier way that I'm missing? Thanks.</p>