import urllib
import json
import pandas as pd

# read in json
url = 'https://www.nwfsc.noaa.gov/data/api/v1/source/trawl.catch_fact/selection.json?filters=' + \
      'field_identified_taxonomy_dim$scientific_name=Eopsetta%20jordani,date_dim$year>=2010,' + \
      'date_dim$year<=2012&variables=date_dim$yyyymmdd,field_identified_taxonomy_dim$scientific_name'
api_response = urllib.urlopen(url)
json_file = json.loads(api_response.read())

pd.DataFrame(json_file)

	date_dim$yyyymmdd	field_identified_taxonomy_dim$scientific_name
0	20120526	Eopsetta jordani
1	20100824	Eopsetta jordani
2	20120526	Eopsetta jordani
3	20110823	Eopsetta jordani
4	20120526	Eopsetta jordani
5	20120821	Eopsetta jordani
6	20100527	Eopsetta jordani
7	20110523	Eopsetta jordani
8	20110524	Eopsetta jordani
9	20120821	Eopsetta jordani
10	20110825	Eopsetta jordani
11	20110825	Eopsetta jordani
12	20100527	Eopsetta jordani
13	20120527	Eopsetta jordani
14	20100825	Eopsetta jordani
15	20110524	Eopsetta jordani
16	20120822	Eopsetta jordani
17	20110524	Eopsetta jordani
18	20100527	Eopsetta jordani
19	20110824	Eopsetta jordani
20	20120526	Eopsetta jordani
21	20110823	Eopsetta jordani
22	20100527	Eopsetta jordani
23	20110825	Eopsetta jordani
24	20120822	Eopsetta jordani
25	20100526	Eopsetta jordani
26	20110822	Eopsetta jordani
27	20110523	Eopsetta jordani
28	20120822	Eopsetta jordani
29	20110523	Eopsetta jordani
...	...	...
981	20110711	Eopsetta jordani
982	20110711	Eopsetta jordani
983	20110717	Eopsetta jordani
984	20110717	Eopsetta jordani
985	20100713	Eopsetta jordani
986	20110711	Eopsetta jordani
987	20110711	Eopsetta jordani
988	20101017	Eopsetta jordani
989	20110717	Eopsetta jordani
990	20121009	Eopsetta jordani
991	20101012	Eopsetta jordani
992	20121010	Eopsetta jordani
993	20120712	Eopsetta jordani
994	20101012	Eopsetta jordani
995	20100712	Eopsetta jordani
996	20100719	Eopsetta jordani
997	20121016	Eopsetta jordani
998	20121012	Eopsetta jordani
999	20121013	Eopsetta jordani
1000	20111012	Eopsetta jordani
1001	20111013	Eopsetta jordani
1002	20121015	Eopsetta jordani
1003	20100717	Eopsetta jordani
1004	20110716	Eopsetta jordani
1005	20100717	Eopsetta jordani
1006	20111012	Eopsetta jordani
1007	20100716	Eopsetta jordani
1008	20110715	Eopsetta jordani
1009	20101014	Eopsetta jordani
1010	20111014	Eopsetta jordani